Working again on AMC audit to show data behind the dashboard in a report and we need
Provided Education Resource(s) what table is it stored in?
And this one? Thanks! I’ll turn over the audit code again when we get over these……
Provide patients with timely electronic access to their health information (including lab results, problem list, medication lists, medication allergies) within four business days of the information being available to the EP. ( AMC:170.304(g) )
It appears when the box is checked that a record is written to the amc_misc_data table.
The amc_id column will contain ‘patient_edu_amc’ and the map_category column will be “form_encounter”, indicating that the map_id column can be used to query the encounter column of the form_encounter table to retrieve the pertinent encounter row/record. The pid is available in either the amc_misc_data table or the matching row of the form_encounter table.