HRS_SCT_CFG_LNG

(SQL View)
Index Back

Content Section Config View

Language View to display the translated JPM Labels

SELECT DISTINCT JPMCFG.JPM_JP_TYPE , JPMCFG.JPM_CAT_TYPE , JPMCFGL.LANGUAGE_CD , JPMCFGL.DESCR FROM PS_JPM_PRI_P_CAT_I JPMCFG , PS_JPM_PRI_P_CATLI JPMCFGL , PS_JPM_JP_ROLES JPMROL WHERE JPMCFG.JPM_JP_TYPE = JPMROL.JPM_JP_TYPE AND JPMCFG.JPM_JP_SECTION_ID = JPMROL.JPM_JP_SECTION_ID AND %EffdtCheck(JPM_JP_ROLES JPMROL2, JPMROL, %CurrentDateIn) AND JPMROL.JPM_ROLE = 'EMP' AND JPMROL.JPM_SCRTY_MODIFY = 'Y' AND JPMCFG.JPM_JP_TYPE = JPMCFGL.JPM_JP_TYPE AND JPMCFG.JPM_CAT_TYPE = JPMCFGL.JPM_CAT_TYPE

  • Related Language Record for HRS_BIP_SCT_VW HRS_PRNT_JPM_VW HRS_SCT_CFG_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description