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

WORK_REQUEST_PHASE_NOTES Table

Explanation
The WORK_REQUEST_PHASE_NOTES table contains notes associated with work request phases.

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

NOTE_SEQ
PHASE
WR_NUMBER

NOTE_SEQ
NOTE_TYPE
PHASE
WR_NUMBER

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

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

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