Ticket |
| ||||||||
---|---|---|---|---|---|---|---|---|---|
Legacy stored procedure | uspSSRSPremiumDistribution |
Comments about the report
Note |
---|
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)