ACCOMPLISHMENTLANGUAGE_CDHRS_ACCOMP_LANG(SQL View) |
Index Back |
|---|---|
Related Lang-Accomplishmnt TblHRS_ACCOMP_LANG is the language record related to HRS_ACCOMP_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) ,A.LANGUAGE_CD ,%Substring(A.JPM_DESCR90,1,30) ,A.DESCRSHORT ,A.JPM_DESCR90 FROM PS_JPM_CAT_ITM_LNG A WHERE A.JPM_CAT_TYPE IN('DEG', 'HON', 'LIC', 'LNG', 'MEM', 'NVQ', 'TST') 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 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
| 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 | NVQ_TITLE | Character(90) | VARCHAR2(90) NOT NULL | Title |