EPO_JCAT_IT_GVW

(SQL View)
 Index Back

Catalog Items - Content Group

ePerformance Objective Management Interface view for JPM Catalog Items. Used to map the fields in the JPM Catalog Item record to the fields used as Objective Page Items. This view lists items that belong to a Content Group. This has a left join to the JPM groups.

SELECT A.JPM_CAT_TYPE ,B.JPM_CAT_GROUP_TYPE ,B.JPM_CAT_GROUP , A.JPM_CAT_ITEM_ID , A.EFFDT , A.EFF_STATUS , %Substring(A.JPM_DESCR90, 1, 60) , A.JPM_DATE_1 , A.JPM_TEXT1325_1 , A.JPM_TEXT1325_2 FROM PS_JPM_CAT_ITEMS_I A LEFT 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: EPO_JCAT_IT_LVW

    • # 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 EP_ITEM_DUE_DT Date(10) DATE Date that an item is due.
    9 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance
    10 EP_MEASURE Long Character CLOB 1325 Character Item measurement description