Behind the PDP Submission: Getting Started with Data Submission (7 minutes)
This is the start of a mini-series that covers file submission. This video covers the PDP files needed for PDP data submission, how to find the resources that detail what goes into the files, submission strategy, and what kind of access is needed to submit PDP files, download AR files, and access the dashboards.
Resources
- Submitting Data section of the PDP Knowledge Base
- PDP Mapping Tool
- Getting Started with the PDP: Data Elements
Video Transcript
[Alex]: Welcome to the Postsecondary Data Partnership. I'm excited to kick off this behind the submission series with Vijaya, a representative for our PDP experts.
[Vijaya]: Thanks for having me. Today we'll cover what institutions need to know before their first PDP submission. [Alex]: Before we get started, throughout this series you'll find links to the content mentioned in the materials tab. A transcript is also posted there, and you can also turn on closed captions. So Vijaya, what do data submitters need to do to get access to the PDP dashboards and analysis ready files?
[Vijaya]: They need to submit two additional files called the course and cohort files. This is information that is not provided in the other Clearinghouse services that institutions report. The cohort file contains one row of data per student and is static data at the time of enrollment. For the course file, include all students from previous and current cohorts that are currently enrolled at your institution in a reporting term. This file contains dynamic data for each term the student attended at your institution. For the financial aid file, use the same logic as the course file. For each cohort year submitted, include every student that enrolled at your institution as a first-time or transfer student in that particular year. Then submit the supporting course data for each of those years. The course files are cumulative, and the records in each file should grow in volume as you progress through the years. You may submit all of your cohort data in one file as long as it's under 5 GB or submit by academic year or term.
[Alex]: How long does the first submission take?
[Vijaya]: Every institution and system is a little different. Typically, it's 40 hours of work.
[Alex]: So what's step one?
[Vijaya]: Build a team, bring together folks from IR, registrar, and financial aid. It's important to align terminology across campus and a common data dictionary that includes leave of absence, withdrawn, first time in college, readmit, and transfer. The course cohort and optional financial aid data files for PDP are matched with data submitted by registrars and financial aid through the enrollment reporting and verification services. You want to make sure you have data governance on campus to qualify and track students so you can get started and have alignment for all services.
[Alex]: I like that. My tip, let's navigate to the PDP knowledge base from studentclearinghouse.org, select help near the top right.
On the help page, in the Educational Institutions and Organizations column, select Postsecondary Data Partnership PDP.
In the By Stage section, select the Submitting Data tile.
Start with the Submitting Data section of the PDP knowledge base. Review the data elements that need to be mapped and how they impact the PDP dashboards and analysis ready files.
[Vijaya]: Exactly. It's also a great place to just get started and say, where do we have the data? Which office owns the data? Where are we going to keep and store the data so that I can extract it into the files? You can download the PDP mapping template and use it as a worksheet to note the department and individual responsible. The worksheet also denotes optional fields used as dashboard filters. And if you elect to submit a financial aid file, but it's going to take time, submit your course and cohort files first.
[Alex]: Great point. A common question is, when should we submit?
[Vijaya]: PDP has no deadlines. For your initial submission, send three to five years of historical data. After that, most schools submit twice a year, February for fall term and July for spring. If you have winter or summer terms, submit once grades are finalized. Just don't send incomplete data.
[Alex]: Where do schools usually get stuck? [Vijaya]: Finding the data. Gateway status might be in advising notes. CIP codes sometimes not tracked at all. One school created a PDP task force to map data ownership and to save them headaches later.
[Alex]: And if you're missing CIP codes, submit what you have and use missing as a placeholder. Then when your institution has time, you could start a cleanup project.
[Vijaya]: Exactly. Quick note on gateway courses. They're only English and math. When thinking about if a course should be a gateway, think of it as is the course a basic requirement for the major the student is in.
[Alex]: Can you talk about what kinds of variable types we ask for?
[Vijaya]: Of course, let's navigate to the PDP knowledge base. In the formatting the detailed records articles of the knowledge base, there are tables detailing the data. The variable type column indicates what kind of data is accepted for that variable. String means any character goes. Enumerated is a constrained field that only accepts certain values. The format column indicates the number of characters, year, or numeric format allowed in each field. The required field identifies which fields are required. Yes is required. No is not required or optional. And conditional is conditionally required. The description column is a definition of the field, often with examples and notes on what can be included. Please study these carefully. There are also sample downloadable templates available.
[Alex]: Great. Before we wrap, let's talk access. Your PDP user administrators, usually the registrar, controls access. If you don't have access to the PDP, reach out to them. You'll need an individual login to upload files and view dashboards. If you are going to access the analysis ready or AR files, that's a shared FTP account that's separate from any other FTP accounts your institution may have for other services like enrollment reporting. Always make sure to check with your fellow shared account holders before resetting that password.
[Vijaya]: And my advice, don't wait for perfect data. Start with what you have. Use the submitting data section of the knowledge base, PDP tutorials, and email pdpservice@studentclearinghouse.org if you need help.
[Alex]: Great advice. Before our next episode, check out the next two videos that discuss the data elements, the recorded key concepts webinar, and the submitting data section of the knowledge base. Then meet with your internal team to figure out what data is available and where it's stored. We'll return to discuss reviewing your file format.



