COMPETENCY_LANG

(SQL View)
 Index Back

Related Lang-Competency Tbl

COMPETENCY_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)

  • Related Language Record for COMPETENCY_TBL

    • # 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 CLOB 1325 character description field used in ePerformance
    6 DESCRLONG Long Character CLOB Long Description