CM_CLUSTER_ACMP

(SQL View)
 Index Back

Cluster Accomplishments

CM_CLUSTER_ACMP identifies the accomplishments of a competency cluster and the importance of each. 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 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( SELECT FIELDVALUE FROM PSXLATITEM WHERE FIELDNAME = 'ACCOMP_CATEGORY') 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)

  • 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: ACCOMP_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