Skip to main content
Aria Knowledge Central

Snowflake VM Object: Usage Types

► Usage Types

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
USAGE_TYPE_NO NUMBER the usage_type_no for the referenced record
USAGE_TYPE_CD TEXT the usage_type_cd for the referenced record
DESCRIPTION TEXT The detailed description related to the referenced data
DISPLAY_NAME TEXT the display_name for the referenced record
LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale
NAME TEXT the name for the referenced record
PRODUCT_FIELD_ASSIGNMENTS VARIANT An embedded one to many JSON subrecord related to product field assignments
USAGE_UNIT_TYPE_NO NUMBER the usage_unit_type_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

LOCALE_DETAILS USAGE_TYPES VM_UT_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS USAGE_TYPES VM_UT_PFA_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS USAGE_TYPES VM_UT_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS USAGE_TYPES VM_UT_PRODUCT_FIELD_ASSIGNMENTS
  • Was this article helpful?