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 (note: import tool is optional and used only if converting from DEMS to CDEMS). Save each file to the CDEMS folder. After the compressed files are downloaded, double-click on each file > Extract > Self-Extract > Execute to uncompress. Double-click the uncompressed data entry program file (cdem_10-1-09) 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/or Reports programs.
| Access 2000/02/03 Files
| zzzz
| Access 97 Files
|
| (MAROON Access "Key")
| zzzz
| (YELLOW Access "Key") |
|
zzzz
|
|
* 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.10-12-09 contains new "pick list" functionality allowing user definition of dropdown result options (e.g. "current", "past", "never" for smoke assessment results) or validation checks (e.g. numeric results only or values within a defined range) for services and labs. This functionality improves accuracy and consistency of service and lab results as they are entered through the Data Entry screen. Click Pick List Quick Guide for instructions to define your pick list & validation parameters -- these are also included in an updated version of the Data Entry Guide (10/09).
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:
-
From the Data Entry program, verify references by pressing the F11 function key > click on Modules > New
- 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
- 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).
- Click on "X" in upper right corner to close the module > Save with the default module name when prompted.
- 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)
STEP #6 - CDEMS-PCMH Reports Webinar - Dec. 9, 2009 (w) 11-noon
Learn how to analyze PCMH adult and pediatric measures and produce IPIP diabetes reports! To register for the webinar, email jackie@cdems.com -- a meeting link and teleconference call-in number will be provided upon registration.
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. Technical support for CDEMS+SQL is not offered. While the basic CDEMS SQL program files are provided, your organization must have the technical capability to manage the SQL database. Below are the files needed to install the SQL version of CDEMS; refer to the CDEMS+SQL Guide for complete instructions:
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:
- Click the desired Guide section(s) to download into your CDEMS folder
- SAVE the file to your CDEMS folder
- When download is complete, double-click on the saved file (a Quarterdeck Zip-It window appears > click Extract Files > Self Extract > Execute > Close)
- 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.
- 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.
- Dynacare - Cdems 2k
- Dynacare - Cdems 97
- Labcorp - Cdems 2k
- Labcorp - Cdems 97
- PAML - Cdems 2k
- PAML - Cdems 97
- Quest - Cdems2k Unix v.1006
- 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
|
|
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