Notifications
Clear all
Topic starter
Before I create this report I wanted to check to see if someone else has...
Denominator= All office visits, any status, by provider, in a certain time frame
Numerator= Same, except signed within 48 hours
Or anything close would be fine, thanks.
Posted : October 23, 2015 8:49 am
We would be interested in this as well!
Thanks,
Betsy
Posted : October 23, 2015 10:07 am
I would like this as well!.
Posted : October 23, 2015 10:24 am
CPS or Oracle?
Posted : October 26, 2015 2:08 am
Here is a report that I run monthly, as part of a process that creates a monthly dashboard. It looks at all office visits in the past 12 months, and creates a summary for 28 days and that full year.
Some modifications to consider.
in Record Selection Formula, the 3 bold lines below may need adjustment:
{PERSON.PSTATUS} = "A" and
{PERSON.ISPATIENT} = "Y" and
{PERSON.SEARCHNAME} < "ZZZ" and
not (LowerCase({PERSON.LASTNAME}) like ["test","testing","logician"]) and
{LOCREG.ABBREVNAME} in ["GMA","PDC"] and
instr({USRINFO.LASTNAME},"PCP not in GMA")=0 and
instr({USRINFO.LASTNAME},"TERMINATED")=0 and
{@aDocDate} >= dateadd("m",-12,currentdate) and
{USRINFO.STATUS} = "A" and
{DOCCONTB.CONTB_ACTION} in [0.00, 2.00, 7.00] and
{DOCTYPES.ABBR} in ["Ofc Visit", "Ofc Visit2"]
Would suggest you try to run before editing, so you can get a good idea of its operation. I output to Excel data only, and the columns are:
Provider Name (you may clean up the logic I used here)
NPI #, that lets me link multiple spreadsheet files together
Floor (you may change/remove this)
Documents signed for the past 28 days Office visits.
Documents signed within 2 days, of past 28 day office visits
Documents that are office visits in past 28 days
Documents signed for the past year Office visits.
Documents signed within 2 days, of past year office visits
Documents that are office visits in past year
[Note that columns 4-5-6 and 7-8-9 follow similar logic; just whether it looks back at past 4 weeks or 52 weeks.]
Finally, I run this on Sundays, when I assume little or no activity.
Posted : October 26, 2015 2:09 am
Topic starter
We have 9.8, Oracle
Posted : October 26, 2015 2:14 am
Topic starter
Thank you very much for sharing this, I will check it out
Posted : October 26, 2015 2:14 am
Here are three Oracle reports:
OVs; All Documents Active; All Documents All status
CHUG_OVs_OnHoldActive_PickPractice CHUG_AllDocuments_OnHoldActive CHUG_AllDocuments_AllStatus
Note that they don't have a whole lot of parameter prompts (such as for document type, signature status) but those can easily be included.
Posted : October 26, 2015 4:33 am
Topic starter
Thank you Jim!
Posted : October 26, 2015 6:49 am
