Contact
Module: Customer Insights
Type: Dimension
ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | True | Record Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| EMAIL_HAS_HARD_BOUNCED | NUMBER | 1 | 0 | Email Has Hard Bounced | |||
| HAS_EMAIL_ADDRESS | NUMBER | 1 | 0 | Has Email Address | |||
| HAS_PHONE_NUMBER | NUMBER | 1 | 0 | Has Phone Number | |||
| HAS_PHONE_SMS | NUMBER | 1 | 0 | Has SMS Phone Number | |||
| HAS_PHONE_VOICE | NUMBER | 1 | 0 | Has Voice Phone Number | |||
| HAS_PUSH | NUMBER | 1 | 0 | Has Push Notifications | |||
| LOCALE_CODE | VARCHAR2 | 6 | Locale Code | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |