S_NC_RPT_SAR_OVERSUMM_TBL (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report Class Overage view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| 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. |