Pipe Repair Data Fields (Collection)

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

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

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

Common Data Fields

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

Pipe Repair Data

Database Table Name: cams_pipe_repair

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 repair.

id

Text

40

 

0

 

 

 

 

 

Repair type

Database Value

Description

POINT

Point Repair

REPLACE

Replacement

CURED

Cured In-Place Liner

FOLD

Fold and Form Liner

SECTION

Sectional Liner

GROUT

Grouting

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

repair_type

Text

20

 

0

 

 

 

 

 

Defect type

The type of defect requiring repair:

Database Value

Description

BREAK

Break

COL

Collapse

CRACK

Crack

JOINT

Joint Defect

ROOTS

Roots

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

defect_type

Text

15

 

0

 

 

 

 

 

Status

The current status of the repair in relation to completion:

Database Value

Description

PLAN

Planned

APP

Approved

ACT

Active

COMP

Completed

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

status

Text

32

 

0

 

 

 

 

 

Cause of failure

Database Value

Description

GROUND

Ground Movement

MANDEF

Manufacturing Defect

IMPACT

Impact Damage

TEMP

Temperature Changes

WORKS

Other Works

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

cause_of_failure

Text

40

 

0

 

0

0

0

0

Start length

Location along pipe where repair starts, relative to upstream end of pipe. Default is 0.

start_length

Double

 

L

3

 

 

 

 

 

Repair length

Length of pipe repaired. Default is calculated as Length of pipe with which repair is associated minus Start Length of repair.

repair_length

Double

 

L

3

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 
CCTV survey ID (before)

ID of CCTV survey used to identify the requirement for the pipe repair.

This field will be automatically populated when creating a pipe repair as a scheduled task for the CCTV survey.

 cctv_survey_id Text 40   0          
CCTV required

Check this box if a review CCTV survey is required to verify that the pipe repair has been carried out correctly.

The repair will not be automatically closed when updating scheduled tasks if a completed review CCTV survey does not exist.

 cctv_required Boolean     0          
Review CCTV survey ID (after)

ID of CCTV survey used to verify that the repair has been carried out correctly.

This field will be automatically populated when creating a CCTV survey as a scheduled task for the pipe repair.

 review_cctv_survey_id Text 40   0          

US node ID

ID of the node upstream of the associated pipe.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

ID of the node downstream of the associated pipe.

ds_node_id

Text

40

 

0

 

 

 

 

 

Link suffix

Suffix of the associated pipe.

link_suffix

Text

1

 

0

 

 

 

 

 
PLR / asset ID Pipe reference code. plr Text 40   0          
Connection pipe ID

ID of the associated connection pipe.

 connection_pipe_id Text 40   0          

Job number

Job reference number.

job_number

Text

15

 

0

 

 

 

 

 

Material

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.

material

Text

64

 

0

 

 

 

 

 

Lining material

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.

lining_material

Text

64

 

0

 

 

 

 

 

Lining type

Database Value

Description

M

Inserted During Manufacture

SP

Sprayed

CIP

Cured in Place

SEG

Segmental

DP

Lining with Discrete Pipes

CP

Lining with Continuous Pipes

CF

Close Fit Lining

SW

Spirally Wound Lining

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.

lining_type

Text

64

 

0

 

 

 

 

 

Shape

Database Value

Description

A

Arch

B

Barrel

C

Circular

E

Egg

H

Horseshoe

K

Kerb Block

O

Oval

R

Rectangular

S

Square

T

Trapezoidal

U

U-Shaped with Flat Top

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.

shape

Text

15

 

0

 

 

 

 

 

Width

Repaired pipe dimension.

width

Double

 

CAMS_PS

0

 

 

 

 

 

Height

Repaired pipe dimension.

height

Double

 

CAMS_PS

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.                    

Repairs

Repair Grid

Network Data Fields

Common Data Fields