CM_CLUSTER_COMP

(SQL View)
 Index Back

Cluster Competencies

CM_CLUSTER_COMP identifies the competencies of a competency cluster and the importance of each, and the desired employee proficiency. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

SELECT %Substring(B.JPM_LGCY_PRFL_ID,1,6) ,%Substring(A.JPM_CAT_ITEM_ID,1,8) ,A.JPM_IMPORTANCE ,0 ,A.JPM_RATING1 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.JPM_JP_TYPE = 'CLUSTER' AND A.JPM_CAT_TYPE IN('COMPETENCY','NVQ UNIT') AND A.EFFDT = ( SELECT MAX(Y.EFFDT) FROM PS_JPM_JP_ITEMS Y WHERE A.JPM_PROFILE_ID = Y.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = Y.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = Y.JPM_CAT_ITEM_ID AND Y.EFFDT <= %CurrentDateIn) AND A.JPM_ITEM_KEY_ID = ( SELECT MAX(X.JPM_ITEM_KEY_ID) FROM PS_JPM_JP_ITEMS X WHERE A.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND A.EFFDT = X.EFFDT)

  • Parent record: CM_CLUSTER_TBL

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

    Prompt Table: COMPETENCY_TBL

    3 CM_IMPORTANCE Character(1) VARCHAR2(1) NOT NULL Competency Importance
    1=1-Low
    2=2-Below Average
    3=3-Average
    4=4-Above Average
    5=5-High

    Default Value: 3

    4 CM_IMPORTANCE_NBR Number(3,0) SMALLINT NOT NULL Competency Importance

    Default Value: 3

    5 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL