HRS_ACMPC_TBL_I

(SQL View)
 Index Back

Accomplishment Table

The HRS_ACCOMP_TBL contains the organizations active competencies

SELECT %Substring(A.JPM_CAT_ITEM_ID,1,8) ,%Substring(A.JPM_DESCR90,1,30) ,A.DESCRSHORT ,A.RATING_MODEL FROM PS_JPM_CAT_ITEMS A WHERE A.JPM_CAT_TYPE IN('COMPETENCY') AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_CAT_ITEMS X WHERE A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND X.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: ACCOMP_TBL.DESCR

4 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model