HRS_SCR_CRT_LVW

(SQL View)
 Index Back

Screening Lic/Cert

Provides a unique list of accomplishments (licenses/certifications) that are used as screening critiera in any screening level associated with a job opening. This view is used to provide a list of accomplishment 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.ACCOMPLISHMENT , E.LANGUAGE_CD , E.DESCR FROM PS_HRS_RATE_JC_VW A , PS_HRS_RATE_SCR_VW B , PS_HRS_JO_SCR_AC_I C , PS_ACCOMP_TBL D , PS_ACCOMP_TBL_LANG E 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.ACCOMPLISHMENT = D.ACCOMPLISHMENT AND D.ACCOMP_CATEGORY = 'LIC' AND E.ACCOMPLISHMENT = D.ACCOMPLISHMENT

  • Related Language Record for HRS_SCR_CERT_VW

    • # 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: HRS_ACCOM_TBL_I

    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description