This page presents the analysis of AI algorithm’s input data model. First, we analyse the openIMIS data structure and fields representing the information used by the Medical Officer to adjudicate a claim. Second, we look at the openIMIS-FHIR mapping and extract the
...
required FHIR resources
...
to feed the AI algorithm during the learning, development and test processes. Because the openIMIS FHIR module do not map all openIMIS fields to FHIR resources, we are limited by the current FHIR-openIMIS R4 mapping
...
Table of Contents |
---|
Claim adjudication - openIMIS entities and fields
...
.
openIMIS Claim Review Web Page
...
openIMIS Database Tables
Diagram
The following database diagram displays openIMIS tables and their relations. The analysis is
...
centered on Claim and identifies other entities in relation to a Claim and used in the adjudication process.
...
FHIR Resources Definition
From all the fields that the Medical Officers are using when reviewing claims, we mainly need to identify entities in relation to the Claim. From some entities (
...
Diagnosis,
...
HF), we
...
might not require more than the identification fields.
...
Field
...
Type
...
Description
...
ClaimUUID
...
uniqueidentifier
...
Unique identifier of the Claim
...
DateFrom
...
smalldatetime
...
DateTo
...
smalldatetime
...
DateClaimed
...
date
...
ClaimStatus
...
tinyint
...
Claimed
...
decimal(18, 2)
...
Approved
...
decimal(18, 2)
...
VisitType
...
char(1)
...
Emergency, Referral, Other
...
ClaimCategory
...
char(1)
...
Automatically defined in checking process: Surgery, Delivery, Antenatal, Hospitalisation, Consultation, Visit
...
last visit to the same hospital (how many days)
tblClaim → tblHF
...
Field
...
Type
...
Description
...
HfUUID
...
uniqueidentifier
tblClaim → tblClaimAdmin
...
Field
...
Type
...
Description
...
ClaimAdminUUID
...
uniqueidentifier
tblClaim → tblClaimServices
...
Field
...
Type
...
Description
...
ClaimServiceStatus
...
tinyint
...
Service accepted or rejected
...
QtyProvided
...
decimal(18, 2)
...
PriceAsked
...
decimal(18, 2)
...
Field
...
Type
...
Description
...
ServiceUUID
...
uniqueidentifier
tblClaim → tblClaimItems
...
Field
...
Type
...
Description
...
ClaimItemStatus
...
tinyint
...
Item accepted or rejected
...
QtyProvided
...
decimal(18, 2)
...
PriceAsked
...
decimal(18, 2)
...
Field
...
Type
...
Description
...
ItemUUID
...
uniqueidentifier
tblClaim → tblICDCodes (Main and Secondary Diagnosis)
...
Field
...
Type
...
Description
...
ICDUUID
...
uniqueidentifier
tblClaim → tblInsuree
...
Field
...
Type
...
Description
...
InsureeUUID
...
uniqueidentifier
...
DOB
...
date
...
Date of birth
...
Gender
...
char(1)
...
Gender in codded format: e.g. M/F, 0/1
...
HFID
...
int
...
First Point of Contact
FK for tblHF
tblClaim → tblInsuree → tblFamilies
...
Field
...
Type
...
Description
...
FamilyUUID
...
uniqueidentifier
tblClaim → tblInsuree → tblInsureePolicy → tblPolicies
...
Field
...
Type
...
Description
...
PolicyUUID
...
The fields that will be taken into consideration from openIMIS database will be limited by the current openIMIS to FHIR mapping. More particular, the ClaimResponse will be used for the development of the AI algorithm and for production use. This resource is required to have the adjudication results for already categorized claims by a medical officer for development stage and to have the static validation response (automatic checking step) when categorizing the claims through the AI model.
In the following table, we list FHIR and openIMIS resources that will be considered as the input data model for the development of the AI algorithm and model.
FHIR R4 Resource (AI algorithm input data model) | openIMIS Database Tables (mapped entities) | Notes |
---|---|---|
tblClaim | ||
ClaimResponse → Condition | tblClaim → tblICDCodes | Main and Secondary Diagnosis |
ClaimResponse → HealthcareService | tblClaim → tblHF | |
ClaimResponse → Patient | tblClaim → tblInsurees | Name is not considered |
ClaimResponse → ActivityDefinition | tblClaim →tblClaimServices → tblServices | |
ClaimResponse → Medication | tblClaim →tblClaimItems→ tblItems | |
ClaimResponse → Practitioner | tblClaim → tblClaimAdmin | Only the identifier is considered |