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. |