Model: Production Performance - Specifications for Dimension Table: SHOP ORDER OPERATION
Attributes
| Attribute |
Description (where applicable) |
| SO Op Order No |
Built as ORDER_NO + ' - ' + SEQUENCE_NO + ' - ' + RELEASE_NO + ' -
' + OPERATION_NO |
| SO Operation Interruption Cause |
Cause of operation interruption. |
| SO Operation Milestone |
Is the operation defined as a milestone? |
| SO Operation Order No |
Corresponding shop order number. |
| SO Operation Purch Order No |
Corresponding purchase order number. |
| SO Operation Resource |
Resource identity. |
| SO Operation Status |
Status of Shop Order operation. I.e. Cancelled, Planned, Released etc |
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 |
| SHOP ORDER OPERATION |
FACT_SHOP_ORDER_OPERATION_TM |
FACT_SHOP_ORDER_OPERATION_BI |
FACT_SHOP_ORDER_OPERATION |
Data Mart |