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

WORK_REQUEST_PHASE_PO Table

Explanation
The WORK_REQUEST_PHASE_PO table contains information about purchase orders associated with work requests. Only purchase orders processed by BEN Financials will be represented.

Common Uses
Displaying information about purchase orders related to a particular work request phase.

FRES_WR_PO_CODE
PHASE
WR_NUMBER

FRES_WR_PO_CODE
PENN_PO_NUMBER
PHASE
PO_STATUS
VENDOR_NAME
VENDOR_NUMBER
WR_NUMBER
WR_TITLE

WORK_REQUEST_EXTRA_DESC
WORK_REQUEST_PHASE
WORK_REQUEST_PHASE_DETAIL
WORK_REQUEST_PHASE_EXTRA_DESC
WORK_REQUEST_PHASE_HISTORY
WORK_REQUEST_PRIORITY_CODES
WORK_REQUEST_PROBLEM_CODES
WORK_REQUEST_STATUS_CODES
WORK_REQUEST_SUMMARY
WORK_REQUEST_WORK_CODES

Cautions

• WORK_REQUEST_PHASE_PO contains summary status, amount and vendor information for BEN Financials purchase orders associated with work request phases. For purchase order details, review the PO in BEN Financials.
• The WORK_REQUEST_PHASE_PO Table is stored in the DWFS schema in the Data Warehouse.

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