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
Student Borrower Demographic – Detail Identifier Record (05) Length = 300 Pos FR Pos TO Description Type Lth. 1 1 Record Type ‘1’ – Represents Detail record Char. 1 2 10 Borrower SSN Student Borrower’s Social Security Number Char. 9 11 12 Sub Record Type Identifier of the type of detail record. Value for a Student Borrower Identifiers detail record: ‘05’ Char. 2 13 20 Source Source Code for Borrower Name Valid values are: School OPEID; GA/ED servicer code Char. 8 21 28 Effective Date Effective Date for Borrower Name Date 8 29 63 Borrower First Name First name of student borrower Char. 35 64 98 Borrower Middle Name Middle name or middle initial of student borrower Char. 35 99 133 Borrower Last Name Last name of student borrower Char. 35 134 134 Current for Source Flag Indicates that the name for the student borrower is considered current by the data provider Valid values are ‘Y’ for yes and ‘N’ for no Char. 1 135 135 Current for NSLDS Flag Indicates which of the names for the student borrower is the active or current name for that borrower on NSLDS Valid values are ‘Y’ for yes and ‘N’ for no Char. 1 136 143 Borrower DOB Borrower’s year, month and day of birth. Format CCYYMMDD Date 8 144 300 Filler Spaces Char. 157 Student Borrower Demographic – Detail Mail Address Record (10) Length = 300 Pos FR Pos TO Field Description Type Lth. 1 1 Record Type ‘1’ – Represents Detail record Char. 1 2 10 Borrower SSN Student Borrower’s Social Security Number Char. 9 11 12 Sub Record Type Identifier of the type of detail record. Value for a Student Borrower’s Mail Address detail record: ‘10’ Char. 2 13 20 Source Source Code for Borrower’s Mail Address Valid values are: School OPEID; GA/ED Servicer Code; ‘EXITCNSL’ from student completed Exit Counseling session Char. 8
211 212 Country Code Country Code of Next of Kin’s address Char. 2 213 229 Postal Code Postal Code of Next of Kin’s address Char. 17 230 241 Phone Number Phone Number of Next of Kin Char. 12 242 300 Filler Spaces Char. 59 Student Borrower Demographic – Detail Exit Counseling Reference One (35) Length = 300 Pos FR Pos TO Field Description Type Lth. 1 1 Record Type ‘1’ – Represents Detail record Char. 1 2 10 Borrower SSN Student Borrower’s Social Security Number Char. 9 11 12 Sub Record Type Identifier of the type of detail record. Value for a Student Borrower reported Exit Counseling Reference 1 detail record: ‘35’ Char. 2 13 20 Source Code Source Code for Borrower’s Reference Information reported in Exit Counseling – value ‘EXITCNSL’ Char. 8 21 28 Effective Date Effective Date for Borrower’s Reference Information Date 8 29 63 First Name Reference 1 First Name Char. 35 64 98 Last Name Reference 1 Last Name Char. 35 99 138 Street Address 1 Line 1 of Reference 1 address Char. 40 139 178 Street Address Line 2 of Reference 1 address Char. 40 179 208 City City of Reference 1 address Char. 30 209 210 State / Province Code State / Province Code of Reference 1 address Char. 2 211 212 Country Code Country Code of Reference 1 address Char. 2 213 229 Postal Code Postal Code of Reference 1 address Char. 17 230 241 Phone Number Phone Number of Reference 1 address Char. 12 242 300 Filler Spaces Char. 59 Student Borrower Demographic – Detail Exit Counseling Reference Two Record (40) Length = 300 Pos FR Pos TO Field Description Type Lth.
Student Borrower Demographic – Detail PLUS Phone Record (55) Length. = 300 Pos FR Pos TO Field Description Type Lth. 1 1 Record Type ‘1’ – Represents Detail record Char. 1 2 10 Student SSN Social Security Number of student recipient of PLUS funds Char. 9 11 12 Sub Record Type Identifier of the type of detail record. Value for a Plus Borrower Phone Number detail record: ‘55’ Char. 2 13 20 Source Code Source Code for PLUS borrower number Valid Values are: School OPEID; GA/ED Servicer Code Char. 8 21 28 Effective Date Effective Date for PLUS Borrower’s phone number Valid value ‘00000000’ Note: NSLDS does not store the date the borrower’s phone number was reported. Date 8 29 40 Phone Number Number of PLUS Borrower Char. 12 41 43 Country Code Country Code of PLUS Borrower’s Number Char. 3 44 44 Type The PLUS Borrower's phone numbers type Valid values are ‘H’ - Home, ‘C’ - Cell, ‘W’ - Work, ‘F’ - Fax, ‘O’ - Other Char. 1 45 45 Preferred Flag Preferred Flag indicates the preferred number reported by the source Valid values are ‘Y’ for yes and ‘N’ for no Char. 1 46 300 Filler Spaces Char. 255 Student Borrower Demographic – Detail PLUS Email Address Record (60) Length = 300 Pos FR Pos TO Field Description Type Lth. 1 1 Record Type ‘1’ – Represents Detail record Char. 1 2 10 Student SSN Social Security Number of student recipient of PLUS funds Char. 9 11 12 Sub Record Type Identifier of the type of detail record. Value for PLUS Borrower Email Address detail record: ‘60’ Char. 2 13 20 Source Code Source Code for PLUS Borrower’s Address Valid values: School OPEID, GA/ED servicer code Char. 8 21 28 Effective Date Effective Date for PLUS Borrower’s Email Address Date 8