HR_VWAS_RCD_4 (SQL View)	Index Back
Direct Reports Access Type 4 Access Type 4 - Position Management - Supervisor Records

HR_VWAS_RCD_4

(SQL View)

Direct Reports Access Type 4

Access Type 4 - Position Management - Supervisor Records

SELECT DISTINCT SUPERVISOR_ID , SUPERVISOR_ERN FROM PS_HR_VWAS_SRCH_4

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