JPM_CAT_ITM_LVW

(SQL View)
 Index Back

Cat Items lang- Talent Mgmt

Defines all of the Catalog Items for a particular Catalog Type related language view

SELECT A.JPM_CAT_TYPE , A.EFFDT , A.JPM_CAT_ITEM_ID , B.LANGUAGE_CD , B.JPM_DESCR90 , B.DESCRSHORT , A.JPM_TEXT254_1 , B.DESCRLONG FROM PS_JPM_CAT_ITEMS A , PS_JPM_CAT_ITM_LNG B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.EFFDT = B.EFFDT AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID

  • Related Language Record for JPM_CAT_ITMVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_CAT_TYPE2 Character(12) VARCHAR2(12) NOT NULL Secondary content item type (as in a related item- such as a child or a supporting item of another item).
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 JPM_CAT_ITEM_ID2 Character(12) VARCHAR2(12) NOT NULL Secondary content item id (as in a related item- such as a child or a supporting item of another item).
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 JPM_TEXT254_1 Character(254) VARCHAR2(254) NOT NULL User Text - 254 Char
    8 DESCRLONG Long Character CLOB Long Description