Usage Subscription - Service Point
Module: Device Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_SP_ID | VARCHAR2 | 12 | MDM Service Point | DW_EWB_X_EWDI_BASE_D1_SP_D | D1_SP_ID | ||
| START_DT | DATE | 0 | Start Date | ||||
| START_TM | NUMBER | 38 | 0 | Start Time | |||
| US_ID | VARCHAR2 | 12 | Usage Subscription | DW_EWB_X_EWDI_BASE_D1_US_D | US_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 85 | Source Record Id | ||||
| D1_STOP_DT | NUMBER | 38 | 0 | End Date | |||
| D1_STOP_TM | NUMBER | 38 | 0 | End Time | |||
| D1_USAGE_FLG | VARCHAR2 | 4 | Usage | ||||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| USE_PERCENT | NUMBER | 5 | 2 | Use Percent | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |