HRS_APP_RTE2_VW (SQL View)	Index Back
Application Routing Use APPLICATN_ROUTE to record who an application for employment was routed to, the date it was routed, and the date it's due back. This data is used primarily in Recruitment. You can create multiple APPLICATN_ROUTE records for an applicant.

HRS_APP_RTE2_VW

(SQL View)

Application Routing

Use APPLICATN_ROUTE to record who an application for employment was routed to, the date it was routed, and the date it's due back. This data is used primarily in Recruitment. You can create multiple APPLICATN_ROUTE records for an applicant.

SELECT HRS_PERSON_ID ,HRS_RCMNT_ID ,HRS_JOB_OPENING_ID FROM PS_HRS_PSN_APP_VW WHERE OPEN_STS_IND = 'Y'

Parent record: HRS_APPLICANT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID

3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_RCMNT_ID	Number(15,0)	DECIMAL(15) NOT NULL	App Tracking Recruitment ID
3	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone