Model: Maintenance - Specifications for Dimension Table: WORK ORDER
Attributes
| Attribute |
Description (where applicable) |
| Work Leader Sign |
Work leader signature (WORK_LEADER_SIGN) |
| Work Master Sign |
Work master signature (WORK_MASTER_SIGN) |
| Work Order |
Key. Defined as WO_NO (work order number) |
| Work Order Call Code |
Maintenence event identity (CALL_CODE) |
| Work Order Discovery |
Defined as the description of the work order discover code (DISCOVER_DESCRIPTION) |
| Work Order Error Cause |
Defined as the description of the maintenance error cause (ERR_CAUSE_DESCRIPTION) |
| Work Order Error Class |
Defined as the description of the work order error class identity (ERR_CLASS_DESCRIPTION) |
| Work Order Error Symptom |
Defined as the description of the work order error symptom code (SYMPTOM_DESCRIPTION) |
| Work Order Error Type |
Defined as the description of the work order error type code (ERR_TYPE_DESCRIPTION) |
| Work Order Operational Status |
Defined as the operational status of the work order. |
| Work Order Performed Action |
Defined as the description of the performed action (PERFORMED_ACTION_DESCRIPTION) |
| Work Order Priority |
Defined as the description of the work order priority (PRIORITY_DESCRIPTION) |
| Work Order Reported By |
The identity of reporting user (REPORTED_BY) |
| Work Order Site Code |
Defined as the work order site |
| Work Order Status |
The status of the work order (STATUS) |
| Work Order Work Type |
Defined as the work order type description (WORK_TYPE_DESC) |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data source contains a number of
transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View
Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| WORK ORDER |
DIM_WORK_ORDER_TM |
DIM_WORK_ORDER_BI |
DIM_WORK_ORDER |
On Line |