COMPETENCYPrompt Table: COMPETENCY_TBL
EP_SUB_IDLANGUAGE_CDEP_SUBCOMP_LANG(SQL View) |
Index Back |
|---|---|
Related Lang Sub-CompetencyRelated language record for Sub-Competency (EP_SUB_COMP_TBL) |
| SELECT %Substring(A.JPM_CAT_ITEM_ID,1,8) ,B.JPM_CAT_ITEM_ID ,LANGUAGE_CD ,%Substring(B.JPM_DESCR90,1,60) ,B.JPM_TEXT1325_1 FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_ITM_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 A.JPM_EFFDT = ( SELECT MAX(C.JPM_EFFDT) FROM PS_JPM_CAT_I_RLAT C WHERE C.JPM_CAT_TYPE = 'COMPETENCY' AND C.JPM_CAT_TYPE2 = 'SUB_COMP' AND C.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND C.JPM_CAT_ITEM_ID = A.JPM_CAT_ITEM_ID AND C.JPM_CAT_ITEM_ID2 = A.JPM_CAT_ITEM_ID2 AND C.JPM_EFFDT <= %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_JPM_CAT_ITM_LNG D WHERE D.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND D.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND D.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 2 | EP_SUB_ID |
Character(12) | VARCHAR2(12) NOT NULL | Sub-Item unique identifier |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 5 | EP_DESCR254 | Long Character(1325) | VARCHAR2(1325) | 1325 character description field used in ePerformance |