Manhole Repair Data Fields (Distribution)

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

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

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

Common Data Fields

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

Manhole Repair Data

Database Table Name: wams_manhole_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

Manhole ID

ID of the manhole to be repaired.

manhole_id

Text

Repair type

Database Value	Description
LEAK	Repair Leaks
SEAL	Seal Connection
BENCH	Replace Bench
FRAME	Replace Frame
COVER	Replace Cover
RAISE	Raise Manhole
NEW	New Manhole
REPLACE	Replace Manhole
LINER	Install Liner

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

repair_type

Text

Defect type

The type of defect requiring repair:

Database Value	Description
COVER	Cover Defective
FRAME	Frame Defective
MISC	Misc Defects
SEAL	Seal Defective
WALL	Wall Defective

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

defect_type

Text

Status

The current status of the task 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

Location

Address or description of site at which asset is located.

location

Text

100

X coordinate

X coordinate of the object.

Double

Y coordinate

Y coordinate of the object.

Double

Job number

Job reference number.

job_number

Text

Lining material

Database Value	Description
FIBRE	Fibre Glass
CEMENT	Cementitious
POLY	Polyethylene

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

material

Text

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.