Module: Digital Asset Analytics
Type: Dimension
D1_SP_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_SP_ID | VARCHAR2 | 12 | True | MDM Service Point | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ADDRESS1 | VARCHAR2 | 254 | Address | ||||
| ADDRESS1_UPPER | VARCHAR2 | 254 | Address Line 1 Upper Case | ||||
| ADDRESS2 | VARCHAR2 | 254 | Address 2 | ||||
| ADDRESS3 | VARCHAR2 | 254 | Address 3 | ||||
| ADDRESS4 | VARCHAR2 | 254 | Address 4 | ||||
| CITY | VARCHAR2 | 90 | City | ||||
| CITY_UPPER | VARCHAR2 | 90 | City Upper Case | ||||
| COUNTRY | VARCHAR2 | 3 | Country | ||||
| COUNTY | VARCHAR2 | 90 | County | ||||
| D1_GEO_LAT | NUMBER | 15 | 6 | Geographic Latitude | |||
| D1_GEO_LONG | NUMBER | 15 | 6 | Geographic Longitude | |||
| D1_LS_SL_DESCR | VARCHAR2 | 4000 | Description | ||||
| D1_LS_SL_FLG | VARCHAR2 | 4 | Life Support / Sensitive Load | ||||
| D1_SP_TYPE_CD | VARCHAR2 | 30 | Service Point Type | ||||
| DISCONN_LOC_FLG | VARCHAR2 | 4 | Disconnect Location | ||||
| DIVISION_CD | VARCHAR2 | 30 | Division | ||||
| GEO_CODE | VARCHAR2 | 11 | Geographical Code | ||||
| HOUSE_TYPE | VARCHAR2 | 2 | House Type | ||||
| IN_CITY_LIMIT | VARCHAR2 | 1 | In City Limit | ||||
| MKT_CD | VARCHAR2 | 30 | Market | ||||
| MSRMT_CYC_CD | VARCHAR2 | 30 | Measurement Cycle | ||||
| MSRMT_CYC_RTE_SEQ | NUMBER | 9 | 0 | Sequence | |||
| NUM1 | VARCHAR2 | 6 | Number 1 | ||||
| NUM2 | VARCHAR2 | 4 | Number 2 | ||||
| PARENT_SP_IND_FLG | VARCHAR2 | 4 | Parent Service Point | ||||
| POSTAL | VARCHAR2 | 12 | Postal | ||||
| SP_CATEGORY_FLG | VARCHAR2 | 4 | Service Point Category | ||||
| SP_SRC_STAT_FLG | VARCHAR2 | 4 | Source Status | ||||
| STATE | VARCHAR2 | 6 | State | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |