EP_J_CAT_IT_L_I

(SQL View)
 Index Back

Catalog Items: Item Map RLang

ePerformance Interface view for JPM Catalog Items Related Language record. Used to map the fields in the JPM Catalog Item record to the fields used as ePerformance Items.

SELECT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.EFFDT , B.LANGUAGE_CD , A.EFF_STATUS , %Substring(B.JPM_DESCR90, 1, 60) , A.RATING_MODEL , A.JPM_DATE_1 , A.JPM_DATE_2 , B.JPM_TEXT1325_1 , B.JPM_TEXT1325_2 FROM PS_JPM_CAT_ITEMS_I A , PS_JPM_CAT_ITM_L_I B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND A.EFFDT = B.EFFDT AND B.JPM_DESCR90 <> ' '

  • Related Language Record for EP_J_CAT_ITEM_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_J_ITEM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific version of the JPM Catalog Type field.
    2 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    7 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
    8 EP_ITEM_DUE_DT Date(10) DATE Date that an item is due.
    9 EP_ITEM_REMIND_DT Date(10) DATE Date to remind an item is due.
    10 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 1325 character description field used in ePerformance
    11 EP_MEASURE Long Character(1325) VARCHAR2(1325) 1325 Character Item measurement description