FRES Work Requests Collection Refresh Schedule
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.