JPM_CAT_ITM_VW2

(SQL View)
 Index Back

Adm Profile Item Id Prompt Vw

Admin prompt view for profile item id.

SELECT A.JPM_CAT_TYPE ,A.JPM_CAT_ITEM_ID ,B.EFFDT ,B.EFF_STATUS ,A.JPM_CAT_GROUP_TYPE ,A.JPM_CAT_GROUP ,B.JPM_DESCR90 FROM PS_JPM_CAT_GMEMB A , PS_JPM_CAT_ITEMS B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID UNION SELECT B.JPM_CAT_TYPE ,B.JPM_CAT_ITEM_ID ,B.EFFDT ,B.EFF_STATUS ,' ' ,' ' ,B.JPM_DESCR90 FROM PS_JPM_CAT_ITEMS B WHERE NOT EXISTS ( SELECT 'x' FROM PS_JPM_CAT_GMEMB B1 WHERE B1.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND B1.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID)

  • Related Language Record: JPM_CAT_ITMLVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.

    Prompt Table: JPM_CAT_GTYP_VW

    2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

    Prompt Table: JPM_CAT_ITEMS

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 JPM_CAT_GROUP_TYPE Character(12) VARCHAR2(12) NOT NULL Defines Catalog Group Types

    Prompt Table: JPM_CAT_GTYPE

    6 JPM_CAT_GROUP Character(12) VARCHAR2(12) NOT NULL Content Group

    Prompt Table: JPM_CAT_GROUPS

    7 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm