JPM_CAT_ITEMS_X

(SQL View)
 Index Back

Catalog Items - Search View

Search view for JPM Catalog Items.

SELECT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.EFFDT , A.EFF_STATUS , A.JPM_DESCR90 , A.DESCRSHORT , A.RATING_MODEL , A.JPM_DATE_1 , A.JPM_DATE_2 , A.JPM_TEXT254_1 , A.JPM_TEXT254_2 , A.JPM_TEXT254_3 , A.JPM_TEXT254_4 , A.JPM_TEXT1325_1 , A.JPM_TEXT1325_2 , A.DESCRLONG FROM PS_JPM_CAT_ITEMS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM 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 AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: JPM_CAT_ITM_L_I

    • # 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_TYPES

    2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

    Prompt Table: CM_RATING_VW

    8 JPM_DATE_1 Date(10) DATE generic profile item date property
    9 JPM_DATE_2 Date(10) DATE generic profile item date property
    10 JPM_TEXT254_1 Character(254) VARCHAR2(254) NOT NULL Generic Text property for profile items
    11 JPM_TEXT254_2 Character(254) VARCHAR2(254) NOT NULL Generic Text property for profile items
    12 JPM_TEXT254_3 Character(254) VARCHAR2(254) NOT NULL Generic Text property for profile items
    13 JPM_TEXT254_4 Character(254) VARCHAR2(254) NOT NULL Generic Text property for profile items
    14 JPM_TEXT1325_1 Long Character(1325) VARCHAR2(1325) Generic Text property for profile items
    15 JPM_TEXT1325_2 Long Character(1325) VARCHAR2(1325) Generic Text property for profile items
    16 DESCRLONG Long Character CLOB Long Description