Dropout Prevention Program

• Fixed edit 52.

ELL

• Updated list of valid ELL tests based on Appendix L.
• Removed subject code '19' from qualifying as a Speaking subject for test code 'GEN'.
• Removed non-alphanumeric characters from being output for the various Test Level fields.

End of Year

• Reinstated Certificate of Completion, Type column that was previously removed in the DB Manual Updates for Sept 19, 2025.

Student Assessment

• Modified test history queries to filter out orphaned score records attached to differing student_ids on the same administration_id.

Student Course

• No longer pulls student course records for credit by exam in survey 4 if said student has a survey 2/3 o-file record for the same course in the given school year.

Teacher Course

• Now upper-cases FISH number to avoid batch change records due to case differences in o-file vs what is generated.

CTE Student Course Verification Report

• Updated edit 63.

CTE Teacher Course Verification Report

• Updated edit 61.

Demographic Verification Report

• Fixed edit 46 for ZZ country of birth.
• Updated edit 17.
• Some tweaks to edits 17, 31, & 44 to better handle missing values and default codes.

End of Year Verification Report

• Reinstated edit rules 10 and 33 that were previously removed in the DB manual update for Sept 19, 2025.
• Updated logic for edit 25.

Exceptional Student Verification Report

• Removed hurricane logic from edits 2B, 2C, 2F.

Fed/State Indicator Verification Report

• Fixed edit 68.
• Resolved database error encountered when generating the report for Survey 5.

Industry Certification Verification Report

• Updated edit 41 to better mimic CTE Student Course logic for more accurate error reporting.

SESIR Verification Report

• Updated edit 60 to catch more errors.

Student Assessment Verification Report

• Updated logic for Edit 32 to prevent false errors for IBP tests with a subject code of PT.

Student Course Verification Report

• Updated edits 45, 5P, 5Q, 5Y, & 80.
• Fixed some false positive errors dealing with NFC courses and FEFP 999.

Teacher Course Verification Report

• Added local edit F7.
• Updated edits 12, 26, & 63.

Staff Additional Comp

• Now pulls the charter log fields based on school year.

Staff Benefits

• Updated so that pulling the charter_benefits log field is based on the school year the extract is ran under.

Staff Demographic

• Personnel Evaluation information pulled from the Personnel Evaluation log field now updated to use the school year (SYEAR) column over the old text field.
• Now outputs a value of 'Y' for 'Exempt from Public Records Law, Employee' if a district had imported values of '1' for the checkbox field.
• If the values for the various personnel evaluation charter user fields populated as 0, then fall back to the pers_eval log field if it exists.
• Fixed output for Employment Date, Current Position column.
• Now checks Personnel Logging Field first before user fields when pulling charter/contracted module users.
• Fixed a database error that was occurring in survey 5 for systems that use both payroll and charter/contracted module.
• Now outputs 'School Number, Primary/Home' for staff with job code '71001' to match logic in Staff Payroll that does the same (for edit 18).
• Fixed an issue where the 'Employment Date, Continuous Employment' did not output as expected.

Staff Experience

• Updated so that pulling the charter_exper log field is based on the school year the extract is ran under.

Staff FY Salaries

• Fixed an issue where not all records would pull correctly for salary information despite duty days being correct.
• Fixed an issue where charter FY salary records from prior years were pulling.

Staff Payroll Info

• Resolved rare issue that caused the ZIP code field to output all zeros.

Staff Benefits Verification Report

• Edits updated to pull the charter log records based on school year.

Staff Demographic Verification Report

• Fixed an issue where edit 7 & 1N were outputting incorrect errors.
• Personnel Evaluation log records are now pulled based on the newer school year drop-down over the old school/fiscal year text field.
• Updated edit 6.

Staff Experience Verification Report

• Edits updated to pull the charter experience log records based on school year.

Staff Payroll Verification Reports

• Added logic to hide All Schools option from the Schools drop-down when the user does not have access to all schools.

CTE Student Course

• Fixed an issue where there could be duplicate records if students were missing FLEID information.

Demographic

• Updated logic to default the Adult High School Diploma option to Z for students that were previously enrolled in Adult High School and an existing diploma option is present that is other than Z.

End Of Term

• Fixed an issue where Diploma Type did not output correctly.

Supplemental Information

• Updated extract logic for Postsecondary School of Enrollment when pulling Industry Certification data.

Test

• Adjusted extract logic so ACT WorkKeys tests output a level value of NA.

AGE Student Course Verification Report

• Updated Edit 18 dates to match the current dates listed on the DOE website; this only affects the edit description, as the actual edit was using the correct dates.

CTE Student Course Verification Report

• Updated edits 43 & 46.

Test Verification Report

• Updated Edit 08 to include ACT.
• Refined Edit 21 validation to identify invalid characters.

WDIS Automated Processes

• Adjusted minimum test date logic to match the date defined in Edit 24 for the Adult Test and Performance record.
• Implemented support for processing ACT WorkKeys test data.
• Resolved issue where students were included in job output despite no data changes occurring during the run.
• Updated post-job cleanup logic to null the Subject Area when neither Pre nor Post Test IDs are present.
• Refined logic used to determine a student's previous year Functioning Level.
• Fixed issue that blocked recalculation of tests with invalid level values.

WDIS Extract Field Defaults

• Updated extract logic for Postsecondary School of Enrollment under Supplemental Information.

• Fixed an issue where Bright Futures, Talented Twenty, & MSIX were unavailable as drop down options for outgoing transcripts.
• Fixed database error on importing responses.
• Fixed an issue with some new functionality causing the process to not finish.
• Corrected import process to properly load TSCRIPT files into the database and removed erroneous error headers from affected printable transcripts.
• Updated MSIX logic to allow all school year records to extract; previously only records that occurred after a student's Qualified Arrival Date were extracted.
• On FASTER search screens, implemented current school priority if all schools is unchecked. This has the effect of letting users at certain schools send transcripts for students currently enrolled primarily at another school.
• Fixed an issue where a test score designated as a non-numeric/alphanumeric score type with decimal values caused outgoing transcript edit errors.

Migration added to ensure Charter Experience, Charter Benefits, and Charter Personnel Evaluations logging fields have a visible school year drop-down column (this varied between districts).

Migration added to convert Personnel Evaluation log field text Fiscal Year field to update and instead use the SYEAR column when pulling data.

Added migration to enable school year drop-down on additional comp charter log field if not already shown.

Introduced a Peer URL computed field on the ESE tab, enabling direct access to a student's Peer record from within Focus.

Bonus FTE Student Detail Report

• Updated logic for CTE Pathway Concentrator Completors to include industry certifications earned within the current year and the three preceding years. Additionally, restricted certifications to those earned in grades 9-12.
• Enhanced report to display 5 years of O-files, highlighting each year in red if not downloaded and in green if downloaded. Hovering over a year now shows the last load date for industry certs. Report is limited to students with 3 or more course completions in a program, with a new option to show students with fewer completions.
• Enhanced report to display the list of course numbers completed by each CTE Program of Concentration.
• Updated report to display the course sequence number before each course number for completed sequences to better assist in verification.
• Added staff ID for teachers in IBP, AP, and AICE reports.

Class Size Report

• Updated scheduling method legend to include code 'D'.

Cohort Reports

• Adjusted report logic and output to align with the most recent DOE format updates.

DOE Data Verification District Usage Report

• Redesigned report interface and merged K12, WDIS, and Staff sections into a unified report. Permissions were automatically migrated. Enhanced Excel export to better reflect displayed data, and added functionality to remember the last selected area, survey, and school type.

DMV Attendance

• Added address2 column to address for unit numbers, etc.
• If an address is marked as mailing, prioritize displaying the mailing address.

Download DOE & Error Reports

• Implemented functionality to download PEER Integration files from TIBCO, providing improved support for diagnosing PEER import issues.
• Updated push to school folder logic to correct an issue where file 63359 did not work correctly.

EOY Processing

• Updated logic for CTE Pathway Concentrator Completors to include industry certifications earned within the current year and the three preceding years. Additionally, restricted certifications to those earned in grades 9-12.
• Updated logic for course sequence calculations. The process will now look back 4 years instead of 3 and no longer requires courses to be scheduled under the program of concentration. Matching has been expanded to use either the local ID or FLEID, rather than only the student's local ID when joining to the o-files.
• Corrected CTE Pathway Completors logic to ensure Dual Enrollment substitutions are included when determining sequence completion.
• Resolved issue in AICE bonus FTE logic that caused students who took courses at a school other than their current enrollment to be flagged as not reported to DOE.
• Updated logic for IBP FTE calculation to exclude scores 8, 9, and 14 from counting as passing.
• Refined CTE Pathway Completor logic so that an industry certification can count toward a different program than listed on the O-file when a matching program exists in the linkage list.

FES/PEP/FTC Payment Verification

• Updated to be able to import PEP & FTC files and export combined PEP & FTC files if the category is set to either PEP or FTC.
• Added record listing to show what was imported into the system.
• Now also excludes primary enrollments at school '3450' from the matching process.
• Modified export file to double-quote values containing a comma like the DOE import file does.
• Updated for speed increase in the matching process.
• Added 'FLEID MISSING' to replace an empty FLEID in the comment if the student did not match on FLEID.
• Added an error handling case for import files with missing or unexpected header information.

FTE Summary Report

• Corrected edge-case condition that could cause an error during report generation in limited scenarios.

Florida Reports Setup

• Updated background import logic for Florida files to significantly reduce load time for large datasets, including the Statewide Course Numbering System file.
• Resolved issue preventing WDIS Appendix G from loading successfully into background table.

FLTESTID Job

• Resolved issue that caused duplicate FLTESTIDs when a user manually entered a value before the automated job assigned one. The process now reassigns new FLTESTIDs as needed and synchronizes updates to the student's test history and schedule.

Teachers In/Out Field Logic

• If a teacher can be in field using the 6799 requirement, it can only be applied at a Classical School as designated by the MSID file.
• Added the certification level '6' (in addition to the existing 'E') to the reading certification check with the Tier 3 reading district option set.
• For dual certification CCD codes, the process now checks co-teachers on the section for primary teachers missing one subject code of the dual requirement and vice-versa.

Menu

• Updated schedule minutes total to exclude minutes from schedules marked as Exclude from FTE.

Peer Export Integration

• Modified logic so schools with a school number of ZZZZ are included when identified as Peer Only Schools.

Peer Nightly Import

• Implemented support for importing the student info file.
• Resolved an issue in which backslashes embedded in CSV rows caused line merging and prevented updates to the impacted tables.

Pre-ID Extracts

• Updated Spring FAA extract per 2025 PreID spec doc.
• Removed Biology courses being flagged as courses that count when determining if a student should take the Math test or not depending on the EOC courses.
• Updated ACCESS for ELLs so accommodations outputs again no matter the mode.
• Converting test indicator 'R' to output 'P' for PM Pre-ID.

Process Assessments

• Students who took the CLT prior to 08/19/2025 no longer can use scores from after that date as part of the lower score sum required to meet concordant score.
• Added School and Gradelevel drop-downs to Course Assessment Status, EOC30, AND FSA/FST ELA screens for smaller update runs if desired.
• Tweaked how Algebra 1 alternate assessments factor geometry alternate assessment comparative scores so they are not limited by the same test short name.
• Added course 2100485 to the Set Courses drop down for EOC US History (EAH) on Scale Score Setup screen.

School Grade Accuracy Reports

• Updated logic to exclude industry certifications categorized as Digital Tool Certificate (cert types 1 and 2) for reports School Grade Acceleration One or More NOT Met and School Grade Acceleration One or more Met.
• School Grade Acceleration One or more Met - Updated logic to use individual student cohort year for pulling industry certs.
• Resolved issue that excluded middle school students with industry certifications from the report output.
• Refined Acceleration Met/Not Met report calculations to include only industry certifications earned while the student is enrolled at their current school.

Survey Accuracy Reports

• CTE Schedules With Invalid CTE Courses - Fixed All Schools checkbox logic, and updated logic to exclude orphaned schedule records from the results.
• 255 254 FTE - Updated logic to include students enrolled in HBB courses 7755020, 7855020, and 7900030.
• Elem students with less than 450 mins ELA - Updated logic to pull students with non-consecutive minutes in different settings per DOE requirement.
• Enhanced the "Students Scheduled into a Therapy Course without Exceptionality" report to show the specific course missing an exceptionality, along with the list of valid exceptionalities for the corresponding course.
• Elem students with less than 450 mins ELA - Updated logic for room change requirement.