Skip to content

PSI DATA PROCESS

Following is the process to read and insert PSI excels in to KPAI tables.

STEP 1: Download PSI pdfs from below site https://www.qualityindicators.ahrq.gov/Modules/psi_resources.aspx.

STEP 2: Covert pdf files to xml files through commandpromt by using command. Examples: pdftohtml -xml PSI_03_Pressure_Ulcer_Rate.pdf PressureUlcer.xml.

STEP 3: Read the data from xml files by using PsiXmlReader.java and insert data into PsiTechInfo table.

STEP 4: Prepare PSI table by using Inclusions and Exclusions from PSI Pdfs.

PSI Core Analysis

Following is the process of PSI Core Analysis.
STEP 1:
In Order to run PSI Core Analysis we need AccountNo's which are getting from any modifications/updates to the following table sources. AnnotationList,CodeChangeLog,LabResults,DRGChangeLog,POAChangeLog,Medications and MeditechVitals.
STEP 2:
For those PSI AccountNo's we need to get it's related data like DRG,MDC,AGE,Admitdate,Dischargedate and GLOS.

STEP 3:
We try to find out ICD10DXCoding and PCS Coding for those AccountNo's.
STEP 4:
We try to find out PSI's on those AccountNo's to the following criteria's met by using Standard tables which are PSI and PSITechInfo.

ICDCode, ICD and POA-Y, ICD and PDX, ICD and PDX-S, ICD and PDX-S and POA-N, ICD and PDX-S and POA-Y, ICD&ICD and PDX-S, ICD&ICD and PDX-S and PDX2-P, ICD&ICD and PDX-S and PDX2-S, ICD&ICD and PDX-S and PDX2-S and POA2-Y, ICD&ICD and PDX-S&POA-Y and PDX2-S&POA2-Y, PROC, PROC and PDX[before or on the same day as the first operating room procedure], PROC and PDX[occurs before or on the same day as the first operating room procedure], PROC and PDX[occurs before the first operating room procedure], PROC and Condition2[as the only major operating room procedure(surgical cases only)], PROC and Condition2[before or on the same day as the major operating room procedure] PROC and Condition2[occurring within 2 days of admission or an admission type of elective (ATYPE=3)], PROC and Condition2[occurs on or before the day of the first abdominopelvic surgery procedure], PROC and Condition2[occurs zero or more days after the first major operating room procedure code (based on days from admission to procedure)],
STEP 5: Based on the above conditions we triggered PSI's on those AccountNo's and are inserted in to a final table called PSIResults.
STEP 6: Finally we need to calculate score on triggered PSI's which are on PSIResults table based on Inclusions and Exclusions.

NOTE:
The above steps from 1 to 6 should be implemented on InsertIntoPSIResults(CoreAnalysis) procedure and some quite changes and remaining as to be same for another procedures which are given below.

  • InsertIntoPSIResultsByAccNo
  • InsertIntoDNPSIResults
  • InsertIntoDNPSIResultsByAccNo
  • MeditechPSIResults
  • MeditechPSIResultsByAccNo
  • MeditechPSIResultsByDN
  • MeditechPSIResultsDNByAccNo

PSI Module MS-SQL DBInfo

Facility Tables:

  • PsiResults
  • PSIReviewlog
  • DNPsiResults
  • DNPSIReviewlog
  • MTPsiResults
  • MTPSIReviewlog
  • DNMTPsiResults
  • DNMTPSIReviewlog

Facility Procedures:

  • InsertIntoPSIResults
  • InsertIntoPSIResultsByAccNo
  • InsertIntoDNPSIResults
  • InsertIntoDNPSIResultsByAccNo
  • MeditechPSIResults
  • MeditechPSIResultsByAccNo
  • MeditechPSIResultsByDN
  • MeditechPSIResultsDNByAccNo

Master Tables:

  • PSI
  • PSITechInfo