**National Student Loan Data System**

**School Loan List Report (SCHLL1)**

**April 15, 2007**

# NSLDS School Loan List Extract File Layout (SCHLL1) 

The *School Loan List (SCHLL1)* The School Loan List Report provides
School users with detailed student and loan program type information for
the requesting school and timeframe. Users can request a begin and end
date for specific loan program types. The report will select loans for a
maximum of a one year time period. When selecting the student and loan
data to display, NSLDS will query for the loan program type(s)
associated with the requesting OPEID code where the Date of
Guarantee/Loan Date falls between the begin and end dates provided. The
valid loan program type for foreign schools is FFEL. Output results
include the student\'s First and Last Name, SSN and Date Of Birth. Loan
information displayed includes Loan Amount, Total Disbursement to date,
Loan Type, Loan Date, Loan Period Begin Date and Loan Period End Date.
Cumulative totals for the loans selected will be displayed at the end of
the report. The formatted report or an extract file and sort order can
be specified by the requester. Schools users receive the processed data
via the SAIG mailbox associated with the NSLDS User ID requesting this
report.

This section contains extract file layouts that list the header, detail,
totals, and trailer records for the School Loan List batch request file
produced. Each online extract request is used to generate one header
record, one or more detail records, one or more detail total records and
one trailer record. Each record layout table contains the position, the
data element name, description, field format, and length.

School Loan List Header Record Layout Length = 187

+----+----+--------------------+-----------------------+-------+----+
| *  | *  | **Data Element**   | **Description**       | **    | *  |
| *P | *P |                    |                       | Field | *L |
| os | os |                    |                       | For   | th |
| FR | TO |                    |                       | mat** | ** |
| ** | ** |                    |                       |       |    |
+====+====+====================+=======================+=======+====+
| 1  | 1  | Record Type        | '0'--Represents       | Char. | 1  |
|    |    |                    | Header                |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 2  | 21 | Header Title       | Value 'STUDENT LOAN   | Char. | 20 |
|    |    |                    | LIST'                 |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 22 | 27 | Report ID          | Identifier of report. | Char. | 6  |
|    |    |                    | SCHLL1 or SCHLL2.     |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 28 | 33 | Code               | Code for school being | Char. | 6  |
|    |    |                    | reported on.          |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 34 | 35 | Code               | Code for school       | Char. | 2  |
|    |    |                    | branch being reported |       |    |
|    |    |                    | on.                   |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 36 | 1  | Name               | Name for school       | Char. | 65 |
|    | 00 |                    | branch being reported |       |    |
|    |    |                    | on.                   |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Loan Types         | Types of loans being  | Char. | 1  |
| 01 | 01 |                    | reported on.          |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | "B" = Both            |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | "F" = FFEL            |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | "D" = FDSLP           |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Period Begin Date  | Beginning date range  | Date  | 8  |
| 02 | 09 |                    | for the current loan. |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Period End Date    | Ending date range for | Date  | 8  |
| 10 | 17 |                    | the current loan.     |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Sort Control       | Sort sequence member  | Char. | 8  |
| 18 | 25 | Member             | name.                 |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Submittal Report   | 'R' = Report\         | Char. | 1  |
| 26 | 26 | Type               | 'E' = Extract data    |       |    |
|    |    |                    | file                  |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Submittal Date     | Date which the School | Date  | 8  |
| 27 | 34 |                    | Loan List request is  |       |    |
|    |    |                    | submitted. Format     |       |    |
|    |    |                    | CCYYMMDD.             |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Submittal Time     | Time which the School | Time  | 6  |
| 35 | 40 |                    | Loan List request is  |       |    |
|    |    |                    | submitted. Format     |       |    |
|    |    |                    | HHMMSS.               |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | First Name         | Given name of user    | Char. | 12 |
| 41 | 52 |                    | making report         |       |    |
|    |    |                    | request.              |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Last Name          | Surname of user       | Char. | 35 |
| 53 | 87 |                    | making report         |       |    |
|    |    |                    | request.              |       |    |
+----+----+--------------------+-----------------------+-------+----+

School Loan List Detail Record Layout Length = 187

+----+----+--------------------+-----------------------+-------+----+
| *  | *  | **Attribute**      | **Description**       | **    | *  |
| *P | *P |                    |                       | Field | *L |
| os | os |                    |                       | For   | th |
| FR | TO |                    |                       | mat** | ** |
| ** | ** |                    |                       |       |    |
+====+====+====================+=======================+=======+====+
| 1  | 1  | Record Type        | '1'--Represents       | Char. | 1  |
|    |    |                    | Detail                |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 2  | 36 | Last Name          | Student's last name   | Char. | 35 |
+----+----+--------------------+-----------------------+-------+----+
| 37 | 48 | First Name         | Student's first name  | Char. | 12 |
+----+----+--------------------+-----------------------+-------+----+
| 49 | 57 | SSN                | Student's SSN         | Char. | 9  |
+----+----+--------------------+-----------------------+-------+----+
| 58 | 65 | DOB                | Student's date of     | Date  | 8  |
|    |    |                    | birth                 |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 66 | 71 | Amount             | Dollar amount of loan | Nu    | 6  |
|    |    |                    |                       | meric |    |
+----+----+--------------------+-----------------------+-------+----+
| 72 | 77 | Total              | Amount of total       | Nu    | 6  |
|    |    | Disbursements      | disbursements         | meric |    |
+----+----+--------------------+-----------------------+-------+----+
| 78 | 79 | Type               | Type of loan          | Char. | 2  |
|    |    |                    |                       |       |    |
|    |    |                    | Valid types when FFEL |       |    |
|    |    |                    | is requested include: |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | PL, RF, SF, SL, SU,   |       |    |
|    |    |                    | GB                    |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | Valid types when      |       |    |
|    |    |                    | DIRECT is requested   |       |    |
|    |    |                    | include:              |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | D1, D2, D3, D4        |       |    |
|    |    |                    |                       |       |    |
|    |    |                    | All the above are     |       |    |
|    |    |                    | included when BOTH is |       |    |
|    |    |                    | requested.            |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 80 | 87 | Date               | Date of guaranty      | Date  | 8  |
+----+----+--------------------+-----------------------+-------+----+
| 88 | 95 | Period Begin Date  | Beginning date of     | Date  | 8  |
|    |    |                    | loan                  |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 96 | 1  | Period End Date    | Ending date of loan   | Date  | 8  |
|    | 03 |                    |                       |       |    |
+----+----+--------------------+-----------------------+-------+----+
| 1  | 1  | Filler             | Attribute to complete | Char. | 84 |
| 04 | 87 |                    | record length.        |       |    |
+----+----+--------------------+-----------------------+-------+----+

School Loan List Total Record Layout Length = 187

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

  2       48      Filler                Attribute to complete    Char.      47
                                        record length.                      

  49      50      Type                  Type of loan             Char.      2

  51      110     Lookup Results        Display name for loan    Char.      60

  111     122     Amount                Total loan amount        Num.       12

  123     134     Amount                Total disbursed loan     Num.       12
                                        amount                              

  135     187     Filler                Attribute to complete    Char.      53
                                        record length.                      
  -----------------------------------------------------------------------------------

School Loan List Trailer Record Layout Length = 187

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

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

  11      22      Amount                Grand total loan amount  Num.       12

  23      34      Amount                Grand total disbursed    Num.       12
                                        loan amount                         

  35      43      Student Count         Total count of distinct  Num.       9
                                        students reported on.               

  44      187     Filler                Attribute to complete    Char.      144
                                        record length.                      
  -----------------------------------------------------------------------------------