Database Reference
In-Depth Information
a description of the specific service to be performed, and the current status of the service. The table
also contains the estimated number of hours required to complete the service. For completed jobs, the table
contains the actual number of hours it took to complete the service. If another appointment is required to
complete additional service, the appointment date appears in the NextServiceDate column.
25
ServiceRequest
Service
Slip
Category Description
Status
Est
Spent Next
ID
ID
Num
Hours Hours
ServiceDate
1
1
3
Air conditioner
Technician has veriied
4
2
7/12/2013
periodically stops
the problem. Air
with code indicating
conditioning specialist
low coolant level.
has been called.
Diagnose and repair.
2
5
4
Fuse on port motor
Open
2
0
7/12/2013
blown on two occasions.
Diagnose and repair.
3
4
1
Oil change and general
Service call has been
1
0
7/16/2013
routine maintenance
scheduled.
(check luid levels, clean
sea strainers, etc.).
4
1
2
Engine oil level has been
Open
2
0
7/13/2013
dropping drastically.
Diagnose and repair.
5
3
5
Open pockets at base
Technician has
4
2
7/13/2013
of two stantions.
completed the initial
illing of the open pockets.
Will complete the job
after the initial ill has had
suficient time to dry.
6
11
4
Electric-lush system
Open
3
0
periodically stops
functioning. Diagnose
and repair.
7
6
2
Engine overheating.
Open
2
0
7/13/2013
Loss of coolant.
Diagnose and repair.
8
6
2
Heat exchanger not
Technician has determined
4
1
7/17/2013
operating correctly.
that the exchanger is
faulty. New exchanger
has been ordered.
9
7
6
Canvas severely
Open
8
0
7/16/2013
damaged in windstorm.
Order and install new
canvas.
10
2
8
Install new GPS and
Scheduled
7
0
7/17/2013
chart plotter.
11
2
3
Air conditioning unit
Technician not able to
1
1
shuts down with “HHH”
replicate the problem.
showing on the control
Air conditioning unit ran
panel.
ine through multiple
tests. Owner to notify
technician if the problem
recurs.
FIGURE 1-24
Sample data about service requests for Alexamara Marina Group
(continued)
