This article will assist users with creating an Ad Hoc Report using the Filter Designer to select students Title VI Affiliation information.
Navigation: Menu > Reporting > Ad Hoc Report > Filter Designer
- Open the Filter Designer in Infinite Campus.
- Under the Create New section, choose Query Wizard for the Filter Type and Student for the Data Type.
- Click Create
- Add "Title VI Affiliation" in the Query Name field.
- Provide a description of the query to help users identify the information included in the query.
- Choose the fields listed below. More fields can be added as needed for local PSU information.
| Pathway | Field |
|---|---|
| Student > Demographics | StateID |
| Student > Demographics | legalFirstName |
| Student > Demographics | legalLastName |
| Student > Demographics | grade |
| Student > Demographics | raceEthnicity |
| Student > Demographics | hispanicEthnicity |
| Student > Demographics | raceEthinicityFed |
| Student > Demographics | activeToday |
| Student > School | number |
| Student > School | name |
| Student > Demographics | tribalEnrollment |
| Student > Learner > Title VI | tribalAffiliation |
| Student > Learner > Title VI | indianIDNumber |
| Student > Learner > Title VI | title6ID |
| Student > Learner > Title VI | title6startDate |
Add other fields as needed.- Click Next to navigate to Filter Parameters.
- Optional: Click the
to remove all fields except title6.StartDate. - Set the title6.startDate operator to IS NOT NULL.
to remove all fields except title6.StartDate.
-
Click Save or Save and Test
- Save and Test will give a view of your output to confirm the output includes data as expected.
- Click Next to navigate to Output Formatting.
- Uncheck the following fields from the output
- student.activeToday
- title6.title5ID
Check or uncheck fields as necessary.
- Enter a Sequence order for the columns to appear for the output.
- Add Column Headers as needed.
Add Sequence and Column Headers as needed.By default, Ad Hoc filters are saved to User Accounts. Once the Ad Hoc is created, save a copy to User Groups that may need access to the filter.
Additional Filter Options
Copy the above ad hoc filter and adjust the filter options to review other information.
Example 1: Filter for Students with Tribal Enrollment field values but no Title VI program.
Adjust the filter to student.tribalEnrollment IS NOT NULL and title6startDate IS NULL.
Example 2: Filter for Active Students with a Title VI program.
Adjust the filter to student.activeToday = TRUE and title6.startDate IS NOT NULL.
Use the Tango below for step by step instructions on creating the Title VI ad hoc.
