HRS_SCH_JPRPL2V

(SQL View)
 Index Back

HRS Jo Srch Prop Lng no JPMInt

Language view: if JPM integration is off, selects all properties with fieldname JPM_CAT_ITEM_ID for the intersection of sections for job opening item's with the primary person profile type's sections with TAM content sections. Uses label from the primary person profile type's properties language record.

SELECT DISTINCT JOITEM.HRS_JOB_OPENING_ID ,HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE ,JPMPRIPIL.FIELDNAME ,JPMPRIPIL.LANGUAGE_CD ,JPMPRIPIL.JPM_LABEL_TEXT FROM PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI , PS_HRS_JO_ITEMS JOITEM , PS_HRS_PRI_P_PRPLI JPMPRIPIL WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMPRIPI.FIELDNAME = 'JPM_CAT_ITEM_ID' AND JOITEM.JPM_CAT_TYPE = HRSCTCFG.JPM_CAT_TYPE AND JOITEM.EFF_STATUS = 'A' AND JPMPRIPIL.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND JPMPRIPIL.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMPRIPIL.FIELDNAME = JPMPRIPI.FIELDNAME

  • Related Language Record for HRS_SCH_JPRP2VW

    • # 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 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    3 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.
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.