Penn Computing

University of Pennsylvania
Penn Computing << go backback
FUND_STATUS Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

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.
FUND_STATUS Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania