iNHDEX Student Class

Contents

Introduction

This report produces a Student Class Submission for the iNHDEX.

Selection Criteria

Selection criteria determine which database records are used in the report. For the iNHDEX Beginning of Year Submission, student enrollment records are selected.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.
The school is not excluded from state reporting.

Course Selection

The report selects which course records to use based on the following criteria:

The course is not excluded from i.4.see submissions.
The course was active within the data range specified in the Start and End Date fields on the report page.

Section Selection

The report selects which course section to use based on the following criteria:

The section is not excluded from i.4.see submissions.

Teacher Selection

The report selects which teachers to include in the Teacher selection field on the report input page, based on the following criteria:

The teacher is assigned to an included section in the selected term and has students enrolled in the section.

Student Selection

The report selects which student records to use based on the following criteria:

The student is not excluded from state reporting.

The student is not excluded from i.4.see submissions.

Back to Top

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Teachers	Select All Teachers to run for all teachers in the School or District. Select a Teacher to run the report for a single Teacher. To select multiple teachers, hold the Ctrl key and click on the Teachers to be included in the report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2022 @ 10 AM : 05.
Report Start Date	Enter the first date in the date range for this report. A course must be active on or after this date to be included on the report.
End Date	Enter the last date in the date range for this report. A course must be active on or before this date to be included on the report.
Course Grade Field Options	If Use is set to Current School Only, you can complete the following option to report course grades for the current school. You cannot report course grades if this report is run at the District level.
Do you want to report the course grade?	Click to select Yes to include the course grades in the extract.
Select a grade type	Click to select the grade type from the list provided. If Numeric is chosen, the Course Grade ID column can only contain 1-3 alphanumeric characters and the numeric grade will truncate the decimal places.
Enter Store Code which holds the course grade to be reported	Type the store codes, separated by a comma, that hold the course grades you want to include on the report. If you leave this field blank, the course grades are not included on the report.

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.

Data Element	Description	[Table]FieldName	Field Type	Field Length
sauNbr	This field contains the school administrative unit number assigned to the school submitting the report. This field is extracted from the Start Page > District Setup > District Information.	[Prefs]NH_SAUNBR	Numeric	3
distNbr	This field contains the number of the district submitting the report. This field is extracted from the Start Page > District Setup > District Information.	[Schools]District_Number OR [Prefs]Name-districtnumber	Numeric	3
schoolNbr	This field contains the number of the school submitting the report. This field is extracted from the Alternate School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. If the Alternate School Number field is blank, this field is extracted from the School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[Schools]Alternate_School_Number Or [Schools]School_Number	Numeric	5
Student Name	If 'Yes' is selected in the 'Include Student Names' parameter, this column will appear with the student name in Last First Middle order. This a not a State Data Element for the report but is an option for the purpose of verification. If running this report for the i4see Enrollment Submission, this column should not be in the file.	[Students]LastFirst	Alpha-numeric	150
sasId	This field contains SASID assigned to this student by the New Hampshire Department of Education. This field is extracted from the Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements.	[Students]State_StudentNumber	Numeric	10
dob	This field contains the student’s date of birth. This field is extracted from the Start Page > Student Selection > General Demographics.	[Students]DOB	Date	8
localClassCode	This field contains the course code your school or district uses to identify this course. This field is extracted from the Edit Section page, Start Page > School Setup > Course > Edit Section.	[Sections]Course_Number OR [S_NH_SEC_X]localClassCode	Alpha-numeric	10
courseGradeId	This field contains the grade the student received for this course. This field is extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. Optionally, you can also elect to select or enter the Grade Option, Grade Type, and Store Codes in the Course Grade Options section of the report interface.	[StoredGrades]Grade OR [StoredGrades]Percent	Alpha-numeric	3
sectionId	This field contains the section number of this course. This field is extracted from the Edit Section page, Start Page > School Setup > Course > Edit Section.	[Sections]Section_Number	Alpha-numeric	10
termId	This field contains the term ID assigned to the course section on the Edit Section page, Start Page > School Setup > Course > Edit Section. If the term ID for the course section is blank, the term ID assigned to the course is extracted from the Edit Course page, Start Page > District Setup > Edit Course.	[S_NH_SEC_X]TermID OR [S_NH_CRS_X]TermID	Alpha-numeric	2
participationType	Calculated from the Enrollment Status: When Enrollment Status is 21, 22, 23, 25, 26, 27 or blank then report 1. When Enrollment Status is 29 then report 2. Any other Enrollment Status then report 3.	[S_NH_STU_X]Enrollment_Status OR [S_NH_REN_X]Enrollment_Status	Alpha-numeric	1
competenciesCompleted	Not submitted, null.	N/A	N/A	N/A
creditsAvail	Not submitted, null.	N/A	N/A	N/A
pctComplete	Not submitted, null.	N/A	N/A	N/A