Wachs Vitals - Page 222

Vitals Reference Manual
216 Part No. 79-MAN-04, Rev. I E.H. Wachs
Field size is in characters
unless specified otherwise.
Field names marked with an
asterisk (*) must not be
deleted from the Vitals data-
base structure. If you are
editing the database struc-
ture, do not remove these
fields. Removing these
fields will cause database
errors.
NOTE: The Remarks field contains remarks that the user
has selected on the handheld controller while performing an
activity.
NOTE
CAUTION
Valves Table
Field Name Data Type Size
ValveId* Text 20
Size* Double 8 bytes
NormPosn* Text 10
Close Dir* Text 10
Condition* Text 20
Type* Text 20
Depth* Integer 2 bytes
Street* Text 20
Cross Street* Text 20
Notes* Memo 64000
Latitude Double 8 bytes
Longitude Double 8 bytes
Activities Table
Field Name Data Type Size
ValveId* Text 20
Date* Date 8
OperatedBy* Text 10
Turns* Double 8 bytes
Position* Text 10
HighTorque* Integer 2 bytes
Begin Time* Text 10
End Time* Text 10
Remarks* Text 100
Latitude* Double 8 bytes
Longitude* Double 8 bytes
GPS Positions* Integer 2 bytes
ACtivityId* Long Integer 4 bytes
TransferId* Text 20
TorqueCharts
Table
Field Name Data Type Size
ActivityID* Number 2147483647
Max Value
ChartData* Memo 64000