HR_EMPL_SEC_I (SQL View)	Index Back
Empl Security Record Empl Security Record based on Direct Line Reports records used in MSS pivot grids.

HR_EMPL_SEC_I

(SQL View)

Empl Security Record

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

SELECT DR.EMPLID , DR.EMPL_RCD , DR.JOB_EFFDT , DR.SUPERVISOR_ID , '2' , DR.HR_DR_LEVEL FROM PS_HR_DIRECT_REP_2 DR WHERE DR.HR_DR_LEVEL <> 1 AND '2' = ( SELECT J.ACCESS_TYPE FROM PS_SS_LINK_TBL J WHERE J.PNLGRPNAME = 'UX_DIRECTS_PLT' AND J.MARKET = 'GBL') UNION ALL SELECT DR.EMPLID , DR.EMPL_RCD , DR.JOB_EFFDT , DR.SUPERVISOR_ID , '3' , DR.HR_DR_LEVEL FROM PS_HR_DIRECT_REP_3 DR WHERE DR.HR_DR_LEVEL <> 1 AND '3' = ( SELECT J.ACCESS_TYPE FROM PS_SS_LINK_TBL J WHERE J.PNLGRPNAME = 'UX_DIRECTS_PLT' AND J.MARKET = 'GBL') UNION ALL SELECT DR.EMPLID , DR.EMPL_RCD , DR.JOB_EFFDT , DR.SUPERVISOR_ID , '4' , DR.HR_DR_LEVEL FROM PS_HR_DIRECT_REP_4 DR WHERE DR.HR_DR_LEVEL <> 1 AND '4' = ( SELECT J.ACCESS_TYPE FROM PS_SS_LINK_TBL J WHERE J.PNLGRPNAME = 'UX_DIRECTS_PLT' AND J.MARKET = 'GBL') UNION ALL SELECT DR.EMPLID , DR.EMPL_RCD , DR.JOB_EFFDT , DR.SUPERVISOR_ID , '5' , DR.HR_DR_LEVEL FROM PS_HR_DIRECT_REP_5 DR WHERE DR.HR_DR_LEVEL <> 1 AND '5' = ( SELECT J.ACCESS_TYPE FROM PS_SS_LINK_TBL J WHERE J.PNLGRPNAME = 'UX_DIRECTS_PLT' AND J.MARKET = 'GBL') UNION ALL SELECT DR.EMPLID , DR.EMPL_RCD , DR.JOB_EFFDT , DR.SUPERVISOR_ID , '6' , DR.HR_DR_LEVEL FROM PS_HR_DIRECT_REP_6 DR WHERE DR.HR_DR_LEVEL <> 1 AND '6' = ( SELECT J.ACCESS_TYPE FROM PS_SS_LINK_TBL J WHERE J.PNLGRPNAME = 'UX_DIRECTS_PLT' AND J.MARKET = 'GBL')

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

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