Curriculum Extract

Contents

Introduction

The Curriculum extract is used to report course information on all teachers including elementary and preschool teachers. This is an NDE extract. This extract is used to meet the requirements for NCLB Qualified as well as reporting requirements for the American Recovery and Reinvestment Act on connecting students to course to classes to individual teachers. The extract is generated in a comma-delimited format.

Selection Criteria

Selection criteria determine which database records are used in the report.

Curriculum Selection

The Curriculum extract includes staff assignment records from the [S_NE_USR_StaffAssignment_C] table that meet the following criteria:

Staff members with an active Assignment Date during the reporting period.
Staff members whose assignment has not yet completed. In other words, the Completion Date is 0/0/0 or after the report end date.
Staff members who are associated with a school that is not excluded from state reporting.

Report Input

For help with navigation and report generation, see How to Find and Generate a Report.

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Run Date	Enter a date used to calculate the total students per session. Enter the last in session day of the term when reporting first semester course data. Enter the current date when reporting second semester of all year course data.
Semester for Year-Long Course	Choose the term for year-long courses. Elementary courses are tied to the default term.
Include Header	Choose Yes or No to indicate whether to display the header row in the extract. The header row displays the name of the field in each column of the report. Select No when generating the file for submission to the state.
Include Teacher Name	Choose Yes or No to generate a validation report. The validation report extracts the staff name, section number, and course name. Select No when generating the file for submission to the state.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Element #	Data Element	Description	[Table]FieldName
1	Record Number	Sequential number starting with 1 for every record in the file.	N/A
2	County	Two-digit NDE assigned county number.	[Prefs]Name=districtnumber [Prefs]Value
3	District	Four-digit NDE assigned district/system number.	[Prefs]Name=districtnumber [Prefs]Value
4	School	Three-digit NDE assigned school number.	[Schools]Alternate_School_Number, if available [Schools]School_Number [S_NE_USR_StaffAssignment_C]SchoolID=[Schools]School_Number
5	NDE_Staff_ID	Social Security Number of the teacher. Note: Dashes are not extracted.	[Users]SSN
6	Course_Code	Enter the course code from https://www.https://www.education.ne.gov/nce/education.ne.gov/nce/ Note: Include leading zeros on the 6-digit course code.	[Courses]alt_course_number
7	Grade_Taught_Code	Select the grade level or grade range of students taking the course.	[S_NE_USR_StaffAssignment_C] StaffAssignGrade
8	Special_Course_Indicator_Code	Select if the course is a special course. 0 = Not Applicable 2 = UNL Independent Study High 3 = Distance Learning The default value for this field is 0 if it is not populated.	[S_NE_CRS_X]Spec_Course_Code
9	Semester_Code	Select the code to indicate when the course is offered and the course length. 1 = 1^st Semester 2 = 2^nd Semester 3 = All year course The default value for this field is 3 if it is not populated.	[S_NE_SEC_X]Semester_Code
10	Minutes_Per_Session	Range 1-800. Enter the average number of minutes the class meets during the entire school year (excluding summer school).	[S_NE_SEC_X]Min_Per_Session
11	Sessions_Per_Year	Range 1-800.	Calculated
12	Total_Students	Range 1-999. The total number of students enrolled in the course. First semester courses determined from the last class session. Second semester or year-long courses determined as of the reporting date.	Calculated from CC record and bell schedule.
13	Dual Credit Total Students	This field is reported for Non-Public Schools only. Total number of students taking this course if the course is eligible for dual credit and the students earned both high school and postsecondary credit.	[S_NE_SEC_X]Dual_Credit_Code

Back to Top