HRS_RCM_SCR2_VW

(SQL View)
 Index Back

JO Screening Results 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_JOB_OPENING_ID ,A.HRS_SCREENING_ID ,A.JOBCODE ,A.HRS_SCR_GEN_SCORE ,A.REQ_SCR_EDEX_SCORE ,A.REQ_SCR_COMP_SCORE ,A.REQ_SCR_ACMP_SCORE ,A.REQ_SCR_KEY_SCORE ,A.REQ_SCR_QUES_SCORE ,A.HRS_SCR_GEN_COUNT ,A.REQ_SCR_EDEX_COUNT ,A.REQ_SCR_COMP_COUNT ,A.REQ_SCR_ACMP_COUNT ,A.REQ_SCR_KEY_COUNT ,A.REQ_SCR_QUES_COUNT ,A.HRS_SCR_STATUS ,A.HRS_SCR_STS_RSN ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT ,A.GVT_APPL_AP_SCORE ,A.GVT_APPL_VP_SCORE ,A.HRS_APP_SEL_SCORE ,A.HRS_SCR_SCORE ,A.HRS_SCR_TTL_SCORE ,%subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_SCR_RSLT 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 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
4 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
6 HRS_SCR_GEN_SCORE Signed Number(4,0) DECIMAL(3) NOT NULL Tracks the applicant score of general requirements during job opening screening.
7 REQ_SCR_EDEX_SCORE Number(3,0) SMALLINT NOT NULL Education/Experience Score
8 REQ_SCR_COMP_SCORE Number(3,0) SMALLINT NOT NULL Competencies Score
9 REQ_SCR_ACMP_SCORE Number(3,0) SMALLINT NOT NULL Accomplishments Score
10 REQ_SCR_KEY_SCORE Number(3,0) SMALLINT NOT NULL Keyword Score
11 REQ_SCR_QUES_SCORE Number(3,0) SMALLINT NOT NULL Questions Score
12 HRS_SCR_GEN_COUNT Number(3,0) SMALLINT NOT NULL Stores the count of general requirements for the applicant during job opening screening.
13 REQ_SCR_EDEX_COUNT Number(3,0) SMALLINT NOT NULL Education/Experience Count
14 REQ_SCR_COMP_COUNT Number(3,0) SMALLINT NOT NULL Competencies Count
15 REQ_SCR_ACMP_COUNT Number(3,0) SMALLINT NOT NULL Accomplishment Count
16 REQ_SCR_KEY_COUNT Number(3,0) SMALLINT NOT NULL Keyword Count
17 REQ_SCR_QUES_COUNT Number(3,0) SMALLINT NOT NULL Questions Count
18 HRS_SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Screening Status
1=Passed
2=Failed
19 HRS_SCR_STS_RSN Character(254) VARCHAR2(254) NOT NULL Screening Status Reason
20 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_REC_I

21 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

Prompt Table: HRS_RSN_REC_I

22 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
23 GVT_APPL_AP_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Augmentation Points for Applicants
24 GVT_APPL_VP_SCORE Signed Number(3,0) DECIMAL(2) NOT NULL Veterans Preference Points
25 HRS_APP_SEL_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Selective factor points earned by an applicant.
26 HRS_SCR_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Screening score. Includes all points awarded to an applicant for a screening level, less veterans preference points, augmenting points, and selective factor points.
27 HRS_SCR_TTL_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Screening score. Includes all points awarded to an applicant for a screening level, INCLUDING veterans preference points, augmenting factor points, and selective factor points.
28 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
29 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
30 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
31 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id