Basic Reporting Period Attendance Resource (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
Reporting year enrollment containing present days.

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 record if attendance records are associated with:

  • An enrollment marked as State Exclude or No Show.
  • A Calendar when the Exclude checkbox is marked.
  • 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 System Admin > Calendar > 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.

Scope Year

Business Rules
Attendance records will only send to the school year that the incident date is aligned to based on the School Year Start and End dates.

If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.

If School Year End Date is NULL, 6/30/xxxx will be the default end date used.

Data will only send for the years that have valid configuration.

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 LabelBusiness 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.

MSystem Admin > Calendar > Calendar > Schedule
gradeLevel
Descriptor

Report the student's Grade from the most current Enrollment.MStudent Information > General > Enrollments Tab > 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' 


MSystem Admin > Calendar > Calendar > School Months (Attendance Periods)
schoolReference
Reports the fields that are part of the Natural Key for the School resource.M
studentReference

Reports the data that is part of the Natural Key for the Student resource

M
numberDaysTaught

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.

MSystem Admin > Calendar > Calendar > School Months (Attendance Periods)
totalDaysAbsentIndicates the total number of days the student was absent during a particular reporting period.

See logic above for explanation of a day of absence.


Report the number of days in the reporting period in which the student was enrolled but counted as absent.


Students with ADA Eligibility = 2, 5, or 6 report .5 (1/2) days for every instructional day absent.



Report number as a decimal with the format XXX.X.


Report 000.0 if student has no days of absence.
10 days would report as 10.0 and 10.5 days would report as 10.5.

MCalculated
totalEligibleDays
Present
Indicates the total number of days the student was present and ineligible for Foundation School Program funding during a particular reporting period.

See logic above for explanation of a day of absence.


For a student with ADA Eligibility = 1, 2, 3, or 6, report the number of days in the reporting period in which the student was in an enrollment with ADA Elig=1, 2, 3, or 6 and counted as present.


Students with ADA Eligibility = 2 or 6 report .5(1/2) days for every instructional day present.
 

The final number must be 0 or 5.Report number as a decimal with the format XXX.X.


Report 00.00 if student does not have ADA Eligibility = 1, 2, 3, or 6 at any time in the Reporting Period.


10 days would report as 10.0 and 10.5 days would report as 10.5.


All 3 combined fields must report together (0937/1678/1679) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.

MCalculated
totalInelgibleDays
Present
Indicates the total number of days the student was present and eligible for Foundation School Program funding during a particular reporting period.

See logic above for explanation of a day of absence.


For a student with ADA Eligibility = 4 or 5, report the number of days in the reporting period in which the student was in an enrollment with ADA Elig= 4 or 5 and counted as present.


Students with ADA Eligibility = 5 report .5 (1/2) days for every instructional day present.
The final number must be 0 or 5.

Report number as a decimal with the format XXX.X.


Report 000.0 if student does not have ADA Eligibility = 4 or 5 at any time in the Reporting Period.


10 days would report as 10.0 and 10.5 days would report as 10.5.

OCalculated