This report shows the following information:
- Patient chart number
- First name
- Last name
- Referral date
- Provider to whom patient was referred
- Referral category/type
- Dx code(s)
- Referring provider
- Status of referral
A sample image of this SQL report run in the Database Viewer is shown below:
To highlight and copy the code below to your clipboard, simply click the Copy button.
select patno, fname, lname, loc_name, date1 as referral_date, refmd, refmdspecialty as category, dx, dx2, p_md as referring_provider, status from referalletter rl inner join register r on r.patno = rl.patno inner join location on location.id = r.loc_id where date1 between :Start_Date and :end_Date and custom1 = 'REFERRAL'