Ticket | OMT-328 - Getting issue details... STATUS
|
|---|---|
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)