Knowledge Base

Creating a Data File

Data files are used to submit data through the PDP. They must include all of the necessary information and be...

Formatting a Data File

Data files must be submitted as comma-delimited CSV or TXT files in flat-file format. A flat file contains a plain text table...

Formatting the Header Record

You must include all of the following fields in the header record for each data file. All fields are required....

Formatting the Trailer Record

You must include all of the following fields in the trailer record for each data file. All fields are required....

Formatting the Column Header Record

Every data file must include a column header record containing the column headings for the fields in the data file....

Formatting the Cohort File Detail Records

In the cohort data file, you should include three kinds of data: Identifying information about the student The student’s high...

Formatting the Course File Detail Records

In the course data file, you should include three kinds of information: Identifying information about the student Information about the...

Formatting the Financial Aid File Detail Records

You must submit the financial aid file AFTER your cohort file has been loaded and its status is Passed in...

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...

Data File Templates

You can use the following templates as guides to help you format your data submission files. The templates are in...

Formatting the Detail Records

The detail records contain the field values in the data files. The fields are different for each data file type....