The WORK_REQUEST_PHASE_HISTORY table contains historical information about work request phases.
Displaying changes in status or other attributes for a particular work request and phase, over time.
||Indexed Data Elements
- Contains historical information about work request phases, without amounts, for status changes since July 2009, when the data collection was implemented.
- Created by comparing WORK_REQUEST_PHASE record to the Facility Focus extract file; when the corresponding record in extract file has changed , the old row is written to WORK_REQUEST_PHASE_HISTORY, and the history status date is populated with the date of the record is loaded to the table.
- The WORK_REQUEST_PHASE_HISTORY Table is stored in the DWFS schema in the Data Warehouse.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania