The WORK_REQUEST_PHASE table contains information about Facilities work request tasks and costs at the phase level. Phases define the tasks and costs involved in performing the requested work. Each phase is associated with one trade or housekeeping shop. Although not mandatory, phase one should occur before phase two, and so on, as a logical way of ordering the steps in a job. The number of phases in a single work request is unlimited.
Displaying informaton and summary costs related to individual phases of a Facilities work request.
||Indexed Data Elements
- Amounts are summarized to the phase level; only most current information is stored here - the WORK_REQUEST_PHASE_HISTORY table stores changes to phase data over time.
- The WORK_REQUEST_PHASE 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