HRS_SCT_CFG_LNG(SQL View) |
Index Back |
---|---|
Content Section Config ViewLanguage 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 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type | |
2 | 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 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |