FUND_FREEZE Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Ledger Home

FUND_FREEZE Table

Explanation

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 included.

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.

Common Uses
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.

FUND_CODE

FUND_CODE

BALANCES

FUND_CODES

FUND_FREEZE_HISTORY

Cautions

• 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 freeze status.
• 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 tables.
• 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.

FUND_FREEZE Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Ledger Home