Module: Work Asset Analytics
Type: Dimension
WO_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| WO_ID | VARCHAR2 | 14 | True | Work Order | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCOUNT_SEGMENT | VARCHAR2 | 254 | Account Segment | ||||
| ACT_END_DT | DATE | 0 | End Date | ||||
| ACT_START_DT | DATE | 0 | Start Date | ||||
| ALLOW_CHARGE_FLG | VARCHAR2 | 4 | Allow Charge | ||||
| BUDGET_AMT | NUMBER | 17 | 3 | Budget Amount | |||
| CONSTR_RELATED_FLG | VARCHAR2 | 4 | Construction Related | ||||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| EMERGENCY_FLG | VARCHAR2 | 4 | Emergency | ||||
| EST_END_DT | DATE | 0 | Estimated End Date | ||||
| EST_START_DT | DATE | 0 | Estimated Start Date | ||||
| FINISH_DTTM | TIMESTAMP | 0 | 6 | Finish Date/Time | |||
| PRJ_ID | VARCHAR2 | 12 | Project | ||||
| PRJ_NUM | VARCHAR2 | 14 | Project Number | ||||
| PRJ_STATUS_CD | VARCHAR2 | 12 | Project Status | ||||
| PROJECT_DESCR100 | VARCHAR2 | 100 | Project Description | ||||
| PROJECT_DESCRLONG | VARCHAR2 | 4000 | Project Detailed Description | ||||
| REQUIRED_BY_DT | DATE | 0 | Required By Date | ||||
| TEMPLATE_NAME | VARCHAR2 | 30 | Template Name | ||||
| WORK_PRIORITY_FLG | VARCHAR2 | 4 | Work Priority | ||||
| WORK_REQ_ID | VARCHAR2 | 14 | Work Request | ||||
| WORK_TYPE_FLG | VARCHAR2 | 4 | Work Type | ||||
| WO_NUM | VARCHAR2 | 14 | Work Order Number | ||||
| WO_STATUS_CD | VARCHAR2 | 12 | Work Order Status | ||||
| WO_WORK_CATEGORY_CD | VARCHAR2 | 30 | Work Category - WO | ||||
| WO_WORK_CLASS_CD | VARCHAR2 | 30 | Work Class - WO | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |