Activities
Module: Work Asset Analytics
Type: Fact
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 | ||||
| A1_USER_ID | VARCHAR2 | 8 | Work and Asset User | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| ACTIVITY_DESCR100 | VARCHAR2 | 100 | Activity Description | ||||
| ACTIVITY_DESCRLONG | VARCHAR2 | 4000 | Activity Detailed Description | ||||
| ACTVN_DT | NUMBER | 38 | 0 | Activation Date | |||
| ACTVN_DTTM | TIMESTAMP | 0 | 6 | Activation Date/Time | |||
| ACTVN_TM | NUMBER | 38 | 0 | Activation Time | |||
| ACT_CNT | NUMBER | 38 | 0 | # Activities | |||
| ACT_DPOS_FLG | VARCHAR2 | 4 | Activity Disposition | ||||
| ACT_NUM | NUMBER | 5 | 0 | Activity Number | |||
| ACT_STATUS_CD | VARCHAR2 | 38 | Activity Status | ||||
| ACT_TYPE_CD | VARCHAR2 | 30 | Asset Activity Type | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_TYPE_D | ACT_TYPE_CD | ||
| ACT_WORK_CATEGORY_CD | VARCHAR2 | 38 | Work Category - Activity | DW_EWWA_X_EWDI_WACS_W1_WORK_CATEGORY_D | WORK_CATEGORY_CD | ||
| ACT_WORK_CLASS_CD | VARCHAR2 | 38 | Work Class - Activity | DW_EWWA_X_EWDI_WACS_W1_WORK_CLASS_D | WORK_CLASS_CD | ||
| ANNIVERSARY_DT | NUMBER | 38 | 0 | Anniversary Date | |||
| ANNIVERSARY_VALUE | NUMBER | 18 | 7 | Anniversary Value | |||
| APPROVAL_PROF_CD | VARCHAR2 | 38 | Approval Profile | DW_EWWA_X_EWDI_WACS_W1_APPROVAL_PROF_D | APPROVAL_PROF_CD | ||
| ASSET_ID | VARCHAR2 | 38 | Asset | DW_EWWA_X_EWDI_WACS_W1_ASSET_D | ASSET_ID | ||
| BACK_LOG_GRP_FLG | VARCHAR2 | 38 | Backlog Group | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 38 | Status Reason | ||||
| CATEGORY_FLG | VARCHAR2 | 4 | Category | ||||
| CM_ACT_CNT | NUMBER | 38 | 0 | # Corrective Maintenance Activities | |||
| COMPLIANCE_ACT_CNT | NUMBER | 38 | 0 | # Compliance Related Activities | |||
| COMPLIANCE_DATE | NUMBER | 38 | 0 | Compliance Date | |||
| COMPLIANCE_DATE_DATE_ | DATE | 0 | |||||
| COMPLIANCE_TYPE_CD | VARCHAR2 | 38 | Compliance Type | DW_EWWA_X_EWDI_WACS_W1_COMPLIANCE_TYPE_D | COMPLIANCE_TYPE_CD | ||
| COMPLIANCE_UPD_DATE_RSN_FLG | VARCHAR2 | 38 | Compliance Date Update Reason | ||||
| CONSTR_ACT_CNT | NUMBER | 38 | 0 | # Construction Work Activities | |||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| DELIVER_TO_LOC | VARCHAR2 | 38 | Deliver To Location | ||||
| EMERGENCY_FLG | VARCHAR2 | 4 | Emergency | ||||
| F1_DAYS | NUMBER | 9 | 0 | Days | |||
| F1_MONTHS | NUMBER | 9 | 0 | Months | |||
| F1_YEARS | NUMBER | 9 | 0 | Years | |||
| FIELD_ACT_CNT | NUMBER | 38 | 0 | # Field Activities | |||
| HELD_CM_ACT_CNT | NUMBER | 38 | 0 | # Corrective Maintenance Activities Held for Parts | |||
| HELD_COMPLIANCE_ACT_CNT | NUMBER | 38 | 0 | # Compliance Related Activities Held For Parts | |||
| HELD_CONSTR_ACT_CNT | NUMBER | 38 | 0 | # Construction Related Activities Held For Parts | |||
| HELD_FOR_PARTS_FLG | VARCHAR2 | 38 | Held For Parts | ||||
| HELD_MAINT_ACT_CNT | NUMBER | 38 | 0 | # Maintenance Activities Held For Parts | |||
| HELD_PM_ACT_CNT | NUMBER | 38 | 0 | # Preventive Maintenance Activities Held For Parts | |||
| LATE_CMPL_COMPL_ACT_CNT | NUMBER | 38 | 0 | # Late Completed Compliance Related Activities | |||
| LOC_ORG_HIERARCHY_NODE_ID | VARCHAR2 | 38 | Location/Organization Hierarchy | DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D | LOC_ORG_NODE_ID | ||
| LOC_ORG_NODE_ID | VARCHAR2 | 38 | Location/Organization | DW_EWWA_X_EWDI_WACS_W1_NODE_D | ASSET_ORG_NODE_ID | ||
| MAINT_ACT_CNT | NUMBER | 38 | 0 | # Maintenance Work Order Activities | |||
| MAINT_EVENT_ID | VARCHAR2 | 38 | Maintenance Event | DW_EWWA_X_EWDI_WACS_W1_MAINT_EVENT_D | MAINT_EVENT_ID | ||
| MAINT_SCHED_ID | VARCHAR2 | 38 | Maintenance Schedule | DW_EWWA_X_EWDI_WACS_W1_MAINT_SCHEDULE_D | MAINT_SCHED_ID | ||
| MAINT_TRIGGER_ID | VARCHAR2 | 38 | Maintenance Trigger | DW_EWWA_X_EWDI_WACS_W1_MAINT_TRIGGER_D | MAINT_TRIGGER_ID | ||
| MAT_DISP_ID | VARCHAR2 | 38 | Material Disposition | DW_EWWA_X_EWDI_WACS_W1_MAT_DISP_D | MAT_DISP_ID | ||
| MEASUREMENT_ID | VARCHAR2 | 38 | Measurement | DW_EWWA_X_EWDI_WACS_W1_MEASUREMENT_D | MEASUREMENT_ID | ||
| MEASUREMENT_UOM_CD | VARCHAR2 | 38 | Measurement Identifier | DW_EWWA_X_EWDI_WACS_W1_MEASUREMENT_UOM_D | MEASUREMENT_UOM_CD | ||
| ONTIME_CMPL_COMPL_ACT_CNT | NUMBER | 38 | 0 | # On Time Completed Compliance Related Activities | |||
| OPEN_ACT_CNT | NUMBER | 38 | 0 | # Open Activities | |||
| OPEN_COMPLIANCE_ACT_CNT | NUMBER | 38 | 0 | # Open Compliance Related Activities | |||
| OPEN_CONSTR_ACT_CNT | NUMBER | 38 | 0 | # Open Construction Work Activities | |||
| OPEN_MAINT_ACT_CNT | NUMBER | 38 | 0 | # Open Maintenance Activities | |||
| ORIGINAL_WORK_DT | NUMBER | 38 | 0 | Original Work Date | |||
| ORIGINAL_WORK_DT_DATE_ | DATE | 0 | |||||
| OUTAGE_TYPE_FLG | VARCHAR2 | 38 | Outage Type | ||||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PHASE_FLG | VARCHAR2 | 38 | Phase | ||||
| PLANNED_ACT_CNT | NUMBER | 38 | 0 | # Activities of Planned Work Orders | |||
| PLANNER_CD | VARCHAR2 | 38 | Planner | DW_EWWA_X_EWDI_WACS_W1_PLANNER_D | PLANNER_CD | ||
| PM_ACT_CNT | NUMBER | 38 | 0 | # Preventive Maintenance Activities | |||
| PRJ_ID | VARCHAR2 | 38 | Project | DW_EWWA_X_EWDI_WACS_W1_PROJECT_D | PRJ_ID | ||
| PRNT_ACT_ID | VARCHAR2 | 38 | Originating Activity | DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_D | ACT_ID | ||
| REQUESTOR_ID | VARCHAR2 | 38 | Requestor | DW_EWWA_X_EWDI_WACS_SC_USER_D | USER_ID | ||
| REQUIRED_BY_DT | NUMBER | 38 | 0 | Required By Date | |||
| REQUIRED_BY_DT_DATE_ | DATE | 0 | |||||
| SEQ_NUM | NUMBER | 3 | 0 | Sequence | |||
| SERVICE_CLASS_CD | VARCHAR2 | 38 | Service Class | DW_EWWA_X_EWDI_WACS_W1_SERVICE_CLASS_D | SERVICE_CLASS_CD | ||
| SVC_HIST_ID | VARCHAR2 | 38 | Service History | DW_EWWA_X_EWDI_WACS_W1_SVC_HIST_D | SVC_HIST_ID | ||
| TMPL_ACT_ID | VARCHAR2 | 38 | Template Activity | DW_EWWA_X_EWDI_WACS_W1_TMPL_ACT_D | TMPL_ACT_ID | ||
| TOTAL_PRIORITY | NUMBER | 2 | 0 | Total Risk Priority | |||
| W1_CREW_ID | VARCHAR2 | 38 | Crew | DW_EWWA_X_EWDI_WACS_W1_CREW_D | W1_CREW_ID | ||
| WAIT_SCHED_ACT_CNT | NUMBER | 38 | 0 | # Activities of Planned Work Waiting to be Scheduled | |||
| WORK_LOC_ID | VARCHAR2 | 38 | Work Location | DW_EWWA_X_EWDI_WACS_W1_WORK_LOC_D | WORK_LOC_ID | ||
| WORK_PRIORITY_FLG | VARCHAR2 | 38 | Work Priority | ||||
| WORK_REQ_ID | VARCHAR2 | 38 | Work Request | ||||
| WORK_TYPE_FLG | VARCHAR2 | 4 | Work Type | ||||
| WORK_WIN_END_DT | NUMBER | 38 | 0 | Work Window End Date | |||
| WORK_WIN_END_DTTM | TIMESTAMP | 0 | 6 | Work Window End Date/Time | |||
| WORK_WIN_END_TM | NUMBER | 38 | 0 | Work Window End Time | |||
| WORK_WIN_START_DT | NUMBER | 38 | 0 | Work Window Start Date | |||
| WORK_WIN_START_DTTM | TIMESTAMP | 0 | 6 | Work Window Start Date/Time | |||
| WORK_WIN_START_TM | NUMBER | 38 | 0 | Work Window Start Time | |||
| WO_ID | VARCHAR2 | 38 | Work Order | DW_EWWA_X_EWDI_WACS_W1_WO_D | WO_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |