Data Refresh Schedule
Data is captured from the FACTS, WSU ORG, BALANCES, HEPPS and PAPR systems, reformatted and loaded into the Financial Data Warehouse on a nightly basis. PBL data is normally updated monthly via feeds from the Budget Office. Endowment data is normally updated once per quarter via feeds from the Controllers Office.
Notes about Data Extraction
- Data that is necessary for historical reporting, is kept as a set or version of data called a "snapshot". For each snapshot, a new snapshot generation id is assigned. This id number is assigned to all snapshot records for that extraction.
- Data that does not need to have historical versions kept is simply replaced during each extraction with the most recent data.