| SSR_BASXLAT_LVW(SQL View) | Index Back | 
|---|---|
| Related lang view for acad carUsed as a related language record for academic career translate values. | 
| SELECT %Substring(A.FIELDVALUE,1,3) , A.EFFDT , A.LANGUAGE_CD , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'GRADING_BASIS' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | School Grading Basis | |
| 2 | Date(10) | DATE | Effective Date Default Value: %date | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |