**National Student Loan Data System**

**Usage Summary (SECUS1)**

**October 19, 2008**

# 1.0 NSLDS Usage Summary Extract File Layout (SECUS1) 

#### The *Usage Summary Report* (SECUS1) provides ED and the PDPA a list of the organization's online users and their NSLDS activity. Divided into two sections, the first section identifies users with active access and provides the date last logged on, average number of hours per day logged on, number of borrowers accessed, and a list of unique security email notifications generated for the user. The second section identifies information of those online users who are suspended or deactivated and provides the date and reason. If NSLDS sent more than one email for the same type of security issue, it is only listed once. Data is timeframe specific based on the beginning and end date parameters entered. Sort options include User ID and Last Name/First Name. {#the-usage-summary-report-secus1-provides-ed-and-the-pdpa-a-list-of-the-organizations-online-users-and-their-nslds-activity.-divided-into-two-sections-the-first-section-identifies-users-with-active-access-and-provides-the-date-last-logged-on-average-number-of-hours-per-day-logged-on-number-of-borrowers-accessed-and-a-list-of-unique-security-email-notifications-generated-for-the-user.-the-second-section-identifies-information-of-those-online-users-who-are-suspended-or-deactivated-and-provides-the-date-and-reason.-if-nslds-sent-more-than-one-email-for-the-same-type-of-security-issue-it-is-only-listed-once.-data-is-timeframe-specific-based-on-the-beginning-and-end-date-parameters-entered.-sort-options-include-user-id-and-last-namefirst-name. .010Ch3_Hed4 .unnumbered}

This section contains extract file layouts that list the header,
details, and trailer records for the extract version of the report. Each
online extract request is used to generate one header record, one or
more detail records, and one trailer record. Each record layout table
contains the position, the data element name, description, field format,
and length.

####  {#section .010Ch3_Hed4 .unnumbered}

#### 2.0 Usage Summary Report Record Layouts {#usage-summary-report-record-layouts .010Ch3_Hed4 .unnumbered}

> Header Record Length = 146

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

  2       35      Header Title       Value 'NSLDS USAGE SUMMARY Char.      34
                                     REPORT'                               

  36      41      Report Id          Identifier of report.      Char.      6
                                     Value 'SECUS1'                        

  42      49      Org Code           Code for the organization  Char.      8
                                     which requested the                   
                                     report.                               

  50      57      Begin Date         Lower end of date range.   Date       8

  58      65      End Date           Upper end of date range.   Date       8

  66      82      Filler             Attribute to complete      Char.      17
                                     record length.                        

  83      83      Submittal Report   'R' = Report\              Char.      1
                  Type               'E' = Extract data file               

  84      91      Submittal Date     Date which the report      Date       8
                                     request is submitted.                 
                                     Format CCYYMMDD.                      

  92      97      Submittal Time     Time which the Loan        Time       6
                                     Discharge Report request              
                                     is submitted. Format                  
                                     HHMMSS.                               

  98      146     Filler             Attribute to complete      Char.      49
                                     record length.                        
  --------------------------------------------------------------------------------

Detail Record -- Type 1 Length = 146

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

  2       2       Record Sub-Type    '1'--Represents the first  Char.      1
                                     row for the user                      

  3       10      User ID            User ID of the user who    Char.      8
                                     has online access to                  
                                     NSLDS.                                

  11      18      SAIG Mailbox       SAIG mailbox (TG number)   Char.      8
                                     of the user who has online            
                                     access to NSLDS.                      

  19      53      Last Name          Last name of the user who  Char.      35
                                     has online access to                  
                                     NSLDS.                                

  54      65      First Name         First name of the user who Char.      12
                                     has online access to                  
                                     NSLDS.                                

  66      73      Date of Last Log   Date when the user most    Date       8
                  On                 recently logged on to                 
                                     NSLDS.                                

  74      77      Average Hours      Average number of hours    Num.       4
                  Logged On          logged on during the                  
                                     specified date range. If              
                                     the user was logged on an             
                                     average of four hours and             
                                     30 minutes per day, it                
                                     would show 0045.                      

  78      86      Number of          Number of Title IV aid     Num.       9
                  Borrowers Accessed recipients whom the online            
                                     user accessed during the              
                                     specified date range.                 

  87      146     Filler             Attribute to complete      Char.      60
                                     record length.                        
  --------------------------------------------------------------------------------

> Detail Record -- Type 1A (Unique Emails) Length = 146

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

  2       2       Record Sub-Type    '2'--Represents the 2nd    Char.      1
                                     and subsequent detail rows            
                                     for each user and provides            
                                     each unique email type                

  3       10      User ID            User ID of the user who    Char.      8
                                     has online access to                  
                                     NSLDS.                                

  11      18      Filler             Attribute to complete      Char.      8
                                     record length.                        

  19      53      Last Name          Last name of the user who  Char.      35
                                     has online access to                  
                                     NSLDS.                                

  54      65      First Name         First name of the user who Char.      12
                                     has online access to                  
                                     NSLDS.                                

  66      86      Filler             Attribute to complete      Char.      21
                                     record length.                        

  87      146     Email Type         Type of warning or         Char.      60
                                     suspension email.                     
  --------------------------------------------------------------------------------

> Detail Record -- Type 2 (Users Suspended/Deactivated) Length = 146

  --------------------------------------------------------------------------------
  **Pos   **Pos   **\                **\                        **Field    **\
  FR**    TO**    Data Element**     Description**              Format**   Lth**
  ------- ------- ------------------ -------------------------- ---------- -------
  1       1       Record Type        '2'--Represents Detail     Char.      1
                                     Record Type 2                         

  2       2       Filler             Attribute to complete      Char.      1
                                     record length.                        

  3       10      User ID            User ID of the user who    Char.      8
                                     has online access to                  
                                     NSLDS.                                

  11      18      SAIG Mailbox       SAIG mailbox (TG number)   Char.      8
                                     of the user who has online            
                                     access to NSLDS.                      

  19      53      Last Name          Last name of the user who  Char.      35
                                     has online access to                  
                                     NSLDS.                                

  54      65      First Name         First name of the user who Char.      12
                                     has online access to                  
                                     NSLDS.                                

  66      73      Date of Suspension Date when user's online    Date       8
                                     access to NSLDS was                   
                                     suspended.                            

  74      86      Filler             Attribute to complete      Char.      13
                                     record length.                        

  87      146     Reason for         Reason to detail why the   Char.      60
                  Suspension         online user's access was              
                                     suspended.                            
  --------------------------------------------------------------------------------

> Trailer Record Length = 146

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

  2       10      Record Count        Total count of records.    Num.       9

  11      146     Filler              Attribute to complete      Char.      136
                                      record length.                        
  ---------------------------------------------------------------------------------