i.4.see Enrollment Submission
Contents
Introduction
This report produces a Beginning of Year Enrollment Submission for the Initiative for School Empowerment and Excellence (i.4.see).
Important: Your district must be on PowerSchool Version 6.0.0.1 or higher prior to submitting the i.4.see 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 i.4.see 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.
- The student is not excluded from i.4.see submissions.
- The student must have a valid SASID if the Restrict students to those with a SASID check box is selected.
- When the Enrollment Status is '7' and the reporting period is Beginning of Year (BOY) or Anytime of Year (AOY) and the student exit date is before the date the report is being generated, then the Exit Date is the student exit date, otherwise the Exit Date is one day prior to the student exit date.
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:
- 50 – SchoolNbr – School Number
- 210 – EnrollmentStatus – Enrollment Status
- 220 – Town Responsible – Town Financially Responsible for Education
- 225 – District Responsible – District Financially Responsible for Education
- 230 – EntryDate – Entry Date
- 240 – EntryCode – Entry Code
- 250 – ExitDate – Exit Date
- 260 – ExitCode – Exit (withdrawal) Code
- 400 – Grade – Grade
- 510 – PromotedIndicator – Promoted Indicator
- 610 – PostGradPlans – Post Graduation Plans
- 620 – DiplomaType – Diploma Type
- 325 - Parent_Military_Status - Parent Military Code
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 AOY for Anytime of Year Submission EOY for End of Year Submission |
How hours will be Reported (Half Days/Hours) | Select Half Days or Hours If hours are selected, then the hours are calculated from the Instructional Hours Per Day field (School > Bell Schedule > Edit Bell Schedule > Bell Schedule Name > Instructional Hours Per Day). The hours are prorated based on the student’s absence/presence for each day. Since attendance is recorded in half days the hours reported will either be 100% of hours entered, 50% of hours entered, or 0% of hours entered. |
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.
Item # or Position | Data Element | Description | [Table]FieldName | Field Type | Field Length | Begin / End Position |
10 | 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 | N/A |
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. If running this report for the i4see Enrollment Submission, this column should not be in the file. | [Students]LastFirst | Alpha-numeric | 135 | N/A |
100 | Date of Birth | 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 | N/A |
420 | Race | Race is calculated based on the combination of checkboxes selected and the value assigned to the Hispanic/Latino indicator on the Demographics page, Start Page > Student Selection > General Demographics. | [StudentsRace]RaceCd | Numeric | 2 | N/A |
210 | Enrollment Status | This field contains the student’s current enrollment status. This field is extracted from Start Page > Student Selection > Transfer Information. | [S_NH_STU_X]Enrollment_Status OR [S_NH_REN_X]Enrollment_Status | Numeric | 2 | N/A |
30 | SAU Number | 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 | N/A |
40 | District Number | 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 | N/A |
50 | 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, 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 Or [S_NH_STU_X]School_Number_Override Or [S_NH_REN_X]School_Number_Override | Numeric | 5 | N/A |
220 | 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, Start Page > Student Selection > Transfer Information. If the Town Responsible field is blank, this district number is extracted from the District Information page, Start Page > District Setup > District Information | [S_NH_STU_X]Town_Responsible OR [S_NH_REN_X]Town_Responsible OR [Prefs]districtnumber | Numeric | 3 | N/A |
225 | 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, Start Page > Student Selection > Transfer Information. If the District Responsible field is blank, this district number is extracted from the District Information page, Start Page > District Setup > District Information | [S_NH_STU_X] District_Responsible OR [S_NH_REN_X]District_Responsible OR [Prefs]districtnumber | Numeric | 3 | N/A |
400 | Grade | 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, Start Page > Student Selection > Transfer Information. If this field is blank, the grade level decoded with the correct values for the report. | [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 |
405 | 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, Start Page > Student Selection > Transfer Information. If Reporting Period is EOY then reported as null. | [S_NH_STU_X]FullDayPct OR [S_NH_REN_X]FullDayPct | Numeric | 3 | N/A |
230 | Entry Date | This field contains the date the student enrolled in the school. This field is extracted from the Edit Current Enrollments page, Start Page > Student Selection > Transfer Information. | [Students]EntryDate OR [ReEnrollments]EntryDate | Date | 8 | N/A |
240 | Entry Code | This field contains the entry code the student enrollment. This field is extracted from the Edit Current Enrollments page, Start Page > Student Selection > Transfer Information. | [Students]EntryCode OR [ReEnrollments]EntryCode | Alpha-numeric | 3 | N/A |
250 | Exit Date | This field contains the date the student exited the school, if applicable. This field is extracted from the Edit Current Enrollments page, Start Page > Student Selection > Transfer Information. Note: When the Enrollment Status is '7' and the Reporting Period is Beginning of Year (BOY) or Anytime of Year (AOY) and the student exit date is before the date the report is being generated then the Exit Date is the student exit date, otherwise the Exit Date is one day prior to the student exit date. | If Reporting Period is EOY [Students]ExitDate - 1 day OR [ReEnrollments]ExitDate - 1 day If Reporting Period is BOY or AOY AND [S_NH_STU_X]Enrollment_Status = 7 or OR ELSE [Students]ExitDate - 1 day or [ReEnrollments]ExitDate - 1 day | Date | 8 | N/A |
260 | 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, Start Page > Student Selection > Transfer Information. | [Students]ExitCode OR [ReEnrollments]ExitCode | Alpha-numeric | 3 | N/A |
300 | Half Days in Attendance | This field contains the number of half days or hours the student was in attendance during the given school year. This field is calculated using the ADA ADM function. The total number of days the student was in attendance is multiplied by 2. | N/A | N/A | 3 | N/A |
310 | Half Days Absent | This field contains the number of half days or hours the student was absent during the given school year. This field is calculated using the ADA ADM function. The total number of days the student was in attendance is multiplied by 2. | N/A | N/A | 3 | N/A |
510 | Promoted Indicator | This field identifies the student’s promotion status. This field is extracted from the Edit Current Enrollments page, Start Page > Student Selection > Transfer Information. | If Reporting Period is BOY or AOY [S_NH_STU_X]promoted_indicator OR [S_NH_REN_X]promoted_indicator If Reporting Period is EOY If ExitCode and promoted_indicator is null, and Grade is 12 then 3 If ExitCode and promoted_indicator is null, and Grade is not 12 then 2 If ExitCode is Null or ExitCode is W11 then promoted_indicator If ExitCode is Not Null then Null
| Alpha-numeric | 1 | N/A |
620 | 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 i.4.see Data Elements page, Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements. | If Promoted Indicator =3 Then [S_NH_STU_X]DiplomaType | Alpha-numeric | 2 | N/A |
610 | PostGraduatePlans | This field contains the code identifying the student’s post-graduation plans. This field is extracted from the i.4.see Data Elements page, Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements. | If Promoted Indicator =3 Then [S_NH_STU_X]PostGradPlans | Alpha-numeric | 2 | N/A |
520 | Full Days Suspended – In School | This field contains the number of in-school suspension days this student has served in the selected school year. This field is calculated by summing the Duration (Actual) value entered for each in-school suspension log entry record. The Action Date ([Log]Action_Date) value is used in this calculation. If Reporting Period is EOY then reported as null. | Calculated based on [Log]Discipline_DurationActual | Numeric | 3 | N/A |
530 | Full Days Suspended OS | This field contains the number of out-of-school suspension days this student has served in the selected school year. This field is calculated by summing the Duration (Actual) value entered for each out-of-school suspension log entry record. The Action Date ([Log]Action_Date) value is used in this calculation. If Reporting Period is EOY then reported as null. | Calculated based on [Log]Discipline_DurationActual | Numeric | 3 | N/A |
580 | 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 |
500 | Homeless Code | This field contains a 2 if the student is considered homeless. If the Homeless Code field is blank, this field defaults to 1. This field is extracted from the i.4.see Data Elements page, Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements. | [S_NH_STU_X]Homeless_Code | Alpha-numeric | 1 | N/A |
660 | Original Graduation Year | This field contains the student’s original graduation year, if that student is in grade level 9 or higher. This field is blank if the student is enrolled in a grade level less than 9. This field is extracted from the i.4.see Data Elements page, Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements. | [S_NH_STU_X]OrigGradYear | Alpha-numeric | 30 | N/A |
325 | Parent Military Code | This field indicates the student's parent or guardian military status. | [S_NH_STU_X]Parent_Military_Status OR [S_NH_REN_X]Parent_Military_Status | Alpha-numeric | 1 | N/A |