There are two potential approaches that come to mind, other CHUG users will certainly have other thoughts.
1. For VFE centric practices, there is a text file generated for each form listing the observation terms used. In a Coumadin form a wrote, ACG Coumadin v1.dlg, there is an associated file ACG Coumadin v1.txt. A partial listing of the file looks like the following:
--------------------------------------------------------
CLINICAL KIT: F:\ACG VFE Forms\JWF\ACG Coumadin v1.ckt
FORM NAME: ACG Coumadin
This form uses the following observation terms:
Short Name HDID Type Units Description
--------------- --------------- ----- ---------- ------------------------------------
A&P#1 31410 T Assessment & Plan #1
PROTIME DX 2400001 T anticoagulation treatment, indication for
COUMSTRTDTE 20783 T Coumadin start date
INR RANGE 1600002 T international normalized ratio (INR) range
DURATION 2876 T duration
COUM OTR MD 145183 T Other Provider, Coumadin
CARE LOC 18950 T location of care
CM ASSES CO 125850 T Coumadin assesment comments
WARFMDT COM 146647 T Warfarin med/diet comments
BP SYSTOLIC 54 N mmHg blood pressure, systolic - 8480-6
BP DIASTOLIC 53 N mmHg blood pressure, diastolic - 8462-4
PULSE RATE 56 N /min pulse rate E&M - 8867-4
BLEEDNGSIGNS 35453 T signs of bleeding
INR 309 N international normalized ratio (INR)
PROTIME 109753 N Protime
COUM TAB MG 4800008 T Coumadin tab strength
MONDAY DOSE 4800031 T Coumadin dose, Monday
TUESDAY DOSE 4800044 T Coumadin dose, Tuesday
WEDS. DOSE 4800050 T Coumadin dose, Wednesday
THURS. DOSE 4800043 T Coumadin dose, Thursday
FRIDAY DOSE 4800014 T Coumadin dose, Friday
SAT. DOSE 4800038 T Coumadin dose, Saturday
SUNDAY DOSE 4800039 T Coumadin dose, Sunday
COUM TOT WK 6679 T Coumadin, total dose for week
CCNEXTVISIT 80047 T Coumadin Clinic Next Visit Date
COUMADIN CHG 134600005 T Coumadin dose changes
CM INSTR CO 125851 T Coumadin instruction comments
DOCTOR RN1 16600022 T Coumadin, physician or nurse who ordered
WARF IND COM 88724 T Indication comments for Warfarin use
This form uses the following observation terms not included in your database:
This form uses the following flowsheet views:
Enterprise\ACG\Coumadin
This form uses the following problem custom lists:
.
.
.
.
.
---------------------------------------
All (!!!) you need to do, is parse each form associated .txt file. This is not impossible. The other option is cut and paste from the .txt file into spreadsheet, then sort and summarize.
2. You could also approach this from the document side. Each document is associated with an encounter. The forms for the encounter can be determined, and the obs terms for the encounter can be summarized from their associated document. This is potentially simpler, the down side being the obs terms doesn't identify the form within the encounter, and obs terms that are not used won't be listed.
Good luck, I'm interested in how you solve this problem.
[email protected]
Posted : April 30, 2015 6:26 am