Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania