MyStudentData Download File Layout - ed



National Student Loan Data SystemMyStudentData DownloadFile LayoutDecember 23, 2018IntroductionThe National Student Loan Data System (NSLDS) MyStudentData Download allows students to download information about their loans, grants, overpayments, subsidized usage, enrollment, and addresses from the NSLDS Student Access website into a machine-readable, plain text file.The MyStudentData Download is available from the following NSLDS Student Access web pages: Main Menu (Home page)Financial Aid Review (Aid)Loan Detail Grant DetailOverpayment DetailSubsidized UsageStudents who click the MyStudentData Download icon on any of those pages receive, as a download, a machine-readable file in American Standard Code for Information Interchange (ASCII) format. The simple text file includes their loan information (e.g., loan amount, disbursement amount), grant information (e.g., award amount, disbursement amount), as well as enrollment and overpayment information, regardless of the web page the student is on when clicking the MyStudentData Download.To assist software vendors with designing new tools for students to maximize the usefulness of the data, we have developed the NSLDS MyStudentData Download file layout. This document defines the layout of the file that students can download from NSLDS Student Access.NEW! The following update has been made to the previous version of this document dated August 31, 2016:The following field has been added to the Student section of the layout:Student Iraq and Afghanistan Service Lifetime Eligibility Used.Note: The addition of this field shifts the position number of the remaining field in this section.Loan Type valid value name was changed in the Loan Type Total and Loan sections (documentation change only):Current Loan Type valuePreviously documented Loan Type valueFEDERALLY INSURED (FISL)FEDERAL INSURED (FISL)NSLDS MyStudentData Download File LayoutThe MyStudentData Download file is made up of name:value pairs separated by colons. Each name:value pair occupies a new line of the file. Individual pairs do not occur in fixed positions, as they would in a fixed-length flat file or a formatted report, and they are not tagged to identify their nature or cardinality, as they would be in an eXtensible Markup Language (XML) file. This is because there is no way to specify in advance how many loans, grants, aid overpayments, or program enrollment records each student may have, or how many disbursements or statuses each loan may have.However, pairs will always occur in the same order within the various subsections of the file. A student’s first name, if she has one, will always occur before her middle initial and last name. The status for an individual loan will always occur before the status description or status effective date. The combination of position and name should allow users or third-party software vendors to identify the contents of each name:value pair.The relationships between the different parts of the download file can be expressed in tabular form as follows.RootHasHasHasFile1 Student0–24 Loan Type Totals0–50 Loans1–50 Statuses0–25 Disbursements0–3 Contacts0–1 Special Contacts0–40 Grants0–1 Contacts0–10 Aid Overpayments0–1 Contacts0–1 Special Contacts0–300 Programs0–300 Statuses0–50 AwardsAn example created from the MyStudentData Download output using this file layout is provided in Appendix A.The layouts that follow identify position, name, format, and maximum length for each value. The lengths of both name and value fields are variable.Field names vary from nine to 65 characters in length.Field values vary from one to 253 characters in length, although an email address that long is very unlikely.Students who click the MyStudentData Download on the English language site will see only the English name for each pair. Students who click the MyStudentData Download on the Spanish site will see only the Spanish name. Both will see most non-numeric values displayed in English, as that is the language used to store information on the NSLDS database.FileCardinality: 1Pos.English NameSpanish NameFormatMax. Len.1File SourceArchivo de OrigenText712File Request DateArchivo Fecha de Solicitudccyy-mm-dd-hh.mm. ss.SSS23StudentCardinality: 1Pos.English NameSpanish NameFormatMax. Len.1Student First NameEstudiante Primer NombreText122Student Middle InitialEstudiante Inicial del Segundo NombreText13Student Last NameEstudiante ApellidoText354Student Street Address 1Estudiante Domicilio 1Text405Student Street Address 2Estudiante Domicilio 2Text406Student CityEstudiante CiudadText307Student State CodeEstudiante Codigo de EstadoText28Student Country CodeEstudiante Codigo de PaísText29Student Zip CodeEstudiante Código PostalText1710Student Email AddressEstudiante Correo ElectronicoText25311Student Home Phone Country CodeEstudiante Código de País del Teléfono de CasaText312Student Home Phone NumberEstudiante Numero de Teléfono de CasaText1113Student Home Phone PreferredEstudiante Número de Teléfono de Casa PreferidoText314Student Cell Phone Country CodeEstudiante Código de País del CelularText315Student Cell Phone NumberEstudiante Número de CelularText1116Student Cell Phone PreferredEstudiante Número de Celular PreferidoText317Student Work Phone Country CodeEstudiante Código de País del Teléfono del TrabajoText318Student Work Phone NumberEstudiante Número de Teléfono del TrabajoText1119Student Work Phone PreferredEstudiante Número de Teléfono del Trabajo PreferidoText320Student SULA Maximum Eligibility PeriodEstudiante Periodo Máximo de Elegibilidad SULAnn.n421Student SULA Subsidized Usage PeriodEstudiante Periodo de Uso de Subsidio SULAnn.n422Student SULA Remaining Eligibility PeriodEstudiante Periodo de Elegibilidad Restante SULAnn.n423Student Enrollment StatusEstudiante Dedicación de EstudiosText6024Student Enrollment Status Effective DateEstudiante Fecha de Dedicación de Estudiosmm/dd/ccyy1025Student Total All Loans Outstanding PrincipalEstudiante Total de Todos los Prestamos Capital Pendiente$nnn,nnn826Student Total All Loans Outstanding InterestEstudiante Total de Todos los Prestamos Interés Pendiente$nnn,nnn827Student Pell Lifetime Eligibility UsedEstudiante Cantidad del Límite Máximo de Vida del Pell Usadonnnnn.nnn%1028Student Iraq and Afghanistan Service Lifetime Eligibility UsedEstudiante Cantidad del Límite Máximo de Vida del Servicio Iraq and Afganistán Usadonnnnn.nnn%1029Student Total All GrantsEstudiante Total de Todas las Becas$nnn,nnn8Note: SULA stands for Subsidized Usage Limits Apply. (SULA significa Límites de Uso Subvencionados Aplicando.)Loan Type TotalCardinality: 0–24Pos.English NameSpanish NameFormatMax. Len.1Total <Loan Type> Outstanding PrincipalTotal <Loan Type> Capital Pendiente$nnn,nnn82Total <Loan Type> Outstanding InterestTotal <Loan Type> Interés Pendiente$nnn,nnn8Note: Valid Loan Types for loan type totals are:FFEL CONSOLIDATEDNATIONAL DEFENSE LOAN (PERKINS)DIRECT STAFFORD SUBSIDIZED (SULA ELIGIBLE)DIRECT STAFFORD SUBSIDIZEDDIRECT STAFFORD UNSUBSIDIZEDDIRECT PLUS GRADUATEDIRECT PLUS PARENTDIRECT CONSOLIDATED UNSUBSIDIZEDDIRECT CONSOLIDATED SUBSIDIZED (SULA ELIGIBLE)DIRECT CONSOLIDATED SUBSIDIZEDDIRECT PLUS CONSOLIDATEDDIRECT UNSUBSIDIZED (TEACH)PERKINS EXPANDED LENDINGFEDERALLY INSURED (FISL)FFEL PLUS GRADUATEINCOME CONTINGENT (ICL)NATIONAL DIRECT STUDENT LOAN (PERKINS)FFEL PLUS PARENTFEDERAL PERKINSFFEL REFINANCEDFFEL STAFFORD SUBSIDIZEDFFEL SUPPLEMENTAL LOAN (SLS)FFEL STAFFORD NON-SUBSIDIZEDFFEL STAFFORD UNSUBSIDIZEDLoanCardinality: 0–50Pos.English NameSpanish NameFormatMax. Len.1Loan TypePréstamo TipoText602Loan Award IDPréstamo Identificación de la Concesión*****nnnncnnnnnnnnnnn213Loan Attending School NamePréstamo Nombre de la Institución Postsecundaria de AsistenciaText654Loan Attending School OPEIDPréstamo OPEID de la Institución Postsecundaria de Asistenciannnnnnnn85Loan DatePréstamo Fechamm/dd/ccyy106Loan Repayment Begin DatePréstamo Fecha de Comienzo de Pagosmm/dd/ccyy107Loan Period Begin DatePréstamo Fecha de Comienzo del Plazomm/dd/ccyy108Loan Period End DatePréstamo Fecha de Cierre del Plazomm/dd/ccyy109Loan AmountPréstamo Cantidad$nnn,nnn810Loan Disbursed AmountPréstamo Cantidad Desembolsada$nnn,nnn811Loan Canceled AmountPréstamo Cantidad Cancelada$nnn,nnn812Loan Canceled DatePréstamo Fecha de Cancelaciónmm/dd/ccyy813Loan Outstanding Principal BalancePréstamo Saldo del Capital Pendiente$nnn,nnn814Loan Outstanding Principal Balance as of DatePréstamo Fecha del Saldo del Capital Pendientemm/dd/ccyy1015Loan Outstanding Interest BalancePréstamo Saldo del Interés Pendiente$nnn,nnn816Loan Outstanding Interest Balance as of DatePréstamo Fecha del Saldo del Interés Pendientemm/dd/ccyy1017Loan Interest Rate TypePréstamo Tipo de Tasa de InterésText6018Loan Interest RatePréstamo Tasa de Interésnnnnn.nn%919Loan Repayment Plan TypePréstamo Tipo de Plan de PagoText4820Loan Repayment Plan Begin DatePréstamo Fecha de Inicio del Plan de Pagomm/dd/ccyy1021Loan Repayment Plan Scheduled AmountPréstamo Montó Programado del Plan de Pago$nnn,nnn922Loan Repayment Plan IDR Plan Anniversary DatePréstamo IDR Plan Fecha de Aniversario del Plan de Pagomm/dd/ccyy1023Loan Confirmed Subsidy StatusPréstamo Estado Subsidio ConfirmadoText1524Loan Subsidized Usage in YearsPréstamo Periodo de Uso Subsidiado en A?osnn.n425Loan Reaffirmation DatePréstamo Fecha de Reafirmaciónmm/dd/ccyy1026Loan Most Recent Payment Effective DatePréstamo Fecha Efectiva del Pago Mas Recientemm/dd/ccyy1027Loan Next Payment Due DatePréstamo Fecha de Vencimiento del Pago Siguientemm/dd/ccyy1028Loan Cumulative Payment AmountPréstamo Cantidad de Pago Acumulado$nnn,nnn929Loan PSLF Cumulative Matched MonthsPréstamo PSLF Meses Emparejados Acumulativosnnn3Note: MyStudentData Download masks the first five characters of the Award ID, if it exists, with asterisks. The tenth character is alphanumeric. Characters 6 – 9 and 11–21 should be numeric, although MyStudentData Download reports whatever values have been supplied by the loan holder. MyStudentData Download reports blank for Award IDs less than 21 characters in length.Loan StatusCardinality:1–50Pos.English NameSpanish NameFormatMax. Len.1Loan StatusPréstamo EstadoText22Loan Status DescriptionPréstamo Descripción del EstadoText603Loan Status Effective DatePréstamo Fecha del Estadomm/dd/ccyy10Loan DisbursementCardinality: 0–25Pos.English NameSpanish NameFormatMax. Len.1Loan Disbursement DatePréstamo Fecha de Desembolsomm/dd/ccyy102Loan Disbursement AmountPréstamo Cantidad de Desembolso$nnn,nnn8Loan ContactCardinality: 0–3Pos.English NameSpanish NameFormatMax. Len.1Loan Contact TypePréstamo Tipo de ContactoText252Loan Contact NamePréstamo Nombre de ContactoText653Loan Contact Street Address 1Préstamo Contacto Domicilio 1Text504Loan Contact Street Address 2Préstamo Contacto Domicilio 2Text505Loan Contact CityPréstamo Contacto CiudadText206Loan Contact State CodePréstamo Contacto Codigo de EstadoText27Loan Contact Zip CodePréstamo Contacto Código Postalnnnnn(nnnn)98Loan Contact Phone NumberPréstamo Contacto Numero de Teléfononnn-nnn-nnnn129Loan Contact Phone ExtensionPréstamo Contacto Numero de Extensiónnnnnn510Loan Contact Email AddressPréstamo Contacto Correo ElectrónicoText4511Loan Contact Web Site AddressPréstamo Contacto Sitio WebText45Loan Special ContactCardinality: 0–1Pos.English NameSpanish NameFormatMax. Len.1Loan Special Contact ReasonPréstamo Contacto Razón EspecialText1252Loan Special ContactPréstamo Contacto Especial Text125GrantCardinality: 0–40Pos.English NameSpanish NameFormatMax. Len.1Grant TypeBeca TipoText602Grant Attending School NameBeca Nombre de la Institución Postsecundaria de AsistenciaText653Grant Attending School OPEIDBeca OPEID de la Institución Postsecundaria de Asistenciannnnnnnn84Grant Award YearBeca A?o de Concesiónccyy – ccyy115Grant Scheduled AmountBeca Cantidad Programado a Pagar$nnn,nnn86Grant Award AmountBeca Cantidad de Concesión$nnn,nnn87Grant Disbursed AmountBeca Cantidad Desembolsada$nnn,nnn88Grant Remaining Amount to be PaidBeca Cantidad Pendiente por Pagar$nnn,nnn89Grant First TimeBeca Primera VezText310Grant Additional EligibilityBeca Con Derecho AdicionalText3Grant ContactCardinality: 0–1Pos.English NameSpanish NameFormatMax. Len.1Grant Contact TypeBeca Tipo de ContactoText252Grant Contact NameBeca Nombre de ContactoText653Grant Contact Street Address 1Beca Contacto Domicilio 1Text504Grant Contact Street Address 2Beca Contacto Domicilio 2Text505Grant Contact CityBeca Contacto CiudadText206Grant Contact State CodeBeca Contacto Codigo de EstadoText27Grant Contact Zip CodeBeca Contacto Código Postalnnnnn(nnnn)9OverpaymentCardinality: 0–10Pos.English NameSpanish NameFormatMax. Len.1Overpayment Aid TypeAyuda en Exceso Tipo de AyudaText602Overpayment Attending School NameAyuda en Exceso Nombre de la Institución PostsecundariaText653Overpayment Attending School OPEIDAyuda en Exceso OPEID de la Institución Postsecundariannnnnnnn84Overpayment Disbursement DateAyuda en Exceso Fecha de Desembolsomm/dd/ccyy105Overpayment StatusAyuda en Exceso EstadoText306Overpayment Repayment DateAyuda en Exceso Fecha de Comienzo de Pagosmm/dd/ccyy10Overpayment ContactCardinality: 0–1Pos.English NameSpanish NameFormatMax. Len.1Overpayment Contact TypeAyuda en Exceso Tipo de ContactoText252Overpayment Contact NameAyuda en Exceso Nombre de ContactoText653Overpayment Contact Street Address 1Ayuda en Exceso Contacto Domicilio 1Text504Overpayment Contact Street Address 2Ayuda en Exceso Contacto Domicilio 2Text505Overpayment Contact CityAyuda en Exceso Contacto CiudadText206Overpayment Contact State CodeAyuda en Exceso Contacto Codigo de EstadoText27Overpayment Contact Zip CodeAyuda en Exceso Código Postalnnnnn(nnnn)98Overpayment Contact Phone NumberAyuda en Exceso Número de Teléfononnn-nnn-nnnn129Overpayment Contact Phone ExtensionAyuda en Exceso Número de Extensiónnnnnn510Overpayment Contact Email AddressAyuda en Exceso Correo ElectrónicoText4511Overpayment Contact Web Site AddressAyuda en Exceso Sitio WebText45Overpayment Special ContactCardinality: 0–1Pos.English NameSpanish NameFormatMax. Len.1Overpayment Special Contact ReasonAyuda en Exceso Contacto Razón EspecialText1252Overpayment Special ContactAyuda en Exceso Contacto EspecialText125ProgramCardinality: 0–300Pos.English NameSpanish NameFormatMax. Len.1Program School NamePrograma Nombre de la Institución PostsecundariaText652Program School OPEIDOPEID de la Institución PostsecundariaText83Program CIP TitlePrograma Titulo de CIPText1204Program Credential LevelPrograma Nivel de CredencialText715Program Begin DatePrograma Fecha de Iniciomm/dd/ccyy106Program Published Length in YearsPrograma Longitud Publicada en A?osnn.n4Program StatusCardinality: 0–300Pos.English NameSpanish NameFormatMax. Len.1Program Status DescriptionPrograma Descripción del EstadoText182Program Status Effective DatePrograma Fecha de Dedicación del Estadomm/dd/ccyy10AwardCardinality: 0–50Pos.English NameSpanish NameFormatMax. Len.1Award School NameConcesión Nombre de la Institución PostsecundariaText652Award School OPEIDConcesión OPEID de la Institución PostsecundariaText83Award Earliest Disbursement DateConcesión Fecha del Primer Desembolsomm/dd/ccyy104Award Loan Period Begin DateConcesión Fecha de Comienzo del Plazomm/dd/ccyy105Award Loan Period End DateConcesión Fecha de Cierre del Plazomm/dd/ccyy106Award Subsidized UsageConcesión Uso Subsidiadonn.n47Award Subsidy StatusConcesión Estado del SubsidioText15Appendix A—Sample OutputMyStudentData Download sample output with record layout and data values. Note: Word wrapping of data values occurs only within this document.File Source:U.S. DEPARTMENT OF EDUCATION, NATIONAL STUDENT LOAN DATA SYSTEM (NSLDS)File Request Date:2014-07-01-10.51.27.075Student First Name:YPSILANTIStudent Middle Initial:AStudent Last Name:CURRUTHERSStudent Street Address 1:123 WINDING WAYStudent Street Address 2:APT. 1014Student City:BEDFORD FALLSStudent State Code:NYStudent Country Code:USStudent Zip Code:55501Student Email Address:yacurruthers@ns.eduStudent Home Phone Country Code:001Student Home Phone Number:7035551212Student Home Phone Preferred:NoStudent Cell Phone Country Code:001Student Cell Phone Number:7035551313Student Cell Phone Preferred:YesStudent Work Phone Country Code:001Student Work Phone Number:7035551414Student Work Phone Preferred:NoStudent SULA Maximum Eligibility Period:6.0Student SULA Subsidized Usage Period:1.0Student SULA Remaining Eligibility Period:5.0Student Enrollment Status:FULL TIMEStudent Enrollment Status Effective Date:08/15/2013Student Total All Loans Outstanding Principal:$30,476Student Total All Loans Outstanding Interest:$99Student Pell Lifetime Eligibility Used:4.511%Student Iraq and Afghanistan Service Lifetime Eligibility Used:0.000%Student Total All Grants:$553Total DIRECT STAFFORD SUBSIDIZED (SULA ELIGIBLE) Outstanding Principal:$12,000Total DIRECT STAFFORD SUBSIDIZED (SULA ELIGIBLE) Outstanding Interest:$200Loan Type:DIRECT STAFFORD SUBSIDIZED (SULA ELIGIBLE)Loan Award ID:*****6789012345678901Loan Attending School Name:NORTH SOUTH UNIVERSITYLoan Attending School OPEID:00301000Loan Date:08/15/2013Loan Repayment Begin Date:12/01/2014Loan Period Begin Date:08/15/2013Loan Period End Date:05/20/2014Loan Amount:$8,500Loan Disbursed Amount:$8,500Loan Canceled Amount:$0Loan Canceled Date:Loan Outstanding Principal Balance:$8,500Loan Outstanding Principal Balance as of Date:12/01/2015Loan Outstanding Interest Balance:$100Loan Outstanding Interest Balance as of Date: 12/01/2015Loan Interest Rate Type:VARIABLELoan Interest Rate:6.50%Loan Repayment Plan Type: REVISED PAY AS YOU EARN PLANLoan Repayment Plan Begin Date:12/01/2014Loan Repayment Plan Scheduled Amount:$8,500Loan Repayment Plan IDR Plan Anniversary Date:12/01/2015Loan Confirmed Subsidy Status:SubsidizedLoan Subsidized Usage In Years:1.0Loan Reaffirmation Date:12/15/2014Loan Most Recent Payment Effective Date:11/30/2015Loan Next Payment Due Date:12/30/2015Loan Cumulative Payment Amount:$1,000Loan PSLF Cumulative Matched Months:0Loan Status:IDLoan Status Description:IN SCHOOL OR GRACE PERIODLoan Status Effective Date:08/20/2013Loan Disbursement Date:08/15/2013Loan Disbursement Amount:$7,000Loan Contact Type:Current ED ServicerLoan Contact Name:DEPT OF ED/SERVICERLoan Contact Street Address 1:633 SPIRIT DRIVELoan Contact Street Address 2:Loan Contact City:CHESTERFIELDLoan Contact State Code:MOLoan Contact Zip Code:63005Loan Contact Phone Number:Loan Contact Phone Extension:Loan Contact Email Address:Loan Contact Web Site Address:Grant Type:FEDERAL PELL GRANTGrant Attending School Name:NORTH SOUTH UNIVERSITYGrant Attending School OPEID:00301000Grant Award Year:2013 - 2014Grant Scheduled Amount:$2,210Grant Award Amount:$2,210Grant Disbursed Amount:$110Grant Remaining Amount to be Paid:$2,100Grant First Time:NoGrant Additional Eligibility:N/AGrant Contact Type:Attending SchoolGrant Contact Name:NORTH SOUTH UNIVERSITYGrant Contact Street Address 1:4900 MERIDIAN STREETGrant Contact Street Address 2:Grant Contact City:NORMALGrant Contact State Code:ALGrant Contact Zip Code:357621357Overpayment Aid Type:FEDERAL PELL GRANTOverpayment Attending School Name:NORTH SOUTH UNIVERSITYOverpayment Attending School OPEID:00301000Overpayment Disbursement Date:02/02/2014Overpayment Status:OVERPAYMENTOverpayment Repayment Date:Overpayment Contact Type:Attending SchoolOverpayment Contact Name:NORTH SOUTH UNIVERSITYOverpayment Contact Street Address 1:4900 MERIDIAN STREETOverpayment Contact Street Address 2:Overpayment Contact City:NORMALOverpayment Contact State Code:ALOverpayment Contact Zip Code:357621357Overpayment Contact Phone Number:Overpayment Contact Phone Extension:Overpayment Contact Email Address:Overpayment Contact Web Site Address:Program School Name:NORTH SOUTH UNIVERSITYProgram School OPEID:00301000Program CIP Title:Urban Forestry.Program Credential Level:BACHELOR’S DEGREEProgram Begin Date:08/20/2013Program Published Length in Years:4.0Program Status Description:Full TimeProgram Status Effective Date:08/15/2013Award School Name:North South UniversityAward School OPEID:00301000Award Earliest Disbursement Date:08/15/2013Award Loan Period Begin Date:08/15/2013Award Loan Period End Date:05/20/2014Award Subsidized Usage:1.0Award Subsidy Status:Subsidized ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download