How to update OHIP Error Code 30 showing up on Invoice Reports

Share this

From Ian Pun – SQL script to clear the OHIP Error Code 30 showing up on INVOICE REPORTS for the Dec 1/2022 virtual visit (for OSPs):

ALTER TABLE `oscar_15`.`radetail` ADD `error_code_backup` char(2) NOT NULL DEFAULT '';

update radetail set error_code_backup = error_code where error_code = "30" and error_code_backup = ""  and (service_code = "K300A" or service_code="K301A")   ;
update radetail set error_code = "" where error_code_backup = "30";