S_OH_STU_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. |
| SchoolID | 16.7.0 | Number(11,0) | The State assigned school identifier. |
| 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. |
| DOB | 16.7.0 | Date | The student's date of birth, as of the snapshot. |
| Ethnicity | 16.7.0 | VarChar2(20) | Indicates if the student is identified as Hispanic, as of the snapshot. |
| FedEthnicity | 16.7.0 | Number(11,0) | Indicates the federal race designations to which the student identifies, as of the snapshot. |
| First_Name | 16.7.0 | VarChar2(50) | The student's first name, as of the snapshot. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |
| Gender | 16.7.0 | VarChar2(2) | The student's gender, as of the snapshot. |
| LastFirst | 16.7.0 | VarChar2(135) | The student's last name/first name, as of the snapshot. |
| Last_Name | 16.7.0 | VarChar2(50) | The student's last name, as of the snapshot. |
| Middle_Name | 16.7.0 | VarChar2(30) | The student's middle name, as of the snapshot. |
| Primary_Language | 16.7.0 | VarChar2(4000) | The student's primary language, as of the snapshot. |
| State_ExcludeFromReporting | 16.7.0 | Number(1,0) | Indicates if the student is to be excluded from State reporting, as of the snapshot. |