HRS_APP_RCM_VW (SQL View)	Index Back
Recruitment Tracking View The Recruitment Tracking manages an applicant's progress through recruiting View

HRS_APP_RCM_VW

(SQL View)

Recruitment Tracking View

The Recruitment Tracking manages an applicant's progress through recruiting View

SELECT HRS_PERSON_ID ,APPLID ,APP_PER_STATUS ,HRS_APP_PREF_CONT FROM PS_HRS_APPLICANT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID

3 APP_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant
E=Employee
N=Non-Employee

4 HRS_APP_PREF_CONT Character(1) VARCHAR2(1) NOT NULL Preferred Method of Contact
E=Email
M=Mail
N=Not Specified
P=Phone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
3	APP_PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Identifies the type of applicant - External Applicant, Employee or Non-Employee A=External Applicant E=Employee N=Non-Employee
4	HRS_APP_PREF_CONT	Character(1)	VARCHAR2(1) NOT NULL	Preferred Method of Contact E=Email M=Mail N=Not Specified P=Phone