HRS_RCM_SCR8_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 ,A.HRS_RSLT_APPLIED ,B.NAME_DISPLAY ,D.APP_PER_STATUS ,%subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_SCR_RSLT A , PS_HRS_APP_NAMES B , PS_HRS_APPLICANT_I D WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND B.NAME_TYPE = 'PRI'

  • Related Language Record: HRS_RCM_SCR8_LN

    • # 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 Signed Number(4,0) DECIMAL(3) 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_RSLT_APPLIED Character(1) VARCHAR2(1) NOT NULL Screening Results Applied
    N=No
    P=Partial
    Y=Yes
    29 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    30 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
    31 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    32 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    33 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    34 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id