Contributions - Distribution

Owned by Thibault Dethier
Last updated: Sept 13, 2023
1 min read

Ticket

OMT-328: Report: Contributions - DistributionDone

Legacy stored procedure

uspSSRSPremiumDistribution

 

Comments about the report

The legacy report had a region and a district picker that were simply used to filter out the list of products. They were not used in the report, so they were removed.

 

How it works

 

For each selected month, this report fetches all Premium data linked to a given Product, and dispatches the amounts into 3 categories:

  • Collected: the total amount that was collected

  • Not allocated: the amount that was collected during a given month for a policy that will start after the given month

  • Allocated: the amount that was collected and proportionally assigned to the given month (e.g. if you pay $1200 for a year, each month will have $100 allocated)

Did you encounter a problem or do you have a suggestion?

Please contact our Service Desk


This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/