User Defined Repair Data Fields
User Defined Repair data can be edited on either the Repair Grid or the object Property Sheet.
To view and edit all user defined repair data, use the Property Sheet.
The following describes all the data which can be used to define a user defined repair.
User Defined Repair Data
Database Table Name for user-defined fields: networktype__objectname where:
- networktype is the type of network and can take the following values:
- ams - Asset network
- cams - Collection network
- wams - Distribution network
- "__" - double underscore
- objectname - name of the asset as entered in the Database Name field of the User Defined Objects Dialog.
User defined objects are configured in the User Defined Object Grid. Please refer to the User Defined Object Grid topic for further details.
User defined objects may be assigned:
- built-in fields. This is carried out behind the scenes by InfoAsset Manager at object creation or editing time. These default fields are related to the object type and geometry. Built-in fields are listed in the table below.
- user defined fields. These user defined fields are specified by the user (this may be permissioned). See User Defined Field Grid for more information.
|
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. The identifier depends on the geometry of the repair. |
id for all repair types but points node_id for points ds_node_id and us_node_id for links |
Text |
40 |
|
0 |
|
|
|
|
|
|
Asset type |
Type of asset associated with the repair. (To associate the repair with a Collection Network pipe, use the US node ID, DS node ID and Link suffix fields.) |
asset_type |
Text |
100 |
|
|
|
|
|
|
|
|
Asset ID |
Asset ID of associated asset (To associate the repair with a Collection Network pipe, use the US node ID, DS node ID and Link suffix fields.) |
asset_id |
Text |
40 |
|
|
|
|
|
|
|
| US node ID |
Applies to Collection Networks. Upstream node ID of associated pipe. (Used when repair is associated with a pipe.) |
us_node_id | Text | 40 | 0 | ||||||
| DS node ID |
Applies to Collection Networks. Downstream node ID of associated pipe. (Used when repair is associated with a pipe.) |
ds_node_id | Text | 40 | 0 | ||||||
| Link suffix |
Applies to Collection Networks. Link suffix of associated pipe. (Used when repair is associated with a pipe.) |
link_suffix | Text | 1 | 0 | ||||||
|
X coordinate |
Applies to repairs that are points. X coordinate of the repair. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
|
Y coordinate |
Applies to repairs that are points. Y coordinate of the repair. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
|
Elevation |
Applies to repairs that are points. Elevation above datum level (usually sea level) . |
elevation |
Double |
|
Z |
2 |
|
||||
|
Length |
Applies to repairs that are polylines. Applies to repairs that are polylines. Link length |
length |
Double |
L |
3 |
||||||
|
Area |
Applies to repairs that are polygons. Polygon area. Default value is calculated from polygon geometry. |
area |
Double |
NA |
3 |
|
|
|
|
|
|
|
Location |
Address or description of site at which asset is located. |
location |
Text |
100 |
|
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 | ||||||||
|
Notes Special instructions Hyperlinks Barcode Mobile identifier Unique identifier |
These fields are common to the majority of InfoAsset Manager objects. See Common Data Fields for further details. |
notes special_instructions hyperlinkarcode mobile_uid uid |
Various |
button to display the 