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

These instructions explain how to view the data files containing the reports for fiscal year (FY) 2011 Official Cohort Default Rates for Schools.

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 files. If Access is installed on your system, the files can be opened by directly clicking on the file name (e.g., 11300.accdb).

If you do not have Access, 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 .accdb file. If you cannot "see" the file, ensure that you have selected either All File Types or .accdb file types in the box in the lower left of the application window.

The following files are available for download (the 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):

300—FY 2011, FY 2010, and FY 2009 official cohort default rates published for schools participating in the Title IV student financial assistance programs.

304—Schools subject to loss of Direct Loan Program and/or Pell Grant Program eligibility due to FY 2011, FY 2010, and FY 2009 official cohort default rates of 30% or greater. Definition

305—Schools subject to loss of Direct Loan Program due to FY 2011 official cohort default rates greater than 40%. Definition

751—Schools that have an FY 2011 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.

753—Schools that have had an official cohort default rate of less than 15.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 427(a)(4) and (b)(3) of the Higher Education Opportunity Act (HERA).

Listing of the sector definitions

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

300

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
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 2011	Char	4
NBD_1	Number of Borrowers in Default for 2011	Char	10
NBR_1	Number of Borrowers in Repay for 2011	Char	10
DRATE_1	Official Default Rate for 2011	Char	5
AVG_1	Average Rate Indicator for 2011	Char	1
PRATE_1	Rate Program Type for 2011	Char	3
YR_2	Cohort Year 2010	Char	4
NBD_2	Number of Borrowers in Default for 2010	Char	10
NBR_2	Number of Borrowers in Repay for 2010	Char	10
DRATE_2	Official Default Rate for 2010	Char	5
AVG_2	Average Rate Indicator for 2010	Char	1
PRATE_2	Rate Program Type for 2010	Char	3
YR_3	Cohort Year 2009	Char	4
NBD_3	Number of Borrowers in Default for 2009	Char	10
NBR_3	Number of Borrowers in Repay for 2009	Char	10
DRATE_3	Official Default Rate for 2009	Char	5
AVG_3	Average Rate Indicator for 2009	Char	1
PRATE_3	Rate Program Type for 2009	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
CON_DIST	Congressional District	Char	2
REGION	Region	Char	2
AVGOR_GE30	Borrow Group Indicator (If 2011 rate is average and < 3 yrs data then 0 else 1)	Char	1

304

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
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 2011	Char	4
NBD_1	Number of Borrowers in Default for 2011	Char	10
NBR_1	Number of Borrowers in Repay for 2011	Char	10
DRATE_1	Official Default Rate for 2011	Char	5
RTSUBTP1	Rate Sub Type for 2011	Char	1
PRATE_1	Rate Program Type for 2011	Char	3
YR_2	Cohort Year 2010	Char	4
NBD_2	Number of Borrowers in Default for 2010	Char	10
NBR_2	Number of Borrowers in Repay for 2010	Char	10
DRATE_2	Official Default Rate for 2010	Char	5
RTSUBTP2	Rate Sub Type for 2010	Char	1
PRATE_2	Rate Program Type for 2010	Char	3
YR_3	Cohort Year 2009	Char	4
NBD_3	Number of Borrowers in Default for 2009	Char	10
NBR_3	Number of Borrowers in Repay for 2009	Char	10
DRATE_3	Official Default Rate for 2009	Char	5
RTSUBTP3	Rate Sub Type for 2009	Char	1
PRATE_3	Rate Program Type for 2009	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
ElgRpDt	Date eligible to reapply	Char	1

305

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
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 2011	Char	4
NBD_1	Number of Borrowers in Default for 2011	Char	10
NBR_1	Number of Borrowers in Repay for 2011	Char	10
DRATE_1	Official Default Rate for 2011	Char	5
RTSUBTP1	Rate Sub Type for 2011	Char	1
PRATE_1	Rate Program Type for 2011	Char	3
YR_2	Cohort Year 2010	Char	4
NBD_2	Number of Borrowers in Default for 2010	Char	10
NBR_2	Number of Borrowers in Repay for 2010	Char	10
DRATE_2	Official Default Rate for 2010	Char	5
RTSUBTP2	Rate Sub Type for 2010	Char	1
PRATE_2	Rate Program Type for 2010	Char	3
YR_3	Cohort Year 2009	Char	4
NBD_3	Number of Borrowers in Default for 2009	Char	10
NBR_3	Number of Borrowers in Repay for 2009	Char	10
DRATE_3	Official Default Rate for 2009	Char	5
RTSUBTP3	Rate Sub Type for 2009	Char	1
PRATE_3	Rate Program Type for 2009	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
ElgRpDt	Date eligible to reapply	Char	1

751 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
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 2011	Char	4
NBD_1	Number of borrowers in default for 2011	Char	10
NBR_1	Number of borrowers in repay for 2011	Char	10
DRATE_1	Default Rate for 2011	Long Integer	5
AVG_1	Average Default Rate Ind for 2011	Char	1
PRATE_1	Program Rate (or Loan Program) FL, DL, or DU for 2011	Char	3
YR_2	Cohort Year 2010	Char	4
NBD_2	Number of borrowers in default for 2010	Char	10
NBR_2	Number of borrowers in repay for 2010	Char	10
DRATE_2	Default Rate for 2010	Long Integer	5
AVG_2	Average Default Rate Ind for 2010	Char	1
PRATE_2	Program Rate (or Loan Program) FL, DL, or DU for 2010	Char	3
YR_3	Cohort Year 2009	Char	4
NBD_3	Number of borrowers in default for 2009	Char	10
NBR_3	Number of borrowers in repay for 2009	Char	10
DRATE_3	Default Rate for 2009	Long Integer	5
AVG_3	Average Default Rate Ind for 2009	Char	1
PRATE_3	Program Rate (or Loan Program) FL, DL, or DU for 2009	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
OnOrigPp	On Original Press Package	Char	1
ActRepayTotal	Cumulative Actual Repay Total for all three years	Num	8

Last updated December 5, 2014

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

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