S_VA_DIVISION_SCHOOLS_C (ver 14.5.1)
This table is a standalone table for all VA state schools.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.5.1 | Number(10,0) | system generated primary key |
S_VA_DIVISIONS_SID | 14.5.1 | Number(10,0) | foreign key to the S_VA_Divisions_S |
SchoolNumber | 14.5.1 | Varchar2(20) | school number |
SchoolName | 14.5.1 | Varchar2(100) | school name |
SchoolAddress | 14.5.1 | Varchar2(79) | school address |
SchoolCity | 14.5.1 | Varchar2(79) | school city |
SchoolState | 14.5.1 | Varchar2(79) | school state |
SchoolZip | 14.5.1 | Varchar2(79) | school zip |
SchoolEmail | 14.5.1 | Varchar2(79) | school email |
SchoolPhone | 14.5.1 | Varchar2(31) | school phone |
SchoolNCESNumber | 14.5.1 | Varchar2(20) | NCES assigned school number |
IsActive | 14.5.1 | Number(1,0) | is active school |