Pipe Repair Data Fields (Distribution)

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: wams_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

Unique identifier for the repair.

Text

Location

Address or description of site at which asset is located.

location

Text

100

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

Defect type

The type of defect requiring repair:

Database Value	Description
BREAK	Break
CRACK	Crack
COL	Collapse
CIRC	Circumferential Break
SPLIT	Split/Tear
LONG	Longitudinal Crack
HOLE	Holes/Blow Out
PIN	Pin Holes
SOFT	Softening/Degradation

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

defect_type

Text

Cause of failure

Database Value	Description
INTCORR	Internal Corrosion
EXTCORR	External Corrosion
GROUND	Ground Movement
PRESS	Internal Pressure
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

Start length

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

start_length

Double

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

Pipe ID

ID of the associated pipe.

pipe_id

Text

Valve shut off ID

ID of associated valve shut off object.

valve_shut_off_id

Text

Job number

Job reference number.

job_number

Text

Repair type

Database Value	Description
REPLACE	Replacement
RELINESTRUCT	Structural Relining
CLAMP	Clamp
COUPLING	Coupling
COLL	Collar
PATCH	Patch
WELD	Weld
RELINENON	Non-Structural Relining

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

repair_type

Text

Material

Database Value	Description
ALK	Alkathene
ASB	Asbestose Cement
CI	Cast Iron
CONC	Concrete
DI	Ductile Iron
HDPE	High Density Polyethylene
STEEL	Steel
SI	Spun Iron
GI	Galvanised Iron
MDPE	Medium Density Polyethylene
PE	Polyethylene
PP	Polypropylene
PVC	Poly Vinyl Chloride
UPVC	U Poly Vinyl Chloride
LEAD	Lead
CU	Copper
WOOD	Wood
UNKNOWN	Unknown

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

material

Text

Lining material

Database Value	Description
BIT	Bitumen
TAR	Tar
CEMENT	Cement Mortar
EPOXY	Epoxy Resin
PLASTIC	Plastic
NONE	None
UNKNOWN	Unknown

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

lining_material

Text

Lining type

Database Value	Description
STRUC	Structural
NONSTRUCT	Non-Structural
SWAGE	Swage
ROLL	Rolldown
CURED	Cured in Situ

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

lining_type

Text

Diameter

Diameter of pipe repaired.

diameter

Double

CAMS_PS

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.