MARKETHIGHEST_EDUC_LVLLANGUAGE_CDEFFDTHIGH_EDUCVW_LNG(SQL View) |
Index Back |
|---|---|
Rellang Xlat HIGH_EDUC_LVL vwThis is the related language view for HIGH_EDUCLVL_VW |
| SELECT DISTINCT %Substring(c.fieldvalue, 1, 3) , %Substring(a.fieldvalue, 1, 2) , a.LANGUAGE_CD , a.effdt , a.xlatlongname , a.xlatshortname FROM PSXLATITEMLANG A , PSXLATITEMLANG C WHERE a.fieldname = 'HIGHEST_EDUC_LVL' AND ((a.fieldvalue >= 'A' AND a.fieldvalue <= 'Z' AND c.fieldvalue = 'GBL') OR (a.fieldvalue >= '01' AND a.fieldvalue <= '99' AND c.fieldvalue = 'USF') ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 2 | HIGHEST_EDUC_LVL |
Character(2) | VARCHAR2(2) NOT NULL | Highest Education Level |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |