Module: Digital Asset Analytics
Type: Dimension
A1_PRG_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_PRG_ID | VARCHAR2 | 12 | True | Program | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 30 | Status Reason | ||||
| BUS_OBJ_CD | VARCHAR2 | 30 | Business Object | ||||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| D1_APPROVAL_PROF_CD | VARCHAR2 | 38 | Approval Profile | ||||
| D1_INITIATIVE_CD | VARCHAR2 | 38 | Initiative | ||||
| DIVISION_CD | VARCHAR2 | 38 | Division | ||||
| END_DT | DATE | 0 | End Date | ||||
| EXT_DYN_OPT_ID_VALUE | VARCHAR2 | 120 | External Dynamic Option Identifier | ||||
| QUANTITY | NUMBER | 16 | 6 | Quantity | |||
| START_DT | DATE | 0 | Start Date | ||||
| STATUS_UPD_DTTM | TIMESTAMP | 0 | 6 | Status Date/Time | |||
| SUSPEND_FLG | VARCHAR2 | 38 | Suspend | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |