Reference table containing current grant freeze data, which is updated nightly
from BEN Financials.
"Freeze grant" functionality in BEN Financials allows business administrators
and managers to limit activity against a grant both during the life of the project
and during the grant’s close-out or adjustment period. Authorized users
can designate an entire fund as frozen for all transaction sources (online journal
entries, new purchase orders, C-Forms, feeder systems, and Payroll) or for a
specific transaction source. BEN Financials will automatically freeze a grant
at project end for new purchase orders and at the end of the adjustment period
for all other transaction sources. Unfreeze and refreeze functionality is also
Grant accounts are frozen/unfrozen at the FUND level so that the freeze/unfreeze
action affects all combinations of the fund. Freezing an account has no affect
on being able to query or report on that account, only on being able to transact
against the account.
Retrieving the overall freeze status for a fund or the freeze status by transaction
source, including the date on which the transaction source was frozen.
||Indexed Data Elements
- This table contains only current freeze information for a fund. To
view the freeze history for a fund as well as designated refreeze dates, use
the FUND_FREEZE_HISTORY table.
- There will only be a record for a fund in this table if it has a current
- Note that there may be rows where the FUND_FREEZE value is 'N'. This indicates
that, for that row, the fund is not frozen for any source, but had been frozen
for at least one source at some point in the past. Only funds that have had
freeze activity at some point will exist in the FUND_FREEZE or FUND_FREEZE_HISTORY
- BEN Financials reports contain an additional freeze status value of 'D'
to indicate that a fund has been disabled. To report on a fund's enabled status
in the Warehouse, refer to the ENABLED data element in the FUND_CODES table.
- The FUND_FREEZE.ADJ_PERIOD_END_DATE column is updated only as freeze actions
for the fund occur. There may therefore be discrepancies between data in this
column and that stored in the column of the same name in the FUND_CODES table,
which is recalculated with any change to either the ACCOUNT_END or DAYS_TO_SUBMIT_FINAL_REPORT_CODE
for the fund.
- If you want to report on all funds for your organization, and join in freeze
data where available, perform an outer join to the FUND_CODES (or BALANCES
or other table) table on the FUND_CODE column (i.e., DWADMIN.FUND_FREEZE.FUND_CODE(+)=DWADMIN.FUND_CODES.FUND_CODE).
This join already exists in the Business Objects universe. To show only those
funds with freeze data, along with data from another table such as FUND_CODES
or BALANCES, be sure to set a condition of ' FUND_FREEZE.FUND_CODE is NULL'.
- Security for this table follows established Warehouse practices for reference
tables in the Financial Balances collection. As with BEN Financials access
to the same data, users with authorized access to the Balances collection
will be able to query the freeze status for a fund.
Questions about this page? Email us at email@example.com