Snowflake VM Object: Plan Relationships
- ► Plan Relationships
-
Field
Datatype
Description
CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client IS_DELETED BOOLEAN Denotes a True/False as to if the referenced data has been deleted via soft delete REF_PK TEXT REF_PK The PK of the ref_type concatenated with a pipe as needed within the JSON PARENT_PLAN_NO NUMBER the parent_plan_no for the referenced record CHILD_PLAN_NO NUMBER the child_plan_no for the referenced record PARENT_CLIENT_PLAN_ID TEXT the parent_client_plan_id for the referenced record CHILD_CLIENT_PLAN_ID TEXT the child_client_plan_id for the referenced record HAS_ACCOUNT_LIMITS BOOLEAN the has_account_limits for the referenced record IS_DEFAULT BOOLEAN A True or False indicator showing if the record is the default IS_REQUIRED BOOLEAN A True or False indicator showing if the record is mandatory MAXIMUM_UNITS NUMBER the maximum_units for the referenced record MINIMUM_UNITS NUMBER the minimum_units for the referenced record CREATED_BATCH_ID NUMBER The aria facing creation batch id assigned upon landing for the referenced data CREATED_BATCH_TSTAMP TIMESTAMP_NTZ The aria facing batch timstamp assigned upon landing for the referenced data, showing its creation in snowflake UPDATED_BATCH_ID NUMBER The aria facing update batch id assigned upon landing for the referenced data UPDATED_BATCH_TSTAMP TIMESTAMP_NTZ The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake