Appendix A: Web Report Extract File Layouts
National Student Loan Data System
Teacher Loan Forgiveness (GATLF1)
July 16, 2007
1.0 NSLDS Teacher Loan Forgiveness Extract File Layout (GATLF1)
The Teacher Loan Forgiveness Report (GATLF1) provides GA users with detailed student and Teacher Loan Forgiveness (TLF) information as reported by FFEL data providers. The output produced includes student identifiers (SSN, First and Last Names and Date of Birth), as well as TLF information (TLF Type, Paid Date, Submission Date, TLF Amount, TLF Source, Student's State of Application, Lender Code and TLF Totals). 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 Teacher Loan Forgiveness 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 Teacher Loan Forgiveness Report Record Layouts
TLF Header Record Length = 105
|Pos FR |Pos TO |Attribute |Description |Field Format|Lth |
|1 |1 |Record Type |‘0’–Represents Header |Char. |1 |
|2 |32 |Header Title |Value ‘TEACHER LOAN FORGIVENESS |Char. |31 |
| | | |REPORT’ | | |
|33 |38 |Report Id |Identifier of report. GATLF1 or |Char. |6 |
| | | |GATLF2. | | |
|39 |46 |Source |Code for source reporting TLF. |Char. |8 |
| | | |Spaces for all, valid GA code or | | |
| | | |NSLDS_ED. | | |
|47 |49 |Code |Code for Guaranty Agency to report |Char. |3 |
| | | |on. | | |
| | | |Spaces for all GAs. | | |
|50 |57 |Beginning Paid Date |Lower end of date range. |Date |8 |
|58 |65 |Ending Paid Date |Upper end of date range. |Date |8 |
|66 |67 |Type |Code for TLF eligibility. |Char. |2 |
| | | |spaces = Any | | |
| | | |“ES” = Elementary School | | |
| | | |“SS” = Secondary School | | |
| | | |“HQ” = Highly Qualified | | |
| | | |“SM” = Secondary Math | | |
| | | |“SC” = Secondary Science | | |
| | | |“EE” = Elementary Special Ed. | | |
| | | |“SE” = Secondary Special Ed. | | |
|68 |69 |State |Student’s State of Application. |Char. |2 |
| | | |Spaces for any state. | | |
|70 |70 |Submittal Report Type |‘R’ = Report |Char. |1 |
| | | |‘E’ = Extract data file | | |
|71 |78 |Submittal Date |Date which the TLF Report request |Date |8 |
| | | |is submitted. Format CCYYMMDD. | | |
|79 |84 |Submittal Time |Time which the TLF Report request |Time |6 |
| | | |is submitted. Format HHMMSS. | | |
|85 |105 |Filler |Attribute to complete record |Char. |21 |
| | | |length. | | |
TLF Detail 1 Record Length = 105
|Pos FR |Pos TO | | |Field Format| |
| | |Attribute |Description | |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 |70 |TLF Total |Cumulative amount of TLF for a |Numeric |5 |
| | | |student. | | |
|71 |104 |Filler |Attribute to complete record |Char. |34 |
| | | |length. | | |
|105 |105 |Record Sub Type |‘1’–Represents summary detail |Char. |1 |
TLF Detail 2 Record Length = 105
|Pos FR |Pos TO | | |Field Format| |
| | |Attribute |Description | |Lth |
|1 |1 |Record Type |‘2’–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 |67 |Type |Code for TLF eligibility. |Char. |2 |
| | | |‘A’ = Any | | |
| | | |‘ES’ = Elementary School | | |
| | | |‘SS’ = Secondary School | | |
| | | |‘HQ’ = Highly Qualified | | |
| | | |‘SM’ = Secondary Math | | |
| | | |‘SC’ = Secondary Science | | |
| | | |‘EE’ = Elementary Special Ed. | | |
| | | |‘SE’ = Secondary Special Ed. | | |
|68 |75 |Paid Date |Date TLF was paid. |Date |8 |
|76 |80 |Amount |Dollar amount of TLF. |Numeric |5 |
|81 |88 |System Create Date |Date of when the record was |Date |8 |
| | | |received and stored in NSLDS. | | |
|89 |96 |Source |GA Code or ‘NSLDS_ED’ that created |Char. |8 |
| | | |the TLF. | | |
|97 |98 |State |Student’s State of Application |Char. |2 |
|99 |104 |Lender Code |Identifying code of the Lender |Char. |6 |
| | | |Holder | | |
|105 |105 |Record Sub Type |‘2’–Represents fine detail |Char. |1 |
TLF Trailer Record Length = 105
|Pos FR |Pos TO | | |Field Format| |
| | |Attribute |Description | |Lth |
|1 |1 |Record Type |‘9’–Represents Trailer Record |Char. |1 |
|2 |10 |Student Count |Total count of distinct students |Num. |9 |
| | | |reported on. | | |
|11 |19 |TLF Count |Total count of TLF records on this |Num. |9 |
| | | |file (excluding header, detail 1 | | |
| | | |and trailer). | | |
|20 |105 |Filler |Attribute to complete record |Char. |86 |
| | | |length. | | |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.