HR_CP_COMP2_VW

(SQL View)
 Index Back

SELECT DISTINCT D.EMPLID , A.COMPETENCY , C.JPM_INTEGER_2 , C.JPM_INTEGER_1 , C.JPM_RATING1 , A.DESCR , A.RATING_MODEL , ' ' , ' ' FROM PS_COMPETENCY_TBL A , PS_JPM_JP_ITEMS C , PS_JPM_PROFILE D WHERE A.COMPETENCY = C.JPM_CAT_ITEM_ID AND C.JPM_CAT_TYPE IN ('COMPETENCY','NVQ UNIT') AND C.JPM_PROFILE_ID = D.JPM_PROFILE_ID AND C.RATING_MODEL = A.RATING_MODEL AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_JPM_JP_ITEMS C1 WHERE C.JPM_PROFILE_ID = C1.JPM_PROFILE_ID AND C.JPM_CAT_TYPE = C1.JPM_CAT_TYPE AND C.JPM_CAT_ITEM_ID = C1.JPM_CAT_ITEM_ID AND C.JPM_CAT_ITEM_QUAL = C1.JPM_CAT_ITEM_QUAL AND C.JPM_CAT_ITEM_QUAL2 = C1.JPM_CAT_ITEM_QUAL2 AND C1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAREER_COMPETENCY Character(12) VARCHAR2(12) NOT NULL Competency
3 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
4 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
5 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
8 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
9 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3