Ticket | |
---|---|
Legacy stored procedure | uspSSRSPrimaryIndicators2 |
This report handles claims and products. Every report that handles claims with a specific product will not produce 100% reliable data. Due to architectural choices, claims are only linked to a specific product if they have already been submitted and if they have not been automatically rejected. For a given product, it is currently impossible to know:
Any “rejected” or “total” numbers of claims - if a specific product is given - will never include these two cases. While this is usually not an issue with large numbers, it can make some totals seem wrong. |
For each requested month, a query fetches all claims with the requested criteria (product, region, district…). Then, the content of each claim is analyzed and results are added to subtotals.
There are various subtotal levels:
Overall totals
Subtotals for each month
Subtotals for each Health Facility
in each month
Subtotals for each Product
available in each Health Facility
in each month
The following values are calculated, based on the previously described fetched claims:
Total number of claims. not 100% reliable - see above warning.
Total number of rejected claims: each claim that has the status REJECTED
. not 100% reliable - see above warning.
Total amount remunerated: the sum of ClaimItem
and each ClaimService
that:
have the status PASSED
are linked to a claim with the status PAID