FUND_STATUS Table
Explanation
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.
Common Uses
Determining whether a sponsored project fund is active, for a given child organization
and accounting period, for purposes of footing to BEN Financials reports.
| Primary Key |
Indexed Data Elements |
Related Tables |
FUND_STATUS_PK
|
ACCOUNTING_PERIOD
CALENDAR_MONTH
CALENDAR_YEAR
FISCAL_MONTH
FUND_CODE
ORGANIZATION_CODE
|
BALANCES
BUDGET_PERIODS
FUND_CODES
|
Cautions
- 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
weekend's update.
- 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 da-staff@isc.upenn.edu
|
