S_ON_STU_XML_SPED_C ver 20.10.2.0
This table is a child table of Students and stores Student Special Education segment information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 20.10.2.0 | Number(19) | Primary key |
StudentsDCID | 20.10.2.0 | Number(19) | Primary key that relates the extended table to the [Students] table |
Academic_Year | 20.10.2.0 | Varchar2(9 char) | The academic year of the submission |
| Action | 20.10.2.0 | Varchar2(6 char) | This is the action associated with this submission Valid values: ADD, UPDATE |
| BSID | 20.10.2.0 | Number(11) | Board School Identification number |
| Exceptionality_Type | 20.10.2.0 | Varchar2(6 char) | Used to uniquely identify the special education |
| Individual_Edu_Plan_Flag | 20.10.2.0 | Varchar2(6 char) | Flag indicator for individual education plan |
| IPRC_Review_Date | 20.10.2.0 | Date | Identification, Placement and Review Committee date |
| IPRC_Student_Flag | 20.10.2.0 | Varchar2(1 char) | Flag indicator for identification, placement and review committee |
| Main_Exceptionality_Flag | 20.10.2.0 | Varchar2(1 char) | Flag indicator for Special education funding |
| Non_Identified_Student_Flag | 20.10.2.0 | Varchar2(1 char) | Flag indicating if student is non-identified |
| Special_Edu_Plmnt_Type | 20.10.2.0 | Varchar2(6 char) | Special education placement type |
| Submission_Period_Type | 20.10.2.0 | Varchar2(20 char) | Submission period type |
| WhoCreated | 20.10.2.0 | Varchar2(100 char) | Who created the record |
| WhenCreated | 20.10.2.0 | Timestamp(6) | When record was created |
| WhoModified | 20.10.2.0 | Varchar2(100 char) | Who modified the record |
| WhenModified | 20.10.2.0 | Timestamp(6) | When was the record modified |