BIE Enrollment Summary

Tool Search: Enrollment Summary

The BIE Enrollment Summary lists a breakdown of enrollments grouped by BIE School, BIE Grade, Gender, and Federal Race / Ethnicity. The report can be generated by BIE School, BIE Region, or ERC. 

Screenshot of the BIE Enrollment Summary Report Editor.BIE Enrollment Summary Report Editor

Report Logic

The BIE Enrollment Summary includes totals of students enrolled in selected schools based on an entered enrollment effective date. It is a BIE localized version of the Student Enrollment Summary Report.

Does not report students:

  • Flagged as 'No Show'
  • In a calendar marked as State Exclude
  • In a grade level marked as 'Exclude from BIE'
  • Marked as 'BIE Exclude' on their enrollment (unless the reporting option of "Include Enrollments marked BIE Exclude" is selected)  

Student populations can be delineated by Student Group  (All Students, ISEP Students (not PK), or Non-ISEP Students).

The report is available in both State and District Editions.
The report can be run against a district’s active year as well as any prior year.
File name is defined as BIEEnrollmentSummary_YYYYMMDD_HR:MM   (Where YYYYMMDD_HR:MM is the Date/Time stamp of report generation.)

Report Editor

The following information details the BIE Enrollment Summary.

Click here to expand...

OptionDescription
Enrollment Effective Date
Required

This required field is used to return actively enrolled students as of the entered date. It defaults to the current date but can be changed by selecting the calendar icon to the right of the field, or entering the date manually in MMDDYYYY format.

Which BIE Reporting Population would you like to generate this report on? 

BIE Reporting Population options:

  • BIE School
    • All Schools (default)
    • List of individual schools
  • BIE Regions
    • ALL BIE School Types (Regions) (default) 
    • BOS: Bureau Operated Schools
    • NAV: Navajo School
    • TCS: Tribally-Controlled Schools
  • ERC
    • All ERCs (default)
    • ABQBOS: Albuquerque Bureau Operated
    • ABQTCS: Albuquerque Tribally Controlled
    • BELBOS: Belcourte Bureau Operated
    • BISTCS: Bismarck Tribally Controlled
    • FLATCS: Flandreau Tribally Controlled
    • KYLTCS: Kyle Tribally Controlled
    • MINTCS: Minneapolis Tribally Controlled
    • NASTCS: Nashville Tribally Controlled
    • NCHIBO: Navajo Chinle Bureau Operated
    • NCHITC: Navajo Chinle Tribally Controlled
    • NCROBO: Navajo Crownpoint Bureau Operated
    • NCROTC: Navajo Crownpoint Tribally Controlled
    • NSHPBO: Navajo Shiprock Bureau Operated
    • NSHPTC: Navajo Shiprock Tribally Controlled
    • NTUBBO: Navajo Tuba City Bureau Operated
    • NTUBTC: Navajo Tuba City Tribally Controlled
    • NWINBO: Navajo Window Rock Bureau Operated
    • NWINTC: Navajo Window Rock Tribally Controlled
    • PHXBOS: Phoenix Bureau Operated
    • PINBOS: Pine Ridge Bureau Operated
    • SEATCS: Seattle Tribally Controlled

Only one option can be selected at any given time.

Which Schools would you like to include in the report?This report can be generated for multiple schools in the chosen BIE Reporting Population or a single school. At least one School, Region, or ERC needs to be selected.
Which BIE Calendar Types would you like to include in the report?At least one BIE Calendar Type must be selected in order to report student enrollment data.
  • BIE Calendar Types include:
    • 21: 21st Century
    • A:   Alternative
    • B: Homebound
    • F:  Face
    • H: Homeschool
    • I: Instructional
    • O: Other
    • R: Residential
    • S: Summer
    • X: Outside District
Which BIE student population would you like to include in the report?The student populations include:
  • All Students
  • ISEP Students (Not PK)
  • Non-ISEP Students

Only one option can be selected. 

How would you like to format the report?

The report can be generated using the Original Format or the Tall Format. 


The Original Format will print race / ethnicities across the top of the report and grade levels vertically. This is the default option.


The Tall Format will print the grade levels across the top of the report and the Race / Ethnicities vertically.

 

  • The report will print in portrait layout when there are eight or fewer grade levels for all schools included in the report.
  • The report will print in landscape layout when there are more than eight grade levels reported for any of the schools included in the report.
What types of enrollments would you like to include in the report?

Users can select to print only students who have a certain enrollment type chosen on their enrollment record.  Enrollment records fall into three categories:

  • P: Primary
  • S: Partial
  • N: Special Ed Services
  • A: Ancillary

All types can be chosen at one time for display on the report (this is the default selection). At least one enrollment type must be selected in order for the report to generate. 

Report OptionsThe following can be selected when generating the BIE Student Enrollment Summary:
  • Include enrollments marked BIE Exclude.
  • Only print Race / Ethnicities in which there is at least one student with that designation.
  • Include Schools with 0 student counts on the Effective Date.
Report FormatIndicates how the report generates:
  • PDF (default)
  • DOCX
  • HTML
  • CSV
Generate Report 


To display the results of the report immediately, click the Generate Report button. This is best if the selection criteria is small (one or two calendars, a short date range, a smaller student selection, etc.).


To 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. This tool helps prevent report time-out errors and/or system performance issues. See the Batch Queue article for more information

Report Generation

  1. Enter the Enrollment Effective Date.
  2. Select the BIE Reporting Population to include on the report.
  3. Select the Schools to include in the report.
  4. Select the Calendar Types to include on the report.
  5. Select the BIE Student Population to include on the report.
  6. Select the desired format of the report (Original or Tall).
  7. Select which types of Enrollments to include on the report.
  8. Select which Report Options to include on the report.
  9. Select the desired Report Format.
  10. Click either the Generate Report or the Submit to Batch button.

Example Reports

Screenshot of an example BIE Enrollment Summary in PDF format.BIE Enrollment Summary (PDF )

Screenshot of an example BIE Enrollment Summary in HTML format
BIE Enrollment Summary (HTML)

Screenshot of an example BIE Enrollment Summary in CSV format
BIE Enrollment Summary (CSV)

Report Layout

Click here to expand...

Data Element
Description
Location
HEADER
State District NumberReports the State District Number.School & District Settings > District > District Information > State District Number

district.number
District Name Reports the District's Name.School & District Settings > District > District Information > Name

district.name
District Address Reports the District's address, city, state, and zip code.School & District Settings > District > District Information > Address, City, State, Zip

district.address

district.city

district.state

district.zip

YYYYMMDD, HR:MM Date/Time Stamp of file generation.
Page 1 of X Page 1 of (total number of pages generated)
File NameHard Coded as "Student Enrollment Summary Report"
Effective Date Effective Date selected on the Extract Editor at the time of File Generation.
MM/DD/YYYY

Enrollment Types The Enrollment Types selected on the Extract Editor at the time of file generation.
Total Race / Ethnicities

The total number of Race/Ethnicities reporting: X of X


Total SchoolsThe number of schools reporting.
Race/Ethnicity Source Hard Coded as "Federal".
Male/Female/Total
  • Total count of male students
  • Total count of female students
  • Total count all students, regardless of gender.
Census > People > Demographics > Person Information > Gender

identity.gender
Reported by Reports concatenated:  
BIE Reporting Population + Schools as selected on on the extract editor at the time of report generation.

BIE Calendar Types Reports the Calendar Types selected on the extract editor at the time of report generation.
BIE Student Population Reports the BIE Student Population selected on the extract editor at the time of report generation.
BODY
Grade

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as: Male/Female/Total 

Possible BIE Grade Levels on the reporting school of record:  

  • 01-12
  • F1 (FACE First Grade)
  • F2 (FACE Second Grade)
  • F3 (FACE Third Grade)
  • FA (FACE Adult)  
  • FC (FACE Centerbased)
  • FH (FACE Home-Based)
  • FK (FACE Kindergarten)
  • BF (BabyFACE)
  • PK (Prekindergarten)
  • KG (Kindergarten)
  • OT (Other)
  • ALL Grades

Grade Level must have at least one reportable students present to report.


(PK is NOT returned when generating the ISEP (Not PK) student population.)

School & District Settings > District > Grade Level Definitions

Student Administration > General > Enrollments > General Enrollment Information > Grade


Census > People > Demographics > Person Information > Gender


enrollment.grade

enrollment.stateGrade

Identity.gender


1: Hispanic/Latino

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have the Is the individual Hispanic/Latino? = Yes to count.

Census > People > Demographics > Race/Ethnicity > Is the individual Hispanic/Latino?

Census > People > Demographics > Person Information > Gender

Identity.hispanicEthnicity

Identity.gender

2: American Indian or Alaskan Native

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have (Fed) Race Ethnicity = 2: American Indian or Alaska Native to count.

Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native


Census > People > Demographics > Person Information > Gender

--

Federal Race/Ethnicity override logic: The following logic has been added to the Federal Designation field:  If the Tribe field (Student Information > NASIS > Tribe) is populated with any code other than null or 999: Non-Tribal Member, then Federal Designation = 2:American Indian or Alaska Native.  This logic overrides existing Federal Race/Ethnicity wizard logic.  BIE specific Federal Designation logic will be triggered each time the Race/Ethnicity wizard is saved AND each time the NASIS tab is saved.


fedRace.americanIndian

identity.certificateOfIndianBlood

Identity.gender

3: Asian

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have (Fed) Race Ethnicity = 3: Asian to count.

Census > People > Demographics > Race/Ethnicity > Race Ethnicity


Census > People > Demographics > Person Information > Gender


fedRace.asian

Identity.gender

4: Black or African American

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have (Fed) Race Ethnicity = 4: Black or African American to count.

Census > People > Demographics > Race/Ethnicity > Race Ethnicity


Census > People > Demographics > Person Information > Gender


fedRace.blackOrAfricanAmerican

Identity.gender

5: Native Hawaiian or Other Pacific Islander

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have (Fed) Race Ethnicity = 5: Native Hawaiian or Other Pacific Islander to count.

Census > People > Demographics > Race/Ethnicity > Race Ethnicity


Census > People > Demographics > Person Information > Gender


fedRace.pacificIslander

Identity.gender

6: White

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have (Fed) Race Ethnicity = 6: White to count.

Census > People > Demographics > Race/Ethnicity > Race Ethnicity


Census > People > Demographics > Person Information > Gender


fedRace.white

Identity.gender

7: Two or more races

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • Enrolled student counts by grade level reporting as:  Male/Female/Total
  • Enrolled student must have (Fed) Race Ethnicity = 7: Two or more races to count.

Census > People > Demographics > Race/Ethnicity > Race Ethnicity


Census > People > Demographics > Person Information > Gender


fedRace.multiracial

Identity.gender

Total

Reports 1 (row or column) per applicable mapped BIE Grade Level Code:

  • TOTAL - all enrolled student counts by grade level reporting as:   Male/Female/Total
Census > People > Demographics > Person Information > Gender

Identity.gender