Reporter source Payments: All excludes anonymized transactions

[Lindsay Stratton]

Evergreen 3.6

Payments: All source links to the action.circulation table not action.all_circulation. This excludes anonymized transactions when attempting to display data linked from the Billable Transaction --> Circulation Billing links.

Example report - display payment accepting library, payment year, billed patron profile, sum amount collected.

The same basic query looking at payment types rather than patron profile works as expected.

Table joins from generated SQL for query:
SELECT * FROM (SELECT "198f9d6731e29169fa0366b47672bbbe"."shortname" AS "Payment Accepting LIB",
 (EXTRACT(YEAR FROM "005ba04582862d42145cc618bbdb0119"."payment_ts") || '-' || LPAD(EXTRACT(MONTH FROM "005ba04582862d42145cc618bbdb0119"."payment_ts")::text,2,'0')) AS "Payment Year",
 "45732b5bf748e53665de350f6c551241"."name" AS "Patron Profile",
 SUM("005ba04582862d42145cc618bbdb0119"."amount") AS "Amount Collected"
  FROM money.all_payments AS "005ba04582862d42145cc618bbdb0119"
 INNER JOIN actor.workstation
 INNER JOIN actor.org_unit
 INNER JOIN money.billable_xact
 LEFT OUTER JOIN action.circulation
 LEFT OUTER JOIN actor.usr
 LEFT OUTER JOIN permission.grp_tree