Skip to main content
Skip table of contents


This table is a stand alone table that stores information used in the School Activity Report Personnel Summary View

Column Name


Data Type


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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.