Snowflake VM Object: Comments
- ► Comments
-
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 COMMENT_NO NUMBER the comment_no for the referenced record ACCOUNT_NO NUMBER The account number related to the customer referenced USERID TEXT The userid for login related to the customer referenced APPLICATION_ID TEXT the application_id for the referenced record APPLICATION_TSTAMP_TEXT TEXT the application_tstamp_text for the referenced record AUTHOR TEXT the author for the referenced record COMMENTS TEXT The detailed comments related to the referenced data CREATED_TSTAMP TIMESTAMP_NTZ The original source system created 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