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

WORK_REQUEST_PHASE_HISTORY Table

Explanation
The WORK_REQUEST_PHASE_HISTORY table contains historical information about work request phases.

Common Uses
Displaying changes in status or other attributes for a particular work request and phase, over time.

HISTORY_STATUS_DATE
PHASE
WR_NUMBER

CONTACT_PENN_ID
CUSTOMER_ORG
CUSTOMER_PENN_ID
HISTORY_STATUS_DATE
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
WORK_REQUEST_PHASE_DETAIL
WORK_REQUEST_PHASE_EXTRA_DESC
WORK_REQUEST_PHASE_PO
WORK_REQUEST_PRIORITY_CODES
WORK_REQUEST_PROBLEM_CODES
WORK_REQUEST_STATUS_CODES
WORK_REQUEST_SUMMARY
WORK_REQUEST_WORK_CODES

Cautions

• Contains historical information about work request phases, without amounts, for status changes since July 2009, when the data collection was implemented.
• Created by comparing WORK_REQUEST_PHASE record to the Facility Focus extract file; when the corresponding record in extract file has changed , the old row is written to WORK_REQUEST_PHASE_HISTORY, and the history status date is populated with the date of the record is loaded to the table.
• The WORK_REQUEST_PHASE_HISTORY Table is stored in the DWFS schema in the Data Warehouse.

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