JPM_CONT_CFG_VW

(SQL View)
 Index Back

Content Section Config

Profile Content section configuration parameters

SELECT A.JPM_JP_TYPE , C.JPM_ROLE , A.JPM_CAT_TYPE , A.JPM_JP_SECTION_ID , A.JPM_JP_TABNUM , A.SEQNUM , B.JPM_JP_TABNAME , D.DESCR , T.JPM_DISP_TAB_ICONS , B.JPM_CONTENT_ICON , D.JPM_ADHOC_FLG , A.JPM_JP_QUAL_SET , A.JPM_JP_QUAL_SET2 , C.JPM_JP_APPRVL_FLG , A.JPM_JP_PSECTION_ID , A.JPM_CAT_REQUIRED , C.JPM_SCRTY_MODIFY , C.JPM_ATTACH_ACCESS FROM PS_JPM_JP_TYPES T , PS_JPM_JP_SECTION A , PS_JPM_JP_TAB B , PS_JPM_JP_ROLES C , PS_JPM_CAT_TYPES D WHERE A.JPM_JP_TYPE = T.JPM_JP_TYPE AND A.EFFDT = T.EFFDT AND B.JPM_JP_TYPE = T.JPM_JP_TYPE AND B.EFFDT = T.EFFDT AND A.JPM_JP_TABNUM = B.JPM_JP_TABNUM 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 D.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn)

  • Related Language Record: JPM_CONTCFG_LVW

    • # 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 JPM_JP_SECTION_ID Number(4,0) SMALLINT NOT NULL JPM
    5 JPM_JP_TABNUM Number(3,0) SMALLINT NOT NULL Tab number to be moved or re-ordered in a JPM Profile Content Section within a Profile Type
    6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    7 JPM_JP_TABNAME Character(30) VARCHAR2(30) NOT NULL Tab Name
    8 JPM_CAT_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Content Type Descr
    9 JPM_DISP_TAB_ICONS Character(1) VARCHAR2(1) NOT NULL Display Tab Icons
    10 JPM_CONTENT_ICON Character(30) VARCHAR2(30) NOT NULL Tab Icon
    11 JPM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Indicates that the Catalog Type is Adhoc or FreeForm.
    12 JPM_JP_QUAL_SET Character(12) VARCHAR2(12) NOT NULL 1st Instance Qualifier Set Name for a JPM Profile Item
    13 JPM_JP_QUAL_SET2 Character(12) VARCHAR2(12) NOT NULL 2nd Instance Qualifier Set Name for a JPM Profile Item
    14 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.
    15 JPM_JP_PSECTION_ID Number(4,0) SMALLINT NOT NULL Parent Section Id on Profile Types
    16 JPM_CAT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Used to indicate that the property, item or relationship must be used.
    17 JPM_SCRTY_MODIFY Character(1) VARCHAR2(1) NOT NULL JPM Security Indicator to allow a user to modify a profile.
    18 JPM_ATTACH_ACCESS Character(1) VARCHAR2(1) NOT NULL Enable Attachments
    N=No Attachments
    U=Update Attachments
    V=View Attachments