BIE ISEP Residential Verification Report

Tool Search: BIE ISEP Residential Verification Report

ISEP (Indian School Equalization Program ) Verification and Certification is the Education Resource Center (ERC) process that verifies student eligibility. The ISEP Instructional Verification Report collects the required information for verification of student eligibility (e.g., demographics, instructional program enrollments, and residential program enrollments). Report information is used in calculating and distributing ISEP funding.

ISEP Certification is a two-step process involving verification and certification of student information. The ISEP Verification Report is generated and printed, then evaluated by the school and ERC. As errors in the data are found and corrected in the District Edition, the Verification Report is re-run and reviewed again. The process of running the Verification Report, evaluating the student information, and correcting errors is repeated until the data is considered accurate. When the school and ERC confirm that the data is accurate in the Verification Report, the Certification Report (a formal roster) is run and the data is printed and signed by the Education Program Administrator, school principal, and the school board chairperson. Certification is the official endorsement of the roster (student list). 

Image of the ISEP Residential Verification Report editor.BIE ISEP Residential Verification Report Editor















Read -Generate the report.
Write- N/A
Add- N/A
Delete - N/A

In order to generate this report, users must have Read tool rights for the report type selected as well as rights to any calendar(s) selected. If generating the report for a historical calendar, the user must have modify tool rights for the calendar in order to generate the report for new data. Please refer to the User Calendar Rights article for more information. For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

Report can be generated at the state and district levels.

Report generates on only one school at a time.

Enrollment records with any of the following indicators are excluded from the reports and all calculations:
  • BIE Exclude
  • No Show
  • Not in a BIE Grade Level (01-12) tied to an appropriate BIE Grade Level Code

Report is divided into three sections:

  • Eligible
  • Non-Eligible
  • Exceptions

Within each section the report is grouped with page breaks by Grade. Students within each grade are sorted alphabetically by last name, first name, middle name. 

Report Editor

Report OptionDescription
Type
Run Verification Report on New Data: Real-time district data is reported in PDF format. Use this option to generate the most recent information. 
*Reprint Verification Report (PDF): Data already existing in the ISEP_Ver table reported in PDF format. 
*Reprint Verification Report (CSV):Data already existing in the ISEP_Ver table reported in CSV format. 


*Reported data is that which was last requested and stored on the table.

Select Calendars
The schools available for selection are determined based on the District / School selected in the Campus toolbar. At least one school calendar must be selected in order to generate the report.
Generate Report

To display the results of the report immediately, click the Generate Report button. 

Submit to BatchTo display the results of the report at a later time, click the Submit to Batch button. The Batch Queue tool is used by some districts /states to generate large, system-intense reports. It also allows users to view and access historical ISEP Residential Verification reports. See the Batch Queue article for more information.

Report Layout

The following sections describe each section of the ISEP BIE Residential Verification Report.

Header

The header describes the reporting entity, calendar, ISEP reporting date range, and the number of records for the Program Type, Eligibility status, and grade level listed.

Click here to expand...

Image of the Header Section of the Residential Verification Report.

Header Section of BIE ISEP Residential Verification Report

FieldDescriptionLocation
Education Resource Center Name and Code
The Code and Name of the Education Resource Center selected on the school’s School History 
at the time of report generation.

System Administration > Resources > School > School History > Education Resource Center (ERC)

school.ercBIE
BIE Region Name and Code
A school’s BIE Region affiliation is determined by the Education Resource Center (ERC) value entered on the School History active at the time of report generation.
  • Returns as Navajo (NAV) if the school’s ERC value is NCHITC, NCHIBO, NCROTC, NCROBO, NSHPTC, NSHPBO, NTUBTC, NTUBBO, NWINTC, or NWINBO
  • Returns as Tribally Controlled (TCS) if the school’s ERC value is ABQTCS, FLATCS, KYLTCS, MINTCS, BISTCS, NASTCS, or SEATCS 
  • Returns as Bureau Operated (BOS) if the school’s ERC value is ABQBOS, BELBOS, PHXBOS, or PINBOS
System Administration > Resources > School > School History > Education Resource Center (ERC)


school.schoolTypeBIE
District NameThe name of the reporting district.System Administration > Resources > District Information > Name

district.name
School Name and BIE School NumberThe school name and BIE School Number of the reporting school.System Administration > Resources > School > Name and BIE School Number

School.name  
School.groupNumber
CalendarThe calendar used for reporting data.System Administration > Calendar > Calendar > Name

calendar.name
Program TypeAlways reports a value of R: Residential.System Administration > Calendar > Calendar > BIE Type
ISEP Reporting Date Range
The date range used for calculating attendance.

Date format: MM/DD/YYYY
System Administration > Calendar > Calendar > ISEP Dates

Total Eligible Enrollment Records for Program Type RThe total number of enrollment records for the status being reported (i.e., Eligible). The student count may be duplicated since each student is counted once per enrollment.Not dynamically stored.
Total Eligible Grade #XX Students for Program Type RThe total number of students for the reporting status and within the grade being reported. The student count is unduplicated since each student is only counted once regardless of the number of enrollments.Not dynamically stored.
StatusThe type of status being reported.
  • Reports as Eligible if the student’s Enrollment Type = 1: ISEP
  • Reports as Non-Eligible: if the student’s Enrollment Type does NOT = 1: ISEP
