DW_EWWA_X_EWDI_WACS_W1_BI_WO_F

Work Orders

Details

Module: Work Asset Analytics

Type: Fact

Key Columns

WO_ID

Columns

Columns
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
A1_USER_ID VARCHAR2 8 Work and Asset User DW_EWWA_X_EWDI_WACS_SC_USER_D USER_ID
ADHERED_CM_DUE_DT_CNT NUMBER 38 0 Corrective Maintenance Due Date Adherence
ADHERED_PM_DUE_DT_CNT NUMBER 38 0 PM Program Due Date Adherence
ASSET_ID VARCHAR2 38 Asset DW_EWWA_X_EWDI_WACS_W1_ASSET_D ASSET_ID
BO_STATUS_REASON_CD VARCHAR2 38 Status Reason
CMPL_CONSTR_WO_CNT NUMBER 38 0 # Construction Work Orders Completed
CMPL_MAINT_WO_CNT NUMBER 38 0 # Maintenance Work Orders Completed
CM_WO_CNT NUMBER 38 0 # Corrective Maintenance Work Orders
CONSTR_RELATED_FLG VARCHAR2 38 Construction Related
CONSTR_WO_CNT NUMBER 38 0 # Construction Work Orders
CRE_CONSTR_WO_CNT NUMBER 38 0 # Construction Work Orders Created
CRE_DT NUMBER 38 0 Creation Date
CRE_MAINT_WO_CNT NUMBER 38 0 # Maintenance Work Orders Created
CRE_TM NUMBER 38 0 Creation Time
DESCR100 VARCHAR2 100 Description
DESCRLONG VARCHAR2 4000 Detailed Description
EMERGENCY_FLG VARCHAR2 4 Emergency
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_SCHED_ID VARCHAR2 38 Maintenance Schedule DW_EWWA_X_EWDI_WACS_W1_MAINT_SCHEDULE_D MAINT_SCHED_ID
MAINT_WO_CNT NUMBER 38 0 # Maintenance Work Orders
OPEN_CONSTR_WO_CNT NUMBER 38 0 # Open Construction Work Orders
OPEN_MAINT_WO_CNT NUMBER 38 0 # Open Maintenance Work Orders
OPEN_WO_CNT NUMBER 38 0 # Open Work Orders
ORIGINAL_WORK_DT NUMBER 38 0 Original Work Date
ORIGINAL_WORK_DT_DATE_ DATE 0
OVERHEAD_CD VARCHAR2 38 Overhead DW_EWWA_X_EWDI_WACS_W1_OVERHEAD_D OVERHEAD_CD
OWNING_ACCESS_GRP_CD VARCHAR2 38 Owning Organization
PLANNED_WO_CNT NUMBER 38 0 # Planned Work Orders
PLANNER_CD VARCHAR2 38 Planner DW_EWWA_X_EWDI_WACS_W1_PLANNER_D PLANNER_CD
PLANNING_WO_CNT NUMBER 38 0 # Work Orders in Planning Status
PM_WO_CNT NUMBER 38 0 # Preventive Maintenance Work Orders
PRJ_ID VARCHAR2 38 Project
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
SVC_HIST_TYPE_CD VARCHAR2 38 Service History Type DW_EWWA_X_EWDI_WACS_W1_SVC_HIST_TYPE_D SVC_HIST_TYPE_CD
SVC_SCHED_WO_ID VARCHAR2 38 Service Schedule Work Order DW_EWWA_X_EWDI_WACS_W1_WO_D WO_ID
TEMPLATE_NAME VARCHAR2 38 Template Name
W1_CREW_ID VARCHAR2 38 Crew DW_EWWA_X_EWDI_WACS_W1_CREW_D W1_CREW_ID
WORK_DESIGN_ID VARCHAR2 38 Work Design DW_EWWA_X_EWDI_WACS_W1_WORK_DESIGN_D WORK_DESIGN_ID
WORK_FINISH_DT NUMBER 38 0 Work Finished Date
WORK_FINISH_TM NUMBER 38 0 Work Finished Time
WORK_PRIORITY_FLG VARCHAR2 38 Work Priority
WORK_REQ_ID VARCHAR2 38 Work Request
WORK_TYPE_FLG VARCHAR2 38 Work Type
WO_CNT NUMBER 38 0 # Work Orders
WO_CRE_DT NUMBER 38 0 Work Created Date
WO_CRE_TM NUMBER 38 0 Work Created Time
WO_NUM VARCHAR2 38 Work Order Number
WO_STATUS_CD VARCHAR2 38 Work Order Status
WO_WORK_CATEGORY_CD VARCHAR2 38 Work Category - WO DW_EWWA_X_EWDI_WACS_W1_WORK_CATEGORY_D WORK_CATEGORY_CD
WO_WORK_CLASS_CD VARCHAR2 38 Work Class - WO DW_EWWA_X_EWDI_WACS_W1_WORK_CLASS_D WORK_CLASS_CD
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6