**National Student Loan Data System**

**Exit Counseling by SSN Report**

**(SCH01A)**

**and**

**Exit Counseling Report (SCH01B)**

**May 24, 2002**

# NSLDS Exit Counseling by SSN Report Extract File Layout (SCH01A) 

The *Exit Counseling by SSN (SCH01A)* report provides school users with
exit counseling information on students who attend the requesting
school. Users can enter up to 50 borrower SSNs, specify one of two sort
orders, and choose whether to receive the information as a formatted
report or an extract file. Schools receive the report via their SAIG
mailboxes. Additional hints for printing the report in Microsoft Word
format are available on the Report List Help page.

This section contains extract file layouts that list the header, detail,
and trailer records for the Exit Counseling by SSN Report file. Each
table contains the position, the data element name, description, field
format, and length.

Header Record Layout LRECL = 660

  ------- ------- ------------------- ------------------------------ ---------- ---------
  **Pos   **Pos   **Data Element**    **Description**                **Field    **Lth**
  FR**    TO**                                                       Format**   

  1       1                           Record Type Indicator 'H' for  Char.      1
                                      Header record.                            

  2       36      Report Description  Title of the report.           Char.      35

  37      96      Sort Description    Sort order for the report.     Char.      60

  97      660     Filler                                             Char.      564
  ------- ------- ------------------- ------------------------------ ---------- ---------

Select Record Layout LRECL = 660

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Data Element**    **Description**                **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ------------------- ------------------------------ ---------- ---------
  1       1                           Record Type Indicator 'S' for  Char.      1
                                      selection record.                         

  2       10      Number              SSN 1                          Char.      9

  11      19      Number              SSN 2                          Char.      9

  20      28      Number              SSN 3                          Char.      9

  29      37      Number              SSN 4                          Char.      9

  38      46      Number              SSN 5                          Char.      9

  47      55      Number              SSN 6                          Char.      9

  56      64      Number              SSN 7                          Char.      9

  65      73      Number              SSN 8                          Char.      9

  74      82      Number              SSN 9                          Char.      9

  83      91      Number              SSN 10                         Char.      9

  92      100     Number              SSN 11                         Char.      9

  101     109     Number              SSN 12                         Char.      9

  110     118     Number              SSN 13                         Char.      9

  119     127     Number              SSN 14                         Char.      9

  128     136     Number              SSN 15                         Char.      9

  137     145     Number              SSN 16                         Char.      9

  146     154     Number              SSN 17                         Char.      9

  155     163     Number              SSN 18                         Char.      9

  164     172     Number              SSN 19                         Char.      9

  173     181     Number              SSN 20                         Char.      9

  182     190     Number              SSN 21                         Char.      9

  191     199     Number              SSN 22                         Char.      9

  200     208     Number              SSN 23                         Char.      9

  209     217     Number              SSN 24                         Char.      9

  218     226     Number              SSN 25                         Char.      9

  227     235     Number              SSN 26                         Char.      9

  236     244     Number              SSN 27                         Char.      9

  245     253     Number              SSN 28                         Char.      9

  254     262     Number              SSN 29                         Char.      9

  263     271     Number              SSN 30                         Char.      9

  272     280     Number              SSN 31                         Char.      9

  281     289     Number              SSN 32                         Char.      9

  290     298     Number              SSN 33                         Char.      9

  299     307     Number              SSN 34                         Char.      9

  308     316     Number              SSN 35                         Char.      9

  317     325     Number              SSN 36                         Char.      9

  326     334     Number              SSN 37                         Char.      9

  335     343     Number              SSN 38                         Char.      9

  344     352     Number              SSN 39                         Char.      9

  353     361     Number              SSN 40                         Char.      9

  362     370     Number              SSN 41                         Char.      9

  371     379     Number              SSN 42                         Char.      9

  380     388     Number              SSN 43                         Char.      9

  389     397     Number              SSN 44                         Char.      9

  398     406     Number              SSN 45                         Char.      9

  407     415     Number              SSN 46                         Char.      9

  416     424     Number              SSN 47                         Char.      9

  425     433     Number              SSN 48                         Char.      9

  434     442     Number              SSN 49                         Char.      9

  443     451     Number              SSN 50                         Char.      9

  452     660     Filler                                             Char.      208
  ---------------------------------------------------------------------------------------

Extract Record Layout LRECL = 660

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Data Element**    **Description**                **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ------------------- ------------------------------ ---------- ---------
  1       1                           Record Type Indicator 'X' for  Char.      1
                                      selection record.                         

  2       10      Current SSN         Student Social Security Number Char.      9

  11      18      Date of Birth       Date of Student's Birth        Num.       8

  19      53      Current Last        Student's Last Name            Char.      35

  54      65      Current First       Student's First Name           Char.      12

  66      66      Middle Initial      Student's Middle Initial       Char.      1

  67      72      Code                Current School Code            Char.      6

  73      74      Code                Current School Branch Code     Char.      2

  75      82      Date                Date of First Disbursement     Num.       8

  83      84      Code                Type of Loan/Other Aid         Char.      2

  85      85      FFEL Duplicate      Indicator of Separate Loan     Char.      1
                  Indicator                                                     

  86      150     Name                Original School Name           Char.      65

  151     200     Street Address      Original School Street Address Char.      50

  201     220     City                Original School City           Char.      20

  221     222     St                  Original School State          Char.      2

  223     231     Zip Code            Original School Zip Code       Char.      9

  232     237     School Code         6 Digit Original School Code   Char.      6

  238     239     School Branch Code  2 Digit Original School Branch Char.      2
                                      Code                                      

  240     247     Antic Comp Dt       Date of Anticipated Completion Num.       8

  248     250     Current GA Code     Code for Guaranty Agency       Char.      3

  251     251     Academic Level      Student's Academic Level       Char.      1

  252     257     Amount              Amount of Loan/Other Aid       Num.       6

  258     263     Outstanding         Amount of Outstanding Interest Num.       6
                  Interest Balance    Balance                                   

  264     269     Outstanding         Amount of Outstanding          Num.       6
                  Principal Balance   Principal Balance                         

  270     271     Current Loan Status Code for Loan Status           Char.      2

  272     279     Current Loan Status Date of Loan Status            Num.       8
                  Date                                                          

  280     287     Period Begin Date   Date Enrollment Period Begins  Num.       8

  288     293     Total Disbursement  Amount of Disbursement         Num.       6
                  Amount                                                        

  294     299     Total Cancellation  Amount of Cancellation         Num.       6
                  Amount                                                        

  300     301     Cancel Code         Cancellation Code              Char.      2

  302     309     Period End Date     Date Enrollment Period Ends    Num.       8

  310     315     Current Lender      Code for Servicer              Char.      6
                  Servicer ID                                                   

  316     321     Current Lender Code Code for Current Holder Lender Char.      6

  322     326     Interest Rate       Interest Rate                  Num.       5
                                                                     (99.999)   

  327     327     Interest Rate Code  Type of Interest Rate          Char.      1

  328     336     Current SSN         PLUS Borrower's SSN            Char.      9

  337     348     Current First       PLUS Borrower's First Name     Char.      12

  349     383     Current Last        PLUS Borrower's Last Name      Char.      35

  384     384     Middle Initial      PLUS Borrower's Middle Initial Char.      1

  385     390     Orig Len Code       Code for Originating FFEL      Char.      6
                                      Lender                                    

  391     430     Name                Lender Name                    Char.      40

  431     480     Street Address      Lender Street Address          Char.      50

  481     500     City                Lender City                    Char.      20

  501     502     State               Lender State                   Char.      2

  503     511     Zip Code            Lender Zip Code                Char.      9

  512     576     Name                Branch Servicer Name           Char.      65

  577     626     Street Address      Branch Servicer Street Address Char.      50

  627     646     City                Branch Servicer City           Char.      20

  647     648     State               Branch Servicer State          Char.      2

  649     657     Zip Code            Branch Servicer Zip Code       Char.      9

  658     658     Error Code          Error Message                  Num.       1

  659     660     Filler                                             Char.      2
  ---------------------------------------------------------------------------------------

# NSLDS Exit Counseling Extract File Layout (SCH01B)

The *Exit Counseling (SCH01B)* report provides school users with exit
counseling information on students who attend the requesting school and
whose anticipated completion dates fall within a specified date range.
Users can enter begin and end dates for the date range, specify one of
three sort orders, and choose whether to receive the information as a
formatted report or an extract file. Schools receive the report via
their SAIG mailboxes. Additional hints for printing the report in
Microsoft Word format are available on the Report List Help page.

This section contains extract file layouts that list the header, detail,
and trailer records for the Exit Counseling by SSN Report extract file.
Each table contains the position, the data element name, description,
field format, and length.

Header Record Layout LRECL = 660

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Data Element**    **Description**                **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ------------------- ------------------------------ ---------- ---------
  1       1                           Record Type Indicator 'H' for  Char.      1
                                      Header record.                            

  2       36      Report Description  Title of the report.           Char.      35

  37      96      Sort Description    Sort order for the report.     Char.      60

  97      660     Filler                                             Char.      564
  ---------------------------------------------------------------------------------------

Select Record Layout LRECL = 660

  ---------------------------------------------------------------------------------------
  **Pos   **Pos   **Data Element**    **Description**                **Field    **Lth**
  FR**    TO**                                                       Format**   
  ------- ------- ------------------- ------------------------------ ---------- ---------
  1       1                           Record Type Indicator 'S' for  Char.      1
                                      selection record.                         

  2       451     Filler                                             Char.      449

  452     457     School Code         6-digit School Code            Char.      6

  458     459     School Branch Code  2-digit School Branch Code     Char.      2

  460     467     Antic Comp Date     Anticipated Completion date to Num.       8
                  Begin               begin.                                    

  468     475     Antic Comp Date End Anticipated Completion Date to Num.       8
                                      end.                                      

  476     660     Filler                                             Char.      185
  ---------------------------------------------------------------------------------------

Extract Record Layout LRECL = 660

  --------------------------------------------------------------------------------------
  **Pos   **Pos   **Data Element**    **Description**               **Field    **Lth**
  FR**    TO**                                                      Format**   
  ------- ------- ------------------- ----------------------------- ---------- ---------
  1       1                           Record Type Indicator 'X' for Char.      1
                                      selection record.                        

  2       10      Current SSN         Student Social Security       Char.      9
                                      Number                                   

  11      18      Date of Birth       Date of Student's Birth       Num.       8

  19      53      Current Last        Student's Last Name           Char.      35

  54      65      Current First       Student's First Name          Char.      12

  66      66      Middle Initial      Student's Middle Initial      Char.      1

  67      72      School Code         6-digit current School Code   Char.      6

  73      74      School Branch Code  2-digit current School Branch Char.      2
                                      Code                                     

  75      82      Date ID             Date of First Disbursement    Num.       8

  83      84      Code                Type of Loan/Other Aid        Char.      2

  85      85      FFEL Duplicate      Indicator of Separate Loan    Char.      1
                  Indicator                                                    

  86      150     Name                Original School Name          Char.      65

  151     200     Street Address      Original School Street        Char.      50
                                      Address                                  

  201     220     City                Original School City          Char.      20

  221     222     St                  Original School State         Char.      2

  223     231     Zip Code            Original School Zip Code      Char.      9

  232     237     Code                Original School Code          Char.      6

  238     239     Code                Original School Branch Code   Char.      2

  240     247     Antic Comp Date     Date of Anticipated           Num.       8
                                      Completion                               

  248     250     Current GA Code     Code for Guaranty Agency      Char.      3

  251     251     Academic Level      Student's Academic Level      Char.      1

  252     257     Amount              Amount of Loan/Other Aid      Num.       6

  258     263     Outstanding         Amount of Outstanding         Num.       6
                  Interest Balance    Interest Balance                         

  264     269     Outstanding         Amount of Outstanding         Num.       6
                  Principal Balance   Principal Balance                        

  270     271     Current Loan Status Code for Loan Status          Char.      2

  272     279     Current Loan Status Date of Loan Status           Num.       8
                  Date                                                         

  280     287     Period Begin Date   Date Enrollment Period Begins Num.       8

  288     293     Total Disbursement  Amount of Disbursement        Num.       6
                  Amount                                                       

  294     299     Total Cancellation  Amount of Cancellation        Num.       6
                  Amount                                                       

  300     301     Cancel Code         Cancellation Code             Char.      2

  302     309     Period End Date     Date Enrollment Period Ends   Num.       8

  310     315     Current Lender      Code for Servicer             Char.      6
                  Servicer ID                                                  

  316     321     Current Lender Code Code for Current Holder       Char.      6
                                      Lender                                   

  322     326     Interest Rate       Interest Rate                 Num.       5
                                                                    (99.999)   

  327     327     Int Rate Code       Type of Interest Rate         Char.      1

  328     336     Current SSN         PLUS Borrower's SSN           Char.      9

  337     348     Current First       PLUS Borrower's First Name    Char.      12

  349     383     Current Last        PLUS Borrower's Last Name     Char.      35

  384     384     Middle Initial      PLUS Borrower's Middle        Char.      1
                                      Initial                                  

  385     390     Orig Len Code       Code for Originating FFEL     Char.      6
                                      Lender                                   

  391     430     Name                Lender Name                   Char.      40

  431     480     Street Address      Lender Street Address         Char.      50

  481     500     City                Lender City                   Char.      20

  501     502     State               Lender State                  Char.      2

  503     511     Zip Code            Lender Zip Code               Char.      9

  512     576     Name                Branch Servicer Name          Char.      65

  577     626     Street Address      Branch Servicer Street        Char.      50
                                      Address                                  

  627     646     City                Branch Servicer City          Char.      20

  647     648     State               Branch Servicer State         Char.      2

  649     657     Zip Code            Branch Servicer Zip Code      Char.      9

  658     658     Error Code          Error Message                 Num.       1

  659     660     Filler                                            Char.      2
  --------------------------------------------------------------------------------------