News for hackers. Stuff that matters.

A comment on State found $117k in double payments through data analytics. Parent comment

Re:State found $117k in double payments through data analytics by ellisv on Wednesday December 11, 2019 @12:47PM (#21764854)
HAVING COUNT(*) > 2;

I'll take 9% );

[ Parent | on HN ]
Re:State found $117k in double payments through data analytics by madenine on Wednesday December 11, 2019 @12:59PM (#21764992)
HAVING COUNT(*) >= 2;

Back to 10%

[ Parent | on HN ]
Re:State found $117k in double payments through data analytics by elhudy on Wednesday December 11, 2019 @01:26PM (#21765266)
Add a date field or you might get legitimate duplicates if the payment amounts are the same across months.
[ Parent | on HN ]
Re:State found $117k in double payments through data analytics by TheSoftwareGuy on Wednesday December 11, 2019 @02:25PM (#21765823)
They shouldn't have the same transactionID then, no?
[ Parent | on HN ]
Re:State found $117k in double payments through data analytics by elhudy on Wednesday December 11, 2019 @02:40PM (#21765962)
Wouldn't think so. Each transaction ID would represent a unique transaction?

>Other double payments made by mistake included times that the state received multiple invoices.

I would assume each paid invoice was a new transaction ID. The real problem seems like there are two invoices being paid. Not that there are two transactions (which seems like just a symptom). It's possible that each invoice even has it's own ID.

[ Parent | on HN ]
Re:State found $117k in double payments through data analytics by mgraczyk on Wednesday December 11, 2019 @12:59PM (#21764989)
`>=`

8%?

[ Parent | on HN ]