Interqual Logic Tables

Master tables for Interqual Data;

1. select * from KPAIMAster.dbo.MST_IQSubSet
2. select * from KPAIMAster.dbo.MST_IQSubsetCriteria
3. select * from KPAIMAster.dbo.MST_IQSubSetNote

Classification tables for Interqual Data;

1. select * from MST_IQ_DrugClassification
2. select * from MST_IQ_DrugMapping
3. select * from MST_IQ_ICDClassification
4. select * from MST_IQ_MedicalConceptClassification
5. select * from MST_IQ_NurseNoteClassification
6. select * from MST_IQ_PCSClassification

LogicGroup tables for Interqual Data;

1. select * from KPAIMAster.dbo.MST_IQLogicGroup
2. select * from KPAIMAster.dbo.MST_IQCriteriaElement
3. select * from KPAIMAster.dbo.MST_IQCriteriaElementMapping

Criteria Met Results tables;

1. select * from CM_IQ_KPAI_PendingAccount
2. select * from CM_IQ_KPAI_IQElementResult
3. select * from CM_IQ_KPAI_SelectedCriteria
4. select * from CM_IQ_KPAI_SelectedSubsets
5. select * from CM_IQ_KPAI_CriteriaMetSubSets
6. select * from CM_IQ_KPAI_ActionLog

1. Criteria Data to MST_IQLogicGroup Table

Fill MST_IQLogicGroup table from MST_IQSubsetCriteria table by using below query:

select distinct CriteriText from KPAIMAster.dbo.MST_IQSubsetCriteria where IQSubSetId=3 and CriteriaCheck='true'

update GroupId to all Criteria Text in MST_IQSubsetCriteria table from MST_IQLogicGroup table :

Update mc set GroupID=mg.GroupID from MST_IQSubsetCriteria mc
inner join MST_IQLogicGroup mg on mc.CriteriaText=mg.GroupName

update ConditionCount=2 in MST_IQLogicGroup table for GroupName contains 'and' like '>= 2x baseline and chronic kidney disease'

split those GroupNames into two entries, and update GroupId as ParentId to new entries.

GroupId          GroupName                          ParentId    ConditionCount  
1       < 120 mEq/L(120 mmol/L) and volume overload   0             2   
133     < 120 mEq/L(120 mmol/L)                       1             0   
134     volume overload                               1             0

2. Criteria Data to Classification Tables

Fill Classification tables for all the GroupNames in MST_IQLogicGroup Table.

if GroupName like:

Diseases -----> MST_IQ_ICDClassification and MST_IQ_MedicalConceptClassification
Procedure ----> MST_IQ_PCSClassification
Medication ---> MST_IQ_DrugClassification and MST_IQ_DrugMapping
NurseNotes ---> MST_IQ_NurseNoteClassification
Labs & Vitals --> use Dictionary tables MST_LabDictionary and MST_VitalSignDictionary

3. Criteria Data to MST_IQCriteriaElement Table

Fill MST_IQCriteriaElement Table based on the CriteriaElementType and update Source_UniqueID field from Corresponding Classification Table.

CriteriaElementId	CriteriaElementType	CriteriaElementName	Source_UniqueId	Source_Table
1	LabTest	Sodium	60	MST_LabDictionary
10	Vitalsign	Temperature	12	MST_VitalSignDictionary
12	ICDCode	chronic kidney disease	1	MST_IQ_ICDClassification
24	MedicalConcept	chronic kidney disease	1	MST_IQ_MedicalConceptClassification
36	Medication	Diuretic	1	MST_IQ_DrugClassification

4. Criteria Data to MST_IQCriteriaElementMapping Table

Fill MST_IQCriteriaElementMapping Table by using MST_IQCriteriaElement and MST_IQLogicGroup Tables

Interqual Core Analysis Process:

Note

To Run IQ Analysis get Accounts from CM_IQ_KPAI_PendingAccount table with status=0, which was filled after Document Analysis was Done on corresponding Accounts.

IQAS_RunIQLogic is the core stored procedure to map all the Analysis Data like Icd coding, Pcs coding, MedicalConcepts, Nurse Notes, LabTests, Medications and Vitals.

Process of all Analysis join with corresponding Logic tables

IQAS_RunIQLogic

IcdCode: IQAS_ICDCodeCheck

PcsCode: IQAS_PCSCodeCheck

MedicalConcept: IQAS_MedicalConceptCheck

NurseNote: IQAS_NurseNoteCheck

Lab: IQAS_LabTestCheck

Medication: IQAS_MedicationCheck

Vital: IQAS_VitalsignCheck

---