S_NC_RPT_SAR_PERSUMM_TBL (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report Personnel Summary 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 |
| CLASS_MIN | 13.6.0 | VARCHAR2(50) | The number of minutes this section meets. |
| CLASS_PERCENT | 13.6.0 | VARCHAR2(50) | The percentage of time this staff person is associated to the section. |
| CORE_EXC_REQ | 13.6.0 | VARCHAR2(20) | Indicates if this is a core exceptionality requirement. |
| CORE_SUB_REQ | 13.6.0 | VARCHAR2(20) | Indicates if this si a core subject requirement. |
| COURSE_NAME | 13.6.0 | VARCHAR2(200) | The course name of the section. |
| COURSE_NUMBER | 13.6.0 | VARCHAR2(30) | The course number of the section. |
| EC_POPULATION | 13.6.0 | VARCHAR2(200) | Indicates the primary disability codes of students in this section. |
| ETHNICITY_RACE | 13.6.0 | VARCHAR2(200) | The ethnicity description for the staff person on this record. |
| GENDER | 13.6.0 | VARCHAR2(50) | The gender of the staff person on this record. |
| 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 record. |
| MAX_ENROLL | 13.6.0 | NUMBER(10,0) | The maximum number of students allowed in this section. |
| NONCORE_EXC_REQ | 13.6.0 | VARCHAR2(20) | Indicates if this is a non-core exceptionality requirement. |
| NONCORE_SUB_REQ | 13.6.0 | VARCHAR2(20) | Indicates if this is a non-core subject requirement. |
| 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) | The section number of this section. |
| SSN | 13.6.0 | VARCHAR2(15) | The social security number of the staff person on this record. |
| STAFF_DUTY | 13.6.0 | VARCHAR2(200) | The description of all of the staff duty codes for the staff person on this record. |
| 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_MIN | 13.6.0 | VARCHAR2(50) | The number of minutes the staff duty is assigned. |
| STAFF_NAME | 13.6.0 | VARCHAR2(200) | The name of the staff person on this record. |
| STAFF_PERCENT | 13.6.0 | VARCHAR2(50) | The percent of the staff's time spent on this staff duty. |
| STAFF_ROLE | 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 description of the role of the teacher on this record. |
| STAFF_UID | 13.6.0 | VARCHAR2(20) | The state staff number for the teacher on this record. |
| 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. |