S_NC_AIG (ver 13.6.0)
This table is a child table of the Students table and stores Academically and Intellectually Gifted program information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AIG_Exceptionality_AM | 13.6.0 | Varchar2(1) | Indicates the student has an exceptionality for Math. |
AIG_Exceptionality_AR | 13.6.0 | Varchar2(1) | Indicates the student has an exceptionality for Reading. |
AIG_Exceptionality_IG | 13.6.0 | Varchar2(1) | Indicates the student has an exceptionality for Intellectually Gifted. |
Annual_Review_Date | 13.6.0 | Date | This is no longer collected in this table. |
Comment_Text | 13.6.0 | Varchar2(512) | This is no longer collected in this table. |
Endcode_LEA_Criteria | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Endcode_Parent_Request | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
End_Date | 13.6.0 | Date | This stores the date that the AIG identification ended for information on this record. This is automatically populated when a new event record is created with a new start date. |
Evidence_Other_Notes | 13.6.0 | Varchar2(1000) | This is no longer collected in this table. |
| Full_School_Name | 13.6.0 | Varchar2(150) | The name of the LEA/School where the services are received. |
| ID | 13.6.0 | Number(19,0) | Primary key |
Nomination_Date | 13.6.0 | Date | This is no longer collected in this table. |
Notes_Text | 13.6.0 | Varchar2(512) | This is no longer collected in this table. |
Placement_Date | 13.6.0 | Date | Notes for other identification evidence information. |
Referral_Date | 13.6.0 | Date | This is no longer collected in this table. |
School_ID | 13.6.0 | Number(11,0) | The School Number where the student is getting services. |
School_Name | 13.6.0 | Varchar2(60) | The School Name where the student is getting services. |
Select_Acceleration | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Class_Perf | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Cluster | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Consultation | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Coursework | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Exit_LEACriteria | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Exit_ParentGuard | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Family_Input | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Interview | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Other_Info | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Other_Program | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Plan | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Resource | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Separate | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Student_Input | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Student_Perf | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Student_Portfolio | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Teacher_Input | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Test_Normed | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Test_Other | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Test_School | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Select_Test_State | 13.6.0 | Varchar2(1) | This is no longer collected in this table. |
Start_Date | 13.6.0 | Date | This is the date that the identification for this record began. It is identified as the School Placement Date on the AIG Program page for this record. The very first date is displayed at the top of this page as the Initial Identification date. |
| StudentsDCID | 13.6.0 | Number(19,0) | Foreign key that links to the students table. |
Text_Acceleration | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Class_Perf | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Cluster | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Consultation | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Coursework | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Family_Input | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Interview | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Other_Info | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Other_Program | 13.6.0 | Varchar2(512) | This is no longer collected in this table. |
Text_Plan | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Resource | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Separate | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Student_Input | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Student_Perf | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Student_Portfolio | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Teacher_Input | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Test_Normed | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Test_Other | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Test_School | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Text_Test_State | 13.6.0 | Varchar2(128) | This is no longer collected in this table. |
Withdrawal_Code | 13.6.0 | Varchar2(5) | This is the reason code for the student's withdrawal from AIG. |
| Withdrawal_Date | 13.6.0 | Date | This is the date that the student withdrew from the AIG program. |