Special Programs Reporting Period Attendance (Texas v4.0)

Object Triggering Logic

Action	Trigger
POST	Report attendance for each school the student has a Student School Association record for. Reports attendance from associated Attendance Periods: Date Range of reporting period is the Attendance Start Date through Attendance End Date. 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 not = 0 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.
DELETE	If enrollment that affects the attendance range is deleted.

Action

Trigger

POST

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

Reports attendance from associated Attendance Periods:

Date Range of reporting period is the Attendance Start Date through Attendance End Date.
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 not = 0

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.

DELETE

If enrollment that affects the attendance range is deleted.

Logic for Counting Days of Absence

There is an "Attendance Snapshot Time" designated in Calendar Information 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.

If there is a number entered into Present Minutes for a period, use that number to calculate the total minutes, no matter what attendance code is entered.

If there is no attendance code/a Present code/an Absent-Exempt code and no minutes entered into the Present Minutes, use the Period Start and End times to calculate the number of minutes Present, adding together the instructional minutes from any instructional period in which the student is scheduled into an attendance taking course, when the student does not have an attendance code with a Status/Excuse of Absent/Excused, Absent/Unexcused, Absent/Unknown, or teacher-entered absence.

There must be a record for each student who was enrolled for at least two hours for one or more days within the indicated reporting period and has an ADA eligibility not equal to 0 (Report a record for each Reporting Period in which he/she has at least 45 minutes of presence).
- State Programs > ADA > ADA Detail > ADA Eligibility
- If ADA records for the reporting enrollment contain an ADA Eligibility of 0 or blank, then the student will not report attendance for the date range of the ADA record
Students in GRADE-LEVEL-CODE EE cannot report days in Bilingual/ESL.
Students in grades EE through 03 should not have days reported in Pregnancy Related Services.
Days may be reported only in whole days or half days. The "total days" reported for students in half-day programs, such as prekindergarten, cannot be more than half of the "number of days taught" for that reporting period.
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.
A student who changes schools in a reporting period should have two records for that reporting period, one for each school.
A student who changes grade levels but remains in the same school in a reporting period should have two records for that reporting period, one for each grade level.
Students who should not report are:
- A student who does not have a State ID should not report
- A student who is marked Exclude, in a grade level marked State Exclude, or in a School marked as State Exclude should not report.
- A student who is marked as a No Show should not report data for any enrollment that is so marked.
If a number is entered into Present Minutes for a period, the total minutes are calculated using that number, regardless of the attendance code entered.
If there is no attendance code/a Present code/an Absent-Exempt code and no minutes entered into the Present Minutes, use the Period Start and End times to calculate the number of minutes Present, adding together the instructional minutes from any instructional period in which the student is scheduled into an attendance taking course, when the student does not have an attendance code with a Status/Excuse of Absent/Excused, Absent/Unexcused, Absent/Unknown, or teacher-entered absence.

Attendance Event Indicator Code Table

Click here to expand...

Code	Name	Eligible ADA Values	Data Setup
01	Regular	1/2/3/4/5/6	Reporting year enrollment containing present days
02	Regular - Bilingual/ESL	1/2/3/4/5/6	EL Program Status of EL during the reporting period or Exited after the Attendance Period EL Service Type of B2, B3, B4, B5, E2, or E3 during the attendance period
03	Regular - CTE	1/2/3/4/5/6	Enrolled in a CTE course during the reporting period
04	Regular - PRS	1/2/3/4/5/6	Active PRS flag during the reporting period
05	Regular - SpecialEd	1/2/3/4/5/6	Active and locked IEP during the reporting period
06	Flexible - Regular	7/8	Need value in Flexible Attendance Program Type on the ADA tab
07	Flexible - Bilingual/ESL	7/8	Need value in Flexible Attendance Program Type on the ADA tab EL Program Status of EL during the reporting period EL Service Type of B2, B3, B4, B5, E2, or E3 during the reporting period
08	Flexible - CTE	7/8	Need value in Flexible Attendance Program Type on the ADA tab Enrolled in a CTE course during the reporting period
09	Flexible - PRS	7/8	Need value in Flexible Attendance Program Type on the ADA tab Active PRS Flag or Program during the reporting period
10	Flexible - SpecialEd	7/8	Need value in Flexible Attendance Program Type on the ADA tab Active and locked IEP during the reporting period
11	Regular - SpecialEd Mainstream	1/2/3/6	Active and locked IEP during the reporting period Special Ed Setting of '40'
12	Flexible - SpecialEd Mainstream	7/8	Need value in Flexible Attendance Program Type on the ADA tab Active and locked IEP during the reporting period Special Ed Setting of '40' Student grade level of 9, 10, 11, or 12
13	Regular - Residential Facility	1/2/3/4/5/6	Active Residential Facility Program record during the reporting period
14	Flexible - Residential Facility	7/8	Need value in Flexible Attendance Program Type on the ADA tab Active Residential Facility Program during the reporting period

Instructional Setting Code Multiplier (Excess Minutes)

Click here to expand...

Instructional Setting Code	Weight Multiplier
00 (Speech Therapy Services)	0.250
01	1.000
02	4.500
08	5.500
30	5.500
41-45	2.859
81-89	5.500
91-98	4.250

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.

DE#	Data Element Label	Business Requirement	Former Element Name	Logic	M, C, or, O	Location
TX100	id	The unique identifier of the resource.			M
TX200	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.	INSTRUCTIONAL-TRACK-INDICATOR-CODE	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	Scheduling & Courses > Calendar Setup > Calendar Information
TX300	gradeLevel Descriptor		GRADE-LEVEL-CODE	Report the student's Grade from the most current Enrollment.	M	Student Information > General > Enrollments > General Enrollment Information > Grade
TX400	reportingPeriod Descriptor		REPORTING-PERIOD-INDICATOR-CODE	Report the Sequence of the School Month (Attendance or Reporting Period). EX: First 6 Week Reporting Period reports '1'.	M	Scheduling & Courses > Calendar Setup > Attendance Periods
TX500	schoolReference			Reports the fields part of the Natural Key for the School resource.	M
TX600	studentReference			Reports the data that is part of the Natural Key for the Student resource	M
TX700	numberDays Taught	Indicates the number of days of instruction offered, as shown on the school calendar, during a particular reporting period.	NUMBER-DAYS-TAUGHT	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	Scheduling & Courses > Calendar Setup > Attendance Periods
TX800	TotalEligPreg RelSvcsDays Present	The total number of days a female student was present at school or served through Compensatory Education Home Instruction (CEHI) and an eligible recipient of pregnancy-related services during a particular reporting period.	TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT	See Business Rules above for explanation of a day of absence. For a student with an active PRS program or flag during the reporting period, report the number of days in the reporting period in which: 1. the student was enrolled, 2. the program was active, 3. and the student was 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. This value is reported as a number with the format XXX.X. Report 0.0 if the student does not have an active PRS program during the reporting period, OR if the student is male (even with an active program) OR if the student's grade level is EE - 03 (even with an active program) 10 days would report as 10.0, and 10.5 days would report as 10.5. All 3 combined fields must report together (0939/1686/1687) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Flags > Flag > PRS / calculated OR > Program Participation > Programs > Program Participation Editor > Program > PRS / calculated
TX900	RSTotalElig PregRelSvcs DaysPresent	Indicates the total number of days a female student was remote synchronous present or served through Compensatory Education Home Instruction (CEHI) and an eligible recipient of pregnancy related services during a particular reporting period.	RS-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT	For all days that qualify in the field above do the following: For every day that a student is present do the following: If student has an attendance code of RS for that day - count that day for this field If student has an attendance code of RA OR IP - ignore that day for this field If student does not have an applicable attendance code for that day - check their blended learning group assignment If assignment is marked as Virtual > Synchronous count that day for this field If none of the above are true, do not count that day for this field If day is counted for this field it will NOT count for standard attendance (field above) If the student value is 0.0, do not report the element.	O	Flags > Flag > PRS / calculated OR Program Participation > Programs > Program Participation Editor > Program > PRS / calculated
TX1000	RATotalEligPreg RelSvcsDays Present	Indicates the total number of days a female student was remote asynchronous present or served through Compensatory Education Home Instruction (CEHI) and an eligible recipient of pregnancy related services during a particular reporting period.	RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT	For all days that qualify in the field above, do the following: For every day that a student is present, do the following: If the student has an attendance code of RA for that day - count that day for this field If student has an attendance code of RS OR IP - ignore that day for this field If student does not have an applicable attendance code for that day - check their blended learning group assignment If assignment is marked as Virtual > Asynchronous count that day for this field If none of the above are true, do not count that day for this field If day is counted for this field it will NOT count for standard attendance (field above) If the student value is 0.0, do not report the element.	O	Flags > Flag > PRS / calculated OR Program Participation > Programs > Program Participation Editor > Program > PRS / calculated
TX1100	TotalEligSpEd Mainstream DaysPresent	Indicates the total number of days a student with a special education individualized education program which provided for the mainstream instructional arrangement/setting was present during a particular reporting period.	TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT	See the Business Rules above for an explanation of a day of absence. For a student with an active and locked IEP with an Instructional Setting = 40: Mainstream, during the reporting period, report the number of days in the reporting period in which: 1. the student was enrolled, # the IEP was active and locked, 2. and the student was 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. This value is reported as a number with the format XXX.X. Report 0.0 if student does not have an active and locked IEP with and Instructional Setting = 40 during the reporting period. All 3 combined fields must report together (0940/1688/1689) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Special Ed > Documents > TX IEP Enrollment Info > Special Ed Setting = ‘40’ / calculated
TX1200	RSTotalElig SpEd Mainstream Days Present	Indicates the total number of days a student with special education individualized education program which provided for the mainstream instructional arrangement/setting was remote synchronous present during a particular reporting period.	RS-TOTAL-ELIG-SP- ED-MAINSTREAM- DAYS-PRESENT	For all days that qualify in the field above (E0940) do the following: For every day that a student is present, do the following: If the student has an attendance code of RS for that day - count that day for this field If the student has an attendance code of RA OR IP - ignore that day for this field If the student does not have an applicable attendance code for that day - check their blended learning group assignment If an assignment is marked as Virtual > Synchronous count that day for this field If none of the above are true, do not count that day for this field If a day is counted for this field, it will NOT count for standard attendance (field above) If the student value is 0.0, do not report the element.	O	Special Ed > Documents > TX IEP Enrollment Info > Special Ed Setting = ‘40’ / calculated
TX1300	RATotalEligSp EdMainstream DaysPresent	Indicates the total number of days a student with special education individualized education program which provided for the mainstream instructional arrangement/setting was remote asynchronous present during a particular reporting period.	RA-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT	For all days that qualify in the field above (E0940) do the following: For every day that a student is present, do the following: If the student has an attendance code of RA for that day - count that day for this field. If the student has an attendance code of RS OR IP - ignore that day for this field. If the student does not have an applicable attendance code for that day - check their blended learning group assignment. If an assignment is marked as Virtual > Asynchronous count that day for this field If none of the above are true, do not count that day for this field If the day is counted for this field, it will NOT count for standard attendance (field above) If the student value is 0.0, do not report the element.	O	Special Ed > Documents > TX IEP Enrollment Info > Special Ed Setting = ‘40’ / calculated
TX1400	TotalElig Residential FacilityDays Present	Indicates the total number of days the student was present and eligible for LEA services while living in a Residential Facility during a particular reporting period.	TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT	See the Business Rules above for an explanation of a day of absence. For a student with an active Residential Facilities program during the reporting period, report the number of days in the reporting period in which: 1. the student was enrolled, 2. the program was active, 3. and the student was 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. This value is reported as a number with the format XXX.X. Report 0.0 if the student does not have an active Residential Facilities program during 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 (1652/1684/1685) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Program Participation > State Programs > Residential Facilities / calculated
TX1500	RSTotalElig Residential Facility DaysPresent	Indicates the total number of days the student was remote synchronous present and eligible for LEA services in a Residential Facility during a particular reporting period.	RS-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT	For all days that qualify in the field above, do the following: For every day that a student is present, do the following: If the student has an attendance code of RS for that day - count that day for this field If the student has an attendance code of RA OR IP - ignore that day for this field If the student does not have an applicable attendance code for that day - check their blended learning group assignment If an assignment is marked as Virtual > Synchronous, count that day for this field. If none of the above are true, do not count that day for this field If the day is counted for this field, it will NOT count for standard attendance (field above) If the student value is 0.0, do not report the element.	O	Program Participation > State Programs > Residential Facilities / calculated
TX1600	RATotalElig Residential FacilityDays Present	Indicates the total number of days the student was remote asynchronous present and eligible for LEA services in a Residential Facility during a particular reporting period	RA-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT	For all days that qualify in the field above, do the following: For every day that a student is present, do the following: If the student has an attendance code of RA for that day - count that day for this field If the student has an attendance code of RS OR IP - ignore that day for this field If the student does not have an applicable attendance code for that day - check their blended learning group assignment If an assignment is marked as Virtual > Asynchronous count that day for this field If none of the above are true, do not count that day for this field If day is counted for this field it will NOT count for standard attendance (field above) If the student value is 0.0, do not report the element	O	Program Participation > State Programs > Residential Facilities / calculated