View: EDWBV_HR_PERM_SPSR1_L10_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ '10-' || PEO.PERSON_ID || '-' || INST.INSTANCE_CODE SPRVSR_LVL10_PK
, '11-' || SPV.SUPV_PERSON_ID || '-' || INST.INSTANCE_CODE SPRVSR_LVL11_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 = 5
AND SPV.SUPV_LEVEL+1 = SPV.SUB_LEVEL
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE UNION SELECT '10-NA_EDW' || '-' || INST.INSTANCE_CODE SPRVSR_LVL10PK
, '11-NA_EDW' || '-' || INST.INSTANCE_CODE SPRVSR_LVL11_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