All records of the same status are grouped together.
Student Information > General > 
Enrollments > Bureau of Indian 
Education Reporting > Enrollment 
Type

GradeThe mapped BIE Grade Level code of the students being reported for that page.
Student Information > General > 
Enrollments > General Enrollment 
Information > *Grade


System Administration > Resources 
> Grade Level Definitions > BIE 
Grade Level Definitions > BIE 
Grade Level Definitions Editor > 
BIE Grade Level Definitions Detail > 
*Code

Body of Report

The body of the report describes detailed information about each eligible student.

Click here to expand...

Image of the Body of the Residential Verification Report

Body of BIE ISEP Residential Verification Report

FieldDescriptionLocation
Student NameThe student's first, middle and last name.





Alphanumeric
Census > People > Demographics > Person Information > First Name, Middle Name, Last Name

Identity.firstName  
Identity.middleName
Identity.lastName
DOBThe student's date of birth.


Date/Time Field, 10 digits
Census > People > Demographics > Person Information > Birth Date

Identity.birthdate
GenderThe student's gender.


Alphanumeric, 2 characters 
Census > People > Demographics > Person Information > Gender

Identity.gender
NASISIDThe student's NASIS ID.


Numeric, 15 digits
Census > Demographics > Person Identifiers > NASIS ID

Person.otherID
TribeThe student's tribe.


Numeric, 3 digits
Student Information > Program Participation > NASIS Programs > NASIS

NASIS.tribalCode
StartThe start date of the student's enrollment record.

Date Format,  MM/DD/YYYY
Student Information > General > Enrollments > Start Date

Enrollment.startDate
EndThe end date of the student's enrollment record.

Date Format,  MM/DD/YYYY
Student Information > General > Enrollments > End Date

Enrollment.endDate
ERC

Indicates if the student is receiving Special Ed Services in a residential setting.




Alphanumeric, 2 characters (Y or N)

Student Information > General > Enrollments > Bureau of Indian Education Reporting > Rec Sped Svcs / Res Setting

enrollmentBIE.recServcsResSettingBIE
IRG

The Intensive Residence Guidance (IRG) code entered for a residential student with a severe behavior event.
 
IRG Codes:

  • 1 = Court or Juvenile Authority
  • 2 = Expulsion from Previous School
  • 3 = Refer by Lic Psyc/Psychiatrist/Cert Psychiatric SW
  • 4 = Truancy Last School Yr or Extreme Disruptive Behavior

Numeric, 1 digit

Student Information > General > Enrollments > Bureau of Indian Education Reporting > IRG Code

enrollmentBIE.irgCodeBIE
Prog

Program Type for the report. This field always reports a value of R.


Alphanumeric, 1 character
N/A
NoResAtt

Indicates if the student has no Residential Attendance Eligibility. See the Attendance Calculation section for more information.
 
Residential Attendance Eligibility is determined as follows:

  • At least 1 attendance day = 2 attendance bedchecks present for 1 days of each count week.
  • Date range for the enrollment start and end date is for at least one day of each count week.

X= Student is not eligible.

Null= Student is eligible.


Alphanumeric, 1 character



No TribeIndicates if the student is not a tribal member.
X = If Tribe is null or 999: Non Tribal Member


Alphanumeric, 1 character
Student Information > Program Participation > NASIS Programs > NASIS


NASIS.tribalCode
No DOB

Indicates if the student has no date of birth entered within Campus.
X = No date of birth     

Null = Date of birth exists within Campus


Alphanumeric, 1 character
Census > People > Demographics > Person Information > Birth Date


Identity.birthdate
Non-ISEPIndicates if the student's enrollment record Enrollment Type is not ISEP.
X = Enrollment Type is 2: Non-ISEP or 3: Public Enrolled

Alphanumeric, 1 character
Student Information > General>Enrollments > Bureau of Indian Education Reporting > Enrollment Type


enrollmentBIE.stateAidBIE

Exceptions and Totals

The Exceptions section describes all students for whom the report could not determine eligibility. See the Eligibility Calculation section for more information.

The Verification Summary for Qualified Students table provides a breakdown of how many students per grade qualified for each category (Residential, ECR, IRG).

Click here to expand...

Students with multiple enrollment records in different grade levels are only counted once in all total fields. Students with multiple enrollment records in different grade levels are only counted for the grade level they were most recently enrolled in for the reporting year.

Image of the Exceptions and Totals Section of the Residential Verification ReportExceptions and Totals Section of BIE ISEP Residential Verification Report

Column

Description

Total Exceptions

Total number of students who have eligibility exceptions.

Name

The name of each student with an eligibility exception.

Grade

The grade of each student with an eligibility exception.

Exception Type

The type of exception tied to the student.

Verification Summary for Qualified Students

The Verification Summary for Qualified Students section lists totals for each of the following categories:

  • Grade: The grade for each reported value.
  • Residential: Total number of students eligible per grade.
  • ECR: Total number of students per grade marked "Y" for ECR.
  • IRG: Total number of students per grade with an IRG code.
  • Total: Total number of eligible students per grade.

School Total

The School Totals section lists a school-wide count of the following categories:

  • Residential: Total number of eligible students within the school.
  • ECR: Total number of students within the school marked "Y" for ECR. 
  • IRG: Total number of students within the school with an IRG code.
  • Total Students: Total number of eligible students within the school.

Eligibility Calculation

ISEP funding is distributed to schools and dormitories based on membership eligibility. If a student’s membership / enrollment meets all of the required eligibility criteria, that student’s record receives a status of Eligible. In cases where a record fails to meet one or more of the eligibility criteria, that record is listed as Non-Eligible. Each enrollment is analyzed individually to determine eligibility status; therefore, the same student may have enrollment records that appear under both sections.

Click here to expand...

Student enrollment records are considered eligible if they meet all of the following criteria:

  • Enrolled in an Residential program for the selected calendar (Calendar.calendarID matches enrollment.calendarID and calendar.type = R)
  • Enrollment record has an Enrollment Type = 1: ISEP.
  • Student has a valid birth date.
  • Student has a Tribal Code not null or 999: Non-Tribal Member.
  • Student is enrolled in a recognized BIE grade level of 01-12. The grade level should be mapped to a BIE Grade Mapping. If not, logic looks at the State and Local Grade level to determine if it matches a BIE Grade Mapping value.
  • Student has a gender of Male or Female.
  • Attendance marked present at afterschool and midnight bed checks at least one day for each of the dorm's three count weeks (see the Attendance Calculation section for more information).

Student enrollment records are considered Non-eligible if they meet any of the following criteria:

  • Enrollment record has an Enrollment Type = null or any value other than 1: ISEP (System Administration > General > Enrollment > BIE Reporting > Enrollment Type).
  • Student has a Tribal Code = null or 999: Non-Tribal Member.
  • Student is in Kindergarten.
  • Student's enrollment record start date is after the end of the first count week.
  • Student's enrollment record end date is prior to the start of the third week count week.
  • Students who were not present for both checks on at least one day of each of the three count weeks, with the exception of students with an attendance status of absent: exempt.

Student enrollment records are considered Exceptions when any of the following data inconsistencies are identified:

Students are listed in the Exceptions section of the report when their eligibility or non-eligibility requires further investigation. Students who are listed with Exceptions will also be listed in the Eligible or Non-Eligible section of the report. 

  • Student is enrolled in more than one Residential program. This can occur if a student terminates enrollment and then re-enrolls. (Exception Code: MultCal)
  • Student has enrollment records in different grade levels within the same calendar. In most cases, a student should not be enrolled in two different grade levels at the same time. If this exception is identified the enrollment records are flagged for further investigation by the school and ERC. (Exception Code: MultGrade)
  • Student has multiple enrollment records during the count weeks (i.e., the student left and came back during count weeks). It is possible that neither enrollment record would be eligible but combined enrollments would make the student eligible. (Exception Code: MultEnroll)

Attendance Calculations

Only calendars meeting the following criteria report data:

  • Flagged as Residential.
  • Does NOT have the Exclude checkbox marked.
  • Does NOT have the Non-Instructional checkbox marked.

Click here to expand...

Students must be present for both instructional periods for 1 or more days each count week to be considered eligible. This is calculated using the following logic:

  • Count week start and end dates are determined for the calendar (System Administration > Calendar > Calendar > ISEP Dates).
  • Logic determines the number of instructional days a student was enrolled for the count week. Logic looks at the student's enrollment record start and end dates to determine if they were enrolled for all or a portion of count week. Instructional days are marked on the Days tab as School Day, Instructional and Attendance (System Administration > Calendar > Calendar > Days > School Day, Instructional, Attendance).
  • Logic determines the number of distinct days the student is marked as Absent for one or both instructional periods for an instructional day within the date range. Absences marked as AEX: Absent Exempt or EREX: Early Release Exempt do not count as an absence. 
  • If the number of days the student was absent is greater than or equal to the number of instructional days enrolled, the student is considered ineligible for attendance.

If a student has multiple enrollment records included in the report, the calculation is made one time, using attendance from all enrollments:

  • The count weeks are determined for each calendar; if the student is enrolled in more than one calendar (System Administration > Calendar > Calendar > ISEP Dates), unique count weeks are determined. A unique week is any week with a unique start date/end date combination. If all calendars have the same count weeks, only 3 weeks are possible, but more weeks are possible if calendars do not all have the same count weeks.
  • If a student is in attendance or has an absence with an Excuse code of Exempt for instructional periods in at least one day in at least 3 unique count weeks, the student will be counted as eligible for all enrollments used in the calculation. If the student is not present and does not have an absence with an Excuse code of Exempt for at least one day in at least 3 unique count weeks, the student will be counted as ineligible for all enrollments used in the calculation.
  • When attendance for a student is calculated from multiple enrollments, each record for that student will report an asterisk next to the student’s name. At the bottom of the exceptions page at the end of the report, a note will read “Records marked with * next to a student’s name have had residential attendance eligibility calculated from multiple enrollments.”