S_NC_RPT_AIG_DETAIL (ver 13.6.0)
This table is a stand alone table that stores information about the detail of the Fall and Spring AIG Student Headcounts.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AIG_CODE | 13.6.0 | CHAR(2) | Indicates the Academically & Intellectually Gifted placement code for the student on the headcount date. |
| DUAL_EXCP | 13.6.0 | CHAR(1) | Indicates if the student has dual exceptionality. |
| ENTRYCODE | 13.6.0 | VARCHAR2(10) | The student's entry code from enrollment. |
| ENTRYDATE | 13.6.0 | DATE | The student's entry date in the AIG placement. |
| EXCP_MEMBER_DATE | 13.6.0 | DATE | The date the student's exceptionality started. |
| EXITCODE | 13.6.0 | VARCHAR2(10) | The student's exit code from the AIG placement. |
| EXITDATE | 13.6.0 | DATE | The student's exit date from the AIG placement. |
| GENDER | 13.6.0 | VARCHAR2(2) | The student's gender. |
| GRADE_CODE | 13.6.0 | VARCHAR2(4) | Indicates the student's PowerSchool grade level on the head count date. |
| HAS_FATALS | 13.6.0 | CHAR(1) | Indicates if the student has fatal errors at the time the report is generated. |
| PRIMARY_EXCP | 13.6.0 | VARCHAR2(50) | Indicates the student's primary exceptionality. |
| RPT_RUN_ID | 13.6.0 | NUMBER(10,0) | Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID. |
| RPT_VERSION | 13.6.0 | VARCHAR2(3) | Indicates if the report is for the Fall Headcount or the Spring Headcount. |
| SECOND_EXCP | 13.6.0 | VARCHAR2(50) | Indicates the student's secondary exceptionality if available. |
| STATE_ENTRYCODE | 13.6.0 | VARCHAR2(4) | Indicates the cross walk for the enrollment entry code to the state entry code for the student. |
| STATE_ETHNIC_CODE | 13.6.0 | VARCHAR2(1) | Indicates the student's state ethnic code. |
| STATE_EXITCODE | 13.6.0 | VARCHAR2(4) | Indicates the cross walk for the enrollment exit code to the state exit code for the student. |
| STATE_GRADE_CODE | 13.6.0 | VARCHAR2(4) | Indicates the state grade level code for the student. |
| STATE_STUDENTID | 13.6.0 | VARCHAR2(20) | Indicates the state student number for the student. |
| STUDENTID | 13.6.0 | NUMBER(,) | The internal student id. |