{"id":109,"date":"2021-02-11T03:20:51","date_gmt":"2021-02-11T03:20:51","guid":{"rendered":"https:\/\/pubproof.studentclearinghouse.org\/kbsandbox\/?p=109"},"modified":"2025-06-04T16:11:49","modified_gmt":"2025-06-04T20:11:49","slug":"sample-data-files","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/sample-data-files\/","title":{"rendered":"Sample Data Files"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">CONTENTS<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/sample-data-files\/#Sample_Version_1_Data_Files\" >Sample Version 1 Data Files<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/sample-data-files\/#Sample_Version_20_Data_Files\" >Sample Version 2.0 Data Files<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Sample_Version_1_Data_Files\"><\/span>Sample Version 1 Data Files<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Sample Cohort Data File<\/h3>\n<p class=\"box\"><code>DCE01,10027795,004781,00,,,,,20171030,,TEST2010-11,,,,<br \/>\nCH1,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<br \/>\nD1,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<br \/>\nT1,63,<\/code><\/p>\n<h3>Sample Course Data File<\/h3>\n<p class=\"box\"><code>DCE02,10027795,004781,00,,,,,20170605,,Client File ID 1000,,,,<br \/>\nCH1,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<br \/>\nD1,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,<br \/>\n,,3,2,,,20101226,OPEID,DGIINST1,DGISTDID054<br \/>\nT1,63,<\/code><\/p>\n<h3>Sample Financial Aid Data File<\/h3>\n<p class=\"box\"><code>DCE03,10027795,004781,00,,,,,20170605,,Client File ID 1000,,,,<br \/>\nCH1,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<br \/>\nD1,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,<br \/>\n0,0,0,0,1000,0,0,1000,0,500,500,500,500,500<br \/>\nT1,4,<\/code><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sample_Version_20_Data_Files\"><\/span>Sample Version 2.0 Data Files<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Sample Version 2.0 Cohort Data File<\/h3>\n<div class=\"code\"><code>DCE01,10027795,004781,00,2.0,,,,20171030,,TEST2010-11,,,,<br \/>\nCH1,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,Reading Placement,Special Program,NASPA First-Generation,Gender,Incarcerated Status,Military Status,Employment Status,Disability Status<br \/>\nD1,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<br \/>\nT1,4,<\/code><\/div>\n<h3><\/h3>\n<h3>Sample Version 2.0 Course Data File<\/h3>\n<div class=\"code\"><code>DCE02,10027795,004781,00,2.0,,,,20171030,,TEST2010-11,,,,<br \/>\nCH1,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<br \/>\nD1,2010-11,Fall,2010-11,Spring,OPEID,00478100,123456789,123456789,PDPTESTSTD054,David,Silva,Villa,,<br \/>\n2300 Dulles Station,#300,Herendon,VA,20171,US,19870415,999-999-9999,Y,TEST@EMAIL.COM,C,C,I,B,3.91,<br \/>\n2.98,PHYS,189,JSN3,Physics,,65.3215,CU,NA,,20100816,20101220,A,3,3,F,N,,,3,2,,,20101226,OPEID,DGIINST1,DGI<br \/>\nSTDID054,ce-e8a41a52-6ff6-48f0-9872-889c87b093b7,PT,1,N<br \/>\nT1,4,<\/code><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>See samples of cohort, course, and financial aid data files to help guide you.<\/p>\n","protected":false},"author":6,"menu_order":95,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[50,78,81],"ht-kb-tag":[],"class_list":["post-109","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-creating-data-files","ht_kb_category-institutional-researchers","ht_kb_category-information-technology"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":14,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/109\/revisions"}],"predecessor-version":[{"id":16312,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/109\/revisions\/16312"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=109"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}