Notifications
Clear all
Topic starter
I need to add the last appointment date and provider to the superbill. I noticed that the last appointment date is included in the sb1001 file but I have not found the last appointment provider. Does anyone have suggested code to pull the last appointment provider to the superbill?
Thanks in advance!!
Posted : February 26, 2021 8:27 am
OK, here is a description of possible steps.
Add a Subreport to the superbill, based on PERSON.PID
Link to the APPOINTMENT table
Build a formula variable, call it LstArrvRes (last arrived resource), and create as
date of arrived date stored as YYYYMMDD and link from the APPOINTMENT file to USERINFO file so that after the YYYYMMDD you can put a "_" to separate and then the resource name. Example being 20210113_Joe Smith MD
Then summarize to the max of all the arrived entries.
You could print that as is, not necessarily pretty. Or you could cut the max of that field starting at position 10 so you print Joe Smith MD
Posted : March 3, 2021 2:21 am
Topic starter
Thanks - I will look into that!!
Posted : March 3, 2021 4:50 am
