What’s New! The changes for this version of the document include the following: Section Section Name Change Section 3.6 Transfer Student Monitoring Alert/Financial Aid History Batch Report Layout Added new fields: Statutory Interest Rate (pos. 268-273) Actual Interest Rate (pos. 274-279)
58 65 Current Date of Birth Date of Birth from NSLDS of the student for whom the FAH or Alert is being generated. Format is CCYYMMDD. Date 8 66 73 School Code The 8-digit OPEID code used to identify the school and branch. Last 2 digits equal 00 if no branch code. Char. 8 74 74 Defaulted Loan Flag Indicates one or more defaulted loans. = Y or N. Char. 1 75 75 Discharged Loan Code Indicates one or more discharged loans. Values are: D = Death C = Conditional P = Permanent M = Multiple N = None Char. 1 76 76 Loan Satisfactory Repayment Arrangements Flag Indicates one or more loans with satisfactory repayment arrangements. Value = Y or N. Char. 1 77 77 Active Bankruptcy Flag Indicates one or more active bankruptcy loans. Value = Y or N. Char. 1 78 83 Aggregate Subsidized Outstanding Principal Balance (Undergraduate and Graduate) Outstanding principal balance for subsidized loan types (D1, D6, and subsidized SF). Includes calculated share of a consolidation loan that is considered subsidized. Value is balance or N/A if no applicable loans. Char. 6
84 89 Aggregate Unsubsidized Outstanding Principal Balance (Undergraduate and Graduate) Outstanding principal balance for unsubsidized loan types (D2, D5, FI, RF, non-subsidized SF, SL, and SU) Includes calculated share of a consolidation loan that is considered unsubsidized. Value is balance or N/A if no applicable loans. Char. 6 90 95 Aggregate Combined Outstanding Principal Balance (Undergraduate and Graduate) Outstanding principal balance for subsidized and unsubsidized loan types (D1, D2, D5, D6, FI, RF, subsidized and non-subsidized SF, SL, and SU). Includes the total amount of a consolidation loan, excluding the calculated share that is considered to be a Perkins loan. is balance or N/A if no applicable loans. Char. 6 96 101 Filler Blank attribute to maintain record length. Char. 6 102 107 Aggregate Subsidized Pending Disbursement (Undergraduate and Graduate) Pending disbursements for subsidized loan types (D1 and subsidized SF). Value is amount or N/A if no applicable loans. Char. 6 108 113 Aggregate Unsubsidized Pending Disbursement (Undergraduate and Graduate) Pending disbursements for unsubsidized loan types (D2 and SU). Value is amount or N/A if no applicable loans. Char. 6 114 119 Aggregate Combined Pending Disbursement (Undergraduate and Graduate) Pending disbursements for subsidized and unsubsidized loan types (D1, D2, SF, and SU). Value is amount or N/A if no applicable loans. Char. 6
120 125 Aggregate Subsidized Total (Undergraduate and Graduate) Total of Aggregate Subsidized Outstanding Principal Balance and Aggregate Subsidized Pending Disbursement. Value is amount or N/A if no applicable loans. Char. 6 126 131 Aggregate Unsubsidized Total (Undergraduate and Graduate) Total of Aggregate Unsubsidized Outstanding Principal Balance and Aggregate Unsubsidized Pending Disbursement. Value is amount or N/A if no applicable loans. Char. 6 132 137 Aggregate Combined (Undergraduate and Graduate) Total of Aggregate Combined Outstanding Principal Balance and Aggregate Combined Pending Disbursement. Value is amount or N/A if no applicable loans. Char. 6 138 143 Filler Blank attribute to maintain record length. Char. 6 144 149 Perkins Total Outstanding Principal Balance Perkins loan (DU, EU, NU, PU, and IC) outstanding principal balances. Value is amount or N/A if no applicable loans. Char. 6 150 155 Perkins Current Award Year Disbursement Total Perkins loan (DU, EU, NU, PU, and IC) disbursements for award year (July-June). Value is amount or N/A if no applicable loans. Char. 6 156 156 Direct Stafford MPN Flag Direct Loan Stafford Master Promissory Note Flag. Values are: A = Active status I = Inactive status C = Closed status N = No loans with a Master Promissory Note Char. 1
315 320 Undergraduate Aggregate Subsidized Outstanding Principal Balance Outstanding principal balance for undergraduate subsidized loan types (D1, D6, and subsidized SF). Includes calculated share of an undergraduate consolidation loan that is considered subsidized. Value is amount or N/A if no applicable loans. Char. 6 321 326 Undergraduate Aggregate Unsubsidized Outstanding Principal Balance Outstanding principal balance for undergraduate unsubsidized loan types (D2, D5, FI, RF, non-subsidized SF, SL, and SU). Includes calculated share of an undergraduate consolidation loan that is considered unsubsidized. Value is amount or N/A if no applicable loans. Char. 6 327 332 Undergraduate Aggregate Combined Outstanding Principal Balance Outstanding principal balance for undergraduate subsidized and unsubsidized loan types (D1, D2, D5, D6, FI, RF, subsidized and SF, SL, and SU). Includes the total amount of an undergraduate consolidation loan, excluding the calculated share that is considered to be a Perkins loan. Value is amount or N/A if no applicable loans. Char. 6 333 338 Undergraduate Aggregate Consolidation Loans, Unallocated Outstanding Principal Balance Outstanding principal balance for undergraduate consolidation loan amount determined to be unallocated. Value is amount or N/A if no applicable loans. Char. 6
339 344 Undergraduate Aggregate Subsidized Pending Disbursement Pending disbursements for undergraduate subsidized loan types (D1 and subsidized SF). Value is amount or N/A if no applicable loans. Char. 6 345 350 Undergraduate Aggregate Unsubsidized Pending Disbursement Pending disbursements for undergraduate unsubsidized loan (D2 and SU). Value is amount or N/A if no applicable loans. Char. 6 351 356 Undergraduate Aggregate Combined Pending Disbursement Pending disbursements for undergraduate subsidized and unsubsidized loan types (D1, D2, SF, and SU). Value is amount or N/A if no applicable loans. Char. 6 357 362 Undergraduate Aggregate Subsidized Total Total of Undergraduate Aggregate Subsidized Outstanding Principal Balance and Undergraduate Aggregate Subsidized Pending Disbursements. is amount or N/A if no applicable loans. Char. 6 363 368 Undergraduate Aggregate Unsubsidized Total of Undergraduate Aggregate Unsubsidized Outstanding Principal Balance and Undergraduate Aggregate Unsubsidized Pending Disbursements. Value is amount or N/A if no applicable loans. Char. 6 369 374 Undergraduate Aggregate Combined Total Total of Undergraduate Aggregate Combined Outstanding Principal Balance and Undergraduate Aggregate Combined Pending Disbursements. Value is amount or N/A if no applicable loans. Char. 6
398 403 Graduate Aggregate Combined Outstanding Principal Balance Outstanding principal balance for graduate subsidized and unsubsidized loan types (D1, D2, D5, D6, FI, RF, subsidized and non-subsidized SF, SL, and SU). Includes the total amount of a graduate consolidation loan, excluding the calculated share that is considered to be a Perkins loan. is amount or N/A if no applicable loans. Char. 6 404 409 Graduate Aggregate Consolidation Loans, Unallocated Outstanding Principal Balance Outstanding principal balance for graduate consolidation loan amount determined to be unallocated. Value is amount or N/A if no applicable loans. Char. 6 410 415 Graduate Aggregate Subsidized Pending Disbursement Pending disbursements for graduate subsidized loan (D1 and subsidized SF). is amount or N/A if no applicable loans. Char. 6 416 421 Graduate Aggregate Unsubsidized Pending Disbursement Pending disbursements for graduate unsubsidized loan types (D2 and SU). Value is amount or N/A if no applicable loans. Char. 6 422 427 Graduate Aggregate Combined Pending Disbursement Pending disbursements for graduate subsidized and unsubsidized loan (D1, D2, SF, and SU). Value is amount or N/A if no applicable loans. Char. 6
457 463 Lifetime Eligibility Used (LEU) The Lifetime Eligibility Used (LEU) for Pell grants expressed as a decimal Format is 99v99999 (‘V’ is implied decimal and will not be included on the output). Example: 12.34567 is 1234.567 %. 01.00000 is 0100.000%. For ACG, SMART and TEACH grants value is 0000000 (zeroes); not applicable. Num. 7 464 464 Unusual Enrollment History Indicator Indicates a student’s Pell Grant awarding activity pattern that looks suspicious. Valid values: 2 = Possible enrollment history problem 3 = Questionable enrollment history N = No problem Char. 1 465 465 LEU Limit Indicator Indicates the limit reached for the Pell Grant Lifetime Eligibility Used. values: E = Limit met or exceeded C = Close to limit H = High % warning N = No problem Char. 1 466 466 SULA Flag Subsidized Usage Limit Applies (SULA) indicator on loan. Y = The borrower is subject to the 150% Direct Subsidized Loan Limit provision. N = The borrower is not subject to the 150% Direct Subsidized Loan provision. Char. 1
TSM Alert/FAH Detail Record Type 4—Grant Payment Record Layout Length = 500 Pos. From Pos. To Added/ Modified Attribute Description Field Format Field Length 1 1 Record Type Indicator Indicator used to identify the Grant Payment Record. Value = 4. Char. 1 2 10 Current SSN Current SSN from NSLDS of the student for whom the FAH or Alert is being generated. Char. 9 11 22 Current First Name Current first name from NSLDS of the student for whom the FAH or Alert is being generated. = NFN if student has no first name. Char. 12 23 57 Current Last Name Current last name from of the student for whom the FAH or Alert is being generated. Value = NLN if student has no last name. Char. 35 58 65 Current Date of Birth Date of from NSLDS of the student for whom the FAH or Alert is being generated. Format is CCYYMMDD. Date 8 66 73 School Code The 8-digit OPEID code used to identify the school and branch. Last 2 digits equal 00 if no branch code. Char. 8 74 79 Scheduled Amount Scheduled amount of the Federal Pell grant. TEACH grant scheduled award is $4,000. Num. 6 80 85 Disbursed Amount The amount of the Federal grant the school has disbursed to the student. Num. 6 86 91 Filler Spaces. Char. 6 92 95 Award Year The Award Year for the grant program, beginning July 1 and ending June 30 of following year. Char. 4 96 100 Filler Spaces. Char. 5
155 160 Total Disbursement Amount Cumulative amount disbursed. Value = amount or N/A. Char. 6 161 166 Lender Code Current Lender code or N/A if not applicable. Char. 6 167 172 Lender Servicer Code Current Lender Servicer code or N/A if not applicable. Char. 6 173 173 Loan Change Flag Indicates change to this loan record. There will be a space for FAH records. Value = Y or N. Char. 1 174 179 Calculated Subsidized Aggregate OPB Amount included in Subsidized Aggregate calculation. Value = amount or 000000. Char. 6 180 185 Calculated Unsubsidized Aggregate OPB Amount included in Unsubsidized Aggregate calculation. = amount or 000000. Char. 6 186 191 Calculated Combined Aggregate OPB Amount included in Combined Aggregate calculation. Value = amount or 000000. Char. 6 192 197 Consolidation Unallocated Aggregate OPB Amount that could not be determined to be subsidized, unsubsidized or Perkins. Value = amount or 000000. Char. 6 198 203 Last Disbursement Amount Amount of last disbursement Value = amount or N/A Char. 6
280 500 Modified field for 2018-2019 Filler Spaces Char. 221 TSM/FAH Trailer Record Layout The last record in the file will be a Trailer record, which will be populated as described in the following table. Fields for which no definition is provided were determined to be self-explanatory. TSM Trailer Record Layout Length = 500 Pos. From Pos. To Added/ Modified Attribute Description Field Format Field 1 1 Record Type Indicator Indicator used to identify the trailer record. Value = 9. Char. 1 2 47 Trailer Title used to identify the trailer record. Value = TSM ALERT TRAILER or FAH TRAILER. Char. 46 48 56 Record Count count of detail records on this file (excluding header and trailer). Num. 9 57 500 Filler Spaces. Char. 444