acq.all_fund_encumbrance_total (view)

↑ acq schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

Column	Type	Nullable	Notes
fund	`integer`	Yes
amount	`numeric`	Yes

fund

integer

Yes

amount

numeric

Yes

View Definition

 SELECT f.id AS fund,
    COALESCE(encumb.amount, 0::numeric) AS amount
   FROM acq.fund f
     LEFT JOIN ( SELECT fund_debit.fund,
            sum(fund_debit.amount) AS amount
           FROM acq.fund_debit
          WHERE fund_debit.encumbrance
          GROUP BY fund_debit.fund) encumb ON f.id = encumb.fund;