Bilingual ESL Program Reporting Period Attendance (Texas v4.0)

Tool Search Term: Ed-Fi 

Object Triggering Logic

ActionTrigger
POST

Report attendance for each school the student has a Student School Association record for.


Reports attendance from associated Attendance Periods:

  1. Date Range of reporting period is the Attendance Start Date through Attendance End Date.
  2. Exclude any attendance/membership found between Exclude Start Date and Exclude End Date.

Student must have an ADA eligibility record that is active in the reporting range.

  • ADA eligibility = 1/2/3/4/5/6
  1. EL Program Status of EL during the reporting period or Exited after the reporting period
  2. EL Service Type of B2, B3, B4, B5, E2, or E3 during the reporting period
  3. Bilingual/ESL Funding = NOT NULL
A change of school within the Attendance Period will cause a record for each school to report.

A change in grade level within the Attendance Period will cause a record for each grade level to report.

  • The total days reported for each data element on the record is the total for that specific reporting period. If a student has multiple entries and withdrawals in the same grade in the same school on the same instructional track during a specific reporting period, only one record is required and the total days for each data element are reported.

Do not send a record if attendance records are associated with an enrollment marked as No Show.


Do not send records if attendance records are associated with a Calendar when the Exclude checkbox is marked.


Do not send records if attendance records are associated with a School when the Exclude checkbox is marked.

PUT

Attendance data is changed within a reported Attendance Period.

DELETEIf enrollment that affects the attendance range is deleted.

Logic for Counting Days of Absence

There is an "Attendance Snapshot Time" designated in Calendar Information > Calendar for each School.
Students who are marked absent in the period that contains the snapshot time are considered absent for the day.
Students who are marked present in the period that contains the snapshot time are considered present for the day.
Attendance marks in any other period do not count.
Students with ADA Eligibility = 2, 5, or 6 count one-half day of absence or presence for each instructional day.
Students in Grade = EE must have an overlapping IEP to have attendance days included

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element
Label
Business RequirementLogicM, C, or, OLocation
idThe unique identifier of the resource.
M
calendarCode

A unique campus calendar of school days for a particular group of students on a campus. Students with the same instructional track have the same number of days taught in a particular reporting period at a campus.

Report an identifying number for the number of Calendars in a particular school. If there is only 1 Calendar for a School, report 00.


If there is more than 1 Calendar for a school, report Track Number of 00 for the first Calendar listed and a Track of 01 for the 2nd Calendar listed in the School, and count up from there.

M Calendar > Schedule
gradeLevel
Descriptor

Report the students Grade from the most current Enrollment.M Enrollments > General Enrollment Information > Grade
reportingPeriod
Descriptor


Report the Sequence of the School Month (Attendance or Reporting Period).


EX: First 6 Week Reporting Period reports '1' 


M Calendar > School Months (Attendance Periods)
numberDays
Taught

Indicates the number of days of instruction offered, as shown on the school calendar, during a particular reporting period.

Report the number of instructional days in the Report.


The number of instructional days in the Attendance Period or Reporting Period (School Month).


This represents the actual number of instructional days in the school/track calendar for a specific reporting period.

All students in a particular school/track will have the same number of days taught.

M Calendar > School Months (Attendance Periods)
BilingualESLFunding
Descriptor

Indicates the language program in which the student participates during the reporting period.

If the student has an active EL record AND an active EL Services record AND Bilingual/ESL Funding contains a value, then report that value.

M Program Participation > English Learners (EL) > EL AND EL Services
TotalEligBilingual
ESLDaysPresent

Indicates the total number of days the student was present and an eligible participant in the state-approved bilingual/ESL program during a particular reporting period.

  1. Report the number of days in the reporting period in which the student was present in ESL/BIL program
    1. See Business Rules above for explanation of a day of absence.
  2. This value is reported as a number with the format XXX.X
OCalculated