Payment Hit Report

[viv_prabha]

Hi Team,

Is there any report avialable in cognos, where we can get payment hit report in below format.

Employee Name

Employee iD

Claim iD

Payment status

Paid date

Duration  between Line manager approval & Paid date

Number of rejection time

Reason of rejection (at each time) = to verify,if calim rejected twice , then the rejection reason is same or diffrent.

[KevinD · Accepted solution]

@viv_prabha I believe the exact report you are looking for does not already exist and would need to be built by someone in your organization. 

I don't know what your Cognos report building experience is, but most of the data items you mentioned can easily be found in the data warehouse and added to a custom report. 

For the Line Manager Approval and Paid Date, you would need to create a calculation between, last submitted date and Paid date and have Cognos subtract Last Submitted Date from the Paid date. This will show the number of days to go from Submitted and Pending Approval to Paid. You could also subtract the Paid date from the Manager approval date, but that is a little more involved and not quite as easy to do because you have to account for the Workflow Step of Manager Approval and include this step action date and time and then the step action date and time for Paid Date. It is possible and not too difficult if you have experience using Cognos.

[Lewis-H]

One late payment could have a more significant impact on higher credit scores. According to FICO data, a 30-day delinquency could cause as much as a 90- to 110-point drop on a FICO Score of 780 for a consumer who has never missed a payment on any credit account.