Pipe Clean Data Fields

Pipe clean data can be edited on either the Pipe Clean Grid Window of the Repair Grid or the Pipe Clean Property Sheet.

To view and edit all pipe clean data, use the Property Sheet.

The following describes all the data which can be used to define a pipe clean.

Common Data Fields

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

Pipe Clean Data

Database Table Name: cams_pipe_clean

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

The name of the object.

The ID is the primary key in the database for the network object. This means that the ID field of each object must be unique for all objects of the same object type.

Text

Cleaning method

Database Value	Description
Jetting	Jetting
Rodding	Rodding
Rooting	Roto-rooting
Other	Other

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

cleaning_method

Text

Location

Address or description of site at which asset is located.

location

Text

100

Job number

Job reference number.

job_number

Text

Node ID flushing from

Node at which pipe clean is to start.

node_id_flushing_from

Text

Node ID flushing to

Node at which pipe clean is to end.

node_id_flushing_to

Text

Distance flushed

Length of pipe that is to be cleaned.

distance_flushed

Double

Width

Width dimension of pipe to be cleaned.

width

Double

CAMS_PS

9999

Height

Height dimension of pipe to be cleaned.

height

Double

CAMS_PS

9999

Pipe material

Material of pipe to be cleaned:

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

Connection pipe ID

ID of the associated connection pipe.

connection_pipe_id

Text

Distance to any resistance met

Length of pipe from start of pipe clean until resistance, due to debris or tree roots for example, is encountered.

distance_to_any_resistance

Double

Debris removed after flushing

Database Value	Description
Sticks	Sticks
Grease	Grease
Roots	Roots
Sand	Sand
Gravel	Gravel
Rocks	Rocks
Bricks	Bricks
Paper	Paper
Rags	Rags
Other	Other

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

debris_removed_after_flushing

Text

Waste water condition when flushed

Database Value	Description
Clear	Clear
Grey	Grey
Black	Black

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

wastewater_condition

Text

Odor when flushing

Database Value	Description
None	None
Mild	Mild
Strong	Strong (Rotten Eggs)
Other	Other

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

odor_when_flushing

Text

Flow before flushing

Database Value	Description
None	None
Even	Even
Less	Less
More	More

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

flow_before_flushing

Text

Flow after flushing

Database Value	Description
None	None
Even	Even
Less	Less
More	More

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

flow_after_flushing

Text

Pipes

Pipe identifier details of pipes to be cleaned.

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Database Table Name: cams_pipe_ref

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size
1	US node ID	Upstream node	us_node_id	Text	40
2	DS node ID	Downstream node	ds_node_id	Text	40
3	Link suffix	Pipe suffix	link_suffix	Text	1
4	PLR / asset ID	Pipe reference code	plr	Text	40

pipes

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

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.

Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.