Notifications
Clear all
Trading Post
5
Posts
3
Users
0
Reactions
84
Views
Topic starter
Does anyone know how is the patient visist diagnosis table related to the problems table?
Posted : March 11, 2013 3:48 am
I'm assuming you're talking about the integrated CPS platform.... A common element between the two tables is the PID (a unique patient identifier), linked in PatientProfile. However, the two tables aren't really related. PROBLEM lists active and inactive problems in a patient's chart whereas PatientVisitDiags lists diagnosis codes that have been attached to billed procedures (PatientVisitProcs which link to PatientVisit). You could very easily find diagnosis codes linked to a patient in one table but not in the other.
There are instances where the two tables might be used in the same report. For example, if I want to find out all procedures billed out for diabetic patients, I could use the PROBLEM table to find PID's where an active dx code is like ICD-250.xx and then evaluate all procedures billed for those PID's, regardless of the diagnosis code attached. This ensures I can catch procedures that may have been billed with dx codes other than diabetes.
Posted : March 11, 2013 5:02 am
Topic starter
I am trying to create a report to see if a patient has had a diagnosis done and not sure which table to use. i noticed that some diagnosis code appears in the patientvisitdiag table but not in the problem table and i was a little confused.
Thanks.
Posted : March 11, 2013 7:27 am
I had this very discussion with a doctor a couple weeks back, and he explained it as:
PROBLEMS are what needs to be monitored, tracked, reported.
DIAGNOSIS are what is handled during an office visit.
Perhaps best understood with a couple of examples:
Diabetes is something that should be on the PROBLEM list as it is long-term and will be followed, tracked, etc...
UTI (urinary tract infection) or Flu are both something that is episodic - at a moment in time. Both hopefully to be recovered from, and thus not important to be on the PROBLEM list.
Another distinction is related to billing. The Diagnosis is important for insurance to relate an issue and the procedure or work done by the doctor. A Problem may not be addressed at every visit, nor billed at every visit.
So, why you are trying to pull this information will point you to a specific data-table.
Posted : March 12, 2013 11:19 pm
lic08 said:
I am trying to create a report to see if a patient has had a diagnosis done and not sure which table to use. i noticed that some diagnosis code appears in the patientvisitdiag table but not in the problem table and i was a little confused.
Thanks.
If you're reporting on problems in a chart - active or inactive - you'll want to use PROBLEM. If you want to analyze diagnosis codes attached to procedures for which you billed (including office visits), you'll want to use PatientVisit, PatientVisitProcs, and PatientDiags. The first is clinical; the second is financial.
Posted : March 13, 2013 1:27 am
