Model: Production Performance - Specifications for Dimension Table: SHOP ORDER ANALYSIS NORM
Attributes
| Attribute |
Description (where applicable) |
| ACCEPTANCE_NO |
|
| ANALYSIS_MEAN |
|
| ANALYSIS_NO |
|
| ANALYSIS_NO_KEY |
|
| ANALYSIS_RANGE |
|
| ANALYSIS_STD_DEVIATION |
|
| CONTRACT |
|
| CONTROL_CHART_TYPE |
|
| CONTROL_CHART_TYPE_DESC |
|
| COUNT_NON_CONFORMING |
|
| COUNT_NON_CONFORMITIES_EXIST |
|
| DATA_POINT |
|
| DATA_POINT_KEY |
|
| DATE_COMPLETED |
|
| INNER_MAX |
|
| INNER_MIN |
|
| INSPECTION_CODE |
|
| LAST_ACTIVITY_DATE |
|
| MVT_CREATED_DT |
|
| NON_CONFORMS |
|
| NON_CONFORM_QTY |
|
| NORM_TYPE |
|
| NORM_VALUE |
|
| OUTER_MAX |
|
| OUTER_MIN |
|
| PART_NO |
|
| QTY_TO_CONTROL |
|
| REAL_TIME_SPC |
|
| REAL_TIME_SPC_DESC |
|
| REJECTION_NO |
|
| REPORTED_BY |
|
| STATUS |
|
| TEST_OPERATION_DESCRIPTION |
|
| TEST_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 ANALYSIS NORM |
|
|
|
|