EP_J_CAT_IT_GTY

(SQL View)
 Index Back

Catalog Items-Content GrpType

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. This view lists items that belong to a Content Group Type.

SELECT A.JPM_CAT_TYPE ,B.JPM_CAT_GROUP_TYPE , 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 , PS_JPM_CAT_GMEMB B WHERE A.JPM_DESCR90 <> ' ' AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND A.EFF_STATUS = 'A'

  • Related Language Record: EP_J_CAT_IT_GTL

    • # 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_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    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_SUB_LEVEL Character(1) VARCHAR2(1) NOT NULL Sub-Competency level
    9 EP_ITEM_DUE_DT Date(10) DATE Date that an item is due.
    10 EP_ITEM_REMIND_DT Date(10) DATE Date to remind an item is due.
    11 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance
    12 EP_MEASURE Long Character CLOB 1325 Character Item measurement description