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
| When | What happens | Source |
|---|---|---|
| Every 6 months | Every CDC-recognized organization sends session-level participant data to the CDC. | Standards IV, When to Submit Data |
| 6 months after your effective date | Your first file is due. | Standards IV, When to Submit Data |
| The first day of the month after CDC approves your application | This is your effective date. | Standards Appendix G |
| Your two due months | Your 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 month | Each delivery mode has its own organization code. Send each mode's data under its own code. | Standards II.D |
| Any time | You may upload files. | Standards IV, Making Data Submissions |
| On or after the first day of the due month | You may submit files. | Standards IV, Making Data Submissions |
| About one month before your due month | The CDC emails your contacts. | Standards IV, When to Submit Data |
| About 2 weeks into the due month | A second reminder comes. | Standards IV, When to Submit Data |
| Every 6 months, at every recognition status | Send data on all participants in all ongoing cohorts. | Standards II.K |
What a file covers
- A sequence is a 6-month data collection period. It starts on the first day of a due month. It ends the day before the next due month. Standards Appendix G
- Each file holds the records of the sequence before the current due month. Standards IV, Making Data Submissions
- Leave out records from the current due month. Standards IV, Making Data Submissions
- Your first file holds the sessions held since your approval date. Standards Appendix G
- Include every participant who came to at least 1 session in the sequence. Include all cohorts. Standards IV, Making Data Submissions
- Send the records of every session each enrolled participant completed. Never send only the people you think took part enough. Standards II.I
- A file may hold participants from several cohorts. Standards IV, Making Data Submissions
- Send no data on family members or friends who come to support a participant. Standards II.A
The DPRP data portal
- You submit files through the DPRP Data Submission and Administration Portal. Standards IV, How to Submit Data
- Only contacts the portal lists may submit. They are the Program Coordinator, Secondary Contact and Data Preparer. Standards IV, How to Submit Data
- Each of them needs their own SAMS account. Standards IV, How to Submit Data
- The SAMS email comes within a week of being named to one of those roles. Check your spam folder if it does not come. Standards IV, How to Submit Data
- Your SAMS password expires every 60 days. Standards IV, How to Submit Data
- Keep your contacts, Lifestyle Coaches and class information current in the portal. The portal requires it before you submit. Standards IV, Updating Organizational Information
- A Data Preparer can submit data. A Data Preparer cannot download the recognition certificate and letter. Standards IV, Table 4
The file
- The file is a CSV file. On a Mac, save it as CSV (Comma Delimited), never CSV (Macintosh). Standards IV, Making Data Submissions
- You may send one file, or two. Standards IV, Making Data Submissions
- In one file, every session row carries the participant's enrollment answers. Standards IV, Making Data Submissions
- With two files, one holds the sessions of every participant. Standards IV, Making Data Submissions
- The other holds enrollment answers only for new participants, or for answers that changed. Standards IV, Making Data Submissions
- Use the column names, codes and values of Table 5, the Data Dictionary. Keep their spelling. Standards IV, Making Data Submissions
- The columns stand in the same order as in Table 5. Standards IV, Making Data Submissions
- Each row is one participant at one session, with the session's actual date. Standards IV, Table 5
- Send no personally identifiable information about participants or Lifestyle Coaches. Standards IV, Making Data Submissions
CDC rule
Once the CDC accepts a file, you cannot submit it again. Make sure it is complete and right first. Standards IV, Making Data Submissions
The identifiers
| Field | What it holds | Values | Source |
|---|---|---|---|
| ORGCODE | The organization code the CDC assigns. There is one for each delivery mode. | Standards IV, Evaluation Data Elements | |
| PARTICIP | The 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 |
| COHORTID | It 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 |
| COACHID | It 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 |
- An ID holds up to 25 letters and numbers. An ID of numbers alone holds up to 10. Standards IV, Table 5
- The CDC suggests IDs that do not look like dates. Standards IV, Table 5
- An ID holds no spaces, and no special character except a hyphen. Standards IV, Table 5
The enrollment answers
- Ask the enrollment questions in the format of the Participant Enrollment Form, Appendix D. Using the form itself is optional. Standards IV, Evaluation Data Elements
- Enrollment answers are collected once. Update them when they change. Standards IV, Evaluation Data Elements
| Field | What it holds | Values | Source |
|---|---|---|---|
| ENROLLMOT | What moved the participant most to enroll. | Standards IV, Table 5 | |
| ENROLLHC | Whether a health care professional asked the participant to join. | Standards IV, Table 5 | |
| PAYERSOURCE | The primary payer for the participant's participation. | Standards IV, Table 5 | |
| STATE | The state or territory where the participant lives. | Its two-letter postal abbreviation. | Standards IV, Table 5 |
| PARTICIPZIP | The zip code where the participant lives. | 5 digits. | Standards IV, Table 5 |
| AGE | The participant's age at enrollment. | 18 to 125, in whole years. | Standards IV, Table 5 |
| ETHRACEINFO | The participant's own words. | Up to 100 characters. NA when they give none. | Standards IV, Table 5 |
| SEX | The sex on the participant's original birth certificate. | 1, 2, or 9 when not reported. | Standards IV, Table 5 |
| HEIGHT | A 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 |
| EDU | The highest grade completed. | 1 to 4, or 9 when not reported. | Standards IV, Table 5 |
| A1C | The 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 |
- Each of the seven race and ethnicity columns holds 1 or 2. A participant may choose more than one. Standards IV, Table 5
- A participant who gives no race or ethnicity gets 2 in all seven columns. Standards IV, Table 5
- The six disability columns each hold 1 or 2. They hold 9 when the participant chose not to answer. Standards IV, Table 5
- GLUCTEST, GDM and RISKTEST record how prediabetes was determined, and stand on every session row. Standards IV, Evaluation Data Elements
- A participant may become pregnant, or be diagnosed with type 2 diabetes. Then all three hold 2. Standards IV, Evaluation Data Elements
The session answers
| Field | What it holds | Values | Source |
|---|---|---|---|
| DMODE | The delivery mode of that session. | 1 in person, 2 online, 3 distance learning. | Standards IV, Table 5 |
| SESSTYPE | A 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 |
| DATE | The 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 |
| WEIGHT | Pounds, to the nearest tenth. | 70 to 997. 999 when the weight cannot be reported. | Standards IV, Table 5 |
| PA | The 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
- Code every column correctly, with no invalid dates and no typos. Standards IV, Making Data Submissions
- A participant has one row for a session date. Standards IV, Evaluation Data Elements
- The one exception is a make-up session on the same date as a regular session. Standards IV, Evaluation Data Elements
- One module counts as one session, even when it took several dates or several logins. Report it once. Standards II.I
- Record one weight for a session date. Never estimate a weight with a formula. Standards Appendix F
- A self-reported weight is no more than one week old. Standards Appendix F
- An unusual weight may be flagged. Ask the participant to confirm it. Standards II.I
- A weight you cannot confirm becomes 999. Standards II.I and IV, Evaluation Data Elements
- Unusual activity minutes may be flagged too. Minutes you cannot confirm become 0. Standards II.I
- A make-up session on the same date as a regular session records the same weight. Standards II.J
- Record that day's activity minutes on one of the two sessions. Record 0 on the other. Standards II.J
- Only Lifestyle Coaches or other trained facilitators record weights and minutes for the CDC. Standards Appendix F
- A participant may join a group more than 14 days after its first session. Standards II.K
- Then the CDC asks that their cohort ID be their own participant ID. Standards II.K
After you submit
- A DPRP statistician reviews the file. Standards IV, What happens after the file is submitted
- The statistician may release a File Review Report with errors or items to confirm. Standards IV, What happens after the file is submitted
- The Program Coordinator, Secondary Contact and Data Preparer get an alert when it is ready. Standards IV, What happens after the file is submitted
- Make the corrections or confirm the items. Submit the file again if the report asks. Standards IV, What happens after the file is submitted
- Once every issue is answered, the CDC accepts the file. Standards IV, What happens after the file is submitted
- The CDC then makes a progress report or an evaluation report. Standards IV, What happens after the file is submitted
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
- Checks on a session lists what Lukio found. Lukio, Answer the checks
- A weight outside 70 to 997 pounds is a check. Table 5 accepts only that range. Lukio, Answer the checks, and Standards IV, Table 5
- A weight that changed fast since the last session is a check. Confirm it with the participant. Lukio, Answer the checks, and Standards II.I
- More activity minutes than a person could do is a check. Lukio, Answer the checks, and Standards II.I
- A person marked present with no weight is a check. Lukio, Answer the checks
- A person you could not weigh gets Could not weigh. Lukio files 999 for that weight. Lukio, Answer the checks, and Standards IV, Table 5
- A weight you cannot confirm also gets Could not weigh. Standards II.I
- Minutes the participant did not report go in the file as 0. Lukio, CDC file, and Standards IV, Table 5
- Click Accept only on a value you checked. An accepted value goes into the file. Lukio, Answer the checks
Common pitfalls
- One participant ID used for two people. Standards IV, Evaluation Data Elements
- An old participant ID reused for a person who enrolls again. They get a new ID. Standards IV, Evaluation Data Elements
- An ID built from a name, a birth date or a social security number. Standards IV, Evaluation Data Elements
- An ID of numbers alone over 10 digits, or one that looks like a date. Standards IV, Table 5
- A required answer left blank, such as age, sex, education or payer source. Standards IV, Table 5
- A file saved as CSV (Macintosh). Standards IV, Making Data Submissions
- A column renamed, respelled or moved. Standards IV, Making Data Submissions
- Records from the current due month in the file. Standards IV, Making Data Submissions
- A participant who came in the sequence, left out of the file. Standards IV, Making Data Submissions
- Two rows for one person on one date, when neither is a same-day make-up. Standards IV, Evaluation Data Elements
- A weight kept that nobody could confirm. It belongs in the file as 999. Standards II.I
- Activity minutes left blank. They belong in the file as 0. Standards IV, Table 5
- A session in months 1 to 6 coded CM because its module comes from later. Standards IV, Table 5
- A height left in feet and inches. Convert it to whole inches. Standards IV, Evaluation Data Elements
- Rows for a family member or friend who came along for support. Standards II.A
- A file submitted before it was checked. An accepted file cannot be submitted again. Standards IV, Making Data Submissions
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
Who can joinCan a participant stay in the program after a diabetes diagnosis or pregnancy?Who can joinWhat blood test results qualify someone for the National DPP?Who can joinWhat happens when a National DPP participant is diagnosed with type 2 diabetes?Who can joinWhat is the minimum age to join a National DPP lifestyle change program?Who can joinWho is eligible for the National DPP lifestyle change program?Enrollment and retentionCan someone join a National DPP class after it has started?
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?