DIM_CONTACTS
This table stores the contact entities. Users can use the information stored in these entities to identify the contact person for more information regarding a specific request. Contacts are either created by the customer or seeded as part of the installation.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
DIM_PERSON |
PERSON _ID |
PK_PERSON_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
SCD2 |
---|---|---|---|---|
PK_CONTACTS_ID |
Not Null |
INT |
System-generated identifier |
No |
MD_BUSINESS_KEY |
Not Null |
VARCHAR(1000) |
Primary key that is mapped to one or more source columns
|
No |
MD_ENTERPRISE_KEY |
Not Null |
INT |
Unique identifier for entity |
No |
PERSON_ID |
Nullable |
INT |
Unique identifier for the person associated with this contact |
No |
PERSON_BUSINESS_ KEY |
Nullable |
VARCHAR(1000) |
Foreign key that is mapped to DIM_PERSON
|
No |
PERSON_ENTERPRISE_ KEY |
Nullable |
INT |
Unique identifier for foreign key
|
No |
FIRST_NAME |
Not Null |
VARCHAR(80) |
Contact’s first name |
No |
LAST_NAME |
Not Null |
VARCHAR(80) |
Contact’s last name |
No |
FULL_NAME |
Not Null |
VARCHAR(200) |
Contact’s full name |
No |
PHONE_NUMBER |
Nullable |
VARCHAR(30) |
Contact’s phone number |
No |
EMAIL_ADDRESS |
Nullable |
VARCHAR(80) |
Contact’s email address |
No |
ENABLED_FLAG |
Not Null |
VARCHAR(1) |
Indicates whether this contact is available for use |
Yes |
USER_DATA_SET_ CONTEXT_ID |
Nullable |
INT |
Parameter set context identifier for the user data fields |
Yes |
USER_DATA1-20 |
Nullable |
VARCHAR(200) |
User data segment |
No |
VISIBLE_USER_DATA1-20 |
Nullable |
VARCHAR(200) |
User data segment |
No |
COMPANY |
Nullable |
VARCHAR(30) |
Contact person's company |
Yes |
MD_BATCH_ID |
Nullable |
INT |
ID of data batch |
No |
MD_PROCESS_ID |
Nullable |
INT |
ID of ETL process running on a specific task |
No |
MD_SOURCE_ INSTANCE_ID |
Nullable |
INT |
Content pack ID of source instance |
No |
MD_CREATEDDATE |
Nullable |
DATETIME |
Date of the record being inserted |
No |
MD_DELETEDDATE |
Nullable |
DATETIME |
Date of the record being deleted |
No |
MD_LASTMODDATE |
Nullable |
DATETIME |
Date of the record being updated |
No |
MD_TRANSLASTIND |
Nullable |
VARCHAR(1) |
Flags whether it is the latest record after updated by SCD2 |
No |
MD_TRANSENDDATE |
Nullable |
DATETIME |
End date of the record being effective |
No |
MD_ACTIVESTATUSIND |
Nullable |
VARCHAR(1) |
Flags whether or not the old record is deleted |
No |
MD_HASH_CODE_SCD1 |
Nullable |
VARCHAR(40) |
(Only for dimension table) Hash code that is generated by SCD1 columns |
No |
MD_HASH_CODE_SCD2 |
Nullable |
VARCHAR(40) |
(Only for dimension table) Hash code that is generated by SCD2 columns |
No |
Projections
This table uses no projections.
Sequences
Sequence Name |
Sequence Type |
---|---|
CONTACTS_ENTERPRISE_XREF_SEQ |
MD_ENTERPRISE_KEY |
CONTACTS_KEY_LOOKUP_SEQ |
PK_CONTACTS_ID |