S_NC_RPT_SAR_CLASSSIZE (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report Class Size view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ALT_LEAD_COUNT | 13.6.0 | NUMBER(10,0) | The calculated value of number of lead teachers after considering sections taught at the same time by the same teacher. |
| ALT_ROW_NUM | 13.6.0 | NUMBER(10,0) | Indicates the alternate row number within the course/section grouping after considering sections taught at the same time by the same teacher. |
| ALT_STU_COUNT | 13.6.0 | NUMBER(10,0) | The calculated value of number of students in the section after considering sections taught at the same time by the same teacher. |
| COURSE_HIGH | 13.6.0 | NUMBER(11,0) | Indicates the high grade level indicator for this course. |
| COURSE_LOW | 13.6.0 | NUMBER(11,0) | Indicates the low grade level indicator for this course. |
| COURSE_NUM | 13.6.0 | VARCHAR2(11) | The course number for this record. |
| COURSE_NUM_CLASS | 13.6.0 | VARCHAR2(100) | Indicates the course number to use if multiple courses are taught in this section. This is based on the majority of students in the section. |
| EC_CLASS | 13.6.0 | CHAR | Indicates if there are 80% or more of the students in this section are classified as EC. |
| GRADE_CATEGORY | 13.6.0 | VARCHAR2(20) | The grade category calculated for this section based on the majority of students in the section. |
| GRADE_RANGE | 13.6.0 | VARCHAR2(5) | The grade range of the students in this section. |
| GROUP_STR | 13.6.0 | VARCHAR2(100) | This concatenates several fields together for use with the collection. |
| INSTANCE_ID | 13.6.0 | NUMBER(10,0) | The ID linking this row to a specific row in the CST_DSHReportSubmissions table. |
| LEAD_COUNT | 13.6.0 | NUMBER(,) | The number of lead teachers for this section. This includes TE, TE2, TE3, and TE4 roles. |
| LEA_ID | 13.6.0 | VARCHAR2(20) | The LEA number for this section. |
| MATRIX_MEETING_CODE | 13.6.0 | VARCHAR2(80) | The expression for this section - period and day rotation. |
| NUM_AIG_STU | 13.6.0 | NUMBER(,) | The number of Academically & Intellectually Gifted students in this section. |
| NUM_EC_STU | 13.6.0 | NUMBER(,) | The number of Exceptional Children students in this section. |
| NUM_STU_GRADE | 13.6.0 | NUMBER(,) | The number of students in that grade for this section. |
| ROW_NUM | 13.6.0 | NUMBER(,) | Indicates the row number of this section within the course/section data. |
| 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) | The school number for this report. |
| SCHOOL_NAME | 13.6.0 | VARCHAR2(500) | The name of the school for this record. |
| SCHOOL_NUM | 13.6.0 | NUMBER(10,0) | The last 3 digits of the school number. |
| SECTION_NUM | 13.6.0 | VARCHAR2(10) | The section number for this record. |
| STAFF_ROLE | 13.6.0 | VARCHAR2(200) | The code for the staff role for the staff on this record. |
| STAFF_UID | 13.6.0 | VARCHAR2(20) | The state staff number for the staff on this record. |
| STATE_GRADE_CODE | 13.6.0 | VARCHAR2(20) | The state grade code for student sin this section. |
| TERM_ID | 13.6.0 | VARCHAR2(6) | The termid for this section. |
| TOTAL_LEAD_TEACHER | 13.6.0 | NUMBER(,) | The total number of lead teachers. |
| TOTAL_STU | 13.6.0 | NUMBER(,) | Indicates the total number of students in the section. |
| TYPICAL_CLASS | 13.6.0 | CHAR | Indicates this is a typical class. A typical class is not an EC class. It has a grade category of KI - 13. The class has the following attributes: Section External Provide is none or null; the Section Third Party Provider is none or null; the Section How Taken is Regular Day school or null; the Section Delivery Mode is Classroom or null; the Section Institution Code is default or null; and the Section Credit Recovery is No or null. The Course Low and Course High fields must be populated. |