Penn Computing

Penn Computing

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

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

FRES Work Requests Collection Refresh Schedule

Work Request header and phase data (status, attributes, dates) is refreshed twice daily, on Monday through Friday evenings and again at 1:30pm each day (Monday-Friday). Note that the data collection is unvailable during the update, and attempts to query during that time will yield "ORA-00942 table or view does not exist" errors. Phase detail cost and hours data, is refreshed weekly, on Thursday evenings, coordinated with Facility Focus load to the General Ledger. Latest collection update status can be found on the Warehouse load status page.

Source of the Data
The data in the Data Warehouse that is accessible via the Business Objects FRES Work Request universe comes from the Facility Focus system. The universe also joins to related tables in the General Ledger and Space@Penn data collections.

Time Span Covered
The Data Warehouse stores current Faclities work request data, as well as historical information on FRES work requests. The data goes as far back as July 2008, and continues from that point. Note there may be incomplete information in the Warehouse for those work requests that were open in July 2009 at the time when the collection was implemented.

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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