Module: Work Asset Analytics
Type: Dimension
MAINT_TRIGGER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| MAINT_TRIGGER_ID | VARCHAR2 | 12 | True | Maintenance Trigger | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| BACK_LOG_GRP_FLG | VARCHAR2 | 38 | Backlog Group | ||||
| BO_STATUS_CD | VARCHAR2 | 38 | Status | ||||
| COMMENTS | VARCHAR2 | 254 | Comments | ||||
| F1_DAYS | NUMBER | 9 | 0 | Days | |||
| F1_MONTHS | NUMBER | 9 | 0 | Months | |||
| F1_YEARS | NUMBER | 9 | 0 | Years | |||
| INITIAL_SCHEDULE_DT | DATE | 0 | Initial Schedule Date | ||||
| LEAD_TIME | NUMBER | 5 | 0 | Lead Time | |||
| LEAD_VALUE | NUMBER | 18 | 7 | Lead Value | |||
| OUTAGE_TYPE_FLG | VARCHAR2 | 38 | Outage Type | ||||
| RISK_PRIORITY_NUM | NUMBER | 5 | 0 | Risk Priority Number | |||
| RUNTIME_VALUE | NUMBER | 18 | 7 | Runtime Value | |||
| SEQNO | NUMBER | 5 | 0 | Sequence | |||
| TRIGGER_TYPE_FLG | VARCHAR2 | 4 | Trigger Type | ||||
| WORK_PRIORITY_FLG | VARCHAR2 | 38 | Work Priority | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |