EP_SUB_PROF_TBL

(SQL View)
 Index Back

Sub-Competency Proficiency

Sub-Competency Proficiency - Describes a level of proficiency for a sub-competency.

SELECT A.JPM_CAT_ITEM_ID ,B.JPM_CAT_ITEM_ID ,B.REVIEW_RATING ,%Substring(B.DESCRLONG,1,254) FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_ITEM_RD 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 B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_CAT_ITEM_RD X WHERE B.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND X.EFFDT <= %CurrentDateIn) AND A.JPM_EFFDT = ( SELECT MAX(Y.JPM_EFFDT) FROM PS_JPM_CAT_I_RLAT Y WHERE A.JPM_CAT_TYPE = Y.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = Y.JPM_CAT_ITEM_ID AND A.JPM_CAT_TYPE2 = Y.JPM_CAT_TYPE2 AND A.JPM_CAT_ITEM_ID2 = Y.JPM_CAT_ITEM_ID2 AND Y.JPM_EFFDT <= %CurrentDateIn)

  • Related Language Record: EP_SUBPROF_LANG

  • Parent record: EP_SUB_COMP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
    2 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
    3 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

    Prompt Table: REVW_RATING_TBL

    4 EP_PROF_STATEMENT Character(254) VARCHAR2(254) NOT NULL Proficiency statement