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

WORK_REQUEST_PHASE_EXTRA_DESC Table

Explanation
The WORK_REQUEST_PHASE_EXTRA_DESC table contains text comments associated with work request phases.

Common Uses
Displaying comments associated with a particular work request phase.

COMMENT_SEQ
PHASE
WR_NUMBER

COMMENT_SEQ
PHASE
WR_NUMBER
WR_TITLE

WORK_REQUEST_EXTRA_DESC
WORK_REQUEST_PHASE
WORK_REQUEST_PHASE_DETAIL
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

• Extra description information is entered by customers using the FacilityFocus Web Portal. (Work Request Phase Notes, which are different from the extra description, are entered by FRES mechanics using mobile devices in the field, and are available in the WORK_REQUEST_PHASE_NOTES table.)
• For comments associated with the work request overall, refer to the WORK_REQUEST_EXTRA_DESC table.
• The WORK_REQUEST_PHASE_EXTRA_DESC Table is stored in the DWFS schema in the Data Warehouse.

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