XLAT_LVLED_VW(SQL View) |
Index Back |
|---|---|
SEVIS XLAT Level of Ed View |
| SELECT B.SEV_VISA_TYPE , %Substring(A.FIELDVALUE ,1,2) , A.EFFDT , A.EFF_STATUS , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A , PS_SEV_LVL_VSA_TBL B WHERE A.FIELDNAME = 'LVL_OF_EDUC' AND B.LVL_OF_EDUC = A.FIELDVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEV_VISA_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
SEVIS Visa Type
01=F-1 02=M-1 03=J-1 04=F-2 05=M-2 06=J-2 99=No Visa Type |
| 2 | LVL_OF_EDUC |
Character(2) | VARCHAR2(2) NOT NULL |
Level of Education
01=Primary 02=Secondary 03=Associate 04=Bachelors 05=Masters 06=Doctorate 07=Language training 08=High School 09=Flight training 10=Other vocational school 11=Other 99=No Valid Values |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 6 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |