Trailer Record Message Classes There will be multiple message classes for the TSM/FAH batch files: one each for the Inform, the Error/Acknowledgment, the report format TSM Alert, the extract format TSM Alert, the report format FAH, and the extract format FAH. The message class names used to send/receive these files are listed in the following chart: Message Class Process flow SAIG Mailbox(2) (send/receive) Description TRNINFIN From school/servicer to processor (NSLDS) School/servicer sends to TG53163 School Batch Inform/FAH request file (used for both FAH requests and/or TSM batch informs—See record layout to indicate request type(s) and format). TRNINFOP (1)(3) From processor (NSLDS) to school/servicer School/servicer receives from TG53162 Error/Acknowledgement file (used by both FAH requests and TSM batch informs.) Each properly formatted TRNINFIN file will generate an error/acknowledgement file). From processor (NSLDS) to school/servicer School/servicer receives from TG50012 FAH processed output file in extract format. FAHREPOP(5) From processor (NSLDS) to school/servicer School/servicer receives from TG50012 FAH processed output file in report format. TRLTRPOP From processor (NSLDS) to school/servicer School/servicer receives from TG53162 Transfer Student Monitoring Alert output file in report format. TRALRTOP(6) From processor (NSLDS) to school/servicer School/servicer receives from TG53162 Transfer Student Monitoring Alert output file in extract format. (1) If an error/acknowledgement file is not sent to the schools, or the school servicer’s, receiving SAIG mailbox within the next business day, contact NSLDS Customer Support (800-999-8219) for assistance. (2) The Department of Education’s (ED’s) transmission software has the mailboxes predefined. (3) This message class and corresponding record layout is also generated when requesting the FAT001 Web report from the NSLDS Professional Access Web site .
TSM Alert/FAH Header 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 header record. Value = 0 (zero). Char. 1 2 47 Header Title Title used to identify the header record. Value = FAH HEADER or TSM ALERT HEADER. Char. 46 48 55 School Code The 8-digit OPEID code used to identify the school and branch receiving the record. Last 2 digits equal 00 if no branch code. Char. 8 56 63 Servicer Code For Alerts, fill with 00000000 (zeroes). For FAH, return values from original submittal file. Char. 8 64 64 Report Type Type of format in which the file is provided. Values are: R = formatted report file is generated E = an extract file is generated Char. 1 65 72 Date Date on which the Alert or FAH was generated by NSLDS. Format CCYYMMDD. Date 8 73 74 Sequence Number Used to differentiate between multiple FAH and Alert files generated on the same date. Starts with 01 and increments for subsequent files. Char. 2 75 500 Filler Spaces. Char. 426
244 244 Direct Loan PLUS MPN Flag Direct Loan PLUS Graduate/Professional Master Promissory Note Flag. Values are: A = Active status I = Inactive status E = Inactive, Endorsed C = Closed status N = No loans with a Master Promissory Note Char. 1 245 245 Fraud Flag Indicates fraud on one or more loans or overpayments. Value = Y or N. Char. 1 246 251 Aggregate PLUS Outstanding Principal Balance Outstanding principal balance for PLUS Graduate/Prof. loan types (D3 and GB). Value is amount or “N/A” if no applicable loans. Char. 6 252 257 Aggregate PLUS Total Total for PLUS Graduate/Prof. loan types (D3 and GB). Value is amount or “N/A” if no applicable loans. Char. 6 258 258 Graduate Subsidized Loan Limit Flag Flag indicating the condition of the Aggregate Total for subsidized loan limit (Loan types include: D1, D6, subsidized SF, and calculated share of consolidation loan considered to be subsidized.) for a borrower with cumulative balances having undergraduate and graduate loans. Values are E, C, N, or R. Char. 1
274 279 Aggregate Total TEACH Grant Undergraduate Disbursement Amount Aggregate Undergraduate/Post Baccalaureate TEACH grant disbursed amounts for the following Academic Levels: 0 = 1st year undergraduate/never attended college, 1 = 1st year undergraduate/attended college before. 2 = 2nd year 3 = 3rd year undergraduate/junior. 4 = 4th year undergraduate/senior. 5 = 5th year/other undergraduate. Value is amount or N/A if no applicable grants. Char. 6 280 286 Undergraduate % Eligibility Used TEACH grant’s awarded percent used by Undergraduate/Post Baccalaureate Academic Levels. Format 999V9999 (‘V’ is implied decimal and will not be included on the output), for example, 1000000 represents 100%. Num. 7 287 292 Undergraduate Remaining Amount The remaining eligible amount by Undergraduate/Post Baccalaureate Academic Levels. Value is amount or N/A if no applicable grants. Char. 6
147 154 Last Disbursement Date Date latest loan disbursement was made. Format CCYYMMDD. Value = date or N/A. Char. 8 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. Value = 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
221 241 Data Provider Loan ID/Award ID For FFEL and Perkins loans, Data Provider Loan ID used by data provider (Guaranty Agency or Debt Management Collection Service for FFEL or Perkins held loans) for internal loan identification. For Direct Loans and FFEL loans purchased by ED, Award ID used by Federal Loan Servicers (including the Direct Loan Servicing System) data providers for loan identification. For TEACH loans, Award ID originated by COD for the TEACH grant, which is retained when converted to a TEACH loan. Char. 21 242 242 Confirmed Loan Subsidy Status Indicates the current status of a SULA eligible loan’s subsidy as reported by the servicer. L = Lost Subsidy R = Reinstated Subsidy N = Not Applicable Char. 1 243 250 Subsidy Status Date Date the subsidy status went into effect as reported to NSLDS. Format is CCYYMMDD. Value is date or N/A if date is not available. Char. 8 251 258 Academic Year Begin Date The date when the student's academic year begins (or has begun) for the period covered by the loan. Format is CCYYMMDD. Value is date or N/A if date is not available. Char. 8