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

Depth

Structure Inventory Depth field

Cover Level

Structure Inventory Grade field

Node Type

Structure Inventory Type field

Street Number/Direction/Road Name/Suffix/Post Direction

Structure Inventory Street fields

Location

Structure Inventory User 1 field

Drawing Number

Structure Inventory Drawing Number field

X Coord.

Structure Inventory X Coord field

Y Coord.

Structure Inventory Y Coord. field

Pipe Size

Pipe Inventory Diameter field

By Size

 

Pipe Inventory Width field

Pipe Section Length

Pipe Inventory Pipe Sec Length field

Surface Type

Pipe Inventory Surface field

Design Grade

Pipe Inventory Slope field

Material

Pipe Inventory Material field (WRC standard)

Lining

Pipe Inventory Liner field (WRC standard)

Shape

Pipe Inventory Shape field (WRC standard)

Start Date

TV Inspection Date field

Operator

TV Inspection Crew field

Comments

TV Inspection Comments tab

Cassette Number

TV Inspection Tape ID field

Purpose

TV Inspection Purpose field

Weather

TV Inspection Weather field

Pre-Cleaning

TV Inspection Other Maint. Prior field

 

 

 

Imported Observation Data

(goes into)

These Fields in Lucity

VCR Tape Time

TV Observation VCR Counter field

Counter

TV Observation Distance (ft) field

ObsCod

TV Observation Defect field--This is the field that is linked to the Flexidata code database that was setup in the initial code setup.

Intrusion

TV Observation Val Dim 1 field

Percent

TV Observation Percent Loss field

Remarks

TV Observation Comments tab

Dimension

TV Observation Lateral Diameter field

Severity

TV Observation Rating field (L= rating 2, M= rating 3, S= rating 5), otherwise it uses whatever rating is in the field.

Clock From

TV Observation Start Clock field

Clock To

TV Observation End Clock field

See Also

Flexidata

Code Setup

Import

Validate and Transfer