FSA Canonical Model 2024_1016.pdf

Customer Forms

Financial Partner

Award Origination

Award Repayment

Customers

Financial Partners:

* Federal Loan Servicers

* Asset Recovery Agencies

* Guaranty Agencies

* Bank/Credit Bureaus

* Employers

Education Partners

Loan Repayment Events:

Scheduled Payment Bankruptcy Death Default Disability Deferment Forbearance Approved Forgiveness Approved Grace Period Ends In-School Paid-In Full Other

Security Events:

Authentication

Aid Award Types:

Loan Grant Federal Work Study

Master Data

Data Lake Lakehouse Zones:

* Raw

* Transient

* Curated

* Consumer(s)

Master Data Guiding Principles

* All Master element names end with "Control Number"

* Master elements cannot be used as a Primary Key

Award Disbursement

Application Submittal Customer Account ID (FK) Application Submittal ID

Form Type Code Form Application Name Form Application Number Form Organization Name Form Begin Date Form End Date Application Source Code Application Type Code Application Submittal Date Application Receipt Date Application Signature Date Application Status Code Application End Date Application Decision Code Original Application Receipt Indicator Application Verification Indicator Application Verification Sequence Number Endorser Addendum Number

Award Counseling Award Origination ID (FK) Award Type Code (FK) Award Counseling ID

Direct Loan Counseling Required Indicator TEACH Counseling Required Indicator Counseling Type Code Counseling Acknowledgement Code Counseling Acknowledgement Date

Servicer Financial Servicer Account ID (FK) Servicer Financial ID

Bank Routing Number Bank Account Number Account Type Code Employer Identification Number Tax Exempt Eligibility Indicator

Servicer Account Servicer Account ID

Servicer DUNS Number Servicer Full Name Servicer Specialty Text Servicer Status Code Servicer Type Code Not For Profit Servicer Indicator School Authorized Indicator Servicer Reduction Code Responsibility Begin Date Responsibility End Date External Servicer Indicator

Student Academic Profile Customer Account ID (FK) School Account ID (FK) School Program ID (FK) Student Academic Profile ID

High School Graduation Status Code Student Grade Level Code School Verification Code Enrollment Begin Date Enrollment Status Code Enrollment Status Date Student Participation Reason Code Student Progress Code Student Withdrawal Date Enrollment End Date Term Begin Date Coursework Study Code Non Academic Experience Indicator Term End Date Anticipated Graduation Date Bachelor Degree Indicator Credential Level Code SSCR Schedule Date SSCR Return Date SSCR Waiver Approval Date SSCR Waiver Begin Date SSCR Waiver Reason Text SSCR Waiver End Date Student Aid Report Identification Number Student Aid Report Verification Code Student Separation Date

School Accreditation School Account ID (FK) School Accreditation ID

Accreditation Agency Name Accreditation Designation Code Accreditation Type Code Accreditation Status Code Accreditation Begin Date Accreditation End Date

Cohort Default School Account ID (FK) Cohort Default ID

Cohort Default Year Cohort Default Code Cohort Default Rate Cohort Rate Appeal Indicator Program Type Code Debt Management Indicator Loan Servicing Appeal Indicator

Cohort Default History School Account ID (FK) Cohort Default ID (FK)

Cohort Year Average Default Rate

School Eligibility School Account ID (FK) School Eligibility ID

Enrollment Certification Date Eligibility Action Code Eligibility Action Date Eligibility Override Status Code Eligibility Reason Code ATS Disbursement Indicator Direct Loan Approval End Date Disbursement Without MPN Indicator Experimental Site Indicator School Certification Status Code TitleIV Approval Date TitleIV Eligibility Status Code TitleIV Certification Type Code TitleIV Participation End Date TitleIV Disapproval Date TitleIV Disapproval Reason Code

School Event School Account ID (FK) School Event ID

Closure Evaluation Date Event Type Begin Date Event Type End Date Experiment Type Indicator School Event Type Code

School Financial School Account ID (FK) School Financial ID

Reported Allowance Amount Estimated Cost Of Attendance Amount Attendance Debt Amount Credit Funding Limit Amount Funding Account Number Funding Unsubstantiated Amount Funding Known Recovered Amount Funding Year Maximum Amount Portfolio Closed Indicator Group Identification Routing Number School Bond Value Amount School Tax Identification Number Tuition Enrollment Fee Amount Tuition Recovery Amount School Previous Tax Identification Number

School Account School Account ID

Administrative Cost Allowance Indicator Affiliation Change Code Case Team Code Affiliation Change Begin Date Ethnicity Affiliation Code FFEL Identification Number FFEL Previous Identification Number FDLP Approval Indicator FDLP Identification Number FDLP Previous Identification Number Grantee DUNS Number Grantee Previous DUNS Number Pell Identification Number Pell Previous Identification Number Perkins Portfolio Indicator School Begin Date School End Date School Reinstate Date School Status Code School Latest Closure Date School Group Name School Housing Code School Full Name School Owner Name School Preference Number School Short Name School Type Code School Reduction Code School System Funded Office Indicator State Bond Indicator

School Program School Account ID (FK) School Program ID

Program Type Code Program Award Year Determination Letter Date Determination Expedited Letter Date Full Participation Indicator Program Participation Agreement Send Date Program Participation Agreement Begin Date Program Certification Begin Date Program Certification End Date Classification Instructional Program Code Program Funding Code Special Program Indicator Program Duration Quantity Program Duration Code School Term Code Term Begin Date Term End Date Program Participation Agreement End Date Program End Reason Text

Servicer Address Servicer Account ID (FK) Servicer Address ID

Address City Name Address Country Code Address County Name Address Line1 Text Address Line2 Text Address Line3 Text Address Postal Code Address State Code Geographic Area Code

Servicer Contact Servicer Account ID (FK) Servicer Contact ID (FK)

Contact First Name Contact Middle Name Contact Last Name Contact Suffix Name Contact Designation Text Contact Department Name Website URL Text Contact Primary Indicator

Servicer Email Servicer Account ID (FK) Servicer Email ID

Email Address Name Email Effective Date Email Verification Date Email Verification Indicator Email Verification Status Code Email Type Code

Servicer Phone Servicer Account ID (FK) Servicer Phone ID

Country Calling Code Servicer Phone Number Phone Extension Number Phone Default Indicator Phone Type Code Phone Verification Date

Customer Address Customer Account ID (FK) Customer Address ID

Address Begin Date Address Change Indicator Address City Name Address Condition Code Address Country Code Address County Name Address Line1 Text Address Line2 Text Address Line3 Text Address Mail Return Code Address Mail Return Date Address Postal Code Address State Code Address Status Code Address Type Code Address Verification Indicator Legal Address Indicator Mail Delivery Indicator Geographic Area Code Housing Type Code Address End Date Address End Reason Code

Customer Email Customer Account ID (FK) Customer Email ID

Email Address Name Email Begin Date Email Type Code Email Status Date Email Status Code Email End Date

Customer Phone Customer Account ID (FK) Customer Phone ID

Customer Phone Number Phone Extension Number Foreign Phone Indicator Country Calling Code Phone Default Indicator Phone Type Code Phone Verification Code Phone Verification Date

Customer Preference Customer Account ID (FK) Customer Preference ID

Customer Type Code Customer Signature Indicator Contact Preferred End Time Contact Preferred Begin Time Contact Preferred Method Code Contact Preferred Language Code Contact Preferred Correspondence Code Opt In No Contact Indicator Opt In Email Indicator Opt In SMS Account Recovery Indicator Opt In Notification Push Indicator Opt In SMS Indicator Opt Out SMS Date Opt Out Email Date Opt Out No Contact Date Opt Out Notification Push Date Preference Review Date

School Address School Account ID (FK) School Address ID

Address Change Indicator Address City Name Address Country Code Address County Name Address Line1 Text Address Line2 Text Address Line3 Text Address Postal Code Address Province Name Salutation Address Text Address State Code Address Verification Indicator School Campus Name Campus Identification Number Campus Previous Identification Number Campus Region Code Campus Type Code Congressional District Code Geographic Area Code Mailbox Identification Number

School Contact School Account ID (FK) School Address ID (FK) School Contact ID

Contact Type Code Contact Designation Text Contact Effective Date Contact End Date Contact First Name Contact Middle Name Contact Last Name Contact Suffix Name Contact Primary Indicator Website URL Text

School Email School Account ID (FK) School Email ID

Email Address Name Email Effective Date Email Type Code Email Verification Date Email Verification Status Code Email Verification Indicator

School Phone School Account ID (FK) School Phone ID

Country Calling Code School Phone Number Phone Extension Number Phone Default Indicator Phone Type Code Phone Verification Date

School Preference School Account ID (FK) School Preference ID

Contact Preferred Hour End Time Contact Preferred Hour Begin Time Contact Preferred Method Code Contact Preferred Correspondence Code Contact Preferred Language Code Opt In No Contact Indicator Opt In Email Indicator Opt In Notification Indicator Opt In SMS Indicator Opt Out SMS Date Preference Review Date

Award Origination Award Origination ID Award Type Code

Award Academic Year Award Verification Status Code Ability to Benefit State Code Ability to Benefit Achieve Code Ability to Benefit Test Administrator Code Ability to Benefit Test Code Ability to Benefit Test Date Professional Judgment Indicator IRS Verification Indicator Student Eligibility Code Multiple Eligibility Indicator Disbursement Maximum Quantity

Award Disbursement Award Origination ID (FK) Award Type Code (FK) Award Disbursement ID

Award Balance Amount Anticipated Disbursement Date Award Disbursement Date Disbursement Sequence Number Disbursement Transaction Amount Disbursement Transaction Code Disbursement Transaction Date Disbursement Fee Amount Disbursement Net Amount Disbursement Status Code Disbursement Posted Date Disbursement Posted Amount Disbursement Void Date

Grant Origination Award Origination ID (FK) Award Type Code (FK) Grant Origination ID

Grant Type Code Grant Award Amount Enrollment Accept Date Grant Accept Amount Grant Accept Date Grant Status Code Grant Status Date Grant Modify Date Children of Fallen Heroes Scholarship Indicator Lifetime Eligibility Used Overage Begin Date Lifetime Eligibility Used Overage End Date Student Grade Level Code

Federal Work Study Origination Award Origination ID (FK) Award Type Code (FK) Federal Work Study ID

Award Available Amount Earned Academic Credit Quantity Hourly Wage Amount Work Hour Month Quantity School Contribution Percentage Rate FWS Requested Indicator FWS Award Name FWS Award Amount FWS Begin Date FWS End Date

Loan Master Promissory Note Award Origination ID (FK) Award Type Code (FK) Loan Origination ID (FK) Loan MPN ID

MPN Authentication Date MPN Begin Date MPN Change Date MPN Close Date MPN First Name MPN Middle Name MPN Last Name MPN Suffix Name MPN Collection Cap Fee Amount MPN Interest Rate MPN Discharge Date MPN Electronic Indicator MPN Electronic Date MPN Expiration Date MPN Expiration Reason Code MPN Link Code MPN Link Date MPN Receipt Date MPN SDLC Indicator MPN Signature Date MPN Signature Indicator MPN Source Code MPN Status Code MPN Term Review Date MPN Type Code

Academic Competitiveness Grant Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

ACG Eligibility Maximum Amount ACG Eligibility Used Amount

FSEOG Grant Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

FSEOG Disbursement Amount FSEOG Overpayment Contact Code FSEOG Overpayment Indicator

IASG Grant Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

IASG Eligibility Maximum Amount IASG Eligibility Sequester Amount IASG Eligibility Used Amount

Pell Grant Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

Pell Eligibility Used Amount Pell Eligibility Used Rate Pell Ineligible Indicator Applicant Verification Code Multiple Pell Indicator Pell Additional Eligibility Indicator Pell Initial Disbursement Indicator Pell Reason Code Pell Change Indicator Pell Computed Code Pell Effective Date Pell Overpayment Indicator Pell Overpayment Contact Code Pell Expiration Date Pell School Code Expected Family Contribution Adjustment Reason Code School Award Receipt Date Schedule Pell Award Amount Student Incarcerated Indicator Student Incarcerated Status Code

SMART Grant Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

SMART Eligibility Maximum Amount SMART Eligibility Used Amount

TEACH Grant Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

Certification Due Date Certification Notice Date Certification Notice Code TEACH Change Indicator TEACH Academic Credit Year TEACH Eligibility Maximum Amount TEACH Eligibility Used Amount TEACH Obligation Begin Date TEACH Obligation End Date TEACH Obligation Year TEACH Eligibility Used Rate TEACH Expert Indicator Teacher Satisfaction Requirement Date Teacher Years Completed Quantity Teacher Subject Taught Code

TEACH Agreement To Serve Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

TEACH ATS ID

ATS Authentication Date ATS Begin Date ATS Close Date ATS Close Reason Code ATS End Date ATS Linked Award Indicator ATS Receipt Date ATS Note Origination Code ATS Note Status Code ATS Signature Date ATS Signature Indicator ATS Term Review Date ATS Type Code FAFSA SSN Number FAFSA Student Code Name School Control Number

Award Overpayment Award Origination ID (FK) Award Type Code (FK) Award Overpayment ID

Overpayment Begin Date Overpayment Disbursement Date Overpayment Balance Date Overpayment Balance Amount Overpayment Principal Amount Overpayment Interest Amount Overpayment Owner Code Overpayment Status Code Overpayment Status Date Overpayment Review Indicator Overpayment Response Code Overpayment Response Date Overpayment End Date Overpayment Repayment Date Overpayment Exclusion Code Overpayment Exclusion Indicator

Loan Account Loan Account ID

Loan Program Code Loan Type Code Loan Award Amount First Disbursement Date Credit Reform Code Algorithm Number Interest Type Code Actual Interest Rate Statutory Interest Rate Interest Accrual Type Code Interest Accrual Amount Interest Rate Benefit Indicator Bill Type Code Bill Payment Cycle Loan Begin Date Loan Maturity Date Loan Status Code Loan Status Date Loan Acceleration Indicator Loan Close Date Loan Close Code Federally Insured Indicator ED Administered Indicator Direct Loan Program Indicator Direct Loan Subsidy Indicator Direct Loan Unsubsidized Indicator PLUS Loan Indicator FFEL Program Indicator HEAL Program Indicator Perkins Program Indicator Perkins Assignment Date Perkins Certification Date Private Loan Indicator Loan Consolidation Indicator Consolidation Eligible Indicator Grant Convert Status Code Grant Convert Date Grant Convert Reason Code Reaffirmation Agreement Date Variable Interest Rate Maximum Variable Interest Rate Loan Certification Indicator Origination Payer Fee Indicator

Loan Summary Loan Account ID (FK)

Outstanding Balance Amount Outstanding Balance Date Outstanding Principal Amount Outstanding Principal Date Outstanding Fee Amount Outstanding Guaranty Fee Amount Outstanding Interest Amount Outstanding Interest Date Outstanding Catch Up Amount Latest Payment Date Next Payment Due Date Loan Payoff Date Grant Paid on Transaction Number Maturity Balance Amount Maturity Balance Date Cumulative Disbursement Amount Cumulative Capitalized Interest Amount Cumulative Capitalized Interest Date Cumulative Cancellation Amount Cumulative Principal Paid Amount Cumulative Paid Fee Amount Cumulative Interest Paid Amount Cumulative School Refund Amount IDR Plan Code Cumulative Deferment Quantity Cumulative Forbearance Quantity

Asset Recovery Case Loan Account ID (FK) Loan Acceleration ID (FK) Delinquency Case ID (FK) Recovery Asset Case ID

Asset Recovery Indicator Collection Fee Amount Collection Begin Date Collection Exclusion Text Collection Exclusion Date Collection End Date Collection Recall Reason Code Collection Recall Reason Date Collection Reacceleration Indicator

Loan Acceleration Loan Account ID (FK) Loan Acceleration ID

Delinquency Begin Date Loan Acceleration Date Loan Acceleration Amount Acceleration Principal Amount Acceleration Insurance Premium Amount Acceleration Interest Amount Acceleration Interest Charged Rate Acceleration Fee Rate Loan Recall Indicator Acceleration Borrower Fee Amount Acceleration Guaranty Fee Amount Acceleration Total Fee Amount Lender Fee Amount Loan Rehabilitation Indicator Loan Rehabilitation Date Loan Rehabilitation Amount Loan Rehabilitation Posted Date Rehabilitation Transfer Indicator Loan Repurchase Date Loan Repurchase Amount Insurance Claim Indicator

Loan Suspension Loan Account ID (FK) Loan Suspension ID

Suspension Type Code Suspension Begin Date Capitalized Interest Accrual Indicator Suspension Reason Code Loan Deferment Quantity Suspension End Date

Loan Cancellation Loan Account ID (FK) Loan Cancellation ID

Loan Forgiveness Indicator Loan Discharge Indicator Direct Loan Eligible Indicator FFEL Loan Eligible Indicator Perkins Loan Eligible Indicator Parent Borrower Eligible Indicator Cancellation Request Begin Date Cancellation Request Status Code Cancellation Decision Reason Code Cancellation Request End Date Cancellation Apply Amount Cancellation Interest Apply Amount Cancellation Principal Apply Amount Cancellation Apply Date Cancellation Percent Rate Cancellation Reversal Indicator Loan Cancellation Date Paid In Full Indicator

Administrative Wage Garnishment Case Loan Account ID (FK) Loan Acceleration ID (FK) Delinquency Case ID (FK) AWG Case ID

AWG Withhold Rate AWG Begin Date AWG Status Code AWG Status Date AWG Suspension Indicator AWG Suspension Date AWG End Date Employer Control Number Employer Noncompliance Indicator Employer Noncompliance Fee Amount Protected Wage Amount

Treasury Offset Program Case Loan Account ID (FK) Loan Acceleration ID (FK) Delinquency Case ID (FK) TOP Case ID

Treasury Claim Type Code Obligor Control Number Obligor Control Name Obligor Debt Owed Amount Delinquency Begin Date Creditor Control Number Creditor Contact Control Number Creditor Case Number Creditor Type Code Creditor Priority Code Offset Notice Date Offset Certification Date Offset Original Amount Offset Original Date Offset Fee Amount Offset Begin Date Offset Status Code Offset Pending Indicator Offset Balance Amount Offset Balance Date Offset End Date Offset End Reason Code

Collection Transaction Loan Account ID (FK) Repayment Transaction ID (FK)

Collection Installment Amount Collection Installment Code Collection Receipt Date Collection Receipt Amount Collection Apply Date Collection Principal Apply Amount Collection Interest Apply Amount Collection Fee Apply Amount Collection Trend Code AWG Payment Indicator SPA Payment Indicator SPA Payment Date TOP Payment Indicator

Refund Transaction Loan Account ID (FK) Repayment Transaction ID (FK)

Refund Verification Begin Date Refund Type Code Refund Status Code Refund Submittal Date Refund Approve Date Refund Deposit Date Refund Post Date Refund Cancel Date Refund Verification End Date Loan Reduction Amount Loan Reduction Date Overpayment Method Code Overpayment Transaction Control Number TOP Transaction Number ACH Refund Indicator

Rebate Transaction Loan Account ID (FK) Repayment Transaction ID (FK)

Consolidation Incentive Indicator Rebate Incentive Status Code Rebate Adjustment Amount Rebate Apply Amount Rebate Apply Rate Rebate Revoke Date Rebate Status Code Rebate Status Date Rebate Type Code Rebate Unearned Amount Rebate Upfront Benefit Rate

Loan Consolidation Loan Account ID (FK) Loan Consolidation ID

Consolidation Application ID MPN Master Id Consolidation Application Date Underlying Servicer Control Number Underlying Loan Control Number Underlying Loan Payoff Date Underlying Loan Payoff Amount Underlying Loan Principal Amount Underlying Loan Fee Amount Underlying Loan Daily Interest Amount Underlying Loan Consolidation Status Code Underlying Loan Group Type Code Underlying Loan Term Remaining Quantity Underlying PLUS Loan Type Indicator Consolidation Servicer Control Number Consolidation Loan Control Number Consolidation Debt Amount Consolidation Rebate Fee Amount Consolidation Book Date Consolidation Value Date LVC Pass Indicator LVC Exception Text ICR Eligible Indicator IDR Eligible Indicator Joint Consolidation Indicator

Lien Holder Loan Account ID (FK) Lien Holder ID

Transfer To ED Indicator Transfer Responsibility From Code Transfer Responsibility From Date Transfer Responsibility To Code Transfer Responsibility To Date Transfer Pending Code Transfer Abandon Indicator Lender Last Resort Indicator Loan Sold Indicator Participation Certificate Sold Date Guaranty Transfer Date

Lockbox Transaction Loan Account ID (FK) Repayment Transaction ID (FK)

Lockbox Account Number Lockbox Owner Number Lockbox Transaction Fee Amount Lockbox Recurring Fee Amount Lockbox Setup Fee Amount Lockbox Fraud Indicator Lockbox First Name Lockbox Middle Name Lockbox Last Name Lockbox Suffix Name Instrument Payment Amount Instrument Routing Number Instrument Account Number Instrument Trace Number

Customer Account Customer Account ID

Citizenship Status Code Customer BirthISO Date Customer First Name Customer Middle Name Customer Last Name Customer Alias Name Customer Age In Years Quantity Customer Death Date Customer Deceased Indicator Customer Suffix Name Customer Title Code Customer Education Level Code Customer Ethnicity Code Customer Gender Code Customer Race Code Customer Religion Text Drivers License Number Drivers State Code Legal Residence State Code Marital Status Date Marital Status Code Military Status Code Military Status Begin Date Military Status End Date Military Branch Code Military Unknown Active Duty Indicator Active Account Indicator Fraud Account Indicator

Customer Federal Tax Information Customer Account ID (FK) FTI Customer ID

FTI SSN Number FTI Individual Tax Identification Number FTI Birth Date FTI Filing Year FTI Filing Type Code FTI Filing Status Code FTI Amend Filing Indicator FTI AGI Amount FTI Total Income Tax Amount FTI Wage Amount FTI Exempt Interest Amount FTI Untaxed Pension and Annuity Amount FTI Taxed Earned Income Amount FTI Untaxed Income Amount FTI Untaxed IRA Pension Amount FTI Schedule_1 Indicator FTI Schedule_A Indicator FTI Schedule_B Indicator FTI Schedule_C Amount FTI Schedule_D Indicator FTI Schedule_G Indicator FTI Schedule_F Indicator FTI Schedule_H Indicator FTI Exempt Dependent Quantity FTI Verification NonFiling Indicator FTI Education Credit Quantity FTI IRA Deduction Amount FTI Paid Tax Amount FTI Exempt Number FTI Exempt Claim Quantity FTI Eligibility Indicator FTI Tax Exempt Number

Customer Consent Customer Account ID (FK) Customer Consent ID

Consent Source Code Consent Status Code Consent Status Date

Customer Financial Customer Account ID (FK) Customer Financial ID

Bank Account Number Bank Routing Number Bank Account Amount Account Type Code Bankruptcy Status Code Credit Score Number Child Support Expense Amount Child Support Income Amount Customer Taxable Income Indicator Customer Income Amount Customer Combat Income Amount Customer Offspring Quantity Customer Tax Dependent Quantity Tax Return Type Code Tax Return Status Code Tax Return Filing Status Code Spouse Income Access Indicator

Customer Employment Customer Account ID (FK) Customer Employer ID

Address City Name Address Country Code Address County Name Address Line1 Text Address Line2 Text Address Line3 Text Address Postal Code Address State Code Federal Employer Identification Number Employer Certification Indicator Employer Legal Name Employer Phone Number Employment Begin Date Employment Certification Form Date Employment Certification Form Number Employment Designation Text Employment End Date Employment Status Code Employment PSLF Indicator

Customer Case Customer Account ID (FK) Customer Case ID

Case Begin Date Case Type Code Case Submittal Code Case Status Code Case Certification Date Case End Date Assigned Division Code Assigned Team Code Assigned Owner Name Allegation Decision Text Allegation Program Text Allegation Type Text Alleged Violator Name

Student Aid Index Customer Account ID (FK) SAI Detail ID

SAI Formula Type Code Student Dependency Code Simplified Formula Indicator SAI Zero Eligible Code

Servicer Submittal Servicer Account ID (FK) Servicer Submittal ID

Submittal Effective Date Submittal Receipt Date Submittal Bundle Name Bundle Reject Indicator Submittal Interval Code Initial Submittal Indicator Submittal Schedule Date Submittal Action Code Submittal Reject Indicator Submittal Status Code Submittal Record Quantity Servicer Control Number

Request FAFSA Customer Account ID (FK) Application Submittal ID (FK)

Applicant Education Level Code Applicant Dislocated Worker Indicator SAI Contribution Number Applicant Emancipated Minor Indicator Applicant Tax Estimated Amount Applicant Tax Exempt Quantity FAFSA Process Date Applicant Food Stamp Indicator Applicant Foster Care Code Applicant Graduation Indicator Applicant Graduation Status Answered Indicator Applicant In Legal Guardianship Indicator Application Preparer EIN Dependency Override Indicator GED Earned Year Loan Satisfactory Arrangement Change Indicator Lunch Benefit Indicator Money Receipt Indicator Pin Issue Indicator School Change Indicator Loan Satisfactory Arrangement Indicator Supplemental Security Income Benefit Indicator Temporary Assistance for Needy Family Benefit Indicator Veterans Affairs Match Indicator Veterans Affairs Benefit Indicator Veterans Affairs Education Benefit Amount Women Infants Children Benefit Indicator

Delinquency Case Loan Account ID (FK) Loan Acceleration ID (FK) Delinquency Case ID

Delinquency Begin Date Delinquency Letter Code Delinquency Aging Code Delinquency End Date Hearing Request Type Code Hearing Receipt Date Hearing Objection Code Hearing Decision Code Hearing Decision Date Summons Service Date Attorney Retainer Date Litigation Debt Amount DOJ Fee Amount Litigation Begin Date Litigation Status Code Litigation Cancellation Date Litigation Cancellation Reason Text Litigation Closure Date Litigation Close Reason Text Litigation Judgment Date Judgment Expiration Date Notice of Intent Type Code Notice Of Intent Sent Date Loan Judgment Indicator

Loan Program School Account ID (FK) School Program ID (FK)

FFEL Loan Indicator PLUS Loan Indicator Serial Loan Indicator Origination Level Code Level Begin Date Level End Date Level End Reason Text

Servicer Preference Servicer Account ID (FK) Servicer Preference ID

Contact Preferred Hour End Time Contact Preferred Hour Begin Time Contact Preferred Method Code Contact Preferred Correspondence Code Contact Preferred Language Code Opt In No Contact Indicator Opt In Email Indicator Opt In Notification Indicator Opt In SMS Indicator Opt Out SMS Date Preference Review Date

Request Income Driven Repayment Customer Account ID (FK) Application Submittal ID (FK)

Applicant AGI Amount Applicant Inclusive AGI Indicator Applicant Taxable Income Amount Applicant Children Quantity Applicant Dependent Quantity Applicant Documentation Required Indicator Applicant Documentation Receipt Date Applicant Filing Indicator Applicant Filing Year Applicant Filing Status Code Applicant Taxable Income Indicator PSLF Employment Indicator Marital Status Code Spouse Separated Indicator Spouse Information Access Indicator Spouse AGI Amount Spouse Inclusive AGI Indicator Spouse Taxable Income Amount Spouse Filing Indicator Spouse Filing Year Spouse Filing Status Code Spouse Documentation Required Indicator Spouse Documentation Receipt Indicator Spouse Documentation Receipt Date Suspension Application Control Number Suspension Payment Amount Suspension Option Code Requested Plan Code Requested Plan Reason Code Requested Plan Status Code Requested Plan Status Date Requested By Borrower Indicator Lowest Payment Plan Indicator Joint Plan Indicator Multiple Servicer Indicator Income Documentation Required Indicator Total Income Amount Family Size Quantity

Repayment Plan Loan Account ID (FK) Repayment Plan ID

Borrower Type Code Repayment Plan Code Repayment Maximum Term Quantity Repayment Status Code Repayment Status Date Repayment Disclosure Date Repayment Grace Period Quantity Direct Loan Subsidy Eligible Indicator Direct Loan Unsubsidized Eligible Indicator Grad PLUS Eligible Indicator Parent PLUS Eligible Indicator PSLF Eligible Indicator Consolidation Direct Eligible Indicator Consolidation FFEL Eligible Indicator Graduated Repayment Indicator Negative Amortization Indicator Partial Financial Hardship Eligibility Indicator Partial Financial Hardship Reason Change Code Voluntary Agreement Indicator

Loan Origination Award Origination ID (FK) Award Type Code (FK) Loan Origination ID

Loan Type Code Loan Type Begin Date Loan Request Amount Loan Endorsed Amount Loan Award Amount Loan Guaranty Amount Loan Guaranty Code Loan Guaranty Date Loan Book Date Loan Interest Rate Miscellaneous Fee Amount Origination Fee Amount Credit Reform Code Credit Check Date Credit Check Met Indicator HEAL Override Indicator PLUS Override Denial Indicator Loan Counseling Required Indicator

Federal Work Study Disbursement Award Origination ID (FK) Award Type Code (FK) Award Disbursement ID (FK)

School Contribution Date School Contribution Amount

Loan Disbursement Award Origination ID (FK) Award Type Code (FK) Award Disbursement ID (FK)

Loan Account Number Late Disbursement Indicator Full Disbursement Indicator Subsidy Non Credential Disbursement Period Subsidy Disbursement Period Subsidy Anticipated Period

Scholarship Origination Award Origination ID (FK) Award Type Code (FK) Scholarship Origination ID

Scholarship Award Name Scholarship Award Amount

Estimated Cost of Attendance Award Origination ID (FK) Award Type Code (FK) Estimated Cost of Attendance ID

Cost Type Code Cost Estimate Name Cost Estimate Amount

Grant Conversion Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK) Grant Repayment Id

Grant Repayment Amount Converted To Loan Indicator Converted To Loan Date Loan Assignment Code Life Circumstance Reason Code Life Circumstance Notification Date Life Circumstance Begin Date Life Circumstance End Date

Loan Forgiveness Loan Account ID (FK) Loan Cancellation ID (FK)

Forgiveness Type Code Previous Forgiveness Indicator Qualifying Employer Indicator Qualifying Employment Indicator Qualifying Eligible Loan Indicator Qualifying Payment Indicator

Income Driven Agreement Loan Account ID (FK) Repayment Plan ID (FK)

IDR Plan Indicator Anniversary Certification End Date IDR Forgiveness Tax Indicator REPAYE Plan Indicator REPAYE Schedule Catch Up Amount REPAYE Total Catch Up Amount ICR Plan Indicator PAYE Plan Indicator IBR Plan Indicator New Borrower Indicator Annual Income Amount Spouse Income Required Indicator Discretionary Income Amount Discretionary Payment Rate

Standard Agreement Loan Account ID (FK) Repayment Plan ID (FK)

Standard Plan Indicator Graduated Plan Indicator Extended Plan Indicator Extended Threshold Amount

Loan Discharge Loan Account ID (FK) Loan Cancellation ID (FK)

Discharge Type Code Discharge Special Handling Text Bankruptcy Eligible Indicator Bankruptcy Determination Date Bankruptcy Determination Code Borrower Defense Eligible Indicator False Certification Eligible Indicator Ability To Benefit Certification Indicator Disqualifying Status Indicator Unauthorized Signature Indicator School Closure Eligible Indicator School Closure Date School Closure Reason Code Student Enrolled Indicator Student Leave of Absence Indicator Student Withdrawal Indicator Student Withdrawal Date Disability Eligible Indicator Disability Physician Certification Date Veterans Affairs Disability Determination Indicator SSA Disability Determination Indicator Refund Unpaid Discharge Indicator

TEACH Forgiveness Loan Account ID (FK) Loan Cancellation ID (FK) TEACH Forgiveness ID

Employer Type Code Employer Service Type Code Employer Weekly Hours Quantity Perkins Eligible Indicator TEACH Institution Type Code TEACH State Code

Grant Program School Account ID (FK) School Program ID (FK)

Grant Program Indicator

Federal Work Study Program School Account ID (FK) School Program ID (FK)

Work Study Program Indicator

Voluntary Agreement Loan Account ID (FK) Repayment Plan ID (FK)

Collection Fee Rate Collection Fee Amount Compromise Fee Amount Compromise Interest Amount Compromise Principal Amount Compromise Due Date Compromise Type Code Compromise Debt Indicator

Request Repayment Customer Account ID (FK) Application Submittal ID (FK)

Request Consolidation Indicator Request IDR Indicator Request Reaffirmation Indicator Request Direct Repayment Plan Indicator Request Reason Code Expected Grace Period Quantity

Request Deferment Customer Account ID (FK) Application Submittal ID (FK)

Request Cancer Treatment Deferment Indicator Request Economic Hardship Deferment Indicator Request Graduate Fellowship Deferment Indicator Request In School Deferment Indicator Request Military Service Deferment Indicator Request Parent Plus Deferment Indicator Request Rehabilitation Training Deferment Indicator Request Temporary Total Disability Deferment Indicator Request Unemployment Deferment Indicator

Request Forbearance Customer Account ID (FK) Application Submittal ID (FK)

Request General Forbearance Indicator Request Mandatory Forbearance Indicator Request Student Loan Debt Burden Forbearance Indicator Teacher Forbearance Request Indicator

Request Discharge Customer Account ID (FK) Application Submittal ID (FK)

Request Borrower Defense Discharge Indicator Request Disqualifying Status Discharge Indicator Request Unauthorized Signature Discharge Indicator Request Ability To Benefit Discharge Indicator Request Forgery Discharge Indicator Request Forgiveness Indicator Request School Closure Discharge Indicator Request Teacher Forgiveness Indicator Request Applicant Representative Disability Discharge Indicator Request Discharge Application Indicator Request Post Discharge Monitoring Indicator Refund Unpaid Discharge Indicator

Request Rehabilitation Customer Account ID (FK) Application Submittal ID (FK)

Loan Rehabilitation Indicator

Request Servicemember Relief Customer Account ID (FK) Application Submittal ID (FK)

Request SCRA Indicator

Request TEACH Grant Customer Account ID (FK) Application Submittal ID (FK)

Request ATS Indicator Request Qualifying Teaching Certification Indicator Request Qualifying Program Suspension Indicator Request FMLA Suspension Indicator Request Military Spouse Suspension Indicator Request Major Disaster Indicator Request Military Service Indicator

Payment Transaction Loan Account ID (FK) Repayment Transaction ID

Transaction Type Code Transaction Subtype Code Collection Type Code ACH Transaction Code ACH Trace Number Electronic Payment Indicator Lockbox Payment Indicator Recurring Payment Indicator Payment Confirmation Number Payment Instrument Type Code Payment Instrument Number Payment Receipt Date Payment Receipt Amount Payment Apply Date Payment Principal Apply Amount Catch Up Apply Amount Interest Benefit Apply Date Payment Interest Apply Amount Interest Negative Amortization Apply Amount Capitalized Interest Apply Amount Interest Non Capitalized Apply Amount Payment Fee Apply Amount Qualifying Forgiveness Year Payment Zero Dollar Indicator Special Allowance Indicator Special Allowance Code Special Allowance Rate

Treasury Offset Program Transaction Loan Account ID (FK) Repayment Transaction ID (FK)

Offset Payor Code Offset Type Code Offset Debt Amount Offset Debt Date Offset Apply Date Debt Principal Apply Amount Debt Interest Apply Amount Debt Fee Apply Amount Offset Reversal Amount Offset Reversal Code Offset Refund Amount TOP Cycle Year TOP Trace Number Cumulative TOP Principal Amount Cumulative TOP Interest Amount Cumulative TOP Debt Amount

Customer Eligibility Customer Account ID (FK)

Assets Reported Indicator Federal Employee Indicator Foreign National Indicator HEAL Eligibility Indicator Homeless Determination Indicator Subsidy Loan Limit Code Loan Unsubsidized Indicator Multiple Loan Indicator Multiple School Indicator Multiple Servicer Indicator Veteran Status Indicator Ward Orphan Indicator Ineligible Borrower Code Drug Abuse Indicator Fraud Alert Indicator Loan Collection Indicator PLUS Denial Code PLUS Override Denial Code SULA Status Code SULA Status Date SULA Override Code

Loan Certification Loan Account ID (FK)

Certification Frequency Code Direct Loan Certification Amount School Certified Indicator School Certification Amount School Certification Date School Certification Status Code Self Certified Indicator

Interest Benefit Loan Account ID (FK)

Interest Benefit Begin Date Interest Benefit Type Code Interest Benefit Status Code Interest Benefit Status Date Interest Benefit Apply Rate Interest Benefit Accrual Amount Interest Benefit End Date

Interest Capitalization Loan Account ID (FK) Repayment Transaction ID (FK)

Capitalized Interest Begin Date Capitalized Interest Accrual Amount Capitalized Interest Threshold Rate Capitalized Interest Threshold Indicator Capitalized Interest End Date

Master Association Master Association ID

Customer Control Number (FK) Customer Alias Control Number Customer Source System Number IDR Control Number (FK) IDR Alias Control Number IDR Source System Number Award Control Number (FK) Award Alias Control Number Award Source System Number ATS Control Number (FK) ATS Alias Control Number ATS Source System Number School Control Number (FK) School Alias Control Number School Source System Number Servicer Control Number (FK) Servicer Alias Control Number Servicer Source System Number Loan Control Number (FK) Loan Alias Control Number Loan Source System Number Portfolio Control Number (FK) Portfolio Alias Control Number Portfolio Source System Number User Control Number (FK) User Alias Control Number User Source System Number MPN Control Number (FK) MPN Alias Control Number MPN Source System Number ECF Control Number (FK) ECF Alias Control Number ECF Source System Number Complaint Control Number (FK) Complaint Alias Control Number Complaint Source System Number

Insurance Claim Loan Account ID (FK) Insurance Claim ID

Guarantor Receipt Date Servicer Notification Date Claim Control Number Claim Type Code Claim Reason Code Claim Status Code Claim Gross Amount Claim Paid Date Claim Paid Amount Claim Principal Amount Claim Interest Amount Reinsurance Request Date Reinsurance Reason Code Reinsurance Paid Date Reinsurance Request Amount Reinsurance Reimbursement Rate Code Reinsurance Refund Amount Reinsurance Refund Date Supplemental Reinsurance Request Date Supplemental Reinsurance Fee Amount Supplemental Reinsurance Request Amount

Document Master Document Master ID

Document Upload Date Document Classification Number Document Classification Code Document Submittal Date Document Postmark Date Document Receipt Date Document Review Date Document Approval Date Document Release Date Document Request Date Audit Create Name Audit Create Date Audit Modify Name Audit Modify Date

Document Tag Document Master ID (FK) Document Tag ID

Document File Name Document Zone Name Document Type Code Zone Year Name Zone Month Name Zone Day Name System Source Code Transformation Type Code Transformation File Name

School Submittal School Account ID (FK) School Submittal ID

Submittal Effective Date Submittal Receipt Date Submittal Schedule Date Bundle Reject Indicator Submittal Bundle Name Submittal Interval Code Initial Submittal Indicator Submittal Reject Indicator Submittal Status Code

Loan Deferment Loan Account ID (FK) Loan Suspension ID (FK)

Loan Deferment Indicator PLUS Deferment Indicator Repayment Deferment Code

Loan Forbearance Loan Account ID (FK) Loan Suspension ID (FK)

Loan Forbearance Indicator Mandatory Forbearance Eligible Indicator General Forbearance Eligible Indicator General Forbearance Maximum Limit Indicator

Grant Disbursement Award Origination ID (FK) Award Type Code (FK) Award Disbursement ID (FK)

Grant Disbursement Indicator

Customer Party Customer Account ID (FK) Party Account ID (FK)

Customer Role Code Party Role Code

Customer Master Customer Control Number

Customer Account ID (FK)

School Master School Control Number

School Account ID (FK)

Servicer Master Servicer Control Number

Servicer Account ID (FK)

Income Driven Repayment Master IDR Control Number

Customer Account ID (FK) Application Submittal ID (FK)

Award Master Award Control Number

Award Origination ID (FK) Award Type Code (FK)

Portfolio Master Portfolio Control Number

Customer Account ID (FK)

MPN Master MPN Control Number

Award Origination ID (FK) Award Type Code (FK) Loan Origination ID (FK) Loan MPN ID (FK)

Loan Master Loan Control Number

Loan Account ID (FK)

Agreement To Serve Master ATS Control Number

Award Origination ID (FK) Award Type Code (FK) Grant Origination ID (FK)

TEACH ATS ID (FK)

Employment Certification Form Master ECF Control Number

Customer Employer ID (FK) Customer Account ID (FK)

DOD Interest Benefit Loan Account ID (FK)

DoD Benefit Indicator DoD Match Code DoD Parent Death Date

SCRA Interest Benefit Loan Account ID (FK)

SCRA Benefit Indicator SCRA Notification Date SCRA Transfer In Date

Subsidy Interest Benefit Loan Account ID (FK)

Interest Subsidy Indicator Subsidy MEP Begin Date Subsidy MEP End Date Subsidy Notification Status Code Subsidy Notification Status Date Subsidy Notification Action Code Subsidy Notification Action Date Subsidy Status Effective Date

Imminent Danger Hostile Fire Benefit Loan Account ID (FK)

IDP HFP Eligibility Indicator IDP HFP Apply Date

Repayment Schedule Loan Account ID (FK) Repayment Plan ID (FK) Repayment Schedule ID

Schedule Begin Date Schedule Term Quantity Bill Schedule Cycle Bill Payment Type Code Schedule Permanent Payment Amount Schedule Standard Payment Amount Schedule Amount Effective Date Schedule Interest Rate Schedule End Date Schedule Payment Amount

IDR Forgiveness Loan Account ID (FK)

Qualifying Payment Quantity Qualifying Effective Date Servicer Control Number Prior Servicer Indicator

PSLF Forgiveness Loan Account ID (FK)

Qualifying Payment Year Qualifying Payment Quantity TEPSLF Forgiveness Indicator

Customer Call Customer Account ID (FK) Customer Correspondence ID (FK) Customer Call ID

Call Type Code Customer Phone Number

Customer Correspondence Customer Account ID (FK) Customer Correspondence ID

Correspondence Type Code Correspondence Initiation Code Correspondence Initiation Date Correspondence Result Code Additional Correspondence Text Borrower Contact Indicator Due Diligence Begin Date Due Diligence Sequence Number Due Diligence End Date Skip Trace Request Date

Customer Notification Customer Notification ID Customer Account ID (FK) Customer Correspondence ID (FK)

Notification Type Code Notification Letter Code Notification Mail Text Notification Email Name

Servicing Complaint Customer Account ID (FK) Customer Case ID (FK)

Complaint Type Code Complaint Verification Indicator Complaint Verification Date Borrower Demand Letter Date Endorser Demand Letter Date Timely Response Indicator Complaint Detail Notes

Complaint Master Complaint Control Number

Customer Account ID (FK) Customer Case ID (FK)

Borrower Portfolio Customer Account ID (FK) Loan Account ID (FK) Borrower Portfolio ID

Aid Index Party Customer Account ID (FK) SAI Detail ID (FK) SAI Party ID

SAI Party Code Parent Income Amount Parent Protected Income Amount Parent Asset Amount Parent Protected Asset Amount

Customer Identity Customer Account ID (FK)

Customer SSN Number SSN Verification Code Pseudo SSN Indicator Customer FSAID Number Customer FAN Number Customer PMDMID Number Individual Tax Identification Number Alien Registration Number

Mobile Device Customer Account ID (FK) Customer Phone ID (FK)

Mobile Device Identification Number Mobile Application Version Number Mobile Operating System Version Number Mobile Operating System Type Code

Form Type Code Form Type Code

Form Type Code

Form Type Code

Form Type Code

Form Type Code

Form Type Code

Form Type Code

Form Type Code Program Type Code

Program Type Code

Program Type Code

Award Type Code

Award Type Code

Award Type Code

Award Type Code

Award Type Code

Award Type Code

Award Type Code

Grant Type CodeGrant Type Code

Grant Type Code

Grant Type Code Grant Type CodeGrant Type CodeGrant Type CodeGrant Type Code

Loan Type Code

Loan Consolidation Indicator

Loan Acceleration Indicator Interest Rate Benefit Indicator

Federally Insured Indicator

IDR Plan Code

Loan Recall Indicator

Suspension Type Code Suspension Type Code

Loan Forgiveness Indicator

Loan Discharge Indicator

TOP Payment Indicator

Case Type Code

Hearing Decision CodeHearing Decision Code

Hearing Decision Code

Repayment Plan Code Repayment Plan Code

Voluntary Agreement Indicator

Loan Type Code

Transaction Type Code Transaction Type Code Lockbox Payment IndicatorCollection Type Code

Capitalized Interest Apply Amount

Correspondence Type Code

Correspondence Type Code

Canonical Model view

2:25:28 PM , 10/16/2024