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. |