Instructions for Using the Data Files
For the FY 2006 School Cohort Default Rate Reports

These instructions explain how to view the data files containing the reports for fiscal year (FY) 2006 Official Cohort Default Rates for Schools. To request a hard copy of these reports, please contact Default Management at (202) 377-4259 or via e-mail at fsa.schools.default.management@ed.gov.

Using the Data: These files have been compressed for downloading. After downloading, please use PKUNZIP, WinZIP, or another method to decompress the files. These are Microsoft Access 2000 files. If Access 00 is installed on your system, the files can be opened by directly clicking on the file name (e.g., 06peps300.mdb).

If you do not have Access 00, you can read and manipulate the data using Microsoft Excel. To do this, launch Excel and use the OPEN function under the FILE menu item to open the .mdb file. If you cannot "see" the file, ensure that you have selected either All File Types or .mdb file types in the box in the lower left of the application window.

The following files are available for download (the PEPS 304 and 305 reports will not be available for download if no schools are subject to cohort default rate sanctions in the most current cohort year):

PEPS300 - FY 2006, FY 2005, and FY 2004 official cohort default rates published for schools participating in the Title IV Federal Student Aid Programs.

PEPS304 - Schools subject to loss of FFEL Program, Direct Loan Program and/or Federal Pell Grant Program eligibility due to FY 2006, FY 2005, and FY 2004 official cohort default rates of 25% or greater. Please note that since no schools meet this criterion for FY 2006, no schools appear on this report. Definition

PEPS305 - Schools subject to loss of FFEL Program, Direct Loan Program and/or Federal Pell Grant Program eligibility due to FY 2006 official cohort default rates greater than 40%. Definition

PEPS751 - Schools that have an FY 2006 official cohort default rate that is less than 5.0% and are eligible to make single and non-delayed disbursements on loans used for attendance in a study abroad program as defined in Section 428G(e) of the HEA.

PEPS753 - Schools that have had an official cohort default rate of less than 10.0% for each of the three most recent fiscal years for which data are available, including eligible foreign institutions. These schools are eligible to disburse, in a single installment, loans that are made for one semester, one trimester, one quarter, or a four-month period. Such an institution is also no longer required to delay the first disbursement of a loan for 30 days for first-time, first-year undergraduate borrowers as defined in Section 428G(a)(3) and (b)(1) of the Higher Education Reconciliation Act of 2005 (HERA).

File Layouts - The layouts of the MS Access files are contained in the following tables.

PEPSR300

Field Name	Field Description	Type	Width
OPE_ID	OPE ID	Char	8
NAME	Institution Name	Char	70
ADDR	Street Address	Char	35
CITY	City	Char	25
ST_CD	State Abbreviation	Char	2
ST_DESC	State Name	Char	50
ZIP	Zip Code	Char	5
ZIP_EXT	Zip Code Extension	Char	6
Country	Country Name of foreign schools	Char	50
PGM_LEN	Program Length (Bachelor, Master, Associate, etc.)	Char	50
SCH_TYPE	School Type (Public, Private, Proprietary, Foreign, etc.)	Char	10
YR_1	Cohort Year 2006	Char	4
NBD_1	Number of Borrowers in Default for 2006	Char	10
NBR_1	Number of Borrowers in Repay for 2006	Char	10
DRATE_1	Official Default Rate for 2006	Char	5
AVG_1	Average Rate Indicator for 2006	Char	1
PRATE_1	Rate Program Type for 2006	Char	3
YR_2	Cohort Year 2005	Char	4
NBD_2	Number of Borrowers in Default for 2005	Char	10
NBR_2	Number of Borrowers in Repay for 2005	Char	10
DRATE_2	Official Default Rate for 2005	Char	5
AVG_2	Average Rate Indicator for 2005	Char	1
PRATE_2	Rate Program Type for 2005	Char	3
YR_3	Cohort Year 2004	Char	4
NBD_3	Number of Borrowers in Default for 2004	Char	10
NBR_3	Number of Borrowers in Repay for 2004	Char	10
DRATE_3	Official Default Rate for 2004	Char	5
AVG_3	Average Rate Indicator for 2004	Char	1
PRATE_3	Rate Program Type for 2004	Char	3
Eth_Cert	Ethnic Code or No Longer in FFEL Program (Code "C", "H", "T", or blank)[C=No Longer in FFEL Program; H=HBCU; T=TCCC]	Char	1
PROGRAM	F=FFEL Participation; D=Direct Loan Program Participation; B=Participation in both Programs	Char	1
CON_DIST	Congressional District	Char	2
REGION	Region	Char	2
AVGOR_GE30	Borrow Group Indicator (If 2006 rate is average and < 3 yrs data then 0 else 1)	Char	1

PEPSR304

Field Name	Field Description	Type	Width
OPE_ID	OPE ID	Char	8
NAME	Institution Name	Char	70
ADDR	Street Address	Char	35
CITY	City	Char	25
ST_CD	State Abbreviation	Char	2
ST_DESC	State Name	Char	50
ZIP	Zip Code	Char	5
ZIP_EXT	Zip Code Extension	Char	6
Country	Country Name of foreign schools	Char	50
PGM_LEN	Program Length (Bachelor, Master, Associate, etc.)	Char	50
SCH_TYPE	School Type (Public, Private, Proprietary, Foreign, etc.)	Char	10
REGION	Region	Char	2
CON_DIST	Congressional District	Char	2
YR_1	Cohort Year 2006	Char	4
NBD_1	Number of Borrowers in Default for 2006	Char	10
NBR_1	Number of Borrowers in Repay for 2006	Char	10
DRATE_1	Official Default Rate for 2006	Char	5
RTSUBTP1	Rate Sub Type for 2006	Char	1
PRATE_1	Rate Program Type for 2006	Char	3
YR_2	Cohort Year 2005	Char	4
NBD_2	Number of Borrowers in Default for 2005	Char	10
NBR_2	Number of Borrowers in Repay for 2005	Char	10
DRATE_2	Official Default Rate for 2005	Char	5
RTSUBTP2	Rate Sub Type for 2005	Char	1
PRATE_2	Rate Program Type for 2005	Char	3
YR_3	Cohort Year 2004	Char	4
NBD_3	Number of Borrowers in Default for 2004	Char	10
NBR_3	Number of Borrowers in Repay for 2004	Char	10
DRATE_3	Official Default Rate for 2004	Char	5
RTSUBTP3	Rate Sub Type for 2004	Char	1
PRATE_3	Rate Program Type for 2004	Char	3
ActnDt	Effective Date of the Action	Char	10
ActnDesc	Action Name	Char	50
Eth_Cert	Ethnic Code or No Longer in FFEL Program (Code "C", "H", "T", or blank) [C=No Longer in FFEL Program; H=HBCU; T=TCCC]	Char	1
PROGRAM	F=FFEL Participation; D=Direct Loan Program Participation; B=Participation in both Programs	Char	1
ElgRpDt	Date eligible to reapply	Char	1

PEPSR305

Field Name	Field Description	Type	Width
OPE_ID	OPE ID	Char	8
NAME	Institution Name	Char	70
ADDR	Street Address	Char	35
CITY	City	Char	25
ST_CD	State Abbreviation	Char	2
ST_DESC	State Name	Char	50
ZIP	Zip Code	Char	5
ZIP_EXT	Zip Code Extension	Char	6
Country	Country name of foreign school	Char	50
PGM_LEN	Program Length (Bachelor, Master, Associate, etc.)	Char	50
SCH_TYPE	School Type (Public, Private, Proprietary, Foreign, etc.)	Char	10
REGION	Region	Char	2
CON_DIST	Congressional District	Char	2
YR_1	Cohort Year 2006	Char	4
NBD_1	Number of Borrowers in Default for 2006	Char	10
NBR_1	Number of Borrowers in Repay for 2006	Char	10
DRATE_1	Official Default Rate for 2006	Char	5
RTSUBTP1	Rate Sub Type for 2006	Char	1
PRATE_1	Rate Program Type for 2006	Char	3
YR_2	Cohort Year 2005	Char	4
NBD_2	Number of Borrowers in Default for 2005	Char	10
NBR_2	Number of Borrowers in Repay for 2005	Char	10
DRATE_2	Official Default Rate for 2005	Char	5
RTSUBTP2	Rate Sub Type for 2005	Char	1
PRATE_2	Rate Program Type for 2005	Char	3
YR_3	Cohort Year 2004	Char	4
NBD_3	Number of Borrowers in Default for 2004	Char	10
NBR_3	Number of Borrowers in Repay for 2004	Char	10
DRATE_3	Official Default Rate for 2004	Char	5
RTSUBTP3	Rate Sub Type for 2004	Char	1
PRATE_3	Rate Program Type for 2004	Char	3
ActnDt	Effective Date of the Action	Char	10
ActnDesc	Action Name	Char	50
Eth_Cert	Ethnic Code or No Longer in FFEL Program (Code "C", "H", "T", or blank) [C=No Longer in FFEL Program; H=HBCU; T=TCCC]	Char	1
PROGRAM	F=FFEL Participation; D=Direct Loan Program Participation; B=Participation in both Programs	Char	1
ElgRpDt	Date eligible to reapply	Char	1

PEPSR751 and 753

Field Name	Field Description	Type	Width
OPE_ID	OPE_ID	Char	8
NAME	Institution Name	Char	70
ADDR	Address	Char	35
CITY	City	Char	25
ST_CD	State Abbreviation	Char	2
ST_DESC	State Name	Char	50
ZIP	Zip Code	Char	5
ZIP_EXT	Zip Code Extension	Char	6
Country	Country Name of foreign schools	Char	50
PGM_LEN	Program Length (Bachelor, Master, Associate, etc.)	Char	50
SCH_TYPE	School Type (Public, Private, Proprietary, Foreign, etc.)	Char	10
YR_1	Cohort Year 2006	Char	4
NBD_1	Number of borrowers in default for 2006	Char	10
NBR_1	Number of borrowers in repay for 2006	Char	10
DRATE_1	Default Rate for 2006	Long Integer	5
AVG_1	Average Default Rate Ind for 2006	Char	1
PRATE_1	Program Rate (or Loan Program) FL, DL, or DU for 2006	Char	3
YR_2	Cohort Year 2005	Char	4
NBD_2	Number of borrowers in default for 2005	Char	10
NBR_2	Number of borrowers in repay for 2005	Char	10
DRATE_2	Default Rate for 2005	Long Integer	5
AVG_2	Average Default Rate Ind for 2005	Char	1
PRATE_2	Program Rate (or Loan Program) FL, DL, or DU for 2005	Char	3
YR_3	Cohort Year 2004	Char	4
NBD_3	Number of borrowers in default for 2004	Char	10
NBR_3	Number of borrowers in repay for 2004	Char	10
DRATE_3	Default Rate for 2004	Long Integer	5
AVG_3	Average Default Rate Ind for 2004	Char	1
PRATE_3	Program Rate (or Loan Program) FL, DL, or DU for 2004	Char	3
Eth_Cert	Ethnic Code or No Longer in FFEL Program (Code "C", "H", "T", or blank) [C=No Longer in FFEL Program; H=HBCU; T=TCCC]	Char	1
PROGRAM	F=FFEL Participation; D=Direct Loan Program Participation; B=Participation in both Programs	Char	1
OnOrigPp	On Original Press Package	Char	1
ActRepayTotal	Cumulative Actual Repay Total for all three years	Num	8

Last updated September 15, 2008

Instructions for Using the Data Files For the FY 2006 School Cohort Default Rate Reports

Instructions for Using the Data Files
For the FY 2006 School Cohort Default Rate Reports