USOE Home » Warehouse » SERF

SERF - State Education Research File

SERF, formerly known as the Enhanced Research Disk is a collection of tables that is meant to mirror the data that is stored at Utah State Office of Education (USOE) and is used to generate the AYP (Adequate Yearly Progress) and other accountability reports as well as other varied purposes.

SERF is generated at the end of each school year and on request for each LEA (Local Education Agency) in the state. The data contained in the SERF is specific to a single school year, however; since some prior year data is needed to generate the AYP (Adequate Yearly Progress), 
CAS (Childhood Apraxia of Speech), and other accountability reports, prior years data for the students enrolled in the reporting year at the LEA is also included.

The SERF is provided as a Microsoft Access database file.  In order to use it, you will need to have Microsoft Access 2007 or newer installed on your computer.



Year 2014-2015

Version 3

Release Date: 02/19/2015

Added new Tables:

  •  SAGEAccountabilityLevels
  •  SAGEAssessmentSeries
  •  SAGETestCourses
  •  SAGETestStatuses
  •  SFARSchoolDemographicScores
  •  WIDARaw
  • Renamed existing ACT, DWA, GUS, PACE, SAGE, SFAR (UCAS), and WIDA tables and fields.
    SERF Updated Tables and Fields
  • Primary keys added to tables beginning with ACT, SAGE, SFAR, PACE, WIDA, and DWA
  • SAGEStudentTest missing fields fixed
  • SAGESubScores table data updated
  • SAGEStudent query updated


Year 2013-2014

Version: 2

Release Date: 12/15/2014

  • Added pace_CCR_serf - Contains College Credit and Readiness data used in PACE report.
  • Added pace_demographics_serf - Contains demographics data used in PACE report.
  • Added pace_highschool_serf - Contains ACT and Graduation Rate data used in PACE report.
  • Added pace_rogl - Contains all sge data used in Academic Performance section of the PACE report.
  • Added pace_school_commments - Contains school snapshot comments used in the PACE report.
  • Added pace_schools_serf - Contains school info and flags to show how split schools are broken out.  Also, shows which type of PACE report(s) each school will get.
  • Added Pace_summary - Pace summary table was removed.  Data previously in that table may be found in the new tables listed for this release.


Release Date: 12/04/2014

  • Added pace_summary - Contains some of the data on the PACE excel files.
  • Added school_scores - Contains test counts, year to year growth statistics and test proficiency scores related to SAGE testing.
  • Added school_content_area_scores - Details of how each score was calculated in school_scores
  • Added sub_scores - Contains the SAGE subscores.
  • Added ualpa_wida_xwalk - Maps the UALPA proficiencies to the WIDA proficiencies.
  • Added test_proficiency_levels - Join tables for sub_scores.  Contains score range for each subscore.
  • Added test_reporting_categories - Join tables for sub_scores.  Gives name of subscores per test.
  • Added act_student - Max ACT scores used in PACE CCR calculations.  Per-student data
  • Added act_school - Max ACT scores used in PACE CCR calculation.  Aggregated school data

      The CCR data in the pace_summary is not available


Version: 1

Release Date: 11/07/2014

  • Added resultSummary table that contains the summarized data that is reported at
  • Added SubGroup table that indicates the subgroups used in the resultSummary table.
  • Added SubGroupCategory table which is a list of categories used in the SubGroup table.
  • Added SubjectArea table which has the IDs for the subject areas used in the resultSummary table.
  • Added SageGradeLevel table which lists the grade levels for which SAGE tests were administered and which indicates the grade levels used in the resultSummary table.
  • Added student_test_sage table that contains detailed student SAGE data.
  • Added dwa_Raw table to house the 2014 DWA data.
  • Added student_Test_wida table to house the WIDA data.
  • Removed student_test_concept and student_test_objective tables.
  • Student query is only used for historical CRT data, since the CRT is no longer administered, please use the tables listed above for access to student test scores.

Year 2012-2013

Version: 5

Release Date: 10/04/2013

  • A small handful of assessments for one LEA that were missing in past releases have now been added
  • SGP calculations were re-applied
  • This release may not be significantly different from version 4

Version: 4

Release Date: 8/28/2013

This release only affects the following LEAs

  • The proficiencies for some NWEA tests in these LEAs were incorrect and have now been computed based on the scaled score.
