HRS_JPIDX_PRPL3

(SQL View)
 Index Back

cont sect props lang

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

SELECT DISTINCT props.jpm_jp_type ,sect.jpm_cat_type ,props.fieldname ,propsl.language_cd ,propsl.jpm_label_text FROM ps_jpm_jp_pri_type jpmcfg , ps_jpm_jp_props props , ps_jpm_jp_section sect , ps_jpm_cat_types cat , PS_JPM_JP_ROLES jpmrol , ps_jpm_jp_prop_lng propsl WHERE props.jpm_jp_type = jpmrol.jpm_jp_type AND sect.jpm_jp_type = jpmrol.jpm_jp_type AND sect.jpm_jp_section_id = jpmrol.jpm_jp_section_id AND jpmrol.effdt = ( SELECT MAX(effdt) FROM PS_JPM_JP_ROLES jpmrol2 WHERE jpmrol2.jpm_jp_type = jpmrol.jpm_jp_type AND jpmrol2.jpm_jp_section_id = jpmrol.jpm_jp_section_id AND jpmrol2.jpm_role = jpmrol.jpm_role AND jpmrol2.effdt <= %CurrentDateIn) AND jpmrol.jpm_role = 'EMP' AND jpmrol.jpm_scrty_modify = 'Y' AND sect.jpm_jp_type = jpmcfg.jpm_pri_pers_type AND sect.jpm_cat_type = cat.jpm_cat_type AND sect.effdt = ( SELECT MAX(effdt) FROM ps_jpm_jp_section sect2 WHERE sect2.jpm_jp_type = sect.jpm_jp_type AND sect2.jpm_jp_section_id = sect.jpm_jp_section_id AND sect2.effdt <= %CurrentDateIn) AND props.jpm_jp_type = jpmcfg.jpm_pri_pers_type AND props.jpm_jp_type = sect.jpm_jp_type AND props.jpm_jp_section_id = sect.jpm_jp_section_id AND props.effdt = ( SELECT MAX(effdt) FROM ps_jpm_jp_props props1 WHERE props1.jpm_jp_type = props.jpm_jp_type AND props1.jpm_jp_section_id = props.jpm_jp_section_id AND props1.fieldname = props.fieldname AND props1.effdt <= %CurrentDateIn) AND sect.effdt = ( SELECT MAX(effdt) FROM ps_jpm_jp_section sect1 WHERE sect1.jpm_jp_type = sect.jpm_jp_type AND sect1.jpm_jp_section_id = sect.jpm_jp_section_id AND sect1.effdt <= %CurrentDateIn) AND (props.FIELDNAME = 'JPM_CAT_ITEM_ID' OR(cat.JPM_ADHOC_FLG = 'Y' AND props.FIELDNAME = 'JPM_ADHOC_DESCR')) AND propsl.jpm_jp_type = props.jpm_jp_type AND propsl.effdt = props.effdt AND propsl.jpm_jp_section_id = props.jpm_jp_section_id AND propsl.fieldname = props.fieldname

  • Related Language Record for HRS_JPIDX_PRP3I

  • Parent record: JPM_CAT_TYPES

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    2 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.
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 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.