Module: Customer Analytics
Type: Dimension
SP_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SP_ID | VARCHAR2 | 10 | True | Service Point | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| ABOLISH_DT | DATE | 0 | Out of Service Date | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| FAC_LVL_1_CD | VARCHAR2 | 38 | Facility Level 1 | ||||
| FAC_LVL_2_CD | VARCHAR2 | 38 | Facility Level 2 | ||||
| FAC_LVL_3_CD | VARCHAR2 | 38 | Facility Level 3 | ||||
| INSTALL_DT | DATE | 0 | Install Date | ||||
| KEY_ID | VARCHAR2 | 38 | Key ID | ||||
| KEY_SW | VARCHAR2 | 1 | Key | ||||
| MR_CYC_RTE_SEQ | NUMBER | 8 | 0 | Service Cycle/Route Sequence | |||
| MR_INSTR_CD | VARCHAR2 | 38 | Meter Read Instruction | ||||
| MR_INSTR_DETAILS | VARCHAR2 | 250 | Instruction Details | ||||
| MR_WARN_CD | VARCHAR2 | 38 | Meter Read Warning | ||||
| MTR_LOC_DETAILS | VARCHAR2 | 4000 | Location Details | ||||
| OK_TO_ENTER_SW | VARCHAR2 | 1 | OK to Enter | ||||
| OVRD_PREM_FLD_INFO_FLG | VARCHAR2 | 4 | Override Premise Field Information | ||||
| SP_SRC_STATUS_FLG | VARCHAR2 | 38 | Service Point Source Status | ||||
| SP_STATUS_FLG | VARCHAR2 | 2 | Service Point Status | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |