Campus Summary 22-23

Introduction

A new version of the Campus Summary (Version 22.12.2) is now available on the state reports page. This version is completely revised with a new layout that presents the data in a similar format as in the TEA PDM3-130-001 Superintendent’s Report of Attendance.

Note: The legacy version of the prior Campus Summary (version 22.5.1) is temporarily preserved on the state reports page but is not recommended for use. This version does not contain any of the new or revised elements and related calculations. The legacy report will be removed in a subsequent release.

The Campus Summary report provides a summary of student membership and attendance information for a selected reporting period. You can generate this report for a specific date range or a pre-defined reporting period at the school or district level.

This summary has five parts:

Table I - Attendance Totals
Table II – Career & Technology Code Summary
Table III – Instructional Setting Code Summary
Table IV – Gifted and Talented Students
Oaths and Affidavits signature page

New Instructional Methods Parameter
- Combined Option: In-Person (IP), Remote Synchronous (RS), and Remote Asynchronous (RA) are combined to present the total days of attendance for each type on a single line, similar to the legacy Campus Summary.
- Separate Option
  - The sub-totals for IP, RS, and RA Days Eligible are displayed on separate lines wherever required, similar to the records reported in the Summer PEIMS Attendance Interchange.
  - Any schools with remote RS or RA Attendance must have the appropriate Attendance Code Categories setup in place for the “RSC” (Remote Synchronous Category) and/or “RAC” (Remote Asynchronous Category), and at least one attendance code assigned to each category in use.
Report Options for Merged or Separate Tracks: no change to existing functionality
- As before, if “Separate Tracks” is selected, each track is output with a separate set of pages, and the “Number of Days Taught” is displayed for each track.
- If “Merged Tracks” is selected, all data are presented within a single set of pages for the school and/or district; “Number of Days Taught” is not displayed. Charter districts should use this option and set the “Include FSP Summary Page” parameter to “Yes” when generating the report for data entry in the TEA FSP Funding application.
Table I – Attendance Totals
- Grade Levels and their subtotals now display horizontally across the page, followed by a Total column.
- The calculations for attendance days and FTEs now display vertically down the page.
- Data are presented using the numbering conventions and labels from the TEA Superintendent’s Report.
- In addition to the elements, sub-totals for IP, RS,and RA Days Eligible are also included when the Instructional Methods parameter is set to “Separate.”
Table II - Career and Technology Code Summary
- This page is revised to report CTE Attendance based on a combination of the Vocational Contact Hours value (V1, V2, V3) assigned to the CTE course in PowerSchool, the CTE Course Weighted Funding Tier assigned by TEA, and each student’s scheduled CTE classes.
- As before, any CTE Hours exclusions entered at the Section level or the individual student level in the Career and Tech special program record is considered in the calculations.
- These calculations reference the TEA “All CTE Courses Weighted Tiers Excel” lookup table to determine the Funding Tier and Weight for each CTE Service ID. Note that the current version of this table is for 2021-22, and TEA has not yet published updates for the 2022-23 school year. Any CTE Service IDs missing from the TEA lookup table are automatically assigned a Tier 1 Funding Weight.
  - CTE Funding Tier 1: Weight 1.1
  - CTE Funding Tier 2: Weight 1.28
  - CTE Funding Tier 3: Weight 1.47
- Within each of the three Funding Tiers, Days Eligible V1, V2, and V3 are calculated and multiplied by the applicable funding tier weight (contact hour multiplier). The contact hours for each tier are then summed to arrive at the Total Contact Hours for Tier 1, Tier 2, and Tier 3.
- The Total Contact Hours for each tier are divided by (Days Taught × 6 hours) to arrive at the CTE FTE for each of the three tiers.
Table III - Instructional Setting Code Summary: There are no changes to this page or to the calculations.
FSP Six-Week Report Detail
- Set the “Include FSP Summary Page” parameter to “Yes” to include this page.
- The presentation of the data is now modified to conform to the current TEA FSP Six-Week Report Detail web page layout, element order, and naming conventions.
- As before, the PowerSchool District Summary Equivalents are listed in the far right column.
Calculations Legend
- Calculation details and formulae are now listed for each item appearing in Table I - Attendance Totals.
- The same calculations are applied to the PowerSchool data for any element reported on the TEA PDM3-130-001 Superintendent’s Report of Attendance.

Selection Criteria

Selection criteria determine which database records are used in the report. For the Campus Summary, student membership and attendance records are selected.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.

The Campus Summary is updated with a parameter available when the user is logged into a single school, the user can include other schools that report under the same TEA CDC number as the login school.

Student Selection

The report selects which student records to use based on the following criteria:

The student must not be excluded from PEIMS reporting.
The student must be enrolled in the district for at least one day during the selected reporting period.

Attendance Selection

The report calculates attendance fields based on the following criteria:

The attendance item must be flagged as Counts for ADA, OR the Official Attendance Period flag must be set. If the Official Attendance Period is set, the report calculates based on the periods set as the Official Attendance Period.
If multiple periods are set for either the Official Attendance Period and Counts for ADA indicator and the student is absent for either period, the report calculates the student as absent.
If a student is marked Absent but the item is counted under the Present for Funding attendance category, the report counts the student as present.

Flexible Attendance Selection

The report calculates flexible attendance fields based on the following criteria:

The student must have a Flexible Attendance Program Type Code of (02) HSEP or (6) OFSDP.
The student must have ADA Eligibility Code of (07) Eligible - Flexible Attendance or (08) Ineligible - Flexible Attendance covering each day of enrollment in the flex program.
- Students with an ADA Eligibility Code of (08) Ineligible - Flexible Attendance do not qualify for Special Program Flexible Attendance and will be reported only with Regular Flex Attendance records.
The student must have a minimum of 45 daily minutes. Days with minutes under 45 are ignored in the calculations.
Students can have a maximum of 600 daily minutes. Daily minutes over 600 are ignored in the calculations.
When converting the total flexible minutes into equivalent Days Present and Days Eligible for Special Programs, the total flex minutes for the reporting period are summed, divided by 360 for HSEP and 240 for OFSDP, and rounded down to the nearest half day.
For Special Programs, flex minutes are counted only for days where the student is a program participant.

Report Input

For help with report navigation and generation, see Generate Reports.

Each of the available run options and data fields for the report is described below.

Field	Description
Select Schools	At the District Level: Select All Schools to run the extract for all schools that are not excluded from state reporting. Selecting Multiple Schools allows you to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract. At the School Level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Current School Only to run the extract just for the current school.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
School Year	Choose the school year for the student membership and attendance data you want to include on the report.
Pages to Include	Use the Shift and Control (Option) keys to select particular pages or all pages of the report.
Report Period	Choose the reporting period for the student membership and attendance data you want to include on the report. If you only want to run for a specific date range it doesn’t matter what you put in this field.
Override Start Date	If you only want to run for certain dates in a Reporting Period, select the first date in the date range from the calendar provided.
Override End Date	If you only want to run for certain dates in a Reporting Period, select the end date in the date range from the calendar provided.
Report Options	Choose Both Merged Tracks to generate the Campus and District Summary with merged tracks. This generates one Campus Summary per school and one District Summary. Keep in mind that when the tracks are merged the formulas divide by the largest number of days in a reporting period for all schools. Choose Both Separate Tracks to generate the Campus and District Summary with separate reports for each track. There may be multiple Campus Summary reports per school and multiple District Summary reports per LEA. Choose Campus Summary Only Merged Tracks to generate the Campus Summary with merged tracks. This generates one report per school. Keep in mind that when the tracks are merged the formulas divide by the largest number of days in a reporting period for all schools. Choose Campus Summary Only Separate Tracks to generate the Campus Summary with separate tracks. This may generate multiple reports per school depending of whether or not they have tacks. Choose District Summary Only Merged Tracks to generate the District Summary with merged tacks. This generates one report per LEA. Keep in mind that when the tracks are merged the formulas divide by the largest number of days in a reporting period for all schools. Choose District Summary Only Separate Tracks to generate the District Summary with separate tracks. This may generate multiple reports per LEA depending on whether or not they have tracks.
Report Sort	Choose School Name to sort the report alphabetically by school name or School Number to sort the report Alpha-numerically by school ID.
Include Instructional Setting Groups	Select Yes if you want to include instructional setting groups, else select No.
Attendance to Include	Select attendance to include.
Include FSP Summary Page	Select Yes if you want to include FSP summary page, else select No.
Instructional Methods	Select one of the options: Combined Separate
Run Now	Select this option if the user wants to run the report immediately.
Schedule	Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

Report Output

Table I – Attendance Totals

