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
|
Field Name |
Help Text |
Database Field |
Size |
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 |
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:
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:
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 |
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 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. |
button to display the 