Manhole Repair Data Fields (Collection)

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

ID

Unique identifier for the repair.

id

Text

40

 

0

 

 

 

 

 

Manhole ID

ID of the manhole to be repaired.

manhole_id

Text

40

 

0

 

 

 

 

 

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

20

 

0

 

 

 

 

 

Defect type

The type of defect requiring repair:

Database Value

Description

BENCH

Bench Defective

CHAN

Channel Defective

COVER

Cover Defective

MISC

Misc Defects

FRAME

Frame Defective

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

15

 

0

 

 

 

 

 

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

32

 

0

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

X coordinate

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Job number

Job reference number.

job_number

Text

15

 

0

 

 

 

 

 

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

64

 

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