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

Contnet 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