What do the FullFund scripts do?
- Product: Voyager
- Product Version: All
- Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care
Question
What do the FullFund scripts (FullFundPendingExpenditures3.sql, FullFundPendingCommitments3.sql, FullFundExpenditures.sql, FullFundCommitments3.sql, FullFundDiagnostic.sql) do?
Answer
FullFundDiagnostic.sql can be run regularly to help identify any discrepancies in FUND.COMMIT_PENDING, FUND.COMMITMENTS, FUND.EXPEND_PENDING, and FUND.EXPENDITURES.
Based on the results of the diagnostic any or all of the following would be run to correct the relevant total.
|
FullFundPendingCommitments3.sql |
recalculates the pending commitments and updates the fund summary totals (FUND.COMMIT_PENDING) |
|
FullFundCommitments3.sql |
recalculates the commitments and updates the fund summary totals (FUND.COMMITMENTS) |
|
FullPendingFundExpenditures3.sql |
recalculates pending expenditures and updates summary totals (FUND.EXPEND_PENDING) |
|
FullFundExpenditures.sql |
recalculates expenditures and updates summary totals (FUND.EXPENDITURES) |
Additional Information
See also:
- Fund discrepancies - totals displayed in Acquisitions not accurate
- Overview of Voyager Acquisitions Fund Diagnostic and Repair Workflow
- Article last edited: 08-Oct-2013