S_VA_SchoolsAttended_S (ver 17.6.0)
This table is a standalone table and stores schools attended data.
Column Name | Version | Data Type | Description |
unique_id | 17.6.0 | Number(11,0) | Record ID |
schoolID | 17.6.0 | Number(11,0) | School ID |
foreignKey | 17.6.0 | Number(11,0) | Reserved for future use. |
foreignKey_alpha | 17.6.0 | Varchar2(31) | Reserved for future use. |
School_Number | 17.6.0 | Varchar2(30) | School Number |
School_Name | 17.6.0 | Varchar2(50) | School Name |
| School_Address | 17.6.0 | Varchar2(50) | School Address |
| School_City | 17.6.0 | Varchar2(35) | School City |
| School_State | 17.6.0 | Varchar2(2) | School State |
| School_Zip | 17.6.0 | Number(11,0) | School Zip |
| School_Email | 17.6.0 | Varchar2(35) | School Email |
| School_Phone | 17.6.0 | Varchar2(12) | School Phone |
| sort_by | 17.6.0 | Varchar2(30) | Sort value |