View: EDWBV_HR_PERM_SPSR1_L14_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ '14-' || PEO.PERSON_ID || '-' || INST.INSTANCE_CODE SPRVSR_LVL14_PK
, '15-' || SPV.SUPV_PERSON_ID || '-' || INST.INSTANCE_CODE SPRVSR_LVL15_FK
, INST.INSTANCE_CODE INSTANCE
, SPV.CREATION_DATE CREATION_DATE
, SPV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEO.FULL_NAME || ' (' || NVL(PEO.EMPLOYEE_NUMBER
, PEO.APPLICANT_NUMBER) ||'
, ' || 'EMPLOYEE' || ')' NAME
, PEO.FULL_NAME || ' (' || NVL(PEO.EMPLOYEE_NUMBER
, PEO.APPLICANT_NUMBER) ||'
, ' || 'EMPLOYEE' || ')' SPRVSR_DP
, PEO.PERSON_ID PERSON_ID
, SPV.SUB_ASSIGNMENT_ID ASSIGNMENT_ID
FROM PER_ALL_PEOPLE_F PEO
, EDW_LOCAL_INSTANCE INST
, HRI_SUPV_HRCHY_SUMMARY SPV
WHERE SPV.SUB_PERSON_ID = PEO.PERSON_ID
AND SPV.SUB_LEVEL = 1
AND SPV.SUPV_LEVEL+1 = SPV.SUB_LEVEL
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE UNION SELECT '14-NA_EDW' || '-' || INST.INSTANCE_CODE SPRVSR_LVL14_PK
, '15-NA_EDW' || '-' || INST.INSTANCE_CODE SPRVSR_LVL15_FK
, INST.INSTANCE_CODE INSTANCE
, INST.CREATION_DATE CREATION_DATE
, INST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL NAME
, NULL SPRVSR_DP
, TO_NUMBER(NULL) PERSON_ID
, TO_NUMBER(NULL) ASSIGNMENT_ID
FROM EDW_LOCAL_INSTANCE INST

Columns