Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

Current Load Status
Regular Availability
FAQs & Tips
Password Changer
Support services
About the Data Warehouse
Data Administration
Express Mail
General Ledger
Learning Management
Position Inventory
Research-PennERA Proposals
Research Inventory
Salary Management
Travel Expense Management
Tuition Distribution
World Travel

PennERA Proposals Collection Snapshot Dates

·Back to the documentation on PennERA Proposals Collection Snapshots 

The PennERA Proposals snapshot is taken annually, and is identified by the snapshot fiscal year--the latest closed fiscal year as of the date when the snapshot job was run. (The University's fiscal year runs from July 1 through June 30. For example, fiscal year 2005 ended on June 30, 2005.) The snapshot fiscal year is stored in SNAPSHOT_FY in the snapshots of the PennERA Proposals tables, and in SPFY_SNAP_FY in the snapshots of the reference tables for the BALANCES table (in the General Ledger data collection).

The snapshot is not automatically scheduled, but is run upon Data Administration's request--usually in January. For example, in January, 2007, the data for snapshot fiscal year 2006 was loaded in the Warehouse. (By January, 2007, for most of the proposals submitted during fiscal year 2006, the sponsors had let the University know whether they had awarded funding or not.)

Two batch jobs are used to take the snapshot. One job takes the snapshot of the reference tables for the BALANCES table. The other job takes the snapshot of the PennERA Proposals tables. In each record of a snapshot table, the snapshot date indicates when the snapshot of the record was taken. (The snapshot date is stored in SNAPSHOT_DATE in the snapshots of the PennERA Proposals tables, and in SPFY_SNAP_DATE in the snapshots of the reference tables for the BALANCES table.) Because the two snapshot jobs are often run on different days, and each of the jobs can take some time to run, the value for the snapshot date can differ from record to record for a given snapshot. The snapshot date for a given snapshot is the latest (max) snapshot date for all of the records for the snapshot fiscal year in all of the tables that are included in the snapshot.

The following table provides the snapshot date for each PennERA Proposals snapshot that has been taken since PennERA was implemented (October 14, 2003).

Snapshot Fiscal Year Snapshot Date
2012 February 4, 2013
2011 January 31, 2012
2010 February 4, 2011
2009 January 29, 2010
2008* June 10, 2009
2007 January 31, 2008
2006 January 12, 2007
2005 December 22, 2005
2004 February 1, 2005

* Note: Use caution when comparing success rates for other snapshot fiscal years with the rates for snapshot fiscal year 2008. The 2008 snapshot seems to have a greater success rate because the sponsors had more time to notify the University about awards before the snapshot was taken. For example, for proposals submitted in June, 2008, the sponsors had almost 12 months to notify the University about awards before the snapshot was taken; for proposals submitted in June in other years, they had about 6 months.


Information Systems and Computing
University of Pennsylvania
Comments & Questions

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