Model: Production Performance - Specifications for Dimension Table: SHOP ORDER OPERATION HIST
Attributes
| Attribute |
Description (where applicable) |
| SO Operation No |
Operation Number |
| SO Scrap Cause |
Scrap cause. |
| SO Team Id |
Team identity. |
| SO Transaction |
Transaction Type. |
| Shop Order No |
Shop Order Number. |
| Shop Order Operation Hist |
Built up as Shop Order - Rel No - Seq No - Operation No |
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 HIST |
FACT_OPERATION_HISTORY_TM |
FACT_OPERATION_HISTORY_BI |
FACT_OPERATION_HISTORY |
Data Mart |