HR_VWAS_RCD_6 (SQL View)	Index Back
Direct Reports Access Type 6 Access Type 6 - Partial Position/Department Manager - Supervisor Records

HR_VWAS_RCD_6

(SQL View)

Direct Reports Access Type 6

Access Type 6 - Partial Position/Department Manager - Supervisor Records

SELECT DISTINCT SUPERVISOR_ID , SUPERVISOR_ERN FROM PS_HR_VWAS_SRCH_6

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