COMPETENCYEP_SUB_IDREVIEW_RATINGPrompt Table: REVW_RATING_TBL
LANGUAGE_CDEP_SUBPROF_LANG(SQL View) |
Index Back |
|---|---|
Sub-Competency ProficiencyRelated language record for Sub-Competency Proficiency (EP_SUB_PROF_TBL) |
| SELECT %Substring(A.JPM_CAT_ITEM_ID,1,8) ,%Substring(B.JPM_CAT_ITEM_ID,1,8) ,B.REVIEW_RATING ,B.LANGUAGE_CD ,%Substring(B.DESCRLONG,1,254) FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_IRD_LNG 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_IRD_LNG X WHERE B.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND B.REVIEW_RATING = X.REVIEW_RATING AND X.EFFDT <= %CurrentDateIn) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EP_PROF_STATEMENT | Character(254) | VARCHAR2(254) NOT NULL | Proficiency statement |