Prior Authorization Report Error - Error: Table 'openemr.patient_status' doesn't exist - Advanced Prior Authorisations module

Day-to-Day Users
1

Patients > Prior Authorization Report yields the following error:

Prior Auths
SQL Statement failed on preparation: SELECT `ps`.`status` FROM `patient_status` ps WHERE `ps`.`pid` = ? ORDER BY `ps`.`statusId` DESC'
Query Error

ERROR: query failed: SELECT `ps`.`status` FROM `patient_status` ps WHERE `ps`.`pid` = ? ORDER BY `ps`.`statusId` DESC

Error: Table 'openemr.patient_status' doesn't exist

/var/www/localhost/htdocs/openemr/interface/modules/custom_modules/oe-module-prior-authorizations/src/Controller/AuthorizationService.php at 233:sqlQuery
/var/www/localhost/htdocs/openemr/interface/modules/custom_modules/oe-module-prior-authorizations/public/reports/list_report.php at 65:patientInactive(19)

image
image1045×546 23.7 KB

OpenEMR version: 7.0.2 (3)

Any ideas?

Thanks!