Penn Computing

University of Pennsylvania
Penn Computing << go backback
WORK_REQUEST_EXTRA_DESC Table - Data Element Index   Tables and Data Elements   FRES Work Requests Home   Data Warehouse Home

WORK_REQUEST_EXTRA_DESC Table

Explanation
The WORK_REQUEST_EXTRA_DESC table contains text comments associated with work requests.

Common Uses
Displaying comments associated with a particular work request.

Primary Key Indexed Data Elements Related Tables
COMMENT_SEQ
WR_NUMBER
COMMENT_SEQ
WR_NUMBER
WORK_REQUEST_PHASE
WORK_REQUEST_SUMMARY

Cautions

  • Extra description information is entered by customers using the FacilityFocus Web Portal. (Work Request 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_NOTES table.) .
  • For comments associated with a particular phase of the work request, refer to the WORK_REQUEST_PHASE_EXTRA_DESC table.
  • The WORK_REQUEST_EXTRA_DESC Table is stored in the DWFS schema in the Data Warehouse.
WORK_REQUEST_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