Module: Customer Analytics
Type: Dimension
C1_CONTACT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| C1_CONTACT_ID | VARCHAR2 | 10 | True | Person Contact | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| CND_ACTINACT_FLG | VARCHAR2 | 38 | Active/Inactive | ||||
| CND_PRIMARY_FLG | VARCHAR2 | 38 | Primary | ||||
| CND_VERIF_STATUS_FLG | VARCHAR2 | 38 | Contact Status | ||||
| CONTACT_NAME | VARCHAR2 | 100 | Contact Nickname | ||||
| CONTACT_VALUE | VARCHAR2 | 254 | Contact Information | ||||
| CONTACT_VALUE_EXT | VARCHAR2 | 38 | Extension | ||||
| DND_END_TM | TIMESTAMP | 0 | 6 | Do Not Disturb (To) | |||
| DND_START_TM | TIMESTAMP | 0 | 6 | Do Not Disturb (From) | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |