PK-12 Extracts

• Now only pulling students enrolled in school 3450 if there exists second school enrollment or schedule records.
• Added school 3950 to extract and verification logic where there are existing occurences of school 3450.

Assessment

• Refreshed IBP level crosswalk using the latest mappings from Appendix L.

Discipline

• Updated logic to utilize new district option to exclude minor infractions and/or unprocessed referrals.
• Refactored query logic to increase efficiency and improve runtime performance for both extracts and associated verification reports.

ELL

• Reworked extract for speed increases.

ESE Extract

• Optimized extract logic to improve performance and reduce processing time during verification report generation.

End of Year

• Removed Certificate of Completion, Type column from layout.

Fed/State Comp Extract

• Adjusted sort order for Support Services codes to prevent false change records from being created when batching.

Fed/State Indicator Extract

• Updated extract logic for Immigrant Student (custom_775) to output N when value is NULL.
• Updated Edit 68 to display Withdrawal Code.
• Optimized extract logic to improve performance and reduce processing time during verification report generation.

Industry Certification Extract

• Resolved issue that caused invalid or unintended data to populate a filler field.
• Fixed an issue where the enrollment record used for outputting information did not match the logic in the Demographic extract (Homeschool NG students pulling).

Student Course

• Corrected conditional logic to prevent excluded schools from influencing attendance calculations in rare scenarios.
• Updated virtual FTE calculation logic to prioritize grade term records that directly match schedule terms, rather than relying on derived or partial term data.
• Refactored query logic to increase efficiency and improve runtime performance for both extracts and associated verification reports.
• Optimized extract logic to improve performance and reduce processing time during verification report generation.

Student Transcript

• Speed improvements for extract and verification report.

Transportation

• Modified the dates used to pull marking period data to use survey week rather than the survey window to match enrollment/schedule pulling the same way.

Additional Funding Verification Report

• Resolved logic error in Edit 23 that caused valid entries to be mistakenly flagged as invalid.
• Revised edit descriptions to display the maximum allowable FTE for each test.

Assessment Verification Report

• Updated edit 32.

Demographic Verification Report

• Updated description for edits 5A and 5B.

Dropout Prevention Verification Report

• Added conditional logic to suppress Edit 52 in verification reports when the selected reporting year is prior to its implementation.

ELL Verification Report

• Added Test Name and Test Date columns to edits 2J and 2K.

End of Year Verification Report

• Removed edits 10, 19, & 35.
• Updated edits 3K, 3L, & 16.
• Added edit 18, 3S, & 34.

Fed/State Indicator Verification Report

• Updated logic for Edit 63 to use latest overall enrollment record (Survey 5 ONLY).

Student Course Verification Report

• Updated Edit 2.

Student Transcript Verification Report

• Corrected logic for Edit 09 to prevent empty string values in the Semester Content field from triggering false edits in the verification report.
• Updated Edit 18 & 29.

Teacher Course Verification Report

• Corrected logic in Edit 38 that resulted in all records being flagged.
• Updated Edit 19 for Database Manual Updates - July 25, 2025.
• Updated verbiage on Edit 33.

Transportation Verification Report

• Added new local edit F1.

WDIS Extracts

• Fixed issue that was preventing the AGE D file from being loaded.

WDIS AGE Extract

• Adjusted filler length to allow records to pass edits.
• Fixed issue preventing post-tests from being extracted in Survey F.
• Adjusted extract mapping to ensure pre- and post- test IDs are output in compliance with Edit 9J.
• Refined meeting pattern logic so that days beyond the defined schedule meeting days may be included when calculating total scheduled hours for a survey.
• Updated logic so that Adult High School Credits at Entry outputs 999 when a student has no current-year schedules under program code 9900010.

WDIS Automated Processes

• Added support for CG2 Reading and made additional adjustments based on Appendix R.
• Modified logic to retain Adult Education Function Levels and Test IDs on schedules outside the selected survey. The process will continue to update only the schedules associated with the survey selected on the job.
• Resolved issue where the job would fail if a student's test score did not produce a valid level, which occurred in rare scenarios.
• Resolved compatibility issue causing job failure in MSSQL districts.
• Corrected assignment logic to ensure all applicable TABE tests are assigned.
• Resolved issue where certain records received a pre- or post-test assignment but no corresponding level on the schedule.
• Updated logic to avoid Edit 9J violations by withholding language pre-test assignment for program 9900000 and course 9900023 until a valid reading pre-test is present on the schedule.

WDIS CTE Extract

• Resolved issue causing the GATE Program Enrollment flag to default to N instead of reflecting the correct student field value.
• Refined meeting pattern logic so that days beyond the defined schedule meeting days may be included when calculating total scheduled hours for a survey.

WDIS AGE Verification Report

• Updated Appendix Q syear logic for edits 10, 11, and 12.
• Corrected validation logic so that Edit 9J properly displays all records failing the rule.

WDIS CTE Verification Report

• Removed Edit 75, as per DOE the CTE Program Code P430102 will be allowed across all surveys.

WDIS Demographic Verification Report

• Fixed output for Adult High School Credits at Entry for Edit 83.

WDIS Test Verification Report

• Updated Edits 10, 11, and 24.

Staff Demographic

• Moved how the Measure Student Performance Charter field actually outputs.
• Fixed database error in 2526.
• Fixed logic for 'Personnel Evaluation, Measures of Student Performance' when checking against 'Personnel Evaluation, Student Performance Component' zero.
• No longer pulling duplicate records if charter user has multiple charter attendance log records.
• Implemented a priority system to determine which attendance record is output for a given school year if there happens to be multiple.
• Setting the various 'Days *****' fields to 0s for users who do not meet the employment type and EEO line criteria in edits 2C & 2D in survey 5.
• Checking against GL_HR_EDUCATION_DEGREES table in case district has select option query for Highest Degree Earned.

Staff FY Salaries

• Tweaked how Charter Duty Days are calculated and to also fall back to Charter Payroll Info or 260 days.
• Fixed an issue where the charter staff attendance log field was not school year specific.
• A Duty Days column was added to charter log field so extract will check that first for data.
• Updated to check against newly added 'Employee Type' & 'Job Code FTE' columns on charter FY Salaries log records.

Staff Payroll Info

• A survey column was added to charter payroll info so that will be checked against when determining to output records in surveys 2 & 3.

• Added logic to parse and load tscript file into database; trunk only for now for further testing.
• Updated manual links for 2025-2026.
• Implemented tab-level access control within FASTER via profile permissions.
• Right-justifying test score when the score type is OS.
• Updated Aging Report screen to use DataTable to resolve issue with filtering records across all schools.
• Resolved display issue where alert icons were not rendering correctly under certain conditions.
• Fixed an issue where certain fields could be unintentionally imported as NULL values from an incoming response.

Set a Max School Year of 2024 for W09 certification of completion option.

Resolved issue that blocked users from entering decimal values for "FTE Earned, CTE Pathway Concentrator Completion".

Added a new user field 'Exclude from State Reporting'.

Added 'Employee Type' & 'Job Code FTE' columns to charter FY Salaries log records.

Added a new program titled 'FES Payment Verification' that provides a way to accomplish Family Empowerment Scholarship data collection requirements.

Bonus FTE Student Detail

• Resolved database error affecting the IBP/APT report.
• Corrected enrollment prioritization logic so AP and IB reports no longer select summer enrollment over regular-year enrollment.

EOY Processing

• Capped bonus FTE calculations at the maximum values defined for each test in the Additional Funding edits. Enhanced interface for improved usability.
• Resolved MSSQL-specific issue preventing completion of AICE Bonus FTE calculations.
• Adjusted IBP passing score criteria to >= 4, replacing the former requirement of scores between 4 and 7.

Florida Reports Setup

• District option for ELA and ESE Waiver reworded per logic change.
• Resolved issue that caused a non-numeric value to be defaulted into the "PEER Export - Max Days Ahead of Effective Date (Max 14)" field in District Options.
• Implemented minimum and maximum constraints to prevent invalid values.
• Added a 'Survey Week Start' column to the Alternate Membership interface so districts have the option to pick a different date than the Monday of the week of the Effective Date.
• Updated background tables to resolve issue that blocked multiple K12 appendices from loading properly.
• Added new district option 'WDIS - Ignore Schedule Funding End Date when Totaling Scheduled Hours'; option tells the schedule interface to not check funding end date when totaling scheduled hours column.
• District Options - Added new district option for 'Discipline Referrals to exclude Minor Infractions and/or Unprocessed Referrals'.
• Resolved issue that blocked K12 Appendix O from loading properly into background tables.
• Resolved loading issue affecting the K12 L and K12 DD appendices for background tables.
• Added a new district option titled 'Process Assessments - Require Exam Attempt Prior to using Concordant Score' to be used by process assessments when determining whether to use a concordant score or not.

FTE Summary Reports (Breakdown)

• Fixed an issue where records would not display for a school where a student was not enrolled in (section school of instruction matched)

Teachers In/Out of Field

• Fixed an issue where in-field status did not match out of field reasons.
• Updated exact match course number to Course Catalog district listing.
• Limiting Course Catalog joins to active entries only.
• Added a dual certification requirement entry for '584' that is met via '964' & 'E1062'.

K12 Extract Field Defaults

• Fed State Indicator - Updated extract logic for KG-8 PE Waiver and Immigrant Student.
• Student Additional Funding - Added extract logic for FTE Earned, CTE Pathway Concentrator Completion.

Menu

• Fixed descriptions and missing options for Online Course and Virtual Instruction Provider fields.
• Adjusted Total Clock Hour calculation to reflect updated SIS logic.
• Updated description of option D for WDIS First-Time Student Indicator.
• Modified schedule interface to check new district option 'WDIS - Ignore Schedule Funding End Date when Totaling Scheduled Hours'.
• Resolved issue preventing the Process Assessments option from displaying for districts configured as WDIS only.
• Modified schedule interface functions that handle WDIS hours to round to 2 decimal places.

Peer Export Integration

• Resolved issue that was blocking generation of the Staff Demographic export.

Pre-ID Extracts

• Added new Zoom Text column, and updated file layout for the following:
  • Fall EOC and ELA Retake
  • Progress Monitoring Assessments
  • Spring Science, Writing, EOC, and Retake
  • Winter EOC, FCLE, and FST ELA Retake.
• Added the ability to pick schools for Progress Monitoring Assessments.
• Fixed an issue in Spring and Progress Monitoring Assessments where the schools selected were ignored.
• Sped up the process that inserts Pre-ID records generated into the background table.
• Added 2025-2026 Fall FAA report.
• Updated course enrollment values to output course number rather than Y flag for the 2025-2026 Fall FAA Pre-ID Extract.
• Updated logic for the EOC Course Enrollment and Exceptionality, Other columns for the 2025-2026 Fall FAA Pre-ID Extract.
• Updated extract layout by removing Season column for the 2025-2026 PSAT/SAT Pre-ID Extract.
• Fixed issue where SAT extract did not properly store pre-id records into table.

Process Assessments

• No longer updating the Communications, Date Passed & Mathematics, Date Passed elements for ESE Waiver students per DOE.
• Added support for the EOC30 process to process multiple tests & parts with the same short name and subject code respectively (Multiple instances/duplicates of a given test and part combination).
• Fixed an error that was occurring during course assessment status update.
• SAT Reading and Writing updated for cohorts 2023-2024+ to 490 for ELA concordant (except 2023-2024 & 2024-2025 cohorts taken the test prior to 08/19/2025).
• Added PSAT/NMSQT Reading and Writing section for cohorts 2022-2023+ of 470 for ELA concordant.
• Added PSAT 10 English and Writing section for cohorts 2022-2023+ of 470 for ELA concordant.
• Updated CLT for cohorts 2023-2024+ to require sum score of 39 (except 2023-2024 & 2024-2025 cohorts taken the test prior to 08/19/2025) for ELA concordant.
• Added CLT10 Grammar/Writing and Verbal Reasoning subject test score for ELA concordant score for cohorts 2022-2023+.
• Added Algebra 1 EOC Comparative score for PSAT 10 Math for cohorts 2022-2023+.
• Updated CLT for cohorts 2023-2024+ to require score of 14 (except 2023-2024 & 2024-2025 cohorts taken the test prior to 08/19/2025) for Algebra 1 EOC Comparative score.
• Added Algebra 1 EOC Comparative score for CLT10 Quantitative Reasoning for cohorts 2022-2023+.
• Cohorts prior to 2022-2023 can use PSAT 10 & PSAT/NMSQT for ELA.
• CLT prior to 2020-2021 and CL1 prior to 2022-2023 can be used for ELA.
• PSAT 10 Math can be used as Algebra 1 comparative for cohorts prior to 2022-2023.
• CLT prior to 2020-2021 and CL1 prior to 2022-2023 can be used as Algebra 1 comparative score.
• Added ZZZ & ZA1 for test and part respectively for out-of-state Algebra 1 concordant score when determining student Algebra 1 status (EX: Pre-ID Extracts).
• Added PSAT/NMSQT PSA - BR test and subject code for ELA concordant score >=470.
• Updated logic to check the district option 'Process Assessments - Require Exam Attempt Prior to using Concordant Score' when determining ELA & Algebra 1 concordant & comparative scores.
• Added Pre-ACT Secure (PAC) logic for determining ELA concordant score and Algebra 1 comparative score.

School List Setup

• Modified the process that pulls/populates schools from DOE files to exclude SPEEDE institutions that do not accept electronic requests.

Survey Accuracy Reports

• Implemented new report to detect invalid Schools of Instruction in section records (not in schools table), excluding school codes prefixed with C, U, or P.

WDIS Extract Field Defaults

• Student Demographic Information - Added Gate Program Date of Enrollment (custom_200000300).
• AGE Student Course, CTE Student Course - Added Gate Enrollment Flag (custom_200000303).

WDIS Total Hours Scheduled Job

• Updated to check new district option 'WDIS - Ignore Schedule Funding End Date when Totaling Scheduled Hours' when populating table columns.
• Modified so that hours are rounded to two decimal places when updating schedule records.