Student Borrower Demographic Report Header Record Layout Length = 300 Pos Pos Field Description Type Lth. FR TO 1 1 Record Type Represents Header record Char. 1 ‘0’ – 2 36 Header Title Value DEMOGRAPHIC Char. 35 ‘BORROWER REPORT’ 37 42 Report ID Identifier of report. Values: Char. 6 Ad Hoc = 'SCHBR1' Scheduled = 'SCHBR4' 43 50 Report Date Date the report was created Date 8 ‘CCYYMMDD’ 51 56 Report Time Time Prepared format Char 6 – ‘HHMMSS’ 57 62 School ID The first 6 digits of the OPEID* as assigned by Char. 6 the Office of Postsecondary Education for the school being requested. 63 64 School Branch ID The last 2 digits of the OPEID* of the school Char. 2 location as assigned by the Office of Postsecondary Education for the school being reported. If all school locations are selected (*), this field displays as “*” 65 67 Filler Spaces Char. 3 68 75 Entered Repayment Begin Beginning Date of the Date Entered Repayment Date 8 Date 76 83 Entered Repayment End Date Ending Date of the Date Entered Repayment Date 8 Range 84 103 Loan Status Category Selected loan status category: All, Open, Closed, Char. 20 Defaulted, Payment Suspended, Disability, Un-reinsured, or In-School 104 113 Loan Program Type Valid Values: Char. 10 FFELP loans only ‘FFEL’ – Direct Loans only ‘DL’ – FFELP and Direct Loans ‘BOTH’ – 114 116 Exit Counseling Flag Request Flag showing if Exit Counseling data was Char. 3 requested. values ‘YES’; ‘NO’ 117 136 Extract Type Format of the extract file values Char. 20 – ‘Comma delimited’ or (fixed-length) ‘Standard’ 137 156 Sort By SSN or Last/First Name Char. 20 157 300 Filler Spaces Char. 144
Student Borrower Demographic Report Header Record Layout Length = 300 Pos FR Pos TO Field Description Type Lth. 1 1 Record Type ‘0’ – Represents Header record Char. 1 2 36 Header Title Value ‘BORROWER DEMOGRAPHIC REPORT’ Char. 35 37 42 Report ID Identifier of report. Values: Ad Hoc = 'SCHBR1' Scheduled = 'SCHBR4' Char. 6 43 50 Report Date Date the report was created ‘CCYYMMDD’ Date 8 51 56 Report Time Time Prepared – format ‘HHMMSS’ Char 6 57 62 School ID The first 6 digits of the OPEID* as assigned by the Office of Postsecondary Education for the school being requested. Char. 6 63 64 School Branch ID The last 2 digits of the OPEID* of the school location as assigned by the Office of Postsecondary Education for the school being reported. If all school locations are selected (*), this field displays as “*” Char. 2 65 67 Filler Spaces Char. 3 68 75 Entered Repayment Begin Date Beginning Date of the Date Entered Repayment Date 8 76 83 Entered Repayment End Date Ending Date of the Date Entered Repayment Range Date 8 84 103 Loan Status Category Selected loan status category: All, Open, Closed, Defaulted, Payment Suspended, Disability, Un-reinsured, or In-School Char. 20 104 113 Loan Program Type Valid Values: ‘FFEL’ – FFELP loans only ‘DL’ – Direct Loans only ‘BOTH’ – FFELP and Direct Loans Char. 10 114 116 Exit Counseling Flag Request Flag showing if Exit Counseling data was requested. values ‘YES’; ‘NO’ Char. 3 117 136 Extract Type Format of the extract file – values ‘Comma delimited’ or ‘Standard’ (fixed-length) Char. 20 137 156 Sort By SSN or Last/First Name Char. 20 157 300 Filler Spaces Char. 144
NSLDSBorrowerDemoRptExtFileLaySCHBR1andSCHBR4.docx