Sample Data Files

Sample Version 1 Data Files

Sample Cohort Data File

DCE01,10027795,004781,00,,,,,20171030,,TEST2010-11,,,,
CH1,Cohort,Cohort Term,Cohort Term Begin Date, Cohort Term End Date,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Street Line 1,Street Line 2,City,State,Zip/Postal Code,Country,Date of Birth,Ethnicity,Race,Institution ID Type,Institution ID,HS Completion Status,HS Completion Year,HS Unweighted GPA,HS Weighted GPA,First Gen,Dual and Summer Enrollment,Enrollment Type,Number of College Credits Attempted to Transfer,Number of College Transfer Credits Accepted,Math Placement,English Placement,Gateway Math Status,Gateway English Status
D1,2010-11,Fall,20170810,20171220,123456789,123456789,PDPTESTSTD053,John,M,Terry,1234 Test St,,Herndon,VA,20171,US,19800101,H,A,OPEID,00478100,H,2010,3.52,3.75,N,DE,F,,,N,N,N,N
T1,63,

Sample Course Data File

DCE02,10027795,004781,00,,,,,20170605,,Client File ID 1000,,,,
CH1,Cohort,Cohort Term,Academic Year,Term,Institution ID Type,Institution ID,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Suffix,Current Street 1,Current Street 2,Current City,Current State,Current Zip/Postal Code,Current Country,Date of Birth,Student Phone Number,Pell Recipient,Student Email,CompleteDevMath,CompleteDevEnglish,TransferIntent,Degree Type Sought,Semester/Session GPA,Overall GPA,Course Prefix,Course Number,Section ID,Course Name,Course Description,Course CIP,Course Type,MathOrEnglishGateway,Co-requisite Course,Course Begin Date,Course End Date,Grade,Number of Credits Attempted,Number of Credits Earned,Delivery Method,Core Course,Core Course Type,Core Competency Completed,Total Combined Earned and Transferred Credits,Purpose of Course Exchange,Certification Endorsed Curriculum/Program,Certificate Endorsing Industry,Grade Effective Date,DGI Institution ID Type,DGI Institution ID,DGI Student ID
D1,2010-11,Fall,2010-11,Spring,OPEID,00478100,123456789,123456789,PDPTESTSTD054,David,Silva,Villa,,2300 Dulles Station,#300,Herndon,VA,20171,US,19870415,999-999-9999,Y,TEST@EMAIL.COM,C,C,I,B,3.91,2.98,PHYS,189,JSN3,Physics,,65.3215,CU,NA,,20100816,20101220,A,3,3,F,N,
,,3,2,,,20101226,OPEID,DGIINST1,DGISTDID054
T1,63,

Sample Financial Aid Data File

DCE03,10027795,004781,00,,,,,20170605,,Client File ID 1000,,,,
CH1,Cohort,Cohort Term,Academic Year,Institution ID Type,Institution ID,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Suffix,Street Line 1,Street Line 2,City,State,Zip/Postal Code,Country,Date of Birth,Applied Aid,Depend,Income,Tuition,Type of Housing,Room Charges,Board Charges,Books,Other Expense,EFC,Marital Status,Number of Dependents,SEOG,TEACH,Veteran and Military,Other Federal Grant,Pell Amount,State Grant Need Based,State Grant Non Need Based,Institution Grant Need Based,Institution Grant Employer Aid,Institution Grant Merit,Institution Grant Military or Veteran,Other Institution Grant Non Need Based,Other Grant,Federal Loan,State Loan,Institution Loan,Parent PLUS,Other Loan,Federal Work,State Work,Inst Work,Other Aid
D1,2010-11,Fall,2010-11,OPEID,99999999,123456789,123456789,PDPTESTSTD054,David,Silva,Villa,,2300 DullesStation,#300,Herndon,VA,20171,US,19870415,Y,Y,10000,17000,1,500,500,100,1000,0,1,1,0,0,50,0,0,0,0,0,
0,0,0,0,1000,0,0,1000,0,500,500,500,500,500
T1,4,

Sample Version 2.0 Data Files

Sample Version 2.0 Cohort Data File

DCE01,10027795,004781,00,2.0,,,,20171030,,TEST2010-11,,,,
CH1,Cohort,Cohort Term,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Street Line 1,Street Line 2,City,State,Zip/Postal Code,Country,Date of Birth,Ethnicity,Race,Institution ID Type,Institution ID,HS Completion Status,HS Completion Year,HS Unweighted GPA,HS Weighted GPA,First Gen,Dual and Summer Enrollment,Enrollment Type,Number of College Credits Attempted to Transfer,Number of College Transfer Credits Accepted,Math Placement,English Placement,Gateway Math Status,Gateway English Status,Cohort Term Begin Date,Cohort Term End Date,Reading Placement,Special Program,NASPA First-Generation,Gender,Incarcerated Status,Military Status,Employment Status,Disability Status
D1,2010-11,Fall,20170810,20171220,123456789,123456789,PDPTESTSTD053,John,M,Terry,1234 Test St,,Herendon,VA,20171,US,19800101,H,A,OPEID,00478100,H,2010,3.52,3.75,N,DE,F,,,N,N,N,N,UK,ccgefcohort,4,X,
N,1,3,Y
T1,4,

Sample Version 2.0 Course Data File

DCE02,10027795,004781,00,2.0,,,,20171030,,TEST2010-11,,,,
CH1,Cohort,Cohort Term,Academic Year,Term,Institution ID Type,Institution ID,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Suffix,Current Street 1,Current Street 2,Current City,Current State,Current Zip/Postal Code,Current Country,Date of Birth,Student Phone Number,Pell Recipient,Student Email,CompleteDevMath,CompleteDevEnglish,TransferIntent,Degree Type Sought,Semester/Session GPA,Overall GPA,Course Prefix,Course Number,Section ID,Course Name,Course Description,Course CIP,Course Type,MathOrEnglishGateway,Co-requisite Course,Course Begin Date,Course End Date,Grade,Number of Credits Attempted,Number of Credits Earned,Delivery Method,Core Course,Core Course Type,Core Competency Completed,Total Combined Earned and Transferred Credits,Purpose of Course Exchange,Certification Endorsed Curriculum/Program,Certificate Endorsing Industry,Grade Effective Date,DGI Institution ID Type,DGI Institution ID,DGI Student ID,Credential Engine Identifier,Course Instructor Employment Status,Course Instructor Rank,Foreign Language Completion
D1,2010-11,Fall,2010-11,Spring,OPEID,00478100,123456789,123456789,PDPTESTSTD054,David,Silva,Villa,,
2300 Dulles Station,#300,Herendon,VA,20171,US,19870415,999-999-9999,Y,TEST@EMAIL.COM,C,C,I,B,3.91,
2.98,PHYS,189,JSN3,Physics,,65.3215,CU,NA,,20100816,20101220,A,3,3,F,N,,,3,2,,,20101226,OPEID,DGIINST1,DGI
STDID054,ce-e8a41a52-6ff6-48f0-9872-889c87b093b7,PT,1,N
T1,4,

Previous: Formatting the Financial Aid File Detail Records  |  Next: When to Submit Data Files


 

Was this article helpful?

Related Articles