HRS_APP_ASSO_VW (SQL View)	Index Back
Applicant Employee View Employees on the hiring team that is associated with applicants.

HRS_APP_ASSO_VW

(SQL View)

Applicant Employee View

Employees on the hiring team that is associated with applicants.

SELECT DISTINCT A.HRS_PERSON_ID , B.EMPLID FROM PS_HRS_RCMNT A , PS_HRS_JO_TEAM B WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID