Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Ticket

Jira Legacy
serverSystem JIRA
serverId97d38f4a-4cd9-3563-900d-60c9290b47f4
keyOMT-314

Legacy stored procedure

uspSSRSGetClaimHistory

...

Comments about the report

Note

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:

  • the number of entered claims (as in “not yet submitted”)

  • the number of automatically rejected claims (as opposed to manually rejected by a claim administrator)

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.

In this report, if a specific product is asked, it would be impossible to fetch all claims with that product as the ENTERED claims are not linked yet to the product and the SUBMITTED claims that were automatically rejected were not linked either.

...

Info

This report is exactly the same as the Claim - Overview report, except that it focuses on a single Insuree.

How it works

A query fetches all claims with the requested criteria (insuree, product, region, district…).

...