Valerie Sherrer, NSLDSFSA

1
NSLDS WORKGROUP MEETING
Guaranty Agency Data Provider Instructions

• Valerie Sherrer, NSLDS/FSA
• Dennis Kemp, AEM

March 2005
2
Guaranty Agency Data Provider Instructions
Overview Reasonability Fields
3
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Introduction (What is NSLDS?)
• GA responsibilities
• Extracting data (DataPrep)
• Submitting data to NSLDS
• NSLDS load process

March 2005
4
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix A
• Data Dictionary
• Data element index list (position, field code
  number, alphabetically)

March 2005
5
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix A Layout Descriptions
• Loan Identifier
• History Kept
• Reasonability
• Data Sequence Edit
• Type
• Size
• Position
• Field Code

March 2005
6
(No Transcript)
7
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix A Layout Descriptions
• Description
• Comments
• Part of Event Type
• Companion Fields
• Default Value/Use
• Reporting

March 2005
8
(No Transcript)
9
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix A Layout Descriptions
• Edit Level
• Verifies
• Error
• Error Number
• Error Message

March 2005
10
(No Transcript)
11
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix B Coding Tables
• Data Elements from Appendix A
• Loan Status, Claim Reason, Academic Level , etc.
  

March 2005
12
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix C Past Period Change Record Layout
• Delete previously reported events that were
  reported in error
• Correcting historical data that cannot be
  corrected by adjusting current data
• Delete a previously reported loan where the
  never existed
• PPC record layout
• PPC Events

March 2005
13
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Appendix D Load Process Error File
• Error Record
• SSN Conflict Error Record
• Appendix E
• Threshold, Error Code and Field Code file (TEF
  file)
• Appendix F
• Glossary

March 2005
14
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Reasonability Fields
• Reinsurance Reimbursement Rate (field code 119)
• Current rate at which the government paid a
  reinsurance claim or supplemental reinsurance
  claim to a Guaranty Agency on a specific loan.
• This rate may change if the reason for
  reinsurance or supplemental reinsurance is due
  to a change in claim status.
• Amount of Claim Paid to Lender (field code 107)
• The cumulative amount of principal and interest
  including any additional principal and interest
  paid on the claim to a lender.
• Do not include Closed School or False
  Certification claims paid to directly borrowers.

March 2005
15
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Reasonability Fields
• Amount of Guaranty Agency Interest Collections
  (field code 124)
• Amount of Guaranty Agency Principal Collections
  (field code 126)
• Amount does not include Consolidation Loan
  Payoffs
• If GA receives payment on behalf of the
  borrower, from any source, after reinsurance has
  been paid report as collection.

March 2005
16
NSLDS WORKGROUP MEETING

• Guaranty Agency Data Provider Instructions
• Reasonability Fields
• Amount of Refund on Claims, formerly Amount of
  Refund from Lender on Claims (field code 100)
• The cumulative dollar amount of refund(s) on a
  claim originally paid to a lender. A refund
  occurs when the GA receives a borrower payment
  from the lender after an insurance claim was
  paid and before ED has paid reinsurance.
• If GA receives a borrower payment from the
  lender after the insurance claim was paid but
  prior to reinsurance request report as refund and
  reduce Amount of Reinsurance Requested
• If GA receives a borrower payment from the
  lender after ED has paid reinsurance report as
  collections

March 2005
17

• Guaranty Agency Data Provider Instructions
• Reasonability Fields
• Amount of Reinsurance Claim Requested (field
  code 116)
• The total amount of original and additional
  reinsurance claim requested of ED by a GA
• Amount of Supplemental Claim Requested (Change
  of Status, field code 118)
• 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 Repurchased (field code 121)
• The total (non-cumulative) dollar amount of
  repurchased claims for which the GA is making a
  full refund of reinsurance.

18

• Guaranty Agency Data Provider Instructions
• Reasonability Fields
• Claims Reason for Guaranty Agency Claim (field
  code 096)
• Update this field whenever there is change in the
  reason (maybe non-monetary) for reinsurance or
  supplemental reinsurance.
• Date Claim Paid (field code 106)
• Date when GA paid an original insurance claim or
  the date of any additional claims to a lender.
• Date of Refund on Claims, formerly Date of Refund
  from Lender on Claims (field code 99)
• If GA receives a borrower payment from the lender
  after the an insurance claim was paid but prior
  to reinsurance request, report the date of
  refund.

19

• Guaranty Agency Data Provider Instructions
• Reasonability Fields
• Date Reinsurance Claim Paid (field code 115)
• Electronic Funds Transfer Date
• Date Reinsurance Claim Requested (field code 114)
• Report the month end date (the last calendar day
  of the month) that equals the fiscal month of the
  Guaranty Agency Financial Report for which
  reinsurance is requested.

20
Contact NSLDS at 1-800-999-8219 orvia e-mail
atNSLDS_at_pearson.com