...

Objective

Provide a mechanism to increase the performance to calculate the balance per insuree - currently full table scans:

...

. It will be used by both modular BE and REST API.

Solution

Create a policy_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

      enquiry

  schedule

Schedule task to update

...

• for

  For all claims updates since the last run

  • get all policy details covered by claims (column in item and services)

    • get all the member of the policy

      • update the common limits

      • update the individual limits

      • save all cached

        inquiry

        enquiry