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