Classic View: NH State Reporting > i4see Extracts > Submission Course Report
Search Terms: i4see Extracts
The Submission Course Report collects teachers and courses data for courses available in the selected calendar. Only Primary Teachers are included; secondary teachers and other section staff are not reported.
Submission Course Report Extract Editor
Report Logic
- All Primary Teachers tied to a section for the year the report is generated report. Additional teachers tied to the section will not report.
- Once a calendar is selected on the Extract Editor, a report generates for that entire year.
- Start and/or End Dates are not considered for being included in the report.
- If the Exclude form State Reporting checkbox is marked, the course does not report.
- Only courses in which the student is actively enrolled report.
- Courses assigned a CIP code do not report.
Start and End Dates
- If a Start Date is entered on the Extract Editor, an End Date must also be entered. A warning message displays indicating the need for the End Date.
- If an End Date is entered on the Extract Editor, a Start Date must also be entered. A warning message displays indicating the need for the Start Date.
- If a Start Date or End Date is not entered, the extract will generate for the entire school year for the selected calendar(s).
Report Editor Options
Data Element |
Description |
|---|---|
Extract Type |
Indicates the type of extract selected. Different options may appear depending on the selection. |
Start Date |
Beginning date of the student enrollment records. Dates are entered in mmddyy format or can be selected by using the calendar icon. |
End Date |
End date of the student enrollment records. Dates are entered in mmddyy format or can be selected by using the calendar icon. |
Ad hoc Filter |
Selection of previously made filter that contains specific students to include in the label request. |
Report Format |
Determines how the request is generated - in the State Format (CSV) or HTML. Use the HTML format when reviewing data. Use the State Format when submitting the list to the state. |
Select Calendars |
At least one calendar must be selected in order for the extract to generate. Calendars are selected by the active year, by the school or by the year. Students in the chosen calendars are included in the extract. |
Generate the Report
- Select the Submission Course Report option from the Extract Type dropdown list.
- Enter the Start Date and End Date of the enrollment records to include.
- Select an Ad hoc filter from the dropdown list to reduce the amount of students included in the extract.
- Select the Report Format.
- Select the Calendars from which to pull students in the report.
- Click the Generate Extract button. The report will display in the selected format.
Submission Course Report Extract - HTML Format
Submission Course Report Extract - State Format (CSV)
Extract Layout
Data Element |
Description |
Type, Format and Length |
Campus Database |
Campus Interface |
|---|---|---|---|---|
SAU Number |
School Administrative Unit Number. |
Numeric, 3 digits |
School.SAUnumber |
System Administration > Resources > District Information > SAU Number |
District Number |
State-assigned district number. |
Numeric, 3 digits |
District.number |
System Administration > Resources > District Information > Number |
School Number |
District-assigned school number. |
Numeric, 5 digits |
School.number |
System Administration > Resources > School > Number |
Educator ID |
Primary teacher's license number. If the teacher does not have a license number, reports blank. |
Numeric, 10 digits |
Employment. licenseNumber |
Census > People > District Employment > License Number of Primary Teacher |
Course ID |
Indicates the Course ID state code. |
Numeric, 10 digits |
Course.number |
Scheduling > Courses > Course > Course Editor > State Code |
Section ID |
Indicates the section number. |
Numeric, 3 digits |
Section.number |
Scheduling > Courses > Section > Section Editor > Section Number |
Begin Date |
Identifies the start date based on the first term flagged within the selected calendar. |
Date field, 10 characters |
Term.startDate |
Scheduling > Courses > Section > Section Schedule Placement flag and System Admin > Calendar > Calendar > Terms |
End Date |
Identifies the end date based on the last term flagged within the selected calendar. |
Date field, 10 characters |
Term.endDate |
Scheduling > Courses > Section > Section Schedule Placement flag and System Admin > Calendar > Calendar > Terms |
School Year |
Identifies the school year. |
Numeric, 4 digits |
Calendar.year |
System Administration > Calendar > School Years > School Year Editor > End Year |
Term ID |
Indicates the Term ID code used to represent the term.
|
Numeric, 2 digits |
Calendar.term |
Scheduling > Courses > Section > Section Schedule Placement |
Credits |
Identifies the number of credits the course is worth. |
Numeric, 5 digits |
GradingTask Credit.credit |
Scheduling > Courses > Grading Tasks > Credit |
Primary Grade ID |
Indicates the primary grade level. |
Numeric, 2 digits |
CustomSection.value |
Scheduling > Courses > Section > Section Editor > Primary Grade Level |
Room Number |
Identifies the room number of the course. |
Alphanumeric, 5 characters |
Section.room |
Scheduling > Courses > Section > Section Editor > Room |
Local Class Code |
Identifies the course number. |
Numeric, 5 digits |
Course.number |
Scheduling > Courses > Course > Course Editor > Number |
Local Class Name |
Identifies the class name. |
Alphanumeric, |
Course.name |
Scheduling > Courses > Course > Course Editor > Name |
| SCED Common Course Code | Reports the 10-digit SCED Subject Area, SCED Course Identifier and SCED Course Level assigned to the course. This code prints as SCEDxxxxxY.
This only reports for high school level courses for students in grades 9-12 with Grade Level Codes of 9, 10, 11, 12 and 31. |
Numeric, 10 digits | Course.scedSubjectArea Course.scedCourseId Course.scedCourseLevel |
Scheduling > Courses > NCES Data > SCED Subject Area, SCED Course Identifier, SCED Course Level |
