GA Data Provider Instructions Appendix A: Data Dictionary
Introduction A–1
Layout Description A–3
Indexes A–5
Index 1: Guaranty Agency Header Data Elements (Sorted by Position) A–6
Index 2: Guaranty Agency Detail Data Elements (Sorted by Position) A–7
Index 3: Guaranty Agency Detail Data Elements (Sorted by Field Code Number) A–11
Index 4: Guaranty Agency Detail Data Elements (Sorted Alphabetically by Name) A–15
Index 5: Guaranty Agency Trailer Data Elements (Sorted by Position) A–19
Layouts A–21
Header Record Layout A–21
Detail Record Layout A–36
Trailer Record Layout A–203
Appendix A, Guaranty Agency Data Dictionary, provides the following tools to help create your Database Extract file:
Indexes for the data elements
Header, Detail, and Trailer Record layouts
Each record layout illustrates the data fields’ lengths, types, position, description, validation edits, relationships to other data elements, and more. The Database Extract file created by data providers must adhere to these processing specifications. The Database Extract file must mirror the data provider’s system of records and is subject to audit and program reviews. The DataPrep software provided by ED reads and processes the Database Extract file. Assuming no File Level Errors (causing the file to be rejected) and that Domain Level Errors are below tolerance levels set by ED, the DataPrep software will create the Submittal file. The data provider then sends the Submittal file to NSLDS.
If DataPrep cannot read your Database Extract file, you will get a file-level error. PC users should refer to Appendix B–Table B-15, for a list of the file-level edits and error messages. Z/OS LE users should refer to Appendix B–Table B-16. All other edit conditions and error messages will be noted on the page for each data element.
Note: Please be particularly careful about sending the current Submittal file to NSLDS. Do not send the Database Extract file as it will be rejected. Do not send the Submittal file from the previous month as it also will be rejected. Each data provider should establish a process to ensure that the current Submittal file is sent at least once a month.
Data elements are defined as character, numeric, or date fields, where:
Character fields may contain letters, numbers, or blanks.
Numeric fields must only contain numbers.
Date fields must contain eight digits, be valid dates, and appear in the format CCYYMMDD (e.g., 19970131), where:
CC = 2 digits for century
YY = 2 digits for year
MM = 2 digits for month
DD = 2 digits for day
The following are the default values that are used for each type of field:
Character fields—must be filled with spaces.
Numeric fields—must be filled with zeroes.
Date fields—must be filled with zeroes.
The following definitions explain the fields of the data elements.
Name—The data element or field name.
Loan Identifier—Denotes whether the field belongs to the set of data elements that together uniquely identify a loan (values in positions 4-60). These key Identifier fields, and their counterpart New Identifiers, are treated as a block. Changes made to one identifier require that all the identifiers be re-confirmed.
History Kept—Indicates whether history is kept for the data element. History is what you have reported in the past.
Reasonability—Determines the reasonability of guaranty agency’s monthly, quarterly, or annual financial reports. For fields that contain dates, this field should correspond to the dates used for financial reporting. For fields that contain amounts, this field should correspond to the amounts used in financial reporting.
Date Sequence Edit—Alerts you that date changes made to this field must fall within the acceptable range of dates, in relation to historical data that may exist in NSLDS for this loan, or they will cause Date Sequence Errors.
Type—Indicates whether a field is a character, numeric, or date field.
Size—The number of bytes in the field.
Position—The physical position of the data within the record type being defined (Header, Detail, Past Period Change).
Field Code—The number assigned to a given field in NSLDS and used in generating error messages.
Description—A short definition of the data element.
Comments—Additional remarks on handling data in the field.
Part of Event Type—Indicates whether the field is part of an event, and therefore linked to other fields that may be affected by changes made here. If the data element is associated with an event, the event name is given.
Companion Field(s)—Identifies the relationship this field has to other fields. These relationships may be:
Linked through edit—This field checks the value in the listed companion field(s), (e.g., Date in one field must be earlier than/later than the date in the other). An error will result if the relationship does not fall within NSLDS expected parameters.
Linked through event—Two or more data elements are related, because their meaning is lost if they are handled separately (e.g., Code for Loan Status and Date of Loan Status are both part of the event Loan Status). A change made to one field may affect the others in the event. The possible effect on all the related fields should be considered before a change is made to any one of them.
Related Fields—The listed companion field checks the value contained in this field. If there is an error, it will occur in the field that checks the value of this field. This shows that a relationship exists with another field based on the value in this field. For example, Date of Guaranty is a related field that checks the value in the Submittal (Extract) Date field.
Default Value/Use—NSLDS interprets the presence of a default value in different ways, depending on the field with which it is associated. There are three possibilities: the default means the event has never occurred, it occurred in the past, or the event is not currently occurring. The specific usage associated with each data element is described in this field.
Reporting—Identifies when information should be reported (e.g., when event occurs, during regular cycle).
Edit Level—Identifies whether a data element is edited during Extract Validation (file-level or domain-level edits) or Load Validation (domain-, record-, and load-level edits).
Verifies—Explains what the verification process checks, with respect to the value contained in that field.
Error—Explains what errors would cause NSLDS to reject the update and return a message in the Load Level Error report.
Error Number—The Message Code number for the associated error.
Exit State Message (For Header Records only)—Assigned code number and associated text description of error. This description is for mainframe users only.
Error Message (For Detail Records only)—Text description of error.
Date Revised—Date when information associated with this data element was last revised. (Replacement pages are issued as the system is modified.)
The following indexes list the data elements (or ‘fields’) described in this Data Dictionary in three different ways:
Index 1: Header Index (Sorted by Position)—Lists all the data elements in the order in which they appear in the document, which mirrors the position that the data occupies in the extract file.
Index 2: Detail Index (Sorted by Position)—Lists all the data elements in the order in which they appear in the document, which mirrors the position that the data occupies in the extract file.
Index 3: Detail Index (Sorted by Field Code Number)—Lists all the data elements according to their Field Code number. The Field Code number is a unique number that NSLDS has assigned to each field.
Index 4: Detail Index (Sorted Alphabetically by Field Name)—Lists all the data elements alphabetically by Field Name.
Index 5: Trailer Index (Sorted by Position)—Lists all the data elements in the order in which they appear in the document, which mirrors the position that the data occupies in the extract file.
Use the index that best meets your needs.
|
||||
Field |
Field Name |
Position |
Record Type |
|
|
Start |
End |
|
|
001 |
Code for Guaranty Agency |
1 |
3 |
Header |
002 |
Sort Social Security Number |
4 |
12 |
Header |
003 |
Data Provider Indicator |
13 |
13 |
Header |
004 |
Submittal (Extract) Date |
14 |
21 |
Header |
007 |
Initial Load Date |
22 |
29 |
Header |
005 |
Software Version |
30 |
34 |
Header |
008 |
Submittal Receive Date |
35 |
42 |
Header |
006 |
Error File Level Indicator |
43 |
43 |
Header |
009 |
Submittal Error Rate |
44 |
48 |
Header |
N/A |
Filler |
49 |
60 |
Header |
010 |
Record Type |
61 |
61 |
Header |
011 |
Label |
62 |
111 |
Header |
N/A |
Filler |
112 |
640 |
Header |
|
||||
Field |
Field Name |
Position |
Record Type |
|
|
Start |
End |
|
|
020 |
Code for Guaranty Agency |
1 |
3 |
Detail |
021 |
Student’s Social Security Number |
4 |
12 |
Detail |
022 |
Date of Student’s Birth |
13 |
20 |
Detail |
023 |
Student’s First Name |
21 |
32 |
Detail |
024 |
Type of Loan |
33 |
34 |
Detail |
025 |
Date of Guaranty |
35 |
42 |
Detail |
026 |
Indicator of Separate Loan |
43 |
43 |
Detail |
027 |
Code for Original School |
44 |
51 |
Detail |
028 |
PLUS Borrower’s Social Security Number |
52 |
60 |
Detail |
029 |
Record Type Indicator |
61 |
61 |
Detail |
030 |
Action Code |
62 |
62 |
Detail |
041 |
New Student’s Social Security Number |
63 |
71 |
Detail |
042 |
New Date of Student’s Birth |
72 |
79 |
Detail |
043 |
New Student’s First Name |
80 |
91 |
Detail |
044 |
New Type of Loan |
92 |
93 |
Detail |
045 |
New Date of Guaranty |
94 |
101 |
Detail |
046 |
New Indicator of Separate Loan |
102 |
102 |
Detail |
047 |
New Code for Original School |
103 |
110 |
Detail |
048 |
New PLUS Borrower’s Social Security Number |
111 |
119 |
Detail |
060 |
Date Entered Repayment (Date of Maturity) |
120 |
127 |
Detail |
061 |
Amount of Guaranty |
128 |
133 |
Detail |
062 |
Date of Loan Status |
134 |
141 |
Detail |
063 |
Code for Loan Status |
142 |
143 |
Detail |
064 |
Date of Cancellation |
144 |
151 |
Detail |
065 |
Amount of Cancellation |
152 |
157 |
Detail |
066 |
Date of Disbursement |
158 |
165 |
Detail |
067 |
Amount of Disbursement |
166 |
171 |
Detail |
068 |
Filler |
172 |
179 |
Detail |
069 |
Filler |
180 |
180 |
Detail |
070 |
PLUS Borrower’s Social Security Number Ind. |
181 |
181 |
Detail |
071 |
PLUS Borrower’s First Name |
182 |
193 |
Detail |
072 |
PLUS Borrower’s Last Name |
194 |
228 |
Detail |
073 |
Date of PLUS Borrower’s Birth |
229 |
236 |
Detail |
074 |
Student’s Social Security Number Indicator |
237 |
237 |
Detail |
075 |
Student’s Academic Level |
238 |
238 |
Detail |
076 |
Student’s Last Name |
239 |
273 |
Detail |
077 |
Date Enrollment Period Begins |
274 |
281 |
Detail |
078 |
Date Enrollment Period Ends |
282 |
289 |
Detail |
079 |
Student’s Middle Initial |
290 |
290 |
Detail |
080 |
Student’s Driver’s License Number |
291 |
320 |
Detail |
081 |
Student’s Driver’s License State |
321 |
322 |
Detail |
086 |
PLUS Borrower’s Middle Initial |
323 |
323 |
Detail |
087 |
PLUS Borrower’s State of Residence |
324 |
325 |
Detail |
088 |
Code for Servicer |
326 |
331 |
Detail |
089 |
Code for Originating FFELP Lender |
332 |
337 |
Detail |
090 |
Date Guaranty Transferred |
338 |
345 |
Detail |
091 |
Type of Deferment |
346 |
347 |
Detail |
092 |
Date Deferment Starts |
348 |
355 |
Detail |
093 |
Date Deferment Stops |
356 |
363 |
Detail |
095 |
Indicator of Lender-of-Last-Resort Lender |
364 |
364 |
Detail |
096 |
Claim Reason for Guaranty Agency Claim |
365 |
366 |
Detail |
099 |
Date of Refund on Claims |
367 |
374 |
Detail |
100 |
Amount of Refund on Claims |
375 |
380 |
Detail |
101 |
Date of Refund to Lender from school |
381 |
388 |
Detail |
103 |
Amount of Refund From School to Lender |
389 |
394 |
Detail |
105 |
Claim Reason for Lender Claim |
395 |
396 |
Detail |
106 |
Date Claim Paid |
397 |
404 |
Detail |
107 |
Amount of Claim Paid to Lender |
405 |
410 |
Detail |
108 |
Amount of Outstanding GA fees Balance(formerly Amount of Ending Balance on Claim of Other Fees |
411 |
416 |
Detail |
114 |
Date Reinsurance Claim Requested |
417 |
424 |
Detail |
115 |
Date Reinsurance Claim Paid |
425 |
432 |
Detail |
116 |
Amount of Reinsurance Claim Requested |
433 |
438 |
Detail |
117 |
Date Supplemental Claim Requested |
439 |
446 |
Detail |
118 |
Amount of Supplemental Claim Requested |
447 |
452 |
Detail |
119 |
Reinsurance Reimbursement Rate |
453 |
453 |
Detail |
120 |
Date Repurchased |
454 |
461 |
Detail |
121 |
Amount Repurchased |
462 |
467 |
Detail |
122 |
Indicator of Rehabilitated Loan |
468 |
468 |
Detail |
123 |
Date of Guaranty Agency Principal / Interest Collections |
469 |
476 |
Detail |
124 |
Amount of Guaranty Agency Interest Collections |
477 |
482 |
Detail |
126 |
Amount of Guaranty Agency Principal Collections |
483 |
488 |
Detail |
127 |
Date of TOP Principal / Interest Collections |
489 |
496 |
Detail |
128 |
Amount of TOP Interest Collections |
497 |
502 |
Detail |
130 |
Amount of TOP Principal Collections |
503 |
508 |
Detail |
131 |
Date Enrollment Status Effective |
509 |
516 |
Detail |
132 |
Code for Enrollment Status |
517 |
517 |
Detail |
133 |
Date of Anticipated Completion |
518 |
525 |
Detail |
134 |
Code for Current Holder Lender |
526 |
531 |
Detail |
135 |
Date of Outstanding Principal Balance |
532 |
539 |
Detail |
136 |
Amount of Outstanding Principal Balance |
540 |
545 |
Detail |
137 |
Date of Outstanding Accrued Interest Balance |
546 |
553 |
Detail |
138 |
Amount of Outstanding Accrued Interest Balance |
554 |
559 |
Detail |
141 |
Date Loan Sold |
560 |
567 |
Detail |
142 |
Indicator of Origination Fee Payer |
568 |
568 |
Detail |
143 |
Interest Rate |
569 |
573 |
Detail |
144 |
Type of Interest Rate |
574 |
574 |
Detail |
145 |
Date of Guaranty Agency Bankruptcy Claim Refunds |
575 |
582 |
Detail |
146 |
Amount of Guaranty Agency Bankruptcy Claim Refunds |
583 |
588 |
Detail |
147 |
Filler |
589 |
596 |
Detail |
148 |
Filler |
597 |
602 |
Detail |
149 |
Indicator of Subsidy |
603 |
603 |
Detail |
150 |
Date of Servicer Responsibility |
604 |
611 |
Detail |
102 |
Code for Current School |
612 |
619 |
Detail |
193 |
Data Provider Identifier |
620 |
640 |
Detail |
|
||||
Field |
Field Name |
Position |
Record Type |
|
|
Start |
End |
|
|
020 |
Code for Guaranty Agency |
1 |
3 |
Detail |
021 |
Student’s Social Security Number |
4 |
12 |
Detail |
022 |
Date of Student’s Birth |
13 |
20 |
Detail |
023 |
Student’s First Name |
21 |
32 |
Detail |
024 |
Type of Loan |
33 |
34 |
Detail |
025 |
Date of Guaranty |
35 |
42 |
Detail |
026 |
Indicator of Separate Loan |
43 |
43 |
Detail |
027 |
Code for Original School |
44 |
51 |
Detail |
028 |
PLUS Borrower’s Social Security Number |
52 |
60 |
Detail |
029 |
Record Type Indicator |
61 |
61 |
Detail |
030 |
Action Code |
62 |
62 |
Detail |
041 |
New Student’s Social Security Number |
63 |
71 |
Detail |
042 |
New Date of Student’s Birth |
72 |
79 |
Detail |
043 |
New Student’s First Name |
80 |
91 |
Detail |
044 |
New Type of Loan |
92 |
93 |
Detail |
045 |
New Date of Guaranty |
94 |
101 |
Detail |
046 |
New Indicator of Separate Loan |
102 |
102 |
Detail |
047 |
New Code for Original School |
103 |
110 |
Detail |
048 |
New PLUS Borrower’s Social Security Number |
111 |
119 |
Detail |
060 |
Date Entered Repayment (Date of Maturity) |
120 |
127 |
Detail |
061 |
Amount of Guaranty |
128 |
133 |
Detail |
062 |
Date of Loan Status |
134 |
141 |
Detail |
063 |
Code for Loan Status |
142 |
143 |
Detail |
064 |
Date of Cancellation |
144 |
151 |
Detail |
065 |
Amount of Cancellation |
152 |
157 |
Detail |
066 |
Date of Disbursement |
158 |
165 |
Detail |
067 |
Amount of Disbursement |
166 |
171 |
Detail |
068 |
Filler |
172 |
179 |
Detail |
069 |
Filler |
180 |
180 |
Detail |
070 |
PLUS Borrower’s Social Security Number Indicator |
181 |
181 |
Detail |
071 |
PLUS Borrower’s First Name |
182 |
193 |
Detail |
072 |
PLUS Borrower’s Last Name |
194 |
228 |
Detail |
073 |
Date of PLUS Borrower’s Birth |
229 |
236 |
Detail |
074 |
Student’s Social Security Number Indicator |
237 |
237 |
Detail |
075 |
Student’s Academic Level |
238 |
238 |
Detail |
076 |
Student’s Last Name |
239 |
273 |
Detail |
077 |
Date Enrollment Period Begins |
274 |
281 |
Detail |
078 |
Date Enrollment Period Ends |
282 |
289 |
Detail |
079 |
Student’s Middle Initial |
290 |
290 |
Detail |
080 |
Student’s Driver’s License Number |
291 |
320 |
Detail |
081 |
Student’s Driver’s License State |
321 |
322 |
Detail |
086 |
PLUS Borrower’s Middle Initial |
323 |
323 |
Detail |
087 |
PLUS Borrower’s State of Residence |
324 |
325 |
Detail |
088 |
Code for Servicer |
326 |
331 |
Detail |
089 |
Code for Originating FFELP Lender |
332 |
337 |
Detail |
090 |
Date Guaranty Transferred |
338 |
345 |
Detail |
091 |
Type of Deferment |
346 |
347 |
Detail |
092 |
Date Deferment Starts |
348 |
355 |
Detail |
093 |
Date Deferment Stops |
356 |
363 |
Detail |
095 |
Indicator of Lender-of-Last-Resort Lender |
364 |
364 |
Detail |
096 |
Claim Reason for Guaranty Agency Claim |
365 |
366 |
Detail |
099 |
Date of Refund on Claims (formerly Date of Refund From Lender on Claims) |
367 |
374 |
Detail |
100 |
Amount of Refund on Claims (formerly Amount of Refund From Lender on Claims) |
375 |
380 |
Detail |
101 |
Date of Refund to Lender |
381 |
388 |
Detail |
102 |
Code for Current School |
612 |
619 |
Detail |
103 |
Amount of Refund From School to Lender |
389 |
394 |
Detail |
105 |
Claim Reason for Lender Claim |
395 |
396 |
Detail |
106 |
Date Claim Paid |
397 |
404 |
Detail |
107 |
Amount of Claim Paid to Lender |
405 |
410 |
Detail |
108 |
Amount of Outstanding GA fees Balance (formerly Amount of Ending Balance on Claim of Other Fees) |
411 |
416 |
Detail |
114 |
Date Reinsurance Claim Requested |
417 |
424 |
Detail |
115 |
Date Reinsurance Claim Paid |
425 |
432 |
Detail |
116 |
Amount of Reinsurance Claim Requested |
433 |
438 |
Detail |
117 |
Date Supplemental Claim Requested |
439 |
446 |
Detail |
118 |
Amount of Supplemental Claim Requested |
447 |
452 |
Detail |
119 |
Reinsurance Reimbursement Rate |
453 |
453 |
Detail |
120 |
Date Repurchased |
454 |
461 |
Detail |
121 |
Amount Repurchased |
462 |
467 |
Detail |
122 |
Indicator of Rehabilitated Loan |
468 |
468 |
Detail |
123 |
Date of Guaranty Agency Principal / Interest Collections |
469 |
476 |
Detail |
124 |
Amount of Guaranty Agency Interest Collections |
477 |
482 |
Detail |
126 |
Amount of Guaranty Agency Principal Collections |
483 |
488 |
Detail |
127 |
Date of TOP Principal / Interest Collections |
489 |
496 |
Detail |
128 |
Amount of TOP Interest Collections |
497 |
502 |
Detail |
130 |
Amount of TOP Principal Collections |
503 |
508 |
Detail |
131 |
Date Enrollment Status Effective |
509 |
516 |
Detail |
132 |
Code for Enrollment Status |
517 |
517 |
Detail |
133 |
Date of Anticipated Completion |
518 |
525 |
Detail |
134 |
Code for Current Holder Lender |
526 |
531 |
Detail |
135 |
Date of Outstanding Principal Balance |
532 |
539 |
Detail |
136 |
Amount of Outstanding Principal Balance |
540 |
545 |
Detail |
137 |
Date of Outstanding Accrued Interest Balance |
546 |
553 |
Detail |
138 |
Amount of Outstanding Accrued Interest Balance |
554 |
559 |
Detail |
141 |
Date Loan Sold |
560 |
567 |
Detail |
142 |
Indicator of Origination Fee Payer |
568 |
568 |
Detail |
143 |
Interest Rate |
569 |
573 |
Detail |
144 |
Type of Interest Rate |
574 |
574 |
Detail |
145 |
Date of Guaranty Agency Bankruptcy Claim Refunds |
575 |
582 |
Detail |
146 |
Amount of Guaranty Agency Bankruptcy Claim Refunds |
583 |
588 |
Detail |
147 |
Filler |
589 |
596 |
Detail |
148 |
Filler |
597 |
602 |
Detail |
149 |
Indicator of Subsidy |
603 |
603 |
Detail |
150 |
Date of Servicer Responsibility |
604 |
611 |
Detail |
193 |
Data Provider Identifier |
620 |
640 |
Detail |
|
||||
Field |
Field Name |
Position |
Record Type |
|
|
Start |
End |
|
|
030 |
Action Code |
62 |
62 |
Detail |
065 |
Amount of Cancellation |
152 |
157 |
Detail |
107 |
Amount of Claim Paid to Lender |
405 |
410 |
Detail |
067 |
Amount of Disbursement |
166 |
171 |
Detail |
061 |
Amount of Guaranty |
128 |
133 |
Detail |
146 |
Amount of Guaranty Agency Bankruptcy Claim Refunds |
583 |
588 |
Detail |
124 |
Amount of Guaranty Agency Interest Collections |
477 |
482 |
Detail |
126 |
Amount of Guaranty Agency Principal Collections |
483 |
488 |
Detail |
138 |
Amount of Outstanding Accrued Interest Balance |
554 |
559 |
Detail |
108 |
Amount of Outstanding GA fees Balance (formerly Amount of Ending Balance on Claim of Other Fees) |
411 |
416 |
Detail |
136 |
Amount of Outstanding Principal Balance |
540 |
545 |
Detail |
103 |
Amount of Refund From School to Lender |
389 |
394 |
Detail |
100 |
Amount of Refund on Claims (formerly Amount of Refund From Lender on Claims) |
375 |
380 |
Detail |
116 |
Amount of Reinsurance Claim Requested |
433 |
438 |
Detail |
118 |
Amount of Supplemental Claim Requested |
447 |
452 |
Detail |
128 |
Amount of TOP Interest Collections |
497 |
502 |
Detail |
130 |
Amount of TOP Principal Collections |
503 |
508 |
Detail |
121 |
Amount Repurchased |
462 |
467 |
Detail |
096 |
Claim Reason for Guaranty Agency Claim |
365 |
366 |
Detail |
105 |
Claim Reason for Lender Claim |
395 |
396 |
Detail |
134 |
Code for Current Holder Lender |
526 |
531 |
Detail |
102 |
Code for Current School |
612 |
619 |
Detail |
132 |
Code for Enrollment Status |
517 |
517 |
Detail |
020 |
Code for Guaranty Agency |
1 |
3 |
Detail |
063 |
Code for Loan Status |
142 |
143 |
Detail |
027 |
Code for Original School |
44 |
51 |
Detail |
089 |
Code for Originating FFELP Lender |
332 |
337 |
Detail |
088 |
Code for Servicer |
326 |
331 |
Detail |
193 |
Data Provider Identifier |
620 |
640 |
Detail |
106 |
Date Claim Paid |
397 |
404 |
Detail |
092 |
Date Deferment Starts |
348 |
355 |
Detail |
093 |
Date Deferment Stops |
356 |
363 |
Detail |
077 |
Date Enrollment Period Begins |
274 |
281 |
Detail |
078 |
Date Enrollment Period Ends |
282 |
289 |
Detail |
131 |
Date Enrollment Status Effective |
509 |
516 |
Detail |
060 |
Date Entered Repayment (Date of Maturity) |
120 |
127 |
Detail |
090 |
Date Guaranty Transferred |
338 |
345 |
Detail |
141 |
Date Loan Sold |
560 |
567 |
Detail |
133 |
Date of Anticipated Completion |
518 |
525 |
Detail |
064 |
Date of Cancellation |
144 |
151 |
Detail |
066 |
Date of Disbursement |
158 |
165 |
Detail |
025 |
Date of Guaranty |
35 |
42 |
Detail |
145 |
Date of Guaranty Agency Bankruptcy Claim Refunds |
575 |
582 |
Detail |
123 |
Date of Guaranty Agency Principal / Interest Collections |
469 |
476 |
Detail |
062 |
Date of Loan Status |
134 |
141 |
Detail |
137 |
Date of Outstanding Accrued Interest Balance |
546 |
553 |
Detail |
135 |
Date of Outstanding Principal Balance |
532 |
539 |
Detail |
073 |
Date of PLUS Borrower’s Birth |
229 |
236 |
Detail |
099 |
Date of Refund on Claims (formerly Date of Refund From Lender on Claims) |
367 |
374 |
Detail |
101 |
Date of Refund to Lender |
381 |
388 |
Detail |
150 |
Date of Servicer Responsibility |
604 |
611 |
Detail |
022 |
Date of Student’s Birth |
13 |
20 |
Detail |
127 |
Date of TOP Principal / Interest Collections |
489 |
496 |
Detail |
127 |
Date of TOP Principal / Interest Collections |
489 |
496 |
Detail |
115 |
Date Reinsurance Claim Paid |
425 |
432 |
Detail |
114 |
Date Reinsurance Claim Requested |
417 |
424 |
Detail |
120 |
Date Repurchased |
454 |
461 |
Detail |
117 |
Date Supplemental Claim Requested |
439 |
446 |
Detail |
148 |
Filler |
597 |
602 |
Detail |
068 |
Filler |
172 |
179 |
Detail |
147 |
Filler |
589 |
596 |
Detail |
069 |
Filler |
180 |
180 |
Detail |
068 |
Filler |
172 |
179 |
Detail |
069 |
Filler |
180 |
180 |
Detail |
095 |
Indicator of Lender-Of-Last-Resort Lender |
364 |
364 |
Detail |
142 |
Indicator of Origination Fee Payer |
568 |
568 |
Detail |
122 |
Indicator of Rehabilitated Loan |
468 |
468 |
Detail |
026 |
Indicator of Separate Loan |
43 |
43 |
Detail |
149 |
Indicator of Subsidy |
603 |
603 |
Detail |
143 |
Interest Rate |
569 |
573 |
Detail |
047 |
New Code for Original School |
103 |
110 |
Detail |
045 |
New Date of Guaranty |
94 |
101 |
Detail |
042 |
New Date of Student’s Birth |
72 |
79 |
Detail |
046 |
New Indicator of Separate Loan |
102 |
102 |
Detail |
048 |
New PLUS Borrower’s Social Security Number |
111 |
119 |
Detail |
043 |
New Student’s First Name |
80 |
91 |
Detail |
041 |
New Student’s Social Security Number |
63 |
71 |
Detail |
044 |
New Type of Loan |
92 |
93 |
Detail |
071 |
PLUS Borrower’s First Name |
182 |
193 |
Detail |
072 |
PLUS Borrower’s Last Name |
194 |
228 |
Detail |
086 |
PLUS Borrower’s Middle Initial |
323 |
323 |
Detail |
028 |
PLUS Borrower’s Social Security Number |
52 |
60 |
Detail |
070 |
PLUS Borrower’s Social Security Number Indicator |
181 |
181 |
Detail |
087 |
PLUS Borrower’s State of Residence |
324 |
325 |
Detail |
029 |
Record Type Indicator |
61 |
61 |
Detail |
119 |
Reinsurance Reimbursement Rate |
453 |
453 |
Detail |
075 |
Student’s Academic Level |
238 |
238 |
Detail |
080 |
Student’s Driver’s License Number |
291 |
320 |
Detail |
081 |
Student’s Driver’s License State |
321 |
322 |
Detail |
023 |
Student’s First Name |
21 |
32 |
Detail |
076 |
Student’s Last Name |
239 |
273 |
Detail |
079 |
Student’s Middle Initial |
290 |
290 |
Detail |
021 |
Student’s Social Security Number |
4 |
12 |
Detail |
074 |
Student’s Social Security Number Indicator |
237 |
237 |
Detail |
091 |
Type of Deferment |
346 |
347 |
Detail |
144 |
Type of Interest Rate |
574 |
574 |
Detail |
024 |
Type of Loan |
33 |
34 |
Detail |
|
||||
Field |
Field Name |
Position |
Record Type |
|
|
Start |
End |
|
|
250 |
Code for Guaranty Agency |
1 |
3 |
Trailer |
255 |
Sort Social Security Number |
4 |
12 |
Trailer |
251 |
Number of Records With Domain Errors |
13 |
21 |
Trailer |
N/A |
Filler |
22 |
30 |
Trailer |
253 |
Number of Records With Domain, Record and Load-Level Errors |
31 |
39 |
Trailer |
254 |
Total Detail Records Contained on Extract File |
40 |
48 |
Trailer |
256 |
Number of PPC Records in Extract File |
49 |
57 |
Trailer |
N/A |
Filler |
58 |
60 |
Trailer |
029 |
Record Type Indicator |
61 |
61 |
Trailer |
258 |
Number of Detail Records in Submittal File |
62 |
70 |
Trailer |
259 |
Number of PPC Records in Submittal File |
71 |
79 |
Trailer |
260 |
Number of Forced Records |
80 |
88 |
Trailer |
261 |
Number of PPC Delete Records |
89 |
97 |
Trailer |
262 |
Number of Add Records |
98 |
106 |
Trailer |
263 |
Number of Change Records |
107 |
115 |
Trailer |
264 |
Number of Open Loans |
116 |
124 |
Trailer |
265 |
Loan Total: Amount of Guaranty |
125 |
136 |
Trailer |
266 |
Loan Total: Amount of Disbursement |
137 |
148 |
Trailer |
267 |
Loan Total: Amount of Cancellation |
149 |
160 |
Trailer |
268 |
Loan Total: Amount of School Refund |
161 |
172 |
Trailer |
269 |
Loan Total: Amount of Outstanding Principal Balance |
173 |
184 |
Trailer |
270 |
Loan Total: Amount of Accrued Interest Balance |
185 |
196 |
Trailer |
271 |
Loan Total: Amount of Ending Balance on Claim of Other Fees |
197 |
208 |
Trailer |
272 |
Loan Total: Amount of Claim Paid to Lender |
209 |
220 |
Trailer |
273 |
Loan Total: Amount of Reinsurance Claim Requested |
221 |
232 |
Trailer |
274 |
Loan Total: Amount of Guaranty Agency Principal Collections |
233 |
244 |
Trailer |
275 |
Loan Total: Amount Repurchased |
245 |
256 |
Trailer |
N/A |
Filler |
257 |
640 |
Trailer |
The following three sections detail the Header, Detail, and Trailer Record layouts.
This section contains specific Header Record Layout details for each record.
Code for Guaranty Agency |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Numeric |
3 |
1-3 |
001 |
|||||
Description |
Identification code for Guaranty Agency. |
|||||||||||
Comments |
Must be a valid code from the Guaranty Agency Code Table (Appendix B– Table B-8). |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
File-Level Error |
Can’t be blank. |
Is blank. |
N/A |
GA CODE ON HEADER IS MISSING (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
File-Level Error |
Must be numeric. |
Isn’t numeric. |
N/A |
GA CODE ON HEADER IS INVALID (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
Date Revised |
5-26-2000 |
Sort Social Security Number |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
9 |
4-12 |
002 |
|||||
Description |
Positional sort field used for sorting the Header Record to the top of the file. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be blank. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
File-Level Error |
Is blank. |
Isn’t blank. |
N/A |
HEADER SORT SSN MUST EQUAL SPACES (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
Date Revised |
5-26-2000 |
Data Provider Indicator |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
13 |
003 |
|||||
Description |
Indicator identifying the type of data provider submitting this file. |
|||||||||||
Comments |
Must be ‘G’ for guaranty agency. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with G. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
File-Level Error |
Can’t be blank. |
Is blank. |
N/A |
DATA PROVIDER INDICATOR IS SPACES (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
File-Level Error |
Must be ‘G’. |
Contains wrong value. |
N/A |
DATA PROVIDER INDICATOR ON HEADER IS INVALID (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
Date Revised |
5-26-2000 |
Submittal (Extract) Date |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Date |
8 |
14-21 |
004 |
|||||
Description |
Date when the Database Extract file was created. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Related fields that check value here
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
File-Level Error |
Can’t be blank. |
Is blank. |
N/A |
SUBMITTAL DATE IS REQUIRED (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
File-Level Error |
Must be a valid date. |
Invalid date. |
N/A |
SUBMITTAL DATE IS INVALID (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
Date Revised |
6-16-2003 |
Initial Load Date |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Date |
8 |
22-29 |
007 |
|||||
Description |
Date when Data Provider created extract for initial load. |
|||||||||||
Comments |
None. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
File-Level Error |
Can’t be blank. |
Is blank. |
N/A |
INITIAL LOAD DATE IS REQUIRED (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
File-Level Error |
Must be a valid date. |
Invalid date. |
N/A |
INITIAL LOAD DATE INVALID (For PC users, a message to the Extract Validation Log tells you that the process has stopped and the above message is displayed. For Z/OS LE users, the process aborts and a system message is generated.) |
||||||||
Date Revised |
5-26-2000 |
Software Version |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
5 |
30-34 |
005 |
|||||
Description |
Current version of the DataPrep software used to create the Submittal file. |
|||||||||||
Comments |
Populate with spaces on Database Extract file. The DataPrep software will populate this field with the version/release level. NSLDS uses this information to determine if the appropriate version/release level of the DataPrep software was used to create the Submittal file. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with spaces. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
Load-Level Error |
Latest DataPrep version/release is used to create Submittal file. |
Outdated DataPrep software used to create Submittal file. |
N/A |
NSLDS staff contacts the data provider to instruct, then install new software and resubmit. |
||||||||
Date Revised |
5-26-2000 |
Submittal Receive Date |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Date |
8 |
35-42 |
008 |
|||||
Description |
Date when submittal was received at NSLDS. |
|||||||||||
Comments |
Populate with default value (00000000) on Database Extract file. The DataPrep software will populate this field with the date the Submittal file is received by NSLDS. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with 00000000. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Error File Level Indicator |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
43 |
012 |
|||||
Description |
Indicator to show type of error file. |
|||||||||||
Comments |
Populate with default value of spaces on Database Extract file. The DataPrep software will leave this field blank on the Extract Error file and Submittal file. The field will be populated by the Load Process with a “3” on the Load Process Error File. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with spaces. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Submittal Error Rate |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Numeric |
5 |
44-48 |
009 |
|||||
Description |
Submittal Error rate for current submittal. |
|||||||||||
Comments |
Populate with default value of 00000 on Database Extract file. The DataPrep software will populate this field with the Submittal Error Rate. The rate is computed by taking the number of records with errors divided by the number of records in the Database Extract file. It does not include records with errors from prior submittals unless those same records have errors in the current submittal. The field includes an implied decimal point after the second digit (e.g., 12345 means 12.345%). |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with spaces. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Filler |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
12 |
49-60 |
N/A |
|||||
Description |
Blank field. |
|||||||||||
Comments |
None. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with spaces. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Record Type |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
61 |
010 |
|||||
Description |
Identifies the Header Record of the file. |
|||||||||||
Comments |
Set to H for Header Record. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with an H. (Note: If data provider leaves field blank, DataPrep will set to H.) |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Label |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
50 |
62-111 |
011 |
|||||
Description |
Name of file. |
|||||||||||
Comments |
Populate with spaces in Database Extract file. NSLDS will populate with a descriptive name of the file. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with spaces. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Filler |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
529 |
112-640 |
N/A |
|||||
Description |
Blank field to complete record length. |
|||||||||||
Comments |
None. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Must always be filled with spaces. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Exit State Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
This section contains specific Detail Record Layout details for each record.
Code for Guaranty Agency |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Numeric |
3 |
1-3 |
020 |
|||||
Description |
Identification code for Guaranty Agency guaranteeing an FFELP loan. |
|||||||||||
Comments |
Must be a valid code from the Guaranty Agency Code Table (Appendix B– Table B-8). |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be numeric. |
Not numeric. |
0177 |
Invalid Code for Guaranty Agency |
||||||||
Record-Level Error |
Must be reported. |
Contains zeroes. |
0127 |
Code for GA is required |
||||||||
Record-Level Error |
Must be same as Guaranty Agency code in Header record. |
Guaranty Agency code in Header record differs. |
0249 |
Header GA code and Detail GA code must be equal |
||||||||
Load-Level Error |
Must be valid code from Guaranty Agency Code table. |
Invalid Guaranty Agency Code. |
0177 |
Invalid Code for Guaranty Agency |
||||||||
Load-Level Error |
GA is not allowed to report loans that have been assigned to or purchased by ED. |
Agency reports on loans assigned to or purchased by ED. |
0177 |
Invalid Code for Guaranty Agency (This error commonly occurs when a loan is returned to a GA but DCS(555) has not updated the loan. Message is suppressed when 927(ECMC) or 555(DCS) is the current holders of the loan. This error also commonly occurs when a GA reports on a loan, without reporting a transfer that has already been reported by GA577.) |
||||||||
Load-Level Error |
GA577 has already accepted this loan. |
Reporting GA reported transfer of loan after GA577 accepted the loan. |
0737 |
Loan has been accepted by 577 |
||||||||
Date Revised |
11-22-2009 |
Student’s Social Security Number |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes |
Yes |
No |
No |
Character |
9 |
4-12 |
021 |
|||||
Description |
Title IV aid recipient or beneficiary’s Social Security Number. |
|||||||||||
Comments |
1. First Name and Date of Birth (DOB) matches. First Name
Date of Birth
Note: When NSLDS performs the analysis on the three of first four characters in first name or five of first seven characters in last name, the letters must match in the same sequence. For example, Nary and Mary would match, as “ary” is in same sequential order. So would Maty and Mary, as “may” is in the same sequential order. 2. Transposed first name and last name with DOB match. Last Name
Date of Birth
3. Match on first initial of first name when NSLDS’ first name is only an initial and no other first names exist in NSLDS. First Name
Date of Birth
4. Match on first initial and part of last name with DOB match. First Name
Last Name
Date of Birth
Note: When NSLDS performs the analysis on the three of first four characters in first name or five of first seven characters in last name, the letters must match in the same sequence. For example, Nary and Mary would match, as “ary” is in same sequential order. So would Maty and Mary, as “may” is in the same sequential order. 5. Match on student SSN and a single loan is found using the non-student related identifiers. This loan was last reported on by the current provider.
|
|||||||||||
Part of Event Type |
Loan Identifier / Student Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
If SSN Indicator is ‘R’ (i.e., SSN is Real), this field must be numeric. |
Isn’t numeric. |
0235 |
Invalid Student SSN |
||||||||
Record-Level Error |
Must be reported. |
Is blank or zeroes. |
0258 |
Student SSN is required |
||||||||
Load-Level Error |
NSLDS determines whether NSLDS database already has a different student associated with that SSN. (See comments.) |
Conflicting first name or date of birth information exists. |
0408 |
Student SSN currently used by another Student |
||||||||
Date Revised |
3-13-2006 |
Date of Student’s Birth |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes |
No |
No |
No |
Date |
8 |
13-20 |
022 |
|||||
Description |
Date when a Title IV aid recipient or beneficiary was born. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Student Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date. |
Invalid date. |
0233 |
Invalid Student Date of Birth |
||||||||
Domain-Level Error |
Must be reported. |
Is zeroes. |
0264 |
Student Date of Birth is required |
||||||||
Record-Level Error |
Plug date is not allowed if Date of Guaranty is later than Initial Load Date. |
Plug date was used for loan that had a Date of Guaranty that was later than the Initial Load Date. |
0102 |
19000101 is invalid if Date of Guaranty is greater than Init Load Date |
||||||||
Record-Level Error |
CCYY of Student’s Birth must be earlier than CCYY of Submittal Receive Data on Header Record. Note: Only checked if Date of Guaranty is invalid. |
CCYY is same or later. |
0131 |
Date of Student’s Birth must be less than Submittal Date |
||||||||
Record-Level Error |
Date of Student’s Birth must be on or after the Date of Guaranty less 99 years. |
Date of Student’s Birth is before the Date of Guaranty less 99 years. |
0558 |
Date must be = or greater than Date of Guaranty – 99 years |
||||||||
Record-Level Error |
Date of Student’s Birth must be on or before the Date of Guaranty less 12 years. |
Date of Student’s Birth is after the Date of Guaranty less 12 years. |
0559 |
Date must be = or less than Date of Guaranty – 12 years |
||||||||
Date Revised |
5-26-2000 |
Student’s First Name |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes |
Yes |
No |
No |
Character |
12 |
21-32 |
023 |
|||||
Description |
Title IV aid recipient or beneficiary’s first name. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Student Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be left-justified. |
Isn’t left-justified. |
0166 |
Field must be left-justified |
||||||||
Domain-Level Error |
Must be reported. |
Is blank. |
0260 |
Student First Name is required |
||||||||
Date Revised |
5-26-2000 |
Type of Loan |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
Yes |
No |
Yes |
No |
Character |
2 |
33-34 |
024 |
||||
Description |
Code indicating type of aid received or guaranteed. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Identifier |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be reported. |
Is blank. |
0111 |
Type of Loan is required |
|||||||
Record-Level Error |
Must be a valid code from the Loan Type Code Table. |
Invalid code. |
0238 |
Invalid Type of Loan |
|||||||
Date Revised |
6-16-2003 |
Date of Guaranty |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
Yes |
No |
Yes |
No |
Date |
8 |
35-42 |
025 |
||||
Description |
Date when an FFELP loan was originally guaranteed. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Identifier |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be reported. |
Contains zeroes. |
0153 |
Date of Guaranty is required |
|||||||
Domain-Level Error |
Must be a valid date. |
Invalid date. |
0194 |
Invalid Date of Guaranty |
|||||||
Record-Level Error |
For CL loans, date must be on or after the program start date (19860407). |
Date of Guaranty is earlier than program start date. |
0550 |
Date for CL loan must be = or greater than 19860407 |
|||||||
Record-Level Error |
For PL loans, date must be on or after the program start date (19810101). |
Date of Guaranty is earlier than program start date. |
0551 |
Date for PL loan must be = or greater than 19810101 |
|||||||
Record-Level Error |
For RF loans, date must be on or after the program start date (19861017). |
Date of Guaranty is earlier than program start date. |
0552 |
Date for RF loan must be = or greater than 19861017 |
|||||||
Record-Level Error |
For SF loans, date must be on or after the program start date (19651108). |
Date of Guaranty is earlier than program start date. |
0553 |
Date for SF loan must be = or greater than 19651108 |
|||||||
Record-Level Error |
For SL loans, date must be on or after the program start date (19810101). |
Date of Guaranty is earlier than program start date. |
0554 |
Date for SL loan must be = or greater than 19810101 |
|||||||
Record-Level Error |
For SU loans, date must be on or after the program start date (19921001). |
Date of Guaranty is earlier than program start date. |
0555 |
Date for SU loan must be = or greater than 19921001 |
|||||||
Record-Level Error |
For all loan types, date must be on or before the Submittal (Extract) Date. |
Date of Guaranty is after the Submittal (Extract) Date. |
0556 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
For SL loans, date must be on or before 19960630. |
Date of Guaranty is after 19960630. |
0557 |
Date for SL loans must be = or less than 19960630 |
|||||||
Record-Level Error |
Each loan record on Database Extract file must have unique loan identifiers that are SSN, Type of Loan, Date of Guaranty, Indicator of Separate Loan, Code for Original School, and PLUS Borrower’s SSN. |
Two or more loans have the same loan identifiers and appear to be duplicates. Note: All loans associated with this problem receive this error. |
0671 |
Identifiers must be unique on each detail record |
|||||||
Record-Level Error |
For UI Loan Status, date must be on or after the inception of the HEA (19651108). |
Date of Guaranty is earlier than inception of HEA. |
0711 |
For UI Loan Status, Date must be = or greater than 19651108 |
|||||||
Record-Level Error |
For loans transferred, date must be on or after the inception of the HEA (19651108). |
Date of Guaranty is earlier than inception of HEA. |
0712 |
For transferred loans, Date must be = or greater than 19651108 |
|||||||
Record-Level Error |
For GB loans, date must be on or after the program start date (20060701). |
Date of Guaranty is earlier than program start date. |
0734 |
Date for GB loans must be = or greater than 20060701 |
|||||||
Date Revised |
7-03-2006 |
Indicator of Separate Loan |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
Yes |
No |
No |
No |
Character |
1 |
43 |
026 |
||||
Description |
An indicator used to differentiate among multiple loans of the same type that have the same guaranty date for the same student attending the same school. |
||||||||||
Comments |
Underlying
Date of Loan Indicator
Total HEAL 3/15/98 CL A $25,000 Stafford sub 3/15/98 CL B 12,000 Stafford unsub 3/15/98 CL C 3,000 |
||||||||||
Part of Event Type |
Loan Identifier |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must contain a character between ‘A’ and ‘Z’. |
Contains wrong value. |
0396 |
Invalid Indicator of Separate Loan |
|||||||
Load-Level Error |
If two or more GAs report loans with identical identifiers and the same Indicator of Separate Loan, the Indicator has reached its maximum value. (This error is reported when the Indicator has reached its maximum value.) |
Duplicate loan exists, and Indicator has reached maximum value of ‘Z’. |
0259 |
Ind of Separate Loan has Reached Max Value for This Loan |
|||||||
Load-Level Error |
If two or more GAs report loans with identical identifiers and the same Indicator of Separate Loan, the second will produce an error. (This error is reported when the Indicator has not reached its maximum value.) |
Duplicate loan exists. |
0526 |
Dup Loan exists for another GA, increment Ind of Sep Loan. (This error is also generated when GA attempts to report transferred loan without Date of Guaranty Transferred.) |
|||||||
Date Revised |
6-16-2003 |
Code for Original School |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
Yes |
No |
No |
No |
Numeric |
8 |
44-51 |
027 |
||||
Description |
An eight-digit code, known as the OPE code, identifying the original school at which the student was enrolled or accepted for enrollment when the loan was made. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Identifier |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be reported. |
Contains zeroes. |
0128 |
Code for Original School is required |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0181 |
Invalid Code for Original School |
|||||||
Record-Level Error |
Must contain ‘88888800’ if Type of Loan is ‘CL’ (Consolidated). |
Contains wrong value. |
0181 |
Invalid Code for Original School |
|||||||
Record-Level Error |
Must contain ‘88888811’ if Type of Loan is ‘RF’ (Refinanced). |
Contains wrong value. |
0181 |
Invalid Code for Original School |
|||||||
Record-Level Error |
If Date of Guaranty is January 1, 1984 or later, ‘99999900’ is not valid. |
Contains wrong value. |
0237 |
Invalid value when Dt of GA > or = 19840101 |
|||||||
Load-Level Error |
Must be a valid OPE Code. |
Invalid code. |
0181 |
Invalid Code for Original School |
|||||||
Date Revised |
5-26-2000 |
PLUS Borrower’s Social Security Number |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes |
Yes |
No |
No |
Character |
9 |
52-60 |
028 |
|||||
Description |
PLUS Borrower’s Social Security Number. |
|||||||||||
Comments |
1. First Name and Date of Birth (DOB) matches. First Name
Date of Birth
Note: When NSLDS performs the analysis on the three of first four characters in first name or five of first seven characters in last name, the letters must match in the same sequence. For example, Nary and Mary would match, as “ary” is in same sequential order. So would Maty and Mary, as “may” is in the same sequential order. 2. Transposed first name and last name with DOB match. Last Name
Date of Birth
3. Match on first initial of first name when NSLDS’ first name is only an initial and no other first names exist in NSLDS. First Name
Date of Birth
4. Match on first initial and part of last name with DOB match. First Name
Last Name
Date of Birth
Note: When NSLDS performs the analysis on the three of first four characters in first name or five of first seven characters in last name, the letters must match in the same sequence. For example, Nary and Mary would match, as “ary” is in same sequential order. So would Maty and Mary, as “may” is in the same sequential order. 5. Match on student SSN, and a single loan or grant overpayment is found using the non-student related identifiers. This loan or grant overpayment was last reported on by the current provider.
|
|||||||||||
Part of Event Type |
Loan Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled for PLUS loans. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be numeric if PLUS Borrower’s Social Security Number Indicator is ‘R’. |
Isn’t numeric. |
0160 |
Invalid PLUS Borrower SSN |
||||||||
Record-Level Error |
Must be blank if Type of Loan is other than ‘PL’. |
Isn’t blank. |
0193 |
Field not required on this type of loan |
||||||||
Record-Level Error |
This field must be reported if Type of Loan is ‘PL’. |
Is blank. |
0250 |
PLUS Borrower SSN is required |
||||||||
Load-Level Error |
For loans already reported to NSLDS, the incoming PLUS Borrower SSN is associated to the loan identified. |
PLUS Borrower’s SSN does not match (See comments). |
0160 |
Invalid PLUS Borrower SSN |
||||||||
Load-Level Error |
Whether NSLDS database already has a different PLUS Borrower associated with that SSN. |
Conflicting first name or date of birth information exists. |
0409 |
PLUS Borrower SSN currently used by another borrower |
||||||||
Date Revised |
3-27-2007 |
Record Type Indicator |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
N/A |
No |
N/A |
Character |
1 |
61 |
029 |
|||||
Description |
Identifies type of record (i.e., Detail or Past Period Change). |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
None. |
|||||||||||
Default Value / Use |
Report a blank. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Record Type Indicator is a space or ‘Z’. |
Is not blank or ‘Z’. |
0252 |
Record Type Indicator must be Z or spaces |
||||||||
Record-Level Error |
Record Type Indicator is ‘N’ or ‘Z’ in valid records that are sent to NSLDS. |
Is not ‘N’ or ‘Z’. |
0339 |
Field must be ‘N’ or ‘Z’ in file received by NSLDS |
||||||||
Date Revised |
5-26-2000 |
Action Code |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
N/A |
No |
N/A |
Character |
1 |
62 |
030 |
|||||
Description |
Identifies action type. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
None. |
|||||||||||
Default Value / Use |
Report a blank if no special conditions apply. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be ‘A’, ‘C’, or ‘F’. |
Contains wrong value. |
0171 |
Invalid Action Code |
||||||||
Date Revised |
5-26-2000 |
New Student’s Social Security Number |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes (New) |
Yes |
No |
No |
Character |
9 |
63-71 |
041 |
|||||
Description |
Title IV aid recipient or beneficiary’s Social Security Number. |
|||||||||||
Comments |
1. First Name and Date of Birth (DOB) matches. First Name
Date of Birth
Note: When NSLDS performs the analysis on the three of first four characters in first name or five of first seven characters in last name, the letters must match in the same sequence. For example, Nary and Mary would match, as “ary” is in same sequential order. So would Maty and Mary, as “may” is in the same sequential order. 2. Transposed first name and last name with DOB match. Last Name
Date of Birth
3. Match on first initial of first name when NSLDS’ first name is only an initial and no other first names exist in NSLDS. First Name
Date of Birth
4. Match on first initial and part of last name with DOB match. First Name
Last Name
Date of Birth
Note: When NSLDS performs the analysis on the three of first four characters in first name or five of first seven characters in last name, the letters must match in the same sequence. For example, Nary and Mary would match, as “ary” is in same sequential order. So would Maty and Mary, as “may” is in the same sequential order. 5. Match on student SSN, and a single loan or grant overpayment is found using the non-student related identifiers. This loan or grant overpayment was last reported on by the current provider.
|
|||||||||||
Part of Event Type |
Loan Identifier / Student Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report blanks when Loan Identifier information has not changed. |
|||||||||||
Reporting |
Report actual value if change in Student’s Social Security Number occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
If Student’s SSN Indicator is ‘R’ (Real), this field must be numeric and not all zeroes. |
Isn’t numeric or is zeroes. |
0224 |
Invalid New Student SSN |
||||||||
Domain-Level Error |
Change value given when made to another Loan Identifier field. |
No value entered (whether new or existing). |
0246 |
New Student SSN is required |
||||||||
Load-Level Error |
Whether NSLDS database already has a different student associated with that SSN. (See comments.) |
Conflicting first name or date of birth information exists. |
0407 |
New Student SSN currently used by another student |
||||||||
Date Revised |
3-13-2006 |
New Date of Student’s Birth |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes (New) |
No |
No |
No |
Date |
8 |
72-79 |
042 |
|||||
Description |
Date when Title IV aid recipient or beneficiary was born. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Student Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report ‘00000000’ when Loan Identifier information has not changed. |
|||||||||||
Reporting |
Report actual value if change in Student’s Date of Birth occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0225 |
Invalid New Student Date of Birth |
||||||||
Domain-Level Error |
Change value given when made to another Loan Identifier field. |
No value entered here (whether new or existing). |
0244 |
New Student Date of Birth is required |
||||||||
Record-Level Error |
If Date of Guaranty is later than Date of Initial Load, ‘19000101’ cannot be reported. |
Invalid date. |
0102 |
19000101 is invalid when Date of Guaranty > Init Load Date |
||||||||
Record-Level Error |
CCYY of Student’s Birth must be earlier than CCYY of Submittal Receive Data on Header Record. Note: Only checked if Date of Guaranty is invalid. |
CCYY is same or later. |
0151 |
New Student Date of Birth must be less than Submittal Date |
||||||||
Record-Level Error |
New Date of Student’s Birth must be on or after New Date of Guaranty less 99 years. |
New Date of Student’s Birth is before New Date of Guaranty less 99 years. |
0568 |
Date must be = or greater than New Date of Guaranty - 99 years |
||||||||
Record-Level Error |
New Date of Student’s Birth must be on or before New Date of Guaranty less 12 years. |
New Date of Student’s Birth is after New Date of Guaranty less 12 years. |
0569 |
Date must be = or less than New Date of Guaranty - 12 years |
||||||||
Date Revised |
5-26-2000 |
New Student’s First Name |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes (New) |
Yes |
No |
No |
Character |
12 |
80-91 |
043 |
|||||
Description |
Title IV aid recipient or beneficiary’s first name. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Student Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report blanks when Loan Identifier information has not changed. |
|||||||||||
Reporting |
Report actual value if change in Student’s First Name occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be left-justified. |
Isn’t left-justified. |
0166 |
Field must be left-justified |
||||||||
Domain-Level Error |
Change value given when made to another Loan Identifier field. |
No value entered here (whether new or existing). |
0247 |
New Student First Name is required |
||||||||
Date Revised |
5-26-2000 |
New Type of Loan |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes (New) |
No |
Yes |
No |
Character |
2 |
92-93 |
044 |
|||||
Description |
Code indicating type of aid received or guaranteed. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Loan Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report blanks when Loan Identifier information has not changed. |
|||||||||||
Reporting |
Report actual value if change in loan type occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Change given when made to another Loan Identifier field. |
No value entered (whether new or existing). |
0248 |
New Type of Loan is required |
||||||||
Record-Level Error |
Must be a valid code from the Loan Type Code Table. |
Invalid code. |
0342 |
Invalid New Type of Loan |
||||||||
Date Revised |
6-16-2003 |
New Date of Guaranty |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes (New) |
No |
Yes |
No |
Date |
8 |
94-101 |
045 |
|||||
Description |
Date when an FFELP loan was originally guaranteed. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Loan Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report zeroes when Loan Identifier information has not changed. |
|||||||||||
Reporting |
Report actual value if change in date of guaranty occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0222 |
Invalid Date of New Guaranty |
||||||||
Domain-Level Error |
Value given when change made to another Loan Identifier field. |
New Date of Guaranty was not reported. |
0406 |
New Date of Guaranty is required |
||||||||
Record-Level Error |
For CL loans, the Date of Guaranty must be on or after the program start date (19860407). |
Date of Guaranty is earlier than the program start date. |
0560 |
Date for CL loan must be = or greater than 19860407 |
||||||||
Record-Level Error |
For PL loans, the Date of Guaranty must be on or after the program start date (19810101). |
Date of Guaranty is earlier than the program start date. |
0561 |
Date for PL loan must be = or greater than 19810101 |
||||||||
Record-Level Error |
For RF loans, the Date of Guaranty must be on or after the program start date (19861017). |
Date of Guaranty is earlier than the program start date. |
0562 |
Date for RF loan must be = or greater than 19861017 |
||||||||
Record-Level Error |
For SF loans, the Date of Guaranty must be on or after the program start date (19651108). |
Date of Guaranty is earlier than the program start date. |
0563 |
Date for SF loan must be = or greater than 19651108 |
||||||||
Record-Level Error |
For SL loans, the Date of Guaranty must be on or after the program start date (19810101). |
Date of Guaranty is earlier than the program start date. |
0564 |
Date for SL loan must be = or greater than 19810101 |
||||||||
Record-Level Error |
For SU loans, the Date of Guaranty must be on or after the program start date (19921001). |
Date of Guaranty is earlier than the program start date. |
0565 |
Date for SU loan must be = or greater than 19921001 |
||||||||
Record-Level Error |
For all loan types, the Date of Guaranty must be on or before the Submittal (Extract) Date. |
Date of Guaranty is after the Submittal (Extract) Date. |
0566 |
Date must be = or less than Submittal (Extract) Date |
||||||||
Record-Level Error |
For SL loans, the Date of Guaranty must be on or before 19960630. |
Date of Guaranty is after 19960630. |
0567 |
Date for SL loans must be = or less than 19960630 |
||||||||
Record-Level Error |
For UI Loan Status, the Date of Guaranty must be on or after the inception of the HEA (19651108). |
Date of Guaranty is earlier than the inception of the HEA. |
0713 |
For UI Loan Status, Date must be = or greater than 19651108 |
||||||||
Record-Level Error |
For loans transferred, the Date of Guaranty must be on or after the inception of the HEA (19651108). |
Date of Guaranty is earlier than the inception of the HEA. |
0714 |
For transferred loans, Date must be = or greater than 19651108 |
||||||||
Load-Level Error |
Determine whether ‘old’ and New Loan Identifiers both match existing loans. |
Both ‘old’ and New Loan Identifiers match existing loans. |
0253 |
Loan already exists, cannot change key |
||||||||
Record-Level Error |
For GB loans, date must be on or after the program start date (20060701). |
Date of Guaranty is earlier than program start date. |
0735 |
Date for GB loans must be = or greater than 20060701 |
||||||||
Date Revised |
7-03-2006 |
New Indicator of Separate Loan |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
Yes (New) |
No |
No |
No |
Character |
1 |
102 |
046 |
||||
Description |
An indicator used to differentiate among multiple loans of the same type that have the same loan date for the same borrower or student attending the same school. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Identifier |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report a blank when Loan Identifier information has not changed. |
||||||||||
Reporting |
Report actual value if change in indicator of separate loan occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Change value given when made to another Loan Identifier field. |
No value or invalid value entered here (whether new or existing). |
0243 |
New Indictr of Separate Loan must be valid letter |
|||||||
Date Revised |
5-26-2000 |
New Code for Original School |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
Yes (New) |
No |
No |
No |
Numeric |
8 |
103-110 |
047 |
|||||
Description |
An eight-digit code, known as the OPE code, identifying the original school at which the student was enrolled or accepted for enrollment when the loan was made. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Loan Identifier |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report ‘00000000’ when Loan Identifier information has not changed. |
|||||||||||
Reporting |
Report actual value if change in Code for Original School occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Value given when change was made to another Loan Identifier field. |
No value entered (whether new or existing). |
0245 |
New Code for Original School is required |
||||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0307 |
Invalid New Code for Original School |
||||||||
Record-Level Error |
If Date of Guaranty is Jan. 1, 1984 or later, (former plug value of) ‘99999900’ is invalid. |
Contains invalid plug date. |
0237 |
Invalid value when Dt of GA> or = 19840101 |
||||||||
Record-Level Error |
If New Type of Loan is ‘CL’ (Consolidated), must be ‘88888800’. |
Contains wrong value. |
0307 |
Invalid New Code for Original School |
||||||||
Record-Level Error |
If New Type of Loan is ‘RF’ (Refinanced), must be ‘88888811’. |
Contains wrong value. |
0307 |
Invalid New Code for Original School |
||||||||
Record-Level Error |
‘88888800’ only used on CL (Consolidated) loans. |
Contains wrong value. |
0307 |
Invalid New Code for Original School |
||||||||
Record-Level Error |
‘88888811’ only used on RF (Refinanced) loans. |
Contains wrong value. |
0307 |
Invalid New Code for Original School |
||||||||
Record-Level Error |
New Code for Original School cannot be ‘99999900’ if Code for Original School was not ‘99999900’. |
Contains wrong value. |
0527 |
Def value for this field cannot modify a real value |
||||||||
Load-Level Error |
Must be a valid OPE School Code (if not zeroes). |
Invalid code. |
0307 |
Invalid New Code for Original School |
||||||||
Date Revised |
5-26-2000 |
New PLUS Borrower’s Social Security Number |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
Yes (New) |
Yes |
No |
No |
Character |
9 |
111-119 |
048 |
||||
Description |
PLUS Borrower’s Social Security Number. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Identifier |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report blanks when Loan Identifier information has not changed. |
||||||||||
Reporting |
Report actual value if change in PLUS Borrower’s SSN occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
If PLUS Borrower’s Social Security Number Indicator is ‘R’ (Real), this field must be numeric. |
Isn’t numeric. |
0160 |
Invalid PLUS Borrower SSN |
|||||||
Record-Level Error |
Field must be blank if identifier fields haven’t changed, or if Type of Loan isn’t ‘PL’. |
Is filled. |
0193 |
Field not required on this type of loan |
|||||||
Record-Level Error |
Change value given when made to another Loan Identifier field and New Type of Loan is PL. |
No value entered here (whether new or existing). |
0473 |
New PLUS Borrower SSN is required |
|||||||
Load-Level Error |
Whether NSLDS database already has a different PLUS Borrower associated with that SSN. |
Conflicting first name or date of birth information exists. |
0410 |
New PLUS Borrower SSN currently used by another borrower |
|||||||
Date Revised |
4-05-2007 |
Date Entered Repayment (Date of Maturity) |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Date |
8 |
120-127 |
060 |
|||||
Description |
Date when loan entered repayment or is scheduled to enter repayment for cohort default rate purposes. |
|||||||||||
Comments |
Abbreviated DER. |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0199 |
Invalid Date Entered Repayment |
||||||||
Record-Level Error |
Must be reported. |
Contains zeroes. |
0301 |
Date Entered Repayment is required |
||||||||
Record-Level Error |
For earlier SF and SU loans (Date of Guaranty before 19950701), DER must be on or after the Date of Guaranty. |
DER is before the Date of Guaranty. |
0574 |
Date must be = or > Date of Guaranty for non-CL/RF loans |
||||||||
Record-Level Error |
For earlier PL loans (Date of Guaranty before 19960101), DER must be on or after the Date of Guaranty. |
DER is before the Date of Guaranty. |
0574 |
Date must be = or > Date of Guaranty for non-CL/RF loans |
||||||||
Record-Level Error |
For all SL loans, DER must be on or after the Date of Guaranty. |
DER is before the Date of Guaranty. |
0574 |
Date must be = or > Date of Guaranty for non-CL/RF loans |
||||||||
Record-Level Error |
For later SF and SU loans (Date of Guaranty on or after 19950701), DER must be on or after the Date of Disbursement, except when Date of Disbursement is after Date Enrollment Period ends (indicates late disbursement). |
DER is before the Date of Disbursement. |
0575 |
Based on Loan Type, Date must be = or > Date of Disbursement |
||||||||
Record-Level Error |
For later PL loans (Date of Guaranty on or after 19960101) and GB loans, DER must be on or after the Date of Disbursement, except when Date of Disbursement is after Date Enrollment Period ends (indicates late disbursement). |
DER is before the Date of Disbursement. |
0575 |
Based on Loan Type, Date must be = or > Date of Disbursement |
||||||||
Record-Level Error |
For all loans, DER must be on or before the Submittal (Extract) Date plus 15 years. |
DER is after the Submittal (Extract) Date plus 15 years. |
0576 |
Date must be = or less than Submittal Date + 15 years |
||||||||
Record-Level Error |
For all CL and RF loans, DER must be on or after the Date of Guaranty, less one year. |
DER is before the Date of Guaranty less one year. |
0709 |
For CL & RF loans, Date must be >= Date of Guaranty - 1 year |
||||||||
Date Revised |
04-05-2007 |
Amount of Guaranty |
||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||
No |
No |
Yes |
No |
Numeric |
6 |
128-133 |
061 |
|||
Description |
Original dollar amount, before any cancellations, of an FFELP loan guaranty. |
|||||||||
Comments |
Report whole dollars, no cents (e.g., report $2,500.25 as ‘002500’). |
|||||||||
Part of Event Type |
Not part of an event. |
|||||||||
Companion Field(s) |
formerly Amount of Ending Balance on Claim of Other Fees (108)
|
|||||||||
Default Value / Use |
Must always be filled. |
|||||||||
Reporting |
Report actual value in regular update. |
|||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0314 |
Invalid Amount of Guaranty |
||||||
Record-Level Error |
Amount of Guaranty must be at least one dollar. |
Amount of Guaranty is less than the minimum (one dollar). |
0109 |
Amount of Guaranty is required |
||||||
Record-Level Error |
For SF loans with Academic Level 1 – 5 guaranteed on or after October 1, 1994 and not transferred, the Amount of Guaranty less the Amount of Cancellation must not exceed $5,500. |
Amount of Guaranty exceeds the maximum ($5,500). |
0650 |
Amount for SF loan w/Acad Level 1 thru 5 must be = or < 5500 |
||||||
Record-Level Error |
For SU loans with Academic Level 1-5, the Amount of Guaranty must not exceed $27,167. |
Amount of Guaranty exceeds the maximum ($27,167). |
0651 |
Amount for SU loan w/Acad Level 1 thru 5 must be = or < 27167 |
||||||
Record-Level Error |
For SF loans with Academic Level A - N, the Amount of Guaranty must not exceed $8,500. |
Amount of Guaranty exceeds the maximum ($8,500). |
0669 |
Amount for SF loan w/Acad Level A thru N must be = or < 8500 |
||||||
Record-Level Error |
For SU loans with Academic Level A - N, the Amount of Guaranty must not exceed $47,167. |
Amount of Guaranty exceeds the maximum ($47,167). |
0670 |
Amount for SU loan w/Acad Level A thru G must be = or < 47167 |
||||||
Record-Level Error |
For SF and SU loans transferred, the Amount of Guaranty must not exceed $47,167, regardless of Academic Level. |
Amount of Guaranty exceeds the maximum ($47,167). |
0703 |
For SF & SU loans, Amount must be = or < 47167 |
||||||
Date Revised |
2-15-2007 |
Date of Loan Status |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Date |
8 |
134-141 |
062 |
||||
Description |
Date when the current Code for Loan Status became effective. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Status |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report actual value as new loan or change in loan status occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0198 |
Invalid Date of Loan Status |
|||||||
Record-Level Error |
Must be reported. |
Contains zeroes. |
0154 |
Date of Loan Status is required |
|||||||
Record-Level Error |
For IDLoan Status, the Date of Loan Status must be on or after the Date of Guaranty less 2 years. |
Date of Loan Status is before Date of Guaranty less 2 years. |
0577 |
For ID Loan Status, Date must be >= Date of Guaranty - 2 years |
|||||||
Record-Level Error |
For SF, SU, PL & GB loans with DC, DD, DK, DP, DS, DW, FD, OD or UD Loan Status, the Date of Loan Status must be on or after the Date Entered Repayment. |
Date of Loan Status is before Date Entered Repayment. |
0578 |
Based on Loan Status, Date must be >= Date Entered Repayment |
|||||||
Record-Level Error |
For SL loans (other than ID Loan Status), the Date of Loan Status must be on or after the Date of Guaranty. |
Date of Loan Status is before Date of Guaranty. |
0579 |
Based on loan type & status, Date must be >= Date of Guaranty |
|||||||
Record-Level Error |
For SF, SU, PL & GB loans with BC, BK, CA, DA, DE, DI, FB, PC, PF, RF, RP, or UI, Loan Status, the Date of Loan Status must be on or after the Date of Guaranty. |
Date of Loan Status is before Date of Guaranty. |
0579 |
Based on loan type & status, Date must be >= Date of Guaranty |
|||||||
Record-Level Error |
For Non-CL Loans for all other loan statuses except ID and CA, the Date of Loan Status must be on or before the Submittal (Extract dt) Date. |
Date of Loan Status is after the Submittal (Extract) Date. |
0580 |
Date must be = or less than Submittal Date |
|||||||
Load-Level Error |
For ID Loan Status, the Date of Loan Status must be on or before the Submittal (Extract) Date unless equal to the Date Enrollment Period Begins. |
Date of Loan Status is after the Submittal (Extract) Date, but not equal to the Enrollment Period Begin Date. |
0668 |
For ID Loan Stat, Datet must be <= Submit Date or = Enrol Per Beg Date |
|||||||
Record-Level Error |
For CA Loan Status, the Date of Loan Status must be on or before the later of (a) the Date of Guaranty plus 2 years or (b) the Submittal (Extract) Date. |
Date of Loan Status is after the later of (a) the Date of Guaranty plus 2 years or (b) the Submittal (Extract) Date. |
0710 |
For CA Loan Stat, must be <= Date of Guar + 2yr or <= Submittal Date(Extract Date) |
|||||||
Record-Level Error |
For CA Loan Status, the Date of Loan Status must be on or before the later of (a) the Date of Guaranty plus 2 years or (b) the Submittal (Extract Dt) Date. |
Date of Loan Status is after the later of (a) the Date of Guaranty plus 2 years or (b) the Submittal (Extract) Date. |
0710 |
For CA Loan Stat, must be <= Date of Guar + 2yr or <= Submittal Date(Extract Date) |
|||||||
Record-Level Error
|
For SF, SU, & PL loans with DB, DL, DO, DT, DU, DX Loan Status, the Date of Loan Status must be on or after the Date of Disbursement. |
Date of Loan Status is before the Date of Disbursement. |
0715 |
Based on loan type & status, Dt must be >= Date of Disbursement |
|||||||
Record-Level Error |
For CL loans, for all loan statuses except CA, the Date of Loan Status must be on or before the Submittal (Extract) Date plus 1 month. |
Date of Loan Status is after the Submittal (Extract) Date plus 1 month. |
0721 |
For CL loans, Date must be <= Submittal Ate + 1 year. |
|||||||
Record-Level Error |
For CL & RF loans not in an IA status, the Date of Loan Status must be on or after the Date of Guaranty less 1 year.. |
Date of Loan Status is before Date of Guaranty less 1 year. |
0720 |
For CL and RF loans, Date must be >= Date of Guaranty – 1 year. |
|||||||
Record-Level Error |
Date of Loan Status must be after the other loan activity dates. |
Date of Loan Status is on or before the other loan activity dates. |
0724 |
For AE status, date must be > other loan activity dates |
|||||||
Record-Level Error |
For AE loan status, Date of Loan Status must be on or after 11/1/1994. |
Date of Loan Status is before 11/1/1994. |
0725 |
AE status date must be >= 11/1/1994 |
|||||||
Record-Level Error |
For IG or IM loan status, Date of Loan Status must be on or after the Date of Guaranty minus 180 days. |
Date of Loan Status is before Date of Guaranty minus 180 days. |
0726 |
For IG/IM loan status date must be >= date of guaranty - 180 days |
|||||||
Load Level Error |
If Loan-Status = IA and Date of Guaranty, the loan must have a prior status of IM. |
Date of Loan Status = Date of Guaranty. Date of Guaranty is before Loan Status Date and prior loan status in not IM. |
0728 |
For IA loan status, Date must = Date of Guaranty unless prior IM status. |
|||||||
Date Revised 02-15-2007 |
Code for Loan Status |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Character |
2 |
142-143 |
063 |
||||
Description |
Code for current status of a loan. |
||||||||||
Comments |
Must be a valid code from the Loan Status Codes Table (Appendix B–Table B-10). |
||||||||||
Part of Event Type |
Loan Status |
||||||||||
Companion Field(s) |
(formerly Amount of Ending Balance on Claim of Other Fees )(108)
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report actual value if change in loan status occurs, or as new loan is made. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Record-Level Error |
Must be reported. |
Is blank. |
0130 |
Code for Loan Status is required |
|||||||
Record-Level Error |
Must be a valid code from the Loan Status Code Table. |
Invalid code. |
0179 |
Invalid Code for Loan Status |
|||||||
Load-Level Error |
Loan with AE loan status must already reside on the database |
Loan with AE loan status is not on the database. |
0723 |
AE loan status not valid on first reporting of loan |
|||||||
Date Revised |
04-06-2006 |
Date of Cancellation |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
144-151 |
064 |
||||
Description |
Date when all or part of a loan was canceled. |
||||||||||
Comments |
Report the actual Date of Cancellation. |
||||||||||
Part of Event Type |
Cancellation |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if cancellation has not occurred. |
||||||||||
Reporting |
Report actual value if full or partial cancellation occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0302 |
Invalid Date of Cancellation |
|||||||
Record-Level Error |
Must be reported if Code for Loan Status is ‘CA’ or there is a corresponding value in Amount of Cancellation. |
Contains zeroes. |
0152 |
Date of Cancellation is required |
|||||||
Record-Level Error |
Date of Cancellation must be on or after the Date of Guaranty. |
Date of Cancellation is before the Date of Guaranty. |
0583 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
Date of Cancellation must be on or before the later of (a) the Date of Guaranty plus two years or (b) the Submittal (Extract) Date. |
Date of Cancellation is after the later of (a) the Date of Guaranty plus two years or (b) the Submittal (Extract) Date. |
0717 |
Date must be <= Dt of Guar + 2yr or <= Submittal Dt |
|||||||
Date Revised |
6-16-2003 |
Amount of Cancellation |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
152-157 |
065 |
||||
Description |
The cumulative amount of loan or disbursement(s) that was canceled. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Cancellation |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if cancellation has not occurred. |
||||||||||
Reporting |
Report actual value if cancellation occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0312 |
Invalid Amount of Cancellation |
|||||||
Record-Level Error |
Must be reported if Code for Loan Status is ‘CA’ or there is a corresponding value in Date of Cancellation. |
Contains zeroes. |
0105 |
Amount of Cancellation for Loan is required |
|||||||
Record-Level Error |
If the Code for Loan Status is ‘CA’, this field must equal the Amount of Guaranty. |
Amount of Cancellation is not equal to the Amount of Guaranty. |
0138 |
Amount of Cancellation must = Loan Amount |
|||||||
Record-Level Error |
Amount of Cancellation must be the same or less than the Amount of Guaranty. |
Amount of Cancellation is greater than the Amount of Guaranty. |
0287 |
Amount of Cancellation must be < or = Amount of Guaranty |
|||||||
Date Revised |
6-16-2003 |
Date of Disbursement |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
158-165 |
066 |
||||
Description |
Date when latest loan disbursement was made. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Disbursement |
||||||||||
Companion Field(s) |
(formerly Date of Refund from Lender on Claims)099
|
||||||||||
Default Value / Use |
Report ‘00000000’ if disbursement has not occurred. |
||||||||||
Reporting |
Report actual value if disbursement occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0192 |
Invalid Date of Disbursement |
|||||||
Record-Level Error |
Must be reported if there is a corresponding value in Amount of Disbursement. |
Contains zeroes. |
0145 |
Date of Disbursement is required |
|||||||
Record-Level Error |
A plug date is not reported on loan guaranteed on or after January 1, 1984. |
Plug date used. |
0230 |
‘19000101’ invalid when Dt of GA >= ’19840101’ |
|||||||
Record-Level Error |
Date of Disbursement must be on or after the Date of Guaranty (excludes CL, RF, loans transferred or loans with Date of Guaranty before 19950701). |
Date of Disbursement is before the Date of Guaranty. |
0581 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
Date of Disbursement must be on or before the Submittal (Extract) Date. |
Date of Disbursement is after the Submittal (Extract) Date. |
0582 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
For loans not transferred, Date of Disbursement must be on or before the Date of Guaranty plus 2 years. |
Date of Disbursement is after the Date of Guaranty plus 2 years. |
0633 |
Date must be = or less than Date of Guaranty + 2 years |
|||||||
Record-Level Error |
For CL and RF loans, the Date of Disbursement must be on or after the Date of Guaranty less 1 year. |
Date of Disbursement is before the Date of Guaranty less 1 year. |
0704 |
For CL & RF loans, Dt must be >= than Dt of Guaranty - 1 year |
|||||||
Record-Level Error |
For loans transferred, the Date of Disbursement must be on or after Date of Guaranty less 1 year. |
Date of Disbursement is before the Date of Guaranty less 1 year. |
0705 |
Date must be >= than Dt of Guaranty - 1 year |
|||||||
Record-Level Error |
For loans with an early date of Guaranty (on or before 19950630), the Date of Disbursement must be on or after Date of Guaranty less 1 year. |
Date of Disbursement is before the Date of Guaranty less 1 year. |
0705 |
Date must be >= than Date of Guaranty - 1 year |
|||||||
Load-Level Error |
Date change falls in acceptable range with historical data. |
Date Sequence Error. |
0525 |
Date must be > preceding date (if amount of Disbursement = Amount of Guaranty minus Amount of Cancellation there is a $5.00 tolerance) |
|||||||
Load-Level Error |
A plug date can’t supplant a previously reported actual date. |
Plug date used. |
0527 |
Default value for this field cannot modify a real value |
|||||||
Date Revised |
6-16-2003 |
Amount of Disbursement |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
166-171 |
067 |
||||
Description |
The cumulative net amount of loan actually disbursed to a borrower. The cumulative amount includes origination fees and insurance premiums. Cancellations are deducted from the amount in this field. Refunds are not deducted from the amount in this field |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Disbursement |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if disbursement has not occurred. |
||||||||||
Reporting |
Report actual value if disbursement occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0311 |
Invalid Amount of Disbursement |
|||||||
Record-Level Error |
Amount of Disbursement must not exceed the Amount of Guaranty. |
Amount of Disbursement exceeds the Amount of Guaranty. |
0101 |
Amount exceeds Amount of Guaranty |
|||||||
Record-Level Error |
Must be zeroes if Code for Loan Status is ‘CA’. |
Contains balance on canceled loan. |
0355 |
Amount of Disbursement must be zero for Loan Status CA |
|||||||
Date Revised |
5-26-2000 |
Filler |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Date |
8 |
172-179 |
068 |
||||
Description |
This field is no longer required as of October 1, 2000. All edits have been removed. Until you make system changes, you may continue to populate this field as before, but any data submitted will be ignored by NSLDS. |
||||||||||
Comments |
Not applicable. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
6-16-2003 |
Filler |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
180 |
069 |
|||||
Description |
This field is no longer required as of October 1, 2000. All edits have been removed. Until you make system changes, you may continue to populate this field as before, but any data submitted will be ignored by NSLDS. |
|||||||||||
Comments |
Not applicable. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
6-16-2003 |
PLUS Borrower’s Social Security Number Indicator |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Character |
1 |
181 |
070 |
|||||
Description |
Indicates whether PLUS Borrower’s Social Security Number is a real Social Security Number or a pseudo number. |
|||||||||||
Comments |
Report ‘R’ (Real) or ‘P’ (Pseudo). |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled when loan is a PLUS loan. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be a blank when Type of Loan is other than ‘PL’. |
Not blank. |
0193 |
Field not required on this type of loan |
||||||||
Record-Level Error |
Must be reported when Type of Loan is ‘PL’. |
Is blank. |
0226 |
PLUS Borrower SSN Indicator is required |
||||||||
Record-Level Error |
Must be ‘R’ or ‘P’ when Type of Loan is ‘PL’. |
Contains wrong value. |
0228 |
Invalid PLUS Borrower SSN Indicator |
||||||||
Date Revised |
5-26-2000 |
PLUS Borrower’s First Name |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
No |
No |
Character |
12 |
182-193 |
071 |
||||
Description |
PLUS Borrower’s first name. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report blanks if not a PLUS loan. |
||||||||||
Reporting |
Report actual value in regular update when new PLUS loan or change in name occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be left-justified. |
Isn’t left-justified. |
0166 |
Field must be left-justified |
|||||||
Record-Level Error |
Must be blank if Type of Loan is not ‘PL’. |
Isn’t blank. |
0193 |
Field not required on this type of loan |
|||||||
Record-Level Error |
Must be reported if Type of Loan is ‘PL’. |
Is blank. |
0344 |
Borrower First Name is required |
|||||||
Load-Level Error |
If the Student’s and PLUS Borrower’s SSNs are equal, the Student’s and PLUS Borrower’s First Names are also equal. |
PLUS Borrower and Student SSNs match and First Names do not. |
0405 |
Student / PLUS Borrower First Names must match if SSNs match |
|||||||
Date Revised |
5-26-2000 |
PLUS Borrower’s Last Name |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Character |
35 |
194-228 |
072 |
|||||
Description |
PLUS Borrower’s last name. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report blanks if not a PLUS loan. |
|||||||||||
Reporting |
Report actual value if new loan or name change occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be left-justified. |
Isn’t left-justified. |
0166 |
Field must be left-justified |
||||||||
Record-Level Error |
Must be blank if not ‘PL’ Type of Loan. |
Isn’t blank. |
0193 |
Field not required on this type of loan |
||||||||
Record-Level Error |
Must be reported if Type of Loan is ‘PL’. |
Is blank. |
0345 |
PLUS Borrower Last Name is required |
||||||||
Date Revised |
5-26-2000 |
Date of PLUS Borrower’s Birth |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Date |
8 |
229-236 |
073 |
||||
Description |
Date when PLUS Borrower was born. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if loan is not a PLUS loan. |
||||||||||
Reporting |
Report actual value if loan is a PLUS loan. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0227 |
Invalid PLUS Borrower Date of Birth |
|||||||
Record-Level Error |
If Date of Guaranty is later than Date of Initial Load, ‘19000101’ cannot be reported. |
Invalid plug date. |
0102 |
19000101 is invalid when Date of Guaranty > Init Load Date |
|||||||
Record-Level Error |
Must be zeroes if Type of Loan is not ‘PL’. |
Contains wrong value. |
0193 |
Field not required on this type of loan |
|||||||
Record-Level Error |
Can’t be zeroes if Type of Loan is ‘PL’. |
Contains zeroes. |
0343 |
PLUS Borrower Date of Birth is required |
|||||||
Record-Level Error |
Date of PLUS Borrower Birth must be on or after the Date of Guaranty less 99 years. |
Date of PLUS Borrower Birth is before the Date of Guaranty less 99 years. |
0621 |
Date must be = or greater than Date of Guaranty - 99 years |
|||||||
Record-Level Error |
Date of PLUS Borrower Birth must be on or before the Date of Guaranty less 12 years. |
Date of PLUS Borrower Birth is after the Date of Guaranty less 12 years. |
0622 |
Date must be = or less than Date of Guaranty - 12 years |
|||||||
Date Revised |
5-26-2000 |
Student’s Social Security Number Indicator |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Character |
1 |
237 |
074 |
|||||
Description |
Indicates whether Student’s Social Security Number is a pseudo SSN or a real number. |
|||||||||||
Comments |
Report ‘R’ for Real, ‘P’ for ‘Pseudo’. |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be ‘R’ or ‘P’. |
Contains wrong value. |
0236 |
Invalid Student SSN Indicator |
||||||||
Record-Level Error |
Must be reported. |
Is blank. |
0261 |
Student SSN Indicator is required |
||||||||
Date Revised |
5-26-2000 |
Student’s Academic Level |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Character |
1 |
238 |
075 |
||||
Description |
Student’s academic or grade level in school at the beginning of the specific period covered by the loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report a blank if Type of Loan is ‘CL’ (Consolidated) or ‘RF’ (Refinanced). |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Record-Level Error |
Must be a valid code from the Academic Level Codes Table. |
Invalid code. |
0232 |
Invalid Student Academic Level |
|||||||
Record-Level Error |
Whether ‘N’ is valid. |
Contains plug value when Date of Guaranty is Jan. 1, 1984 or later. |
0237 |
Invalid value when DT of GA > or = 19840101 |
|||||||
Record-Level Error |
Must be reported unless Type of Loan is ‘CL’ or ‘RF’. |
Is blank. |
0522 |
Student Academic level is required |
|||||||
Load-Level Error |
Plug value can’t be used to modify real data. |
Type of Loan is not ‘CL’ or ‘RF’, but plug value of ‘N’ was used. |
0527 |
Def value for this field cannot modify a real value |
|||||||
Date Revised |
5-26-2000 |
Student’s Last Name |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
No |
No |
Character |
35 |
239-273 |
076 |
||||
Description |
Title IV aid recipient or beneficiary’s current last name. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be left-justified. |
Isn’t left-justified. |
0166 |
Field must be left-justified |
|||||||
Record-Level Error |
Must be reported. |
Is blank. |
0263 |
Student Last Name is required |
|||||||
Date Revised |
5-26-2000 |
Date Enrollment Period Begins |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Date |
8 |
274-281 |
077 |
||||
Description |
Date when classes are (or were) to begin for the period covered by the loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0187 |
Invalid Date Enrollment Period Begins |
|||||||
Record-Level Error |
Must be reported if Type of Loan is other than ‘CL’ or ‘RF’. |
Contains zeroes. |
0165 |
Date Enrollment Period Begins is required |
|||||||
Record-Level Error |
Whether ‘19000101’ is valid. |
Contains plug value when Date of Guaranty is Jan. 1, 1984, or later. |
0230 |
19000101 is invalid when DT of GA > or = 19840101 |
|||||||
Record-Level Error |
Date Enrollment Period Begins must be on or after the Date of Guaranty less 2 years. |
Date Enrollment Period Begins is before the Date of Guaranty less 2 years. |
0570 |
Date must be = or greater than Date of Guaranty - 2yrs |
|||||||
Record-Level Error |
Date Enrollment Period Begins must be on or before the Date of Guaranty plus 2 years. |
Date Enrollment Period Begins is after the Date of Guaranty plus 2 years. |
0571 |
Date must be = or less than Date of Guaranty + 2 years |
|||||||
Record-Level Error |
For SL loans, the Date Enrollment Period Begins must be on or before 19940630. |
Date Enrollment Period Begins is after 19940630. |
0645 |
Date must be = or less than 19940630 |
|||||||
Load-Level Error |
Plug value can’t be used to modify real data. |
Type of Loan is not ‘CL’ or ‘RF’, but plug value was used. |
0527 |
Def value for this field cannot modify a real value |
|||||||
Date Revised |
5-26-2000 |
Date Enrollment Period Ends |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Date |
8 |
282-289 |
078 |
||||
Description |
Date when classes ended (or were to end) for the period covered by loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0188 |
Invalid Date Enrollment Period Ends |
|||||||
Record-Level Error |
Date Enrollment Period Ends must be after the Date Enrollment Period Begins. |
Date Enrollment Period Ends is not after the Date Enrollment Period Begins. |
0140 |
Date must be later than Date Enrollment Period Begins |
|||||||
Record-Level Error |
Whether ‘19000101’ is valid. |
Contains plug value when Date of Guaranty is Jan. 1, 1984 or later. |
0230 |
19000101 is invalid when DT of GA > or = 19840101 |
|||||||
Record-Level Error |
Must be reported if Type of Loan is other than ‘CL’ or ‘RF’. |
Contains zeroes. |
0303 |
Date Enrollment Period Ends is required |
|||||||
Record-Level Error |
Date Enrollment Period Ends must be on or before the Date Enrollment Period Begins plus 3 years. |
Date Enrollment Period Ends is after the Date Enrollment Period Begins plus 3 years. |
0736 |
Date must be = or < Date Enrollment Period Begins + 3 years |
|||||||
Load-Level Error |
Plug value can’t be used to modify real data. |
Incoming date is a plug date and previously reported date is a real date. |
0527 |
Default value for this field cannot modify a real value |
|||||||
Date Revised |
06-10-2008 |
Student’s Middle Initial |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
290 |
079 |
|||||
Description |
Title IV aid recipient or beneficiary’s middle initial. |
|||||||||||
Comments |
Report actual initial if known. |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
None. |
|||||||||||
Default Value / Use |
Report a blank if initial is not known or student has no middle initial. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Student’s Driver’s License Number |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
30 |
291-320 |
080 |
|||||
Description |
Title IV aid recipient or beneficiary’s driver’s license number. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must be filled when Code for Enrollment Status is ‘A’, ‘F’, or ‘H’ (i.e., in-school). Report a blank for PLUS loans or loans with other enrollment statuses. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be reported if Code for Enrollment Status is ‘A’, ‘F’, or ‘H’ and Type of Loan is other than ‘PL’. |
Is blank. |
0207 |
Student Driver License Number is required |
||||||||
Date Revised |
5-26-2000 |
Student’s Driver’s License State |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
2 |
321-322 |
081 |
|||||
Description |
State that issued Title IV aid recipient or beneficiary’s driver’s license. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
|
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be a valid code from the State Codes Table (if not blank). |
Invalid code. |
0340 |
Invalid Student Driver’s License State |
||||||||
Record-Level Error |
Must be reported if Code for Enrollment Status is ‘A’, ‘F’, or ‘H’ and Type of Loan is other than ‘PL’. |
Is blank. |
0341 |
Student Driver’s License State is required |
||||||||
Date Revised |
5-26-2000 |
PLUS Borrower’s Middle Initial |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
323 |
086 |
|||||
Description |
PLUS Borrower’s middle initial. |
|||||||||||
Comments |
Field must be blank if loan is not a PLUS loan. |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report a blank if loan is not a PLUS loan, middle initial not known, or no middle initial. |
|||||||||||
Reporting |
Report if new loan or name change occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Field must be blank if Type of Loan is not ‘PL’. |
Isn’t blank. |
0193 |
Field not required on this type of loan |
||||||||
Date Revised |
5-26-2000 |
PLUS Borrower’s State of Residence |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
2 |
324-325 |
087 |
|||||
Description |
The code for a PLUS Borrower’s permanent state of residence at the time the loan was guaranteed. |
|||||||||||
Comments |
Must be a valid code from the State Codes Table (Appendix B– Table B-14). |
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled if loan is a PLUS loan. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be blank if Type of Loan isn’t ‘PL’. |
Isn’t blank. |
0193 |
Field not required on this type of loan |
||||||||
Record-Level Error |
Must be a valid code from the States Code Table. |
Invalid code. |
0347 |
Invalid PLUS Borrower’s State of Residence |
||||||||
Record-Level Error |
Must be reported if Type of Loan is ‘PL’ and the loan was guaranteed after the Initial Load Date. |
Is blank. |
0523 |
PLUS Borrower’s State of Residence is required |
||||||||
Date Revised |
5-26-2000 |
Code for Servicer |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
No |
No |
Numeric |
6 |
326-331 |
088 |
||||
Description |
Code for current lender servicer of an FFELP loan, if there is one. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Lender Servicer |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if loan is not currently assigned to a lender servicer. |
||||||||||
Reporting |
Must always be reported if loan is assigned to a lender servicer. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0182 |
Invalid Code for Servicer |
|||||||
Record-Level Error |
Must contain a valid code if there is a corresponding value in Date of Servicer Responsibility. |
Contains zeroes. |
0395 |
Code for Servicer is required |
|||||||
Load-Level Error |
Must be valid Servicer Code. |
Invalid code. |
0182 |
Invalid Code for Servicer |
|||||||
Date Revised |
11-23-2008 |
Code for Originating FFELP Lender |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
6 |
332-337 |
089 |
||||
Description |
Code for lender that issued promissory note for an FFELP loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0180 |
Invalid Code for Originating FFELP Lender |
|||||||
Record-Level Error |
Must be a value between ‘800000’ and ‘999899’, if not ‘444444’. |
Invalid code. |
0180 |
Invalid code for Originating FFELP Lender |
|||||||
Record-Level Error |
‘444444’ only reported when Date of Guaranty is before January 1, 1984. |
Invalid code based on Date of Guaranty. |
0237 |
Invalid value when Date of Guaranty > or = 19840101 |
|||||||
Record-Level Error |
Can’t be ‘000000’. |
Is ‘000000’. |
0279 |
Code for Originating FFELP Lender is required |
|||||||
Load-Level Error |
Must be a valid Lender Code. |
Invalid code. |
0180 |
Invalid Code for Originating FFELP Lender |
|||||||
Date Revised |
5-26-2000 |
Date Guaranty Transferred |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
338-345 |
090 |
||||
Description |
Date when a loan guaranty is transferred from one GA to another or to the Federal government. Reported by the receiving agency. |
||||||||||
Comments |
Report the date when a loan guaranty was transferred from one GA to another. The following agencies are allowed to take loans from another GA without requiring that the transfer being initiated by the current GA: Debt Collections Services DCS (555) and ECMC (927). In order to transfer in a loan currently held by GA 555 or 927 the transfer must be initiated by the current GA. |
||||||||||
Part of Event Type |
Transfer |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if transfer has not occurred. |
||||||||||
Reporting |
Report actual value if transfer occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0190 |
Invalid Date Guaranty Transferred |
|||||||
Record-Level Error |
Date of Guaranty Transfer must be on or after the Date of Guaranty. |
Date of Guaranty Transfer is before the Date of Guaranty. |
0593 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
Date of Guaranty Transfer must be on or before the Submittal (Extract) Date. |
Date of Guaranty Transfer is after the Submittal (Extract) Date. |
0594 |
Date must be = or less than Submittal Date |
|||||||
Load-Level Error |
Whether date is earlier than a Date Guaranty Transferred previously reported on that loan by another agency. |
Date is earlier. |
0326 |
Guaranty Trans Date must be > Previous Guaranty Trans Date |
|||||||
Date Revised |
5-26-2000 |
Type of Deferment |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
No |
No |
Character |
2 |
346-347 |
091 |
||||
Description |
One of the legal reasons for postponing repayment of loan principal and interest. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Deferment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report blanks if deferment has not occurred. |
||||||||||
Reporting |
Report actual value if deferment occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Record-Level Error |
Can’t be blank if there is a corresponding value in Date Deferment Starts or Date Deferment Stops. |
Is blank. |
0265 |
Type of Deferment is required |
|||||||
Load-Level Error |
Must be a valid code (if not blank) from the Deferment Type Codes Table. If not blank, the code is valid based on Loan Type and Date of Guaranty as described in the Deferment Type Usage Codes Table. |
Invalid code. |
0239 |
Invalid Type of Deferment |
|||||||
Date Revised |
5-26-2000 |
Date Deferment Starts |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
Yes |
Date |
8 |
348-355 |
092 |
|||||
Description |
Date when a legal deferment actually begins. |
|||||||||||
Comments |
(This practice was implemented to accommodate a change in the NSLDS definition of Date Entered Repayment (Date of Maturity) for SLS loans, since technically SLS Date Deferment Starts the day after the loan is disbursed. Reporting the date as described avoids an error with DataPrep Version 1.0. NSLDS automatically subtracts the 7000 years during record-level editing.) |
|||||||||||
Part of Event Type |
Deferment |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report ‘00000000’ if deferment has not occurred. |
|||||||||||
Reporting |
Report actual value if deferment occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0185 |
Invalid Date Deferment Starts |
||||||||
Record-Level Error |
Can’t be zeroes if there are corresponding values in the Date Deferment Stops or the Type of Deferment. |
Contains zeroes. |
0132 |
Date Deferment Starts is required |
||||||||
Record-Level Error |
Date Deferment Starts must be on or before the Submittal (Extract) Date. |
Date Deferment Starts is after the Submittal (Extract) Date. |
0589 |
Date must be = or less than Submittal Date |
||||||||
Record-Level Error |
Date Deferment Starts must be on or after the earlier of (a) the Date of Disbursement (if the Date of Disbursement is not zero) or (b) the Date of Guaranty. |
Date Deferment Starts is before the earlier of (a) the Date of Disbursement (if Date of Disbursement is not zero) or (b) the Date of Guaranty. |
0718 |
Date must be >= Date of Disbursement or >= Date of Guaranty |
||||||||
Record-Level Error |
For non-SL loans, if the loan is not rehabilitated (Indicator of Rehabilitated Loan is not Y) or the Date Deferment Starts is after rehabilitation (Date Repurchased), then the Date Deferment Starts must be on or after the Date Entered Repayment. |
Date Deferment Starts is before the Date Entered Repayment. |
0719 |
Date must be = or greater than Date Entered Repayment |
||||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
||||||||
Date Revised |
5-26-2000 |
Date Deferment Stops |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Date |
8 |
356-363 |
093 |
|||||
Description |
Date when a legal deferment is projected to end or actually ends. Includes post-deferment grace period if applicable. |
|||||||||||
Comments |
(This practice was implemented to accommodate a change in the NSLDS definition of Date Entered Repayment (Date of Maturity) for SLS loans, since technically SLS Date Deferment Starts the day after the loan is disbursed. Reporting the date as described avoids an error with DataPrep Version 1.0. NSLDS automatically subtracts the 7000 years during record-level editing.) |
|||||||||||
Part of Event Type |
Deferment |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report ‘00000000’ if deferment has not occurred. |
|||||||||||
Reporting |
Report actual value if deferment occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0186 |
Invalid Date Deferment Stops |
||||||||
Record-Level Error |
Can’t be zeroes if there are corresponding values in Type of Deferment and Date Deferment Starts. |
Contains zeroes. |
0133 |
Date Deferment Stops is required |
||||||||
Record-Level Error |
Date Deferment Stops must be after the Date Deferment Starts. |
Date Deferment Stops is not after the Date Deferment Starts. |
0139 |
Date must be later than Date Deferment Starts |
||||||||
Record-Level Error |
Date Deferment Stops must be on or before the Date Deferment Starts plus 15 years. |
Date Deferment Stops is after the Date Deferment Starts plus 15 years. |
0592 |
Date must be = or less than Date Deferment Starts + 15 years |
||||||||
Date Revised |
5-26-2000 |
Indicator of Lender-of-Last Resort Loan |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Character |
1 |
364 |
095 |
||||
Description |
Indicates that loan is a lender-of-last-resort loan. |
||||||||||
Comments |
Must contain ‘Y’ (Yes) or a blank. |
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
None. |
||||||||||
Default Value / Use |
Report ‘Y’ if lender of last resort loan, blank if not. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Record-Level Error |
Must be ‘Y’ or blank. |
Contains wrong value. |
0398 |
Invalid Indicator of Lender of Last Resort Loan |
|||||||
Date Revised |
5-26-2000 |
Claim Reason for Guaranty Agency Claim |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
Yes |
No |
Character |
2 |
365-366 |
096 |
|||||
Description |
The reason the latest reinsurance claim, including supplemental insurance, was paid to a Guaranty Agency. Reasons include borrower death, disability, bankruptcy, default, closed school, false certification, or exempt. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Reinsurance Claim Payment |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use
|
1. The reinsurance claim request occurred before the latest repurchase; and 2. The request has been fully paid/processed; and 3. The request has been successfully reported to NSLDS. |
|||||||||||
Reporting |
Report actual value if Reinsurance Claim Payment occurs. |
|||||||||||
|
|
|
|
|
||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be a valid code. |
Contains wrong value. |
0174 |
Invalid Claim Reason for GA Claim |
||||||||
Record-Level Error |
If this field contains ‘CS’ and Date Reinsurance Claim Requested is earlier than April 1, 1993, ‘CS’ is invalid. (Status did not exist prior to this date.) |
Contains wrong value. |
0174 |
Invalid Claim Reason for GA Claim |
||||||||
Record-Level Error |
If this field contains ‘FC’ and Date Reinsurance Claim Requested is earlier than January 1, 1994, ‘FC’ is invalid. (Status did not exist prior to this date.) |
Contains wrong value. |
0174 |
Invalid Claim Reason for GA Claim |
||||||||
Record-Level Error |
Must be reported if there are corresponding values in Amount of Reinsurance Claim Requested or Date Reinsurance Claim Requested. |
Is blank. |
0277 |
Claim Reason for GA Claim is required |
||||||||
Date Revised |
5-26-2000 |
Date of Refund on Claims Formerly Date of Refund From Lender on Claims |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Date |
8 |
367-374 |
099 |
||||
Description |
Date when Guaranty Agency received an insurance claim refund . |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Insurance Claim Refund |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if Insurance Claim Refund has not occurred, or if latest refund occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Insurance Claim Refund occurs.
|
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0209 |
Invalid Date Of Refund on Claims (formerly Invalid Date Of Refund from Lender on Claims) |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Amount of Refund on Claims. |
Contains zeroes. |
0159 |
Date of Refund on Claims is required (formerly Date of Refund From Lender on Claims is required) |
|||||||
Record-Level Error |
Date of Refund on Claims must be on or before the Submittal (Extract) Date. |
Date of Refund on Claims is after the Submittal (Extract) Date. |
0606 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date of Refund on Claims must be on or after the Date of Guaranty. |
Date of Refund on Claims is before the Date of Guaranty. |
0637 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
Date of Refund on Claims must be on or after the Date of Disbursement. |
Date of Refund on Claims is before the Date of Disbursement. |
0644 |
Date must be = or greater than Date of Disbursements |
|||||||
Date Revised |
3-1-2005 |
Amount of Refund on Claims Formerly Amount of Refund From Lender on Claims |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
375-380 |
100 |
||||
Description |
The cumulative dollar amount of reinsurance refund(s) from the GA due to an overpayment of lender claim, overstated reinsurance request, late refunds from the institution to the lender or borrower payments to the lender—A refund is reported only if reinsurance has been requested.. Amount does not include refunds that were made prior to repurchase. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Insurance Claim Refund |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if Insurance Claim Refund has not occurred, or if latest refund occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Insurance Claim Refund occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0334 |
Invalid Amount of Refund on Claims |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date of Refund on Claims. |
Contains zeroes. |
0123 |
Amount of Refund on Claims is required |
|||||||
Record-Level Error |
Amount of Refund on Claims must not exceed the Amount of Claim Paid to Lender. |
Amount of Refund on Claims must not exceed the Amount of Claim Paid to Lender. |
0658 |
Amount must be = or less than Amount of Claim Paid to Lender |
|||||||
Date Revised |
6-1-2005 |
Date of Refund to Lender from School Formerly Date of Refund to Lender |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
No |
No |
Date |
8 |
381-388 |
101 |
||||
Description |
Date when a lender receives a refund from the school. |
||||||||||
Comments |
Report the actual Date of Refund to Lender, or, as a minimum, Guaranty Agencies must collect refund information as it stands at the end of each quarter (March 31, June 30, September 30, and December 31). This data must be forwarded to NSLDS before the end of the next quarter. |
||||||||||
Part of Event Type |
Refund to Lender |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if refund has not occurred or if latest refund occurred before repurchase. |
||||||||||
Reporting |
Report actual value if refund occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0210 |
Invalid Date of Refund to Lender |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Amount of Refund From School to Lender. |
Contains zeroes. |
0161 |
Date of Refund to Lender is required |
|||||||
Record-Level Error |
Date of Refund to Lender must be on or after the Date of Guaranty. |
Date of Refund to Lender is before the Date of Guaranty. |
0585 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
Date of Refund to Lender must be on or before the Submittal (Extract) Date. |
Date of Refund to Lender is after the Submittal (Extract) Date. |
0586 |
Date must be = or less than Submittal Date |
|||||||
Date Revised |
6-16-2003 |
Amount of Refund From School to Lender Formerly Amount of Refund From School to Lender According to Lender |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
389-394 |
103 |
||||
Description |
The cumulative amount of refund(s) returned from school to lender, as reported by lender. School refunds should be reported in this field up to the time an insurance claim is paid on a loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Refund to Lender |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if loan refund has not occurred. |
||||||||||
Reporting |
Report actual value if loan refund occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0327 |
Invalid Amt Refund from School to Lender |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date of Refund to Lender. |
Contains zeroes. |
0125 |
Amt of Refund School to Lender is required |
|||||||
Record-Level Error |
Amount of Refund from School to Lender must not exceed the Amount of Disbursement. |
Amount of Refund from School to Lender exceeds the Amount of Disbursement. |
0652 |
Amount must be = or less than Amount of Disbursement |
|||||||
Record-Level Error |
Amount of Refund from School to Lender must not exceed the Amount of Guaranty. |
Amount of Refund from School to Lender exceeds the Amount of Guaranty. |
0716 |
Amount must be = or less than Amount of Guaranty |
|||||||
Date Revised |
5-26-2000 |
Claim Reason for Lender Claim |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
Yes |
No |
Character |
2 |
395-396 |
105 |
|||||
Description |
The reason the latest insurance claim, including supplemental claims, was paid to lender. Reasons include borrower death, disability, bankruptcy, default, closed school, false certification, or exempt. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Insurance Claim Payment |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report blanks if Insurance Claim Payment has not occurred, or if latest payment occurred before repurchase and it has already been successfully reported to NSLDS. |
|||||||||||
Reporting |
Report actual value if Insurance Claim Payment occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Can’t be ‘CS’ if Date Claim Paid is April 1, 1993 or earlier. (Status did not exist prior to this date.) |
Contains wrong value. |
0175 |
Invalid Claim Reason for Lender Claim |
||||||||
Record-Level Error |
Can’t be ‘FC’ if Date Claim Paid is Jan. 1, 1994 or earlier. (Status did not exist prior to this date.) |
Contains wrong value. |
0175 |
Invalid Claim Reason for Lender Claim |
||||||||
Record-Level Error |
Must be a valid code from the Claim Reason Codes Table (if not blank). |
Invalid code. |
0175 |
Invalid Claim Reason for Lender Claim |
||||||||
Record-Level Error |
Must be reported if Amount of Claim Paid to Lender or Date Claim Paid have corresponding (non-zero) values. |
Is blank. |
0271 |
Claim Reason Code and / or Date Claim Paid is required |
||||||||
Date Revised |
5-26-2000 |
Date Claim Paid |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
397-404 |
106 |
||||
Description |
Date when a Guaranty Agency paid an original insurance claim or the date of any additional claims to a lender. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Insurance Claim Payment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if an Insurance Claim Payment has not occurred, or if latest payment occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Insurance Claim Payment occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0184 |
Invalid Date Claim Paid |
|||||||
Record-Level Error |
Must be reported if there are corresponding values in Claim Reason for Lender Claim or Amount of Claim Paid to Lender. |
Is zeroes. |
0271 |
Claim Reason Code and / or Date Claim Paid is required |
|||||||
Record-Level Error |
Date Claim Paid must be on or before the Submittal (Extract) Date. |
Date Claim Paid is after the Submittal (Extract) Date. |
0604 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date Claim Paid must be on or after the Date of Disbursement. |
Date Claim Paid is before the Date of Disbursement. |
0634 |
Date must be = or greater than Date of Disbursements |
|||||||
Record-Level Error |
Date Claim Paid must be on or after the Date of Guaranty. |
Date Claim Paid is before the Date of Guaranty. |
0635 |
Date must be = or greater than Date of Guaranty |
|||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
|||||||
Date Revised |
5-26-2000 |
Amount of Claim Paid to Lender |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
405-410 |
107 |
||||
Description |
The cumulative amount of principal and interest including any additional principal and interest paid on the claim to a lender by a Guaranty Agency for an insurance claim on loan. Amount does not include claims that were made prior to repurchase. |
||||||||||
Comments |
Principal and interest paid to lender for example: The borrower defaults on a $10,000 loan. The Amount of Claim Paid to the Lender (based on the 2% federal risk sharing), is $9,800.00, Later the Lender realizes that they did not include $100 in accrued interest. The Amount of Claim Paid to lender would be updated to $9,898.00 and the Date of Claim Payment would be updated to the date the additional claim amount was paid to the lender.
|
||||||||||
Part of Event Type |
Insurance Claim Payment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if Insurance Claim Payment has not occurred, or if latest payment occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Insurance Claim Payment occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0324 |
Invalid Amount of Claim Paid to Lender |
|||||||
Record-Level Error |
Can’t be zeroes if there are corresponding values in Date Claim Paid or Claim Reason for Lender Claim. |
Can’t be zeros if there are corresponding values in Claim Reason for Lender Claim or Date Claim Paid. |
0106 |
Amount of Claim Paid to Lender is required |
|||||||
Record-Level Error |
Amount of Claim Paid to Lender must not exceed nine times the Amount of Guaranty. |
Amount of Claim Paid to Lender exceeds nine times the Amount of Guaranty. |
0657 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Load-Level Error |
Can’t be zeroes if Code for Loan Status is ‘BC’, ‘BK’, ‘DB’, ‘DC’, ‘DD’, ‘DE’, ‘DI’, ‘DK’, ‘DL’, ‘DO’, ‘DP’, ‘DS’, ‘DT’, ‘DU’, ‘DW’, ‘DX’, or ‘OD’. |
Contains zeroes. |
0106 |
Amount of Claim Paid to Lender is required |
|||||||
Date Revised |
6-16-2003 |
Amount of Outstanding GA Fees Balance Formerly Amount of Ending Balance on Claim of Other Fees |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
6 |
411-416 |
108 |
||||
Description |
The amount currently owed by the borrower for GA charges other than principal and interest (e.g., late charges, attorney fees, collection charges, and supplemental pre-claims assistance). If other fees are also due to the GA, they should be reported here. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if charges and fees have not occurred. |
||||||||||
Reporting |
Report actual value if charges and fees occur. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0329 |
Invalid Amount of Ending Balance on Claims of Other Fees |
|||||||
Record-Level Error |
Amount of Ending Balance on Claims of Other Fees must not exceed nine times the Amount of Guaranty. |
Amount of Ending Balance on Claims of Other Fees exceeds nine times the Amount of Guaranty. |
0655 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
5-26-2000 |
Date Reinsurance Claim Requested |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
417-424 |
114 |
||||
Description |
Date when the Guaranty Agency requested reinsurance. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Reinsurance Claim Payment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
1. The reinsurance claim request occurred before the latest repurchase; and 2. The request has been fully paid/processed; and 3. The request has been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Reinsurance Claim Payment occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0215 |
Invalid Date Reinsurance Claim Requested |
|||||||
Record-Level Error |
Can’t be zeroes if there are corresponding values in Claim Reason for Guaranty Agency Claim, Amount of Reinsurance Claim Requested, or Amount of Supplemental Claim Requested. |
Contains zeroes. |
0275 |
Date Reinsurance Claim Requested is required |
|||||||
Record-Level Error |
Date Reinsurance Claim Requested must be on or before the Submittal (Extract) Date. |
Date Reinsurance Claim Requested is after Submittal (Extract) Date. |
0608 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date Reinsurance Claim Requested must be on or after the Date of Guaranty. |
Date Reinsurance Claim Requested is before the Date of Guaranty. |
0636 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
Date Reinsurance Claim Requested must be on or after the Date of Disbursement. |
Date Reinsurance Claim Requested is before the Date of Disbursement. |
0643 |
Date must be = or greater than Date of Disbursements |
|||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0529 |
Date Reinsurance Claim Requested must be > prior Date Reinsurance Claim Requested |
|||||||
Date Revised |
02-15-2007 |
Date Reinsurance Claim Paid |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Date |
8 |
425-432 |
115 |
||||
Description |
Date when a Guaranty Agency receives the government reinsurance claim payment.(Electronic Funds Transfer Date). |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Reinsurance Claim Payment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
1. The reinsurance claim request occurred before the latest repurchase; and
|
||||||||||
Reporting |
Report actual value if Reinsurance Claim Payment occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0216 |
Invalid Date Reinsurance Claim Paid |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Reinsurance Reimbursement Rate. |
Contains zeroes. |
0278 |
Date Reinsurance Claim Paid is required |
|||||||
Record-Level Error |
Date Reinsurance Claim Paid must be on or after the Date Reinsurance Claim Requested. |
Date Reinsurance Claim Paid is before the Date Reinsurance Claim Requested. |
0609 |
Date must be = or > Date Reinsurance Claim Requested |
|||||||
Record-Level Error |
Date Reinsurance Claim Paid must be on or before the Submittal (Extract) Date. |
Date Reinsurance Claim Paid is after the Submittal (Extract) Date. |
0610 |
Date must be = or less than Submittal Date |
|||||||
Date Revised |
02-15-2007 |
Amount of Reinsurance Claim Requested |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
433-438 |
116 |
||||
Description |
The total amount of original and additional reinsurance claim requested of ED by a Guaranty Agency. Amount does not include claims that were made prior to repurchase. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Reinsurance Claim Payment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
1. The reinsurance claim request occurred before the latest repurchase; 2. The request has been fully paid/processed; and 3. The request has been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Reinsurance Claim Payment occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0322 |
Invalid Amount of Reinsurance Claim Requested |
|||||||
Record-Level Error |
Can’t be zeroes if there are corresponding values in Date Reinsurance Claim Requested or Claim Reason for Guaranty Agency Claim. |
Contains zeroes. |
0276 |
Amount of Reinsurance Claim Requested is required |
|||||||
Record-Level Error |
Amount of Reinsurance Claim Requested must not exceed nine times the Amount of Guaranty. |
Amount of Reinsurance Claim Requested exceeds nine times the Amount of Guaranty. |
0659 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
6-1-2005 |
Date Supplemental Claim Requested |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
439-446 |
117 |
||||
Description |
Date when a supplemental reinsurance claim request is submitted to ED by a Guaranty Agency. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Supplemental Claim Request |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if Supplemental Claim Request has not occurred, or if latest request occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Supplemental Claim Request occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0217 |
Invalid Date Supplemental Claim Requested |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Amount of Supplemental Claim Requested. |
Contains zeroes. |
0412 |
Date Supplemental Claim Requested is required |
|||||||
Record-Level Error |
If the Date Supplemental Claim Requested is after the Date Repurchased, the Date Supplemental Claim Requested must be on or after the Date Reinsurance Claim Requested. |
Date Supplemental Claim Requested is before the Date Reinsurance Claim Requested. |
0611 |
Date must be = or > Date Reinsurance Claim Requested |
|||||||
Record-Level Error |
Date Supplemental Claim Requested must be on or before the Submittal (Extract) Date. |
Date Supplemental Claim Requested is after the Submittal (Extract) Date. |
0612 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date Supplemental Claim Requested must be on or after the Date of Guaranty. |
Date Supplemental Claim Requested is before the Date of Guaranty. |
0638 |
Date must be = or greater than Date of Guaranty |
|||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
|||||||
Date Revised |
5-26-2000 |
Amount of Supplemental Claim Requested |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
447-452 |
118 |
||||
Description |
The cumulative dollar amount of principal and interest due the Guaranty Agency on a default claim originally paid at a reduced reinsurance rate but which is now eligible for full reimbursement because the borrowers claim status has changed. Amount does not include requests that were made prior to repurchase. |
||||||||||
Comments |
The borrower defaults on a $1,000 loan. The GA pays the lender’s claim of $980 (claim amount minus 2% federal risk share). The Amount of Reinsurance Requested is $931.00 (based on 95% reinsurance rate). A year later the borrower dies. The Amount of Supplemental Claim Requested will be $49.00 (the 5% difference on the Amount of Claim Paid to Lender).
|
||||||||||
Part of Event Type |
Supplemental Claim Request |
||||||||||
Companion Field(s) |
|
||||||||||
Date Revised |
|
||||||||||
Default Value / Use |
Report ‘000000’ if Supplemental Claim Request has not occurred, or if latest request occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Supplemental Claim Request occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0321 |
Invalid Amount of Supplemental Claim |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date Supplemental Claim requested. |
Contains zeroes. |
0413 |
Amount of Supplemental Claim Requested is required |
|||||||
Record-Level Error |
Amount of Supplemental Claim Requested must not exceed nine times the Amount of Guaranty. |
Amount of Supplemental Claim Requested exceeds nine times the Amount of Guaranty. |
0660 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
5-26-2000 |
Reinsurance Reimbursement Rate |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Character |
1 |
453 |
119 |
||||
Description |
Current Rate at which the government paid a reinsurance or supplemental reinsurance claim to a Guaranty Agency on a specific loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Reinsurance Claim Payment |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
1. The reinsurance claim request occurred before the latest repurchase; 2. The request has been fully paid/processed; and 3. The request has been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Reinsurance Claim Payment occurs. |
||||||||||
Date Revised |
3-01-2005 |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Record-Level Error |
Must be a valid code. |
Invalid code. |
0231 |
Invalid Reinsurance Reimbursement Rate |
|||||||
Record-Level Error |
Must be reported if there is a corresponding value in Date Reinsurance Claim Paid. |
Is blank. |
0391 |
Reinsurance Reimbursement Rate is required |
|||||||
Date Revised |
5-26-2000 |
Date Repurchased |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
454-461 |
120 |
||||
Description |
Date for which a claim has been previously paid is repurchased by a lender, (reasons may include loan rehabilitation). |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Repurchase |
||||||||||
Companion Field(s) |
(127)
(formerly Amount of Refund from Lender on Claims (100)
|
||||||||||
Default Value / Use |
Report ‘00000000’ if repurchase has not occurred. |
||||||||||
Reporting |
Report actual value if repurchase occurs. |
||||||||||
Date Revised |
3-01-2005 |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0306 |
Invalid Date Repurchased |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Indicator of Rehabilitated Loan or Amount Repurchased. |
Contains zeroes. |
0273 |
Date Repurchased is required |
|||||||
Record-Level Error |
Date Repurchased must be on or after the Date of Disbursement. |
Date Repurchased is before the Date of Disbursement. |
0619 |
Date must be = or greater than Date of Disbursement |
|||||||
Record-Level Error |
Date Repurchased must be on or before the Submittal (Extract) Date. |
Date Repurchased is after the Submittal (Extract) Date. |
0620 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date Repurchased must be on or after the Date of Guaranty. |
Date Repurchased is before the Date of Guaranty. |
0639 |
Date must be = or greater than Date of Guaranty |
|||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
|||||||
Date Revised |
6-16-2003 |
Amount Repurchased |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
462-467 |
121 |
||||
Description |
The principal dollar amount of repurchased claims (including repurchases of bankruptcy claims). |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Loan Repurchase |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if repurchase has not occurred. |
||||||||||
Reporting |
Report actual value if repurchase occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0318 |
Invalid Amount Repurchased |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date Repurchased or Indicator of Rehabilitated Loan. |
Contains zeroes. |
0272 |
Amount Repurchased is required |
|||||||
Record-Level Error |
Amount Repurchased must not exceed nine times the Amount of Guaranty. |
Amount Repurchased exceeds nine times the Amount of Guaranty. |
0666 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
3-14-2008 |
Indicator of Rehabilitated Loan |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Character |
1 |
468 |
122 |
|||||
Description |
Indicator that a repurchased loan was a rehabilitated loan (i.e., that a defaulter made 9 payments within 20 days of the due date during a period of 10 consecutive months on the loan and that it was sold to a lender by a Guaranty Agency). |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Loan Repurchase |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report a blank if condition has not occurred. |
|||||||||||
Reporting |
Report ‘Y’ if loan is rehabilitated and repurchased. Report ‘E’ if insurance claim payment was made in error. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be ‘Y’, ‘E’ or blank. |
Contains wrong value. |
0221 |
Invalid Indicator of Rehabilitated Loan |
||||||||
Date Revised |
7-03-2006 |
Date of Guaranty Agency Principal / Interest Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
469-476 |
123 |
||||
Description |
Date when the Guaranty Agency last applied default collections (excluding TOP) or bankruptcy recovery to the loan principal and/or interest. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Collection From Borrower |
||||||||||
Companion Field(s) |
|
||||||||||
Date Revised |
3-01-2005 |
||||||||||
Default Value / Use |
Report ‘00000000’ if Collection From Borrower has not occurred, or if latest collection occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Collection From Borrower occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0297 |
Invalid Date of GA Principal / Interest Collections |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in the Amount of Guaranty Agency Interest Collections or the Amount of Guaranty Agency Principal Collections. |
Contains zeroes. |
0298 |
Date of GA Principal / Interest Collections is required |
|||||||
Record-Level Error |
For non-SL loans, if the loan has not been repurchased or the Date of GA Principle/Interest Collections is on or after Date Repurchased, the Date of GA Principal or Interest Collections must be on or after the Date Entered Repayment. |
Date of GA Principal/Interest Collections is before the Date Entered Repayment. |
0615 |
Date must be = or greater than Date Entered Repayment |
|||||||
Record-Level Error |
Date of GA Principal/Interest Collections must be on or before the Submittal (Extract) Date. |
Date of GA Principal/Interest Collections is after the Submittal (Extract) Date. |
0616 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date of GA Principal/Interest Collections must be on or after the Date of Disbursement. |
Date of GA Principal/Interest Collections is before the Date of Disbursement. |
0646 |
Date must be = or greater than Date of Disbursement |
|||||||
Record-Level Error |
Date of GA Principal/Interest Collections must be on or after the Date of Guaranty. |
Date of GA Principal/Interest Collections is before the Date of Guaranty. |
0647 |
Date must be = or greater than Date of Guaranty |
|||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
|||||||
Date Revised |
6-16-2003 |
Amount of Guaranty Agency Interest Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
477-482 |
124 |
||||
Description |
The cumulative amount of Guaranty Agency default collections (excluding TOP) or bankruptcy recovery applied to loan interest. Amount does not include consolidation loan payoffs or collections that were made prior to repurchase. Collections such as administrative wage garnishment (AWG) and state tax s are included in this field. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Collection From Borrower |
||||||||||
Companion Field(s) |
Relationship established
|
||||||||||
Default Value / Use |
Report ‘000000’ if Collection From Borrower has not occurred, if no part of any collection went to pay off interest, or if latest collection occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Collection From Borrower occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0328 |
Invalid Amount of Guaranty Agency Interest Collections |
|||||||
Record-Level Error |
Amount of GA Interest Collections must not exceed nine times the Amount of Guaranty. |
Amount of GA Interest Collections exceeds nine times the Amount of Guaranty. |
0663 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
6-1-2005 |
Amount of Guaranty Agency Principal Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
483-488 |
126 |
||||
Description |
The cumulative amount of Guaranty Agency default collections (excluding TOP collections) or bankruptcy recovery applied to loan principal. Collections such as administrative wage garnishment (AWG) and state tax offsets are included in this field. Amount does not include; consolidation loan payoffs or collections that were made prior to repurchase. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Collection From Borrower |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if Collection From Borrower has not occurred, if no part of any collection went to pay off principal, or if latest collection occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Collection From Borrower occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0330 |
Invalid Amount of Guaranty Agency Principal Collections |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date of Guaranty Agency Principal / Interest Collections, and zeroes in Amount of Guaranty Agency Interest Collections. |
Contains zeroes. |
0113 |
Amount of Guaranty Agency Principal or Interest Collections is required |
|||||||
Record-Level Error |
Amount of GA Principal Collections must not exceed nine times the Amount of Guaranty. |
Amount of GA Principal Collections exceeds nine times the Amount of Guaranty. |
0662 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
6-1-2005 |
Date of TOP Offset Principal / Interest Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
Yes |
Date |
8 |
489-496 |
127 |
||||
Description |
Date when the Guaranty Agency last applied TOP principal and/or interest collections to a loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
TOP Collection |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if TOP Collection has not occurred, or if latest collection occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if TOP Collection occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0204 |
Invalid Date of TOP Principal/Interest Collections |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in the Amount of the TOP Principal Collections or the Amount of the TOP Interest Collections. |
Contains zeroes. |
0150 |
Date of TOP Principal/Interest Collections required |
|||||||
Record-Level Error |
For non-SL loans, if the loan is not rehabilitated (Indicator of Rehabilitated Loan is not ‘Y’) or the Date of TOP Principal/Interest Collections is after rehabilitation (Date Repurchased), the Date of TOP Principal/Interest Collections must be on or after the Date Entered Repayment. |
Date of TOP Principal/Interest Collections is before the Date Entered Repayment. |
0617 |
Date must be = or greater than Date Entered Repayment |
|||||||
Record-Level Error |
Date of TOP Principal/Interest Collections must be on or before the Submittal(Extract)Dt. |
Date of TOP Principal/Interest Collections is after the Submittal Date. |
0618 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
Date of TOP Principal/Interest Collections must be on or after the Date of Disbursement. |
Date of TOP Principal/Interest Collections is before the Date of Disbursement. |
0648 |
Date must be = or greater than Date of Disbursement |
|||||||
Record-Level Error |
Date of TOP Principal/Interest Collections must be on or after the Date of Guaranty. |
Date of TOP Principal/Interest Collections is before the Date of Guaranty. |
0649 |
Date must be = or greater than Date of Guaranty |
|||||||
Load-Level Error
|
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
|||||||
Date Revised |
3-01-2005 |
Amount of TOP Interest Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
497-502 |
128 |
||||
Description |
The cumulative amount collected and applied to interest through TOP . Amount does not include collections that were made prior to repurchase. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
TOP Collection |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if TOP Collection has not occurred, if no part of the collection went to pay off interest, or if latest collection occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if TOP Collection occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0331 |
Invalid Amount of TOP Interest Collections |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date of TOP Principal / Interest Collections and zeroes in Amount of TOP Principal Collections. |
Contains zeroes. |
0114 |
Amount of TOP Prin or Int Collections is required |
|||||||
Record-Level Error |
Amount of TOP Interest Collections must not exceed nine times the Amount of Guaranty. |
Amount of TOP Interest Collections exceeds nine times the Amount of Guaranty. |
0665 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
3-01-2005 |
Amount of TOP Principal Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
503-508 |
130 |
||||
Description |
The cumulative amount collected and applied to principal through TOP . Amount does not include collections that were made prior to repurchase. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
TOP Collection |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if TOP Collection has not occurred, if no part of the collection went to pay off principal, or if latest collection occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if TOP Collection occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0332 |
Invalid Amount of TOP Principal Collections |
|||||||
Record-Level Error |
Amount of TOP Principal Collections must not exceed nine times the Amount of Guaranty. |
Amount of TOP Principal Collections exceeds nine times the Amount of Guaranty. |
0664 |
Amount must be = or less than nine times Amount of Guaranty |
|||||||
Date Revised |
3-01-2005 |
Date Enrollment Status Effective |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Date |
8 |
509-516 |
131 |
|||||
Description |
Date when a student entered current enrollment status, as reported through the enrollment reporting or other status updates. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Enrollment Status |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
|
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0304 |
Invalid Date Enrollment Status Effective |
||||||||
Record-Level Error |
Can’t be zeroes unless Type of Loan is ‘CL’ or ‘RF’ and Code for Enrollment Status is blank. |
Contains zeroes. |
0134 |
Date Enrollment Status Effective is required |
||||||||
Record-Level Error |
Plug date ‘19000101’ not reported on Loan Guaranteed after January 1, 1984. |
Contains wrong value. |
0230 |
‘19000101’ invalid when DT of GA > = ‘19840101’ |
||||||||
Record-Level Error |
If the Enrollment Status is F or H, the Date Enrollment Status Effective must be on or after the Date of Guaranty less 15 years. |
Date Enrollment Status Effective is before the Date of Guaranty less 15 years. |
0626 |
For F/H Enroll Status, Dt must be >= Date of Guaranty - 15 yrs |
||||||||
Record-Level Error |
Date Enrollment Status Effective must be on or after the date of inception of the HEA (19651108). |
Date Enrollment Status Effective is before the date of inception of the HEA (19651108). |
0627 |
Date must be = or greater than 19651108 |
||||||||
Record-Level Error |
Date Enrollment Status Effective must be on or before the Submittal (Extract) Date plus two years. |
Date Enrollment Status Effective is after the Submittal (Extract) Date plus two years. |
0628 |
Date must be = or less than Submittal Date + two years |
||||||||
Date Revised |
5-26-2000 |
Code for Enrollment Status |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Character |
1 |
517 |
132 |
|||||
Description |
Code indicating student’s current enrollment status, as reported through the enrollment reporting or other status updates. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Enrollment Status |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. (Report a blank for ‘CL’ or ‘RF’ loans.) |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be reported if Type of Loan is not ‘CL’ or ‘RF’ or Date Enrollment Status Effective contains a value. |
Is blank. |
0129 |
Code for Enrollment Status is required |
||||||||
Record-Level Error |
If not blank, must be a valid code from Enrollment Status Codes Table. |
Invalid code. |
0176 |
Invalid Code for Enrollment Status |
||||||||
Record-Level Error |
If Date of Guaranty is Jan. 1, 1984 or later, then ‘N’ is invalid. |
Contains wrong value. |
0237 |
Invalid value when Date of Guaranty is greater than or equal to 19840101 |
||||||||
Date Revised |
5-26-2000 |
Date of Anticipated Completion |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Date |
8 |
518-525 |
133 |
|||||
Description |
Date when a student is scheduled to complete course requirements (with degree programs, this is projected graduation date). |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. (May report ‘00000000’ for ‘CL’ (Consolidated) or ‘RF’ (Refinanced) loans.) |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0295 |
Invalid Date of Anticipated Completion |
||||||||
Record-Level Error |
If Date of Guaranty is Jan. 1, 1984 or later, then ‘19000101’ is invalid. |
Contains wrong value. |
0230 |
19000101 is invalid value when Date of GA > or = 19840101 |
||||||||
Record-Level Error |
Can’t be zeroes if Type of Loan is other than ‘CL’ or ‘RF’. |
Contains zeroes. |
0296 |
Date of Anticipated Completion is required |
||||||||
Record-Level Error |
Date of Anticipated Completion must be on or after the inception of the HEA (19651108). |
Date of Anticipated Completion is before the inception of the HEA (19651108). |
0623 |
Date must be = or greater than 19651108 |
||||||||
Record-Level Error |
Date of Anticipated Completion must be on or before the Submittal (Extract) Date plus 15 years. |
Date of Anticipated Completion is after the Submittal (Extract) Date plus 15 years. |
0624 |
Date must be = or less than Submittal Date + 15 years |
||||||||
Date Revised |
5-26-2000 |
Code for Current Holder Lender |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Numeric |
6 |
526-531 |
134 |
|||||
Description |
ED code indicating current holder of a loan or (if a claim has been paid) the lender who submitted the claim.. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Holder Lender |
|||||||||||
Companion Field(s) |
Related field that checks value here
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0178 |
Invalid Code for Current Holder Lender |
||||||||
Record-Level Error |
Must be reported. |
Contains zeroes. |
0103 |
Code for Current Holder Lender is required |
||||||||
Record-Level Error |
Value falls in range of ‘800000’ to ‘999899’, and not ‘444444’. |
Invalid code. |
0178 |
Invalid Code for Current Holder Lender |
||||||||
Record-Level Error |
If the Date of Guaranty is earlier than Jan. 1, 1984, then it may be ‘444444’. |
Contains wrong value. |
0237 |
Invalid value when Dt of GA > or = 19840101 |
||||||||
Load-Level Error |
Must be a valid code from the ED Lender Code Table. |
Invalid code. |
0178 |
Invalid Code for Current Holder Lender |
||||||||
Date Revised |
5-26-2000 |
Date of Outstanding Principal Balance |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Date |
8 |
532-539 |
135 |
||||
Description |
Date when Amount of Outstanding Principal Balance field was updated or verified. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date. |
Invalid date. |
0305 |
Invalid Date of Outstanding Principal Balance |
|||||||
Record-Level Error |
Cannot be zeroes. |
Contains zeroes. |
0157 |
Date of Outstanding Principal Balance is required |
|||||||
Record-Level Error |
Date of Outstanding Principal Balance must be on or after the Date of Guaranty. |
Date of Outstanding Principal Balance is before the Date of Guaranty. |
0629 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
For non-CA Loan Status, Date of Outstanding Principal Balance must be on or before the Submittal (Extract) Date. |
Date of Outstanding Principal Balance is after the Submittal (Extract) Date. |
0630 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
For CA Loan Status, the Date of Outstanding Principal Balance must be on or before the later of (a) the Date of Guaranty plus two years or (b) the Submittal (Extract) Date. |
Date of Outstanding Principal Balance is after the later of (a) the Date of Guaranty plus two years or (b) the Submittal (Extract) Date. |
0707 |
For CA Loan Stat, must be <= Dt of Guar + 2yr or <= Submittal Dt |
|||||||
Load-Level Error |
For all open loans and any closed loans where Date of Outstanding Principal Balance is not equal to Date of Loan Status, Date of Outstanding Principal Balance must be on or after prior Date of Outstanding Principal Balance. |
Date of Outstanding Principal Balance is before prior Date of Outstanding Principal Balance. |
729 |
Date of Outstanding Principal Balance may not precede multiple, previously reported dates. |
|||||||
Load-Level Error |
For all open loans and any closed loans where Date of Outstanding Principal Balance is not equal to Date of Loan Status, if Date or Amount of Outstanding Principal Balance has changed, the Date of Outstanding Principal Balance must be after any Date of Outstanding Principal Balance that was first reported to NSLDS prior to the start of the prior quarter. |
Date of Outstanding Principal Balance is before any Date of Outstanding Principal Balance that was first reported to NSLDS prior to the start of the prior quarter. |
730 |
Based on time of reporting, later Date of Outstanding Principal Balance is required. |
|||||||
Date Revised |
4-05-2007 |
Amount of Outstanding Principal Balance |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
Yes |
No |
Numeric |
6 |
540-545 |
136 |
|||||
Description |
The cumulative dollar value of the outstanding principal balance due on a loan, including capitalized interest. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
|
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0313 |
Invalid Amount of Outstanding Principal Balance |
||||||||
Record-Level Error |
Amount of Outstanding Principal Balance must not exceed nine times the Amount of Guaranty. |
Amount of Outstanding Principal Balance exceeds nine times the Amount of Guaranty. |
0653 |
Amount must be = or less than nine times Amount of Guaranty |
||||||||
Load-Level Error |
Whether open loans disbursed for more than one quarter have a positive balance. |
The sum of the Outstanding Principal Balance, Amount of Outstanding Accrued Interest Balance, and Amount of Ending Balance on Claims on Other Fees is not positive. |
0120 |
Sum of (OPB + OIB + Fees) must be > zero |
||||||||
Load-Level Error |
Must be zero if Code for Loan Status is ‘BC’, ‘CA’, ‘CS’, ‘DC’, ‘DD’, ‘DE’, ‘DK’, ‘DN’, ‘DR’, ‘DP’, ‘FC’, ‘FX’, ‘OD’, ‘PC’, ‘PF’, ‘PM’, ‘PN’, ‘PZ’, ‘RF’, ‘UC’, or ‘UD’. |
Value is not zero.
|
0313 |
Invalid Amount of Outstanding Principal Balance |
||||||||
Date Revised |
8-26-2008 |
Date of Outstanding Accrued Interest Balance |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Date |
8 |
546-553 |
137 |
||||
Description |
Date through which the reported Amount of Outstanding Accrued Interest Balance was accrued. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not part of an event. |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Must always be filled. |
||||||||||
Reporting |
Report actual value if condition occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain- Level Error |
Must be a valid date. |
Invalid date. |
0206 |
Invalid Date of Outstanding Accrued Interest Balance |
|||||||
Record-Level Error |
Can’t be zeroes. |
Contains zeroes. |
0156 |
Date of Outstanding Accrued Interest Balance is required |
|||||||
Record-Level Error |
Date of Outstanding Accrued Interest Balance must be on or after the Date of Guaranty. |
Date of Outstanding Accrued Interest Balance is before the Date of Guaranty. |
0631 |
Date must be = or greater than Date of Guaranty |
|||||||
Record-Level Error |
For non-CA Loan Status, Date of Outstanding Accrued Interest Balance must be on or before the Submittal (Extract) Date. |
Date of Outstanding Accrued Interest Balance is after the Submittal (Extract) Date. |
0632 |
Date must be = or less than Submittal Date |
|||||||
Record-Level Error |
For CA Loan Status, the Date of Outstanding Accrued Interest Balance must be on or before the later of (a) the Date of Guaranty plus two years or (b) the Submittal (Extract) Date. |
Date of Outstanding Accrued Interest Balance is after the later of (a) the Date of Guaranty plus two years or (b) the Submittal (Extract) Date. |
0708 |
For CA Loan Stat, must be <= Dt of Guar + 2yr or <= Submittal Dt |
|||||||
Load-Level Error |
For all open loans and any closed loans where Date of Outstanding Accrued Interest Balance is not equal to Date of Loan Status, Date of Outstanding Accrued Interest Balance must be on or after prior Date of Outstanding Accrued Interest Balance. |
Date of Outstanding Accrued Interest Balance is before prior Date of Outstanding Accrued Interest Balance. |
731 |
Date of Outstanding Accrued Interest Balance may not precede multiple, previously reported dates. |
|||||||
Load-Level Error |
For all open loans and any closed loans where Date of Outstanding Accrued Interest Balance is not equal to Date of Loan Status, if Date or Amount of Outstanding Accrued Interest Balance has changed, the Date of Outstanding Accrued Interest Balance must be after any Date of Outstanding Accrued Interest Balance that was first reported to NSLDS prior to the start of the prior quarter. |
Date of Outstanding Accrued Interest Balance is before any Date of Outstanding Accrued Interest Balance that was first reported to NSLDS prior to the start of the prior quarter. |
732 |
Based on time of reporting, later Date of Outstanding Accrued Interest Balance is required. |
|||||||
Date Revised |
4-05-2007 |
Amount of Outstanding Accrued Interest Balance |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
Yes |
No |
Numeric |
6 |
554-559 |
138 |
|||||
Description |
The cumulative dollar value of the borrower’s outstanding accrued interest balance. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. (Report ‘000000’ if condition has not occurred or if balance is not available.) |
|||||||||||
Reporting |
Report actual value if condition occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0316 |
Invalid Amount of Outstanding Accrued Interest Balance |
||||||||
Record-Level Error |
Amount of Outstanding Accrued Interest Balance must not exceed nine times the Amount of Guaranty. |
Amount of Outstanding Accrued Interest Balance exceeds nine times the Amount of Guaranty. |
0654 |
Amount must be = or less than 9 times Amount of Guaranty |
||||||||
Date Revised |
5-26-2000 |
Date Loan Sold |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
Yes |
Date |
8 |
560-567 |
141 |
|||||
Description |
Date when a loan was sold by one lender to another, as reported by the receiving lender. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Holder Lender |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. (Report ‘00000000’ if loan has not been sold by one lender to another.) |
|||||||||||
Reporting |
Report actual value if sale occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0197 |
Invalid Date Loan Sold |
||||||||
Record-Level Error |
Whether a loan has different values in Code for Current Holder Lender and Originating FFELP Lender. |
Contains zeroes. |
0542 |
Date Loan Sold is required |
||||||||
Record-Level Error |
Date Loan Sold must be on or after the Date of Guaranty. |
Date Loan Sold is before the Date of Guaranty. |
0597 |
Date must be = or greater than Date of Guaranty |
||||||||
Record-Level Error |
Date Loan Sold must be on or before the Submittal (Extract) Date. |
Date Loan Sold is after the Submittal (Extract) Date. |
0598 |
Date must be = or less than Submittal Date |
||||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
||||||||
Date Revised |
3-02-2007 |
Indicator of Origination Fee Payor |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
568 |
142 |
|||||
Description |
Indicator that the current lender paid the origination fee on a loan. Reported to the Guaranty Agency by the lender that paid the fee. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Holder Lender |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report a blank if condition has not occurred. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be ‘Y’ or blank. |
Contains wrong value. |
0255 |
Invalid Ind of Origination Fee Payor |
||||||||
Date Revised |
5-26-2000 |
Interest Rate |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Numeric |
5 |
569-573 |
143 |
|||||
Description |
The original interest rate on a loan, unless the loan was subject to a rebate of excess interest and was converted from a fixed rate to a variable rate through that process or was refinanced (PLUS or SLS) to secure a variable rate. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric, or isn’t five digits long. |
0308 |
Invalid Interest Rate |
||||||||
Record-Level Error |
Cannot be zeroes unless Type of Interest is ‘V’. |
Contains zeroes. |
0266 |
Interest Rate is required |
||||||||
Record-Level Error |
Is zeroes when Type of Interest is ‘V’. |
Is not zeroes. |
0308 |
Invalid Interest Rate |
||||||||
Date Revised |
5-26-2000 |
Type of Interest Rate |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
574 |
144 |
|||||
Description |
Code indicating type of interest rate on a loan. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must be a valid code from the Interest Rate Codes Table. |
Invalid code. |
0240 |
Invalid Type of Interest Rate |
||||||||
Record-Level Error |
Must be reported. |
Is blank. |
0309 |
Type of Interest Rate is required |
||||||||
Date Revised |
5-26-2000 |
Date of Guaranty Agency Bankruptcy Claim Refunds |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
Yes |
Yes |
Date |
8 |
575-582 |
145 |
|||||
Description |
Date when a bankruptcy claim (previously paid as a reinsurance claim) was refunded to ED by a Guaranty Agency. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Bankruptcy Claim Refund |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Report ‘00000000’ if Bankruptcy Claim Refund has not occurred, or if latest refund occurred before repurchase and it has already been successfully reported to NSLDS. |
|||||||||||
Reporting |
Report actual value if Bankruptcy Claim Refund occurs. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0200 |
Invalid Date of GA Bankruptcy Claim Refunds |
||||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Amount of Guaranty Agency Bankruptcy Claim Refunds. |
Contains zeroes. |
0146 |
Date of GA Bankruptcy Claim Refunds is required |
||||||||
Record-Level Error |
If the Date of Guaranty Agency Bankruptcy Claim Refunds is after the Date Repurchased, it must be on or after the Date Reinsurance Claim Requested. |
Date of Guaranty Agency Bankruptcy Claim Refunds is before the Date Reinsurance Claim Requested. |
0613 |
Date must be = or > Date Reinsurance Claim Requested |
||||||||
Record-Level Error |
Date of Guaranty Agency Bankruptcy Claim Refunds must be on or before the Submittal (Extract) Date. |
Date of Guaranty Agency Bankruptcy Claim Refunds is after the Submittal (Extract) Date. |
0614 |
Date must be = or less than Submittal Date |
||||||||
Record-Level Error |
Date of Guaranty Agency Bankruptcy Claim Refunds must be on or after the Date of Guaranty. |
Date of Guaranty Agency Bankruptcy Claim Refunds is before the Date of Guaranty. |
0637 |
Date must be = or greater than Date of Guaranty |
||||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
||||||||
Date Revised |
5-26-2000 |
Amount of Guaranty Agency Bankruptcy Claim Refunds |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
Yes |
No |
Numeric |
6 |
583-588 |
146 |
||||
Description |
The cumulative amount remitted to ED for bankruptcy claim refund(s) on a loan. A guarantor refunds reinsurance to ED after the following sequence of events: the guarantor pays a bankruptcy claim to a lender before the bankruptcy court decides whether the loan is discharged, the guarantor collects reinsurance from ED, and the loan is not discharged by bankruptcy court. Amount does not include refunds that were made prior to repurchase. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Bankruptcy Claim Refund |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘000000’ if Bankruptcy Claim Refund has not occurred, or if latest refund occurred before repurchase and it has already been successfully reported to NSLDS. |
||||||||||
Reporting |
Report actual value if Bankruptcy Claim Refund occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be numeric. |
Isn’t numeric. |
0315 |
Invalid Amount of Guaranty Agency Bankruptcy Claim Refunds |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Date of Guaranty Agency Claim Refunds. |
Contains zeroes. |
0110 |
Amount of Guaranty Agency Bankruptcy Claim Refunds is required |
|||||||
Record-Level Error |
Amount of GA Bankruptcy Claim Refunds must not exceed nine times the Amount of Guaranty. |
Amount of GA Bankruptcy Claim Refunds exceeds nine times the Amount of Guaranty. |
0661 |
Amount must be = or less than 9 times Amount of Guaranty |
|||||||
Date Revised |
5-26-2000 |
Filler Formerly Date of Supplemental Pre-Claims Assistance Payment |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Date |
8 |
589-596 |
147 |
||||
Description |
This field is no longer required as of October 1, 2000. All edits have been removed. Until you make system changes, you may continue to populate this field as before, but any data submitted will be ignored by NSLDS. |
||||||||||
Comments |
Not applicable. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
6-16-2003 |
Filler Formerly Amount of Supplemental Pre-Claims Assistance Payment |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
6 |
597-602 |
148 |
||||
Description |
This field is no longer required as of October 1, 2000. All edits have been removed. Until you make system changes, you may continue to populate this field as before, but any data submitted will be ignored by NSLDS. |
||||||||||
Comments |
Not applicable. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
6-16-2003 |
Indicator of Subsidy |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
603 |
149 |
|||||
Description |
Indicates whether a Stafford loan with a Date Enrollment Period Begins before October 1, 1992 is eligible for interest subsidy from ED. |
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
Not part of an event. |
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
|
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Record-Level Error |
Must contain ‘Y’, ‘N’, or a blank. |
Contains wrong value. |
0220 |
Invalid Indicator of Subsidy |
||||||||
Record-Level Error |
Must be ‘Y’ or ‘N’ if Type of Loan is ‘SF’ and the Date Enrollment Period Begins is before Oct. 1, 1992. |
Contains wrong value. |
0417 |
Indicator of Subsidy is required |
||||||||
Date Revised |
5-26-2000 |
Date of Servicer Responsibility |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
Yes |
No |
Yes |
Date |
8 |
604-611 |
150 |
||||
Description |
Date when a lender servicer assumes responsibility for servicing a loan. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Lender Servicer |
||||||||||
Companion Field(s) |
|
||||||||||
Default Value / Use |
Report ‘00000000’ if loan is not currently being serviced. |
||||||||||
Reporting |
Report actual value if change in Lender Servicer occurs. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
Domain-Level Error |
Must be a valid date (if not zeroes). |
Invalid date. |
0389 |
Invalid Date of Servicer Responsibility |
|||||||
Record-Level Error |
Can’t be zeroes if there is a corresponding value in Code for Servicer. |
Contains zeroes. |
0394 |
Date of Servicer Responsibility is required |
|||||||
Record-Level Error |
Date of Lender Servicer Responsibility must be on or after the Date of Guaranty less one year. |
Date of Lender Servicer Responsibility is before the Date of Guaranty less one year. |
0595 |
Date must be = or greater than Date of Guaranty - 1 year |
|||||||
Record-Level Error |
Date of Lender Servicer Responsibility must be on or before the Submittal (Extract) Date. |
Date of Lender Servicer Responsibility is after the Submittal (Extract) Date. |
0596 |
Date must be = or less than Submittal Date |
|||||||
Load-Level Error |
Date change falls in acceptable range in relation to historical data. |
Date sequence error. |
0525 |
Date must be > preceding date |
|||||||
Date Revised |
5-26-2000 |
Code for Current School |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
Yes |
No |
No |
Numeric |
8 |
612-619 |
102 |
|||||
Description |
|
|||||||||||
Comments |
|
|||||||||||
Part of Event Type |
|
|||||||||||
Companion Field(s) |
|
|||||||||||
Default Value / Use |
Must always be filled. |
|||||||||||
Reporting |
Report in regular update. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
Domain-Level Error |
Must be numeric. |
Contains wrong value. |
0169 |
Invalid Code for Current School |
||||||||
Record-Level Error |
Must be reported. |
Contains zeroes. |
0143 |
Code for Current School is required |
||||||||
Record-Level Error |
‘88888800’ only used when Loan Type is ‘CL’. |
Contains wrong value. |
0169 |
Invalid Code for Current School |
||||||||
Record-Level Error |
‘88888811’ only used when Loan Type is ‘RF’. |
Contains wrong value. |
0169 |
Invalid Code for Current School |
||||||||
Record-Level Error |
If Date of Guaranty is Jan. 1, 1984 or later, then ‘99999900’ is not valid. |
Contains wrong value. |
0237 |
Invalid value when Dt of GA > or = 19840101 |
||||||||
Load-Level Error |
Must be valid OPE code. |
Invalid code. |
0169 |
Invalid Code for Current School |
||||||||
Date Revised |
5-26-2000 |
Data Provider Identifier |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
N/A |
No |
No |
Character |
21 |
620-640 |
193 |
||||
Description |
Loan identifier assigned by data provider. |
||||||||||
Comments |
Populate with the loan identifier used in the data provider’s system of records. The contents of this field are preserved in NSLDS. The identifier should be unique for each loan. The Data Provider Identifier is passed back to you on the Load Process Error file and Loan Detail files provided by NSLDS. This is a character field enabling use of both alpha and numeric characters. There are no edits applied to this field. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Populate with spaces or your unique loan identifier. |
||||||||||
Reporting |
Report in regular update. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
This section contains specific Trailer Record Layout details for each record.
Code for Guaranty Agency |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Numeric |
3 |
1-3 |
250 |
|||||
Description |
Identification code for Guaranty Agency. |
|||||||||||
Comments |
The Trailer Record is created by DataPrep software during Extract Validation process. It is populated with the Code for Guaranty Agency found in the Header record. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Sort Social Security Number |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
9 |
4-12 |
255 |
|||||
Description |
Positional sort field used for sorting the Trailer Record to the bottom of the file. |
|||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. This field is populated with high values. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Number of Records With Domain Errors |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
N/A |
No |
N/A |
Numeric |
9 |
13-21 |
251 |
||||
Description |
Total number of records with domain errors found in the Extract Validation process. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Filler |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Character |
9 |
22-30 |
N/A |
||||
Description |
This field is no longer used. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of Records With Domain, Record and Load-Level Errors |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
9 |
31-39 |
253 |
||||
Description |
Total number of records with domain, record, or load-level errors found during the Load process at NSLDS. |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of Detail Records |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
N/A |
No |
N/A |
Numeric |
9 |
40-48 |
254 |
||||
Description |
Total number of Detail Records included in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of PPC Records |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
N/A |
No |
N/A |
Numeric |
9 |
49-57 |
256 |
||||
Description |
Total number of PPC records included in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Filler |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
N/A |
No |
N/A |
Character |
3 |
58-60 |
257 |
|||||
Description |
This field is not used. |
|||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Record Type Indicator |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
1 |
61 |
029 |
|||||
Description |
Establishes this record as a Trailer Record. |
|||||||||||
Comments |
This field is set to T by the DataPrep software during the Extract Validation process. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Number of Detail Records in Submittal |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Numeric |
9 |
62-70 |
258 |
|||||
Description |
Total number of Detail Records contained in the Submittal file. |
|||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
Number of PPC Records in Submittal |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
9 |
71-79 |
259 |
||||
Description |
Total number of PPC records contained in the Submittal file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of Forced Records |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
9 |
80-88 |
260 |
||||
Description |
Number of Detail Records in the Submittal file that the data provider has “forced” through the Delta process (i.e., data provider populated the Action Code field (030) on the Detail Record with an F). |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of PPC Deletes |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
N/A |
No |
N/A |
Numeric |
9 |
89-97 |
261 |
||||
Description |
Number of PPC records in the Submittal file that will delete a loan from NSLDS (i.e., data provider populated the Action Code field (161) on the PPC Record with a D). |
||||||||||
Comments |
|
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of Add Records |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
9 |
98-106 |
262 |
||||
Description |
Number of Detail Records in the Submittal file that contain new loans. |
||||||||||
Comments |
The DataPrep software during the Delta process populates this field. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of Change Records |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
9 |
107-115 |
263 |
||||
Description |
Number of Detail Records in the Submittal file that contain updated information on loans previously reported to NSLDS. |
||||||||||
Comments |
The DataPrep software during the Delta process populates this field. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Number of Open Loans |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
9 |
116-124 |
264 |
||||
Description |
Total number of records in the Database Extract file that are in an open loan status. See Appendix B– Table B-10 to determine which loan status codes are considered open. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Guaranty |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
125-136 |
265 |
||||
Description |
Sum of the Amount of Guaranty field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Disbursement |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
137-148 |
266 |
||||
Description |
Sum of the Amount of Disbursement field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Cancellation |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
149-160 |
267 |
||||
Description |
Sum of the Amount of Cancellation field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of School Refund |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
161-172 |
268 |
||||
Description |
Sum of the Amount of School Refund field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Outstanding Principal Balance |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
173-184 |
269 |
||||
Description |
Sum of the Amount of Outstanding Principal Balance field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Accrued Interest Balance |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
185-196 |
270 |
||||
Description |
Sum of the Amount of Accrued Interest Balance field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Outstanding GA fees Balance Formerly Amount of Ending Balance on Claim of Other Fees |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
197-208 |
271 |
||||
Description |
Sum of the Amount of Ending Balance on Claim of Other Fees field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Claim Paid to Lender |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
209-220 |
272 |
||||
Description |
Sum of the Amount of Claim Paid to Lender field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Reinsurance Claim Requested |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
221-232 |
273 |
||||
Description |
Sum of the Amount of Reinsurance Claim Requested filed for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount of Guaranty Agency Principal Collections |
|||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
233-244 |
274 |
||||
Description |
Sum of the Amount of Guaranty Agency Principal Collections field for all open loan records in the Database Extract file. |
||||||||||
Comments |
The Trailer Record is created by DataPrep software during the Extract Validation process. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Loan Total: Amount Repurchased |
|||||||||||
Loan Identifier |
History |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
||||
No |
No |
No |
No |
Numeric |
12 |
245-256 |
275 |
||||
Description |
Sum of the Amount Repurchased field for all open loan records in the Database Extract file. |
||||||||||
Comments |
This number is populated during the Load Process and included on the Load Process Error file Trailer Record. |
||||||||||
Part of Event Type |
Not applicable. |
||||||||||
Companion Field(s) |
Not applicable. |
||||||||||
Default Value / Use |
Not applicable. |
||||||||||
Reporting |
Not applicable. |
||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
|||||||
N/A |
N/A |
N/A |
N/A |
N/A |
|||||||
Date Revised |
5-26-2000 |
Filler |
||||||||||||
Loan Identifier |
History Kept |
Reason-ability |
Date Sequence Edit |
Type |
Size |
Position |
Field Code |
|||||
No |
No |
No |
No |
Character |
348 |
257-640 |
N/A |
|||||
Description |
Blank field to complete record length. |
|||||||||||
Comments |
Not applicable. |
|||||||||||
Part of Event Type |
Not applicable. |
|||||||||||
Companion Field(s) |
Not applicable. |
|||||||||||
Default Value / Use |
Not applicable. |
|||||||||||
Reporting |
Not applicable. |
|||||||||||
Edit Level |
Verifies |
Error |
Error No. |
Error Message |
||||||||
N/A |
N/A |
N/A |
N/A |
N/A |
||||||||
Date Revised |
5-26-2000 |
January 15, 2013 Version 4.6
File Type | application/vnd.openxmlformats-officedocument.wordprocessingml.document |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |