Model: Production Performance - Specifications for Dimension Table: SHOP ORDER ANALYSIS
Attributes
| Attribute |
Description (where applicable) |
| ACCEPT_SAMPLING_STATUS |
|
| ACCEPT_SAMPLING_STATUS_DESC |
|
| ANALYSIS_NO |
|
| ANALYSIS_NO_KEY |
|
| ATTRIBUTE_RESULT_STATUS |
|
| ATTRIBUTE_RESULT_STATUS_DESC |
|
| CATEGORY_RESULT_STATUS |
|
| CATEGORY_RESULT_STATUS_DESC |
|
| CNT_ATTR_NON_CONFORMITY_EXISTS |
|
| CNT_CAT_NON_CONFORMITY_EXISTS |
|
| CONTRACT |
|
| CONTROL_PLAN_NO |
|
| COUNT_ATTRIBUTE_CONFORMING |
|
| COUNT_CATEGORY_CONFORMING |
|
| COUNT_OUT_OF_SPECIFICATION |
|
| COUNT_PARTLY_IN_SPECIFICATION |
|
| COUNT_WITHIN_SPECIFICATION |
|
| OPERATION_NO |
|
| ORDER_NO |
|
| PART_NO |
|
| Part ID |
|
| REAL_TIME_SPC |
|
| REAL_TIME_SPC_DESC |
|
| RELEASE_NO |
|
| SEQUENCE_NO |
|
| TIME_CONFIRMED |
|
| TIME_CREATED |
|
| VARIABLE_RESULT_STATUS |
|
| VARIABLE_RESULT_STATUS_DESC |
|
| WORK_CENTER_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 ANALYSIS |
|
|
|
|