Technical Details¶
Tables And Status Description:
IQFormResults
| Description | Status column Value |
|---|---|
| Criteria added by analysis | rstatus=0 |
| Criteria added by user | rstatus=1 |
| Deleted by user | rstatus=2 |
| In two conditions in criteria if condition one true and another one false then condition one with status 5 | rstatus=5 |
Tables¶
Facility DB
- IqFormResults
- iqcriteriametdata
- hashcodeiqdetails
- iqcurrentcensus
- InterQualReviewLog
- IQFormReviewStatus
MedmineMaster
- InterQualFormCodes
- Interqualdata
- interqualforms
- tempiqformsTemp2
- InterqualNotes
- IQCriteriaCount
- DiseaseSynonyms
- DiseaseByCUI
Stored Procedures:¶
InterQual Queue Display:
- TotalIQFormResultsCount
- NoCriteriaMetIQFormAccounts
- ReviewedIQFormResults
- NonReviewedIQFormResults
- IQFormReviewedVSNonReviewed
- GetIQTreeDisplay
- InterQualFormDeletion
- InterQualFormAdding
- EditInterQualResults
- GetIQCriteriaMetForms
- GetIQTreeResultDisplay
- GetAllVitalResults
- GetCDILabResults
- GetMedications
- getPatientInfoDetails
- getDocumentInfoDetails
CoreAnalysis:
InsertIntoInterQualResults
JSP / Js:¶
- Dashboard/patientdashboard.jsp
- dashboard.js
- angucomplete-alt.js
- dashboard.css
Java:¶
- kpmd.dashboard.interqual.dao.DashboardInterqualDao
- kpmd.dashboard.patientdemographics.dao.PatientDemographicsDao
- kpmd.dashboard.servlet.PatientJsonPojo
- kpmd.dashboard.dao.PatientDashboardDao
- kpmd.dashboard.dao.PatientDashboardDaoFactory
- kpmd.dashboard.interqual.pojo.DashboardInterqualPojo
- kpmd.dashboard.patientdemographics.PatientDemographicsPojo
- kpmd.dashboard.patientdemographics.dao.PatientDemographicsDao
- kpmd.dashboard.pojo.PatientDashboardPojo
- kpmd.dashboard.servlet.PatientDashboard
- kpmd.dashboard.servlet.FormSearchServlet
INTERQUAL CORE ANALYSIS PROCESS :¶
STEP1:
In Order run IQCore Analysis we need AccountNo's as an input.Accountno's analyzed by KPMD360 Application are moved in to IQCurrentcensus table with Status=1.
STEP2:
Then Interqual forms are triggered based on patient data like age,sex,
We Trigering/Finding InterQualCriteriaMet Forms on those AccountNo's and it's related data like age,sex,admissionday,InterqualFormId,InterqualFormName and Criteria level based on ICDCode.