This cube dimension represents the human resouces dimension employee duration
and is based on the IFS Applications dimension DIM_CURR_EMP_DURATION_GROUP.
Attribute |
Hierarchy |
Description |
Employment |
NO |
Description + ' - ' + DURATION_GROUP + ' - ' +
GROUP_UNIT + ' - ' + cast(CODE AS varchar) AS CLASS_GROUP_TIME |
Employment Duration Class |
NO |
Represents the Duration Class |
Employment Duration Class Code |
NO |
Represents the Duration Class Code |
Employment Duration From |
NO |
|
Employment Duration Group |
NO |
Represents the Duration Group |
Employment Duration To |
NO |
|
Employment Months |
NO |
(ID as varchar) as ID_CHAR |
Employment Time Unit |
NO |
Represents the Group Unit |
Hierarchy |
YES |
Employment Duration Class -> Employment Duration Group
-> Employment Months |