HRS_SCH_PPRPLVW

(SQL View)
 Index Back

HRS JPM Profile Srch Prop Lang

Language view If JPM Integration is turned on, selects all properties that are searchable for the intersection of properties for profile type's sections intersection with TAM content sections. Uses label from the job opening's primary profile's profile type.

SELECT DISTINCT JPITEM.JPM_PROFILE_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_JPM_JP_ITEMS_I JPITEM , 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.JPM_JP_SRCH_FLG = 'Y' AND JPITEM.JPM_CAT_TYPE = HRSCTCFG.JPM_CAT_TYPE AND JPITEM.EFFDT = ( SELECT MAX(JPITEM3.EFFDT) FROM PS_JPM_JP_ITEMS JPITEM3 WHERE JPITEM3.JPM_PROFILE_ID = JPITEM.JPM_PROFILE_ID AND JPITEM3.JPM_CAT_TYPE = JPITEM.JPM_CAT_TYPE AND JPITEM3.JPM_CAT_ITEM_ID = JPITEM.JPM_CAT_ITEM_ID AND JPITEM3.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_PPRP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    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.