Imported Inspection/Survey Data
(goes into)
These Fields in Lucity
Address
Structure Inventory Street Address fields
Pipe Size
Pipe Inventory Diameter field
Pipe Material
Pipe Inventory Material field
WO Date
TV Inspection Date field
Inspector
TV Inspection Crew field
JTL
TV Inspection Percent Full field
VCR Tape
TV Inspection Tape ID field
Contractor
TV Inspection User 1 field
WO Number
TV Inspection Other Maint. Prior field
Tape Start
TV Inspection Counter Start field
Contract
TV Inspection User 5 field
Comment fields
TV Inspection Comments tab
Imported Observation Data
(goes into)
These Fields in Lucity
Footage
TV Observation Max Observation Length field
VITC
TV Observation VCR Counter field
At Clock
TV Observation Start Clock
To Clock
TV Observation End Clock
SEC Loss/Percent
TV Observation Percent Loss field
Diameter
TV Observation Lateral Diameter field
Comments/Descriptions
TV Observation Comments tab
Codes
If WRC is used, then the Location, Defect, and Rating fields (TV Observation) are obtained from the code matrix.
If WRC is NOT used, then the matrix is not used and the defect is assigned the description of the defect. These defect descriptions should already exist in the code list in the desktop.
The TV Observation Rating is assigned from the left most character in the Observ field (L= Rating 2, M= Rating 3, S or H= Rating 5). If the rating does not match any of these, the value is placed in the TV Observation User 5 field and the Lateral Location field.