EP_SUB_LANG_VW

(SQL View)
Index Back

SubCompetency Item View

SubCompetency Item View is used to convert sub-competencies into items for use in the ePerformance sections, templates, and reviews.

SELECT COMPETENCY , EP_SUB_ID , LANGUAGE_CD , EP_TITLE , EP_DESCR254 FROM PS_EP_SUBCOMP_LANG

  • Related Language Record for EP_SUB_ITEM_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    2 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    5 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance