HRS_APP_SRCH (SQL View)	Index Back
Applicant-Posns Applied For Use POSN_APPLIEDFOR to record job codes and/or job requisitions for which an applicant has applied. This data is used primarily in Recruitment. You can create multiple POSN_APPLIEDFOR records for an applicant.

HRS_APP_SRCH

(SQL View)

Applicant-Posns Applied For

Use POSN_APPLIEDFOR to record job codes and/or job requisitions for which an applicant has applied. This data is used primarily in Recruitment. You can create multiple POSN_APPLIEDFOR records for an applicant.

SELECT A.HRS_PERSON_ID , A.APPLID ,A.EMPLID ,A.STATUS_CODE ,A.APP_PER_STATUS 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
Default Value: 0

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

3 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
Default Value: NEW

4 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
Prompt Table: HRS_STS_APP_I

5 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
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id Default Value: 0
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID Default Value: NEW
4	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status. Prompt Table: HRS_STS_APP_I
5	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 Default Value: A