Snowflake VM Object: Plan Instance Coupon Assignments
- ► Plan Instance Coupon Assignments
-
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_INSTANCE_NO NUMBER The Aria facing unique identifier for a plan_instance COUPON_CODE TEXT The aria facing unique identifier code for a coupon CLIENT_PLAN_INSTANCE_ID TEXT The occurrence (instance) of a plan for the referenced data CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data CANCELLED_TSTAMP TIMESTAMP_NTZ The original source system cancelled timestamp for the referenced data 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