Household Location
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 | ||||
| ADMIN_AREA_1 | VARCHAR2 | 40 | State | ||||
| LOCALITY | VARCHAR2 | 65 | City | ||||
| POSTAL_CODE | VARCHAR2 | 20 | Postal code | ||||
| POSTAL_CODE_LAT | NUMBER | 9 | 6 | Postal code latitude | |||
| POSTAL_CODE_LONG | NUMBER | 9 | 6 | Postal code longitude | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |