MARKETHIGHEST_EDUC_LVLEFFDTA=Active
I=Inactive
Default Value: A
HIGH_EDUCLVL_VW(SQL View) |
Index Back |
|---|---|
Xlat Highest Education Lvl vwA view on the Highest Education Level Xlat values, which only returns the values between 'A' and 'Z' to support the core HR application. |
| SELECT DISTINCT %Substring(c.fieldvalue, 1, 3) , %Substring(a.fieldvalue, 1, 2) , a.effdt , a.eff_status , a.xlatlongname , a.xlatshortname FROM PSXLATITEM A , PSXLATITEM 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 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |