Contains status, by fund and organization, for sponsored project funds for each
accounting period from fiscal year 1999 (JUL-98) onwards. The calculation of
status is performed at the time Balances data are extracted to the Data Warehouse,
and is based on BEN Financials report logic.
Determining whether a sponsored project fund is active, for a given child organization
and accounting period, for purposes of footing to BEN Financials reports.
||Indexed Data Elements
- STATUS should not be confused with the ENABLED flag in the FUND_CODES table.
Requirements for a fund to be considered inactive are more stringent then
those for a fund to be disabled. Refer to the documentation for the STATUS
data element for the complete logic.
- FUND_STATUS is updated in the Data Warehouse on a weekly basis (as part
of the BALANCES refresh), while BEN Financials calculates a sponsored project
fund's active status at the time a report is run. Therefore, if you want to
compare your Warehouse query results to a BEN Financials report, you should
run your BEN Financials report at the start of business for the week to match
Warehouse data retrieved from that point through the week, until the next
- It is possible in BEN Financials for fund status to be calculated at the
Program and CREF levels, although the Warehouse calculation is only performed
to the ORG level.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania