Notifications
Clear all
Topic starter
We would like to add functionality to our EMR to post a reminder if a patient's consent to treat and release of information info is incomplete. We have a Crystal Report that tracks this but would like to also put the status in the EMR.
In Crystal the table is 'Patient Profile' and the 2 fields are
'ReleaseOfInformationIndicatorDate'
'PrivacyPolicyAcknowledgementDate'
In the EMR this information is entered on Registration's 'Additional' tab, within the Authorization section. The test patient had all fields in the Authorization section filled out but no data was returned.
Here's the code I tried to see if I could get any information back. Since the getRowCount() returned nRows of 70,000+ I reset the nRows to 1 just to test the first row's data.
fn TEST_ConsentStatus()
{
local sData
local i
local nRows = getRowCount("_PatientConsent")
nRows = 1
for i =1, i <= nRows, i = i + 1 do
sData = getRow("_PatientConsent",i,"PID","PatientConsent","ConsentRecordedby","ConsentRecordedTime")
endfor
}
Thanks.
Joan Nordberg
Programmer/Analyst
Boston Health Care for the Homeless Program
Posted : October 29, 2012 11:34 pm
