Model: Production Performance - Specifications for Dimension Table: SHOP ORDER ANALYSIS

On this page you will find the specifications regarding the Model: Production Performance and 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)

Model Name
Production Performance

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