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