S_OH_STU_COMMON_SNAP_C (ver 16.7.0)
This table is a child table of the [STUDENTS] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(10,0) | Primary Key. |
| SnapShotRunID | 16.7.0 | Number(11,0) | A unique ID assigned to an individual snapshot to distinguish snapshots, when multiple snapshots are completed. |
| StudentsDCID | 16.7.0 | Number(10,0) | Foreign key that relates the child table back to the STUDENTS table. |
| Alternative_Assessment | 16.7.0 | VarChar2(20) | Indicates the student's assessment type, as of the snapshot. |
| Building_IRN | 16.7.0 | VarChar2(20) | The IRN of the building the student is to be associated, as of the snapshot. |
| Distance_Transported | 16.7.0 | VarChar2(2) | The distance the student was transported, as of the snapshot. |
| Is_Gifted | 16.11.0 | Number(1,0) | Indicates if the student has been identified as gifted, as of the snapshot |
| Is_Served | 16.11.0 | Number(1,0) | Indicates if the student was being served for giftedness, as of the snapshot |
| Grad_Only | 16.10.0 | Number(1,0) | Indicates if the student is to be reported for graduation purposes only, as of the snapshot |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |
| Transportation | 16.7.0 | VarChar2(5) | Indication of whether the student was transported, by day, during the required time frame, as of the snapshot. |