Model: Maintenance - Specifications for Dimension Table: COMPATIBLE UNIT

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

This model dimension represents the Compatible Units and is based on the IFS Cloud dimension DIM_CMPUNT_COMPATIBLE_UNIT. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
CU Id Compatible Unit Id
Class Class
Company Company Code
Compatible Unit Name + Description
Compatible Unit Sq Sequence Number, Internal Database Key
Compatible Unit Type Compatible Unit Type
Configuration Id Configuration Id
Description Compatible Unit Description
Estimate Revision Indicates if this is the revision used for estimations True =1, False =0
Parent Id Parent Unit Id
Parent Rev Parent Unit Revision No
Parent Seq Parent Unit Sequence No
Plant Plant Description
Project Id Project ID
Revision No Revision Number
Site Site Code
Status Compatible Unit Status
Template Id Template unit ID from which Compatible Unit derived
Template Revision No Revision Number of Template unit, from which Compatible Unit derived

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
COMPATIBLE UNIT DIM_CMPUNT_COMPATIBLE_UNIT_TM DIM_CMPUNT_COMPATIBLE_UNIT_BI DIM_CMPUNT_COMPATIBLE_UNIT On Line