WORK_REQUEST_PHASE Table - Data Element Index   Tables and Data Elements   FRES Work Requests Home   Data Warehouse Home

WORK_REQUEST_PHASE Table

Explanation
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.

Common Uses
Displaying informaton and summary costs related to individual phases of a Facilities work request.

PHASE
WR_NUMBER

CONTACT_PENN_ID
CUSTOMER_ORG
CUSTOMER_PENN_ID
PHASE
PHASE_PRIORITY
PHASE_STATUS
PROBLEM_CODE
SHOP
WORK_CODE
WR_ACCOUNTING_PERIOD_CREATED
WR_BUILDING_CODE
WR_CATEGORY
WR_FISCAL_MONTH_CREATED
WR_NUMBER
WR_STATUS
WR_TITLE
WR_TYPE

WORK_REQUEST_EXTRA_DESC
WORK_REQUEST_PHASE_DETAIL
WORK_REQUEST_PHASE_EXTRA_DESC
WORK_REQUEST_PHASE_HISTORY
WORK_REQUEST_PHASE_PO
WORK_REQUEST_PRIORITY_CODES
WORK_REQUEST_PROBLEM_CODES
WORK_REQUEST_STATUS_CODES
WORK_REQUEST_SUMMARY
WORK_REQUEST_WORK_CODES

Cautions

• 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.

WORK_REQUEST_PHASE Table - Data Element Index   Tables and Data Elements   FRES Work Requests Home   Data Warehouse Home