EP_SUB_COMP_TBL

(SQL View)
 Index Back

Sub-Competency Table

Sub-Competency - Used to further define a competency. Usually a sub-competency is a KPI or behavior of a competency. Release 9 Job Profile Management (JPM): Table became a view to JPM data. Ownership of table transferred from ePerformance Management to JPM.

SELECT %Substring(A.JPM_CAT_ITEM_ID,1,8) ,B.JPM_CAT_ITEM_ID ,%Substring(B.JPM_DESCR90,1,60) ,B.EP_SUB_LEVEL ,B.JPM_TEXT1325_1 FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_ITEMS B WHERE A.JPM_CAT_TYPE = 'COMPETENCY' AND A.JPM_CAT_TYPE2 = 'SUB_COMP' AND B.JPM_CAT_TYPE = 'SUB_COMP' AND A.JPM_CAT_ITEM_ID2 = B.JPM_CAT_ITEM_ID AND A.JPM_EFFDT = ( SELECT MAX(C.JPM_EFFDT) FROM PS_JPM_CAT_I_RLAT C WHERE C.JPM_CAT_TYPE = 'COMPETENCY' AND C.JPM_CAT_TYPE2 = 'SUB_COMP' AND C.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND C.JPM_CAT_ITEM_ID = A.JPM_CAT_ITEM_ID AND C.JPM_CAT_ITEM_ID2 = A.JPM_CAT_ITEM_ID2 AND C.JPM_EFFDT <= %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_JPM_CAT_ITEMS D WHERE D.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND D.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND D.EFFDT <= %CurrentDateIn)

  • Related Language Record: EP_SUBCOMP_LANG

  • Parent record: COMPETENCY_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    2 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
    3 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    4 EP_SUB_LEVEL Character(1) VARCHAR2(1) NOT NULL Sub-Competency level

    Prompt Table: JPM_EP_SUBLV_I

    5 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance