Claim

Identifier

tblClaim.ClaimID / tblClaim.ClaimUUID / tblClaim.ClaimCode

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

patient

tblClaim.InsureeID

billablePeriod

tblClaim.DateFrom / tblClaim.DateTo

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

diagnosis

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

ICDID values are mapped to a list of diagnosis

outcome

tblClaim.ClaimStatus

provider

tblClaim.Adjuster

total

tblClaim.Claimed

created

tblClaim.DateClaimed

information

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

information category is distinguishing the type of information

facility

tblClaim.HFID

enterer

tblClaim.ClaimAdminId

type

tblClaim.VisitType

item.service

tblClaimItems.ItemId / tblClaimServices.ServiceID

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

item.quantity

tblClaimItems.QtyProvided / tblClaimServices.QtyProvided

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

item.unitPrice

tblClaimItems.PriceAsked / tblClaimServices.PriceAsked

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