JPM_ROLE_CFG_VW (SQL View)	Index Back
Content Section Role Config Profile Content section role configuration parameters

JPM_ROLE_CFG_VW

(SQL View)

Content Section Role Config

Profile Content section role configuration parameters

SELECT A.JPM_JP_TYPE , A.JPM_CAT_TYPE , C.JPM_ROLE , C.JPM_SCRTY_MODIFY , C.JPM_JP_APPRVL_FLG , C.JPM_ATTACH_ACCESS FROM PS_JPM_JP_TYPES T , PS_JPM_JP_SECTION A , PS_JPM_JP_ROLES C WHERE A.JPM_JP_TYPE = T.JPM_JP_TYPE AND A.EFFDT = T.EFFDT AND C.JPM_JP_TYPE = A.JPM_JP_TYPE AND C.JPM_JP_SECTION_ID = A.JPM_JP_SECTION_ID AND C.EFFDT = A.EFFDT AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn)

# 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 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
ADM=Administrator
EMP=Employee
MGR=Manager

4 JPM_SCRTY_MODIFY Character(1) VARCHAR2(1) NOT NULL JPM Security Indicator to allow a user to modify a profile.

5 JPM_JP_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Flag used in Profile Types to indicate whether approvals are required for a given Catalog Type.

6 JPM_ATTACH_ACCESS Character(1) VARCHAR2(1) NOT NULL Enable Attachments
N=No Attachments
U=Update Attachments
V=View Attachments

#	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	JPM_ROLE	Character(3)	VARCHAR2(3) NOT NULL	Role ADM=Administrator EMP=Employee MGR=Manager
4	JPM_SCRTY_MODIFY	Character(1)	VARCHAR2(1) NOT NULL	JPM Security Indicator to allow a user to modify a profile.
5	JPM_JP_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used in Profile Types to indicate whether approvals are required for a given Catalog Type.
6	JPM_ATTACH_ACCESS	Character(1)	VARCHAR2(1) NOT NULL	Enable Attachments N=No Attachments U=Update Attachments V=View Attachments