S_VA_SCH_CRDC_X (ver 16.6.0)
This table is an extension of the [Schools] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolsDCID | 16.6.0 | Number(10,0) | Foreign Key to Schools table. |
| AbilityGroupedMathERLA_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_AbilityGroupedMathERLA_YN |
| AlternativeSchoolOther_TF | 16.6.0 | Number(1,0) | Migrated from: [Schools]CRDC_AlternativeSchoolOther_TF |
| FTECounselors | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_FTECounselors |
| FTETeacherAbs10 | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_FTETeacherAbs10 |
| FTETeachersFirstYr | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_FTETeachersFirstYr |
| FTETeachersLicensed | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_FTETeachersLicensed |
| FTETeachersSecondYr | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_FTETeachersSecondYr |
| NonPersonelExpenditures | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_NonPerExpend |
| SchoolPart1Comments | 16.6.0 | Varchar2(500) | Migrated from: [Schools]CRDC_SchoolPart1Comments |
| SchoolPart2Comments | 16.6.0 | Varchar2(500) | Migrated from: [Schools]CRDC_SchoolPart2Comments |
| SingleSexClass_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_SingleSexClass_YN |
| TotalFTETeachers | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_TotalFTETeachers |
| TotalInstStaffSalary | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_TotalInstStaffSalary |
| TotalPersonnelSalary | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_TotalPersonnelSalary |
| TotalTeachersSalary | 16.6.0 | Number(25,10) | Migrated from: [Schools]CRDC_TotalTeachersSalary |
| UngradedHSAgeStudents_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_UngradedHSAgeStudents_YN |