HRS_JO_SCRI1_LN

(SQL View)
 Index Back

Job Opening JPM Content Scr Vw

Job opening JPM Content requirements view for screening

SELECT JOITM.HRS_JOB_OPENING_ID , SCRLVL.HRS_JO_SCR_SUMM_ID , SCRLVL.HRS_JO_SCR_SEQ , JOITM.HRS_JO_RQMT_SEQ , JOITM.JPM_PROFILE_ID , JOITM.JPM_CAT_TYPE , JOITM.JPM_CAT_ITEM_ID , JOITM.JPM_CAT_ITEM_QUAL , JOITM.JPM_CAT_ITEM_QUAL2 , TYPLNG.LANGUAGE_CD , TYPLNG.DESCR , ITMLNG.JPM_DESCR90 FROM PS_HRS_JO_ITM01_VW JOITM , PS_JPM_CAT_TYP_LNG TYPLNG , PS_JPM_CAT_ITM_LNG ITMLNG , PS_HRS_JO_SCR_SUMM SCRSUM , PS_HRS_JO_SCR_LVL SCRLVL WHERE JOITM.JPM_CAT_TYPE = TYPLNG.JPM_CAT_TYPE AND %EffdtCheck(JPM_CAT_ITM_LNG ITMLNG1, ITMLNG, %CurrentDateIn) AND JOITM.JPM_CAT_TYPE = ITMLNG.JPM_CAT_TYPE AND JOITM.JPM_CAT_ITEM_ID = ITMLNG.JPM_CAT_ITEM_ID AND ITMLNG.LANGUAGE_CD = TYPLNG.LANGUAGE_CD AND JOITM.HRS_JOB_OPENING_ID = SCRSUM.HRS_JOB_OPENING_ID AND SCRSUM.HRS_JO_SCR_SUMM_ID = SCRLVL.HRS_JO_SCR_SUMM_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_JO_SCRI_VW SCRIVW WHERE SCRIVW.HRS_JOB_OPENING_ID = JOITM.HRS_JOB_OPENING_ID AND JOITM.JPM_PROFILE_ID = SCRIVW.JPM_PROFILE_ID AND JOITM.JPM_CAT_TYPE = SCRIVW.JPM_CAT_TYPE AND JOITM.JPM_CAT_ITEM_ID = SCRIVW.JPM_CAT_ITEM_ID AND JOITM.JPM_CAT_ITEM_QUAL = SCRIVW.JPM_CAT_ITEM_QUAL AND JOITM.JPM_CAT_ITEM_QUAL2 = SCRIVW.JPM_CAT_ITEM_QUAL2) AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_JO_SCR_ITEM SCRITM2 WHERE SCRITM2.HRS_JO_SCR_SUMM_ID = SCRSUM.HRS_JO_SCR_SUMM_ID AND SCRITM2.HRS_JO_SCR_SEQ = SCRLVL.HRS_JO_SCR_SEQ AND SCRITM2.JPM_PROFILE_ID = JOITM.JPM_PROFILE_ID AND SCRITM2.JPM_CAT_TYPE = JOITM.JPM_CAT_TYPE AND SCRITM2.JPM_CAT_ITEM_ID = JOITM.JPM_CAT_ITEM_ID AND SCRITM2.JPM_CAT_ITEM_QUAL = JOITM.JPM_CAT_ITEM_QUAL AND SCRITM2.JPM_CAT_ITEM_QUAL2 = JOITM.JPM_CAT_ITEM_QUAL2)

  • Related Language Record for HRS_JO_SCRI1_VW

  • Parent record: HRS_JO_RQMT

    • # 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_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
    3 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
    4 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

    Prompt Table: HRS_JO_RQMT

    5 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
    6 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
    7 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
    8 JPM_CAT_ITEM_QUAL Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
    9 JPM_CAT_ITEM_QUAL2 Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm