Focus School Software implemented a Florida State Reporting update, effective February 4, 2025.
If the survey is not specified, the change applies to all surveys.
K12 Extract Defaults
- Added "Diploma Florida Seal of Fine Arts Designation" (students.custom_200000297) data element; fixed typo in description for custom_100000001 in ESE, EOY, and ELL.
- Added Career and Professional Academy Participant data element and logic to Fed State Indicator.
- Updated fields and extract logic for Student Course, Fed State Comp, and Student Demographic.
CTE Teacher Course
- Updated extract logic for Section (course period short name) to use correct pattern from FLDOE documentation.
Demographic Extract
- Defaulting Native Language & Primary Language Spoken in Home to ZZ for students enrolled in 9992, 9993, or 9995.
- Defaulting country of birth for students enrolled in 9992, 9993, 9995, or 9997.
ELL Extract
- Fixed issue with edit 94 where it could display false errors if orphaned schedule records with FEFP 130 exist.
Exceptional Student
- Added support for ESE Effective date. Please note this effective date only applies to Survey 2 for the 24-25 year.
Prior School
- Modified how enrollment records pull for survey 2 to compare against the effective date (Date Certain) instead of the end of the survey window; date certain should always be the last date for a given survey.
Student Course
- Performance enhancements for SQL Server districts.
Transcript Extract
- Modified logic to pull students who were previously enrolled in the district during the current year, but are currently participating in home school, and aren't currently dual enrolled within the district.
- Now converting grad subjects FL, EX, & CE to EL; these codes are still valid for FASTER.
Additional Funding Verification Report
- Fixed issues with edits 63 & 64 where records were returning errors despite the student having dual enrollment student course records.
Assessment Verification Report
- Updated Edit 34.
- Updated logic for Edit 09.
Demographic Verification Report
- Updated rule description for Edit 5C per November database manual update.
- Updated Edit 46 per December 2024 database manual update.
- Fixed an issue with edit 46 flagging US as invalid.
- No longer flagging schools being defaulted to ZZ for Country of Birth as an error for edit 46.
ELL Verification Report
- Updated Edits 33, 42, & 51 per 10/04 database manual update.
End of Year Verification Report
- Updated Edits 9, 16, & 32 per 10/04 database manual update.
- Fixed database error in Edit 16.
- Updated logic for Edits 16 and 32 per November database manual update.
Exceptional Student Verification Report
- Added hurricane exception logic to Edits 2B and 2C (ONLY for Survey 2 in 2024) per November database manual update.
- Updated Edits 2B, 2C, & 2F per December 2024 database manual update.
Prior School Verification Report
- Modified edits 8, 13, & 18 to compare against the effective date rather than the survey window end date for 'end of survey period' checks.
- Updated description and logic for Edit 17 to match DOE rule.
- Updated Edit 35 per 10/04 database manual update.
SESIR Verification Report
- Added new local edit F2 to pull FIT SESIRs that do not have at least 2 linked referrals.
Student Course Verification Report
- Updated edit 53 by adding 1700510 to rule logic to match the description.
- Updated logic and description for Edit 52 to match FLDOE documentation.
- Updated logic and description for Edit 80.
Teacher Course Verification Report
- Updated edit 2A to include missing room numbers. Updated records that compare against room/FISH numbers to account for null values.
- Updated logic for Edit 12 per November database manual update.
- Updated Edit 2B to exclude pulling records when Certification/Licensure/Qualification Status is blank.
- Updated Edit 23. Added Edit 2G per December 2024 database manual update.
Transcript Verification Report
- Updated logic for Edit 05.
Transportation Verification Report
- Updated Edits 12 & 19 per 10/04 database manual update.
WDIS Extract Field Defaults
- Updated AGE Student Course, AGE Test Record, and CTE Student Course Schedule.
- Updated Student Demographic Information, Student End of Term Status, Supplemental Information, and Teacher Course.
WDIS Automated Processes
- Streamlined how tests/subjects are defined and processed. Also added ability to exclude specific tests.
- Added support for excluding specific tests & subjects from being processed; this ability will be available in a future SIS update. Also made some minor improvements to navigating the job results for larger districts.
- Fixed issue where pre & post test assignments were in violation of the new AGE 9K & 9L edits. Please note that currently this will only prevent new errors. An upcoming update will address records that are currently in error.
- Now allowing process to remove a post test from a schedule when a valid post test wasn't identified based on current logic; this will correct 9K and 9L errors on AGE.
- Fixed issue that was causing all Adult Test Names to be set with CAS on student's schedules, regardless of the test taken.
- Fixed issue with previous update that could cause some post tests to not be identified.
- Fixed issue where some tests weren't being processed due to a districts test setup.
- Fixed issue where Initial Functioning Level could be set incorrectly.
- Fixed issue where the Final Functioning Level wasn't being removed when a Post Test was removed from a schedule. Also updated the log output to highlight a Function Level or Post Test ID in red upon its removal.
- Fixed issue where OOR scores were being prioritized over other tests with a higher AEFL.
- Fixed issue where process was assigning Initial and Final functioning levels for program 9900099.
- Fixed an issue that could occur in rare cases where a test with an admin date that is greater than the schedule start date could be selected as a pretest when there are other valid tests with admin dates before the schedule start date.
- Added support for new TAB test forms (13OL,13PB,14OL,14PB). Please note this update does not add these new forms to test setup; that will need to be done by the district if needed.
WDIS AGE Extract
- Fixed an issue where Pre & Post test IDs wouldn't output as expected for select students who had duplicate course & sections.
WDIS Supplemental
- Fixed an issue where program completers were pulling in Supplemental when they should not have been.
- Fixed issue where a student could incorrectly be flagged as program completer.
WDIS AGE Verification Report
- Updated Edit 9J, and added Edits 9K and 9L.
- Fixed issue causing false 9E edits.
WDIS CTE Verification Report
- Updated Edits 34, 41, 47, and 55.
Staff Demographic
- Fixed an issue where Days Present/Leave was outputting as '999' for staff with employment status other than 'RF', 'TF', and 'CF'.
- Calculating attendance per job code as well in case user swaps during year and latest/primary does not have attendance.
- If the value for the element 'Employment Date, Continuous Employment' is missing or blank, fall back to the value for 'Employment Date, Original Position'.
- Updated logic to pull mid-year evaluation info for survey 3.
Staff Experience
- Only creating default experience records for staff with Employee Types RF, TF, & CF instead of all users.
Staff Demographic Verification Report
- Updated Edit 57 per 10/04 database manual update.
- Added Edit 23.
Staff Fiscal Year Salary Verification Report
- Added Edits 07, 15, 16, 35, 36, 37, 38.
Staff Payroll Verification Reports
- Updated Edit 44 per 10/04 database manual update.
- Updated logic for Edit 44 per November database manual update.
- Added new option titled 'Do not Rearrange Postsecondary Lab/Combined Course Numbers' which tells the program to not convert Lab/Combined course numbers when transmitting to FASTER. (EX:Reporting 'PHYL050' for 'PHY1050L')
- Fixed an issue where a white screen would show on the User Report after selecting a user.
- Added New Search interfaces.
- Implemented 2024-2025 cutover changes:
- Updated Post Secondary tests for IBP, CLT, & FCLE.
- Added Fine Arts Seal Designation.
- Added Career and Professional Academy Participant.
- Fixed an issue where a database error could occur if saving tests.
Added codes Q, R, & S for Career and Technical Education Basic Skills Examination.
Added code E for Dual Enrollment Student Type.
Added new student enrollment drop code WOC (K12 Appendix A). Updated max_syear for drop code W28.
Added code C to Certification/Licensure/Qualification Status.
Updated Basic Skills Examination descriptions for codes Q, R, and S.
Bonus FTE Student Detail Report
- Added logic to respect schedule Exclude from FTE checkbox; note this will only affect FTE if the process is run with the Enable FTE Schedule Validation option.
- Fixed an issue that in rare cases would prevent a student from appearing on the report.
- Fixed issue that could cause credits to be higher than expected in rare cases.
DOE Data Verification Reports
- Fixed field title to display correctly in DVR; added missing logic to correctly display field value in DVR; added missing logic for "Verification Reports - Output errors for fields with missing data and an incorrect default code set" district option to work correctly.
Download DOE & Error Reports
- Added report and data file for F71541.
- Added FISH.INITIAL file available under 'F70393 FISH File'.
- Added SPEEDE Colleges & Faster Colleges & Universities files.
EOY Test Crosswalk Setup
- Added logic to prevent crosswalk modification when a user doesn't have edit permission.
EOY Processing
- Fixed issue where some students were being incorrectly flagged as not having a DOE reported course for AICE, which was preventing FTE from being calculated.
- Fixed issue where AICE FTE could be halved when splitting up a FY course into Semesters.
- Fixed an issue in AICE calculations where multiple schedules for a given course were not factored when determining FTE.
- Added a method to correct scheduling marking period anomalies when determining AICE schedules for the same course.
- Fixed an issue where orphan AICE schedule records were being counted.
- Added logic to respect schedule Exclude from FTE checkbox; note this will only affect FTE if the process is run with the Enable FTE Schedule Validation option.
- Adjusted IBP passing score to be 4,5,6, or 7; previously it was considering any score greater than or equal to 4 to be passing.
- Updated log output from Bonus FTE IBP Calculation to Bonus FTE DE Calculation.
- Fixed issue that could cause credits to be higher than expected in rare cases.
Florida Reports Setup
- Added new district option to enable ESE Effective Date on the extract screen; this will allow you to specify a separate effective date to allow students who had to have their IEP rescheduled due to Hurricane Helene/Milton. This date should be no greater than two weeks after schools reopened.
- Fixed issue preventing WDIS Appendix P from loading into background table.
- Fixed issue causing WDIS Appendix O failing to load.
Print FTE Detail
- Added new search.
- Fixed an issue where a white screen would occur for some newer SIS versions.
- Fixed issue where the Effective Date and the Survey Start and End Dates were being set to the current date each time the report was ran.
FTE Summary Reports (Breakdown)
- Fixed issue with FTE Earned by Student and School report where it would include minutes that were marked as 999.
- Now defaulting FTE threshold to .5 if set to zero; previously it would only default to .5 if no value was set.
- FTE Earned By Student and School - Fixed query that caused Push PDF to School Folder(s) to fail.
Generate DOE Extracts
- Fixed an issue where the survey dates where defaulting to incorrect dates upon loading the page.
- Fixed an issue where records would not be reflected in database after extract generation.
Generate WDIS Extracts
- Fixed issue where WDIS Test Date Range would show in the interface when district option wasn't enabled.
Teachers In/Out Field Logic
- Modified process to account for tab delimited CCD requirements on course catalog.
Menu
- Updated description for Virtual Instruction Provider 309 from Edgenuity to Imagine Learning.
Pre-ID Extracts
- Updated FAA Spring for 2024-2025.
- Updated the 'ACCESS for ELLs 2.0' Pre-ID Extract for 2024-2025.
- Fixed FAA Spring Pre-ID Header title with weird dash character.
- Re-enabling logic for 'Mode of Administration', 'Paper Tier', & 'WIDA Alternate ACCESS Tester' fields on ACCESS for ELLs Pre-ID Extract.
- Removed block comment from ACCESS for ELLs extract.
- ACCESS for ELLs - Fixed logic for Mode of Administration and Paper Tier columns to exclude grade level KG.
- 2024-2025 Spring Science, Writing, EOC and Retake - Fixed logic for Spring B.E.S.T. Writing Test Indicator. Added missing column in SELECT for Spring FAST ELA Reading Retake Test Indicator.
- 2024-2025 Spring Science, Writing, EOC, and Retake - Updated logic to exclude students that did not pass FCLE for pulling again for the FCLE.
Process Assessments
- Fixed issue where the scheduled job would update the met date each time the job was run even though the pass date was already populated.
- Fixed issue when running EOC 30% process for BST ALG or GEO. Equivalent tests weren't being considered when inserting exam records.
- Added support for test history score type 'AL_ALPHA' to be used with FAA, FA1, and FA2 tests.
School List Setup
- Fixed issue where MSID lines with NON ASCII characters were causing those lines to not be inserted/updated.
Survey Accuracy Reports
- Fixed issue with ELA 450 mins report where an inclusion section with a different non ELA course number than the parent section was being counted as ELA.
View Background Tables
- Fixed issue that was preventing Appendix Q from displaying.