Notifications
Clear all
Topic starter
How do I identify the document that link to the appointment?
Which field can I link the appointment table and the document table?
Posted : June 22, 2016 10:41 am
The two tables do not link very cleanly.
If you have "Auto-create documents" based off of appointment type, then you can link document.sdid = appointment.docid
We use comparisons based off appointmentdates and clinicialdates, doctors & publishinguser, and doctypes of officevisit.
This works for us, but you have to keep an eye out for duplicates and missing links....
-James
Posted : June 22, 2016 11:00 am
Topic starter
Thank you, James!
For some reason, the appointment.docid in our database are most NULL. Not sure why!
Posted : June 22, 2016 11:07 am
It is a significant hassle. Link on PID, document date.
Posted : June 22, 2016 1:54 pm
You can also link on VISITID if you are putting that value from the appointment in your documents.
Posted : June 23, 2016 5:51 am
Many clinics do not have these mapped. As others have said, you can manually link based on patient pid and the date-of-service. That is what I have had to do in several instances.
Posted : June 27, 2016 4:04 am
