Field Mapping

Below is a grid displaying where imported data is stored in the Lucity software. In other words, what fields the data is imported into. Some data from the inspection may not be used in the Lucity software.

Note: All images and movies are attached as documents to the inspection or observation. These files must be manually copied to their destination directory.

Imported Inspection/Survey Data

(goes into)

These Fields in Lucity

MH Depth

Structure Inventory Depth field

Map Number 1

Structure Inventory Map Page field

MH Surface Type

Structure Inventory Surface Type field

MH Type

Structure Inventory Type field

Pipe Diameter

Pipe Inventory Diameter field

Pipe Protection

Pipe Inventory Liner field

Pipe Material

Pipe Inventory Material field

Section Length Feet

Pipe Inventory Length field

Pipe Length

Pipe Inventory Pipe Sec. Length field

Pipe Profile

Pipe Inventory Shape field

Memo

TV Inspection Comments tab

Situation

TV Inspection Surface Condition field

Save 1

TV Inspection Other Maint. Prior field

Reason for Inspection

TV Inspection Purpose field

Operator

TV Inspection Crew field

Inspection Start Time

TV Inspection Counter Start field

Inspection End Time

TV Inspection Counter End field

VCR Number

TV Inspection Tape ID field

Weather

TV Inspection Weather field

Date

TV Inspection Date Inspected field

Cleaned?

TV Inspection Other Maint. Prior field(s)

(Y= Clean Prior field, "Clean Prior"= Clean Prior field, "Root Cut Prior"= Root Cut Prior field, etc.)

 

 

 

Imported Observation Data

(goes into)

These Fields in Lucity

Position

TV Observation Distance (ft) field

Clock Position 1

TV Observation Start Clock field

Clock Position 2

TV Observation End Clock field

VCR Position

TV Observation VCR Counter field

Code

TV Observation Location, Defect, Rating fields- based on the code matrix

Level

TV Observation Rating if not already specified in the matrix

Text

TV Observation Comments tab

See Also

Pipetech, Subcam, and WinCan

Code Setup

Import

Validate and Transfer