**Guaranty Agency Financial Aid Transcript Batch Request**

####### Technical Update GA--2004--02

**January 12, 2004**

*This information is intended for the person in your organization who is
responsible for working with NSLDS. If that is not you, please forward
this update to the appropriate person.*

**Requesting Financial Aid History Information through the Guaranty
Agency Financial Aid Transcript Batch Request Process**

Guaranty Agencies (GAs) can now obtain student Financial Aid History
(FAH) information. The Department of Education (ED) is providing access
to a student's FAH information in response to interest expressed by the
GA community. GAs will receive FAH information only for those students
who have at least one loan with the requesting GA. In addition, GAs will
receive other Title IV information about the student if it exists in the
NSLDS database (e.g., Pell Grant History). Use of this data is
restricted under the Privacy Act of 1974 (as amended).

This process is intended and designed to report loan information in the
NSLDS database. Although aggregate amounts are sent to GAs in the
Financial Aid Transcript (FAT) Batch Request file, GAs and schools must
rely on the current aggregate calculations and amounts found at
[www.nsldsfap.ed.gov](http://www.nsldsfap.ed.gov/) or the school's
Transfer Student Monitoring (TSM)/FAH batch process for each student.
The calculated aggregate amounts sent on this processed file often
differ, so when determining a borrower's eligibility, GAs cannot use
these aggregate amounts from this GA FAT Batch Request.

This technical update includes the following two attachments:

A.  **GA FAT Batch Request Checklist.**

> This checklist outlines the initial setup process and provides
> guidance for the GA FAT Batch Request process.

B.  **GA FAT Batch Request Record Layouts.**

> These record layouts are divided into two sections. Section 1.1
> describes the Input record layouts. Section 1.2 describes the Output
> record layouts in the processed extract data file. Both layouts
> include header, detail, and trailer records. Additional detail record
> layouts in the Output file include the following:
>
> Record Type 1: Main Record
>
> Record Type 2: Name Record
>
> Record Type 3: Overpayment Record
>
> Record Type 4: Pell Record
>
> Record Type 5: Loan Record

If you have any questions, please contact the NSLDS Customer Service
Center at\
(800) 999-8219 or e-mail them at *[nsldscoe@raytheon.com]{.underline}*.

######### Attachment A

**GA FAT Batch Request Checklist**

-   Verify SAIG Enrollment (<https://www.fsawebenroll.ed.gov/>).

SAIG Customer Service at 800--330--5947 can assist with the enrollment
signup process.

> A conference call with NSLDS Customer Service (800--999--8219) can be
> arranged to assist with this.

-   Determine the type of SAIG connectivity for the GA FAT Batch Request
    file transmission: Mainframe or PC (EDconnect software). SAIG
    Customer Service can assist with connectivity issues.

> Your TG ID enrolled for the NSLDS Batch service must be the same TG ID
> used when sending/receiving the GA FAT request files.

-   Create processes to accommodate the GA FAT Batch Request record
    layouts.

> See Attachment B.

-   Create a file according to the GA FAT Batch Request record layouts
    and specifications (Section 1.1, Input).

-   Select a small population to test the process.

> Send your initial FAT request batch the next business day after
> signing up for this process (allows time for SAIG enrollment and NSLDS
> to sync up).

-   Submit your test file via the SAIG network under the message class:
    SHFATQIN.

-   Receive processed results via the SAIG network under the message
    class: GAFAHEOP.

> A processed file will be ready within the next 24-36 hours; if nothing
> has been returned after looking in your SAIG mailbox after this
> timeframe, call NSLDS Customer Service for assistance.

-   Verify the processed data to the GA FAT Batch Request record layouts
    (Section 1.2, Outputs).

> Detail Record type 1, the Main record layout, positions 215-219 will
> show error code(s) and match flag. Refer to the Error Code Legend and
> Match Flag Legend for values and explanations. If applicable for a
> student, NSLDS could send a set of detail records for Name History,
> Overpayments or Pells. Each record is identified by the record type in
> the 1^st^ position of the detail record.

-   After testing for a successful send/receive GA FAT Batch Request
    process, submit others as needed.

**Attachment B**

######### GA FAT Batch Request Record Layouts

## 1.1 Input

GAs send the file through the SAIG in the message class SHFATQIN.

The following record layouts describe the input header, detail, and
trailer records for the FAT Batch Request file sent by GAs. Each
submission from a GA includes one header record, one or more detail
records, and one trailer record.

FAT Request Header Record Layout Length = 80

  ----------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**      **Description**                  **Field    **Lth**
  FR**    TO**                                                        Format**   
  ------- ------- ------------------ -------------------------------- ---------- ---------
  1       1       Record Type        '0'--Represents Header           Char.      1

  2       47      Header Title       Value 'FINANCIAL AID TRANSCRIPT  Char.      46
                                     HEADER'.                                    

  48      53      GA Code            For GA requests, GA code of the  Char.      6
                                     GA requesting the FAT. Required             
                                     for GA requests; left justify.              

  54      55      School Branch Code Code for school branch           Char.      2
                                     requesting FAT:\                            
                                     optional for servicer\                      
                                     mandatory for school\                       
                                     blank for GA requests.                      

  56      63      Servicer Code      Code for FAT servicer; Zeros for Char.      8
                                     GA requests.                                

  64      64      Report Type        'R' = Report\                    Char.      1
                                     'E' = Extract data file                     
                                     (default)\                                  
                                     For GA request, must be 'E'.                

  65      72      Submittal Date     Date that the FAT request is     Date       8
                                     submitted. Format CCYYMMDD.                 

  73      80      Filler             Attribute to complete record     Char.      8
                                     length.                                     
  ----------------------------------------------------------------------------------------

FAT Request Detail Record Layout Length = 80

  ----------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**      **Description**                  **Field    **Lth**
  FR**    TO**                                                        Format**   
  ------- ------- ------------------ -------------------------------- ---------- ---------
  1       1       Record Type        '1'--Represents Detail           Char.      1

  2       10      Current SSN        SSN of the student for whom FAT  Char.      9
                                     is desired.                                 

  11      45      Last Name          Last name of student for whom    Char.      35
                                     FAT is desired.                             

  46      57      First Name         First name of student for whom   Char.      12
                                     FAT is desired.                             

  58      65      Date of Birth      Date of Birth of the student for Date       8
                                     whom FAT is desired. Format                 
                                     CCYYMMDD.                                   

  66      69      School Year        Pell school year (July-June).    Char.      4
                                     Optional, if provided, must be              
                                     in CCYY format and not greater              
                                     than current Pell school year.              
                                     When not provided, (i.e.,                   
                                     spaces), current Pell school                
                                     year is used, determined as                 
                                     follows:\                                   
                                     Jan.-June = current calendar                
                                     year.\                                      
                                     July-Dec. = current calendar                
                                     year +1.                                    

  70      75      GA Code            GA code of the GA requesting the Char.      6
                                     FAT. Required for GA requests;              
                                     left justify.                               

  76      77      School Branch Code Blank for GA requests.           Char.      2

  78      80      Filler             Attribute to complete record     Char.      3
                                     length.                                     
  ----------------------------------------------------------------------------------------

FAT Request Trailer Record Layout Length = 80

+---+---+-----------------+--------------------------------+-----+---+
| * | * | **Attribute**   | **Description**                | *   | * |
| * | * |                 |                                | *Fi | * |
| P | P |                 |                                | eld | L |
| o | o |                 |                                | Fo  | t |
| s | s |                 |                                | rma | h |
| F | T |                 |                                | t** | * |
| R | O |                 |                                |     | * |
| * | * |                 |                                |     |   |
| * | * |                 |                                |     |   |
+===+===+=================+================================+=====+===+
| 1 | 1 | Record Type     | '9'--Represents Trailer        | Ch  | 1 |
|   |   |                 | Record.                        | ar. |   |
+---+---+-----------------+--------------------------------+-----+---+
| 2 | 4 | Trailer Title   | Value 'FINANCIAL AID           | Ch  | 4 |
|   | 7 |                 | TRANSCRIPT TRAILER'.           | ar. | 6 |
+---+---+-----------------+--------------------------------+-----+---+
| 4 | 5 | Record Count    | Total count of detail records  | N   | 9 |
| 8 | 6 |                 | on this file (excluding header | um. |   |
|   |   |                 | and trailer).                  |     |   |
|   |   |                 |                                |     |   |
|   |   |                 | Valid Field content:\          |     |   |
|   |   |                 | 000000001-999999999 (use lead  |     |   |
|   |   |                 | zeroes).                       |     |   |
+---+---+-----------------+--------------------------------+-----+---+
| 5 | 8 | Filler          | Attribute to complete record   | Ch  | 2 |
| 7 | 0 |                 | length.                        | ar. | 4 |
+---+---+-----------------+--------------------------------+-----+---+

## 1.2 Output

GAs receive processed files through the SAIG in the message class
GAFAHEOP.

The following record layouts describe the header, detail, and trailer
records in the output FAT Batch Request extract data file.

The file contains the FAT results for each of the input FAT request
submissions. The results for each submission contain one header record,
a set of detail records for each requested student, and one trailer
record as indicated below:

> Header Record
>
> Detail Record(s) For Student 1
>
> Detail Record(s) For Student 2
>
> .
>
> .
>
> .
>
> Detail Record(s) For Student N
>
> Trailer Record

Each set of detail records contains one or more detail records for a
student. Detail records consist of the following types:

Record Type 1: Main Record

Record Type 2: Name Record

Record Type 3: Overpayment Record

Record Type 4: Pell Record

Record Type 5: Loan Record

In each set of detail records for a student there is exactly one record
type 1 and zero or more record types 2 through 5, depending upon the
data in NSLDS for the student. If any errors are indicated on record
type 1, there are no record types 2 through 5 for the student.

Header Record Layout Length = 260

  ------------------------------------------------------------------------------------------
  **Pos\   **Pos\   **Attribute**      **Description**                  **Field    **Lth**
  FR**     TO**                                                         Format**   
  -------- -------- ------------------ -------------------------------- ---------- ---------
  1        1        Record Type        Value = '0'                      Char.      1

  2        10       Filler             Dummy SSN for header record.     Char.      9
                                       Value is spaces.                            

  11       52       Header Title       Value 'FINANCIAL AID TRANSCRIPT  Char.      42
                                       HEADER'                                     

  53       58       GA Code            GA code of GA requesting FAT.    Char.      6

  59       60       School Branch Code Blank for GA requests.           Char.      2

  61       68       Servicer Code      Zeros for GA requests.           Char.      8

  69       69       Report Type        'E' = Extract Data File          Char.      1

  70       77       Submittal Date     Date on which the FAT request is Date       8
                                       submitted. Format CCYYMMDD.                 

  78       85       Process Date       Date on which the FAT request is Date       8
                                       processed. Format CCYYMMDD.                 

  86       260      Filler             Attribute to complete record     Char.      175
                                       length.                                     
  ------------------------------------------------------------------------------------------

FAT Main Record Layout (Record Type 1) Length = 260

  ----------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**      **Description**                  **Field    **Lth**
  FR**    TO**                                                        Format**   
  ------- ------- ------------------ -------------------------------- ---------- ---------
  1       1       Record Type        Indicator used to identify the   Char.      1
                  Indicator          record.\                                    
                                     Value = '1'.                                

  2       10      Current SSN        Current SSN from NSLDS of the    Char.      9
                                     student for whom the FAT is                 
                                     being generated.                            

  11      22      Current First Name Current first name from NSLDS of Char.      12
                                     the student for whom the FAT is             
                                     being generated.\                           
                                     Value = 'NFN' if student has no             
                                     first name.\                                
                                     'N/A' if request record errs                
                                     out.                                        

  23      57      Current Last Name  Current last name from NSLDS of  Char.      35
                                     the student for whom the FAT is             
                                     being generated.\                           
                                     Value = 'NLN' if student has no             
                                     last name.\                                 
                                     'N/A' if request record errs                
                                     out.                                        

  58      65      Current Date of    Date of Birth from NSLDS of the  Date       8
                  Birth              student for whom the FAT is                 
                                     being generated.\                           
                                     Format is CCYYMMDD.\                        
                                     Zeros if request record errs                
                                     out.                                        

  66      73      GA Code            GA code of GA requesting FAT.    Char.      8

  74      74      Defaulted Loans    Indicates one or more defaulted  Char.      1
                  Flag               loans.\                                     
                                     Value = 'Y' or 'N'.                         

  75      75      Discharged Loans   Indicates one or more discharged Char.      1
                  Flag               loans.\                                     
                                     Value = 'Y' or 'N'.                         

  76      76      Satisfactory       Indicates one or more loans with Char.      1
                  Arrangements Flag  satisfactory repayment                      
                                     arrangements.\                              
                                     Value = 'Y' or 'N'.                         

  77      77      Active Bankruptcy  Indicates one or more active     Char.      1
                  Flag               bankruptcy loans. Value = 'Y' or            
                                     'N'.                                        

  78      83      Aggregate          Outstanding principal balance    Char.      6
                  Subsidized         for subsidized loan types (D1,              
                  Outstanding        D6, and subsidized SF).\                    
                  Principal Balance  Value is balance or 'N/A' if no             
                                     applicable loans.                           

  84      89      Aggregate          Outstanding principal balance    Char.      6
                  Unsubsidized       for unsubsidized loan types (D2,            
                  Outstanding        D5, RF, non-subsidized SF, SL,              
                  Principal Balance  and SU).\                                   
                                     Value is balance or 'N/A' if no             
                                     applicable loans.                           

  90      95      Aggregate Combined Outstanding principal balance    Char.      6
                  Outstanding        for subsidized and unsubsidized             
                  Principal Balance  loan types (D1, D2, D5, D6, RF,             
                                     subsidized and non-subsidized               
                                     SF, SL, and SU). Value is                   
                                     balance or 'N/A' if no                      
                                     applicable loans.                           

  96      101     Aggregate          Outstanding principal balance    Char.      6
                  Consolidated       for FFEL consolidated loan type             
                  Outstanding        CL.\                                        
                  Principal Balance  Value is balance or 'N/A' if no             
                                     applicable loans.                           

  102     107     Aggregate          Pending disbursements for        Char.      6
                  Subsidized Pending subsidized loan types (D1, D6,              
                  Disbursement       and subsidized SF).\                        
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  108     113     Aggregate          Pending disbursements for        Char.      6
                  Unsubsidized       unsubsidized loan types (D2, D5,            
                  Pending            RF, non-subsidized SF, SL, and              
                  Disbursement       SU).\                                       
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  114     119     Aggregate Combined Pending disbursements for        Char.      6
                  Pending            subsidized and unsubsidized loan            
                  Disbursement       types (D1, D2, D5, D6, RF,                  
                                     subsidized and non-subsidized               
                                     SF, SL, and SU). Value is amount            
                                     or 'N/A' if no applicable loans.            

  120     125     Aggregate          Total for subsidized loan types  Char.      6
                  Subsidized Total   (D1, D6, and subsidized SF).\               
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  126     131     Aggregate          Total for unsubsidized loan      Char.      6
                  Unsubsidized Total types (D2, D5, RF,                          
                                     non-subsidized SF, SL, and SU).\            
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  132     137     Aggregate Combined Total for subsidized and         Char.      6
                  Total              unsubsidized loan types (D1, D2,            
                                     D5, D6, RF, subsidized and                  
                                     non-subsidized SF, SL, and SU).\            
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  138     143     Aggregate          Total for FFEL consolidated loan Char.      6
                  Consolidated Total type CL.\                                   
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  144     149     Perkins Total      Total Perkins (DU, EU, NU, and   Char.      6
                  Disbursements      PU) loan outstanding principal              
                                     balances.\                                  
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  150     155     Perkins Current    Total Perkins (DU, EU, NU, and   Char.      6
                  Award Year         PU) loan disbursements for award            
                  Disburse           year (July-June).\                          
                                     Value is amount or 'N/A' if no              
                                     applicable loans.                           

  156     156     Direct Loan Master Direct Loan Master Promissory    Char.      1
                  Promissory Note    Note Flag.\                                 
                  Flag               Value = 'A', 'I', 'C', 'N', or              
                                     'U'.                                        

  157     157     Pell Change Flag   Indicates change to Pell Grant   Char.      1
                                     information on one or more                  
                                     grants. Value = 'Y' or 'N'.                 

  158     158     Loan Change Flag   Indicates changed information on Char.      1
                                     one or more loans.\                         
                                     Value = 'Y' or 'N'.                         

  159     159     Aggregates Change  Indicates changed Aggregate      Char.      1
                  Flag               Amount information.\                        
                                     Value = 'Y' or 'N'.                         

  160     171     First Name         First name of student submitted  Char.      12
                                     in FAT request.                             

  172     206     Last Name          Last name of student submitted   Char.      35
                                     in FAT request.                             

  207     214     Date of Birth      Date of Birth of student         Date       8
                                     submitted in FAT request.\                  
                                     Format is CCYYMMDD.                         

  215     215     Error Code 1       Reflects SSN Error. See Error    Char.      1
                                     Codes Legend.                               

  216     216     Error Code 2       Reflects Name Error. See Error   Char.      1
                                     Codes Legend.                               

  217     217     Error Code 3       Reflects Date of Birth Error.    Char.      1
                                     See Error Codes Legend.                     

  218     218     Error Code 4       Reflects School Year Errors. See Char.      1
                                     Error Codes Legend.                         

  219     219     Match Flag         Successful/unsuccessful match of Char.      1
                                     Student/PLUS Borrower against               
                                     search parameters in the                    
                                     database. See Match Flag Legend.            

  220     260     Filler             Attribute to complete record     Char.      41
                                     length.                                     
  ----------------------------------------------------------------------------------------

These error codes describe positions 215 through 218 on the FAT Main
Record Layout (Record Type 1).

Error Codes Legend

  -----------------------------------------------------------------------
  **Attribute**     **Value**    **Meaning**
  ----------------- ------------ ----------------------------------------
  Error Code 1      space        No error.

                    1            SSN must not be spaces.

  Error Code 2      space        No error.

                    2            First name and last name must not be
                                 spaces.

  Error Code 3      space        No error.

                    3            Invalid Date of Birth.

  Error Code 4      space        No error.

                    4            School Year must be numeric.

                    5            School Year must not be greater than
                                 current school year.

                    6            School Year field length must be equal
                                 to 4.
  -----------------------------------------------------------------------

These flag values describe position 219 on the FAT Main Record Layout
(Record Type 1).

Match Flag Legend

  -----------------------------------------------------------------------
  **Attribute**     **Value**    **Meaning**
  ----------------- ------------ ----------------------------------------
  Match Flag        0            Successful match. No error.

                    6            Student Social Security Number not
                                 found.

                    7            Match on SSN. No match on DOB and Name.

                    8            Student has no loans with the GA.
  -----------------------------------------------------------------------

FAT Name Record Layout (Record Type 2) Length = 260

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**     **Description**                  **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ----------------- -------------------------------- ---------- ---------
  1       1       Record Type       Indicator used to identify the   Char.      1
                  Indicator         Name History record.\                       
                                    Value = '2'.                                

  2       10      Current SSN       Current SSN from NSLDS of the    Char.      9
                                    student for whom the FAT is                 
                                    being generated.                            

  11      22      Current First     Current first name from NSLDS of Char.      12
                  Name              the student for whom the FAT is             
                                    being generated.\                           
                                    Value = 'NFN' if student has no             
                                    first name.                                 

  23      57      Current Last Name Current last name from NSLDS of  Char.      35
                                    the student for whom the FAT is             
                                    being generated.\                           
                                    Value = 'NLN' if student has no             
                                    last name.                                  

  58      65      Current Date of   Date of Birth from NSLDS of the  Date       8
                  Birth             student for whom the FAT is                 
                                    being generated.\                           
                                    Format is CCYYMMDD.                         

  66      73      GA code           GA code of GA requesting FAT.    Char.      8

  74      85      First             Other first name used by the     Char.      12
                                    student for whom the FAT is                 
                                    provided.\                                  
                                    Value = 'NFN' if student has no             
                                    first name.                                 

  86      86      Middle Initial    Other middle initial used by the Char.      1
                                    student for whom the FAT is                 
                                    provided, if available.                     

  87      121     Last              Other last name used by the      Char.      35
                                    student for whom the FAT is                 
                                    provided.\                                  
                                    Value = 'NLN' if student has no             
                                    last name.                                  

  122     260     Filler            Attribute to complete record     Char.      139
                                    length.                                     
  ---------------------------------------------------------------------------------------

FAT Overpayment Record Layout (Record Type 3) Length = 260

+---+---+-----------------+-------------------------------+-----+---+
| * | * | **Attribute**   | **Description**               | *   | * |
| * | * |                 |                               | *Fi | * |
| P | P |                 |                               | eld | L |
| o | o |                 |                               | Fo  | t |
| s | s |                 |                               | rma | h |
| F | T |                 |                               | t** | * |
| R | O |                 |                               |     | * |
| * | * |                 |                               |     |   |
| * | * |                 |                               |     |   |
+===+===+=================+===============================+=====+===+
| 1 | 1 | Record Type     | Indicator used to identify    | Ch  | 1 |
|   |   | Indicator       | the Overpayment Record. Value | ar. |   |
|   |   |                 | = '3'                         |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 2 | 1 | Current SSN     | Current SSN from NSLDS of the | Ch  | 9 |
|   | 0 |                 | student for whom the FAT is   | ar. |   |
|   |   |                 | being generated.              |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 2 | Current First   | Current first name from NSLDS | Ch  | 1 |
| 1 | 2 | Name            | of the student for whom the   | ar. | 2 |
|   |   |                 | FAT is being generated.\      |     |   |
|   |   |                 | Value = 'NFN' if student has  |     |   |
|   |   |                 | no first name.                |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 2 | 5 | Current Last    | Current last name from NSLDS  | Ch  | 3 |
| 3 | 7 | Name            | of the student for whom the   | ar. | 5 |
|   |   |                 | FAT is being generated.\      |     |   |
|   |   |                 | Value = 'NLN' if student has  |     |   |
|   |   |                 | no last name.                 |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 5 | 6 | Current Date of | Date of Birth from NSLDS of   | D   | 8 |
| 8 | 5 | Birth           | the student for whom the FAT  | ate |   |
|   |   |                 | is being generated.\          |     |   |
|   |   |                 | Format is CCYYMMDD.           |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 6 | 7 | GA Code         | GA code of GA requesting FAT. | Ch  | 8 |
| 6 | 3 |                 |                               | ar. |   |
+---+---+-----------------+-------------------------------+-----+---+
| 7 | 7 | Aid Type        | Two-character code that       | Ch  | 2 |
| 4 | 5 |                 | identifies the type of        | ar. |   |
|   |   |                 | Overpayment(s) reported for   |     |   |
|   |   |                 | the student.                  |     |   |
|   |   |                 |                               |     |   |
|   |   |                 | PE = Pell Grant               |     |   |
|   |   |                 |                               |     |   |
|   |   |                 | SE = Federal Supplemental     |     |   |
|   |   |                 | Educational Opportunity Grant |     |   |
|   |   |                 |                               |     |   |
|   |   |                 | PK = Perkins loan (loan types |     |   |
|   |   |                 | PU, NU, EU or DU)             |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 7 | 7 | Overpayment     | One-character code that       | Ch  | 1 |
| 6 | 6 | Indicator       | identifies the status of the  | ar. |   |
|   |   |                 | Overpayment.                  |     |   |
|   |   |                 |                               |     |   |
|   |   |                 | 'Y' = Yes, an active          |     |   |
|   |   |                 | Overpayment exists.           |     |   |
|   |   |                 |                               |     |   |
|   |   |                 | 'N' = No, an active           |     |   |
|   |   |                 | Overpayment does not exist.   |     |   |
|   |   |                 |                               |     |   |
|   |   |                 | 'S' = Yes, the student has an |     |   |
|   |   |                 | Overpayment, but has made     |     |   |
|   |   |                 | satisfactory arrangements for |     |   |
|   |   |                 | repayment.                    |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 7 | 8 | Award Year      | Award Year on which the       | Ch  | 4 |
| 7 | 0 |                 | overpayment was disbursed.    | ar. |   |
+---+---+-----------------+-------------------------------+-----+---+
| 8 | 8 | Contact         | Contact for Pell overpayment. | Ch  | 8 |
| 1 | 8 |                 |                               | ar. |   |
|   |   |                 | Value is contact code when 1  |     |   |
|   |   |                 | overpayment, or 'Y' when more |     |   |
|   |   |                 | than 1 overpayment.           |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 8 | 2 | Filler          | Attribute to complete record  | Ch  | 1 |
| 9 | 6 |                 | length.                       | ar. | 7 |
|   | 0 |                 |                               |     | 2 |
+---+---+-----------------+-------------------------------+-----+---+

FAT Pell Record Layout (Record Type 4) Length = 260

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Attribute**     **Description**                  **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ----------------- -------------------------------- ---------- ---------
  1       1       Record Type       Indicator used to identify the   Char.      1
                  Indicator         Pell Payment Record.\                       
                                    Value = '4'                                 

  2       10      Current SSN       Current SSN from NSLDS of the    Char.      9
                                    student for whom the FAT is                 
                                    being generated.                            

  11      22      Current First     Current first name from NSLDS of Char.      12
                  Name              the student for whom the FAT is             
                                    being generated.\                           
                                    Value = 'NFN' if student has no             
                                    first name.                                 

  23      57      Current Last Name Current last name from NSLDS of  Char.      35
                                    the student for whom the FAT is             
                                    being generated.\                           
                                    Value = 'NLN' if student has no             
                                    last name.                                  

  58      65      Current Date of   Date of Birth from NSLDS of the  Date       8
                  Birth             student for whom the FAT is                 
                                    being generated.\                           
                                    Format is CCYYMMDD.                         

  66      73      GA Code           GA code of GA requesting FAT.    Char.      8

  74      79      Scheduled Amount  Scheduled amount of the Federal  Num.       6
                                    Pell Grant award.                           

  80      85      Amount Paid To    The amount of the Federal Pell   Num.       6
                  Date              Grant the school has disbursed              
                                    to the student.                             

  86      91      Remaining Amount  The remaining Federal Pell Grant Num.       6
                  To Pay            amount to be disbursed for the              
                                    award year.                                 

  92      95      Award Year        The Award Year for the Pell      Char.      4
                                    Grant program, beginning July 1             
                                    and ending June 30 of following             
                                    year.                                       

  96      100     Segment           Segment percentage of            Num.       5
                  Eligibility Used  eligibility used.\               999V99     
                                    Format 999V99, for example,                 
                                    10000 represents 100%.                      

  101     102     Transaction       Transaction number on the SAR or Char.      2
                  Number            ISIR for the payment accepted by            
                                    the school.                                 

  103     110     Disbursement Date Date disbursement was made or    Char.      8
                                    will be made to student. Format             
                                    is CCYYMMDD.\                               
                                    Value is date or 'N/A'.                     

  111     113     Accepted          Accepted verification status.\   Char.      3
                  Verification      Value is status or 'N/A'.                   
                  Status                                                        

  114     119     Expected Family   Index produced by the            Numeric    6
                  Contribution      Congressional Methodology (CM)              
                                    needs analysis assessment.                  

  120     125     Accepted          Accepted origination amount.     Numeric    6
                  Origination                                                   
                  Amount                                                        

  126     133     School Code       An eight-digit ED OPE Code used  Char.      8
                                    to identify the school and                  
                                    branch associated with the Pell             
                                    Grant. Last two digits equal 00             
                                    if no branch code.\                         
                                    Value is school code or 'N/A'.              

  134     134     Pell Change Flag  Indicates change to this Pell    Char.      1
                                    Grant record.\                              
                                    Value = 'Y' or 'N'.                         

  135     260     Filler            Attribute to complete record     Char.      126
                                    length.                                     
  ---------------------------------------------------------------------------------------

FAT Loan Record Layout (Record Type 5) Length = 260

+---+---+-----------------+-------------------------------+-----+---+
| * | * | **Attribute**   | **Description**               | *   | * |
| * | * |                 |                               | *Fi | * |
| P | P |                 |                               | eld | L |
| o | o |                 |                               | Fo  | t |
| s | s |                 |                               | rma | h |
| F | T |                 |                               | t** | * |
| R | O |                 |                               |     | * |
| * | * |                 |                               |     |   |
| * | * |                 |                               |     |   |
+===+===+=================+===============================+=====+===+
| 1 | 1 | Record Type     | Indicator used to identify    | Ch  | 1 |
|   |   | Indicator       | the Detail Record.\           | ar. |   |
|   |   |                 | Value = '5'.                  |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 2 | 1 | Current SSN     | Current SSN from NSLDS of the | Ch  | 9 |
|   | 0 |                 | student for whom the FAT is   | ar. |   |
|   |   |                 | being generated.              |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 2 | Current First   | Current first name from NSLDS | Ch  | 1 |
| 1 | 2 | Name            | of the student for whom the   | ar. | 2 |
|   |   |                 | FAT is being generated.\      |     |   |
|   |   |                 | Value = 'NFN' if student has  |     |   |
|   |   |                 | no first name.                |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 2 | 5 | Current Last    | Current last name from NSLDS  | Ch  | 3 |
| 3 | 7 | Name            | of the student for whom the   | ar. | 5 |
|   |   |                 | FAT is being generated.\      |     |   |
|   |   |                 | Value = 'NLN' if student has  |     |   |
|   |   |                 | no last name.                 |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 5 | 6 | Current Date of | Date of Birth from NSLDS of   | D   | 8 |
| 8 | 5 | Birth           | the student for whom the FAT  | ate |   |
|   |   |                 | is being generated.\          |     |   |
|   |   |                 | Format is CCYYMMDD.           |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 6 | 7 | GA Code         | GA code of GA requesting FAT. | Ch  | 8 |
| 6 | 3 |                 |                               | ar. |   |
+---+---+-----------------+-------------------------------+-----+---+
| 7 | 7 | Code            | Code indicating the type of   | Ch  | 2 |
| 4 | 5 |                 | loan.                         | ar. |   |
+---+---+-----------------+-------------------------------+-----+---+
| 7 | 7 | Current Loan    | Code used to identify the     | Ch  | 2 |
| 6 | 7 | Status          | current status of a student's | ar. |   |
|   |   |                 | loan.                         |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 7 | 8 | Current Loan    | Date (year, month and day)    | D   | 8 |
| 8 | 5 | Status Date     | the current loan status code  | ate |   |
|   |   |                 | became effective.\            |     |   |
|   |   |                 | Format is CCYYMMDD.           |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 8 | 9 | Outstanding     | Amount of outstanding         | Ch  | 6 |
| 6 | 1 | Principal       | principal balance.\           | ar. |   |
|   |   | Balance         | Value is balance or 'N/A'.    |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 9 | 9 | Outstanding     | Date (year, month, and day)   | Ch  | 8 |
| 2 | 9 | Principal       | the outstanding principal     | ar. |   |
|   |   | Balance Date    | balance was last updated.\    |     |   |
|   |   |                 | Format is CCYYMMDD.\          |     |   |
|   |   |                 | Value is date or 'N/A' if     |     |   |
|   |   |                 | date is not available.        |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Period Begin    | Date (year, month, and day)   | Ch  | 8 |
| 0 | 0 | Date            | the enrollment period begins  | ar. |   |
| 0 | 7 |                 | for this loan.\               |     |   |
|   |   |                 | Format is CCYYMMDD.\          |     |   |
|   |   |                 | Value is date or 'N/A' if     |     |   |
|   |   |                 | date is not available.        |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Period End Date | Date (year, month, and day)   | Ch  | 8 |
| 0 | 1 |                 | the enrollment period ends    | ar. |   |
| 8 | 5 |                 | for this loan.\               |     |   |
|   |   |                 | Format is CCYYMMDD.\          |     |   |
|   |   |                 | Value is date or 'N/A' if     |     |   |
|   |   |                 | date is not available.        |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Current GA Code | Current Guaranty Agency code  | Ch  | 3 |
| 1 | 1 |                 | or 'N/A' if not applicable.   | ar. |   |
| 6 | 8 |                 |                               |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Academic Level  | Student's academic level      | Ch  | 1 |
| 1 | 1 |                 | (grade level) at the school   | ar. |   |
| 9 | 9 |                 | when the loan was disbursed.  |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Contact Type    | Contact Type code.            | Ch  | 3 |
| 2 | 2 |                 |                               | ar. |   |
| 0 | 2 |                 | Values are:\                  |     |   |
|   |   |                 | EDR = ED Region\              |     |   |
|   |   |                 | LEN = Lender\                 |     |   |
|   |   |                 | SCH = School\                 |     |   |
|   |   |                 | GA = Guaranty Agency\         |     |   |
|   |   |                 | DLS = Direct Loan Servicer\   |     |   |
|   |   |                 | LNS = Lender Servicer\        |     |   |
|   |   |                 | N/A = Not Applicable          |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Net Loan Amount | Amount of loan/guaranty minus | N   | 6 |
| 2 | 2 |                 | total amount of               | ume |   |
| 3 | 8 |                 | cancellations.                | ric |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Contact         | Code indicating the agency to | Ch  | 8 |
| 2 | 3 |                 | be contacted for this loan.\  | ar. |   |
| 9 | 6 |                 | Value is 'N/A' if contact is  |     |   |
|   |   |                 | not available.                |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | School Code     | An eight-digit ED OPE Code    | Ch  | 8 |
| 3 | 4 |                 | used to identify the school   | ar. |   |
| 7 | 4 |                 | and branch attended by the    |     |   |
|   |   |                 | student when the loan was     |     |   |
|   |   |                 | originated. Last two digits   |     |   |
|   |   |                 | equal 00 if no branch code.   |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Additional      | Additional Unsubsidized Loan  | Ch  | 1 |
| 4 | 4 | Unsubsidized    | flag.                         | ar. |   |
| 5 | 5 | Loan Flag       |                               |     |   |
|   |   |                 | Values are:\                  |     |   |
|   |   |                 | 'P' = PLUS Denial\            |     |   |
|   |   |                 | 'H'= Health Loan Program\     |     |   |
|   |   |                 | 'B'= Both\                    |     |   |
|   |   |                 | 'N'= Neither.                 |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Capitalized     | Capitalized Interest flag.\   | Ch  | 1 |
| 4 | 4 | Interest Flag   | Value = 'Y' or 'N'.           | ar. |   |
| 6 | 6 |                 |                               |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Current         | Date latest loan disbursement | Ch  | 8 |
| 4 | 5 | Disbursement    | was made.\                    | ar. |   |
| 7 | 4 | Date            | Format CCYYMMDD.\             |     |   |
|   |   |                 | Value is date or 'N/A'.       |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Total           | Cumulative amount disbursed.\ | Ch  | 6 |
| 5 | 6 | Disbursement    | Value is amount or 'N/A'.     | ar. |   |
| 5 | 0 | Amount          |                               |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Current Lender  | Current Lender code or 'N/A'  | Ch  | 6 |
| 6 | 6 | Code            | if not available.             | ar. |   |
| 1 | 6 |                 |                               |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Current Lender  | Current Lender Servicer code  | Ch  | 6 |
| 6 | 7 | Servicer        | or 'N/A' if not applicable.   | ar. |   |
| 7 | 2 |                 |                               |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 1 | Loan Change     | Indicates change to this loan | Ch  | 1 |
| 7 | 7 | Flag            | record.\                      | ar. |   |
| 3 | 3 |                 | Value = 'Y' or 'N'.           |     |   |
+---+---+-----------------+-------------------------------+-----+---+
| 1 | 2 | Filler          | Attribute to complete record  | Ch  | 8 |
| 7 | 6 |                 | length.                       | ar. | 7 |
| 4 | 0 |                 |                               |     |   |
+---+---+-----------------+-------------------------------+-----+---+

Trailer Record Layout Length = 260

  -----------------------------------------------------------------------------------------
  **Pos\   **Pos\   **Attribute**     **Description**                  **Field\   **Lth**
  FR**     TO**                                                        Format**   
  -------- -------- ----------------- -------------------------------- ---------- ---------
  1        1        Record Type       Value = '9'                      Char.      1

  2        10       Filler            Dummy SSN for trailer record.\   Char.      9
                                      Value is '999999999'.                       

  11       52       Trailer Title     Value = 'FINANCIAL AID           Char.      42
                                      TRANSCRIPT TRAILER'.                        

  53       60       Match Count       Total count of records for which Num.       8
                                      matches were found.                         

  61       69       Record Count      Total count of detail records on Num.       9
                                      this file (excluding header and             
                                      trailer).                                   

  70       77       Error Count       Number of requests with errors.  Num.       8

  78       260      Filler            Attribute to complete record     Char.      183
                                      length.                                     
  -----------------------------------------------------------------------------------------