Dye Test Survey Data Fields

Information relating to a Dye Test Survey can be viewed and edited on the Dye Test Grid Window of the Survey Grid or the Dye Test Property Sheet.

To view and edit all dye test survey data, use the Property Sheet.

The following describes all the data which can be used to define a dye test survey.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

Dye Test Survey Data

Database Table Name: cams_dye_test

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

Precision

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

ID

Unique identifier for the survey. This is based on the associated monitored pipe by default.

id

Text

40

 

0

 

 

 

 

 

Date

Survey date.

date

Date / Time

 

 

0

 

 

 

 

 

Status

The current status of the survey in relation to completion:

Database Value

Description

PLAN

Planned

ONGOING

Ongoing

COMP

Complete

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

status

Text

32

 

0

 

 

 

 

 

Location

Address / Description of the location of the monitored pipe.

location

Text

100

 

0

 

 

 

 

 

Injection method

Database Value

Description

DRAIN

Storm Drain

FLOOD

Ground Flooding

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

inj_method

Text

32

 

0

 

 

 

 

 

Surface type

The type of surface:

Database Value

Description

Road

Road

Pavement

Pavement

Field

Field

Unpaved

Unpaved

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

ground_condition

Text

20

 

0

 

 

 

 

 

Defects found

Check box used to indicate whether any defects were observed as a result of the survey.

defects_found

Boolean

 

 

3

 

 

 

 

 

Comments

Any additional comments relating to the survey.

comments

Text

64

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Job number

Job reference number.

job_number

Text

32

 

0

 

 

 

 

 

PLR / asset ID

Pipe reference code.

plr

Text

40

 

0

 

 

 

 

 

Before flood time

Time before dye is injected into the system.

before_flood_time

Text

40

 

0

 

 

 

 

 

Before flood level

Water level in the monitored pipe before dye enters the pipe.

before_flood_level

Double

 

Y

0

 

 

 

 

 

Before flood PVM ave

Average velocity in the monitored pipe as measured by Portable Velocity Meter before dye enters the pipe.

before_flood_pvm_ave

Double

 

V

0

 

 

 

 

 

Before flood max vel

Maximum velocity in the monitored pipe before dye enters the pipe.

before_flood_max_vel

Double

 

V

0

 

 

 

 

 

During flood time

Time at which dye is passing through the monitored pipe.

during_flood_time

Text

40

 

0

 

 

 

 

 

During flood level

Water level in the monitored pipe at the time that dye is passing through the pipe.

during_flood_level

Double

 

Y

0

 

 

 

 

 

During flood PVM ave

Average velocity in the monitored pipe as measured by Portable Velocity Meter while dye is passing through the pipe the pipe.

during_flood_pvm_ave

Double

 

V

0

 

 

 

 

 

During flood max vel

Maximum velocity in the monitored pipe while dye is passing through the pipe.

during_flood_max_vel

Double

 

V

0

 

 

 

 

 

After flood time

Time after which dye has passed through the monitored pipe.

after_flood_time

Text

40

 

0

 

 

 

 

 

After flood level

Water level in the monitored pipe after dye has passed through the pipe.

after_flood_level

Double

 

Y

0

 

 

 

 

 

After flood PVM ave

Average velocity in the monitored pipe as measured by Portable Velocity Meter after dye has passed through the pipe.

after_flood_pvm_ave

Double

 

V

0

 

 

 

 

 

After flood max vel

Maximum velocity in the monitored pipe after dye has passed through the pipe.

after_flood_max_vel

Double

 

V

0

 

 

 

 

 

US node ID

US node ID of the associated monitored pipe.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

DS node ID of the associated monitored pipe.

ds_node_id

Text

40

 

0

 

 

 

 

 

Link suffix

Link suffix of the associated monitored pipe.

link_suffix

Text

1

 

0

 

 

 

 

 

Monitored US depth

Upstream water level in the monitored pipe at time of flooding.

mon_us_depth

Double

 

MANH_DIM

0

 

 

 

 

 

Monitored DS depth

Downstream water level in the monitored pipe at time of flooding.

mon_ds_depth

Double

 

MANH_DIM

0

 

 

 

 

 

Pipe size

Diameter of monitored pipe.

pipe_size

Double

 

CAMS_PS

0

 

 

 

 

 

Pipe material

Material of monitored pipe:

Database Value

Description

AC

Asbestos Cement

AK

Alkathene

BL

Bitumen (Lining)

BR

Brick

CC

Concrete Box Culvert

CI

Cast Iron

CL

Cement Mortar (Lining)

CO

Concrete

CSB

Concrete Segments Bolted

CSU

Concrete Segments Unbolted

DI

Ductile Iron

EP

Epoxy

FC

Fibre Cement

FRP

Fibre Reinforced Plastics

GI

Grey Cast Iron

GRC

Glass Reinforced Concrete

GRP

Glass Reinforced Plastic

MAC

Masonry, Coursed

MAR

Masonry, Random

PE

Polyethylene

PF

Pitch Fibre

PP

Polypropylene

PS

Polyester

PSC

Plastic/Steel Composite

PVC

Polyvinyl Chloride

RC

Reinforced Concrete

RPM

Reinforced Plastic Matrix

SI

Spun Iron

SPC

Sprayed Concrete

ST

Steel

U

Unspecified

VC

Vitrified Clay

X

Unidentified Material

XI

Unidentified Type of Iron/Steel

XP

Unidentified type of Plastics

Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

pipe_material

Text

64

 

0

 

 

 

 

 

CCTV survey ID

ID of CCTV Survey used to make observations during dye test.

cctv_survey_id

Text

40

 

0

 

 

 

 

 

Injection US node ID

US Node ID of associated injection pipe.

us_node_id_inj

Text

40

 

0

 

 

 

 

 

Injection DS node ID

DS Node ID of associated injection pipe.

ds_node_id_inj

Text

40

 

0

 

 

 

 

 

Injection link suffix

Link Suffix of associated injection pipe.

link_suffix_inj

Text

1

 

0

 

 

 

 

 
Injection connection pipe ID ID of associated injection connection pipe. connection_pipe_id_inj Text 40   0          
Scheduled Task fields See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet.                    
Attachments

Click the button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

 attachments Array                
General properties fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    

Creating a Dye Test

Survey Grid

Network Data Fields

Common Data Fields