description: tags: 2006-2007nsldsupdateoffat001extract-recordlayouts

8/14/2019 description: tags: 2006-2007NSLDSUPDATEofFAT001EXTRACT-RECORDLAYOUTS

1/19

National Student Loan Data System

Request for Financial Aid History Report(FAT001)

Record File Layouts

January 30, 2006


2/19


3/19

1.0FAT001 Header File Layout

FAT001 Header Record Layout Length = 260

Pos.From

Pos.To

Added/Modified

Attribute Description FieldFormat

FieldLength

1 1 Record Type Indicator Indicator used to identify theheader record.

Value = 0 (zero).

Char. 1

2 47 Header Title Title used to identify the header record.

Value = FAH HEADER

Char. 46

48 55 School Code The 8-digit ED OPE Code usedto identify the school and

branch receiving the record.Last 2 digits equal 00 if no

branch code.

Char. 8

56 63 Servicer Code Returned values from originalsubmittal file.

Char. 8

64 64 Report Type Type of format in which the fileis provided.

Values are:R = formatted report file is

generated (for NSLDSinternal use only)

E = an extract file isgenerated

Char. 1

65 72 Date Date on which the FAH wasgenerated by NSLDS.

Format CCYYMMDD.

Date 8

73 74 Sequence Number Used to differentiate betweenmultiple FAH files generated onthe same date.

Starts with 01 and incrementsfor subsequent files.

Char. 2

75 260 Filler Blank attribute to completerecord length.

Char. 186

January 30, 2006 Request for Financial Aid History Report (FAT001)

1


4/19

1.1FAT001 Detail Record Layout

(Type 1Aggregates, Perkins, and Flags Record)

FAT001 Detail Record Type 1Aggregate, Perkins, Flags Record Layout Length = 260

Pos.From Pos.To Added/Modified Attribute Description FieldFormat FieldLength

1 1 Record Type Indicator Indicator used to identify therecord.

Value = 1.

Char. 1

2 10 Current SSN Current SSN from NSLDS of thestudent for whom the FAH is

being generated.

Char. 9

11 22 Current First Name Current first name from NSLDSof the student for whom the FAHis being generated.

Value = NFN if student has nofirst name.

Char. 12

23 57 Current Last Name Current last name from NSLDSof the student for whom the FAHis being generated.

Value = NLN if student has nolast name.

Char. 35

58 65 Current Date of Birth Date of Birth from NSLDS of the student for whom the FAH is

being generated.

Format is CCYYMMDD.

Date 8

66 73 School Code The 8-digit ED OPE Code usedto identify the school andbranch. Last 2 digits equal 00 ifno branch code.

Char. 8

74 74 Defaulted Loan Flag Indicates one or more defaultedloans.

Value = Y or N.

Char. 1

75 75 Discharged Loan Code Indicates one or more dischargedloans.

Values are:D = DeathR = Reaffirm

C = ConditionalP = PermanentM = Multiple

N = None

Char. 1

76 76 Loan SatisfactoryRepaymentArrangements Flag

Indicates one or more loans withsatisfactory repaymentarrangements.

Value = Y or N.

Char. 1


2


5/19

Pos.From

Pos.To

Added/Modified


FieldLength

77 77 Active Bankruptcy Flag Indicates one or more activebankruptcy loans.

Value = Y or N.

Char. 1

78 83 Aggregate SubsidizedOutstanding PrincipalBalance

Outstanding principal balancefor subsidized loan types (D1,D6, and subsidized SF). Includescalculated share of aconsolidation loan that isconsidered subsidized.

Value is balance or N/A if noapplicable loans.

Char. 6

84 89 AggregateUnsubsidizedOutstanding PrincipalBalance

Outstanding principal balancefor unsubsidized loan types (D2,D5, FI, RF, non-subsidized SF,SL, and SU) Includes calculated

share of a consolidation loanthat is considered unsubsidized.


Char. 6

90 95 Aggregate CombinedOutstanding PrincipalBalance

Outstanding principal balancefor subsidized and unsubsidizedloan types (D1, D2, D5, D6, FI,RF, subsidized and non-subsidized SF, SL, and SU).Includes the total amount of aconsolidation loan, excludingthe calculated share that isconsidered to be a Perkins loan.


Char. 6

96 101 Modified

Changed field tofiller

Filler Blank attribute to maintainrecord length.

Char. 6

102 107 Aggregate SubsidizedPending Disbursement

Pending disbursements forsubsidized loan types (D1 andsubsidized SF).

Value is amount or N/A if noapplicable loans.

Char. 6

108 113 AggregateUnsubsidized PendingDisbursement

Pending disbursements forunsubsidized loan types (D2 andSU).


Char. 6


3


6/19

Pos.From

Pos.To

Added/Modified


FieldLength

114 119 Aggregate CombinedPending Disbursement

Pending disbursements forsubsidized and unsubsidizedloan types (D1, D2, SF, andSU).


Char. 6

120 125 Aggregate SubsidizedTotal

Total of Aggregate SubsidizedOutstanding Principal Balance

plus Aggregate SubsidizedPending Disbursement.


Char. 6

126 131 AggregateUnsubsidized Total

Total of Aggregate UnsubsidizedOutstanding Principal Balance

plus Aggregate Unsubsidized

Pending Disbursement.Value is amount or N/A if noapplicable loans.

Char. 6

132 137 Aggregate CombinedTotal

Total of Aggregate CombinedOutstanding Principal Balance

plus Aggregate CombinedPending Disbursement.


Char. 6

138 143 Modified

Changed field to

filler

Filler Blank attribute to maintainrecord length.

Char. 6

144 149 Perkins TotalOutstanding PrincipalBalance

Total Perkins loan (DU, EU,NU, PU, and IC) outstandingprincipal balances.


Char. 6

150 155 Perkins Current AwardYear Disbursement

Total Perkins loan (DU, EU,NU, PU, and IC) disbursementsfor award year (July-June).


Char. 6

156 156 Direct Stafford MPNFlag Direct Loan Stafford MasterPromissory Note Flag.

Values are:A = Active statusI = Inactive statusC = Closed status

N = No loans with a MasterPromissory Note

Char. 1


4


7/19

Pos.From

Pos.To

Added/Modified


FieldLength

157 159 . Filler Blank attribute to completerecord length.

Char. 3

160 171 First Name First name of student submitted. Char. 12

172 206 Last Name Last name of student submitted. Char. 35

207 214 Date of Birth Date of Birth of studentsubmitted.Format is CCYYMMDD.

Date 8

215 215 Direct PLUS MPN Flag Direct Loan PLUS Master Promissory Note Flag.

Values are:A = Active statusI = Inactive statusC = Closed status

N = No loans with a MasterPromissory Note

Char. 1

216 216 Exceeds SubsidizedLoan Limit Flag

Flag indicating the condition ofthe Aggregate OPB forsubsidized loan limit (Loan typesinclude: D1, D6, subsidized SF,and calculated share ofconsolidation loan considered to

be subsidized.)

Values are E, C, or N.

Char. 1

217 217 Exceeds CombinedLoan Limit Flag

Flag indicating the condition ofthe Aggregate OPB combinedloan limit.

Values are E, C, or N.

Char. 1

218 223 Modified

Removed theterm FFEL

AggregateConsolidation Loans,UnallocatedOutstanding PrincipalBalance

Aggregate Outstanding principalbalance for Consolidation Loans,Unallocated.

Value is amount or N/A if nounallocated balance.

Char. 6

224 229 Aggregate PLUS LoansOutstanding PrincipalBalance

Outstanding principal balancefor PLUS loan types (PL, D4,and D7). Will be populated whenthe borrower is the PLUS loanholder.

Value is amount or N/A if no

applicable loans.

Char. 6

230 235 Modified

Removed theterm FFEL

AggregateConsolidation Loans,Unallocated Total

Aggregate Total forConsolidation Loans,Unallocated.

Value is amount or N/A if nounallocated balance.

Char. 6


5


8/19

Pos.From

Pos.To

Added/Modified


FieldLength

236 241 Aggregate PLUS LoansTotal

Total for PLUS loan types (PL,D4, and D7). Will be populatedwhen the borrower is the PLUSloan holder.


Char. 6


Char. 19


6


9/19


(Type 2Name History Record)

FAT001 Detail Record Type 2Name History Record Layout Length = 260


1 1 Record Type Indicator Indicator used to identify theName History record.

Value = 2.

Char. 1

2 10 Current SSN Current SSN from NSLDS of the student for whom the FAH is

being generated.

Char. 9



Char. 12



Char. 35

58 65 Current Date of Birth Date of Birth from NSLDS of the student for whom the FAH is

being generated.

Format is CCYYMMDD.

Date 8

66 73 School Code An 8-digit ED OPE Code usedto identify the school andbranch. Last 2 digits equal 00 ifno branch code.

Char. 8

74 85 First Name History Other first name used by thestudent for whom the FAH is

provided.


Char. 12

86 86 Middle Initial History Other middle initial used by thestudent for whom the FAH is

provided, if available.

Char. 1

87 121 Last Name History Other last name used by thestudent for whom the FAH is

provided.


Char. 35


Char. 139


7


10/19

1.3FAT Detail Record Layout

(Type 3Overpayment Record)

FAT001 Detail Record Type 3Overpayment Record Layout Length = 260


1 1 Record TypeIndicator

Indicator used to identify theOverpayment Record.

Value = 3.

Char. 1

2 10 Current SSN Current SSN from NSLDS of thestudent for whom the FAH is beinggenerated.

Char. 9

11 22 Current First Name Current first name from NSLDS of the student for whom the FAH is

being generated.

Value = NFN if student has no firstname.

Char. 12

23 57 Current Last Name Current last name from NSLDS of the student for whom the FAH is

being generated.

Value = NLN if student has no lastname.

Char. 35

58 65 Current Date of Birth

Date of Birth from NSLDS of thestudent for whom the FAH is beinggenerated.

Format is CCYYMMDD.

Date 8

66 73 School Code The 8-digit ED OPE Code used toidentify the school and branch. Last2 digits equal 00 if no branch code.

Char. 8

74 75 Overpayment Type A 2-character code that identifiesthe type of Overpayment(s) reportedfor the student.

PE = Pell grantSE = Federal Supplemental

Educational OpportunityGrant

PK = Perkins loan (loan types DU,EU, NU, or PU).

Char. 2

76 76 OverpaymentIndicator

One-character code that identifiesthe status of the Overpayment.

Y = Yes, an active Overpaymentexists

S = Yes, the student has anOverpayment, but has madesatisfactory arrangements forrepayment.

Char. 1


8


11/19

Pos.From

Pos.To

Added/Modified


FieldLength

77 80 Award Year Award Year on which theoverpayment was disbursed.

Char. 4

81 88 Contact Contact for Pell overpayment.

Value is contact code when oneoverpayment, or Y when more thanone overpayment.

Char. 8

89 260 Filler Blank attribute to complete recordlength.

Char. 172


9


12/19


(Type 4Pell Payment Record)

FAT001 Detail Record Type 4Pell Payment Record Layout Length = 260



Indicator used to identify the PellPayment Record.

Value = 4.

Char. 1

2 10 Current SSN Current SSN from NSLDS of thestudent for whom the FAH is

being generated.

Char. 9



Char. 12



Char. 35

58 65 Current Date of Birth Date of Birth from NSLDS of thestudent for whom the FAH is

being generated.

Format is CCYYMMDD.

Date 8

66 73 School Code The 8-digit ED OPE Code usedto identify the school and branch.Last 2 digits equal 00 if no

branch code.

Char. 8

74 79 Scheduled Amount Scheduled amount of the FederalPell grant award.

Num. 6

80 85 Disbursed Amount The amount of the Federal Pellgrant the school has disbursed tothe student.

Num. 6


Char. 6

92 95 Award Year The Award Year for the Pell grant

program, beginning July 1 andending June 30 of following year.

Char. 4

96 100 Percent of EligibilityUsed

Segment percentage of eligibilityused.

Format 999V99, for example,10000 represents 100%.

Num.999V99

5


10


13/19

Pos.From

Pos.To

Added/Modified


FieldLength

101 102 Transaction Number Transaction number on the SAR or ISIR for the payment accepted

by the school.

Char. 2

103 110 Latest DisbursementDate Date school made the latestdisbursement.

Format is CCYYMMDD.

Value is date or N/A.

Char. 8

111 113 Accepted VerificationStatus

Accepted verification status.

Value is status or N/A.

Char. 3

114 119 Expected FamilyContribution

Index produced by theCongressional Methodology(CM) needs analysis assessment.

Num. 6

120 125 Award Amount Accepted origination amount. Num. 6

126 133 School Code An 8-digit ED OPE Code used toidentify the school and branchattended by the student with thePell grant. Last 2 digits equal 00if no branch code.

Char. 8


Char. 1

135 142 Posted by Pell Date disbursement was posted tothe Pell system.Format is CCYYMMDD.

Value is date or N/A.

Char. 8


Char. 118


11


14/19


(Type 5Loan Detail Record)

FAT001 Detail Record Type 5Loan Detail Record Layout Length = 260



Indicator used to identify theDetail Record.

Value = 5.

Char. 1

2 10 Current SSN Current SSN from NSLDS of the student for whom theFAH is being generated.

Char. 9

11 22 Current First Name Current first name fromNSLDS of the student forwhom the FAH is beinggenerated.

Value = NFN if student hasno first name.

Char. 12

23 57 Current Last Name Current last name fromNSLDS of the student forwhom the FAH is beinggenerated.

Value = NLN if student hasno last name.

Char. 35

58 65 Current Date of Birth Date of Birth from NSLDS ofthe student for whom theFAH is being generated.

Format is CCYYMMDD.

Date 8

66 73 School Code An 8-digit ED OPE Codeused to identify the schooland branch. Last 2 digitsequal 00 if no branch code.

Char. 8

74 75 Loan Type Code Code indicating the type of loan.

Char. 2

76 77 Current Loan StatusCode

Code used to identify thecurrent status of a studentsloan.

Char. 2

78 85 Current Loan StatusDate

Date the current loan statuscode became effective.

Format is CCYYMMDD.

Date 8

86 91 Outstanding PrincipalBalance

Amount of outstandingprincipal balance.

Value is balance or N/A.

Char. 6


12


15/19

Pos.From

Pos.To

Added/Modified


FieldLength

92 99 Outstanding PrincipalBalance Date

Date the outstandingprincipal balance was lastupdated. Format isCCYYMMDD.

Value is date or N/A if date isnot available.

Char. 8

100 107 Loan Period BeginDate

Date the enrollment periodbegins for this loan.Format is CCYYMMDD.Value is date or N/A if date isnot available.

Char. 8

108 115 Loan Period EndDate

Date the enrollment periodends for this loan.Format is CCYYMMDD.Value is date or N/A if date isnot available.

Char. 8

116 118 Current GA Code Current Guaranty Agencycode or N/A if not applicable.

Char. 3


13


16/19

Pos.From

Pos.To

Added/Modified


FieldLength

119 119 Academic Level Students academic level atthe school when the loan wasdisbursed.

Values are:1 = Freshman/First Year

(including proprietaryinstitution programs thatare less than 1 year induration)

2 = Sophomore/Second Year3 = Junior/Third Year4 = Senior/Fourth Year5 = Fifth/Other

Undergraduate (mayinclude sixth yearundergraduate andcontinuing education

students)A = First YearGraduate/Professional

B = Second YearGraduate/Professional

C = Third YearGraduate/Professional

D = Beyond Third YearGraduate/Professional

G = Graduate/Professional,year of study unknown

N = Not available (to be usedonly if the date of thefirst disbursement is

prior to July 23, 1992,and data provider doesnot have requiredattribute)

Char. 1

120 122 Modified

Added a Contacttype

Contact Type Contact Type code.Values are:

EDR = ED RegionLEN = LenderSCH = SchoolGA = Guaranty AgencyDLS = Direct Loan

ServicerLNS = Lender Servicer

DDP = Disability DataProviderRDS = CDDTS

RepaymentServicing

N/A = Not Applicable

Char. 3

123 128 Net Loan Amount Amount of loan/guarantyminus total amount ofcancellations and refunds.

Num. 6


14


17/19

Pos.From

Pos.To

Added/Modified


FieldLength

129 136 Contact Code indicating the agencyto be contacted for this loan.Value is N/A if contact is notavailable.

Char. 8

137 144 School Code An 8-digit ED OPE Codeused to identify the schooland branch attended by thestudent when the loan wasoriginated. Last 2 digitsequal 00 if no branch code.

Char. 8

145 145 AdditionalUnsubsidized LoanFlag

Additional UnsubsidizedLoan flag.

Values are:

P = PLUS DenialH = Health Loan ProgramB = Both

N= Neither

Char. 1

146 146 Capitalized InterestFlag

Capitalized Interest flag.

Value = Y or N.

Char. 1

147 154 Last DisbursementDate

Date latest loan disbursementwas made.Format CCYYMMDD.

Value = date or N/A.

Char. 8

155 160 Total DisbursementAmount

Cumulative amountdisbursed.

Value = amount or N/A.

Char. 6

161 166 Lender Code Current Lender code or N/Aif not applicable.

Char. 6

167 172 Lender Servicer Code Current Lender Servicer codeor N/A if not applicable.

Char. 6


Char. 1

174 179 Modified

Removed thereference to CLLoan Type only

CalculatedSubsidized AggregateOPB

Amount included inSubsidized Aggregatecalculation.

Value = amount or 000000.

Char. 6

180 185 Modified


Calculated

UnsubsidizedAggregate OPB

Amount included in

Unsubsidized Aggregatecalculation.


Char. 6

186 191 Modified


Calculated CombinedAggregate OPB

Amount included inCombined Aggregatecalculation.


Char. 6


15


18/19

Pos.From

Pos.To

Added/Modified


FieldLength

192 197 Modified

Removed the termFFEL and

reference to CLLoan Type only

ConsolidationUnallocatedAggregate OPB

Amount that could not bedetermined to be subsidized,unsubsidized, or Perkins.


Char. 6

198 203 Last DisbursementAmount

Amount of last disbursementValue = amount or N/A

Char. 6

204 206 Added

New for 2006-2007

Perkins CancellationType Code

Loan cancellation reasons.

Values are:

DT = Defense Teacher

PB = PerkinsBankruptcy

PD = Perkins Death

PE = Perkins Early

InterventionPI =Perkins Disability

PL = Perkins LawEnforcement

PM = Perkins MilitaryService

PN = PerkinsNurse/Medical Technician

PS = Perkins SubjectMatter Area

PT = Perkins TeacherService

PV = Perkins VolunteerService

N/A

Char. 3

207 212 Added

New for 2006-2007

Loan Amount Guaranteed/approved loanamount.

Value is amount or N/A.

Char. 6

213 220 Added

New for 2006-2007

Loan Date Date of loanguarantee/approval.

Format CCYYMMDD.

Value = date or N/A.

Char. 8


Char. 40


16


19/19

1.6FAT001 Trailer Record Layout

FAT001 Trailer Record Layout Length = 260

Pos.From

Pos.To

Added/Modified


FieldLength

1 1 Record Type Indicator Indicator used to identify thetrailer record.Value = 9.

Char. 1

2 47 Trailer Title Title used to identify the trailer record.Value = FAH TRAILER.

Char. 46

48 56 Record Count Total count of detail records onthis file (excluding header andtrailer).

Num. 9


Char. 204


17

description: tags: 2006-2007nsldsupdateoffat001extract-recordlayouts

Documents