Penn Computing

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

WORK_REQUEST_PHASE_HISTORY Table - Data Element Index

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



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, at the phase level.


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

HISTORY_STATUS

Indexed - no
Format - char(1)
May be null? yes
The 1-character code that indicates whether the WORK_REQUEST_PHASE_HISTORY record is Current (C) or History (H). Records with a History_Status of "C" reproduce the WORK_REQUEST_PHASE records as they currently exist in the Facility Focus system. Records with a History_Status of "H" represent earlier versions of the data. (See also History_Status_Date.)

Values:

C     Current (that is, the most recent in 

      the Facility Focus system)

H     History

HISTORY_STATUS_DATE

Indexed - yes
Format - date
May be null? no
Date on which the record became history, generated upon the record load to the Warehouse.
LABOR_COST_EST

Indexed - no
Format - number(18,4)
May be null? yes

Estimated labor cost, at the phase level.


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, at the phase level.

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, at the phase level.

Facility Focus source: ae_p_phs_e.tot_mat

PART_CODE

Indexed - no
Format - varchar2(25)
May be null? no

An equipment class defined for a group of unique assets that are serviced at scheduled intervals.


PHASE

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

Phases define the tasks and costs involved in performing the requested work. Each phase is associated with one trade or housekeeping shop. Although not mandatory, phase one should occur before phase two, and so on, as a logical way of ordering the steps in a job. The number of phases in a single work request is unlimited.

Facility Focus source: ae_p_phs_e.sort_code

PHASE_ACCOUNTING_PERIOD_CLOSED

Indexed - yes
Format - varchar2(6)
May be null? yes
The GL accounting period in which the phase was closed. This column will be populated based on the PHASE_CLOSED_DATE, which will be populated for any phases with status of 70 or greater (cancelled, complete, or closed).
PHASE_CLOSED_DATE

Indexed - no
Format - date
May be null? yes

The date on which the phase was closed. This column will be populated with the PHASE_STATUS_DATE for any phases with status of 70 or greater (cancelled, complete, or closed).

PHASE_DESC

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

The explanation of the task required for each particular phase.

Facility Focus source: ae_p_phs_e.phsdsc

PHASE_EST_END_DATE

Indexed - no
Format - date
May be null? yes

Estimated end date for the work defined in that phase.

Facility Focus source: ae_p_phs_e.end_date

PHASE_EST_START_DATE

Indexed - no
Format - date
May be null? yes

Estimated start date for the work defined in that phase.

Facility Focus source: ae_p_phs_e.beg_date

PHASE_FISCAL_MONTH_CLOSED

Indexed - yes
Format - varchar2(2)
May be null? yes
The fiscal month sequence in which the phase was closed. This column will be populated based on the PHASE_CLOSED_DATE, which will be populated for any phases with status of 70 or greater (cancelled, complete, or closed).
PHASE_FLOOR

Indexed - no
Format - char(8)
May be null? yes

Identifies the floor within the building associated with the work request.

Facility Focus source: ae_p_phs_e.flr_id

PHASE_FY_CLOSED

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

The fiscal year in which the phase was closed. This column will be populated based on the PHASE_CLOSED_DATE, which will be populated for any phases with status of 70 or greater (cancelled, complete, or closed).

PHASE_PRIORITY

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

Estimated end date for the work defined in that phase.

Facility Focus source: ae_p_phs_e.end_date

PHASE_ROOM

Indexed - no
Format - char(16)
May be null? yes

Estimated start date for the work defined in that phase.

Facility Focus source: ae_p_phs_e.beg_date

PHASE_STATUS

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

The status of the phase. 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


PHASE_STATUS_DATE

Indexed - no
Format - date
May be null? yes

The date on which the phase status went into effect.

PROBLEM_CODE

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

A code which helps define the situation involved in the request for work.

Facility Focus source: ae_p_phs_e.problem_code

SHOP

Indexed - yes
Format - varchar2(15)
May be null? yes

The trade (e.g., CARP, AC, ELEC) to which the phase has been assigned.

Facility Focus source: ae_p_phs_e.shop

WORK_CODE

Indexed - yes
Format - varchar2(15)
May be null? yes

An identifier of the kind of work to be performed, such as core change, filters, etc. It is the granularity of a skilled set or craft.

Facility Focus source: ae_p_phs_e.craft_code

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


WORK_REQUEST_PHASE_HISTORY 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