Teacher/Section Federally Funded Check Report

Introduction

This report uses the current school and term to check for sections and teachers that are erroneously marked as federally funded. If a staff member has a Staff Assignment record for federally funded status, then the sections the teacher is assigned to must be marked as federally funded. The reverse is also true: if a section is marked as federally funded, the teacher assigned to the section must have a Staff Assignment record for federally funded status.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Section Selection

The report selects records from the [Sections] table based on the following criteria:

The section must be assigned the current term (the term you are logged into when you run the report).
The section must be assigned to the current school (the school you are logged into when you run the report).

Report Input

For help with navigation and report generation, see How to Find and Generate a Report.

This report has no specified parameters.

Report Output

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

Item #	Data Element	Description	[Table]FieldName
1	Teacher	The teacher's name.	[Users]LastFirst
2	Federally Funded Teacher	The report displays Y or N to indicate whether the teacher is federally funded. To be considered federally funded, the teacher must have a federally funded staff assignment record within the current term. The teacher must meet the following criteria: The teacher must have a Staff Assignment record with the code "(FD) Federally Funded." The teacher's Assignment Begin Date must occur on or before the first day of the current term. The teacher's Assignment End Date must occur on or after the first day of the current term.	[S_TN_USR_StaffAssignments_C]StaffAssignment=FD [S_TN_USR_StaffAssignments_C]AssignmentBeginDate [S_TN_USR_StaffAssignments_C]AssignmentEndDate
3	Course.Section	The course number and section number, separated by a period.	[Sections]Course_Number [Sections]Section_Number
4	Course Name	The name of the course.	[Courses]Course_Name
5	Federally Funded Section	The report displays Y or N to indicate whether the section is federally funded. The section must have a value of "(Y) Yes" chosen for the field "Federally Funded Class" on the Edit Section page.	[S_TN_SEC_X]FederalllyFunded

Back to Top