← Back to emilyrupp.consulting

PDP Required Variables Checklist

The Postsecondary Data Partnership (PDP) submission includes 89 unique variables across two files — but you can get started with an initial submission of just 28. This checklist breaks down what you need for a minimum viable submission, the priority variables to update next, and the students you should exclude for better dashboard accuracy.

Must Upload Now - 0 of 28 complete

Common Variables (14 - must match between Cohort and Course files)

Column headers differ between files. Cohort header shown first, Course header in parentheses where different.

VarCohort HeaderCourse HeaderFormatNotes
V1Data record type (Col: CH1)Data record type (Col: CH1)EnumeratedFixed: D1
V2CohortCohortYYYY-YYMust match between files
V3Cohort TermCohort TermEnumeratedFall, Spring, Summer, Winter
V6/V8SSNSSN9 digitsA/B: submit SSN or Student ID
V8/V10Student IDStudent ID3-20 charsA/B: submit SSN or Student ID
V9/V11First NameFirst NameUp to 60 charsA-Z, hyphens, apostrophes, spaces, periods only. No accented characters — transliterate to ASCII.
V11/V13Last NameLast NameUp to 60 charsA-Z, hyphens, apostrophes, spaces, periods only. No accented characters — transliterate to ASCII.
V12/V15Street Line 1Current Street 12-30 charsUK if unknown
V14/V17CityCurrent City2-20 charsUK if unknown
V15/V18StateCurrent State2 charsUK if unknown
V17/V20CountryCurrent Country2-char ISOUK if unknown
V18/V21Date of BirthDate of BirthYYYYMMDDExclude student from BOTH files if unknown
V21/V6Institution ID TypeInstitution ID TypeEnumeratedFixed: OPEID
V22/V7Institution IDInstitution ID8 chars

Cohort-Only Variables (4)

VarColumn HeaderFileFormatNotes
V4Cohort Term Begin DateCohortYYYYMMDDCannot be same as or after End Date
V5Cohort Term End DateCohortYYYYMMDDCannot be same as or before Begin Date
V19EthnicityCohortEnumeratedH, N, UK
V29Enrollment TypeCohortEnumeratedF, R, T — derived variable

Course-Only Variables (10)

VarColumn HeaderFileFormatNotes
V4Academic YearCourseYYYY-YYYear the course belongs to (not Cohort year)
V5TermCourseEnumeratedFall, Spring, Summer, Winter
V31Course PrefixCourseUp to 50 charse.g., ENGL, MATH
V32Course NumberCourseUp to 20 charse.g., 101, 200A
V34Course NameCourseUp to 50 charse.g., College Algebra
V36Course CIPCourseEnumeratedEnter "Missing" if unavailable
V40Course Begin DateCourseYYYYMMDD
V41Course End DateCourseYYYYMMDD
V43Number of Credits AttemptedCourseXX.XXCRITICAL: never leave blank. Use 0.00 for non-credit
V50Purpose of Course ExchangeCourseEnumerated

Exclusions - 0 of 4 complete

RuleApplies ToNotes
Exclude students with unknown Date of BirthBothRemove ALL
Exclude CCAP studentsBothCollege and Career Access Pathways
Exclude Dual Enrolled studentsBothConcurrently Enrolled High School Students
Exclude Statewide Virtual Campus Exchange studentsBothFor Example: CVC Exchange Students in California

Update Later - 0 of 16 complete

Cohort Variables (5, ranked by priority)

PriorityVarVariable NameFileInterim CodeNotes
1stV20RaceCohortUKCritical for equity reporting
2ndV32Math PlacementCohortUKPowers Placement dashboard filter
2ndV33English PlacementCohortUKPowers Placement dashboard filter
3rdV34Gateway Math StatusCohortUKAll-UK = no Gateway data shown
3rdV35Gateway English StatusCohortUKAll-UK = no Gateway data shown

Course Variables (11, ranked by priority)

PriorityVarVariable NameFileInterim CodeNotes
1stV42GradeCourseMissingCore outcome; analysis-ready file
1stV44Number of Credits EarnedCourse0.00Must have value or dashboards break
2ndV28Degree Type SoughtCourseUKCredential Seeking Status filter
2ndV30Overall GPACourse0.00Dashboard filter/dimension
3rdV38MathOrEnglishGatewayCourseNAGateway shows 0% completion if all NA
4thV23Pell RecipientCourseUKY, N, UK
5thV37Course TypeCourseOtherCU, CG, CC, CD, EL, AB, GE, NC, O
5thV33Section IDCourseNAUp to 20 chars, no slashes (/ or \)
5thV29Semester/Session GPACourse0.00X.XX format (0.00–4.00). Must use 0.00 if no data
6thV25CompleteDevMathCourseNADev students only
6thV26CompleteDevEnglishCourseNADev students only