Penn Computing

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

WORK_REQUEST_EXTRA_DESC Table - Data Element Index

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



Data element Definition
COMMENT_SEQ

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

A number indicating the sequence of the extra descriptive comment for the work request.

Facility Focus source: ae_p_dsc_h.seq

LAST_EDIT_DATE

Indexed - no
Format - date
May be null? yes

The date that the comment was edited.

Facility Focus source: ae_p_dsc_h.edit_date

WR_EXTRA_DESC

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

Continuation of WR_Title field. Should the initial description exceed the length of the Title, it would be stored in this field.

Facility Focus source: ae_p_dsc_h.comm

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_TITLE

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


WORK_REQUEST_EXTRA_DESC 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