Skip Navigation


Data Extracts

PEPS produces a weekly data extract of select school data (created on Thursday evenings and posted to this site each Friday). A "change indicator" is provided within each of the thirteen record types so end users can easily identify changes made within a seven-day period.

The files on this page are in Microsoft (MS) Word or PowerPoint. If you don't have this software, Microsoft makes available free software that you can download and use to view these files.

What is provided on the data extract?

The following document contains descriptions for each of the record types/data fields provided on the weekly data extract:

File Layout Document

What do all these codes mean?

The weekly data extract contains many codes used within the PEPS database. The following document provides the translation for these codes:

Reference Data Document

Are the files compressed?

The weekly data extract is compressed using Winzip.

How do I get Winzip?

You may download an unregistered evaluation version of Winzip at:

http://www.winzip.com

What are my options for using the data extract in different formats?

The data extract is provided in two formats:

Option I—Weekly data extract in a fixed-length, text-file format. This format is used primarily for end users who have a specific program that automatically updates their database. This method is not recommended for beginners!

The following WinZip file is a fixed length, text format. This is a full extract of select school data from PEPS. Please copy the file to your computer before decompressing.

WARNING! Once decompressed, the file is 127+ megabytes.

School File [8.5 MB]

Option II: Step 1—Microsoft Access "tables" and "forms". Provided for your ease of use is an Access database with a menu-driven system for refreshing the database using the weekly data extract file from Option II Step 2. You must have Access 97 or 2000 to use this database. Please copy the following file to your computer:

Microsoft Access Form and Tables [500 KB]

Option II: Step 2—Weekly data extract text files for Microsoft Access users. This format is the most frequently used and the easiest to work with. Each of the thirteen record types are provided as separate text files. The text files are named according to their database table names. The files follow the file layout documentation for each record type.
 

Text File Name Record Layout Type Database Table Name
HEADER Header 00 HEADER

DETAIL

School Detail

01

DETAIL

CONTACT

School Contact Information

02

CONTACT

PROGRAM

School Program Information

03

PROGRAM

SCHIDS

School Identifier Information

04

SCHIDS

DIRLOAN

School Direct Loan Information

05

DIRLOAN

COA

School Change of Affiliation

06

COA

AAGENCY

School Accreditation Information

07

AAGENCY

DEFAULT

School Default Rate Information

08

DEFAULT

OTHERADD

Other School Address Information

09

OTHERADD

EXSITE

School Experimental Site Information

10

EXSITE

CLOSURE

School Closure Information

11

CLOSURE

FEDSCHCD

School FAFSA Information

97

FEDSCHCD

TRAILER

Trailer

99

TRAILER


The following WinZip file contains the thirteen text files that make up the weekly data extract. This is a full extract of select school data from PEPS for Microsoft Access users. Please copy the file to your computer before decompressing.

WARNING! Once decompressed, the file is 127+ megabytes.

PEPS Data Files [8.3 MB]

How do I unzip files and use the Microsoft Access tables and form to import the data?

The following document, created in Microsoft PowerPoint, contains step-by-step procedures on how to copy the files from this site, decompress and import the Weekly Data Extract file into Microsoft Access 97 and 2000.

Downloading Instructions

Register for e-mail updates! If you are a regular user of the weekly data extracts, please send your name, company name, e-mail address, mailing address, and phone number to the following e-mail address: FSA_PEPS@ED.GOV. The information will be used to notify users of any problems or updates pertaining to the weekly data extracts.

If you have any questions or need assistance using the PEPS data extracts, please send an email to FSA_PEPS@ED.GOV.

 

Page last modified 4/14/14

 

End of Page