Module: Work Asset Analytics
Type: Dimension
WORK_DESIGN_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| WORK_DESIGN_ID | VARCHAR2 | 12 | True | Work Design | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| APPROVAL_DTTM | TIMESTAMP | 0 | 6 | Approval Date/Time | |||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| DESIGNED_BY | VARCHAR2 | 254 | Designed By | ||||
| DESIGN_NUM | VARCHAR2 | 14 | Work Design Number | ||||
| DESIGN_VERSION | NUMBER | 5 | 0 | Work Design Version | |||
| EXPIRATION_DT | DATE | 0 | Expiration Date | ||||
| OVERHEAD_CD | VARCHAR2 | 30 | Overhead | ||||
| PHASE_WD_FLG | VARCHAR2 | 4 | Phase | ||||
| PLANNER_CD | VARCHAR2 | 30 | Planner | ||||
| PLANNER_STATUS_CD | VARCHAR2 | 12 | Planner Status | ||||
| PRIORITY_FLG | VARCHAR2 | 4 | Priority | ||||
| REQUIRED_DT | DATE | 0 | Required Date | ||||
| W1_PERCENTAGE | NUMBER | 8 | 5 | Percentage | |||
| WORK_DESIGN_TYPE_FLG | VARCHAR2 | 4 | Work Design Type | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |