Skip to main content
Topics

DPRP data guide

Send your class data to the CDC and keep it clean.  Read what the 2024 DPRP Standards ask.

Where each point comes from

Each point ends with its source.  The Standards are CDC's Diabetes Prevention Recognition Program Standards and Operating Procedures.  They are dated June 1, 2024.  A source such as Standards IV names a section of that document.  Lukio names a Lukio page.

When you send data

WhenWhat happensSource
Every 6 monthsEvery CDC-recognized organization sends session-level participant data to the CDC.Standards IV, When to Submit Data
6 months after your effective dateYour first file is due.Standards IV, When to Submit Data
The first day of the month after CDC approves your applicationThis is your effective date.Standards Appendix G
Your two due monthsYour effective date sets them.  An effective date of March 1 makes March and September your due months.Standards IV, When to Submit Data
Each code's due monthEach delivery mode has its own organization code.  Send each mode's data under its own code.Standards II.D
Any timeYou may upload files.Standards IV, Making Data Submissions
On or after the first day of the due monthYou may submit files.Standards IV, Making Data Submissions
About one month before your due monthThe CDC emails your contacts.Standards IV, When to Submit Data
About 2 weeks into the due monthA second reminder comes.Standards IV, When to Submit Data
Every 6 months, at every recognition statusSend data on all participants in all ongoing cohorts.Standards II.K

What a file covers

The DPRP data portal

The file

The identifiers

FieldWhat it holdsValuesSource
ORGCODEThe organization code the CDC assigns.  There is one for each delivery mode.Standards IV, Evaluation Data Elements
PARTICIPThe participant ID your organization assigns to each participant.Never base it on a name, social security number or date of birth.  Never base it on other identifying information.  Never reuse it, for another person or for the same person enrolling again.Standards IV, Evaluation Data Elements
COHORTIDIt names a group cohort or an individual cohort.Never reuse a cohort ID.  An individual cohort's cohort ID equals the participant's ID.Standards IV, Evaluation Data Elements
COACHIDIt names each Lifestyle Coach.Never base it on the coach's name or other identifying information.  Lifestyle Coaches who deliver the MDPP use their National Provider Identifier as their coach ID.Standards IV, Evaluation Data Elements and Table 5

The enrollment answers

FieldWhat it holdsValuesSource
ENROLLMOTWhat moved the participant most to enroll.Standards IV, Table 5
ENROLLHCWhether a health care professional asked the participant to join.Standards IV, Table 5
PAYERSOURCEThe primary payer for the participant's participation.Standards IV, Table 5
STATEThe state or territory where the participant lives.Its two-letter postal abbreviation.Standards IV, Table 5
PARTICIPZIPThe zip code where the participant lives.5 digits.Standards IV, Table 5
AGEThe participant's age at enrollment.18 to 125, in whole years.Standards IV, Table 5
ETHRACEINFOThe participant's own words.Up to 100 characters.  NA when they give none.Standards IV, Table 5
SEXThe sex on the participant's original birth certificate.1, 2, or 9 when not reported.Standards IV, Table 5
HEIGHTA height that may be self-reported.Whole inches, from 30 to 98.  Convert a height in feet and inches to the nearest whole inch.Standards IV, Table 5 and Evaluation Data Elements
EDUThe highest grade completed.1 to 4, or 9 when not reported.Standards IV, Table 5
A1CThe first A1C is from a test within a year before enrollment.  Report it within 14 days of the first session.  The final A1C is from a test in months 9 to 12.  It is required only when you plan to use it to show reduced risk.5.7 to 6.4 for the first entry, and 2.5 to 18 after.  999 when not reported.  An A1C that drops below the prediabetes range does not make a participant ineligible.Standards IV, Table 5 and Evaluation Data Elements

The session answers

FieldWhat it holdsValuesSource
DMODEThe delivery mode of that session.1 in person, 2 online, 3 distance learning.Standards IV, Table 5
SESSTYPEA session in months 1 to 6 is C.  This holds even for a module from months 7 to 12.  A session in months 7 to 12 is CM.  This holds even for a module from months 1 to 6.C in months 1 to 6.  CM in months 7 to 12.  A make-up session is MU-C in months 1 to 6.  It is MU-CM in months 7 to 12.  OM marks an Ongoing Maintenance session after the first year.  The CDC does not evaluate those.Standards IV, Table 5 and Evaluation Data Elements
DATEThe actual date of the session.  For an online session, it is the date the participant completed it.Written mm/dd/yyyy.Standards IV, Table 5 and Evaluation Data Elements
WEIGHTPounds, to the nearest tenth.70 to 997.  999 when the weight cannot be reported.Standards IV, Table 5
PAThe minutes of moderate or brisk activity since the participant's previous session attended.0 when the participant did no activity, or did not track their minutes.Standards IV, Table 5

Clean the data

After you submit

What the CDC evaluates

  • The CDC evaluates only at your required data submissions. Standards II.K
  • An evaluation cohort is every cohort whose first session falls in the same 6-month sequence. Standards II.K
  • That sequence began 12 to 18 months before the current due month's first day. Standards II.K
  • A cohort is complete once 365 days pass after its first session. Standards II.K
  • The CDC analyzes only the first 365 days of each cohort. Standards II.K, Requirement 3
  • The CDC evaluates only eligible participants who are completers. Standards II.K
  • A completer came to at least 8 sessions in months 1 to 6. Standards II.K
  • A completer's last session is at least 9 full months after the cohort's first session. Standards II.K
  • Requirement 5 asks for at least 5 eligible participants.  At least 30% of them are completers. Standards II.K, Table 3
  • Requirement 6 asks that at least 60% of completers reach one goal below. Standards II.K, Table 3
  • The goals are 5% weight loss, or 4% weight loss with 17 sessions. Standards II.K
  • Another goal is 4% weight loss with 8 sessions averaging 150 activity minutes a week. Standards II.K
  • The last goal is a 0.2 point drop in A1C. Standards II.K
  • Weight loss uses the first and last recorded weights of Core and Core Maintenance. Standards II.K
  • Requirement 7 asks that at least 35% of completers qualified by blood test or GDM. Standards II.K, Table 3
  • Full Plus also asks that eligible participants stay.  At least 50% remain at the start of month 4.  At least 40% remain at month 7, and 30% at month 10. Standards II.K, Table 3

Who is eligible

  • A participant is 18 or older. Standards II.A
  • A participant's BMI is 25 or more.  It is 23 or more if Asian or Asian American. Standards II.A
  • A blood test within a year of enrollment shows prediabetes.  Or the participant had GDM before. Standards II.A
  • Or the participant screens positive on the Prediabetes Risk Test. Standards II.A
  • MDPP participants qualify by a lab result only. Standards II.A
  • A participant has no earlier diagnosis of type 1 or type 2 diabetes. Standards II.A
  • A participant is not pregnant at enrollment. Standards II.A

Get the file ready in Lukio

  • Lukio makes the file on the CDC file page. Lukio, Export the CDC file
  • It makes one CSV file, with one row for each participant at each session. Lukio, CDC file
  • Its columns carry Table 5's names, in Table 5's order. Lukio, CDC file
  • Site and period chooses the delivery code and the 6-month sequence the file covers. Lukio, CDC file
  • Lukio reads each delivery code's sequences from its effective date. Lukio, CDC file
  • The file holds only sessions dated inside the chosen sequence. Lukio, CDC file
  • A red count beside Freeze and download lists each row the file holds back. Lukio, Export the CDC file
  • Freeze and download works only when no red count stands. Lukio, Export the CDC file
  • Freeze and download works only once the sequence's last day has passed.  The CDC takes a sequence's data from the first day of its due month. Lukio, CDC file, and Standards IV, Making Data Submissions
  • The preview shows a sequence any time.  A sequence whose last day has not passed reads still collecting. Lukio, CDC file
  • Lukio keeps each file it freezes.  Upload the downloaded file to the DPRP data portal yourself. Lukio, Export the CDC file

