S_NC_RPT_AMC (ver 21.2.2)
This table is a stand alone table that stores information about the advance math enrollment of students that are reported on the Advanced Mathematics Course Enrollment (AMC) collection .
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACHIEVEMENT_LEVEL | 21.2.2 | VARCHAR2(20 CHAR) | Score in Achievement Level type test (V,LEVEL V,LEVEL 5). |
| ADVANCED_COURSE | 21.2.2 | VARCHAR2(2 CHAR) | It indicates if course type is advance math course (Y/N). |
| AIG_STATUS | 21.2.2 | VARCHAR2(2 CHAR) | It indicates if student is enrolled in AIG program (Y/N). |
| CURRENT_COURSE | 21.2.2 | VARCHAR2(11 CHAR) | It indicates current year math course number for a student. |
| EC_STATUS | 21.2.2 | VARCHAR2(2 CHAR) | It indicates Exceptional (EC) students (Y/N). |
| ENGLISH_LANGUAGE_STATUS | 21.2.2 | VARCHAR2(2 CHAR) | English Language Status (Y/N). |
| ETHNICITY | 21.2.2 | VARCHAR2(20 CHAR) | It indicates student's race. |
| GRADE_LEVEL | 21.2.2 | NUMBER(10,0) | Indicates the student's grade level. |
| HOMELESS_STATUS | 21.2.2 | VARCHAR2(2 CHAR) | It indicates student's Homeless status(Y/N). |
| MIGRANT_STATUS | 21.2.2 | VARCHAR2(2 CHAR) | It indicates student's Migrant status(Y/N). |
| PREVIOUS_COURSE | 21.2.2 | VARCHAR2(11 CHAR) | It indicates previous year math course number for a student. |
| PREVIOUS_COURSE_ASSESSMENT | 21.2.2 | VARCHAR2(35 CHAR) | It indicates previous course assessment name. |
| RPT_RUN_ID | 21.2.2 | NUMBER | 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. |
| SCHOOL_NAME | 21.2.2 | VARCHAR2(60 CHAR) | The name of the school |
| SCHOOL_NUMBER | 21.2.2 | NUMBER(10,0) | The school number. |
| SEX | 21.2.2 | VARCHAR2(2 CHAR) | Indicates student's Gender. |
| STUDENT_NAME | 21.2.2 | VARCHAR2(135 CHAR) | Student Name. |
| STUDENT_NUMBER | 21.2.2 | FLOAT | Student Number. |