Module: Work Asset Analytics
Type: Dimension
ACT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACT_ID | VARCHAR2 | 14 | True | Asset Activity | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCOUNT_SEGMENT | VARCHAR2 | 254 | Account Segment | ||||
| ACTIVITY_DESCR100 | VARCHAR2 | 100 | Activity Description | ||||
| ACTIVITY_DESCRLONG | VARCHAR2 | 4000 | Activity Detailed Description | ||||
| ACTVN_DTTM | TIMESTAMP | 0 | 6 | Activation Date/Time | |||
| ACT_DPOS_FLG | VARCHAR2 | 4 | Activity Disposition | ||||
| ACT_END_DT | DATE | 0 | End Date | ||||
| ACT_NUM | NUMBER | 5 | 0 | Activity Number | |||
| ACT_START_DT | DATE | 0 | Start Date | ||||
| ACT_STATUS_CD | VARCHAR2 | 12 | Activity Status | ||||
| ACT_TYPE_CD | VARCHAR2 | 30 | Asset Activity Type | ||||
| ACT_WORK_CATEGORY_CD | VARCHAR2 | 30 | Work Category - Activity | ||||
| ACT_WORK_CLASS_CD | VARCHAR2 | 30 | Work Class - Activity | ||||
| ALLOW_CHARGE_FLG | VARCHAR2 | 4 | Allow Charge | ||||
| ANNIVERSARY_DT | DATE | 0 | Anniversary Date | ||||
| ANNIVERSARY_VALUE | NUMBER | 18 | 7 | Anniversary Value | |||
| BACK_LOG_GRP_FLG | VARCHAR2 | 4 | Backlog Group | ||||
| BUDGET_AMT | NUMBER | 17 | 3 | Budget Amount | |||
| CATEGORY_FLG | VARCHAR2 | 4 | Category | ||||
| COMPLIANCE_DATE | DATE | 0 | Compliance Date | ||||
| COMPLIANCE_UPD_DATE_RSN_FLG | VARCHAR2 | 4 | Compliance Date Update Reason | ||||
| CONSTR_RELATED_FLG | VARCHAR2 | 4 | Construction Related | ||||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| DELIVER_TO_LOC | VARCHAR2 | 12 | Deliver To Location | ||||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| EMERGENCY_FLG | VARCHAR2 | 4 | Emergency | ||||
| EST_END_DT | DATE | 0 | Estimated End Date | ||||
| EST_START_DT | DATE | 0 | Estimated Start Date | ||||
| HELD_FOR_PARTS_FLG | VARCHAR2 | 4 | Held For Parts | ||||
| MAT_DISP_ID | VARCHAR2 | 14 | Material Disposition | ||||
| NT_XID_CD | VARCHAR2 | 30 | External System | ||||
| ORIGINAL_WORK_DT | DATE | 0 | Original Work Date | ||||
| OUTAGE_TYPE_FLG | VARCHAR2 | 4 | Outage Type | ||||
| PHASE_FLG | VARCHAR2 | 4 | Phase | ||||
| 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 | ||||
| RENEWAL_FLG | VARCHAR2 | 4 | Service Class Type | ||||
| REQUESTOR_ID | VARCHAR2 | 8 | Requestor | ||||
| REQUIRED_BY_DT | DATE | 0 | Required By Date | ||||
| SEQ_NUM | NUMBER | 3 | 0 | Sequence | |||
| SERVICE_CLASS_CD | VARCHAR2 | 30 | Service Class | ||||
| STATUS_UPD_DTTM | TIMESTAMP | 0 | 6 | Status Date/Time | |||
| TOTAL_PRIORITY | NUMBER | 2 | 0 | Total Risk Priority | |||
| WORK_PRIORITY_FLG | VARCHAR2 | 4 | Work Priority | ||||
| WORK_REQ_ID | VARCHAR2 | 14 | Work Request | ||||
| WORK_WIN_END_DTTM | TIMESTAMP | 0 | 6 | Work Window End Date/Time | |||
| WORK_WIN_START_DTTM | TIMESTAMP | 0 | 6 | Work Window Start Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |