COMPETENCYLANGUAGE_CDCOMPETENCY_LANG(SQL View) |
Index Back |
|---|---|
Related Lang-Competency TblCOMPETENCY_LANG is the language record related to COMPETENCY_TBL. A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| SELECT %Substring(A.JPM_CAT_ITEM_ID,1,8) ,LANGUAGE_CD ,%Substring(A.JPM_DESCR90,1,30) ,A.DESCRSHORT ,A.JPM_TEXT1325_1 ,A.DESCRLONG FROM PS_JPM_CAT_ITM_LNG A WHERE A.JPM_CAT_TYPE IN ('COMPETENCY','NVQ UNIT') AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_CAT_ITM_LNG X WHERE A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND A.LANGUAGE_CD = X.LANGUAGE_CD AND X.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | EP_DESCR254 | Long Character(1325) | VARCHAR2(1325) | 1325 character description field used in ePerformance |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |