**LPIF Difference File Record Layouts**

GA LPIF Header Record Layout Length = 400

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**      **Description**                 **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ------------------ ------------------------------- ---------- ---------
  1       9       Record Sequence    Positional sort field for       Num.       9
                  Number             sorting the header record to               
                                     the top of the file. Set the               
                                     value to all zeroes:                       
                                     '000000000'.                               

  10      12      Code for GA        Identification code for         Char.      3
                                     guaranty agency.                           

  13      20      Report Begin Date  Start date of quarter; CCYYMMDD Date       8
                                     format.                                    

  21      28      Report End Date    End date of quarter; CCYYMMDD   Date       8
                                     format.                                    

  29      29      Filler             Space                           Char.      1

  30      37      Create Date        Date that the file is created;  Date       8
                                     CCYYMMDD format.                           

  38      45      Create Time        Time when the file is created;  Char.      8
                                     HH:MM:SS format.                           

  46      75      File Description   'GA LPIF DETAIL HEADER'         Char.      30

  76      400     Filler             Spaces                          Char.      325
  ---------------------------------------------------------------------------------------

GA LPIF Detail Record Layout Length = 400

+---+---+---------------------+---------------------------+------+---+
| * | * | **Attribute**       | **Description**           | **F  | * |
| * | * |                     |                           | ield | * |
| P | P |                     |                           | Form | L |
| o | o |                     |                           | at** | t |
| s | s |                     |                           |      | h |
| F | T |                     |                           |      | * |
| R | O |                     |                           |      | * |
| * | * |                     |                           |      |   |
| * | * |                     |                           |      |   |
+===+===+=====================+===========================+======+===+
| 1 | 9 | Student's Social    | Title IV aid recipient or | C    | 9 |
|   |   | Security Number     | beneficiary's SSN.        | har. |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | Date of Student's   | Date when a Title IV aid  | Date | 8 |
| 0 | 7 | Birth               | recipient or beneficiary  |      |   |
|   |   |                     | was born; CCYYMMDD        |      |   |
|   |   |                     | format.                   |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 2 | Student's First     | Title IV aid recipient or | C    | 1 |
| 8 | 9 | Name                | beneficiary's first name. | har. | 2 |
+---+---+---------------------+---------------------------+------+---+
| 3 | 6 | Student's Last Name | Title IV aid recipient or | C    | 3 |
| 0 | 4 |                     | beneficiary's last name.  | har. | 5 |
+---+---+---------------------+---------------------------+------+---+
| 6 | 6 | Type of Loan        | Code indicating type of   | C    | 2 |
| 5 | 6 |                     | aid received or           | har. |   |
|   |   |                     | guaranteed:               |      |   |
|   |   |                     |                           |      |   |
|   |   |                     | SF---Stafford\            |      |   |
|   |   |                     | SU---Unsubsidized         |      |   |
|   |   |                     | Stafford\                 |      |   |
|   |   |                     | PL---PLUS\                |      |   |
|   |   |                     | CL---Consolidated         |      |   |
|   |   |                     |                           |      |   |
|   |   |                     | Detail is provided for    |      |   |
|   |   |                     | consolidated but is not   |      |   |
|   |   |                     | used for fee computation. |      |   |
+---+---+---------------------+---------------------------+------+---+
| 6 | 7 | Date of Guaranty    | Date the FFEL loan was    | Date | 8 |
| 7 | 4 |                     | originally guaranteed;    |      |   |
|   |   |                     | CCYYMMDD format.          |      |   |
+---+---+---------------------+---------------------------+------+---+
| 7 | 7 | Indicator of        | Indicators used to        | C    | 1 |
| 5 | 5 | Separate Loan       | differentiate among       | har. |   |
|   |   |                     | multiple loans of the     |      |   |
|   |   |                     | same type that have the   |      |   |
|   |   |                     | same guaranty date for    |      |   |
|   |   |                     | the same student          |      |   |
|   |   |                     | attending the same        |      |   |
|   |   |                     | school.                   |      |   |
+---+---+---------------------+---------------------------+------+---+
| 7 | 8 | Code for Original   | ED Office of              | C    | 8 |
| 6 | 3 | School              | Postsecondary Education   | har. |   |
|   |   |                     | (OPE) code for school     |      |   |
|   |   |                     | where a student was       |      |   |
|   |   |                     | enrolled or accepted for  |      |   |
|   |   |                     | enrollment at the time    |      |   |
|   |   |                     | the loan was made.        |      |   |
+---+---+---------------------+---------------------------+------+---+
| 8 | 1 | GA Unique Loan ID   | Unique ID that has been   | C    | 2 |
| 4 | 0 |                     | assigned to a loan by the | har. | 1 |
|   | 4 |                     | Guaranty Agency.          |      |   |
|   |   |                     | (Optional --will be set   |      |   |
|   |   |                     | to spaces if an ID is not |      |   |
|   |   |                     | assigned.)                |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | PLUS Borrower's     | Applicable to PLUS (PL)   | C    | 9 |
| 0 | 1 | Social Security     | Loans only. It will be    | har. |   |
| 5 | 3 | Number              | set to spaces otherwise.  |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | PLUS Borrowers'     | Applicable to PLUS (PL)   | Date | 8 |
| 1 | 2 | Date of Birth       | Loans only. It will be    |      |   |
| 4 | 1 |                     | set to spaces otherwise.  |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | PLUS Borrower's     | Applicable to PLUS (PL)   | C    | 1 |
| 2 | 3 | First Name          | Loans only. It will be    | har. | 2 |
| 2 | 3 |                     | set to spaces otherwise.  |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | PLUS Borrower's     | Applicable to PLUS (PL)   | C    | 3 |
| 3 | 6 | Last Name           | Loans only. It will be    | har. | 5 |
| 4 | 8 |                     | set to spaces otherwise.  |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | Amount of Guaranty  | Cumulative amount of loan | Num. | 1 |
| 6 | 7 | Current Period      | guaranty, before any      |      | 1 |
| 9 | 9 |                     | cancellations, that was   |      |   |
|   |   |                     | reported by the GA on or  |      |   |
|   |   |                     | after 10/01/1999 and on   |      |   |
|   |   |                     | or before the current     |      |   |
|   |   |                     | reporting period end      |      |   |
|   |   |                     | date.                     |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 1 | Amount of Guaranty  | Cumulative amount of loan | Num. | 1 |
| 8 | 9 | Prior Period        | guaranty, before any      |      | 1 |
| 0 | 0 |                     | cancellations, that was   |      |   |
|   |   |                     | reported by the GA on or  |      |   |
|   |   |                     | after 10/01/1999 and      |      |   |
|   |   |                     | before the current        |      |   |
|   |   |                     | reporting period begin    |      |   |
|   |   |                     | date. This amount should  |      |   |
|   |   |                     | have been included in a   |      |   |
|   |   |                     | previous LPIF detail      |      |   |
|   |   |                     | file. For a new loan      |      |   |
|   |   |                     | guaranty, this amount     |      |   |
|   |   |                     | will be zero.             |      |   |
+---+---+---------------------+---------------------------+------+---+
| 1 | 2 | Difference Guaranty | Difference between amount | Num. | 1 |
| 9 | 0 | Amount              | of guaranty current       |      | 1 |
| 1 | 1 |                     | period and amount of      |      |   |
|   |   |                     | guaranty prior period.    |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Date of             | Date of last cancellation | Date | 8 |
| 0 | 0 | Cancellation^\*^    | as reported to NSLDS on   |      |   |
| 2 | 9 |                     | or after 10/01/1999 and   |      |   |
|   |   |                     | on or before the current  |      |   |
|   |   |                     | reporting period end      |      |   |
|   |   |                     | date; CCYYMMDD format.    |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Amount of           | Cumulative amount of loan | Num. | 1 |
| 1 | 2 | Cancellation        | cancellation for loans    |      | 1 |
| 0 | 0 | Current Period^\*^  | guaranteed on or after    |      |   |
|   |   |                     | 10/01/1999 and last       |      |   |
|   |   |                     | reported to NSLDS on or   |      |   |
|   |   |                     | after 10/01/1999 and on   |      |   |
|   |   |                     | or before the current     |      |   |
|   |   |                     | reporting period end      |      |   |
|   |   |                     | date.                     |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Amount of           | Cumulative amount of loan | Num. | 1 |
| 2 | 3 | Cancellation prior  | cancellation for loans    |      | 1 |
| 1 | 1 | period^\*\*^        | guaranteed on or after    |      |   |
|   |   |                     | 10/01/1999 and reported   |      |   |
|   |   |                     | by the GA on or after     |      |   |
|   |   |                     | 10/01/1999 and before the |      |   |
|   |   |                     | current reporting period  |      |   |
|   |   |                     | begin date. This amount   |      |   |
|   |   |                     | should have been included |      |   |
|   |   |                     | in a previous LPIF detail |      |   |
|   |   |                     | file and include only the |      |   |
|   |   |                     | cancellations for which   |      |   |
|   |   |                     | the GA is responsible.    |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Difference          | Difference between amount | Num. | 1 |
| 3 | 4 | Cancellation Amount | of cancellation current   |      | 1 |
| 2 | 2 |                     | period and amount of      |      |   |
|   |   |                     | cancellation prior        |      |   |
|   |   |                     | period.                   |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Date of             | Date of last disbursement | Date | 8 |
| 4 | 5 | Disbursement^\*^    | as reported to NSLDS on   |      |   |
| 3 | 0 |                     | or after 10/01/1999 and   |      |   |
|   |   |                     | on or before the current  |      |   |
|   |   |                     | reporting period end      |      |   |
|   |   |                     | date; CCYYMMDD format.    |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Amount of           | Cumulative amount of loan | Num. | 1 |
| 5 | 6 | Disbursement        | disbursement for loans    |      | 1 |
| 1 | 1 | Current Period^\*^  | guaranteed on or after    |      |   |
|   |   |                     | 10/01/1999 and last       |      |   |
|   |   |                     | reported to NSLDS on or   |      |   |
|   |   |                     | after 10/01/1999 and on   |      |   |
|   |   |                     | or before the current     |      |   |
|   |   |                     | reporting period end      |      |   |
|   |   |                     | date.                     |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Amount of           | Amount of loan            | Num. | 1 |
| 6 | 7 | Disbursement Prior  | disbursement for loans    |      | 1 |
| 2 | 2 | Period^\*\*^        | guaranteed on or after    |      |   |
|   |   |                     | 10/01/1999 and last       |      |   |
|   |   |                     | reported by the GA on or  |      |   |
|   |   |                     | after 10/01/1999 and      |      |   |
|   |   |                     | before the current        |      |   |
|   |   |                     | reporting period begin    |      |   |
|   |   |                     | date. This amount should  |      |   |
|   |   |                     | have been included in a   |      |   |
|   |   |                     | previous LPIF detail      |      |   |
|   |   |                     | file. And include only    |      |   |
|   |   |                     | the disbursements for     |      |   |
|   |   |                     | which the GA is           |      |   |
|   |   |                     | responsible.              |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Difference          | Difference between amount | Num. | 1 |
| 7 | 8 | Disbursement Amount | of disbursement current   |      | 1 |
| 3 | 3 |                     | period and amount of      |      |   |
|   |   |                     | disbursement prior        |      |   |
|   |   |                     | period. This amount will  |      |   |
|   |   |                     | be multiplied by LPIF Fee |      |   |
|   |   |                     | Rate to compute LPIF fee. |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Responsibility      | Responsibility begin date | Date | 8 |
| 8 | 9 | Begin Date          | for loan guarantor.       |      |   |
| 4 | 1 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 2 | 2 | Responsibility End  | Responsibility end date   | Date | 8 |
| 9 | 9 | Date                | for loan guarantor.       |      |   |
| 2 | 9 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Report Begin Date   | Start Date of Quarter;    | Date | 8 |
| 0 | 0 |                     | CCYYMMDD format.          |      |   |
| 0 | 7 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Report End Date     | End Date of Quarter;      | Date | 8 |
| 0 | 1 |                     | CCYYMMDD format.          |      |   |
| 8 | 5 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Code for GA         | Identification Code for   | C    | 3 |
| 1 | 1 |                     | GA.                       | har. |   |
| 6 | 8 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Fee Rate            | Percentage at which LPIF  | Num. | 5 |
| 1 | 2 |                     | is paid                   |      |   |
| 9 | 3 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Disbursement System | NSLDS System Create Date  | Date | 8 |
| 2 | 3 | Create Date\*\*\*   | for the disbursement      |      |   |
| 4 | 1 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Cancellation System | NSLDS System Create Date  | Date | 8 |
| 3 | 3 | Create Date\*\*\*   | for the Cancellation      |      |   |
| 2 | 9 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 3 | Responsibility End  | NSLDS System Create Date  | Date | 8 |
| 4 | 4 | Date System Create  | for the Responsibility    |      |   |
| 0 | 7 | Date\*\*\*          | End Date.                 |      |   |
+---+---+---------------------+---------------------------+------+---+
| 3 | 4 | Filler              | Spaces                    | C    | 5 |
| 4 | 0 |                     |                           | har. | 3 |
| 8 | 0 |                     |                           |      |   |
+---+---+---------------------+---------------------------+------+---+

GA LPIF Trailer Record Layout Length=400

  ----------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**            **Description**            **Field    **Lth**
  FR**    TO**                                                        Format**   
  ------- ------- ------------------------ -------------------------- ---------- ---------
  1       9       Record Sequence Number   Positional sort field for  Num.       9
                                           sorting the header record             
                                           to the top of the file.               
                                           Set the value to all                  
                                           nines: '999999999'.                   

  10      12      Code for GA              Identification code for    Char.      3
                                           guaranty agency.                      

  13      42      File Description         'GA LPIF DETAIL TRAILER'   Char.      30

  43      51      Total Number of Detail   Number of detail records   Num.       9
                  Records                  contained in the current              
                                           file                                  

  52      66      Total Difference         Sum of all difference      Num.       15
                  Guaranty Amount          guaranty amounts in this              
                                           file                                  

  67      81      Total Difference         Sum of all difference      Num.       15
                  Cancellation Amount      cancellation amounts in               
                                           this file                             

  82      96      Total Net Guaranty       Difference between the     Num.       15
                  Amount                   total difference guaranty             
                                           amount and the total                  
                                           difference cancellation               
                                           amount                                

  97      111     Total Difference         Sum of all difference      Num.       15
                  Disbursement Amount      disbursement amounts in               
                                           this file                             

  112     126     Total Guaranty Amount    Sum of all difference      Num.       15
                  excluding loan type CL   guaranty amounts in this              
                                           file excluding                        
                                           consolidation loans                   

  127     141     Total Disbursement       Sum of all difference      Num.       15
                  Amount excluding loan    disbursement amounts in               
                  type CL                  this file excluding                   
                                           consolidation loans                   

  142     156     Total Cancellation       Sum of all difference      Num.       15
                  Amount excluding loan    cancellation amounts in               
                  type CL                  this file excluding                   
                                           consolidation loans                   

  157     171     Total Net Guaranty       Difference between the     Num.       15
                  Amount excluding loan    Total Difference Guaranty             
                  type CL                  Amount excluding loan type            
                                           CL in this file and the               
                                           Total Difference                      
                                           Cancellation Amount                   
                                           excluding loan type CL in             
                                           this file                             

  172     400     Filler                   Spaces                     Char.      229
  ----------------------------------------------------------------------------------------

**Note:**

**^\*^** This date must be on or after 10/01/1999. If a disbursement or
cancellation is received late (i.e., past the quarter in which the event
took place), the detailed record will be included in the file, as long
as the disbursement or cancellation date is greater than 10/01/1999.

**^\*\*^** This may be different at this point of time if GA has made
any past period change. However, NSLDS will use the figures that were
used to compute in the prior period but not the one with past period
corrections.

\*\*\* This date will only be populated in LPIF calculations that occur
after 12/31/2008.

**LPIF Cumulative File Record Layouts**

Cumulative LPIF Extract Header Record Layout Length = 400

  ----------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**   **Description**                     **Field    **Lth**
  FR**    TO**                                                        Format**   
  ------- ------- --------------- ----------------------------------- ---------- ---------
  1       9       Record Sequence Positional sort field for sorting   Num.       9
                  Number          the header record to the top of the            
                                  file. Set the value to all zeroes;             
                                  '000000000'.                                   

  10      12      Code for GA     Identification Code for Guaranty    Num.       3
                                  Agency                                         

  13      20      Report Begin    Quarter Begin Date: CCYYMMDD        Num.       8
                  Date                                                           

  21      28      Report End Date Quarter End Date: CCYYMMDD          Num.       8

  29      29      Filler          Space                               Char.      1

  30      37      Create Date     Date on which the file is created:  Num.       8
                                  CCYYMMDD                                       

  38      45      Create Time     Time when the file is created:      Num.       8
                                  HH:MM:SS format                                

  46      95      File            'GA LPIF CUMULATIVE DETAIL HEADER'  Char.      50
                  Description                                                    

  96      400     Filler          Spaces.                             Char.      305
  ----------------------------------------------------------------------------------------

The cumulative LPIF detail record layout is similar to the LPIF detail
record layout with the following exceptions. The following fields are
excluded and populated with filler (i.e., zeroes):

-   Amount of Guaranty Prior Period (positions 180-190)

-   Difference Guaranty Amount (positions 191-201)

-   Amount of Cancellation Prior Period (positions 221-231)

-   Difference Cancellation Amount (positions 232-242)

-   Amount of Disbursement Prior Period (positions 262-272)

-   Difference Disbursement Amount (positions 273-283)

## 

Cumulative LPIF Extract Detail Record Layout Length = 400

+---+---+----------------+--------------------------------+-----+----+
| * | * | **Attribute**  | **Description**                | *   | *  |
| * | * |                |                                | *Fi | *L |
| P | P |                |                                | eld | th |
| o | o |                |                                | Fo  | ** |
| s | s |                |                                | rma |    |
| F | T |                |                                | t** |    |
| R | O |                |                                |     |    |
| * | * |                |                                |     |    |
| * | * |                |                                |     |    |
+===+===+================+================================+=====+====+
| 1 | 9 | Student's      | Title IV aid recipient or      | Ch  | 9  |
|   |   | Social         | beneficiary's SSN              | ar. |    |
|   |   | Security       |                                |     |    |
|   |   | Number         |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | Date of        | Date when a Title IV aid       | D   | 8  |
| 0 | 7 | Student's      | recipient or beneficiary was   | ate |    |
|   |   | Birth          | born; CCYYMMDD                 |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 2 | Student's      | Title IV aid recipient or      | Ch  | 12 |
| 8 | 9 | First Name     | beneficiary's first name       | ar. |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 6 | Student's Last | Title IV aid recipient or      | Ch  | 35 |
| 0 | 4 | Name           | beneficiary's last name        | ar. |    |
+---+---+----------------+--------------------------------+-----+----+
| 6 | 6 | Type of Loan   | Code indicating type of aid    | Ch  | 2  |
| 5 | 6 |                | received or guaranteed:        | ar. |    |
|   |   |                |                                |     |    |
|   |   |                | > SF---Stafford\               |     |    |
|   |   |                | > SU---Unsubsidized Stafford\  |     |    |
|   |   |                | > PL---PLUS\                   |     |    |
|   |   |                | > CL---Consolidated            |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 6 | 7 | Date of        | Date the FFEL loan was         | D   | 8  |
| 7 | 4 | Guaranty       | originally guaranteed;         | ate |    |
|   |   |                | CCYYMMDD                       |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 7 | 7 | Indicator of   | Indicator used to              | Ch  | 1  |
| 5 | 5 | Separate Loan  | differentiate among multiple   | ar. |    |
|   |   |                | loans of the same type, that   |     |    |
|   |   |                | have the same guaranty date    |     |    |
|   |   |                | for the same student attending |     |    |
|   |   |                | the same school                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 7 | 8 | Code for       | OPE code for school where a    | Ch  | 8  |
| 6 | 3 | Original       | student was enrolled or        | ar. |    |
|   |   | School         | accepted for enrollment at the |     |    |
|   |   |                | time the loan was made         |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 8 | 1 | GA Unique Loan | Unique ID that has been        | Ch  | 21 |
| 4 | 0 | ID             | assigned to a loan by the      | ar. |    |
|   | 4 |                | Guaranty Agency (Optional -    |     |    |
|   |   |                | will be set to spaces if ID is |     |    |
|   |   |                | not assigned)                  |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | PLUS           | Applicable to PLUS (PL) Loans  | Ch  | 9  |
| 0 | 1 | Borrower's     | only. It will be set to spaces | ar. |    |
| 5 | 3 | Social         | otherwise.                     |     |    |
|   |   | Security       |                                |     |    |
|   |   | Number         |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | PLUS           | Applicable to PLUS (PL) Loans  | D   | 8  |
| 1 | 2 | Borrowers'     | only. It will be set to spaces | ate |    |
| 4 | 1 | Date of Birth  | otherwise.                     |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | PLUS           | Applicable to PLUS (PL) Loans  | Ch  | 12 |
| 2 | 3 | Borrower's     | only. It will be set to spaces | ar. |    |
| 2 | 3 | First Name     | otherwise.                     |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | PLUS           | Applicable to PLUS (PL) Loans  | Ch  | 35 |
| 3 | 6 | Borrower's     | only. It will be set to spaces | ar. |    |
| 4 | 8 | Last Name      | otherwise.                     |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | Amount of      | Original dollar amount, before | N   | 11 |
| 6 | 7 | Guaranty       | any cancellations, of the FFEL | um. |    |
| 9 | 9 |                | loan guaranty.                 |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 1 | Filler         | Zeroes.                        | N   | 11 |
| 8 | 9 |                |                                | um. |    |
| 0 | 0 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 1 | 2 | Filler         | Zeroes.                        | N   | 11 |
| 9 | 0 |                |                                | um. |    |
| 1 | 1 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Date of        | Date of last cancellation as   | D   | 8  |
| 0 | 0 | Cancellation\* | reported to NSLDS, on or after | ate |    |
| 2 | 9 |                | 10/01/1999 and through the     |     |    |
|   |   |                | report period end date.        |     |    |
|   |   |                | CCYYMMDD.                      |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Amount of      | Cumulative amount of loan      | N   | 11 |
| 1 | 2 | Cancellation   | cancellation last reported to  | um. |    |
| 0 | 0 |                | NSLDS on or after 10/01/1999   |     |    |
|   |   |                | and through the report period  |     |    |
|   |   |                | end date.                      |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Filler         | Zeroes.                        | N   | 11 |
| 2 | 3 |                |                                | um. |    |
| 1 | 1 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Filler         | Zeroes.                        | N   | 11 |
| 3 | 4 |                |                                | um. |    |
| 2 | 2 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Date of        | Date of last Disbursement as   | D   | 8  |
| 4 | 5 | Disbursement\* | reported to NSLDS, on or after | ate |    |
| 3 | 0 |                | 10/01/1999 and through the     |     |    |
|   |   |                | report period end date.        |     |    |
|   |   |                | CCYYMMDD.                      |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Amount of      | Cumulative amount of loan      | N   | 11 |
| 5 | 6 | Disbursement   | disbursement last reported to  | um. |    |
| 1 | 1 |                | NSLDS on or after 10/01/1999   |     |    |
|   |   |                | and through the report period  |     |    |
|   |   |                | end date.                      |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Filler         | Zeroes.                        | N   | 11 |
| 6 | 7 |                |                                | um. |    |
| 2 | 2 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Filler         | Zeroes.                        | N   | 11 |
| 7 | 8 |                |                                | um. |    |
| 3 | 3 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Responsibility | Responsibility begin date for  | D   | 8  |
| 8 | 9 | Begin Date     | loan guarantor.                | ate |    |
| 4 | 1 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 2 | 2 | Responsibility | Responsibility end date for    | D   | 8  |
| 9 | 9 | End Date       | loan guarantor.                | ate |    |
| 2 | 9 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | Report Begin   | Start date of quarter;         | D   | 8  |
| 0 | 0 | Date           | CCYYMMDD.                      | ate |    |
| 0 | 7 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | Report End     | End date of quarter; CCYYMMDD. | D   | 8  |
| 0 | 1 | Date           |                                | ate |    |
| 8 | 5 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | GA code        | Identification Code for GA.    | Ch  | 3  |
| 1 | 1 |                |                                | ar. |    |
| 6 | 8 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | Fee Rate       | Percentage at which LPIF is    | N   | 5  |
| 1 | 2 |                | paid                           | um. |    |
| 9 | 3 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | Disbursement   | NSLDS System Create Date for   | D   | 8  |
| 2 | 3 | System Create  | the disbursement               | ate |    |
| 4 | 1 | Date\*\*       |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | Cancellation   | NSLDS System Create Date for   | D   | 8  |
| 3 | 3 | System Create  | the Cancellation               | ate |    |
| 2 | 9 | Date\*\*       |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 3 | Responsibility | NSLDS System Create Date for   | D   | 8  |
| 4 | 4 | End Date       | the Responsibility End Date.   | ate |    |
| 0 | 7 | System Create  |                                |     |    |
|   |   | Date\*\*       |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+
| 3 | 4 | Filler         | Spaces.                        | Ch  | 53 |
| 4 | 0 |                |                                | ar. |    |
| 8 | 0 |                |                                |     |    |
+---+---+----------------+--------------------------------+-----+----+

Cumulative LPIF Extract Trailer Record Layout Length=

+---+----+------------+------------------------------------+-----+-----+
| * | *  | **A        | **Description**                    | *   | *   |
| * | *P | ttribute** |                                    | *Fi | *Lt |
| P | os |            |                                    | eld | h** |
| o | TO |            |                                    | Fo  |     |
| s | ** |            |                                    | rma |     |
| F |    |            |                                    | t** |     |
| R |    |            |                                    |     |     |
| * |    |            |                                    |     |     |
| * |    |            |                                    |     |     |
+===+====+============+====================================+=====+=====+
| 1 | 9  | Record     | Positional sort field for sorting  | N   | 9   |
|   |    | Sequence   | the trailer record to the bottom   | um. |     |
|   |    | Number     | of the file. Set the value to all  |     |     |
|   |    |            | nines; '999999999'.                |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 12 | Code for   | Identification Code for Guaranty   | N   | 3   |
| 0 |    | GA         | Agency.                            | um. |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 62 | File       | 'GA LPIF CUMULATIVE DETAIL         | Ch  | 50  |
| 3 |    | D          | TRAILER'.                          | ar. |     |
|   |    | escription |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 6 | 71 | Total      | Number of detail records contained | N   | 9   |
| 3 |    | Number of  | in the current file.               | um. |     |
|   |    | Detail     |                                    |     |     |
|   |    | Records    |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 7 | 86 | Total      | Sum of all guaranty amounts in     | N   | 15  |
| 2 |    | Guaranty   | this file.                         | um. |     |
|   |    | Amount     |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 8 | 1  | Total      | Sum of all cancellation amounts in | N   | 15  |
| 7 | 01 | Ca         | this file.                         | um. |     |
|   |    | ncellation |                                    |     |     |
|   |    | Amount     |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 1  | Total Net  | Difference between the Total       | N   | 15  |
| 0 | 16 | Guaranty   | Guaranty amount and the Total      | um. |     |
| 2 |    | Amount     | Cancellation Amount.               |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 1  | Total      | Sum of all disbursement amounts in | N   | 15  |
| 1 | 31 | Di         | the file.                          | um. |     |
| 7 |    | sbursement |                                    |     |     |
|   |    | Amount     |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 1  | Total      | Sum of all guaranty amounts in     | N   | 15  |
| 3 | 46 | Guaranty   | this file excluding loan type      | um. |     |
| 2 |    | Amount     | 'CL'.                              |     |     |
|   |    | excluding  |                                    |     |     |
|   |    | co         |                                    |     |     |
|   |    | nsolidated |                                    |     |     |
|   |    | loans      |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 1  | Total      | Sum of all cancellation amounts in | N   | 15  |
| 4 | 61 | Ca         | this file excluding loan type      | um. |     |
| 7 |    | ncellation | 'CL'.                              |     |     |
|   |    | Amount     |                                    |     |     |
|   |    | excluding  |                                    |     |     |
|   |    | co         |                                    |     |     |
|   |    | nsolidated |                                    |     |     |
|   |    | loans      |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 1  | Total Net  | Difference between the Total       | N   | 15  |
| 6 | 76 | Guaranty   | Guaranty amount and the Total      | um. |     |
| 2 |    | Amount     | Cancellation Amount.               |     |     |
|   |    | excluding  |                                    |     |     |
|   |    | co         | Excluding consolidated loans.      |     |     |
|   |    | nsolidated |                                    |     |     |
|   |    | loans      |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 1  | Total      | Sum of all disbursement amounts in | N   | 15  |
| 7 | 91 | Di         | the file excluding loan type 'CL'. | um. |     |
| 7 |    | sbursement |                                    |     |     |
|   |    | Amount     |                                    |     |     |
|   |    | excluding  |                                    |     |     |
|   |    | co         |                                    |     |     |
|   |    | nsolidated |                                    |     |     |
|   |    | loans      |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+
| 1 | 4  | Filler     | Spaces.                            | Ch  | 209 |
| 9 | 00 |            |                                    | ar. |     |
| 2 |    |            |                                    |     |     |
+---+----+------------+------------------------------------+-----+-----+

**Notes:**

**\*** If a Disbursement/Cancellation is received past the quarter in
which the event took place the detail record will be included in the
file, as long as the disbursement/cancellation date is greater than
10/01/1999.

\*\* This date will only be populated in LPIF calculations that occur
after 12/31/2008.