National Student Loan Data System

Loan Discharge (GADSC1)

July 16, 2007

1.0 NSLDS Loan Discharge Extract File Layout (GADSC1)

The Loan Discharge Report (GADSC1) provides GA users with detailed student and loan discharge information as reported by FFEL data providers. The output produced includes student identifiers (SSN, First and Last Names and Date of Birth), loan information (Loan Type, Loan Date, Separate Loan Indicator, OPEID, Loan Period Begin Date, Loan Period End Date and Loan Amount) as well as loan discharge information (Discharge Type, Discharge Amount, Action Date, and Discharge Source). The report parameter fields containing asterisks (*) select all records by default unless otherwise specified. The information is available in a formatted report or extract file. Additional hints for printing the formatted report in Microsoft Word are available in the Report List Help page. Extract file layouts are available at GA users receive the processed data via the SAIG mailbox associated with the NSLDS User ID requesting this report.

This section contains extract file layouts that list the header, details, and trailer records for the loan discharge batch request file produced. Each online extract request is used to generate one header record, one or more detail records, and one trailer record. Each record layout table contains the position, the data element name, description, field format, and length.

2.0 Loan Discharge Report Record Layouts

Loan Discharge Header Record Length = 161

Pos FR / Pos TO /
Data Element /
Description / Field Format /
Lth
1 / 1 / Record Type / ‘0’–Represents Header / Char. / 1
2 / 22 / Header Title / Value ‘LOAN DISCHARGE REPORT’ / Char. / 21
23 / 28 / Report Id / Identifier of report. GADSC1 or GADSC2. / Char. / 6
29 / 36 / Source / Code for source reporting loan discharge.
Spaces for all, valid GA code or NSLDS_ED. / Char. / 8
37 / 42 / School Code / Code for school being reported on.
‘*’ for any school. / Char. / 6
43 / 44 / School Branch Code / Code for school branch being reported on. / Char. / 2
45 / 45 / Range Type / Code indicating type of date to filter on.
‘A’ = Any dates
‘C’ = Action Date
‘L’ = Loan Date
‘P’ = Loan Period Begin Date / Char. / 1
46 / 53 / Begin Date / Lower end of date range. / Date / 8
54 / 61 / End Date / Upper end of date range. / Date / 8
62 / 65 / Type / Code for discharge type.
Spaces for any type. / Char. / 4
66 / 66 / Submittal Report Type / ‘R’ = Report
‘E’ = Extract data file / Char. / 1
67 / 74 / Submittal Date / Date which the Loan Discharge Report request is submitted. Format CCYYMMDD. / Date / 8
75 / 80 / Submittal Time / Time which the Loan Discharge Report request is submitted. Format HHMMSS. / Time / 6
81 / 161 / Filler / Attribute to complete record length. / Char. / 81

Loan Discharge Detail Record Length = 161

Pos FR / Pos TO /
Data Element /
Description / Field Format /
Lth
1 / 1 / Record Type / ‘1’–Represents Detail / Char. / 1
2 / 10 / SSN / Student’s current SSN / Char. / 9
11 / 22 / First Name / Student’s first name / Char. / 12
23 / 57 / Last Name / Student’s last name / Char. / 35
58 / 65 / DOB / Student’s date of birth / Date / 8
66 / 71 / School Code / Code for school being reported on. / Char. / 6
72 / 73 / School Branch Code / Code for school branch being reported on. / Char. / 2
74 / 94 / Loan External ID Code / Data Provider Loan ID / Char. / 21
95 / 96 / Loan Type / Type of Loan / Char. / 2
97 / 97 / FFEL Duplicate ID / Separate Loan Indicator / Char. / 1
98 / 105 / Date / Date of guaranty / Date / 8
106 / 113 / Period Begin Date / Beginning date of loan / Date / 8
114 / 121 / Period End Date / Ending date of loan / Date / 8
122 / 127 / Amount / Dollar amount of loan / Numeric / 6
128 / 131 / Type / Type of loan discharge / Char. / 4
132 / 137 / Cumulative Amount / Amount of discharge / Numeric / 6
138 / 145 / Date / Date of discharge / Date / 8
146 / 153 / Source / Source of discharge / Char. / 8
154 / 159 / School Code / Code for underlying discharge school in a loan consolidation. / Char. / 6
160 / 161 / School Branch Code / Code for underlying discharge school branch in a loan consolidation. / Char. / 2

Loan Discharge Trailer Record Length = 161

Pos FR / Pos TO /
Data Element /
Description / Field Format /
Lth
1 / 1 / Record Type / ‘9’–Represents Trailer Record / Char. / 1
2 / 10 / Student Count / Total count of distinct students reported on. / Num. / 9
11 / 19 / Loan Discharge Count / Total count of loan discharge records on this file (excluding header and trailer). / Num. / 9
20 / 161 / Filler / Attribute to complete record length. / Char. / 142

July 16, 2007NSLDS Loan Discharge Report Extract File Layout

1