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

Wall Material

Structure Inventory Wall Material field

Surface Cover

Structure Inventory Surface Type field

Depth

Structure Inventory Depth field

Cover Type

Structure Inventory Cover Type field

Street

Structure Inventory Street Name

Pipe Height

Pipe Inventory Diameter field

Pipe Type

Pipe Inventory Material field

Pipe Shape

Pipe Inventory Shape field

Joint Distance

Pipe Inventory Length field

Surface Type

Pipe Inventory Surface field

Date Inspected

TV Inspection Date Inspected field

Time Inspected

TV Inspection Time Inspected field

Crew

TV Inspection Crew field

Weather

TV Inspection Weather field

Flow Control

TV Inspection Flow Type field

Comment

TV Inspection Comments tab

Reason

TV Inspection Purpose field

Surveyed Footage

TV Inspection Max Obs Length field

Condition

TV Inspection Overall Condition field (Summary tab)

Pre-Cleaning

TV Inspection Other Maint. Prior field

 

 

 

Imported Observation Data

(goes into)

These Fields in Lucity

Distance

TV Observation Distance (ft)  field

SML

TV Observation Classification (PACP) field

Dimension 1

TV Observation Val Dim 1 field

Dimension 2

TV Observation Val Dim 2 field

Percentage

TV Observation Percent Loss field

Joint

TV Observation Location field

Severity

TV Observation Rating field- only right most character is used, this is only used when the rating is not setup for the code in the code setup table.

Comment

TV Observation Comment tab

Code

TV Observation Defect field-based on code matrix

Clock From

TV Observation Start Clock field

Clock To

TV Observation End Clock field

See Also

Granite XP

Code Setup

Import

Validate and Transfer