JPM_CAT_ITEMS_I

(SQL View)
 Index Back

Catalog Items - Interface View

Interface view for JPM Catalog Items.

SELECT JPM_CAT_TYPE , JPM_CAT_ITEM_ID , EFFDT , EFF_STATUS , JPM_DESCR90 , DESCRSHORT , RATING_MODEL , EP_SUB_LEVEL , JPM_DATE_1 , JPM_DATE_2 , JPM_TEXT254_1 , JPM_TEXT254_2 , JPM_TEXT254_3 , JPM_TEXT254_4 , JPM_TEXT1325_1 , JPM_TEXT1325_2 , DESCRLONG FROM PS_JPM_CAT_ITEMS

  • 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 EP_SUB_LEVEL Character(1) VARCHAR2(1) NOT NULL Sub-Competency level

    Prompt Table: JPM_C_LST_ITMVW

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