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.
| Question | Answer |
|---|---|
| Form Name | B Extract Form |
| Form Length | 8 pages |
| Fillable? | No |
| Fillable fields | 0 |
| Avg. time to fill out | 2 min |
| Other names | karnataka mobile one b extract, b extract form pdf, rto b extract, parivahan b extract |
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
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 |
|
|
|
|
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 |
|
|
|
|
|
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 |
|
|
|
|
|
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 |