| Data element |
Definition |
CONTACT_EMAIL
Indexed - no
Format - varchar2(50)
May be null? yes |
The email address of the contact person for the work request.
Facility Focus source: ae_p_pro_e.contact_mc
|
CONTACT_NAME
Indexed - no
Format - varchar2(25)
May be null? yes |
The Point of Contact (POC) for the work to be completed.
Facility Focus source: ae_p_pro_e.contact
|
CONTACT_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
For work requests generated via customer requests, this field containts the Penn ID of the contact person for the work request; for work requests from other sources, the value will be null.
Facility Focus source: ae_p_req_e.login
|
CONTACT_PHONE
Indexed - no
Format - varchar2(15)
May be null? yes |
The phone number of the contact person for the work request.
Facility Focus source: ae_p_pro_e.contact_ph
|
CONT_SVCS_COST_EST
Indexed - no
Format - number(18,4)
May be null? yes |
Estimated contracted services cost, for the entire work request.
Facility Focus source: ae_p_phs_e.tot_oth
|
CUSTOMER_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The organization code associated with the work request. For work requests initiated by students, this column will be null.
Facility Focus source: ae_p_pro_e.requestor
|
CUSTOMER_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
The student Penn ID associated with the work request. For work requests initiated by faculty or staff, this column will be null.
Facility Focus source: ae_p_pro_e.requestor
|
DIFFERENTIAL_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Shift differential hours, for the entire work request. |
EXTERNAL_CHARGE_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Amount of external charges, for the entire work request. |
LABOR_COST_EST
Indexed - no
Format - number(18,4)
May be null? yes |
Estimated labor cost, for the entire work request.
Facility Focus source: ae_p_phs_e.tot_lab
|
LABOR_HR_EST
Indexed - no
Format - number(18,4)
May be null? yes |
Estimated labor hours, for the entire work request.
Facility Focus source: ae_p_phs_e.tot_hrs
|
MATERIALS_COST_EST
Indexed - no
Format - number(18,4)
May be null? yes |
Estimated materials cost, for the entire work request.
Facility Focus source: ae_p_phs_e.tot_mat
|
NON_STOCK_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Non-stock cost, for the entire work request. |
OVERTIME_LABOR_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Overtime labor cost, for the entire work request. |
OVERTIME_LABOR_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Overtime labor hours, for the entire work request. |
REGULAR_LABOR_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Regular labor cost, for the entire work request. |
REGULAR_LABOR_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Regular labor hours, for the entire work request. |
TOTAL_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Total cost, for the entire work request. |
TOTAL_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Total hours, for the entire work request. |
WR_ACCOUNTING_PERIOD_CLOSED
Indexed - yes
Format - varchar2(6)
May be null? yes |
The GL accounting period in which the work request as a whole was closed. This column will be populated based on the WR_CLOSED_DATE, which will be populated for any work requests with status of 70 or greater (cancelled, complete, or closed).
|
WR_ACCOUNTING_PERIOD_CREATED
Indexed - yes
Format - varchar2(6)
May be null? yes |
The GL accounting period in which the work request was created.
|
WR_BUILDING_CODE
Indexed - yes
Format - char(16)
May be null? yes |
The unique identifier of the building site that requires the work being requested.
Facility Focus source: ae_p_pro_e.bldg
|
WR_CATEGORY
Indexed - yes
Format - varchar2(5)
May be null? yes |
A grouping of types of work requests. Example categories are Corrective Maintenance, Events and Small Projects.
Facility Focus source: ae_p_pro_e.category |
WR_CLOSED_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the work request as a whole was closed. This column will be populated based on the WR_STATUS_DATE, which will be populated for any work requests with status of 70 or greater (cancelled, complete, or closed).
|
WR_ENTRY_DATE
Indexed - no
Format - date
May be null? yes |
The date the work request was originally created.
Facility Focus source: ae_p_pro_e.ent_date
|
WR_FISCAL_MONTH_CLOSED
Indexed - yes
Format - varchar2(2)
May be null? yes |
The fiscal month sequence in which the work request as a whole was closed. This column will be populated based on the WR_CLOSED_DATE, which will be populated for any work requests with status of 70 or greater (cancelled, complete, or closed).
|
WR_FISCAL_MONTH_CREATED
Indexed - yes
Format - varchar2(2)
May be null? yes |
The fiscal month sequence in which the work request was created.
|
WR_FY_CLOSED
Indexed - no
Format - varchar2(4)
May be null? yes |
The fiscal year in which the work request as a whole was closed. This column will be populated based on the WR_CLOSED_DATE, which will be populated for any work requests with status of 70 or greater (cancelled, complete, or closed).
|
WR_FY_CREATED
Indexed - no
Format - varchar2(4)
May be null? yes |
The fiscal year in which the work request was created.
Facility Focus source: ae_p_pro_e.program_fy
|
WR_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? no |
The unique number for the work request. It is the number the customer will receive, via email from a FRES customer service rep, letting him/her know that the work has been approved and is going to be placed on a schedule. It remains with the work request through its life.
Facility Focus source: ae_p_pro_e.proposal
|
WR_STATUS
Indexed - yes
Format - varchar2(10)
May be null? yes |
The status of the work request as a whole.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_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the work request status went into effect.
|
WR_TITLE
Indexed - yes
Format - varchar2(40)
May be null? yes |
A description of the situation. For example, ‘my bathroom sink is clogged’. If this is a request for chargeable work, the account that is being charged is also in this field.
Facility Focus source: ae_p_pro_e.title
|
WR_TYPE
Indexed - yes
Format - varchar2(1)
May be null? yes |
The type denotes the funding source of the request. Most maintenance requests are Type N or non-allocated cost. There is no direct charge to the client. 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_pro_e.order_type |
