Model: Maintenance - Specifications for Dimension Table: VIM SERIAL

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

This model dimension represents the Serial Structure Information, part of Vehicle Information Management, and is based on the IFS Cloud dimension DIM_VIM_SERIAL. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Eng Part Revision Part revision for the serial
Location Code Location Code for the serial
Maint Group Maint Group Code
Maint Group Desc Maint Group Description
Maint Prog Id Risk Consequence ID - Consequence Description
Maint Prog Rev Maint Prog Revision No
Manufactured Date Article Manufacturing Date
Manufacturer
Manufacturer Name
Manufacturer Part No Manufacturer's article number
Operational Condition Operational Condition
Operational Status Operational Status
Owner Desc Owner Organization Description
Owner Org Owner Organization Code
Owning Customer No Owning Customer Code
Part Desc Part Description
Part No Part Number
Part Ownership Type of ownership description
Quarantined Quarantined TRUE/FALSE
Serial No Part Serial Number
Structure Address Structure Position Address
Template Part No Template Part Number
Template Part Rev Template Part Revision Number
VIM Serial Partno + Serial No +Part Description
Vehicle Id Vehicle Id
Workshop Code Workshop 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
VIM SERIAL DIM_VIM_SERIAL_TM DIM_VIM_SERIAL_BI DIM_VIM_SERIAL On Line