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