Personal tools
 

rejected claim patients V2

Update - I improved my SQL with a clickable link now directly to the billing claim itself --- Ian PUN MD ---As you know, correcting error code report (version codes rejection etc ) is quite tedious in OSCAR, The error report generated is not useful. You just get a bunch of OHIP numbers and you have to manually go to the patient's chart (retyping and searching OHIP numbers ) to correct the OHIP claim. I wrote this this SQL Query by Example query (Paste it in ADMIN -> Query by Example box and click QUERY). It will generate a clickable list of your rejected claim patients. Unfortunately, I can't spoof it to click to the BILLING CORRECTION screen.

Plain Text icon Rejected Claim Patients V2.txt — Plain Text, 1 kB (1077 bytes)

File contents

SELECT distinct  concat (" ", dm.chart_no , "
<\"../demographic/demographiccontrol.jsp?keyword=",dm.chart_no,"&orderby=last_name%2+first_name&dboperation=search_titlename&limit1=0&limit2=10&displaymode=Search&ptstatus=active&displaymode=Search&search_mode=search_chart_no\"> 
") as "Chart#" , 
concat (" ", be.billing_no , "
<\"../billing/CA/ON/billingCorrection.jsp?billing_no=",be.billing_no,"&orderby=last_name\"> 
") as "inv#" , 
substring(bh.comment1, 1,10) as corrected,
 substring(concat(dm.last_name, " , ", dm.first_name), 1 , 25)  as Name,
be.hin , be.ver as oldVC, dm.ver as CurVC  , 
be.code as Bill, be.code_date as BillDate, be.claim_error as Err  ,
be.code_error as CErr ,  bec.description as ErrorDesc
FROM
   billing_on_eareport  be   , billing_on_cheader1    bh   , demographic  dm 
, billing_on_errorCode   bec 
WHERE
   be.billing_no    =  bh.id  and  dm.demographic_no = bh.demographic_no 
and (be.claim_error = bec.code or be.code_error = bec.code) and (
be.code_error <> "" or be.claim_error <> ""  )
ORDER BY
   be.code_date DESC;

Document Actions

 

Download button

DOWNLOAD OSCAR FOR TESTING

 

eForms button

DOWNLOAD SHARED E-FORMS


 Customize button

FIND PLUG-INS AND TWEAKS
FOR YOUR OSCAR EMR

 

Subscribe Button

SUBSCRIBE TO DISCUSSION LIST 
(SEE ALL LISTS)

  

Help button

ACCESS THE ONLINE MANUALS
(PAID SUPPORT)