I have a project in which we are adding documents and valuing obsterms on upwards of 15,000 patients. I want to do this all via SQL and have it 99% of the way there. Was hoping someone might be able to help with some quirks I'm seeing.
- I am inserting a row into the Documents table for each patient. Then as expected I am able to see the Document in the patients chart. However, if I click the "Full Document Viewer" it doesn't display the Patient Name, Properties, or DOC ID.
Is anyone familiar with documents in the DB enough to know what could cause this? Any thoughts are welcome.
What interface engine do you have? We do things like this with HL7 in our Qvera engine rather than directly manipulating the database and losing any kind of audit trail.