...
create a cache_balance table with those columns per “benefit”
benefit detail name (visit hospital … )
insuree id
benefit id (policy)
date of validity (policy end date) ??
balance (actually approved)
provisional (submitted claim)
temporary (draft claim)
limits
MVP:
initial update:
For all policy,
for all insuree covered by policy
get all claim details covered by policy (column in item and services)
update the common limits
update the individual limits
save all cached inquiry
...