[Home] [Help]
View: EDWBV_HR_PERM_SPSR1_L5_LCV
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ '5-' || PEO.PERSON_ID || '-' || INST.INSTANCE_CODE SPRVSR_LVL5_PK
, '6-' || SPV.SUPV_PERSON_ID || '-' || INST.INSTANCE_CODE SPRVSR_LVL6_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' || ')' SPRSVR_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 = 10
AND SPV.SUPV_LEVEL+1 = SPV.SUB_LEVEL
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE UNION SELECT '5-NA_EDW' || '-' || INST.INSTANCE_CODE SPRVSR_LVL5_PK
, '6-NA_EDW' || '-' || INST.INSTANCE_CODE SPRVSR_LVL6_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
Name |
SPRVSR_LVL5_PK |
SPRVSR_LVL6_FK |
INSTANCE |
CREATION_DATE |
LAST_UPDATE_DATE |
NAME |
SPRVSR_DP |
PERSON_ID |
ASSIGNMENT_ID |