kenyanprince wrote on Tuesday, March 22, 2016:
Am getting the following error while trying to generate a report
ERROR: query failed: SELECT po.patient_id, po.encounter_id, po.date_ordered, po.provider_id, pd.regdate, pd.sex, pd.DOB, pd.lname, pd.fname, pd.mname, pd.contrastart, pd.referral_source, pd.title, pd.pubpid, pd.ss, pd.drivers_license, pd.status, pd.genericname1, pd.street, pd.city, pd.state, pd.postal_code, pd.country_code, pd.mothersname, pd.guardiansname, pd.contact_relationship, pd.phone_contact, pd.phone_home, pd.phone_biz, pd.phone_cell, pd.providerID, pd.ref_providerID, pd.hipaa_message, pd.hipaa_mail, pd.hipaa_allowemail, pd.deceased_date, pd.deceased_reason, ps.abnormal, pc.procedure_name AS order_name, ptr.name AS result_name, ptr.related_code FROM procedure_order AS po JOIN form_encounter AS fe ON fe.pid = po.patient_id AND fe.encounter = po.encounter_id JOIN patient_data AS pd ON pd.pid = po.patient_id JOIN procedure_order_code AS pc ON pc.procedure_order_id = po.procedure_order_id JOIN procedure_report AS pr ON pr.procedure_order_id = po.procedure_order_id AND pr.procedure_order_seq = pc.procedure_order_seq AND pr.date_report IS NOT NULL JOIN procedure_result AS ps ON ps.procedure_report_id = pr.procedure_report_id AND ps.result_status = ‘final’ JOIN procedure_type AS ptr ON ptr.lab_id = po.lab_id AND ptr.procedure_code = ps.result_code AND ptr.procedure_type LIKE ‘res%’ WHERE po.date_ordered IS NOT NULL AND po.date_ordered >= ‘2015-03-01’ AND po.date_ordered <= ‘2016-03-22’ ORDER BY fe.pid, fe.encounter, ps.result_code
Error: Unknown column ‘pd.contrastart’ in ‘field list’
C:\xampp\htdocs\emr\interface\orders\procedure_stats.php at 420:sqlStatement