JPM_LOC_ITEM_VW

(SQL View)
 Index Back

Catalog Items - Talent Mgmt

Defines all of the Catalog Items for a particular Catalog Type

SELECT JPM_CAT_ITEM_ID ,JPM_DESCR90 FROM PS_JPM_CAT_ITEMS I WHERE JPM_CAT_TYPE='LOCATION' AND %EffdtCheck(JPM_CAT_ITEMS I1, I, %CurrentDateIn) AND I.EFF_STATUS = 'A'

  • Related Language Record: JPM_LOC_ITEMLVW

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

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