[Home] [Help]
| Product: | HRI - Human Resources Intelligence (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT /**************************************/ /* SELECT DIMENSION LEVEL PRIMARY KEY */ /*
AND OTHER STANDARD PARAMETERS */ /**************************************/ T1.LOOKUP_CODE||'-'||T2.LOOKUP_CODE||'-'||T3.LOOKUP_CODE ||'-'||T4.LOOKUP_CODE||'-'||T5.LOOKUP_CODE||'-' ||T6.LOOKUP_CODE||'-'||T7.LOOKUP_CODE||'-'||INSTANCE_CODE ASG_CHANGE_PK
, 'ALL' ALL_FK
, T1.CREATION_DATE
, NVL(T1.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, INSTANCE_CODE INSTANCE
, T1.LOOKUP_CODE||'-'||T2.LOOKUP_CODE||'-'||T3.LOOKUP_CODE ||'-'||T4.LOOKUP_CODE||'-'||T5.LOOKUP_CODE||'-' ||T6.LOOKUP_CODE||'-'||T7.LOOKUP_CODE ||'('||INSTANCE_CODE||')' NAME
, T1.LOOKUP_CODE||'-'||T2.LOOKUP_CODE||'-'||T3.LOOKUP_CODE ||'-'||T4.LOOKUP_CODE||'-'||T5.LOOKUP_CODE||'-' ||T6.LOOKUP_CODE||'-'||T7.LOOKUP_CODE ||'('||INSTANCE_CODE||')' ASG_CHANGE_DP /**************************************/ /* DIMENSION SPECIFIC PARAMETERS */ /**************************************/
, T1.LOOKUP ORG_CHANGE_FLAG
, T2.LOOKUP JOB_CHANGE_FLAG
, T3.LOOKUP POS_CHANGE_FLAG
, T4.LOOKUP GRD_CHANGE_FLAG
, T5.LOOKUP GEOG_CHANGE_FLAG
, T6.LOOKUP OTHER_CHANGE_FLAG
, T7.LOOKUP CHANGE_STATUS
, NULL ASG_CHANGE_CODE
FROM (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
, LAST_UPDATE_DATE
, CREATION_DATE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T1
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T2
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T3
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T4
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T5
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T6
, (SELECT HR_GENERAL.DECODE_LOOKUP('YES_NO'
, LOOKUP_CODE) LOOKUP
, LOOKUP_CODE
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO') T7
, EDW_LOCAL_INSTANCE INST