HRS_EMPL_SEC_I (SQL View)	Index Back
Supervisor-Employee Relation This view lists the supervisor-employee relationship based on the Direct Line Reports setup to be used in pivot girds.

HRS_EMPL_SEC_I

(SQL View)

Supervisor-Employee Relation

This view lists the supervisor-employee relationship based on the Direct Line Reports setup to be used in pivot girds.

SELECT SUPERVISOR_ID , 0 , EMPLID , EMPL_RCD , HR_DR_LEVEL , JOB_EFFDT , '2' FROM PS_HR_DIRECT_REP_2 UNION ALL SELECT SUPERVISOR_ID , 0 , EMPLID , EMPL_RCD , HR_DR_LEVEL , JOB_EFFDT , '3' FROM PS_HR_DIRECT_REP_3 UNION ALL SELECT SUPERVISOR_ID , SUPERVIS_EMPL_RCD , EMPLID , EMPL_RCD , HR_DR_LEVEL , JOB_EFFDT , '4' FROM PS_HR_DIRECT_REP_4 UNION ALL SELECT SUPERVISOR_ID , SUPERVIS_EMPL_RCD , EMPLID , EMPL_RCD , HR_DR_LEVEL , JOB_EFFDT , '5' FROM PS_HR_DIRECT_REP_5 UNION ALL SELECT SUPERVISOR_ID , SUPERVIS_EMPL_RCD , EMPLID , EMPL_RCD , HR_DR_LEVEL , JOB_EFFDT , '6' FROM PS_HR_DIRECT_REP_6

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

2 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 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.

6 JOB_EFFDT Date(10) DATE Job Effective Date

7 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
2	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	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.
6	JOB_EFFDT	Date(10)	DATE	Job Effective Date
7	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