HGA_DIRREP_VW

(SQL View)
 Index Back

Empl Security Record

Empl Security Record based on Direct Line Reports records used in MSS pivot grids.

SELECT EMPLID , EMPL_RCD , JOB_EFFDT , SUPERVISOR_ID , '2' , HR_DR_LEVEL , CASE WHEN HR_DR_LEVEL = 1 THEN 'D' ELSE 'I' END FROM PS_HR_DIRECT_REP_2 UNION ALL SELECT EMPLID , EMPL_RCD , JOB_EFFDT , SUPERVISOR_ID , '3' , HR_DR_LEVEL , CASE WHEN HR_DR_LEVEL = 1 THEN 'D' ELSE 'I' END FROM PS_HR_DIRECT_REP_3 UNION ALL SELECT EMPLID , EMPL_RCD , JOB_EFFDT , SUPERVISOR_ID , '4' , HR_DR_LEVEL , CASE WHEN HR_DR_LEVEL = 1 THEN 'D' ELSE 'I' END FROM PS_HR_DIRECT_REP_4 UNION ALL SELECT EMPLID , EMPL_RCD , JOB_EFFDT , SUPERVISOR_ID , '5' , HR_DR_LEVEL , CASE WHEN HR_DR_LEVEL = 1 THEN 'D' ELSE 'I' END FROM PS_HR_DIRECT_REP_5 UNION ALL SELECT EMPLID , EMPL_RCD , JOB_EFFDT , SUPERVISOR_ID , '6' , HR_DR_LEVEL , CASE WHEN HR_DR_LEVEL = 1 THEN 'D' ELSE 'I' END FROM PS_HR_DIRECT_REP_6

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 JOB_EFFDT Date(10) DATE Job Effective Date
4 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
5 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=By Dept Security Tree
2=By Supervisor ID
3=By Department Manager ID
4=By Reports To Position
5=By Part Posn Mgmt Supervisor
6=By Part Posn Mgmt Dept Mgr ID
7=By Group ID
6 HR_DR_LEVEL Number(3,0) SMALLINT NOT NULL Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.
7 DIRECT_REPORTS Character(1) VARCHAR2(1) NOT NULL Direct Reports