S_NC_STU_AIGID_C (ver 13.6.0)
This table is a child table of the Students table that stores information about the Academically and Intellectually Gifted Identification information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ANNUAL_REVIEW_DATE | 13.6.0 | DATE | The date the next AIG review is due. |
| BEGIN_SERVICE_DATE | 13.6.0 | DATE | The date the service began for this plan. |
| END_DATE | 13.6.0 | DATE | The date the service ended for this plan. |
| EVIDENCE_OTHER_NOTES | 13.6.0 | VARCHAR2(1000) | Notes for other identification evidence information. |
| ID | 13.6.0 | NUMBER(10,0) | Primary key |
| INITIAL_REVIEW_DATE | 13.6.0 | DATE | The initial review date for this student's plan. |
| NOMINATION_DATE | 13.6.0 | DATE | The date the student was nominated for AIG. |
| PLACEMENT_DATE | 13.6.0 | DATE | The date the student was placed into the AIG program. |
| SCHOOLID | 13.6.0 | NUMBER(11,0) | The school id for this plan. |
| SCHOOL_NAME | 13.6.0 | VARCHAR2(60) | The name of the school for this plan. |
| SELECT_CLASS_PERF | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on class performance. |
| SELECT_FAMILY_INPUT | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on family input. |
| SELECT_INTERVIEW | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on a personal interview. |
| SELECT_OTHER_INFO | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on other information. |
| SELECT_STUDENT_INPUT | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on student input. |
| SELECT_STUDENT_PERF | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on student performance. |
| SELECT_STUDENT_PORTFOLIO | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on the student portfolio. |
| SELECT_TEACHER_INPUT | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on teacher input. |
| SELECT_TEST_NORMED | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on Normed test scores. |
| SELECT_TEST_OTHER | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on other test scores. |
| SELECT_TEST_SCHOOL | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on school test scores. |
| SELECT_TEST_STATE | 13.6.0 | VARCHAR2(1) | Indicates the student was selected based on state test scores. |
| START_DATE | 13.6.0 | DATE | The start date of the identification plan. |
| STUDENTSDCID | 13.6.0 | NUMBER(10,0) | Foreign key that links to the students table. |
| TEXT_CLASS_PERF | 13.6.0 | VARCHAR2(128) | Notes on the class performance. |
| TEXT_FAMILY_INPUT | 13.6.0 | VARCHAR2(128) | Notes on the family input. |
| TEXT_INTERVIEW | 13.6.0 | VARCHAR2(128) | Notes on the student interview. |
| TEXT_OTHER_INFO | 13.6.0 | VARCHAR2(128) | Notes on the other information. |
| TEXT_STUDENT_INPUT | 13.6.0 | VARCHAR2(128) | Notes on the student input. |
| TEXT_STUDENT_PERF | 13.6.0 | VARCHAR2(128) | Notes on the student performance. |
| TEXT_STUDENT_PORTFOLIO | 13.6.0 | VARCHAR2(128) | Notes on the student portfolio. |
| TEXT_TEACHER_INPUT | 13.6.0 | VARCHAR2(128) | Notes on the teacher input. |
| TEXT_TEST_NORMED | 13.6.0 | VARCHAR2(128) | Notes on the normed test scores. |
| TEXT_TEST_OTHER | 13.6.0 | VARCHAR2(128) | Notes on the other test scores. |
| TEXT_TEST_SCHOOL | 13.6.0 | VARCHAR2(128) | Notes on the school test scores. |
| TEXT_TEST_STATE | 13.6.0 | VARCHAR2(128) | Notes on the state test scores. |