SAIS and JTED FTE Validation Tool
This function will list all school enrollment records within the current term for your current selection of students.
All Course Counts and calculated FTE columns are calculated based on a snapshot date. The snapshot date used for each enrollment is the first day of that enrollment.
Use the Course Count Date Override parameter to calculate course enrollments as of a different snapshot date. All student enrollments not containing the overridden snapshot date will be calculated as of the first day of that enrollment.
This page allows for the update of a student’s SAIS FTE (FteId), JTED Indicator, JTED School CTDS, and JTED Concurrent CTDS values for each listed school enrollment record. It also lists various other calculated and static values for use in determining the correct FTE and JTED Indicator value for each enrollment.
This tool can be used to:
- Update student JTED Indicators to 1 (Yes) in bulk at the beginning of the school year.
- Validate a student’s SAIS FTE after setting the student’s JTED Indicator to Yes.
- Verify a student is enrolled in enough classes not excluded from attendance (at the section level) for their FTE as of a snapshot date.
- Check if students’ JTED Indicator values need to be adjusted after Semester 2 schedule changes.
Selection Criteria
Selection criteria determine which database records are used in the function. Refer to selection criteria for analysis when the function does not return the correct records.
Student Enrollment Selection
The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:
- The student must be in the user’s Current Selection.
- The student’s school entry date must occur on or before the current term end date.
- The student’s school exit date must occur after the current term start date.
- The student’s school exit date cannot equal the entry date (excludes no-shows).
Section Enrollment Selection
The report selects records from the [Sections] and [CC] table based on the following criteria:
- The student’s section entry date must occur on or before the course count snapshot date (or school entry date).
- The student’s section exit date must occur after the term start date (or school entry date).
- The section is not flagged as ‘Excluded From Attendance’.”
Input Parameters
To generate the report, do the following:
- On the Start Page, select a group of students.
- Click Special Functions. The Special Functions page appears.
- Click Interfaces to other systems. The Interfaces to Other Systems page appears.
- Click JTED. The JTED – Arizona’s Joint Technical Education District Ranking and Reporting page appears.
- Click SAIS and JTED FTE Validation Tool. The SAIS FTE and JTED Validation Tool page appears.
- Enter information in the desired search parameter fields (none are required).
- Click Search to generate the results.
Field | Description |
Course Count Date Override | Course counts for each listed enrollment are calculated as of the first date of the enrollment (the default snapshot date). Enter a date in the ‘Course Count Date Override’ field to calculate course enrollments as of a different date for all applicable enrollments. (School enrollments which do not contain the overridden date will still calculate as of the first day of the school enrollment) |
SAIS FTE Course Counts (Enter the minimum number of course enrollments required for each FTE amount. Used to determine SAIS FTE (Calc) column) | Enter the appropriate values: 0.25 – Enter the minimum number of ADM course enrollments to be considered a .25 FTE 0.50 - Enter the minimum number of ADM course enrollments to be considered a .5 FTE. 0.75 - Enter the minimum number of ADM course enrollments to be considered a .75 FTE. 1.0 - Enter the minimum number of ADM course enrollments to be considered a 1.0 FTE. The SAIS FTE (Calc) column will compare the values entered with a student’s course count on the course count snapshot date and display a calculated FTE amount based on the values entered. Only the fields populated will be used in the calculation. For example, if you enter a 2 in the .5 box and enter 4 in the 1.0 box, the SAIS FTE (Calc) column will display:
If all boxes are left blank, all enrollments will display as 0.00. |
Function Output
Each of the fields displayed in the output of the function are described below. See Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName |
Set JTED Button Click the ‘Set JTED’ button to set all students’ JTED Indicator values to Y whose JTED Eligible Courses column is greater than 0. Note: All changes to values listed in the results will be applied upon Submit. | ||
Student Name | The student’s first name. | [Students]LastFirst |
Student Number | The student’s locally assigned student number. | [Students]Student_Number |
Grade Level | The student’s grade level for the enrollment. | [Students]Grade_Level |
Enrollment | Entry Date and Exit Date of the enrollment. | [Students]EntryDate [Students]ExitDate [ReEnrollments]EntryDate [ReEnrollments]ExitDate |
Total ADM Courses | The count of courses on the Course Count Snapshot Date, where the section is not Excluded From Attendance. Course Count Snapshot Date = The first day of the listed enrollment, unless:
Click the number to view the course enrollments included in the count. | Calculated. |
SAIS ADM Courses | The total number of course enrollments on count date where the section is not excluded from attendance and the course enrollment is not counted towards JTED attendance. (Total ADM Courses) – (JTED ADM Courses) = (SAIS ADM Courses) | Calculated. |
JTED ADM Courses | The number of courses counting towards JTED ADM on the snapshot date. Will display 1 if the student is enrolled in a JTED course on snapshot date and has a JTED Indicator value of 1 (Yes) for the current enrollment saved in the database. Note: If a change is made to JTED Indicator, the value is recalculated on Submit. | Calculated. |
SAIS FTE (Calc) | The student’s calculated SAIS FTE based on the number of SAIS ADM Courses on count date as compared with the cutoff values entered in the ‘SAIS FTE Course Counts’ parameter. If the ‘SAIS FTE Course Counts’ parameters are all blank, 0.00 will display. The value displayed is not stored or used in reporting. It is a visual cue to aid in determining the correct FTE for each school enrollment. If the SAIS FTE (Calc) value does not equal SAIS FTE (Current), the SAIS FTE (Calc) box will be colored Orange as an alert. An orange alert is not a recommendation to update a student’s FTE, but a suggestion to check the student’s schedule and FTE, making adjustments if necessary and where appropriate. | Calculated. |
SAIS FTE (Current) | Displays the student’s current Full Time Equivalency (FTEId) for the school enrollment listed. Select a different FTE if desired. Note: Changing a student’s Full Time Equivalency will apply the change to the entire enrollment. To update the value as of a certain date within the enrollment, it will be necessary to make this change using the Change Enrollment student screen. | [Students]FteId [ReEnrollments]FteId |
JTED FTE | Will display 0.25 if the student is enrolled in a JTED course on snapshot date and has a JTED Indicator value of 1 (Yes) for the current enrollment saved in the database. Note: If a change is made to JTED Indicator, the value is recalculated on Submit. | Calculated. |
Eligible JTED Courses | The number of JTED section enrollments on the snapshot date. ([Sections]JTED_Indicator=1) | Calculated. |
JTED Indicator | Displays the student’s current JTED Indicator value for the school enrollment listed. Select a different JTED Indicator value if desired. Note: Changing a student’s JTED Indicator value will apply the change to the entire enrollment. To update the value as of a certain date within the enrollment, it will be necessary to make this change using the Change Enrollment student screen. | [S_AZ_STU_X]JTED_Indicator [S_AZ_REN_X]JTED_Indicator |
JTED School CTDS | The JTED School CTDS for the school enrollment. Data entry field. | [S_AZ_STU_X]JTED_School_CTDS [S_AZ_REN_X]JTED_School_CTDS |
JTED Concurrent CTDS | The JTED Concurrent CTDS for the school enrollment. Data entry field. | [S_AZ_STU_X]JTED_Concurrent_CTDS [S_AZ_REN_X]JTED_Concurrent_CTDS |