Skip
Navigation

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).

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 September 24, 2014

End of Page