HRS_APP_EVAL_I (SQL View)	Index Back
Applicant Evaluation Interface Applicant Evaluation Interface

HRS_APP_EVAL_I

(SQL View)

Applicant Evaluation Interface

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID ,A.HRS_PROFILE_SEQ ,A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT FROM PS_HRS_RCMNT_I A WHERE EXISTS ( SELECT 'X' FROM PS_HRS_INT_EVAL D WHERE D.HRS_PERSON_ID =A.HRS_PERSON_ID AND D.HRS_RCMNT_ID = A.HRS_RCMNT_ID AND D.HRS_SUBMITTED = 'Y')

# 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
Prompt Table: HRS_JO_I

5 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
Prompt Table: HRS_STS_REC_I

6 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
Prompt Table: HRS_RSN_REC_I

7 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field

#	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_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
4	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JO_I
5	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status. Prompt Table: HRS_STS_REC_I
6	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status. Prompt Table: HRS_RSN_REC_I
7	HRS_STATUS_DT	Date(10)	DATE	Recruiting Solutions Status Date field