• It depends on who is asking what question. For example: a wrongfully terminated employee (Bob) is reinstated and his personnel record is supposed to be "cleared". If someone runs a report of employees with negative actions, Bob should not appear on report. If someone else runs a report to determine staffing levels on a date between Bob's firing and reinstatement then Bob should not be on the list. If someone wants to run a report of wrongfully terminated employees then like duh, Bob should be on that list.

    Some things are done on a timely basis and some are not. Hiring is usually done in real time but separations frequently are not. Before the final check can be cut their leave has to be audited to be sure of how many hours of unused leave must be paid; some companies do not pay final commissions until 30 days later in case a big purchase is returned.

    Most times and places preserving the "raw" data in the "historical ODS" but having "corrected" data in the Data Marts works pretty well.