I'm looking at well child visits -- and have had no trouble finding the CPTs and ICD-9s for the visit. Sometimes a child is seen by the provider only, sometimes we have a child and family specialist that sees the child as part of the team. Her notes are documented in the regular set of forms, and appear in text translation. I've looked at the patientvisit and documents records for a visit where the child family specialist charted and signed, but the provider's UserID is the only one that seems to be stored on the record.
Is there any way to identify all the UserIDs that signed a form?
Barring that, can someone point me to where the text for the chart updates are stored. I saw the DOCTEXT field on the Document table but it's empty most of the time.
Thanks,
Brad Smith
11th Street Family Health Services
Philadelphia, PA
DOCCONTB table should have that information. It's connected by SDID. They use numbers in the CONTB_ACTION column to signify what was done:
6 = Initial signature
7 = Final signature
8 = Additional signature
Thanks very much.
Brad