Contents of HR-BAIRS Data Warehouse
Yesterday's Data
HR-BAIRS is loaded nightly (Monday through Friday)with date from HRMS. Data in the warehouse is a "mirror" of data in HRMS at the close of business the previous day. On Mondays, HR-BAIRS contains data from HRMS at the close of business on Friday. Data entered in HRMS over the weekend is not posted to HR-BAIRS until Tuesday morning.
Corrected Rows
HRMS's correction mode allows certain users to overwrite data in previously entered records, and insert rows into the past (history). Only HR Data Services has correction capability. Data Services can be reached at hrmshelp@berkeley.edu or 510.643.4443
In some data warehouse models, "snapshots" of a large database (such as that of HRMS) are archived, so that a user can go back to an old snapshot and see what the database actually looked like -- erroneous rows and all -- on a prior date. HR-BAIRS does not work like this. Instead, during the nightly HR-BAIRS refresh, all rows of data are rebuilt from the data currently in HRMS. If a row in HRMS has been corrected, the corrected data will be the one that appears in HR-BAIRS reports the next morning and from that time forward.
For audit-trail purposes, separate records of corrections to HRMS are extracted and stored outside the HR-BAIRS database. These stored transactions are available to Berkeley's Audit and Advisory Services Department as necessary.