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

Report Help

General Discussion

Last Post by aboyer 7 years ago

4 Posts

4 Users

0 Reactions

66 Views

RSS

C J Torontow

(@cjtorontow)

Posts: 45

Trusted Member

Topic starter

Does anyone have a report that will show unsigned documents by user desktop?

Posted : December 13, 2013 7:11 am

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

I am looking for the same type of report. It needs to have in progress, un signed, signed and on-hold. My initial attempt queried the document table, but the numbers were way from what is displayed via the desktop.

SELECT

DoctorFacility.ListName AS Resource_Name,ISNULL(JOBTITLE.DESCRIPTION,'')AS Job_Description,

CASE DoctorFacility.Inactive WHEN 0 THEN'N'WHEN 1 THEN'Y'ENDAS Inactive,

CASE DoctorFacility.IsEmrUser WHEN 0 THEN'N'WHEN 1 THEN'Y'ENDAS ChartAccess,

CASE DoctorFacility.IsBillingEntity WHEN 0 THEN'N'WHEN 1 THEN'Y'ENDAS Billable,

CASE DoctorFacility.IsScheduleAssign WHEN 0 THEN'N'WHEN 1 THEN'Y'ENDAS Schedulable, USR.LAST_LOGIN_DATE,

(SELECTCOUNT(USRID)AS Expr1

FROM [DOCUMENT] AS d

WHERE (USRID = DoctorFacility.PVID)AND(STATUS='A')and CHANGE = 2)AS InProgress_Docs,

(SELECTCOUNT(USRID)AS Expr1

FROM [DOCUMENT] AS d

WHERE (USRID = DoctorFacility.PVID)AND(STATUS='U')and CHANGE = 2)AS Unsigned_Docs,

(SELECTCOUNT(USRID)AS Expr1

FROM [DOCUMENT] AS d

WHERE (USRID = DoctorFacility.PVID)AND(STATUS='H')and CHANGE = 2)AS OnHold_Docs,

(SELECTCOUNT(USRID)AS Expr1

FROM [DOCUMENT] AS d

WHERE (PUBUSER = doctorfacility.PVID)AND(STATUS='S'))AS Signed_Docs, USR.LASTNAME

FROM

DoctorFacility INNERJOIn

USR

ON DoctorFacility.PVId = USR.PVID LEFTOUTERJOIN

JOBTITLE

ON USR.JOBTITLE = JOBTITLE.JTId

WHERE

(USR.LAST_LOGIN_DATE <DATEADD(MM,- 2,'1/1/2014'))AND(DoctorFacility.IsEmrUser = 1)AND(DoctorFacility.LastISNOTNULL)AND

(DoctorFacility.LastNOTIN('Clinic','Box','Test','Kryptiq','DTS','LinkLogic'))AND(DoctorFacility.Inactive = 0)AND(DoctorFacility.Last='Leeder')

ORDER

BY DoctorFacility.Last, USR.LAST_LOGIN_DATE DESC

The query returns 0 - In progress, 0- Unsigned, 0 On-hold and 11951 signed while the desktop view shows 0 In progerss, 3 - Unsigned, 4 - Onhold and 5 - Signed.

John Kingery Outside In

Posted : January 10, 2014 2:18 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

This was in our EMR - think it is a system report though (Go Setup Settings, Reports, Reports: Under the Reports\MedicaLogic folder Unsigned Documents, by User

Posted : January 10, 2014 3:56 am

aboyer

(@aboyer)

Posts: 20

Eminent Member

This is an old post but it came up in my search. In case anyone else is looking, this is what I came up with (Oracle version) to show everything on a user's desktop:

SELECT PERSON.EXTERNALID,
PERSON.SEARCHNAME,
Convert_ID_to_date (DOCUMENT.clinicaldate) AS DOCUMENT_DATE,
DOCTYPES.ABBR,
DOCUMENT.SUMMARY,
DOCUMENT.STATUS,
DOCROUTE.ACTION,
DOCUMENT.DB_CREATE_DATE,
MAX (DOCROUTE.ROUTE_TIME) AS MAX_ROUTE_TIME
FROM (((ML.DOCUMENT DOCUMENT
INNER JOIN ML.DOCROUTE DOCROUTE ON (DOCUMENT.SDID = DOCROUTE.SDID))
INNER JOIN ML.USR USR ON (DOCROUTE.USRID = USR.PVID))
INNER JOIN ML.PERSON PERSON ON (PERSON.PID = DOCUMENT.PID))
INNER JOIN ML.DOCTYPES DOCTYPES ON (DOCTYPES.DTID = DOCUMENT.DOCTYPE)
WHERE USR.LOGINNAME = 'EMR_User_ID_Goes_Here'
GROUP BY DOCROUTE.ACTION,
DOCUMENT.DB_CREATE_DATE,
DOCUMENT.STATUS,
DOCUMENT.SUMMARY,
PERSON.SEARCHNAME,
PERSON.EXTERNALID,
Convert_ID_to_date (DOCUMENT.clinicaldate),
DOCTYPES.ABBR,
DOCROUTE.ROUTE_TIME

Posted : March 19, 2018 11:20 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