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
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 types (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. Value is amount or N/A if no applicable loans. Char. 6 363 368 Undergraduate Aggregate Unsubsidized Total 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
TSM Alert/FAH Detail Record Type 3—Overpayment 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 Overpayment Record. Value = 3. 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. Value = NFN if student has no first name. Char. 12 23 57 Current Last Name Current last name from NSLDS 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 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 ED OPE Code used to identify the school and branch. Last 2 digits equal 00 if no branch code. Char. 8
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 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 101 102 Transaction Number Transaction number on the SAR or ISIR for the payment accepted by the school. Char. 2 103 110 Latest Disbursement Date Date school made the latest disbursement. Format is CCYYMMDD. Value is date or N/A. Char. 8 111 113 Accepted Verification Status Accepted verification status. Value is status or ‘N/A’. For ACG, SMART and TEACH grants, value is “N/A”; not applicable. Char. 3
114 119 Expected Family Contribution Index produced by the Congressional Methodology (CM) needs analysis assessment. For ACG, SMART and TEACH grants value is 000000 (zeroes); not applicable. Num. 6 120 125 Award Amount Accepted origination amount. Num. 6 126 133 School Code An 8-digit OPEID code used to identify the school attended by the student with the grant. Last 2 digits equal 00 if no branch code. Char. 8 134 134 Grant Change Flag Indicates change to this grant record. Value = Y or N. Will be blank for FAH. Char. 1 135 142 Posted by COD Date disbursement was posted to the COD system. Format is CCYYMMDD. Value is date or “N/A” Char. 8 143 149 Percent of Eligibility Used Pell’s percent of scheduled award used by award year. ACG and SMART’s percent eligibility used by scheduled award. Format 999V9999 (‘V’ is implied decimal and will not be included on the output), for example, 1000000 represents 100%. For TEACH grants value is 0000000 (zeroes); not applicable. Num. 7
129 136 Contact Code indicating the agency to be contacted for this loan. Value is N/A if contact is not available. Char. 8 137 144 School Code An 8-digit OPEID code used to identify the school attended by the student when the loan was originated. Last 2 digits equal 00 if no branch code. Char. 8 145 145 Additional Unsubsidized Loan Flag Additional Unsubsidized Loan flag. Values are: P = PLUS Denial H = Health Loan Program B = Both N= Neither Char. 1 146 146 Capitalized Interest Flag Capitalized Interest flag. Value = Y or N. Char. 1 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