Snowflake VM Object: Plan Unit Instances
- ► Plan Unit Instances
-
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 PLAN_UNIT_INSTANCE_NO NUMBER the plan_unit_instance_no for the referenced record CLIENT_PLAN_UNIT_INSTANCE_ID TEXT the client_plan_unit_instance_id for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for a plan_instance CLIENT_PLAN_INSTANCE_ID TEXT The occurrence (instance) of a plan for the referenced data PRODUCT_FIELDS VARIANT An embedded one to many JSON subrecord related to product fields SERVICES VARIANT An embedded one to many JSON subrecord related to services PLAN_UNIT_INSTANCE_STATUS_NO NUMBER the plan_unit_instance_status_no 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 Child Views Variant
Source Table
Child View Name
PRODUCT_FIELDS PLAN_UNIT_INSTANCES VM_PUI_PF_VALUES PRODUCT_FIELDS PLAN_UNIT_INSTANCES VM_PUI_PRODUCT_FIELDS SERVICES PLAN_UNIT_INSTANCES VM_PUI_SERVICES