Skip to main content
Aria Knowledge Central

Snowflake VM Object: Contacts

► Contacts

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
CONTACT_NO NUMBER the contact_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
CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced
FIRST_NAME TEXT The first name of the person referenced in the data
MIDDLE_INITIAL TEXT The middle initial of the person referenced in the data
LAST_NAME TEXT The last name of the person referenced in the data
COMPANY_NAME TEXT The legal company name of the entity referenced in the data
STREET VARIANT The contacts street address.
CITY TEXT The city address of the referenced data
LOCALITY TEXT the locality for the referenced record
STATE_PROV TEXT The state or province address of the referenced data
COUNTRY_CD TEXT The ISO country code of the address of the referenced data
POSTAL_CODE TEXT The postal code of the address of the referenced data
PHONE TEXT The phone number of the referenced data
PHONE_EXT TEXT The phone numbers extension of the referenced data
CELL_PHONE TEXT The cellular phone number of the referenced data
WORK_PHONE TEXT The work phone number of the referenced data
WORK_PHONE_EXT TEXT The work phone numbers extension of the referenced data
FAX TEXT The fax number of the referenced data
EMAIL TEXT The email of the referenced person or entity
BIRTHDATE DATE The birthdate of the referenced person
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
Child Views

Variant

Source Table

Child View Name

STREET CONTACTS  
  • Was this article helpful?