| 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.
|
NOTE_SEQ
Indexed - yes
Format - number(16)
May be null? no |
The sequence number of the note associated with the work request. |
NOTE_TYPE
Indexed - yes
Format - varchar2(15)
May be null? yes |
The type of note associated with the work request.
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
|
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.
|
