JPM_CONTCFG_LVW (SQL View)	Index Back
Content Section Config Profile Content Section configuration parameters

JPM_CONTCFG_LVW

(SQL View)

Content Section Config

Profile Content Section configuration parameters

SELECT A.JPM_JP_TYPE , C.JPM_ROLE , A.JPM_CAT_TYPE , B.LANGUAGE_CD , B.JPM_JP_TABNAME , D.DESCR FROM PS_JPM_JP_SECTION A , PS_JPM_JP_TAB_LNG B , PS_JPM_JP_ROLES C , PS_JPM_CAT_TYP_LNG D WHERE A.JPM_JP_TYPE = B.JPM_JP_TYPE AND A.JPM_JP_TABNUM = B.JPM_JP_TABNUM AND A.EFFDT = B.EFFDT AND D.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND D.LANGUAGE_CD = B.LANGUAGE_CD AND %EffdtCheck(JPM_JP_TYPES D, A, %CurrentDateIn) AND %EffdtCheck(JPM_JP_TYPES E, B, %CurrentDateIn) AND %EffdtCheck(JPM_JP_TYPES F, C, %CurrentDateIn)

Related Language Record for JPM_CONT_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_ROLE Character(3) VARCHAR2(3) NOT NULL Role
ADM=Administrator
EMP=Employee
MGR=Manager

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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 JPM_JP_TABNAME Character(30) VARCHAR2(30) NOT NULL Tab Name

6 JPM_CAT_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Content Type Descr

#	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_ROLE	Character(3)	VARCHAR2(3) NOT NULL	Role ADM=Administrator EMP=Employee MGR=Manager
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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	JPM_JP_TABNAME	Character(30)	VARCHAR2(30) NOT NULL	Tab Name
6	JPM_CAT_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Content Type Descr