USOE Home » Warehouse » SERF


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 and other accountability reports as well as other varied purposes.

SERF is generated at the end of each year and on request for each LEA 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, CAS, 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 installed.




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


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.


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


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.                         


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