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

WORK_REQUEST_SUMMARY Table

Explanation
The WORK_REQUEST_PHASE table contains information about Facilities work request tasks and costs.

Common Uses
Displaying summarized information about a particular work request.

WR_NUMBER

CONTACT_PENN_ID
CUSTOMER_ORG
CUSTOMER_PENN_ID
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
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_WORK_CODES

Cautions

• Amounts are summarized to the work request level; for phase-level detail, see the WORK_REQUEST_PHASE table.
• The WORK_REQUEST_SUMMARY Table is stored in the DWFS schema in the Data Warehouse.

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