Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Crystal Report- OVs signed within 48 hours

Trading Post

Last Post by Anonymous 1 second ago

9 Posts

5 Users

0 Reactions

68 Views

RSS

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

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.

[email protected]

Posted : October 23, 2015 8:49 am

betsyh

(@betsyh)

Posts: 17

Eminent Member

We would be interested in this as well!

Thanks,

Betsy

Posted : October 23, 2015 10:07 am

mfornkahl

(@mfornkahl)

Posts: 132

Estimable Member

I would like this as well!.

Posted : October 23, 2015 10:24 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

CPS or Oracle?

Posted : October 26, 2015 2:08 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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.

PPP_120_OV_data

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

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

We have 9.8, Oracle

Posted : October 26, 2015 2:14 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thank you very much for sharing this, I will check it out

Posted : October 26, 2015 2:14 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

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

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thank you Jim!

Posted : October 26, 2015 6:49 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0