Curent structure

...

openIMIS use a type 2 database were a row is added when a record is changed; there is two reasons:

in openIMIS, the first record is valid for the date-time of entry. if a item (product/service/price list ) need to start before then the Validity

Auditing

This enable to see the historical record in order to see who made which changes

...

• Benefit package: required to assess claim visit type limit, ceiling, deductible …

  • Benefit package Services: required for assess Child / Adult ceiling, Amount limits, limit exclusiosn and relative pricing

  • Benefit package Items: required for assess Child / Adult ceiling, Amount limits, limit exclusiosn and relative pricing

• Medical Item: tblItems required to assess frequency and mask of service: Is it really needed ?

• Medical Product: tblService required to assess frequency, service type and category and mask of service: Is it really needed ?

• Medical Item Price List : needed to unsure the agreement update are taken in account for the right claims

  • Medical Item Price List Items details : tblPLItems

• Medical Services Price List: needed to unsure the agreement update are taken in account for the right claims

  • Medical Service Price List Service details : tblPLService

• Health facility (for price list, type of care and catchement)

• Location:Villages (for population)
  

...