Program Subscription / Service Point / Event
Module: Digital Asset Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_D1_SP_ID | VARCHAR2 | 38 | Digital Asset Service Point | DW_EWDA_X_EWDI_DACS_D1_SP_D | D1_SP_ID | ||
| A1_PRG_EVENT_ID | VARCHAR2 | 14 | Program Event | DW_EWDA_X_EWDI_DACS_D1_DYN_OPT_PRG_EVT_D | A1_PRG_EVENT_ID | ||
| A1_PRG_SUB_ID | VARCHAR2 | 12 | Program Subscription ID | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 66 | Source Record Id | ||||
| A1_ASSET_ID | VARCHAR2 | 120 | Digital Asset | DW_EWDA_X_EWDI_DACS_W1_ASSET_D | ASSET_ID | ||
| A1_D1_SPR_CD | VARCHAR2 | 38 | Digital Asset Service Provider | DW_EWDA_X_EWDI_DACS_D1_SPR_D | D1_SPR_CD | ||
| A1_EVENT | VARCHAR2 | 120 | Event | DW_EWDA_X_EWDI_DACS_D1_DYN_OPT_EVT_D | A1_EVENT | ||
| A1_EVT_HOUR1_REDUCTION | NUMBER | Event Hour 1 Reduction | |||||
| A1_EVT_HOUR2_REDUCTION | NUMBER | Event Hour 2 Reduction | |||||
| A1_EVT_HOUR3_REDUCTION | NUMBER | Event Hour 3 Reduction | |||||
| A1_EVT_HOUR4_REDUCTION | NUMBER | Event Hour 4 Reduction | |||||
| A1_EVT_HOUR5_REDUCTION | NUMBER | Event Hour 5 Reduction | |||||
| A1_EVT_HOUR6_REDUCTION | NUMBER | Event Hour 6 Reduction | |||||
| A1_HOUR1_REDUCTION | NUMBER | Hour 1 Reduction | |||||
| A1_HOUR2_REDUCTION | NUMBER | Hour 2 Reduction | |||||
| A1_HOUR3_REDUCTION | NUMBER | Hour 3 Reduction | |||||
| A1_HOUR4_REDUCTION | NUMBER | Hour 4 Reduction | |||||
| A1_HOUR5_REDUCTION | NUMBER | Hour 5 Reduction | |||||
| A1_HOUR6_REDUCTION | NUMBER | Hour 6 Reduction | |||||
| A1_PAR_DURATION | NUMBER | 38 | 2 | Duration of Participation | |||
| A1_PRG_ID | VARCHAR2 | 12 | Program | DW_EWDA_X_EWDI_DACS_D1_DYN_OPT_D | A1_PRG_ID | ||
| A1_PRG_TYPE_CD | VARCHAR2 | 30 | Program Type | DW_EWDA_X_EWDI_DACS_D1_DYN_OPT_TYPE_D | A1_PRG_TYPE_CD | ||
| A1_SUCCESS_COUNT | NUMBER | Successful Participation Count | |||||
| A1_UOM_CD | VARCHAR2 | 50 | Digital Asset Unit of Measure | DW_EWDA_X_EWDI_DACS_CI_UOM_D | UOM_CD | ||
| ACCT_ID | VARCHAR2 | 120 | Account | ||||
| DEVICE_COUNT | NUMBER | Device Count | |||||
| FACT_COUNT | NUMBER | 38 | 0 | Fact Count | |||
| NON_RESPONSIVE_COUNT | NUMBER | Non Responsive Count | |||||
| NON_RESPONSIVE_INDICATOR | NUMBER | 38 | 0 | Non Responsive Indicator | |||
| OPT_OUT_COUNT | NUMBER | Opt Out Count | |||||
| OPT_OUT_INDICATOR | NUMBER | 38 | 0 | Opt Out Indicator | |||
| OVERRIDE_COUNT | NUMBER | Override Count | |||||
| OVERRIDE_INDICATOR | NUMBER | 38 | 0 | Override Indicator | |||
| PARTICIPATION_END_DT | NUMBER | 38 | 0 | Participation End Date | |||
| PARTICIPATION_END_TM | NUMBER | 38 | 0 | Participation End Time | |||
| PARTICIPATION_START_DT | NUMBER | 38 | 0 | Participation Start Date | |||
| PARTICIPATION_START_TM | NUMBER | 38 | 0 | Participation Start Time | |||
| RESERVATION_INDICATOR | NUMBER | 38 | 0 | Reservation Indicator | |||
| SUCCESS_INDICATOR | NUMBER | 38 | 0 | Success Indicator | |||
| TOTAL_REDUCTION | NUMBER | Total Reduction | |||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |