Skip to content

CDI-DashBoard

CDI-DashBoard

The main motto of CDI dash board module is bring all patient related information into single dash board and provide chance for CDS to make query on patient's information like labs, vital signs, medications, diseases or procedures etc. to physician for clinical documentation improvement.

Functionalitites:

  1. We post cdi dashboard design or functionality issues by post issue tab.
  2. We can see admitorder information provided by KPAI after analyzing patient's documents.
  3. CDS as well as other users can easily make query on patient's information like demographics,vsigns,labs,medicines,icd or pcs codes to the physician who may be attending or admitting or consulting physician by simple clicks.
  4. CDS can simply edit the queries if they are not having proper information by click on edit option under the corresponding query.
  5. CDS can delete the queries if they are not required to be by providing proper reason for deletion of the query.If other than CDS/admin users try to delete the query it won't be deleted, just gives an intimation to the CDS.
  6. CDS can see deleted and responded queries as well as its count in separate tabs like Deleted-Queries and Responded-Queries respectively and they can simply revert the deleted queries once again from deleted query history tab and makes a query as un-responded from responded queries tab.
  7. We can see who were deleted and the reason for the deletion of a query in the deleted queries tab
  8. We can add response to the query by add response button which will be confirmed if the response added by CDS/admin only otherwise it just take that response to show the CDS when he/she opens popup to add response.
  9. We can just add comments if unable to provide response to the query by add comment tab and able to see all comments by view-comments tab.
  10. We can go for reference by click on hyperlinks provided at query note keywords at dashboard.
  11. We can see who is generated a query, cds name and to which physician it was posted beside of Query Title.
  12. We can submit the query and export it simultaneously by using Submit& Export button
  13. We provided an option group the diseases based upon the doctorname, dictated worktype and dictated date as well as labs in an order as shown in dashboard and some manipulations on daylabs data like lab1,labs should be shown as lab: val+units(day1) and lab: val+units(day2) respectively.

DiagnosisCriteria Table Status:

  1. By default,Query status=0, queryresponse=0, enddate is null, exportstatus=0,priority=high
  2. Responded - queryresponse=1, enddate , response, response-by are not null
  3. Exported - exportstatus=1
  4. Deleted - move query into deleteddcquery from diagnosiscriteria
  5. Query Alerts - username=KPAI
  6. Query Alerts Deleted - status=1

FieldDescription Table Status:

  1. AGE - FieldId=1
  2. CDIDES/MEDIDES - FieldId=2
  3. Labs - FieldId=4
  4. Radiology - FieldId=5
  5. Vitals - FieldId=6
  6. Meds - FieldId=7
  7. Diseases - FieldId=3,FieldType=ICD
  8. Procedures - FieldId=3,FieldType=PCS
  9. Sign or Symptoms - FieldId=3,FieldType=SnomedCT-Dx/SnomedCT-SS/SnomedCT-Hx/SnomedCT-Bug/SnomedCT-Tx/SnomedCT-Meds/SnomedCT-RN/SnomedCT-Misc/SnomedCT-Test
  10. Keywords added from document - Fieldid=8
  11. PDx Support - FieldId=9

DeletedDCQueries Table Status:

  1. Query/ Query Alert edit - status=0
  2. Query deletion - status=1

  3. Query Alert deletion

  4. Normal- status=2

  5. deleted by test type user- status=3

Admit-Orders Tab color Status:

  1. No Admit order present - red
  2. No documents present - white
  3. Admit order exists - yellow

Work Flow for CDI-DashBoard

Work Flow for Other tasks at CDI-DashBoard

Files

Tables

Facility DB

  • cdiissues
  • admitorders
  • physiciandetails
  • diagnosiscriteria

  • fielddescription

  • FDKeywords

  • FDKWReferences
  • FDLabs
  • FDVitals

  • FDMeds

  • DeletedDCQueries

  • QueryQueue
  • queryqueuelog
  • CDSResponseLog
  • Querydoccreationlog
  • exporteddocuments
  • viewdocumentreviewlog
  • excludedAccounts
  • excludedalerts

Stored Procedures

  • insertcdiissues
  • getadmitorders
  • getphysicianIdByName
  • getQueryId
  • insertFieldDescription
  • insertEdittedQueryLog
  • deleteDCQuery
  • saveQueryResponseComment
  • revertdeletedDCQuery
  • getDeletedHistory
  • getRespondedQueryHistory
  • getPhysiciandetails
  • getNoteContentByQid
  • SaveCDSResponse
  • SaveCDSResponseClearance
  • insertSearchLog
  • GetQueryHistoryCount
  • GetTotalQueryCount

JSP / Js

  • DrgQueryQueue/patientdemographics.jsp
  • DrgQueryQueue/icdnorms.jsp
  • DrgQueryQueue/vsnorms.jsp
  • DrgQueryQueue/labnorms.jsp
  • DrgQueryQueue/mednorms.jsp
  • DrgQueryQueue/mainqueue.jsp
  • DrgQueryQueue/jquerycaller.jsp
  • DrgQueryQueue/deleteQuery.jsp
  • CDSQueryQueue/ViewAllComments.jsp
  • DrgQueryQueue/admitorders.js
  • jquery/drgquerycheck.js

Java

  • biz.kpai.diagnosiscriteria.DiagnosisCriteria.java
  • biz.kpai.diagnosiscriteria.dao.DiagnosisCriteriaDao.java
  • biz.kpai.diagnosiscriteria.service.DiagnosisCriteriaService.java
  • biz.kpai.diagnosiscriteria.servlet.CriteriaHandlerMap.java
  • biz.kpai.queried.service.GetQueriedInfoService.java
  • biz.kpai.queried.dao.GetQueriedInfoDao.java
  • biz.kpai.queried.servlet.GetQueriedInfoServlet.java
  • biz.codeextract.documentsummary.service.PatientVisitDetailsService.java
  • biz.codeextract.documentsummary.dao.PatientVisitDetailsDao.java

MedmineMaster

  • MNEMONICS
  • user1
  • searchLog