Tests Affected
Test Count
 Algebra I  13
 Biology  15
 Earth Systems  3
 Geometry  32
 Language Arts 3  76
 Language Arts 7  15
 Language Arts 8  26
 Language Arts 9  1
 Language Arts 10  9
 Math 3  1
 Math 5  26
 Math 6  2
 Math 7  16
 Pre Algebra  933
 Science 6  1
 Science 7  1



Version: 3

Release Date: 8/20/2013

  • Some LEAs had some tests that were not included in prior versions of the SERF, this has been corrected
  • SGPs have been re-calculated to account for the missing tests
  • The student query has been fixed to accurately display the LEP code (ELL Status)

Version: 2

Release Date: 8/8/2013

  • ACT Plan data is now complete  (Only a partial set of data was originally loaded)
  • DWA is now included in the UCAS calculation
  • 4 additional queries were added, 3 for Grading Utah Schools and one for UPass Progress

Version: 1

Release Date: 8/5/2013

  • Initial release for LEA Audit of reports


Version: 5

Release Date: 4/9/2013

  • Graduation rate data has been re-calculated
  • An issue was discovered in the ELL AutoExit query after this version was released that has been perpetuated in this release. If you need the proper syntax to fix this issue, please contact us.

Year 2011-2012

Version: 4

Release Date: 02/15/2013

  • Changed the data type of the latitude and longitude columns in the institution table

Version: 3

Release Date: 02/11/2013

  • Added / Updated AMAO queries for AMAO 1, 2, and 3 to assist in auditing the Federal AMAO report

Version: 2

Release Date: 10/17/2012

  • Corrected UALPA data loaded in to the warehouse is now reflected on this release
  • Loaded UAA tests that were missed in the initial warehouse load
  • Added the SGP and below proficient flag to the student test table
  • Added an additional query for below proficient students that replicates the existing students query

Version: 1

Release Date: 8/7/2012

Year 2010-2011

Version: 8

Release Date: 2/27/2011

  • Corrected UALPA data was loaded into the warehouse that is now reflected on this release.

Version: 7

Release Date: 12/1/2011

  • This release is a cohort detail SERF to be used to identify students with an "Unknown" status used to determine Graduation Rate

Version: 6

Release Date: 9/23/2011

  • Updated AYP Attendance and Cohort Detail query
  • Updated UALPA data

Version: 5 (Queries Only) Update Intructions

  • Updated the AYP Participation and AYP Proficiency queries to include the validated proficiency field
  • Click here to download this update (blank database)

Version: 4 (Queries and Forms Only)

  • Updated queries and forms to fix an issue with the AYP Student Group form
  • Click here to download Access Queries and Forms Only (blank database)

Version: 3

Release Date: 8/5/2011

  • Removed the prior two years of data from the student course, student test concept, and student test objective tables
  • Released to coordinate with the 8/5/2011 re-release of the AYP reports
  • Added ethnicity to the student query to pull ethnicity for 2011
  • Improved functionality of the AYP queries
  • Tables with updated data:  school_annual, district_school_ayp, district_school_ayp_results , student_test

Version: 2 Data Dictionary

Release Date: 8/2/2011

  • The first useable release

Version: 1

Release Date: 8/1/2011

  • Original release - This release was not useable and should be deleted.                         

Year 2009-2010

Version: 4

Release Date: October 11, 2010

  • Included NWEA tables.

Version: 3

Release Date: September 16, 2010

All known issues from release 2 have been fixed.

Queries have been updated.

The concepts and objectives for the 2nd Grade Language Arts have been added to the SERF.

The following tables have updated values for the test program id column that match the test program id in the test program table.

  • summary test concept
  • summary test objective
  • summary dist test concept
  • summary dist test objective

Version: Blank SERF with Queries 2010-2

Release Date: August 16, 2010

Original Blank SERF with the following fixes.

  • Fixed LEP Auto Exit query (Was using validated proficiency of 2 instead of '2B' as part of the calculation)
  • The AYP queries have been fixed to match those queries used by USOE to determine proficiency, participation and attendance numbers.
  • New query to help with graduation rate questions is included (This is not fully tested yet, please provide feedback as you encounter problems so we can ensure accuracy)

Version: Blank SERF with Queries 2010-1

Release Date: August 12, 2010

  • Original Blank SERF.

Version: 2

Release Date: July 30, 2010

2010 Year End.

Known issues with this release.

  • The AYP attendance, AYP participation, AYP proficiency and institution list queries have an incorrect year coded in the query.  To fix this you can follow these few steps for each query.

Version: 1

Release Date: January 8, 2010