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

WORK_REQUEST_PHASE_DETAIL Table

Explanation
The WORK_REQUEST_PHASE_DETAIL table contains accounting detail related to particular work request phases. There is one row per work request number, phase, chart of accounts number, transaction type, subledger code, and last extract date.

Common Uses
Displaying details of costs and hours worked for particular work request phases.

WR_PHASE_DETAIL_PK

COA_CNAC
COA_CREF
COA_FUND
COA_OBJECT
COA_ORG
COA_PROGRAM
COA_RESPONSIBLE_ORG
PHASE
WR_NUMBER
WR_PHASE_DETAIL_PK
WR_TITLE

WORK_REQUEST_EXTRA_DESC
WORK_REQUEST_PHASE
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 for use in the Data Warehouse by Facility Focus posting date, transaction type, subledger, and chart of accounts number.
• Data are extracted from Facility Focus and loaded to the Warehouse on Thursday nights, coordinated with Facility Focus load to the General Ledger.
• The WORK_REQUEST_PHASE_DETAIL Table is stored in the DWFS schema in the Data Warehouse.

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