CTE Program 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 = 1/2/3/6 Enrolled in a CTE course during the reporting period CATE Contact Hours = V1, V2, or V3 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 = 1/2/3/6

Enrolled in a CTE course during the reporting period

CATE Contact Hours = V1, V2, or V3

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

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.

Attendance Event Indicator Code Table

Code	Name	Eligible ADA Values	Data Setup
03	Regular - CTE	1/2/3/4/5/6	Enrolled in a CTE course during the reporting period

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

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	System Admin > Calendar > Calendar > Schedule
TX300	gradeLevel Descriptor		GRADE-LEVEL-CODE	Report the student's Grade from the most current Enrollment.	M	Student Information > General > Enrollments Tab > 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	System Admin > Calendar > Calendar > School Months (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	System Admin > Calendar > Calendar > School Months (Attendance Periods)
TX800	cteServiceID Descriptor	Refers to the approved career and technical education course that generates contact hours during a particular reporting period.	SERVICE-ID	1. Report the State Code from the Course(s) as the Service ID. HOWEVER, a) if there are any students actively enrolled in the Course > Section OR students were actively enrolled with a different Service ID (Roster Batch Edit > Course State code (override)) report the Course State Code (override) as the Service ID. EXAMPLE: A Course has a State Code of N1234567, but two students in the Course have a Service ID of ABCD0987 entered on the Roster Batch Edit Course State Code override, TWO 300 records would report for this Course > Section, one for each Service ID. If the Service ID entered in the Course State Code (override) in Roster Batch Edit is greater than 8 characters in length, report 8 zeros on the extract. 2. A Course with a blank Sate Code (Service ID) should not report UNLESS a) there is a Course State Code (override) in Roster Batch Edit, if so, report as Service ID IF b) both are blank, Course should not report. 3. A State Code or Course State Code (override) that begins with a SA, SE, SR, SS, 01, 8 or 9 should not report. `"namespace": "uri://tea.texas.gov/CTEServiceIdDescriptor"`	M	Scheduling > Course > Course/Section > Section Editor > Roster Batch Editor > Section ID OR Scheduling> Course > Course Editor > State Code
TX900	EligibleDays PresentV1	Indicates the total number of days the student was eligible and present and enrolled in an approved career and technical course that generated one contact hour during a particular reporting period.	ELIGIBLE-DAYS-PRESENT-V1	Report the total eligible days present in the Attendance Period in which the V-code on the course scheduled is 1. Otherwise, report 0.0. If a student has a CTE program record containing values in Exempt Start Date AND Exempt End Date, do not consider any dates within that range in the calculation. For example, if the Attendance Period contains 30 days, the student is in a course with a V1 code, and the student is present for all days in the RP, 30.0 would report. If the student dropped the V1-coded course after 15 days, 15.0 would report. Format XXX.X All 3 combined fields must report together (EligibleDaysPresentV1 / RSEligibleDaysPresentV1/ RAEligibleDaysPresentV1) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1000	RSEligibleDays PresentV1	Indicates the total number of days the student was eligible, remote synchronous present and enrolled in an approved career and technical course that generated one contact hour during a particular reporting period.	RS-ELIGIBLE-DAYS-PRESENT-V1	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 the 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 V code (field above) All 3 combined fields must report together (EligibleDaysPresentV1 / RSEligibleDaysPresentV1/ RAEligibleDaysPresentV1) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1100	RAEligibleDays PresentV1	Indicates the total number of days the student was eligible, remote asynchronous present and enrolled in an approved career and technical course that generated one contact hour during a particular reporting period.	RA-ELIGIBLE-DAYS-PRESENT-V1	For all days that qualify in the field above (E0950) 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 the 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 V code (field above) All 3 combined fields must report together (EligibleDaysPresentV1 / RSEligibleDaysPresentV1/ RAEligibleDaysPresentV1) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1200	EligibleDays PresentV2	Indicates the total number of days the student was eligible and present and enrolled in an approved career and technical course that generated two contact hours during a particular reporting period.	ELIGIBLE-DAYS-PRESENT-V2	Report the total eligible days present in the Attendance Period in which the V-code on the course scheduled is 2. Otherwise, report 0.0. If the student has a CTE program record that contains values in Exempt Start Date AND Exempt End Date, do not consider any dates contained within that range in the calculation. For example, if the Attendance Period contains 30 days, the student is in a course with a V2 code, and the student is present for all days in the RP, 30.0 would report. If the student dropped one of the V2-coded courses after 15 days, 15.0 would report in this field. Format XXX.X (EligibleDaysPresentV2/ RSEligibleDaysPresentV2 / RAEligibleDaysPresentV2) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1300	RSEligibleDays PresentV2	Indicates the total number of days the student was eligible, remote synchronous present and enrolled in an approved career and technical course that generated two contact hours during a particular reporting period.	RS-ELIGIBLE-DAYS-PRESENT-V2	For all days that qualify in the field above (EligibleDays PresentV2) 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 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 V code (field above). (EligibleDaysPresentV2/ RSEligibleDaysPresentV2 / RAEligibleDaysPresentV2) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1400	RAEligibleDays PresentV2	Indicates the total number of days the student was eligible, remote asynchronous present and enrolled in an approved career and technical course that generated two contact hours during a particular reporting period.	RA-ELIGIBLE-DAYS-PRESENT-V2	For all days that qualify in the field above (EligibleDaysPresentV2) 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 the 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 V code (field above). All 3 combined fields must report together (EligibleDaysPresentV2/ RSEligibleDaysPresentV2 /RAEligibleDaysPresentV2) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1500	EligibleDays PresentV3	Indicates the total number of days the student was eligible and present and enrolled in an approved career and technical course that generated three contact hours during a particular reporting period.	ELIGIBLE-DAYS-PRESENT-V3	Report the total eligible days present in the Attendance Period in which the V-code on the course scheduled is 3. Otherwise, report 0.0. If the student has a CTE program record that contains values in Exempt Start Date AND Exempt End Date, do not consider any dates contained within that range in the calculation. For example, if the Attendance Period contains 30 days, the student is in a course with a V3 code, and the student is present for all days in the RP, 30.0 would report. Format XXX.X All 3 combined fields must report together (EligibleDaysPresentV3 / RSEligibleDaysPresentV3 / RAEligibleDaysPresentV3) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.		Course > CTE Contact Hours / Calculated
TX1600	RSEligibleDays PresentV3	Indicates the total number of days the student was eligible, remote synchronous present and enrolled in an approved career and technical course that generated three contact hours during a particular reporting period.	RS-ELIGIBLE-DAYS-PRESENT-V3	For all days that qualify in the field above (EligibleDaysPresentV3) 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 RA OR IP attendance code, 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 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 V code (field above). All 3 combined fields must report together (EligibleDaysPresentV3 / RSEligibleDaysPresentV3 / RAEligibleDaysPresentV3) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated
TX1700	RAEligibleDays PresentV3	Indicates the total number of days the student was eligible, remote asynchronous present and enrolled in an approved career and technical course that generated three contact hours during a particular reporting period.	RA-ELIGIBLE-DAYS-PRESENT-V3	For all days that qualify in the field above (RSEligibleDays PresentV3) 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 RS OR IP attendance code, 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 the 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 V code (field above). All 3 combined fields must report together (EligibleDaysPresentV3 / RSEligibleDaysPresentV3 / RAEligibleDaysPresentV3) - total of all 3 fields must equal Total Eligible Days Present for this Attendance Type.	O	Course > CTE Contact Hours / Calculated