HRS_RCM_SCR_VW

(SQL View)
 Index Back

Recruitment Screening View

This view is used to display applicants associated with the job opening and applicants' status as s/he moves through the job opening screening process. It is used as a no-autoselect derived display grid on the job opening screening component. This view should not be exposed through query and should not be used for any other purpose.

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 ,A.ENTRY_SOURCE ,A.ENTRY_DATE ,A.CONTRACT_NUM ,A.ESTABID ,A.OFF_REFSRC_CAT ,A.OFF_REFSRC_SUB ,A.REQST_ADDTNL_INFO ,A.KEYWORD_MATCH FROM PS_HRS_RCMNT A WHERE A.HRS_RCMNT_ID = ( SELECT MAX(D.HRS_RCMNT_ID) FROM PS_HRS_RCMNT D WHERE D.HRS_PERSON_ID = A.HRS_PERSON_ID AND D.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND D.STATUS_CODE NOT IN ( SELECT STATUS_CODE FROM PS_HRS_STS_REC_I WHERE STATUS_AREA = '3' AND HRS_DRFT_STS_IND = '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
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
8 ENTRY_SOURCE Character(1) VARCHAR2(1) NOT NULL Entry Source
A=Application
O=Organization

Default Value: A

9 ENTRY_DATE Date(10) DATE Date Entered

Default Value: %date

10 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Prompt Table: HRS_APP_CNTRACT

11 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
12 OFF_REFSRC_CAT Character(2) VARCHAR2(2) NOT NULL Official Referral Source
AD=Advertisement
AG=Agency
CL=Client Referral
CO=College Recruiting
CR=College Recommendation
EE=Employee
ES=Employment Securitry Bureau
FE=Former Employee
JF=Job Fair
JP=Job Posting
OH=Open House
OT=Other Source
PI=Phone Inquiry
UK=Unknown
US=Unsolicited
WI=Walk-In
XR=Executive Referral
XS=Executive Search
13 OFF_REFSRC_SUB Character(2) VARCHAR2(2) NOT NULL Offer Referral Subcategory

Prompt Table: HRS_REF_SUBCAT
Set Control Field: REF_SRC_SUB_CAT

14 REQST_ADDTNL_INFO Character(1) VARCHAR2(1) NOT NULL Request Additional Information
15 KEYWORD_MATCH Character(1) VARCHAR2(1) NOT NULL Keyword match

Y/N Table Edit