Program Subscription
Module: Digital Asset Analytics
Type: Fact
A1_PRG_SUB_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_PRG_SUB_ID | VARCHAR2 | 12 | True | Program Subscription ID | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| A1_ASSET_ID | VARCHAR2 | 120 | Digital Asset | DW_EWDA_X_EWDI_DACS_W1_ASSET_D | ASSET_ID | ||
| A1_CAPACITY | NUMBER | 16 | 6 | Capacity | |||
| A1_D1_SPR_CD | VARCHAR2 | 38 | Digital Asset Service Provider | DW_EWDA_X_EWDI_DACS_D1_SPR_D | D1_SPR_CD | ||
| A1_D1_SP_ID | VARCHAR2 | 38 | Digital Asset Service Point | DW_EWDA_X_EWDI_DACS_D1_SP_D | D1_SP_ID | ||
| A1_PRG_ID | VARCHAR2 | 38 | Program | DW_EWDA_X_EWDI_DACS_D1_DYN_OPT_D | A1_PRG_ID | ||
| A1_PRG_SUB_STATUS | VARCHAR2 | 8 | Program Subscription Status | ||||
| A1_PRG_SUB_TYPE_CD | VARCHAR2 | 30 | Program Subscription Type | DW_EWDA_X_EWDI_DACS_D1_US_TYPE_D | US_TYPE_CD | ||
| A1_PRG_TYPE_CD | VARCHAR2 | 38 | Program Type | DW_EWDA_X_EWDI_DACS_D1_DYN_OPT_TYPE_D | A1_PRG_TYPE_CD | ||
| A1_RS_CD | VARCHAR2 | 254 | Digital Asset Rate | DW_EWDA_X_EWDI_DACS_CI_RS_D | RATE_SCHEDULE_CD | ||
| 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 | ||||
| CANCELED_COUNT | NUMBER | 38 | 0 | Canceled Count | |||
| DEVICE_COUNT | NUMBER | Device Count | |||||
| END_DT | NUMBER | 38 | 0 | End Date | |||
| END_TM | NUMBER | 38 | 0 | End Time | |||
| ENROLLED_COUNT | NUMBER | 38 | 0 | Enrolled Count | |||
| FACT_COUNT | NUMBER | 38 | 0 | Fact Count | |||
| START_DT | NUMBER | 38 | 0 | Start Date | |||
| START_TM | NUMBER | 38 | 0 | Start Time | |||
| UNENROLLED_COUNT | NUMBER | 38 | 0 | Unenrolled Count | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |