HR_VWAS_RCD_5 (SQL View)	Index Back
Direct Reports Access Type 5 Access Type 5 - Partial Position/Supervisor Id - Supervisor Records

HR_VWAS_RCD_5

(SQL View)

Direct Reports Access Type 5

Access Type 5 - Partial Position/Supervisor Id - Supervisor Records

SELECT DISTINCT SUPERVISOR_ID , SUPERVISOR_ERN FROM PS_HR_VWAS_SRCH_5

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SUPERVISOR_ERN Number(3,0) SMALLINT NOT NULL This is used to hold the Employment Record Number of a supervisor.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
2	SUPERVISOR_ERN	Number(3,0)	SMALLINT NOT NULL	This is used to hold the Employment Record Number of a supervisor.