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

WORK_REQUEST_PART_CODES Table

Explanation
The WORK_REQUEST_PART_CODES table is the reference table for part codes related to work requests. A part code refers to an equipment class defined for a group of unique assets that are serviced at scheduled intervals.

Common Uses
Displaying the description of a work request part code. ("Don't show the codes in the report. Show the English instead.")

WR_PART_CODE

WR_PART_CODE

WORK_REQUEST_PHASE
WORK_REQUEST_PHASE_HISTORY

Cautions

• The WORK_REQUEST_PART_CODES table is stored in the DWFS schema in the Data Warehouse.

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