Latest program files & User Guides available here...

CDEMS Programs
* CDEMS for 2009 WA Patient-Centered Medical Home Collaborative
CDEMS+SQL Files
CDEMS Documentation
Electronic Lab Interfaces

Special Versions - Shared Programs (registry customizations shared by other users)

To receive notification of CDEMS updates, click add me to the CDEMS list (e-mail: jackie@cdems.com). Simply use "CDEMS e-mail List" as the subject line and include your name, e-mail address and clinic name/location in the message. You'll be the first to know what's happening with these programs!



CDEMS PROGRAMS

Save the CDEMS program files corresponding to your version of Microsoft Access* to a CDEMS folder on your computer. Double-click on each file in the list below. Save each file to the CDEMS folder on your computer or server. After the compressed files are downloaded, double-click on each saved file > Extract > Self-Extract > Execute to uncompress. Double-click the uncompressed data entry program file (cdem_DataEntry_6-7-10) to begin using CDEMS. The Data Entry User Guide provides more detailed instructions for downloading files, initial setup, and customizing CDEMS. While you're downloading programs, scroll to the Documentation section below to pick up this handy guide.

CAUTION! Existing users should NOT download a new cdem_dta file; installing a new data file will overwrite your current data! Re-install or upgrade only the Data Entry and Reports program files.

Access 2000/02/03 Files zzzz Access 97 Files
(MAROON Access "Key") zzzz (YELLOW Access "Key")
zzzz
Access 2007 Files

* Program files must correspond to your version of Microsoft Access -- check your version by clicking Start > Programs from your computer desktop. Find Microsoft Access in the program list and note the color of the Access icon "Key". A maroon key = Access 2000/02/03; a yellow key = Access 97. Access-2007 also has a maroon icon key. Access-2007 requires the 2007 version of the Data Entry program but is compatible with 2k versions of the data file and Reports program.

** Data Entry v.6-7-10 contains a customized Asthma progress note (2A) summarizing # of visits in the last 12 mos, steroid bursts in the last 12 mos, and max peak flow recorded ever. The form also displays a short list of health education topics related to asthma. This program version is a minor update to the 10-12-09 Data Entry program and includes only a progress note customization of interest to those tracking asthma patients. If not tracking asthma, there is no reason to upgrade from the 10-12-09 Data Entry program.

*** Reports v.7-30-10 contains a minor patch to repair the formatting of averages in summary reports created through the Create-a-Report template in Access 2007 & 2010 versions of the program only.

**** The cdem_dta file was updated on 6-9-2010 to include the measurement setup for Asthma used in the 2008 WA State Collaborative and matching NHLBI 2007 asthma guidelines. New registry installations will automatically have access to the asthma setup, as well as adult preventive health, diabetes, and cardiovascular. Once installed, any of the pre-defined measures can be adapted to fit your program. Registry users wishing to add asthma measures to an existing data file should copy the setup; NEVER DOWNLOAD A NEW DATA FILE. Click Asthma SetUp for the Excel file with asthma measures and instructions for appending to an existing registry.


TIPS FOR RESOLVING NEW VERSION ISSUES...

  • If your system prevents CDEMS program files from opening the first time, right-click on the file name in your CDEMS folder > Properties > click "Unblock" in the Security area to jumpstart the program.

  • If your firewall blocks .EXE files, please e-mail Jackie (jackie@cdems.com) to receive the uncompressed files on a CD.

  • If your data file is located somewhere different than the CDEMS program files, the new program on first opening must be pointed to the location of the cdem_dta.mdb file on another computer or server. Or, from the Data Entry or Reports opening window, click on Tools > Database Utilities > Linked Table Manager. Place a checkmark in "Always prompt for new location" box > click "Select All" > Press OK and navigate to location of cdem_dta file.

  • If encountering unexpected errors on opening the new Data Entry program, check out possible reference issues due to differences in versions of Microsoft Access:
    1. From the Data Entry program, verify references by pressing the F11 function key > click on Modules > New
    2. Click Tools in the menu bar > References. Look for a "missing" reference in the list (likely a Microsoft Graph Object Library reference) > uncheck the missing reference
    3. Scroll down the list and select the matching Graph Object Library version available on your computer (likely Microsoft Graph 9.0, 10.0, or 11.0 Object Library).
    4. Click on "X" in upper right corner to close the module > Save with the default module name when prompted.
    5. Close program and re-open
Return to top of page



CDEMS FOR 2009 WA PATIENT-CENTERED MEDICAL HOME COLLABORATIVE

 To begin a NEW registry for the Collaborative, begin by downloading the CDEMS Data Entry program and the Medical Home data file below.

STEP #1 - Decide where to install CDEMS (single computer or network server). Create a CDEMS folder on that computer.
STEP #2 - Scroll up to the "Programs" section and select the CDEMS Data Entry file that matches your version of Microsoft Access (2k or Access-07). Double-click on the file; save to the CDEMS folder on your computer.
STEP #3 - If you are installing CDEMS for the first time, double-click on the Medical Home data file below; save to the CDEMS folder on your computer.
cdem_MHome_dta
data file with 2009 Medical Home measures

CAUTION! Existing users should NOT download a new cdem_dta file; installing a new data file will overwrite your current data! 2009 Medical Home measures can easily be added through the Setup Wizard or copied and appended to an existing registry from the Crosswalk and Setup tables in the Excel Setup file below.

2009 Medical Home Excel SetUp
Medical Home measures to append to an existing registry
STEP #4 - After downloading, locate the zipped files in your CDEMS folder; double-click on each file > Extract > Self-Extract > Execute to unzip. Double-click the unzipped Data Entry file to begin using CDEMS. You may need to point or relink the program to the location of the data file. The Data Entry User Guide provides detailed instructions for downloading files, linking to the data file, initial setup, and customizing CDEMS. While you're downloading programs, scroll to the Documentation section below and pick up this valuable guide.

STEP #5 - Download the CDEMS PCMH Reports program (v. 11-16-09). The program contains special queries and templates for producing PCMH adult prevention and pediatric wellness reports as well as the monthly IPIP diabetes report. Double-click on the reports file below and save to the CDEMS folder on your computer. Double-click on the zipped reports file in your CDEMS folder > Extract > Self-Extract > Execute to unzip. Double-click the unzipped rpts2k_PCMH_111609 file to begin using. You may need to point or relink the program to the location of the data file. The CDEMS PCMH Reports Guide provides detailed instructions for producing PCMH and IPIP reports.

rpt2k_PCMH_11-16-09
reports program with customized PCMH queries & templates; 2k version works with Windows 2000-2002-2003-2007. Link to your data file and use simultaneously with other CDEMS Reports programs.

CDEMS PCMH Reports Guide
PCMH Report guide with detailed instructions for PCMH/IPIP reporting and troubleshooting.

2009 Medical Home Abstraction Form & Instructions (v.11-16-09)
Return to top of page



CDEMS+SQL

CDEMS+SQL looks and acts just like native CDEMS. The main difference is that the data stored in the MSAccess cdem_dta.mdb file is now stored in a SQL Server database. Below are the files needed to install the SQL version of CDEMS; refer to the CDEMS+SQL Guide for complete instructions.

  • CDEMS+SQL Guide
  • CDEMS+SQL Files*
    zipped file with SQL version of CDEMS Data Entry & Reports programs (versions for Access 2003 and earlier) and script file for creating SQL server tables
* Important Considerations:

  1. The SQL Data Entry program works with Microsoft Access 2003 and earlier. Code changes required to produce CDEMS graphs when using MS-Access 2007/2010 have not been made in the CDEMS+SQL Data Entry program.

  2. The CDEMS+SQL programs have been available since 2005. While the SQL versions of the CDEMS Data Entry and Reports programs are fully functional, neither program has up-to-date features and improvements made since 2005.

  3. It's expected that your organization has internal capability to manage technical issues and maintenance of the SQL database. Technical support for CDEMS+SQL is strictly fee-for-service, 1 hr minimum.

Return to top of page




CDEMS DOCUMENTATION

The CDEMS User Guide is available in four sections to minimize file size and download time. If you're new to CDEMS, the first section provides a great overview of the program and step-by-step instructions for getting started. Here's how to download the Guide:

  1. Click the desired Guide section(s) to download into your CDEMS folder
  2. SAVE the file to your CDEMS folder
  3. When download is complete, double-click on the saved file (a Quarterdeck Zip-It window appears > click Extract Files > Self Extract > Execute > Close)
  4. Double-click the extracted file to open the document.
  • CDEMS Data Entry Guide (v.1009) (49 p.)
    Program overview, technical requirements,installation and startup instructions, customizations & data entry/edit/print functions...
  • CDEMS Reports Guide (v.0409) (25 p.)
    Detailed instructions for running and creating reports to analyze CDEMS data. Includes instructions for developing user-defined summaries with the Create-a-Report template and user-defined intervention lists with Create-a-List template. Instructions for using advanced filters and reports functions in the 4-9-09 Reports release are provided in this guide. Also contains a list of pre-defined reports and CDEMS table descriptions.
  • CDEMS Electronic Lab Interface Guide (13 p.)
    Lab interface overview, setup instructions, testing, maintenance, troubleshooting tips...
  • Appendix (27 p.)
    Sample progress note & graph styles, CDEMS maintenance, table descriptions, frequently asked questions...
  • PowerTools Guide (5 p.)
    A short instructional guide for using PowerTool programs: GROUPER for aggregating data files to run reports across multiple sites and LOGGER for monitoring who's currently accessing the CDEMS data file.
Other resource documents:

Return to top of page



ELECTRONIC LAB INTERFACE PROGRAMS

Lab interface downloads require setting up an account with your lab company, complete with password and installation of appropriate software for receiving lab results electronically. Lab codes must also be entered into CDEMS tlkpCrosswalk before the lab interface is functional. Please refer to the CDEMS User Guide [Electronic Lab Interface section] for detailed instructions, or e-mail Jackie (jackie@cdems.com) for additional personalized assistance.

