Module: Device Analytics
Type: Dimension
D1_USAGE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_USAGE_ID | VARCHAR2 | 14 | True | Usage Transaction | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| LINKED_TO_FRZN_BSEG_FLG | VARCHAR2 | 38 | Linked to Frozen Bill Segment | ||||
| ORG_USAGE_ID | VARCHAR2 | 38 | Original Usage ID | ||||
| REL_ORDER | NUMBER | 3 | 0 | Relative Order | |||
| SCH_SELECTION_DT | DATE | 0 | Scheduled Selection Date | ||||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| TOT_USG_TRANS_CNT | NUMBER | 3 | 0 | Total Usage Transaction Count | |||
| USED_ON_BILL_FLG | VARCHAR2 | 38 | Used on Bill | ||||
| USG_EXT_ID | VARCHAR2 | 60 | Usage External ID | ||||
| USG_SRC_FLG | VARCHAR2 | 38 | Usage Source | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |