HRS_JO_SCRSUM_I

(SQL View)
 Index Back

Job Opening Screening Summary

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

SELECT A.HRS_JO_SCR_SUMM_ID , A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , 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 , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_JO_SCR_SUMM A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
2 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

Prompt Table: HRS_JOB_OPENING

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

Prompt Table: HRS_JO_RQMT

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_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
24 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
25 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
26 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id