Combined Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item # or Position	Data Element	Description	Table[FieldName]
	Campus	This field contains one of the following depending on the Summary Option selected: The 6-digit County District Number of the district, including any leading zeros as necessary, and the District Name. The unique County District Campus number of the campus in which the student is enrolled and the campus name.	[Prefs]DistrictNumber [Prefs]DistrictName [Schools]School_Number [Schools]Name
	Reporting Period Reporting Period Label	This field contains the date range for the Reporting Period selected on the Campus Summary report interface page and the Report Period Value.	Derived
	Instructional Track	This field contains the instructional track assigned to the students.	[S_TX_SCH_SCHOOLS_C]Track [Students]Track
A	Days Taught	This field contains the number of days of instruction offered, as shown on the school calendar, during the specified reporting period and track.	Calculated
1	Grade Level Total	One row prints for each grade in the district. A row contains data only if that grade level is included in the campus to which the student membership and attendance data pertain. This row contains the totals for all applicable grade levels.	Calculated
B	Days Membership	The total days of membership for all students on the specific track prints for each applicable grade level. All of the In-Session ADA periods the student has between the reporting period starting and ending dates are evaluated. If the ADA code is 2, 5, or 6 the membership is divided by 2 for that time period.	Calculated
C	Days Absent	The total number of days that students on a specific track were absent for that specific reporting period prints for each applicable grade level. If the ADA code is 2, 5, or 6 the membership is divided by 2 for that time period.	Calculated
D	Days Present	The total number of days that students were present prints for each applicable grade level. This value is calculated: Item B – Item C.	Calculated
E	Days Ineligible	The total number of days that students on a specific track were present and ineligible for Foundation School Program funding during a particular reporting period prints for each applicable grade level. Any student with ADA code of 4 or 5 is included in this calculation. If the ADA code is 5, the total ineligible days is divided by 2 for that time period for that student.	[S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
F	Days Eligible	The total number of days that students on a specific track were present and eligible for Foundation School Program funding during a particular reporting period prints for each applicable grade level. Any student with ADA code of 1, 2, 3, or 6 is included in this calculation. If the ADA code is 2 or 6, the total eligible days is divided by 2 for that time period for that student.	[S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
F	Days Eligible In-Person (IP)	Sum of Eligible Days Present	Calculated
F	Days Eligible Remote Synchronous (RS)	Sum of Eligible Days Present	Calculated
F	Days Eligible Remote Asynchronous (RA)	Sum of Eligible Days Present	Calculated
G1	BE (10) Days Bilingual EL/EB	Sum of Eligible Days Present of Students with Fund Code (BE)	Calculated
G1	BE (10) Days Bilingual EL/EB In-Person (IP)	Sum of Eligible Days Present of Students with Fund Code (BE)	Calculated
G1	BE (10) Days Bilingual EL/EB Remote Synchronous (RS)	Sum of Eligible Days Present of Students with Fund Code (BE)	Calculated
G1	BE (10) Days Bilingual EL/EB Remote Asynchronous (RA)	Sum of Eligible Days Present of Students with Fund Code (BE)	Calculated
G2	D1 (.15) Days Bilingual Dual language	Sum of Eligible Days Present of Students with a Fund Code (D1)	Calculated
G2	D1 (.15) Days Bilingual Dual language In-Person (IP)	Sum of Eligible Days Present of Students with a Fund Code (D1)	Calculated
G2	D1 (.15) Days Bilingual Dual language Remote Synchronous (RS)	Sum of Eligible Days Present of Students with a Fund Code (D1)	Calculated
G2	D1 (.15) Days Bilingual Dual language Remote Asynchronous (RA)	Sum of Eligible Days Present of Students with a Fund Code (D1)	Calculated
G3	D2 (.15) (EL) Days Bilingual Dual language	The total number of days that students on a specific track were present and eligible for a state-approved bilingual/ESL program during a particular reporting period prints for each grade level. Students must be ADA code not 0, 4 or 5 and either E1042 of 2 or 3 or E1043 of 2, 3, 4, or 5. If the ADA code is 2 or 6, the total BIL/ESL days is divided by 2 for that time period for that student.	[S_TX_SEN_ESL_X]E1043_ESL_Program [S_TX_SEN_ESL_X]E1042_Bilingual_Program [S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
G3	D2 (.15) (EL) Days Bilingual Dual language In-Person (IP)	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and EL/EB = 1	Calculated
G3	D2 (.15) (EL) Days Bilingual Dual language Remote Synchronous (RS)	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and EL/EB = 1	Calculated
G3	D2 (.15) (EL) Days Bilingual Dual language Remote Asynchronous (RA)	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and EL/EB = 1	Calculated
G.2 + G.3	Total Days Bil Dual Lang	G.2 D1 Days Bil Dual Lang + G.3 D2 (EL) Days Bil Dual Lang	Calculated
G.2 + G.3	Total Days Bil Dual Lang In-Person (IP)	G.2 D1 Days Bil Dual Lang + G.3 D2 (EL) Days Bil Dual Lang	Calculated
G.2 + G.3	Total Days Bil Dual Lang Remote Synchronous (RS)	G.2 D1 Days Bil Dual Lang + G.3 D2 (EL) Days Bil Dual Lang	Calculated
G.2 + G.3	Total Days Bil Dual Lang Remote Asynchronous (RA)	G.2 D1 Days Bil Dual Lang + G.3 D2 (EL) Days Bil Dual Lang	Calculated
	(D2 = D3) Total Days Bilingual Dual language	Total Days Bilingual Dual language	Calculated
G4	D2 (EP) Days Bilingual Dual language	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and LEP not = 1	Calculated
G4	D2 (EP) Days Bilingual Dual language In-Person (IP)	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and LEP not = 1	Calculated
G4	D2 (EP) Days Bilingual Dual language (RS)	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and LEP not = 1	Calculated
G4	D2 (EP) Days Bilingual Dual language Remote Asynchronous (RA)	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and LEP not = 1	Calculated
H1	Days K-3 Eco	Sum of Eligible Days Present of Students in Grades K - 3 that are Economic Disadvantaged	Calculated
H2	Days K-3 Bil	Sum of Eligible Days Present of Students in Grades K - 3 with a Fund Code (BE, D1, D2) and LEP = 1	Calculated
	Total Days K-3 Eco/Bill	H.1 Days K-3 Eco + H.2 Days K-3 Bil	Calculated
H3	Days K-3 Eco+Bill	Sum of Eligible Days Present of Students in Grades K - 3 that are Economic Disadvantaged AND with a Fund Code (BE, D1, D2) and LEP = 1	Calculated
I	Days Res Fac	Sum of Eligible Days Present of Students in a Residential Facility	Calculated
I	Days Res Fac In-Person (IP)	Sum of Eligible Days Present of Students in a Residential Facility	Calculated
I	Days Res Fac Remote Synchronous (RS)	Sum of Eligible Days Present of Students in a Residential Facility	Calculated
I	Days Res Fac Remote Asynchronous (RA)	Sum of Eligible Days Present of Students in a Residential Facility	Calculated
J	Days PRS	Sum of Eligible Days Present of Students in a PRS program	Calculated
J	Days PRS In-Person (IP)	Sum of Eligible Days Present of Students in a PRS program	Calculated
J	Days PRS Remote Synchronous (RS)	Sum of Eligible Days Present of Students in a PRS program	Calculated
J	Days PRS Remote Asynchronous (RA)	Sum of Eligible Days Present of Students in a PRS program	Calculated
K	Days Sped Main	Sum of Eligible Days Present of Students in Special Education Mainstream (Instructional Setting 40	Calculated
K	Days Sped Main In-Person In-Person (IP)	Sum of Eligible Days Present of Students in Special Education Mainstream (Instructional Setting 40	Calculated
K	Days Sped Main Remote Synchronous (RS)	Sum of Eligible Days Present of Students in Special Education Mainstream (Instructional Setting 40	Calculated
K	Days Sped Main Remote Asynchronous (RA)	Sum of Eligible Days Present of Students in Special Education Mainstream (Instructional Setting 40	Calculated
L.1	BE Bil EL/EB Ref. ADA	G.1 BE Days Bil EL/EB / Number of Days Taught	Calculated
L.2	D1 Bil Dual Lang Ref. ADA	G.2 D1 Days Bil Dual Lang / Number of Days Taught	Calculated
L.3	D2 (EL) Bil Dual Lang Ref. ADA	G.3 D2 (EL) Days Bil Dual Lang / Number of Days Taught	Calculated
	(L.2 + L.3) Total Bil Dual Lang Ref. ADA	L.2 D1 Bil Dual Lang Refined ADA + L.3 D2 (EL) Bil Dual Lang Ref. ADA	Calculated
L.4	D2 (EP) Bil Dual Lang Ref. ADA	G.4 D2 (EP) Days Bil Dual Lang / Number of Days Taught	Calculated
M	Res Fac Ref. ADA	I. Days Residential Facility / Number of Days Taught	Calculated
N	Sped Main Ref. ADA	K. Days Special Education Mainstream / Number of Days Taught	Calculated
O.1	K-3 Eco Ref. ADA	H.1 Days K-3 Eco / Number of Days Taught	Calculated
O.2	K-3 Bil Ref. ADA	H.2 Days K-3 Bil / Number of Days Taugh	Calculated
	(O.1 + O.2) Total K-3 Eco/Bil Ref. ADA	O.1 K-3 Eco Refined ADA + O.2 K-3 Bil Refined ADA	Calculated
O.3	K-3 Eco + Bil Ref. ADA	H.3 Days K-3 Eco/Bil / Number of Days Taught	Calculated
	PRS Ref. ADA	J. Days PRS / Number of Days Taught	Calculated
P	PRS FTE	J. (Days PRS * .2936) / Number of Days Taught	Calculated
Q.1	CTE FTE Tier 1	Table II Total Tier 1 Hours / (6 * Number of Days Taught)	Calculated
Q.1	CTE FTE Tier 1 In-Person (IP)	Table II Total Tier 1 Hours / (6 * Number of Days Taught)	Calculated
Q.1	CTE FTE Tier 1 Remote Synchronous (RS)	Table II Total Tier 1 Hours / (6 * Number of Days Taught)	Calculated
Q.1	CTE FTE Tier 1 Remote Asynchronous (RA)	Table II Total Tier 1 Hours / (6 * Number of Days Taught)	Calculated
Q.2	CTE FTE Tier 2	Table II Total Tier 2 Hours / (6 * Number of Days Taught)	Calculated
Q.2	CTE FTE Tier 2 In-Person (IP)	Table II Total Tier 2 Hours / (6 * Number of Days Taught)	Calculated
Q.2	CTE FTE Tier 2 Remote Synchronous (RS)	Table II Total Tier 2 Hours / (6 * Number of Days Taught)	Calculated
Q.2	CTE FTE Tier 2 Remote Asynchronous (RA)	Table II Total Tier 2 Hours / (6 * Number of Days Taught)	Calculated
Q.3	CTE FTE Tier 3	Table II Total Tier 3 Hours / (6 * Number of Days Taught)	Calculated
Q.3	CTE FTE Tier 3 In-Person (IP)	Table II Total Tier 3 Hours / (6 * Number of Days Taught)	Calculated
Q.3	CTE FTE Tier 3 Remote Synchronous (RS)	Table II Total Tier 3 Hours / (6 * Number of Days Taught)	Calculated
Q.3	CTE FTE Tier 3 Remote Asynchronous (RA)	Table II Total Tier 3 Hours / (6 * Number of Days Taught)	Calculated
R	Sped FTE	Table III Contact Hours / (6 * Number of Days Taught)	Calculated
S	Reg Prog Ref. ADA: revised-K-3 Eco Dis/Bil removed	T. Total Refined ADA - (Q.1 CTE FTE Tier 1 + Q.2 CTE FTE Tier 2 + Q.3 CTE FTE Tier 3 + R. Special Education FTE)	Calculated
T	Total Ref. ADA	F. Days Eligible / Number of Days Taught	Calculated
U	Percent Attendance	Calculation: D. Days Present / B. Days Membership	Calculated

Separate Output

Item # or Position	Data Element	Description	Table[FieldName]
	Campus	This field contains one of the following depending on the Summary Option selected: The 6-digit County District Number of the district, including any leading zeros as necessary, and the District Name. The unique County District Campus number of the campus in which the student is enrolled and the campus name.	[Prefs]DistrictNumber [Prefs]DistrictName [Schools]School_Number [Schools]Name
	Reporting Period Reporting Period Label	This field contains the date range for the Reporting Period selected on the Campus Summary report interface page and the Report Period Value.	Derived
	Instructional Track	This field contains the instructional track assigned to the students.	[S_TX_SCH_SCHOOLS_C]Track [Students]Track
A	Days Taught	This field contains the number of days of instruction offered, as shown on the school calendar, during the specified reporting period and track.	Calculated
1	Grade Level Total	One row prints for each grade in the district. A row contains data only if that grade level is included in the campus to which the student membership and attendance data pertain. This row contains the totals for all applicable grade levels.	Calculated
B	Days Membership	The total days of membership for all students on the specific track prints for each applicable grade level. All of the In-Session ADA periods the student has between the reporting period starting and ending dates are evaluated. If the ADA code is 2, 5, or 6 the membership is divided by 2 for that time period.	Calculated
C	Days Absent	The total number of days that students on a specific track were absent for that specific reporting period prints for each applicable grade level. If the ADA code is 2, 5, or 6 the membership is divided by 2 for that time period.	Calculated
D	Days Present	The total number of days that students were present prints for each applicable grade level. This value is calculated: Item B – Item C.	Calculated
E	Days Ineligible	The total number of days that students on a specific track were present and ineligible for Foundation School Program funding during a particular reporting period prints for each applicable grade level. Any student with ADA code of 4 or 5 is included in this calculation. If the ADA code is 5, the total ineligible days is divided by 2 for that time period for that student.	[S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
F	Days Eligible	The total number of days that students on a specific track were present and eligible for Foundation School Program funding during a particular reporting period prints for each applicable grade level. Any student with ADA code of 1, 2, 3, or 6 is included in this calculation. If the ADA code is 2 or 6, the total eligible days is divided by 2 for that time period for that student.	[S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
G1	BE (10) Days Bilingual EL/EB	Sum of Eligible Days Present of Students with Fund Code (BE)	Calculated
G2	D1 (.15) Days Bilingual Dual language	Sum of Eligible Days Present of Students with a Fund Code (D1)	Calculated
G3	D2 (.15) (EL) Days Bilingual Dual language	The total number of days that students on a specific track were present and eligible for a state-approved bilingual/ESL program during a particular reporting period prints for each grade level. Students must be ADA code not 0, 4 or 5 and either E1042 of 2 or 3 or E1043 of 2, 3, 4, or 5. If the ADA code is 2 or 6, the total BIL/ESL days is divided by 2 for that time period for that student.	[S_TX_SEN_ESL_X]E1043_ESL_Program [S_TX_SEN_ESL_X]E1042_Bilingual_Program [S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
G.2 + G.3	Total Days Bil Dual Lang	G.2 D1 Days Bil Dual Lang + G.3 D2 (EL) Days Bil Dual Lang	Calculated
	(D2 = D3) Total Days Bilingual Dual language	Total Days Bilingual Dual language	Calculated
G4	D2 (EP) Days Bilingual Dual language	Sum of Eligible Days Present of Students with a Fund Code (D2) and Bil Code = 4 and LEP not = 1	Calculated
H1	Days K-3 Eco	Sum of Eligible Days Present of Students in Grades K - 3 that are Economic Disadvantaged	Calculated
H2	Days K-3 Bil	Sum of Eligible Days Present of Students in Grades K - 3 with a Fund Code (BE, D1, D2) and LEP = 1	Calculated
	Total Days K-3 Eco/Bill	H.1 Days K-3 Eco + H.2 Days K-3 Bil	Calculated
H3	Days K-3 Eco+Bill	Sum of Eligible Days Present of Students in Grades K - 3 that are Economic Disadvantaged AND with a Fund Code (BE, D1, D2) and LEP = 1	Calculated
I	Days Res Fac	Sum of Eligible Days Present of Students in a Residential Facility	Calculated
J	Days PRS	Sum of Eligible Days Present of Students in a PRS program	Calculated
K	Days Sped Main	Sum of Eligible Days Present of Students in Special Education Mainstream (Instructional Setting 40	Calculated
L.1	BE Bil EL/EB Ref. ADA	G.1 BE Days Bil EL/EB / Number of Days Taught	Calculated
L.2	D1 Bil Dual Lang Ref. ADA	G.2 D1 Days Bil Dual Lang / Number of Days Taught	Calculated
L.3	D2 (EL) Bil Dual Lang Ref. ADA	G.3 D2 (EL) Days Bil Dual Lang / Number of Days Taught	Calculated
	(L.2 + L.3) Total Bil Dual Lang Ref. ADA	L.2 D1 Bil Dual Lang Refined ADA + L.3 D2 (EL) Bil Dual Lang Ref. ADA	Calculated
L.4	D2 (EP) Bil Dual Lang Ref. ADA	G.4 D2 (EP) Days Bil Dual Lang / Number of Days Taught	Calculated
M	Res Fac Ref. ADA	I. Days Residential Facility / Number of Days Taught	Calculated
N	Sped Main Ref. ADA	K. Days Special Education Mainstream / Number of Days Taught	Calculated
O.1	K-3 Eco Ref. ADA	H.1 Days K-3 Eco / Number of Days Taught	Calculated
O.2	K-3 Bil Ref. ADA	H.2 Days K-3 Bil / Number of Days Taugh	Calculated
	(O.1 + O.2) Total K-3 Eco/Bil Ref. ADA	O.1 K-3 Eco Refined ADA + O.2 K-3 Bil Refined ADA	Calculated
O.3	K-3 Eco + Bil Ref. ADA	H.3 Days K-3 Eco/Bil / Number of Days Taught	Calculated
	PRS Ref. ADA	J. Days PRS / Number of Days Taught	Calculated
P	PRS FTE	J. (Days PRS * .2936) / Number of Days Taught	Calculated
Q.1	CTE FTE Tier 1	Table II Total Tier 1 Hours / (6 * Number of Days Taught)	Calculated
Q.2	CTE FTE Tier 2	Table II Total Tier 2 Hours / (6 * Number of Days Taught)	Calculated
Q.3	CTE FTE Tier 3	Table II Total Tier 3 Hours / (6 * Number of Days Taught)	Calculated
R	Sped FTE	Table III Contact Hours / (6 * Number of Days Taught)	Calculated
S	Reg Prog Ref. ADA: revised-K-3 Eco Dis/Bil removed	T. Total Refined ADA - (Q.1 CTE FTE Tier 1 + Q.2 CTE FTE Tier 2 + Q.3 CTE FTE Tier 3 + R. Special Education FTE)	Calculated
T	Total Ref. ADA	F. Days Eligible / Number of Days Taught	Calculated
U	Percent Attendance	Calculation: D. Days Present / B. Days Membership	Calculated

Table II – Career & Technology Code Summary

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item # or Position	Data Element	Description	Table[FieldName]
	Campus	This field contains one of the following depending on the Summary Option selected: The 6-digit County District Number of the district, including any leading zeros as necessary, and the District Name. The unique County District Campus number of the campus in which the student is enrolled and the campus name.	[Prefs]DistrictNumber [Prefs]DistrictName [Schools]School_Number [Schools]Name
	Reporting Period	This field contains the date range for the Reporting Period selected on the Campus Summary report interface page and the Report Period Value.	Derived
	Instructional Track	This field contains the instructional track assigned to the students.	[S_TX_SCH_SCHOOLS_C]Track [Students]Track
1	Vocational Code	V1 Contact Hours = Eligible Days Present V1 (E0950) V2 Contact Hours = Eligible Days Present V2 (E0951) times 2 V3 Contact Hours = Eligible Days Present V3 (E0952) times 3
2	T1 Days	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
3	T1 Hours	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
4	T1 FTE	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
5	T2 Days	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
6	T2 Hours	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
7	T2 FTE	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
8	T3 Days	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
9	T3 Hours	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated
10	T3 FTE	This column contains the FTE calculation for each CTE code and the total Career & Technical Ed FTE (used in the calculation of Item M in Table I. This value is calculated: Item 7 / (6 * Table I Item A)	Calculated

Table III – Instructional Setting Code Summary

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

At the campus level, campuses that have students on different attendance tracks will get a report for each track. At the district level if any campus has more than one track, a report is generated for each track in the district.

Item # or Position	Data Element	Description	Table[FieldName]
	Campus	This field contains one of the following depending on the Summary Option selected: The 6-digit County District Number of the district, including any leading zeros as necessary, and the District Name. The unique County District Campus number of the campus in which the student is enrolled and the campus name.	[Prefs]DistrictNumber [Prefs]DistrictName [Schools]School_Number [Schools]Name
	Reporting Period	This field contains the date range for the Reporting Period selected on the Campus Summary report interface page and the Report Period Value.	Derived
	Instructional Track	This field contains the instructional track assigned to the students.	[S_TX_SCH_SCHOOLS_C]Track [Students]Track
A	Days Taught	This field contains the number of days of instruction offered, as shown on the school calendar, during the specified reporting period and track.	Calculated
1	Special Education Instructional Setting	This column lists the state-defined special education instructional setting codes and descriptions.	Derived from: [S_TX_SEN_SPD_X]E0173_Instr_Setting
2	Eligible Days Present	This column contains the number of days that special education students on a specific track were eligible to participate in each instructional setting and present during this reporting period. Students must be ADA code not 0, 4 or 5 and E0173 not blank or 40. If the ADA code is 2 or 6, the Eligible Days Present is divided by 2 for that time period for that student.	[S_TX_SEN_SPD_X]E0173_Instr_Setting [S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated
3	Contact Hour Multiplier	This column contains the contact hour multiplier assigned to each instructional setting.	[S_TX_SEN_SPD_X]E0173_Instr_Setting Calculated
4	Contact Hours	This column contains the number of contact hours for the students who were eligible to participate in each instructional setting during this accounting period. This value is calculated: Item 5 * Item 6 Note: If a student has a speech therapy indicator of 2, contact hours are applied to both code 00 and the Instructional Setting code. Excess contact hours (above 6 per day) are applied only to the Instructional Code and not the 00 code.	[S_TX_SEN_SPD_X]E0173_Instr_Setting Calculated
5	Excess Contact Hours	This column contains the contact hours provided to the students in each instructional setting that exceeded the eligible contact hours.	[S_TX_SEN_SPD_X]E0173_Instr_Setting Calculated
6	Eligible Contact Hours	This column contains the contact hours for which special education students were eligible to participate in each instructional setting during this reporting period. This value is calculated: (Item 7 – Item 8)	[S_TX_SEN_SPD_X]E0173_Instr_Setting Calculated
7	FTE	This column contains the FTE calculation for each Instructional Setting and the total Special Education FTE (used in the calculation of Item N in Table I. This value is calculated: Item 9 / (6 * Table I Item A)	[S_TX_SEN_SPD_X]E0173_Instr_Setting Calculated
Flexible Attendance Note: Eligible Days Present include both days and minutes.
	Flexible Attendance Program	The flexible attendance program type code. Valid values: 2 = HSEP 6 = OFSDP	[S_TX_STU_Flexible_ATT_C] E1045_Flexible_Prog_Type
1	Special Education Instructional Setting	This column lists the state-defined special education instructional setting codes and descriptions.	Derived from: [S_TX_SEN_SPD_X]E0173_Instr_Setting
2	Eligible Days Present	The total number of days and minutes that special education students in the flex attendance program and on the specific track were eligible to participate in each instructional setting and present during this reporting period.	Calculated
3	Contact Hour Multiplier	The contact hour multiplier assigned to the instructional setting.	Calculated
4	Contact Hours	The number of contact hours for the students in the flex attendance program who were eligible to participate in each instructional setting during this accounting period.	Calculated
5	Excess Contact Hours	The contact hours provided to the students in each instructional setting that exceeded the eligible contact hours.	Calculated
6	Eligible Contact Hours	The contact hours for which special education students were eligible to participate in each instructional setting during this reporting period.	Calculated
7	FTE	The FTE calculation for each Instructional Setting and the total Special Education FTE.	Calculated

Table IV – Gifted and Talented Students

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

At the campus level, campuses that have students on different attendance tracks will get a report for each track. At the district level is any campus has more than one track, a report is generated for each track in the district.

Item # or Position	Data Element	Description	[Table]FieldName
	Campus	This field contains one of the following depending on the Summary Option selected: The 6-digit County District Number of the district, including any leading zeros as necessary, and the District Name. The unique County District Campus number of the campus in which the student is enrolled and the campus name.	[Prefs]DistrictNumber [Prefs]DistrictName [Schools]School_Number [Schools]Name
	Reporting Period Reporting Period Label	This field contains the date range for the Reporting Period selected on the Campus Summary report interface page and the Report Period Value.	Derived
	Instructional Track	This field contains the instructional track assigned to the students.	[S_TX_SCH_SCHOOLS_C]Track [Students]Track
A	Days Taught	This field contains the number of days of instruction offered, as shown on the school calendar, during the specified reporting period and track.	Calculated
1	Grade	This column contains a list of all grade levels in the district.	Derived
2	Gifted and Talented	This column shows the number of students who participated in a gifted and talented program during the reporting period in each applicable grade level. A total of all gifted and talented students displays at the bottom of the column. Students must be ADA code not 0, 4 or 5 and E0034 is 1 at some point in the reporting period.	[S_TX_SEN_GT_X]E0034_GT [S_TX_STU_STATE_GEN_C]E0787_ADA_Code Calculated