• 0 Posts
  • 2 Comments
Joined 6 months ago
cake
Cake day: August 14th, 2024

help-circle
  • The thing is that it’s difficult to even get a complete picture because they release so little data.

    One screenshot I saw had the PIID in the shot so I looked it up. Doofus indicated he saved $8.2M but that was the total amount for the outlay.

    The contract began in 2022 and had already paid out 80% the total $8.2M, meaning only $1.64M was actually “saved”.

    So I know for a fact that the values they’re reporting aren’t correct because they’re looking at these contracts and having no clue on how to actually read them.

    As for the SSN thing where we’re paying 150 year old social security. There’s likely another table with “in question” that has to be joined to get an actual number.

    When I worked for my state this is how we had some data. A master table that you then had to join like five or six exception tables to remove the “questionable” entries from the master.

    And on systems like AS400, EXCEPTION JOIN is a thing for a reason because the OS SQL engine has special ways to optimize these kinds of joins. So it’s likely this is the case here.