Cube Dimension - Employment

This cube dimension represents the human resouces dimension employee duration and is based on the IFS Applications dimension DIM_EMPLOYMENT.

ATTRIBUTES

Attribute	Hierarchy	Description
Company	NO	Represents the parent key COMPANY
Company - Employee No	NO	Built as COMPANY \|\| ' - ' \|\| EMPLOYEE_NUMBER
Employee No	NO	Represents a persons employee number
Employee Agreement	NO	Represents the agreement for an employee
Employment Type	NO	Represents the type of employment
Reson for Leaving	NO	Represents the reson for leaving

USED BY CUBE

Cube Name

HUMAN RESOURCES

ETL Information

BI Access View	BI Component	Recommended Source Type
DIM_EMPLOYMENT_BI	PERSDI	On Line

ETL Step	File Name of SSIS Package	Table Name
E - Stage	1.1.091 Load IFSAppl_DIM_EMPLOYMENT_BI.dtsx	IFSAppl_DIM_EMPLOYMENT_BI
T - DW	2.1.091 Load Dw_DIM_EMPLOYMENT.dtsx	Dw_DIM_EMPLOYMENT
L - DM	3.1.091 Load Dm_DIM_EMPLOYMENT.dtsx	Dm_DIM_EMPLOYMENT