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