What the red count lists

  • A required answer left blank, such as age, sex, education or payer source.  Fix it on the record the line names. Lukio, CDC file
  • A payer source of Other.  The CDC's payer list has no Other.  Pick the payer that fits on the registration. Lukio, CDC file, and Standards IV, Table 5
  • One person with two sessions on one date.  Correct the date, or make one of them a make-up. Lukio, CDC file, and Standards IV, Evaluation Data Elements
  • A person waiting for a participant ID.  Right-click their ID cell, then click Issue ID. Lukio, Export the CDC file
  • A class with no delivery code or no class code.  Open the class and set it. Lukio, CDC file
  • A session with no delivery mode.  Open the session and set it. Lukio, CDC file

The checks on a session

Common pitfalls

Use of this material does not imply endorsement by CDC, HHS or the U.S. Government of Lukio or its services.

Answers about this page

42 more answers
Enrollment and retentionWhat do I tell participants about how their enrollment answers are shared?Enrollment and retentionWhat retention rates does Full Plus recognition require?Sessions and attendanceAre make-up sessions required in the National DPP lifestyle change program?Sessions and attendanceDoes the National DPP have to last exactly 365 days?Sessions and attendanceWhat are the rules for National DPP make-up sessions?Sessions and attendanceWhat weight and minutes do you record for a make-up session on the same day?Weight and physical activityHow do you record weight and activity minutes for a make-up session?Weight and physical activityHow should participants report physical activity minutes at each session?Weight and physical activityWhat weight do we record when a participant can't be weighed?CurriculumCan we add extra sessions in the first 6 months of the National DPP?CurriculumCan we hold extra sessions, and how do we code them for the CDC?CurriculumDo PreventT2 modules have to be taught in order?Coaches and trainingDo nurses and dietitians need formal lifestyle coach training?Data collection and the CDC submissionCan CDC give an extension on a DPRP data submission?Data collection and the CDC submissionCan I submit my next DPRP file before CDC accepts the one due first?Data collection and the CDC submissionCan we send participant names or birth dates to the CDC?Data collection and the CDC submissionDo we submit data for National DPP participants with developmental disabilities?Data collection and the CDC submissionHow do I code education level (EDU) in DPRP data?Data collection and the CDC submissionHow do I get a SAMS account for the DPRP Data Portal?Data collection and the CDC submissionHow do we code PAYERSOURCE for a participant with Medicare and Medicaid, or 2 payers?Data collection and the CDC submissionHow do we code race and ethnicity in the DPRP file when a participant does not report it?Data collection and the CDC submissionHow many data elements does the DPRP data submission file need?Data collection and the CDC submissionShould I update a participant's age in the DPRP data after a birthday?Data collection and the CDC submissionWhat data goes in each 6-month DPRP submission?Data collection and the CDC submissionWhat do you do when a participant's weight looks like an outlier?Data collection and the CDC submissionWhat file format does the DPRP data portal accept?Data collection and the CDC submissionWhen can I submit my DPRP data file?Data collection and the CDC submissionWhen do I record A1C for a National DPP participant?Data collection and the CDC submissionWhen is my DPRP data submission due?Data collection and the CDC submissionWhich records go in a DPRP data submission?Data collection and the CDC submissionWho can submit our data in the DPRP Data Portal?CDC recognitionHow do we withdraw from the DPRP, and can we reapply later?CDC recognitionHow soon can we start classes after CDC approves our DPRP application?CDC recognitionWhat are the 4 levels of CDC recognition for a National DPP program?CDC recognitionWhat does a National DPP organization need to earn Full recognition?CDC recognitionWhat does an organization need to get CDC recognition for a DPP?CDC recognitionWhat weight loss or A1C result counts toward CDC Full recognition?CDC recognitionWhich cohorts does the CDC evaluate at each DPRP data submission?CDC recognitionWho can apply for CDC recognition of a National DPP lifestyle change program?Setting up a programHow do we add or update our class locations in the DPRP Data Portal and Find a Program?Setting up a programHow do we change our DPRP Program Coordinator, Secondary Contact or Data Preparer?Setting up a programWhat is a National DPP State Quality Specialist?