Penn Computing

University of Pennsylvania
Penn Computing << go backback
WORK_REQUEST_STATUS_CODES Table   Tables and Data Elements   FRES Work Requests   Data Warehouse Home

WORK_REQUEST_STATUS_CODES Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
WR_CATEGORY_CODE

Indexed - yes
Format - varchar2(5)
May be null? no

A grouping of types of work requests. Example categories are Corrective Maintenance, Events and Small Projects.

Facility Focus source: ae_s_cat_c.category

WR_CATEGORY_DESC

Indexed - no
Format - varchar2(40)
May be null? yes

The description corresponding to the Category Code.

Facility Focus source: ae_s_cat_c.catdsc

WR_STATUS

Indexed - yes
Format - varchar2(10)
May be null? no

Statuses are defined by FRES based on the way work is processed within the organization. Statuses are selected by the authorized user of the system as the work changes from first being accepted to lastly being closed out. Statuses are specific to each category of work in the Work Management module, such as maintenance, corrective, or events, and thus mirror a specific workflow process. The work request itself has a set of statuses as does each phase.

Facility Focus source: ae_p_pro_e.status_code

WR_STATUS_DESC

Indexed - no
Format - varchar2(40)
May be null? yes

The description corresponding to the work request status.

Facility Focus source: ae_p_sta_c.dsc

WR_TYPE_CODE

Indexed - yes
Format - varchar2(1)
May be null? no

The type denotes the funding source of your request. Most maintenance requests are Type N or non-allocated cost. There is no direct charge to you. If work is performed in a customer owned building, the Type is C or COM for customer. If your request requires that you pay for the work requested, it will be Type P or CPW for customer paid work.

Facility Focus source: ae_p_def_e.wr_type

WR_TYPE_DESC

Indexed - no
Format - varchar2(40)
May be null? yes

The description corresponding to the type code.

Facility Focus source: ae_p_def_e.type_desc


WORK_REQUEST_STATUS_CODES Table   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