| Data element |
Definition |
EDIT_CLERK
Indexed - no
Format - varchar2(128)
May be null? yes |
The user ID of the person who created the note.
|
EDIT_DATE
Indexed - no
Format - date
May be null? yes |
The date that the note was edited.
|
EDIT_TIMESTAMP
Indexed - no
Format - timestamp
May be null? yes |
The timestamp that the note was edited.
|
NOTE
Indexed - no
Format - varchar2(2000)
May be null? yes |
A note associated with a work request and phase.
|
NOTE_SEQ
Indexed - yes
Format - number(16)
May be null? no |
The sequence number of the note associated with the work request and phase. |
NOTE_TYPE
Indexed - yes
Format - varchar2(15)
May be null? yes |
The type of note associated with the work request and phase.
Values:
ASSET Asset-Related Note
CANCELED REASON Reason Work Order was canceled
CUSTOMER Customer feedback
FRES O&M FRES personnel notes
HOLD REASON Reason Work Order was put on hold
REPAIR COMMENTS Mechanic feedback
|
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.
|
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.
|
