B Extract Form PDF Details

Understanding the details enclosed in the B Extract form is crucial for anyone dealing with electronic loan record detail reports and repayment information. This form encompasses a comprehensive layout designed to streamline the process of categorizing and providing accurate records related to loan details and repayment specifics. Highlighted within the form are key elements such as position, field lengths, formats, and names, alongside their descriptions, which collectively ensure precise record-keeping and ease of data interpretation. Particularly, it aids in identifying distinct aspects of a loan such as organizational IDs, school codes, borrower information, and pertinent dates including loan repayment and default statuses. For those seeking a deeper understanding of each field, additional insights are provided in the “Loan Record Detail Report” section, starting from page 47. This layout not only facilitates the tracking of loan records but also plays a significant role in managing default rates and repayment strategies, emphasizing the importance of the B Extract form in educational financing and administration.

QuestionAnswer
Form NameB Extract Form
Form Length8 pages
Fillable?No
Fillable fields0
Avg. time to fill out2 min
Other nameskarnataka mobile one b extract, b extract form pdf, rto b extract, parivahan b extract

Form Preview Example

Appendix B

Extract File Layout

for Electronic Loan Record

Detail Report and

Repayment Information

The file layout contained in this appendix applies to the extract file associated with both the electronic loan record detail report and the repayment information detailed file format. The file layout contains:

positions;

field lengths;

field formats;

field names;

AND

field descriptions.

For an in-depth discussion on each field, please refer to the “Loan Record Detail Report” section beginning on page 47.

FY 1998 Official Cohort Default Rate Guide

Page 1

Extract File Layout for Electronic Loan Record Detail Report and Repayment InformationAppendix B

Position

Position

Field

Field

Name

Description Field Content

from

to

Length

Format

 

 

1

20

20

Character

Filler

Filler

 

 

 

 

 

 

21

21

1

Numeric

Record Type

Indicator used to identify the header

 

 

 

 

 

record. Value must be “1” (one).

 

 

 

 

 

 

22

29

8

Numeric

Organization

The eight-digit ED OPE ID code used to

 

 

 

 

ID Number

identify the school receiving the loan

 

 

 

 

 

record detail report.

 

 

 

 

 

 

30

143

114

Character

Filler

Filler

 

 

 

 

 

 

144

203

60

Character

Organization

School’s name.

 

 

 

 

Name

 

 

 

 

 

 

 

204

253

50

Character

Address

School’s address.

 

 

 

 

 

 

254

273

20

Character

City

School’s city.

 

 

 

 

 

 

274

275

2

Character

State

School’s state.

 

 

 

 

 

 

276

295

20

Character

Country

School’s country.

 

 

 

 

 

 

296

304

9

Numeric

Zip Code

School’s Zip Code.

 

 

 

 

 

 

305

312

8

Date

Request Date

Identifies the request date of the loan

 

 

 

 

 

record detail report report; format is

 

 

 

 

 

CCYYMMDD.

 

 

 

 

 

 

313

320

8

Date

Rate

Identifies the date the rate was

 

 

 

 

Calculation

calculated; format is CCYYMMDD.

 

 

 

 

Date

 

 

 

 

 

 

 

321

324

4

Date

Cohort Year

Identifies the cohort period associated

 

 

 

 

 

with the report; format is CCYY.

 

 

 

 

 

 

325

331

7

Character

Title IV

Identifies the program type of loans

 

 

 

 

Program

included in the loan record detail report.

 

 

 

 

 

 

332

334

3

Character

Filler

Filler

 

 

 

 

 

 

335

335

1

Numeric

Filler

Filler

 

 

 

 

 

 

Page 2

FY 1998 Official Cohort Default Rate Guide

Appendix BExtract File Layout for Electronic Loan Record Detail Report and Repayment Information

Position

Position

Field

Field

Name

Description Field Content

from

to

Length

Format

 

 

1

20

20

Character

Filler

Filler

 

 

 

 

 

 

21

21

1

Character

Record Type

Indicator used to identify the detail

 

 

 

 

 

record. Value must be “2” (two).

 

 

 

 

 

 

22

29

8

Character

School Code

An eight-digit code used by ED OPE to

 

 

 

 

 

identify the school submitting the loan

 

 

 

 

 

record detail report request.

 

 

 

 

 

 

30

37

8

Character

Filler

Filler

 

 

 

 

 

 

38

46

9

Character

SSN

Title IV recipient’s or beneficiary’s

 

 

 

 

 

Social Security Number.

 

 

 

 

 

 

47

47

1

Character

Default Rate

Identifies how the loan is counted in the

 

 

 

 

Usage Code

school’s cohort default rate calculation.

 

 

 

 

 

 

48

65

18

Character

Filler

Filler

 

 

 

 

 

 

66

100

35

Character

Current Last

Title IV recipient’s or beneficiary’s

 

 

 

 

Name

current last name.

 

 

 

 

 

 

101

112

12

Character

Current First

Title IV recipient’s or beneficiary’s

 

 

 

 

Name

current first name.

 

 

 

 

 

 

113

113

1

Character

Student

Title IV recipient’s or beneficiary’s

 

 

 

 

Middle Initial

middle initial.

 

 

 

 

 

 

114

121

8

Numeric

Student Date

Title IV recipient’s or beneficiary’s date

 

 

 

 

of Birth

of birth.

 

 

 

 

 

 

122

129

8

Character

Original

ED OPE code for school that

 

 

 

 

School Code

certified/originated the loan for the

 

 

 

 

 

borrower.

 

 

 

 

 

 

130

137

8

Numeric

Begin Class

The date classes were scheduled to

 

 

 

 

Date

begin for the loan period covered by the

 

 

 

 

 

loan.

 

 

 

 

 

 

138

145

8

Numeric

End Class

The date classes were scheduled to

 

 

 

 

Date

end for the loan period covered by the

 

 

 

 

 

loan.

 

 

 

 

 

 

146

146

1

Character

Academic

Student’s academic or grade level in

 

 

 

 

Level

school at the beginning of the specific

 

 

 

 

 

period covered by the loan.

 

 

 

 

 

 

147

152

6

Character

Original

Code for entity that provided the loan to

 

 

 

 

Lender/

the student; identifies the originating

 

 

 

 

Servicer

holder of the loan.

 

 

 

 

Code

 

 

 

 

 

 

 

153

156

4

Character

Filler

Filler

 

 

 

 

 

 

157

162

6

Character

Current

Current lender code.

 

 

 

 

Lender/

 

 

 

 

 

Servicer

 

 

 

 

 

Code

 

 

 

 

 

 

 

FY 1998 Official Cohort Default Rate Guide

Page 3

Extract File Layout for Electronic Loan Record Detail Report and Repayment InformationAppendix B

Position

Position

Field

Field

Name

Description Field Content

from

to

Length

Format

 

 

163

166

4

Character

Current

Current lender branch.

 

 

 

 

Lender/

 

 

 

 

 

Servicer

 

 

 

 

 

Branch

 

 

 

 

 

 

 

167

168

2

Character

Loan Type

The type of loan.

 

 

 

 

 

 

169

170

2

Character

Loan Status

The status of the borrower’s loan.

 

 

 

 

Code

 

 

 

 

 

 

 

171

178

8

Numeric

Loan Status

Effective date of the loan status code.

 

 

 

 

Code Date

 

 

 

 

 

 

 

179

186

8

Numeric

Repay Date

Date loan entered repayment.

 

 

 

 

 

 

187

192

6

Numeric

Amount

Full amount of the loan.

 

 

 

 

 

 

193

195

3

Character

Code for

Entity that guaranties the loan on behalf

 

 

 

 

Guarantor/

of the Department or entity that the

 

 

 

 

Servicer

Department contracts with to service

 

 

 

 

 

Direct Loans.

 

 

 

 

 

 

196

203

8

Numeric

Guaranty

Date that the guaranty agency insured

 

 

 

 

Loan Date

an FFEL Program loan or the first date

 

 

 

 

 

of disbursement for a Direct Loan

 

 

 

 

 

Program.

 

 

 

 

 

 

204

211

8

Numeric

Default

Date that a default claim was paid on an

 

 

 

 

NegAm Date

FFEL Program loan or the day of

 

 

 

 

 

default, for cohort default rate purposes,

 

 

 

 

 

for Direct Loan Program loans or the

 

 

 

 

 

day certain Direct Loan Program loans

 

 

 

 

 

are considered in default, for cohort

 

 

 

 

 

default rate purposes, if the loan has

 

 

 

 

 

been in an income contingent

 

 

 

 

 

repayment plan with payments of less

 

 

 

 

 

than $15 per month that resulted in

 

 

 

 

 

negative amortization for a certain

 

 

 

 

 

period of time.

 

 

 

 

 

 

212

213

2

Character

Claim

Identifies the reason a claim was paid

 

 

 

 

Reason Code

on an FFEL Program loan or if a Direct

 

 

 

 

 

Loan Program has defaulted or, for

 

 

 

 

 

some Direct Loan Program loans, if the

 

 

 

 

 

loan entered into an income contingent

 

 

 

 

 

repayment plan that resulted in negative

 

 

 

 

 

amortization.

 

 

 

 

 

 

214

234

21

Character

Filler

Filler

 

 

 

 

 

 

235

235

1

Character

Enrollment

Student’s enrollment status at the time

 

 

 

 

Code

the cohort default rate was calculated.

 

 

 

 

 

 

Page 4

FY 1998 Official Cohort Default Rate Guide

Appendix BExtract File Layout for Electronic Loan Record Detail Report and Repayment Information

Position

Position

Field

Field

Name

Description Field Content

from

to

Length

Format

 

 

236

243

8

Numeric

Enrollment

Effective date of the Enrollment Status

 

 

 

 

Code Date

Code. If no data is available, the

 

 

 

 

 

guaranty agency or Direct Loan servicer

 

 

 

 

 

may use 01/01/1900.

 

 

 

 

 

 

244

244

1

Character

Program

Identifies loan program type “F” (FFEL)

 

 

 

 

Type

or “D” (Direct Loan).

 

 

 

 

 

 

245

249

5

Character

Filler

Filler

 

 

 

 

 

 

250

255

6

Numeric

Claim

The claim amount.

 

 

 

 

Amount

 

 

 

 

 

 

 

256

261

6

Numeric

Outstanding

The original dollar amount of the loan.

 

 

 

 

Principal

 

 

 

 

 

Balance

 

 

 

 

 

 

 

262

263

2

Character

Usage Two

Identifies how the loan is counted in

 

 

 

 

 

each individual loan program (i.e., the

 

 

 

 

 

FFEL Program and/or the Direct Loan

 

 

 

 

 

Program).

 

 

 

 

 

 

264

320

57

Character

Filler

Filler

 

 

 

 

 

 

321

324

4

Character

Cohort Year

Identifies the cohort year; format is

 

 

 

 

 

CCYY.

 

 

 

 

 

 

325

335

11

Character

Filler

Filler

 

 

 

 

 

 

FY 1998 Official Cohort Default Rate Guide

Page 5

Extract File Layout for Electronic Loan Record Detail Report and Repayment InformationAppendix B

Position

Position

Field

Field

Name

Description Field Content

from

to

Length

Format

 

 

1

20

20

Character

Filler

Filler

 

 

 

 

 

 

21

21

1

Character

Record Type

Indicator used to identify the trailer

 

 

 

 

 

record. Value must be “3” (three).

 

 

 

 

 

 

22

29

8

Character

School Code

An eight-digit ED OPE code used to

 

 

 

 

 

identify the school receiving the loan

 

 

 

 

 

record detail report.

 

 

 

 

 

 

30

31

2

Character

Filler

Filler

 

 

 

 

 

 

32

39

8

Numeric

Actual

The total number of unduplicated

 

 

 

 

Numerator

borrowers reported in the numerator of

 

 

 

 

Count

the cohort default rate. The report count

 

 

 

 

 

for the numerator represents the

 

 

 

 

 

unduplicated report with a “B” in the

 

 

 

 

 

usage code 1 field.

 

 

 

 

 

 

40

47

8

Numeric

Actual

The total number of unduplicated

 

 

 

 

Denominator

borrowers reported in the denominator

 

 

 

 

Count

of the cohort default rate. The report

 

 

 

 

 

count for the denominator represents

 

 

 

 

 

the unduplicated borrower listed on the

 

 

 

 

 

loan record detail report with a “D” or

 

 

 

 

 

“B” in the usage code 1 field.

 

 

 

 

 

 

48

55

8

Numeric

Report Count

Identifies the unduplicated number of

 

 

 

 

 

borrowers included in the numerator of

 

 

 

 

 

the cohort default rate calculation.

 

 

 

 

 

 

56

63

8

Numeric

Report Count

Identifies the unduplicated number of

 

 

 

 

 

borrowers included in the denominator

 

 

 

 

 

of the cohort default rate calculation.

 

 

 

 

 

 

64

71

8

Numeric

IC

Identifies the number of borrowers

 

 

 

 

 

meeting income contingency repayment

 

 

 

 

 

conditions on the loan record detail

 

 

 

 

 

report.

 

 

 

 

 

 

72

79

8

Numeric

Individual

The total number of unduplicated

 

 

 

 

Program

borrowers counted in the numerator of

 

 

 

 

Tally

the FFEL Program.

 

 

 

 

 

 

80

87

8

Numeric

Individual

The total number of unduplicated

 

 

 

 

Program

borrowers counted in the denominator

 

 

 

 

Tally

of the FFEL Program.

 

 

 

 

 

 

88

95

8

Numeric

Individual

The total number of unduplicated

 

 

 

 

Program

borrowers counted in the numerator of

 

 

 

 

Tally

the Direct Loan Program.

 

 

 

 

 

 

96

103

8

Numeric

Individual

The total number of unduplicated

 

 

 

 

Program

borrowers counted in the denominator

 

 

 

 

Tally

of the Direct Loan Program.

 

 

 

 

 

 

Page 6

FY 1998 Official Cohort Default Rate Guide

Appendix BExtract File Layout for Electronic Loan Record Detail Report and Repayment Information

Position

Position

Field

Field

Name

Description Field Content

from

to

Length

Format

 

 

104

135

32

Numeric

Filler

Filler

 

 

 

 

 

 

136

136

1

Character

Appealed

Identifies if the cohort default rate has

 

 

 

 

Rate Flag

been revised due to an appeal.

 

 

 

 

 

 

137

146

10

Numeric

Dual Total

Total dollars in default. The FFEL

 

 

 

 

Dollars in

Program and Direct Loan Program

 

 

 

 

Default

entries within this field indicate the total

 

 

 

 

 

dollar volume of defaulted loans

 

 

 

 

 

included in the cohort default rate

 

 

 

 

 

calculation.

 

 

 

 

 

 

147

156

10

Numeric

Dual Total

Total dollars in repayment. The FFEL

 

 

 

 

Dollars in

Program and Direct Loan Program

 

 

 

 

Repayment

entries within this field indicate the total

 

 

 

 

 

dollar volume for loans that have

 

 

 

 

 

entered into repayment during the

 

 

 

 

 

cohort period in question.

 

 

 

 

 

 

157

166

10

Numeric

FFEL Total

Dollars in default on FFEL Program.

 

 

 

 

Dollars in

 

 

 

 

 

Default

 

 

 

 

 

 

 

167

176

10

Numeric

FFEL Total

Dollars in repayment on FFEL Program.

 

 

 

 

Dollars in

 

 

 

 

 

Repayment

 

 

 

 

 

 

 

177

186

10

Numeric

Direct Total

Dollars in default on Direct Loan

 

 

 

 

Dollars in

Program.

 

 

 

 

Default

 

 

 

 

 

 

 

187

196

10

Numeric

Direct Total

Dollars in repayment on Direct Loan

 

 

 

 

Dollars in

Program.

 

 

 

 

Repayment

 

 

 

 

 

 

 

197

206

10

Numeric

Total

Identifies the total dollar amount for

 

 

 

 

Insurance

insurance claim payments.

 

 

 

 

Claim

 

 

 

 

 

Payments

 

 

 

 

 

 

 

207

320

114

Character

Filler

Filler

 

 

 

 

 

 

321

324

4

Date

Trailer Sort

Identifies the cohort year; format is

 

 

 

 

Cohort Year

CCYY.

 

 

 

 

 

 

325

335

11

Character

Filler

Filler

 

 

 

 

 

 

FY 1998 Official Cohort Default Rate Guide

Page 7

Extract File Layout for Electronic Loan Record Detail Report and Repayment Information

Appendix B

Page 8

FY 1998 Official Cohort Default Rate Guide