Assessment Extract

• Adjusted logic to allow dual enrolled home school students to pull.

Additional Funding Extract

• Adjusted logic to allow dual enrolled home school students to pull.

CTE Student Course Extract

• Excluded records from school 3518 from pulling.
• Apprenticeship Sponsor code added. (**NEW**)

CTE Teacher Course Extract

• Excluded records from school 3518 from pulling.

English Language Learners Extract

• No longer pulls scores with score types not enabled for the given part.
• Added subject code 19 as valid for GEN Speaking.

Student Course Extract

• Now pulls virtual schedules that withdrew during survey week which are not active as of date certain.
• Now pulls ESE FEFP for school 3900 as edit has changed.
• Apprenticeship sponsor code added. (**NEW**)

Transportation Extract

• Fixed an issue where a student enrolled in a non-reportable school prior to date certain was not generating a transportation record.

CTE Student Course Verification Report

• Added edit 46 & 47. (**NEW**)

English Language Learners Verification Report

• Adjusted edit 94 to display students with an entry date in excess of six years.

Exceptional Student Verification Report

• Added edit 3D.

Fed/State Indicator Verification Report

• Fixed an issue where edit F1 wasn't catching all student that had changed schools.

SESIR Verification Report

• Updated edits for new incident codes USA & USB.

Student Course Verification Report

• Updated edit 2N to treat 111-113 as valid FEFPs.
• Updated edit 2N to add valid FEFP 254 & 255.
• Added edits 3B. (**NEW**)

WDIS CTE Student Course

• Apprenticeship Sponsor code can now be output as blank instead of zero-filled.

WDIS CTE Student Course Verification Report

• Updated edits 36, 54, & 56.
• Added edit 90.
• Added edit 60.

WDIS Total Hours Scheduled Job

• Fixed SQL server issue where database errors would occur.

WDIS Verification Reports

• Fixed an issue where the Student Identifier, Local field did not display in the interface.

Staff Additional Job Assignments

• Updated main query to include survey limits on pay types.

Staff Demographic

• Fixed an issue where other school year records for the log field 'Charter Staff Attendance' were pulling, causing duplicate records.
• Fixed an issue where the teacher certification number didn't pull as expected.
• Updated queries to match payroll extract when determining if a job with a termination code should pull or not.
• Modified SQL for better checking if a staff member is teaching in a section (co-teachers/inclusion teachers now pull).
• Updated code to check for extended leave termination code set on the staff job position if the job position ending date occurred before the survey window start date.
• Includes staff with termination date within specified survey window.

Staff Experience

• Fixed an issue where the Experience Type and Years fields were swapped when inserting default experience log records for users.

Staff Multi District Employee

• Fixed database error.

Staff Payroll

• Fixed an issue where if a termination code was provided but with no termination date, then the payroll record would not pull.
• Modified extract to treat SSN numbers that begin with prefix CS as valid.

• Tweaked queries that update incoming requests into outgoing responses to fix the sending/addressed institution values.
• Fixed an issue where searching on log field dates did not work correctly when selecting all students to create transcripts for, resulting in a higher number of transcripts created than anticipated.
• Fixed an issue where MSIX transcripts were not replacing Migrant School Attended value of 'N998' with '9998'.
• Fixed an issue where course records would pull for migrant students without an accompanying year record.
• For MSIX transcripts, FASTER will no longer output school year records prior the latest QAD date.
• Test Part is now checked when determining which test records to pull. The test part has to be marked as 'Y' for transcript in order to pull.
• No longer pulls test parts with a NULL value for the transcript field (Has to be marked Y).

Combined Student FTE Records (Claims)

• Fixed an issue where the format was the incorrect length when transmitting via FTP.

DMV Attendance Report

• Increased the number of displayed records from 1000 to 1500.

Download DOE & Error Reports

• Added F71411 Bonus FTE, Additional Funding Report.
• Fixed an issue where the SESIR Validation Report did not push to school folders.
• Pushing to school folders for school 4444 will be listed under school 3900.
• Fixed issue where some Recalibrated FTE reports failed to be listed for download.
• Added F71535 Industry Certifications Not Funded report.

EOY Processing

• Year Entered Ninth Grade will no longer be set for students primarily enrolled at N998.

EWS Report

• Fixed an issue where Math/ELA Teacher column could display the wrong teacher.
• Added a count and column for Reading Deficiency (Reading Intervention 'B') but is counted under the Level 1 FSA indicator.
• Updated so that reading deficiency pulls for all grade levels.
• Fixed database error that would occur on certain SIS versions.

Florida Reports Setup

• Fixed background tables issue where DOE changed the column names on Appendix FF for 20-21.
• Fixed issue where IEP Plan date & IEP Expiration dates wouldn't import if no value existed in Focus.
• Added new tab titled 'Contracted Module' to be used with sites with Finance enabled; allows a user to define the valid schools for the element 'School Number, Primary/Home' to be checked when downloading O-Files/D-Files for batching.
• Added Florida Access Course List (F71538) to Florida Files for downloading into background table.
• Reverted format change for the FES Payment files.
• Under the Pre-ID tab, a new option titled "Include students taking courses 'International Baccalaureate History of the Americas (2100800)' and 'International Baccalaureate Contemporary History 2 (2109805)' for the FCLE Pre-ID." was added.
• Added reports F71372 & F71373 to be able to load into table: DOE_INDIVIDUAL_PRORATE_STATEWIDE_FTE.
• Updated WDIS Appendix O format for background table to match new format released by DOE.
• Updated background tables by adding K12 Appendix O and updating WDIS Appendix O format.
• Fixed error preventing Appendix FF background table from being loaded.
• Added new filenames for Individual Prorated FTE import.

FTE Summary Reports (Breakdown)

• Fixed issue with Student Funding report where the printed PDF didn't match what was displayed on the report.
• Adjusted FTE Earned by Student & School Report to output data for students that aren't directly enrolled in their school of instruction.

Teachers In/Out of Field Logic

• Added courses '7863070' and '7963040' to the ESE expanded skills logic.

K12 Extract Field Defaults Report

• Updated SESIR format to match current extract logic.

LearnFare Attendance

• Fixed an issue that prevented a student from being opened when viewing all schools.

Menu

• Schedule inclusion field will show red 'X' instead of 'N/A'.

Import Peer Data

• Adjusted process to no longer overwrite Focus database values when the Peer file contains a NULL or zero value.

Pre-ID Extracts

• Fixed an issue for the Winter EOC & FCLE Pre-ID where certain course numbers weren't being flagged as valid.
• Added Florida Civic Literacy Exam to list of options for EOC Assessment Without Taking the Course.
• Modified Fall EOC & Retake to no longer pull withdrawn prior year schedules.
• Modified Winter EOC to pull currently scheduled students if Algebra 1 test attempts is zero regardless of concordant status.
• Modified Winter EOC Pre-ID extract to no longer pull dropped prior year scheduled students.
• Updated ACCESS for ELL test format for 2021-2022.
• Added new checkbox option titled 'File to be used to order materials' for use with the ACCESS for ELLS Pre-ID Extract.
• Updated ACCESS for ELLs Pre-ID Extract to output the columns'Mode of Administration', 'Student Type', 'Paper Tier', and 'Alternate ACCESS for ELLs Tester' dependent on the order materials checkbox.
• Modified Winter EOC extract to factor new Pre-ID extracts option.
• Updated Spring Pre-ID Extract for 2021-2022.
• Modified name of Spring extract to include mention of FCLE.
• Fixed 504 Status and Primary Exceptionality fields defaulting to blank instead of 'N' on the Spring Reading, Writing, EOC, & FCLE Pre-ID Extract.
• Updated the Spring Retakes Pre-ID Extract for 2021-2022.
• Modified Spring WRMSEOC Pre-ID Extract to no longer output a student as taking both Science and Biology 1 exams.

Process Assessments

• Fixed an issue where multiple exam records could be created in certain situations.

School Grade Accuracy Reports

• Fixed a database error occurring on some sites.

School Grade Scheduler Reports

• Updated intensive reading course numbers.

Survey Accuracy Reports

• Updated valid ELA courses for Elem students with less than 450 mins ELA report.
• Now validates courses against appendix DD when Show Students With 1 or More Non 130 Schedule Records is checked to prevent false errors.
• Fixed database error when trying to run Student Course Records Missing from O File Report.
• Fixed issue where inactive students were showing up as earning zero minutes, regardless of their schedule.

Generate Survey R

• Fixed an issue where HSN incidents would be sent every month due to no required date field causing the month value to be different.