This report will show patients who have accessed the portal. The list is displayed based on parent and displays the patient name, parent name, patient number, and email address. If one parent has multiple children, the report will show one line for the family based on parent name.
A sample image of this SQL report run in the Database Viewer is shown below:
- This will list a parent with multiple children ONE TIME. For example, if a parent has three children, the parent will only be listed once.
- Results include all parents who have ever accessed the portal regardless of date (even if it was once 5 years ago). This includes patients who are no longer active.
To highlight and copy the code below to your clipboard, simply click the Copy button.
select distinct * from ( select first_name, last_name, email_addr from register inner join register_contact on register.patno = register_contact.patno inner join contact on contact.id =register_contact.contact_id left outer join web_user on web_user.contact_id = register_contact.contact_id where patno is not null and REGSTRTN_IND = 1)