Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

how is patient visit diagnosis and problems table related?

Trading Post

Last Post by Mitch Kwiatkowski 12 years ago

5 Posts

3 Users

0 Reactions

62 Views

RSS

lic08

(@lic08)

Posts: 286

Reputable Member

Topic starter

Does anyone know how is the patient visist diagnosis table related to the problems table?

Posted : March 11, 2013 3:48 am

Mitch Kwiatkowski

(@mitch)

Posts: 111

Estimable Member

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

lic08

(@lic08)

Posts: 286

Reputable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

Mitch Kwiatkowski

(@mitch)

Posts: 111

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0