EP_J_CAT_ITEMGV

(SQL View)
 Index Back

Catalog Items - Content Group

ePerformance Interface view for JPM Catalog Items. Used to map the fields in the JPM Catalog Item record to the fields used as ePerformance Items. Outer join to Content Group.

SELECT A.JPM_CAT_TYPE ,%COALESCE(B.JPM_CAT_GROUP_TYPE, ' ') ,%COALESCE(B.JPM_CAT_GROUP, ' ') , A.JPM_CAT_ITEM_ID , A.EFFDT , A.EFF_STATUS , %Substring(A.JPM_DESCR90, 1, 60) , A.RATING_MODEL , A.EP_SUB_LEVEL , A.JPM_DATE_1 , A.JPM_DATE_2 , A.JPM_TEXT1325_1 , A.JPM_TEXT1325_2 FROM PS_JPM_CAT_ITEMS_I A LEFT OUTER JOIN PS_JPM_CAT_GMEMB B ON A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID WHERE A.JPM_DESCR90 <> ' ' AND A.EFF_STATUS = 'A'

  • Related Language Record: EP_J_CAT_ITEMGL

    • # 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_J_CONTENT_GRP_T Character(15) VARCHAR2(15) NOT NULL Content Group Type
    3 EP_J_CONTENT_GROUP Character(12) VARCHAR2(12) NOT NULL Content Group
    4 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

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