iNHDEX Enrollment
Contents
Introduction
This report produces a Beginning of Year Enrollment Submission for the iNHDEX.
Important: Your district must be on PowerSchool Version 6.0.0.1 or higher prior to submitting the iNHDEX Enrollment Submission so that the Federal ethnicity and race are included in the extract.
Selection Criteria
Selection criteria determine which database records are used in the report. For the iNHDEX Enrollment 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.
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 enrolled in the district (by default) or current school and their school enrollment is active during the date range specified.
School Enrollment Selection
The report selects which school enrollment records to use based on the following criteria:
The following fields are school enrollment level and are determined using the school enrollments during the date range specified:
SchoolNbr – School Number
EnrollmentStatus – Enrollment Status
Town Responsible – Town Financially Responsible for Education
District Responsible – District Financially Responsible for Education
EntryDate – Entry Date
EntryCode – Entry Code
ExitDate – Exit Date
ExitCode – Exit (withdrawal) Code
Grade – Grade
PostGradPlans – Post Graduation Plans
DiplomaType – Diploma Type
Parent_Military_Status - Parent Military Code
Additional School Level Settings
Default Exit Codes:
Default codes are for End of Year (EOY) submission only
On the School Info screen (District Management > District Setup > School Info > Select School) an option is added to allow a default exit code for each grade.
If exit code is blank for a student then the default exit code is used as defined on the School Info screen.
Graduation Date:
A field is added on the School Info screen (District Management > District Setup > School Info > Select School) for graduation date (EOY submission only).
If exit code is anything other than 11 then a graduation date is not sent.
If exit code is 11 (regardless of grade level) then a graduation date is provided as follows:
If the students exit date is less than the last day in session then use the student exit date. If not, then use the school level date field - graduation date.
If no graduation date is set at the school level then report blank.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | If run at the district level, choose one of the following:
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. |
Select Students | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Start Date | Enter the first date in the date range for this report. A student must have an active enrollment record equal to or later than this date to be included on the report. |
End Date | Enter the last date in the date range for this report. A student must have an active enrollment record prior to or equal to this date to be included on the report. |
Reporting Period | Select: BOY for the Beginning of Year Submission MOY for Middle of the Year Submission EOY for End of Year Submission |
Include Column Headings | Choose the option to include or not include column headings in the report. Note: If running this report for the i4see Enrollment Submission, do not include the column headings. |
Include Student Names | Choose the option to include or not include a column of student names in the report. The state file should not include the student names, the 'Yes' option is for verification purposes only. The default is set to ‘No’. Note: If running this report for the i4see Enrollment Submission, do not include the student names. |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run nightly, and then select the Weekdays only checkbox. |
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 | Begin / End Position |
sauNbr | SAU Number This field contains the school administrative unit number assigned to the school submitting the report. This field is extracted from District Management > District Setup > District Info. | [Prefs]NH_SAUNBR | Numeric | 3 | N/A |
distNbr | District Number This field contains the number of the district submitting the report. This field is extracted from from District Management > District Setup > District Info. | [Schools]District_Number OR [Prefs]Name-districtnumber | Numeric | 3 | N/A |
schoolNbr | School Number 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, District Management > District Setup > 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, District Management > District Setup > School Info > edit School. | [Schools]Alternate_School_Number Or [Schools]School_Number Or [S_NH_STU_X]School_Number_Override Or [S_NH_REN_X]School_Number_Override | Numeric | 5 | N/A |
sasID | Unique state assigned student ID. This field contains SASID assigned to this student by the New Hampshire Department of Education. This field is extracted from Student Selection > Compliance > iNHDEX Data Elements. | [Students]State_StudentNumber | Numeric | 10 | N/A |
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. | [Students]LastFirst | Alpha-numeric | 150 | N/A |
dob | Date of Birth This field contains the student’s date of birth. This field is extracted from Student Selection > Student Profile > Demographics. | [Students]DOB | Date | 8 | N/A |
grade | Grade Level This field contains the student’s grade level. This field is extracted from the Grade Level field under the New Hampshire State Reporting section on the Edit Current Enrollments page, Student Selection > School Enrollment > Enrollment History > edit enrollment. | [Students]Grade_Level OR [ReEnrollments]Grade_Level OR [S_NH_STU_X] State_GradeLevel OR [S_NH_REN_X]State_GradeLevel | Numeric | 2 | N/A |
enrollmentStatus | Enrollment Status This field contains the student’s current enrollment status. This field is extracted from Student Selection > School Enrollment > Enrollment History > edit enrollment. When the field is blank, the report defaults the status to ‘21’. | [S_NH_STU_X]Enrollment_Status OR [S_NH_REN_X]Enrollment_Status | Numeric | 2 | N/A |
entryDate | Entry Date This field contains the date the student enrolled in the school. This field is extracted from the Edit Current Enrollments page, Student Selection > School Enrollment > Enrollment History > edit enrollment. | [Students]EntryDate OR [ReEnrollments]EntryDate | Date | 8 | N/A |
entryCode | Entry Code This field contains the entry code the student enrollment. This field is extracted from the Edit Current Enrollments page, Student Selection > School Enrollment > Enrollment History > edit enrollment. | [Students]EntryCode OR [ReEnrollments]EntryCode | Alpha-numeric | 3 | N/A |
exitDate | Exit Date This field contains the date the student exited the school, if applicable. This field is extracted from the Edit Current Enrollments page, Student Selection > School Enrollment > Enrollment History > edit enrollment. | If Exit Code is not null then [Students]ExitDate - 1 day OR [ReEnrollments]ExitDate - 1 day OR [S_NH_SCH_X]Date_of_Graduation (EOY Only) - See Additional School Level Settings | Date | 8 | N/A |
exitCode | Exit Code This field contains the code identifying the reason the student exited the school, if applicable. This field is extracted from the Edit Current Enrollments page, Student Selection > School Enrollment > Enrollment History > edit enrollment. | [Students]ExitCode OR [ReEnrollments]ExitCode OR [S_NH_SCH_C]NH_State_ExitCode (EOY Only) - See Additional School Level Settings | Alpha-numeric | 3 | N/A |
districtResponsible | District Responsible This field contains the code identifying the school district financially responsible for the student’s education. This field is extracted from the Edit Current Enrollment page, Student Selection > School Enrollment > Enrollment History > edit enrollment. If the District Responsible field is blank, this district number is extracted from the District Information page, District Management > District Setup > District Info. | [S_NH_STU_X] District_Responsible OR [S_NH_REN_X]District_Responsible OR [Prefs]districtnumber | Numeric | 3 | N/A |
townResponsible | Town Responsible This field contains the code identifying the town financially responsible for the student’s education. This field is extracted from the Edit Current Enrollment page, Student Selection > School Enrollment > Enrollment History > edit enrollment. If the Town Responsible field is blank, this district number is extracted from the District Information page, District Management > District Setup > District Info. | [S_NH_STU_X]Town_Responsible OR [S_NH_REN_X]Town_Responsible OR [Prefs]districtnumber | Numeric | 3 | N/A |
fullDayPct | Full or Partial Grade Program Length This field contains the percent of the school week that is available for the Pre School and Kindergarten student. It indicates if the student is attending a full-time or part-time program. This field is extracted from the Current Enrollment page, Student Selection > School Enrollment > Enrollment History > edit enrollment. If Reporting Period is EOY then reported as null. | [S_NH_STU_X]FullDayPct OR [S_NH_REN_X]FullDayPct | Numeric | 3 | N/A |
diplomaType | Diploma Type This field identifies the type of diploma the student received, if the student graduated from the school. This field is extracted from the iNHDEX Data Elements page, Student Selection > Compliance > iNHDEX Data Elements. | If Exit Code = 11 Then [S_NH_STU_X]DiplomaType | Alpha-numeric | 2 | N/A |
postGradPlans | Post Graduation Plans This field contains the code identifying the student’s post-graduation plans. This field is extracted from the iNHDEX Data Elements page, Student Selection > Compliance > iNHDEX Data Elements. | If Exit Code = 11 Then [S_NH_STU_X]PostGradPlans | Alpha-numeric | 2 | N/A |
race | Race Calculation based on the combination of checkboxes selected and the value assigned to the Hispanic/Latino indicator on the Demographics page, Student Selection > Student Profile > Demographics. | [StudentsRace]RaceCd | Numeric | 2 | N/A |
ethnicity | Ethnicity This field contains the student’s ethnicity found on the Demographics page, Student Selection > Student Profile > Demographics. | [Students]fedethnicity = 1 THEN '1' ELSE '2' | |||
sex | Sex This field contains the student’s gender found on the Demographics page, Student Selection > Student Profile > Demographics. | [Students]Gender='F' THEN '2' WHEN stu.Gender='M' THEN '1' | |||
residentialHome | Residential Home This field identifies the group home in which the student resides, if the student resides in a group home. Otherwise, this field contains a 1. If Reporting Period is EOY then reported as null. | [S_NH_STU_X]ResidentialHome | Alpha-numeric | 2 | N/A |
parentMilitaryCd | Parent Military Code This field indicates the student's parent or guardian military status. This field is extracted from the iNHDEX Data Elements page, Student Selection > Compliance > iNHDEX Data Elements. | [S_NH_STU_X]Parent_Military_Status OR [S_NH_REN_X]Parent_Military_Status | Alpha-numeric | 1 | N/A |
fosterStatus | Foster Status Identifies if the student is in the foster system. This field is extracted from the iNHDEX Data Elements page, Student Selection > Compliance > iNHDEX Data Elements. | [S_NH_STU_X]Foster_Care | Numeric | 1 |