Skip to main content
Skip table of contents


This table is a stand alone table that stores information used in the School Activity Report Class Overage view.

Column Name


Data Type


ACADEMIC_LEVEL 13.6.0 VARCHAR2(200)The description of the the academic level based on the 5th digit of the course number. Values are:  0 - Modified Curriculum; 1 - Abridged/Adapted (Remedial); 2 - Standard Version; 3 - Applied/Technical; 4 - Advanced Placement/NCVPS; 5 - Honors/Advanced/Academically Gifted; 6 - Co-op Education; 7 - Advanced Placement; 8 - International Baccalaureate; 9 - Non-Classroom Activity
COURSE_NAME 13.6.0 VARCHAR2(200)The course name of the section that has too many students.
COURSE_NUMBER 13.6.0 VARCHAR2(30)The course number of the section that has too many students.
GRADE_LEVEL 13.6.0 VARCHAR2(30)Indicates the grade level that is used for this section record.if this is a PK course (P), High School Grades 9-13 (X), Middle School 6-8 (Y) or Elementary (Z). This is the 6th digit of the course number.
GRADE_RANGE 13.6.0 VARCHAR2(20)The grade range of students enrolled in this section.
INSTANCE_ID 13.6.0 NUMBER(10,0)The ID linking this row to a specific row in the CST_DSHReportSubmissions table.
LEA_ID 13.6.0 VARCHAR2(20)The LEA number for this student's enrollment record.
MAX_ENROLL 13.6.0 NUMBER(10,0)The maximum number of students allowed in this section.
NUMBER_OVER 13.6.0 NUMBER(10,0)The number of students over the maximum in this section.
PERIOD_DAY 13.6.0 VARCHAR2(80)The expression for this section.
RPT_RUN_ID 13.6.0 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_ID 13.6.0 NUMBER(10,0)Indicates the school number where this section is taught.
SECTION_NUMBER 13.6.0 VARCHAR2(50)Indicates the section number for this section.
STAFF_DUTY_CODE 13.6.0 VARCHAR2(20)The codes for all of the staff duty codes for the staff person on this record.
STAFF_DUTY_DESC 13.6.0 VARCHAR2(200)The description of all of the staff duty codes for the staff person on this record.
STAFF_NAME 13.6.0 VARCHAR2(200)The name of the teacher on this record.
STAFF_ROLE 13.6.0 VARCHAR2(200)The description of the role of the teacher on this record.
STAFF_ROLE_CODE 13.6.0 VARCHAR2(200)The codes for the roles of the of the staff for this section.
STAFF_ROLE_DESC 13.6.0 VARCHAR2(200)The descriptions of all of the roles of the staff for this section.
STAFF_UID 13.6.0 VARCHAR2(12)The state staff number for the teacher on this record.
SUBJECT_AREA 13.6.0 VARCHAR2(50)Indicates the subject area of the course which is the first 4 digits of the course number.
TERM 13.6.0 VARCHAR2(50)The term this section is taught.
TOTAL_STUDENTS 13.6.0 NUMBER(10,0)The total number of students in the section.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.