S_OH_SCH_PHYSED_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. |
| Advanced | 16.7.0 | Number(11,0) | Count of students performing at the advanced level, as of the snapshot. |
| Exclude | 16.7.0 | Number(1,0) | Indicates the grade band is not present at this building, as of the snapshot. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |
| Grade_Band | 16.7.0 | VarChar2(2) | Indicates the building's grade band, as of the snapshot. |
| Limited | 16.7.0 | Number(11,0) | Count of students performing at the limited level, as of the snapshot. |
| Not_Applicable | 16.7.0 | Number(1,0) | Indicates that the grade band is not evaluated, as of the snapshot. |
| Not_Evaluated | 16.7.0 | Number(11,0) | Count of students not evaluated at the indicated grade band, as of the snapshot. |
| Proficient | 16.7.0 | Number(11,0) | Count of students performing at the proficient level, as of the snapshot. |