S_OH_SCH_SNAP_C (ver 16.7.0)
This table is a child table of the [SCHOOLS] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(10,0) | Primary Key. |
| SchoolsDCID | 16.7.0 | Number(10,0) | Foreign key that relates the child table back to the SCHOOLS table. |
| SnapShotRunID | 16.7.0 | Number(11,0) | A unique ID assigned to an individual snapshot to distinguish snapshots, when multiple snapshots are completed. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |
| High_Grade | 16.7.0 | Number(11,0) | Highest grade-level of education designated for the building, as of the snapshot. |
| Low_Grade | 16.7.0 | Number(11,0) | Lowest grade-level of education designated for the building, as of the snapshot. |
| State_ExcludeFromReporting | 16.7.0 | Number(1,0) | Indicator if the building is to be excluded from State reporting, as of the snapshot. |