Reports

Statistical Reports

It is to provide analyzed statistical information by bar charts as well as pie charts. It provides statistics on the following strategies Queries,Coder manipulations, KPAI Quality measurements and CDI trend information.

Functionalities:

1. We can filter data by selecting appropriate fields in this interface.
2. We have to choose any one of the following sections: KPAI-Queries statistics,KPAI-Coder statistics, KPAI-Quality statistics and CDI trend information at first.
3. We have 4 Query types under KPAI-Queries statistics i.e, General Queires, Query Alerts, Exported Queries and New Queries.
4. We have provided statistical information on Review History,ICD change status,PCS change status and Annotation change status under KPAI-Coder statistics.
5. We can measure the quality of KPAI coding with Meditech coding by KPAI-Quality Stats under 3 scenarios like Non-Auditing, Before Auditing and After Auditing.In which we compare KPAI codes with MT codes like exact metched codes, 4/3 digit matched codes and provide statistical chart on their count.
6. We can see CDI trend statistics by selecting an option of CDI trend Stats. Then after we need to choose on which type of trend statistics we need to see like Diagnoses Specificity,Specific Codes,Case Mix AttPhy,CMI Trend,CC/MCC Ratio Trend,DRG Trend,Complication Trend-MCC,Complication Trend-CC,Attending Physicians,CMI Attending Physicians,LOS Attending Physicians,AVG.LOS Attending Physicians,Compliance Audit Trend,ICDTrends-icd and ICDTrends-term.
7. We can see analyzed chart information inside a popup window which is used to design the chart.
8. We can export chart with its analyzed table information into excel, pdf, image formatted files like JPEG,PNG,SVG. Reports Exporting Logic
9. We can maximize, minimize and refresh/reload the designed chart through this interface.
10. We can change chart type from bar chart to pie chart or vice versa and we can apply themes on the displayed chart.

KPAI-Queries statistics

General Queries:

1. Queried rate
2. Responded rate

Query Alerts:

1. Queried rate
2. Responded rate
3. Edited rate
4. Deleted rate
5. Exported rate
6. Non-Exported rate

Exported Queries:

1. Exported rate
2. Exported and Responded rate

New Queries:

1. Queried rate
2. Responded rate
3. Edited rate
4. Deleted rate
5. Exported rate
6. Non-Exported rate

KPAI-Coder statistics

• Review History
• ICD change status
• PCS change status
• Annotation change status
  1. CDS
     1. Month/Quarter/TimeSlice
     2. AccountNo
     3. Current Census
  2. Coder
     1. Month/Quarter/TimeSlice
     2. AccountNo
     3. Current Census

KPAI-Quality statistics

• Non Auditing
• After Auditing
• Before Auditing
  1. ICD Coding
     1. AccountNo 2.Month/Quarter
     2. Current Census
     3. DischargeDate
  2. Pdx Coding
     1. AccountNo
     2. Month/Quarter
     3. Current Census
     4. DischargeDate
  3. DRG
     1. AccountNo
     2. Month/Quarter
     3. Current Census
     4. DischargeDate

CDI Trend Stats

• CDI trend Info
  1. Diagnoses Specificity
  2. Specific Codes
  3. Case Mix AttPhy
  4. CMI Trend
  5. CC/MCC Ratio Trend
  6. DRG Trend
  7. Complication Trend-MCC
  8. Complication Trend-CC
  9. Attending Physicians
  10. CMI Attending Physicians
  11. LOS Attending Physicians
  12. AVG.LOS Attending Physicians
  13. Compliance Audit Trend
  14. ICDTrends-icd
  15. ICDTrends-term

Plug-ins:

1. amcharts -Third party tool

   Reference: http://www.amcharts.com

MT-Admit Order Reconcile stats

• All
• Census

• Discharge

• All MT Admit Orders

• Reconciled MT Admit Orders
• Completed MT Admit Orders

Strategies1

• Reports Generated for the following scenarios under General Queries, Query Alerts, Exported Queries in the category of KPAI Queries Stats:
  1. Diagnosis
     • Physician
     • CDS
     • Auditor/Name
     • Month
     • Quarter
  2. Physician . Diagnosis . CDS . Auditor/Name . Month *. Quarter
  3. CDS . Diagnosis . Physician . Auditor/Name . Month *. Quarter
  4. Auditor/Name
     • Diagnosis
     • Physician
     • CDS
     • Month
     • Quarter
  5. Month/Quarter
     • Diagnosis
     • Physician
     • CDS
     • Auditor/Name

Strategies2

• Reports Generated for the following scenarios under New Queries in the category of KPAI Queries Stats:

• Diagnosis

  • Physician
  • CDS
  • Month
  • Quarter
• Physician
  • Diagnosis
  • CDS
  • Month
  • Quarter
• CDS
  • Diagnosis
  • Physician
  • Month
  • Quarter
• Month/Quarter
  • Diagnosis
  • Physician
  • CDS

Work Flow for Reports

Work Flow for Other Functionality at Reports

Files

Tables

Facility DB

• DiagnosisCriteria
• icdpriority
• meditechcodes
• trend_data
• documentinfo
• reimbursement

MedmineMaster

• allsynonymquerynames
• commonqueryname
• MNEMONICS
• user1
• MedPrimeHL7.dbo.visits

Stored Procedures

• GetNewQueries
• GetKpaiQALogData
• GetQueiresByTrendReports_test
• GetResponseByTrendReports_test
• GetQueryAlertsByTrendReports_test
• GetExportedQueriesByTrendReports_test
• KPAIVsMeditechReports_New
• GetCDITrendInfo
• GetAdmitOrderReports
• InsertExportedReports
• getKpaiReviewAccountHistory

JSP / Js

• Trendreports/kpaiReports.jsp
• Trendreports/kpaiQueriesStats.jsp
• Trendreports/kpaiCoderStats.jsp
• Trendreports/kpaiQualityStats.jsp
• Trendreports/cdiTrendStats.jsp
• Trendreports/showJSONInfo.jsp
• Trendreports/FormatJSONData.jsp
• Trendreports/KpaiQALog.jsp
• Trendreports/GetStatsCaller.jsp
• Trendreports/NewQueriesData.jsp
• Trendreports/showTableCaller.jsp
• Trendreports/cdiTrendInfo.js

Java

• biz.trendreports.dao.TrendReportDao.java
• biz.trendreports.service.TrendReportService.java
• biz.trendreports.servlet.CreateXLSheet.java
• biz.trendreports.servlet.ExportXLBarchart.java
• biz.trendreports.servlet.ExportPDFChart.java
• biz.trendreports.servlet.ExportXLPiechart.java
• biz.trendreports.servlet.ExportImgBarchart.java
• biz.trendreports.servlet.ExportKpaiStatusXLBarChart.java
• biz.trendreports.servlet.ExportXLCoderBarchart.java
• biz.trendreports.servlet.ExportXLKpaiBarchart.java