HRS_JO_SCRSM_VW

(SQL View)
 Index Back

Job Opening Screening Summ Vw

Job opening screening summary view with overall scoring information and federal ranking categories

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.HRS_JO_SCR_SUMM_ID , A.JOBCODE , A.HRS_SCR_TTL_PT , A.HRS_SCR_TRANSMUTE , A.HRS_SCR_DEPENDENT , A.GVT_TIE_BREAKER , A.GVT_VP_SCORE_LMT , A.GVT_AUG_SCORE_LMT , A.GVT_RANK_COMP_CAT1 , A.GVT_RANK_COMP_CAT2 , A.GVT_RANK_COMP_CAT3 , A.GVT_RANK_COMP_CAT4 , A.GVT_CONSID_VP_COMP , A.GVT_RANK_NCMP_CAT1 , A.GVT_RANK_NCMP_CAT2 , A.GVT_RANK_NCMP_CAT3 , A.GVT_RANK_NCMP_CAT4 , A.GVT_CONSID_VP_NCMP , A.HRS_G_JO_WQL_SCR , A.HRS_G_JO_BQL_SCR ,A.HRS_HOURLY , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_SCR_SUMM A

  • Parent record: HRS_JOB_OPENING

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    2 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

    Prompt Table: HRS_JO_RQMT

    3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
    4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HRS_JO_RQMT

    5 HRS_SCR_TTL_PT Signed Number(5,0) DECIMAL(4) NOT NULL Maximum points for all of screening
    6 HRS_SCR_TRANSMUTE Character(1) VARCHAR2(1) NOT NULL Transmutation flag

    Y/N Table Edit

    Default Value: N

    7 HRS_SCR_DEPENDENT Character(1) VARCHAR2(1) NOT NULL Flag to determine whether a previous level must be passed in order to be considered for next level

    Y/N Table Edit

    Default Value: N

    8 GVT_TIE_BREAKER Number(1,0) SMALLINT NOT NULL Tie Break Number
    9 GVT_VP_SCORE_LMT Number(3,0) SMALLINT NOT NULL Raw Veterans Pref Score Limit
    10 GVT_AUG_SCORE_LMT Number(3,0) SMALLINT NOT NULL Raw Augmented Score Limit
    11 GVT_RANK_COMP_CAT1 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 1

    Y/N Table Edit

    Default Value: N

    12 GVT_RANK_COMP_CAT2 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 2

    Y/N Table Edit

    Default Value: N

    13 GVT_RANK_COMP_CAT3 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 3

    Y/N Table Edit

    Default Value: N

    14 GVT_RANK_COMP_CAT4 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 4

    Y/N Table Edit

    Default Value: N

    15 GVT_CONSID_VP_COMP Character(1) VARCHAR2(1) NOT NULL Veteran Preferred in Tie Break

    Y/N Table Edit

    Default Value: N

    16 GVT_RANK_NCMP_CAT1 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 1

    Y/N Table Edit

    Default Value: N

    17 GVT_RANK_NCMP_CAT2 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 2

    Y/N Table Edit

    Default Value: N

    18 GVT_RANK_NCMP_CAT3 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 3

    Y/N Table Edit

    Default Value: N

    19 GVT_RANK_NCMP_CAT4 Character(1) VARCHAR2(1) NOT NULL Rank Candidates of Category 4

    Y/N Table Edit

    Default Value: N

    20 GVT_CONSID_VP_NCMP Character(1) VARCHAR2(1) NOT NULL Veteran Preferred in Tie Break

    Y/N Table Edit

    Default Value: N

    21 HRS_G_JO_WQL_SCR Number(3,0) SMALLINT NOT NULL Job opening well qualified score
    22 HRS_G_JO_BQL_SCR Number(3,0) SMALLINT NOT NULL Job opening best qualified score
    23 HRS_HOURLY Character(1) VARCHAR2(1) NOT NULL Hourly Transmutation check flag

    Y/N Table Edit

    Default Value: N

    24 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    25 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    26 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    27 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id