S_NC_RPT_SAR_SUMMARY_TBL (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report Class Summary view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACADEMIC_LEVEL | 13.6.0 | VARCHAR2(200) | The description of the the academic level of the course 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 |
| AMERICANIN_FEMALES | 13.6.0 | NUMBER(10,0) | The number of American Indian females in this section. |
| AMERICANIN_MALES | 13.6.0 | NUMBER(10,0) | The number of American Indian males in this section. |
| ASIAN_FEMALES | 13.6.0 | NUMBER(10,0) | The number of Asian females in this section. |
| ASIAN_MALES | 13.6.0 | NUMBER(10,0) | The number of Asian males in this section. |
| BLACK_FEMALES | 13.6.0 | NUMBER(10,0) | The number of Black females in this section |
| BLACK_MALES | 13.6.0 | NUMBER(10,0) | The number of Black males in this section. |
| COURSE_ATTRIBUTES | 13.6.0 | VARCHAR2(2000) | Indicates the attributes that apply to the course number on this record (External Provider, Third party Provider, Delivery Mode, Credit Recovery, Course Length, How Taken) |
| COURSE_NAME | 13.6.0 | VARCHAR2(200) | The course name for this section. |
| COURSE_NUMBER | 13.6.0 | VARCHAR2(30) | The course number for this section. |
| EC_POPULATION | 13.6.0 | VARCHAR2(200) | All of the Exceptionality codes for students in this section. |
| GRADE_RANGE | 13.6.0 | VARCHAR2(20) | The grade range of students enrolled in this section. |
| HISPANIC_FEMALES | 13.6.0 | NUMBER(10,0) | The number of Hispanic females in this section. |
| HISPANIC_MALES | 13.6.0 | NUMBER(10,0) | The number of Hispanic males 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. |
| PACIFIC_FEMALES | 13.6.0 | NUMBER(10,0) | The number of Pacific Islander females in this section. |
| PACIFIC_MALES | 13.6.0 | NUMBER(10,0) | The number of Pacific Islander males 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_ATTRIBUTES | 13.6.0 | VARCHAR2(2000) | Indicates the attributes that apply to the section attributes on this record (External Provider, Third party Provider, Delivery Mode, Credit Recovery, Course Length, How Taken) |
| 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 on this record. |
| STAFF_DUTY_DESC | 13.6.0 | VARCHAR2(200) | The description of all of the staff duty codes for the staff on this record. |
| STAFF_NAME | 13.6.0 | VARCHAR2(200) | The name of the staff person associated to this section/record. |
| STAFF_ROLE | 13.6.0 | VARCHAR2(200) | The role of the staff person associated to this section/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_SSN | 13.6.0 | VARCHAR2(500) | The social security number(s) of the staff on this section. |
| STAFF_UID | 13.6.0 | VARCHAR2(500) | The state staff number(s) for the staff 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 that this section is taught. |
| TOTAL_AIG | 13.6.0 | NUMBER(10,0) | The total number of students in this section identified as Academically and Intellectually Gifted. |
| TOTAL_PRIMARYEC | 13.6.0 | NUMBER(10,0) | The total number of students in this section identified with an Exceptional Childhood code. |
| TOTAL_STUDENTS | 13.6.0 | NUMBER(10,0) | The total number of students in the section. |
| TWO_FEMALES | 13.6.0 | NUMBER(10,0) | The total number of Multiple Ethnicity females in this section. |
| TWO_MALES | 13.6.0 | NUMBER(10,0) | The total number of Multiple Ethnicity males in this section. |
| WHITE_FEMALES | 13.6.0 | NUMBER(10,0) | The total number of White females in this section. |
| WHITE_MALES | 13.6.0 | NUMBER(10,0) | The total number of White males in this section. |