Module: Common
Type: Dimension
D1_DEVICE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_DEVICE_ID | VARCHAR2 | 12 | True | Device | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ARMING_REQ_FLG | VARCHAR2 | 4 | Arming Required | ||||
| ATTACHED_TO_FLG | VARCHAR2 | 4 | Attached To | ||||
| BADGE_NUMBER | VARCHAR2 | 120 | Badge Number | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| CONSUMPTION_SOURCE_FLG | VARCHAR2 | 4 | Consumption Source | ||||
| D1_CMD_SET_CD | VARCHAR2 | 30 | Command Set | ||||
| D1_SPR_CD | VARCHAR2 | 30 | Service Provider | ||||
| DEVICE_TYPE_CD | VARCHAR2 | 30 | Device Type | ||||
| DVC_CLASS_FLG | VARCHAR2 | 4 | Device Classification | ||||
| DVC_SUB_CLASS_FLG | VARCHAR2 | 4 | Device Sub Classification | ||||
| HEAD_END_REGISTR_STATUS_FLG | VARCHAR2 | 4 | Head-End Registration Status | ||||
| IN_DATA_SHIFT_FLG | VARCHAR2 | 4 | Incoming Data Shift | ||||
| MANUFACTURER_CD | VARCHAR2 | 30 | Manufacturer | ||||
| PROD_EXT_ID | VARCHAR2 | 60 | Our Name/ID in Their System | ||||
| SERIAL_NUMBER | VARCHAR2 | 120 | Serial Number | ||||
| SPR_EXT_REF_ID | VARCHAR2 | 60 | External Reference ID | ||||
| SPR_TYPE_FLG | VARCHAR2 | 4 | Service Provider Type | ||||
| TRACK_LOCATION_FLG | VARCHAR2 | 4 | Track Location | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |