HRS_SCR_CMP_VW

(SQL View)
Index Back

Screening Competencies

Provides a unique list of competencies that are used as screening critiera in any screening level associated with a job opening. This view is used to provide a list of competencies on which an applicant should be rated through the "Rate Applicants" component.

SELECT DISTINCT A.HRS_JOB_OPENING_ID , A.JOBCODE , A.HRS_JO_SCR_SUMM_ID , B.HRS_JO_SCR_SEQ , B.HRS_SCREENING_ID , C.COMPETENCY , D.DESCR , C.POINTS , C.HRS_JO_SCR_REQD , C.HRS_JO_SCR_AUGMENT , C.HRS_JO_SCR_SELECT , D.RATING_MODEL , %subrec(HRS_AUDIT_SBR, C) FROM PS_HRS_RATE_JC_VW A , PS_HRS_RATE_SCR_VW B , PS_HRS_JO_SCR_CM_I C , PS_COMPETENCY_TBL D WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID AND B.HRS_JO_SCR_SUMM_ID = C.HRS_JO_SCR_SUMM_ID AND B.HRS_JO_SCR_SEQ = C.HRS_JO_SCR_SEQ AND C.COMPETENCY = D.COMPETENCY

  • Related Language Record: HRS_SCR_CMP_LVW
  • # 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
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
    4 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
    5 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
    6 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 POINTS Number(4,0) SMALLINT NOT NULL Points
    9 HRS_JO_SCR_REQD Character(1) VARCHAR2(1) NOT NULL Job Opening Screening Requirement Required

    Y/N Table Edit

    Default Value: N

    10 HRS_JO_SCR_AUGMENT Character(1) VARCHAR2(1) NOT NULL Augmentation factor

    Y/N Table Edit

    Default Value: N

    11 HRS_JO_SCR_SELECT Character(1) VARCHAR2(1) NOT NULL Selective factor

    Y/N Table Edit

    Default Value: N

    12 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
    13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id