Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

OpenIMIS tables mapped - tblClaim, tblClaimItems , tblClaimServices

FHIR R4 field

OpenIMIS field

notes

mapping status

Identifier

tblClaim.ClaimID / tblClaim.ClaimUUID / tblClaim.ClaimCode

Claim can have multiple identifiers. The most important one is mapped from ClaimCode

ClaimID and ClaimCode mapped

patient

tblClaim.InsureeID

mapped

billablePeriod

tblClaim.DateFrom / tblClaim.DateTo

date from and date to are mapped to a period of time between them

mapped

diagnosis

tblClaim.ICDID / tblClaim.ICDID1 / tblClaim.ICDID2 / tblClaim.ICDID3 / tblClaim.ICDID4

ICDID values are mapped to a list of diagnosis

mapped

provider

tblClaim.Adjuster

not mapped

claimCode

dateFrom

dateTo

total

tblClaim.Claimed

mapped

created

tblClaim.DateClaimed

mapped

supportingInfo

tblClaim.Explanation / tblClaim.GuaranteeId / tblClaimItems.Availability / tblClaimItems.Explanation / tblClaimServices.Explanation

information category is distinguishing the type of information

renamed from information to supportingInfo

mapped

facility

tblClaim.HFID

mapped

enterer

tblClaim.ClaimAdminId

mapped

type

tblClaim.VisitType

mapped

item.productOrService

tblClaimItems.ItemId / tblClaimServices.ServiceID

claim.item.category.text is distinguishing whether mapping is done from tblClaimsServices or tblClaimItems

renamed from service to productOrService

mapped

item.quantity

tblClaimItems.QtyProvided / tblClaimServices.QtyProvided

claim.item.category.text is distinguishing whether mapping is done from tblClaimsServices or tblClaimItems

mapped

item.unitPrice

tblClaimItems.PriceAsked / tblClaimServices.PriceAsked

claim.item.category.text is distinguishing whether mapping is done from tblClaimsServices or tblClaimItems

mapped

...