About

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

Depending on how you document Nexplanon:

• The date may be the date when the patient informed about it
• The date may be the date when you ordered it from the pharmacy
• The date may be the date when you placed it 

So, your resulting workflow is going to differ.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

Copy

select patno, date1, prescrib, purpose from medications
inner join register on register.patno = medications.patno
where prescrib like '%Nexp%' and ongoingmed = 'Y' and status_pat = 'ACTIVE'
order by date1