Notifications
Clear all
Topic starter
Does anyone have a report that will show unsigned documents by user desktop?
Posted : December 13, 2013 7:11 am
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
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
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
