Model: Maintenance - Specifications for Dimension Table: ORGANIZATION

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: ORGANIZATION.

Attributes

Attribute Description (where applicable)
Organization Key. Built as ORG_CONTRACT + ' - ' + ORG_CODE + ' - ' + DESCR
Organization Code The organzation code (ORG_CODE, same as CODE).
Organization Descr The description (DESCR) of the organization code.

USED BY MODEL(S)

Model Name
Maintenance

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
ORGANIZATION DIM_ORGANIZATION_TM DIM_ORGANIZATION_BI DIM_ORGANIZATION On Line