| 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 phase.
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
|
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_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
|
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_REQUEST_EXTRA_DESC
Indexed - no
Format - varchar2(70)
May be null? no |
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_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
|
