BEDS Reporting (New York)

Last Modified on 10/22/2022 10:33 am CDT

Classic View: NY State Reporting > BEDS Reporting

Search Term: BEDS Reporting

The Basic Education Data System (BEDS) is the system for collecting district/school student enrollment and staff counts. The NY BEDS State Report tool produces a report that you can use to fill out some of the BEDS State report. For more information about BEDS reporting, see the NYSED.gov web site.

BEDS Reporting Editor

Reporting Logic

  • Information returned in the report is limited to the selected Effective Date. The default date is the current date.
  • If your districts uses Campus Human Resources as add-on functionality, staff members must have an active District Employment record as of the Effective Date.
  • The following areas report from the  Previous Calendar selected on the extract editor. 

Extract Layout

School Identification

This area displays the School Name and BEDS Code.

Element Name Description Type, Format and Length Campus Database Campus Location
School Name

The school name selected on the extract editor.

 Alphanumeric, 40 characters School.name System Administration > Resources > School > Name
BEDS Code

The BEDS Code for the school selected on the extract editor.

 Alphanumeric, 12 characters School.BEDSCode System Administration > Resources > School > BEDS Code

School Type

This area displays the School Type.

Element Name Description Type, Format and Length Campus Database Campus Location
School Type

The type of school selected on the extract editor.
Options include the following:

  • Regular School
  • Special Education School
  • Vocational Education School
  • Alternative Education School
  • Reportable Program
  • BOCES
  • Public School

Alphanumeric, 5 characters

 School.type System Administration > Resources > School > School Type

Students Suspended

This area displays the number of students suspended as well as a count of the race and gender of these students.

A student must be marked with an Attendance code that begins with OSS (Out of School Suspension) for every period taking attendance in order to be counted.

As a best practice, assign the status of Absent to the OSS and SUS Attendance Excuse Codes.

You can review a student's race ethnicity via the Person Information section of the Demographics tool.

This area reports from the Previous Calendar selected on the extract editor.

Element Name Description Type, Format and Length Campus Database Campus Location
Indian Male The total number of suspended, male students assigned the Indian racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Indian Female The total number of suspended, female students assigned the Indian racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Black Male The total number of suspended, male students assigned the Black racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Black Female The total number of suspended, female students assigned the Black racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Asian Male The total number of suspended, male students assigned the Asian racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Asian Female The total number of suspended, female students assigned the Asian racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Hispanic Male The total number of suspended, male students assigned the Hispanic racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Hispanic Female The total number of suspended, female students assigned the Hispanic racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
White Male The total number of suspended, male students assigned the White racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
White Female The total number of suspended, female students assigned the White racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Pacific Islander Male The total number of suspended, male students assigned the Pacific Islander racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Pacific Islander Female The total number of suspended, female students assigned the Pacific Islander racial status. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Multiracial Male The total number of suspended, male students assigned to multiple racial statuses. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Multiracial Female The total number of suspended, female students assigned to multiple racial statuses. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored
Total Students Suspended The total number of suspended students. Numeric, 4 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored

Professional Staff Assigned to this School

This area displays the number of staff for each role as well as a count of the race and gender of these employees.

Element Name Description Type, Format and Length Campus Database Campus Location
FTE Percent

The full-time employment percentage, in whole numbers, of the staff members.

Logic used to define the full-time employment percentage.

Type Logic
Campus SIS
  • 100 FTE = 100 and NULL on FTE of Assignment - Teacher is counted as Full-Time

  • 0 FTE = 99 and below - Teacher is counted as Part-Time
Campus HR/Payroll

Reports FTE from the Wage Detail Record. Otherwise, reports FTE from Payroll Information.

  • 1.00 FTE or NULL FTE - Teacher is counted as Full-Time
  • FTE < 1.00 - Teacher is counted as Part-Time
Numeric, 3 digits

Employment.ftePercent

OR

HREmploymentAssignmentSalary.fte

Census > People > District Employment

OR

Human Resources > Personnel > Personnel Master > Work Assignment > Wage Detail Records > FTE

OR

Human Resources > Personnel > Personnel Master > Work Assignment > Payroll Information > FTE
Title Description of the staff person's role in an assignment. Alphanumeric, 50 characters

EmploymentAssignment.title

OR

Administration.BEDSCode

Census > People > District Assignment > Employment Assignment Information > Title

OR

Human Resources > Personnel > Personnel Master > Work Assignment > Work Assignment Details > BEDS Code
Indian The total number of employees with this title that are also assigned the Indian racial status. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
Black The total number of employees with this title that are also assigned the Black racial status. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
Asian The total number of employees with this title that are also assigned the Asian racial status. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
Hispanic The total number of employees with this title that are also assigned the Hispanic racial status. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
White The total number of employees with this title that are also assigned the White racial status. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
Pacific Islander
The total number of employees with this title that are also assigned the Pacific Islander racial status. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
Multiracial The total number of employees with this title that are also assigned to multiple racial statuses. Numeric, 4 digits Identity.raceEthnicity

Census > People > Identities > Race/Ethnicity

OR

Human Resources > Personnel > Personnel Master > HR General Information – Current Record
Total The total number of employees assigned to the title in that row. Numeric, 4 digits Calculated, not dynamically stored Calculated, not dynamically stored

Prekindergarten Teachers Records

This area reports a count of all Prekindergarten teachers with a Prekindergarten Employment Assignment. This area also displays how many prekindergarten teachers are considered full or part-time.

Element Name Description Type, Format and Length Campus Database Campus Location
Full Time/
Part Time

The total Full Time or Part Time teachers. The following describes the logic used to define full and part-time teachers.

Type Logic
Campus SIS To calculate correctly, the Title must begin with prek.
  • FTE = 75% and above or NULL - Teacher is counted as Full-Time
  • FTE = 74% and below - Teacher is counted as Part-Time
Campus HR/Payroll

Reports FTE from the Wage Detail Record. Otherwise, reports FTE from Payroll Information.

To calculate correctly, the BEDS Code must begin with prek.

  • FTE >=0.75 - Teacher is counted as Full-Time
  • FTE < 0.75 - Teacher is counted as Part-Time
Numeric, 10 digits

Attribute: Administration.BEDSCode

EmploymentAssignment.fte

HREmploymentAssignmentSalary.fte

EmploymentAssignment.title

Human Resources > Personnel > Personnel Master > Work Assignment > Work Assignment Details > BEDS Code

Human Resources > Personnel > Personnel Master > Work Assignment > Wage Detail Records > FTE

Human Resources > Personnel > Personnel Master > Work Assignment > Payroll Information > FTE

Census > People > District Assignment > Employment Assignment Information:

  • Title
  • FTE of Assignment

Alternative Education Programs Records

This area reports whether the school offers students Alternative Education Programs.

Element Name Description Type, Format and Length Campus Database Campus Location
Are Alternative Education Programs offered to students enrolled in this school?

If the School Type is Alternative Education School, then this field reports Yes. Otherwise, No will report.

 Alphanumeric, 3 characters Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored

Grades Offered Records

This area reports all of the grades offered at the school. An X indicates the grade is available.

Element Name Description Type, Format and Length Campus Database Campus Location

PK

K

1-14

PS

GD

This area reports all grades offered as determined by the State Grade Level Field. Grade Levels marked as Exclude will not report.

The PK column is marked when Grade Levels are marked with State Grade Level codes PKH or PKF.

The K column is marked when Grade Levels are marked with State Grade Level codes KH or KF.

 Alphanumeric, 2 character Calculated, Not Dynamically Stored System Administration > Resources > Grade Level Definitions

Percentage of Attendance Records

This area reports the percent of attendance for the school. This area reports from the Previous Calendar selected on the extract editor. Only whole day absences are calculated.

Element Name Description Type, Format and Length Campus Database Campus Location
Percent Attendance

The attendance percent for the school is calculated by dividing the school attendance by the possible attendance.

 Numeric, 6 digits Calculated, Not Dynamically Stored Calculated, Not Dynamically Stored

Lunch, Breakfast and Milk Programs Records

This area reports whether any students in this school are approved for free and reduced-price lunches.

Element Name Description Type, Format and Length Campus Database Campus Location
Do students in this school qualify for the federal free and/or reduced priced lunch program?

This value is determined by the following logic:

  • Yes reports if a student has a Program = 5817 and the Program End Date is null.
  • Yes reports if a student has a Program = 5806 and the Program End Date is null.
  • Yes reports if a student has an active FRAM Eligibility record where the Eligibility is Free. The FRAM Eligibility Start Date must be <= Extract Editor Effective Date. The FRAM Eligibility End Date must be >= Extract Editor Effective Date
  • Yes reports if a student has an active FRAM Eligibility record where the Eligibility is Reduced. The FRAM Eligibility Start Date must be <= Extract Editor Effective Date. The FRAM Eligibility End Date must be >= Extract Editor Effective Date
  • Otherwise, No reports.
 Alphanumeric, 3 characters

Program.code
ProgramParticipation.startDate
ProgramParticipation.endDate
POSEligibility.eligibility
POSEligibility.startDate
POSEligibility.endDate

Student Information > General > Flags > Student Flag Detail > Flags

Student Information > Program Participation > Programs > Programs > Program Participation Detail > Program

FRAM > Eligibility > Eligibility Detail > Eligibility

Unexcused Absences Records

This area reports students who had an unexcused absence in every hour of their schedule (only whole day absences are calculated). The unexcused absence is reported from when the Attendance Code is Absent and where the Excuse is Unexcused.

This area reports from the Previous Calendar selected on the extract editor. Attendance Present Minutes are ignored.

Element Name Description Type, Format and Length Campus Database Campus Location
One to Four Unexcused Absences

The total of students who have 1-4 unexcused absences.

 Numeric, 10 digits

Attendance.status

Attendance.excuse

Student Information > General > Attendance > Attendance Information > Status; Excuse
Five to Nine Unexcused Absences The total of students who have 5-9 unexcused absences. Numeric, 10 digits

Attendance.status

Attendance.excuse		 Student Information > General > Attendance > Attendance Information > Status; Excuse
Ten or More Unexcused Absences The total of students who have 10+ unexcused absences. Numeric, 10 digits

Attendance.status

Attendance.excuse		 Student Information > General > Attendance > Attendance Information > Status; Excuse




Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com