Notifications
Clear all
Topic starter
I believe the tables are different in CPS, and these are recorded better. However, for the EMR product, has anyone been able to figure out how to track key times in a patient interaction?
Appt Time (in APPT table)
Arrival Time (use DBUPDATED in APPT table, when APPTSTATUS =3)
Now, linking APPT and DOCUMENT gets tricky since this is not done with simply the EMR product. I have found that I must match the DOCUMENT's date to the APPT's date manually. Problem #1, but seems to be possible to work-around.
MA starts with patient ?(can use DOCCONTB table, to determine when visit note is started as CONTB_ACTION=0) Can also use the DOCUMENT file, and the DBCREATED field.
Doctor begins with patient. Stumped. Thought about when CONTB_ACTION=2 and the user is a doctor. However, it seems the time written is the last time - thus a doctor who may edit it twice will have only the 2nd time recorded. And this is problem #2.
So, any ideas on how to solve this, or use different tables and/or changing some system settings?
Thanks.
Posted : October 24, 2014 8:30 am
I am very interested as well in what queries can be used to track patient times/physician times through the visit.
Does anyone do tracking based on storing date timestamps or minutes of face-time into obsterms throughout the visit ?
- Beverly
Just FYI - I was looking at obsterms to do this, here is a list of what I found so far:
CHECKINTIME - patient arrival time
ARRIVALSTATS - patient arrival status, late or on time
PTINRMTIME - patient in room Time
TIME IN EXRM - Time patient is taken to exam room
MDSTARTTIME - Start Time physician patient face to face time
MDENDTIME - End Time physician patient face to face time
TIME_SPENT - Time in min(s) physician spent with patient - used for CMS level of ofc visit eligibility
TIME OUT FD - time patient checks out with front desk
and then there are
TM VISIT #1 - clinic visit event#1, exact time of day in hr:min
thru
TM VISIT #20 - ditto
W/CVISITTYPE - Worker's Compensation, visit time (initial, followup, etc.)
Posted : October 27, 2014 7:31 am
Joeg1962,
We too have been struggling with this and have yet to find an automated way to address it. The best we could come up, with was to use appointment statuses:
- Signed In - 1st Impressions
- Front Desk – In Progress
- Web Portal In Progress
- Web Portal Complete
- Ready for Triage
- Arrived
- Roomed
- Checked-out
This can give us times between each portion of the patients visit with the exception of how long they wait for the physician in the exam room, and how long the physician spends with them (key pieces of information). The other problem with this process is that it is a very manual so it’s not the most reliable.
I would love to hear how others are tackling this.
Posted : October 30, 2014 5:58 am