Note to non-WA users: Assistance with lab interface implementations or troubleshooting is a fee-based service provided by Jackie Gianunzio, CDEMS Technical Support Consultant. For more information, please visit www.support.cdems.com or call 916-817-1401.

  1. HL7 Generic

    * HL7 - Cdems 2k
    * HL7 - Cdems 2007

    HL7 is a generic interface that processes any HL7-formatted lab file. The 2k version works with Access-2003 and earlier; the 2007 version with Access-2007. Place the HL7 interface WITHIN the lab results folder and relink to your CDEMS data file.

    The calculation of eGFR (Glomerular Filtration Rate) is embedded in this interface, based on serum creatinine results reported in the lab file. Entries for "eGFR" lab in CDEMS tlkpCrosswalk and tlkpSetup must be present for this calculation. Additionally, patient's date of birth, gender and ethnicity must be recorded in CDEMS or eGFR is recorded as "UTD" (unable to determine). Since ethnicity is a key factor in this calculation, African American ethnicity must be recorded as "Black" or the appropriate interface code modification made to handle other ethnicity names.

  2. Dynacare - Cdems 2k
  3. Dynacare - Cdems 97
  4. Labcorp - Cdems 2k
  5. Labcorp - Cdems 97
  6. PAML - Cdems 2k
  7. PAML - Cdems 97
  8. Quest - Cdems2k Unix v.1006
  9. Quest - Cdems97 Unix v.1006

Return to top of page



SPECIAL VERSIONS

Customized versions of CDEMS programs may be downloaded here. These specialized adaptations shared by other CDEMS users are provided without documentation. It's possible to review the measurement set or modify a shared form, for example, to use as a building block in the development of a new chronic condition track. Basically these programs are available "AS IS" and must be explored on your own though very general guidance may be available by e-mail (jackie@cdems.com).

Download Instructions: Double-click on each file you wish to download > save to your CDEMS folder. After the compressed files are downloaded, double-click on each file > click Extract > Self-Extract > Execute to uncompress. Double-click the uncompressed data entry program file to begin using.

CAUTION! Do NOT download a data file into the same CDEMS folder if you have an existing CDEMS registry. Doing so will overwrite the existing cdem_dta.mdb file and wipe out your data.

DEMS to CDEMS Conversion tool

Use the DEMS to CDEMS conversion program to upgrade your DEMS data file to the CDEMS format. Create a CDEMS folder on your computer and download a new CDEMS data file from this web site into the CDEMS folder. Place a copy of the DEMS data file into the same folder. Run the conversion tool to export DEMS data into the new CDEMS format. The DEMS data is not changed during the conversion process. Begin using the CDEMS Data Entry and Reports programs linked to the CDEMS data file. DEMS to CDEMS conversion tool

PECS to CDEMS Conversion tool

The PECS Conversion tool, developed by the West Virginia University Office of Health Services Research, provides a step-by-step mechanism for remapping exported PECS data into CDEMS format. This works for either a regular export or an anonymous export. Here's the link to download the tool, a blank data file, and detailed instructions: www.wvuohsr.org/downloads.htm


CDEMS - CA Safety Net Institute "SEED" Project

  • CDEMS-2k Data Entry program
    This is the standard CDEMS data entry program placed here for your convenience in downloading all CDEMS files from one location. There are no customizations in this program for the SEED project.
  • CDEMS-2k SEED Reports program
    The SEED reports (v.2-15-08) contains an updated monthly SEED summary report template for Diabetes and special queries needed to report on SEED measures. Cardiovascular prevention queries and a new query to count pneumonia vaccine regardless of age and time period are updated in the 2-15-08 version . A list query showing service referrals made/completed was added to the program. In addition, the Create-a-Report template features an option to generate user-defined summaries by insurance payer.
  • CDEMS SEED Data file
    This data file contains the customized measurement setup for the SEED project. CAUTION: DO NOT DOWNLOAD THIS FILE IF YOUR REGISTRY IS ALREADY STARTED. Installing this file will overwrite any already existing cdem_dta.mdb file and wipe out your data!

CDEMS - ADHD


CDEMS - HIV

  • CDEMS-2k HIV Data Entry program
    This file contains the CDEMS data entry program with customized HIV progress note forms and graphs.
  • CDEMS-2k HIV Reports program
    This folder contains an adaptation of the 7-14-04 CDEMS reports program with queries for correlating adherence education with antiviral adherence rates.
  • CDEMS-2k HIV Data file
    The HIV data file contains the customized HIV setup with 3 sample patients.

CDEMS FOR 2008 WA STATE COLLABORATIVE

Below are data files and Excel Setup files for the Asthma, Diabetes, Hypertension and Medical Home tracks for the 2008 WA State Collaborative. Scroll a little further for the pediatric obesity files and BMI percentile charts. Below that, you'll find cheat sheets and a Reports program with special queries that meet 2008 WA State Collaborative reporting requirements.

Data Files for all Access versions zzzz Excel Files (optional)
zzzz

Pediatric Obesity Files
The 10-7-08 Reports program contains special queries to report on 2008 WA State Collaborative Diabetes, Asthma, Hypertension, Medical Home and Pediatric Obesity measures.

Cheatsheets for 2008 WA State Collaborative Tracks:
Return to top of page