Common Data Fields

This topic contains information on all the common data fields that can be found for most objects:

Scheduled Task fields information for all survey and repair objects - used to store details of task status for a survey, maintenance or repair activity.
Defects - allow you to view any survey image files you have imported.
Attachments - can be specified for all asset, survey, repair, incident and zone objects. The Attachments editor allows viewing and managing of attachments such as images (pictures, sketches, photos), videos and other files for a network object.
User Fields such as User Numbers and User Text Fields - these allow you to view and edit the data that most network objects can store in user defined fields.
General properties - Notes, special instructions, barcodes, and identifiers, which are used to store any additional relevant information for the network object, and Hyperlinks which are used to associate external files or Internet addresses with objects in the model.
Time series links - can be specified for all asset objects, zone and property types of zone objects, and monitoring and water quality types of survey objects. It allows you to link the appropriate network objects to time series data in either the Infinity System or to ICM time series data (TSD) objects in the database.
Validation - most network object types can have validation information on their property sheet. If the Show Validation Errors option is enabled, the object is automatically validated and any validation errors or warnings are displayed on the Property Sheet (a validation object must be associated with the network). In the tabbed Property Sheets, the Validation page automatically validates the object and displays any validation errors or warnings whenever it is accessed (a validation object must be associated with the network).

These common data fields are described in the table or in the sections below.

Survey, repair and work package objects may have Schedule information on their property sheet. These fields store details of task status for a survey, maintenance or repair activity. This information can be used for monitoring and managing task progress.

See Scheduled Tasks for more information.

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

Schedule number

Identifier intended for use in tracking a group of tasks

schedule_number

Text

Date/Time planned

Date when task is due to start

date_planned

Date / Time

Estimated completion date

Estimated date of task completion

estimated_completion_date

Date / Time

Work package

Work package the currently selected survey, repair, incident or work package is part of.

work_package

Text

Repeat period

Intervals at which task is repeated.

From 1 week to 10 years.

repeat_period

Text

Team leader

Name or identifier of the team leader in charge of the task

Database Value	Description
LEAD1	Team Leader 1
LEAD2	Team Leader 2

team_leader

Text

999

Contractor

Name of person or company carrying out the task

Database Value	Description
CONT1	Contractor 1
CONT2	Contractor 2

contractor

Text

Work type

Applicable to Repair tasks. Type of work order:

Database Value	Description
CM	Corrective
PM	Preventive
PdM	Predictive

work_type

Text

Priority

Priority of the task

Database Value	Description
L	Low
M	Medium
H	High

priority

Text

100

Approval level

Approval level assigned to the scheduled task.

This dropdown list is populated with the Approval Level data entered in the Resource Grid.

approval_level

Text

Approval status

Task approval status.

Database Value	Description
Not required	Not required
Pending	Pending
Approved	Approved
Hold	Hold
Rejected	Rejected

approval_status

Text

Resource details

The Resource Details editor is used to define :

Resources with breakdown by hours worked (normal, overtime and double time) showing an estimated and actual cost for carrying out maintenance work (repairs or surveys) on a selected asset.

The editor can be used to perform resource management calculations.

Quantities and costs of materials required to carry out the related maintenance work, with breakdown by estimated and actual figures for each material.

Database Table Name for built-in objects: cams_resource_details for collection networks, wams_resource_details for distribution networks and ams_resource_details for asset networks.

Database Table Name for user defined objects: user_schedule_fields_cams for collection networks, user_schedule_fields_wams for distribution networks and user_schedule_fields_ams for asset networks

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size	Units	Precision
1	Resource ID	Unique Identifier for the Resource	resource_id	Text	40		0
2	Estimated hours	Estimated time in terms of normal hours required to carry out the task	estimated_hours	Double			2
3	Estimated overtime hours	Estimated time in terms of overtime hours required to carry out the task	estimated_overtime_hours	Double			2
4	Estimated Double Time Hours	Estimated time in terms of double time hours required to carry out the task	estimated_double_time_hours	Double			2
5	Estimated Cost	The estimated cost of carrying out the task	estimated_cost	Double		WN_COST	2
6	Actual Hours	Actual time in terms of normal hours taken to carry out the task	actual_hours	Double			2
7	Actual Overtime Hours	Actual time in terms of overtime hours taken to carry out the task	actual_overtime_hours	Double			2
8	Actual double time hours	Actual time in terms of double time hours taken to carry out the task	actual_double_time_hours	Double			2
9	Actual cost	The actual cost of carrying out the task	actual_cost	Double		WN_COST	2

resource_details

Array

Material details

The Resource Details editor is used to define :

Resources with breakdown by hours worked (normal, overtime and double time) showing an estimated and actual cost for carrying out maintenance work (repairs or surveys) on a selected asset.

The editor can be used to perform resource management calculations.

Quantities and costs of materials required to carry out the related maintenance work, with breakdown by estimated and actual figures for each material.

Database Table Name for built-in objects: cams_material_details for collection networks, wams_material_details for distribution networks and ams_material_details for asset networks.

Database Table Name for user defined objects: user_schedule_fields_cams for collection networks, user_schedule_fields_wams for distribution networks and user_schedule_fields_ams for asset networks

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size	Units	Precision
1	Material ID	Unique Identifier for the Material	material_id	Text	40		0
2	Estimated number	Estimated number of items of this material required to perform the task.	estimated_number	Integer			0
3	Estimated cost	Estimated cost of the material required to carry out the task.	estimated_cost	Double		WN_COST	2
4	Actual number	Number of items of the material actually used to perform the task.	actual_number	Integer			0
5	Actual cost	Actual cost of the material used to carry out the task	actual_cost	Double		WN_COST	2

material_details

Array

Special instructions

Notes containing any additional instructions that the person carrying out the task should be aware of.

special_instructions

Memo

Approval history

Any comments made when the scheduled task was approved are displayed in the read-only Approval history section of the editor.

approval_history

Memo

Task status

Current status of task.

Database Value	Description
PLAN	Planned
DELAY	Delayed
ACT	Active
COMP	Completed

task_status

Text

Task phase

Stage of multi-step task.

Database Value	Description
PHASE 1	Phase 1
PHASE 2	Phase 2

task_phase

Text

Date opened

Read-only field.

Date/Time when task was created.

Automatically populated when object is created as a scheduled task.

date_opened

Date / Time

Date/Time started

Actual start date of task.

date_started

Date / Time

Completed

Indicates whether task has been completed or is still pending.

completed

Boolean

Date completed

Actual date of task completion.

date_completed

Date/Time

Closed

Automatically set by updating scheduled tasks.

A checked field indicates that the task has been updated since completion.

closed

Boolean

Date closed

Date/Time at which task was closed.

date_closed

Date / Time

Repeat schedule number

Schedule number of task created from a repeated task.

repeat_schedule_number

Text

Actual duration

Actual time taken to carry out the task.

May be calculated via the Resource Details editor.

actual_duration

Double

Actual cost

The actual cost of carrying out the task.

May be calculated via the Resource Details editor.

actual_cost

Double

WN_COST

Estimated duration

Estimate of time required to carry out the task.

May be calculated via the Resource Details editor.

estimated_duration

Double

Estimated cost

The estimated cost of carrying out the task.

May be calculated via the Resource Details editor.

estimated_cost

Double

WN_COST

Attachments

The Attachments Editor is used to attach and manage photos, sketches, videos and other files associated with the network object.

The coloured rows in the editor display fixed image fields that cannot be deleted. Details of these fields are displayed in the table below.

See the Attachments Editor topic for details on working with attachments.

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

Attachments

Database Table Name: cams_attachment_details for Collection networks, wams_attachment_details for Distribution networks and ams_attachment_details for Asset networks.

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size
1	Purpose	Select an option from the dropdown or manually enter purpose of the attachment.	purpose	Text	100
2	Original file name	External reference to attachment file. Maybe a hardcopy reference or an original source for the attachment.	filename	Text	255
3	Description	Optional description or notes regarding attachment.	description	Text	255
4	Database reference	Internal reference to attachment file in database. Displayed in attachments as read only Has attachments check box. If the box is checked, an attachment is associated with the row.	db_ref	Text	30

attachments

Array

Sketch

Applies to majority of network objects.

Internal reference to an image file in the database. Intended for surveyors sketch of the layout of the asset and surroundings.

sketch

Text

(Sketch) Filename

External reference to Sketch attachment. Maybe a hardcopy reference or an original source for the attachment.

sketch_filename

Text

255

(Sketch) Description

Optional description or notes regarding the Sketch attachment.

sketch_ref

Text

Photo

Applies to majority of network objects.

Internal reference to an image file in the database.

photo

Text

(Photo) Filename

External reference to Photo attachment. Maybe a hardcopy reference or an original source for the attachment.

photo_filename

Text

255

(Photo) Description

Optional description or notes regarding the Photo attachment.

photo_ref

Text

Location sketch

Applies to majority of network objects.

Internal reference to an image file in the database. Intended for surveyors sketch of the layout of the asset and surroundings.

location_sketch

Text

(Location sketch) Filename

External reference to Location sketch attachment. Maybe a hardcopy reference or an original source for the attachment.

location_sketch_filename

Text

255

(Location sketch) Description

Optional description or notes regarding the Location sketch attachment.

location_sketch_ref

Text

Location photo

Applies to majority of network objects.

Internal reference to an image file in the database. Intended for photo of the layout of the asset and surroundings.

location_photo

Text

(Location photo) Filename

External reference to Location photo attachment. Maybe a hardcopy reference or an original source for the attachment.

location_photo_filename

Text

255

(Location photo) Description

Optional description or notes regarding the Location photo attachment.

location_photo_ref

Text

Location image

Applies to Collection network manholes and manhole surveys.

Internal reference to an image of the manhole location.

location_image

Text

(Location image) Filename

External reference to Location image attachment. Maybe a hardcopy reference or an original source for the attachment.

location_image_filename

Text

255

(Location image) Description

Optional description or notes regarding the Location image attachment.

location_image_ref

Text

Plan sketch

Applies to Collection network manholes and manhole surveys.

Internal reference to surveyors sketch of layout of the asset and surroundings.

plan_sketch

Text

(Plan sketch) Filename

External reference to Plan sketch attachment. Maybe a hardcopy reference or an original source for the attachment.

plan_sketch_filename

Text

255

(Plan sketch) Description

Optional description or notes regarding the Plan sketch attachment.

plan_sketch_ref

Text

Internal image

Applies to Collection network manholes and manhole surveys.

Internal reference to photo inside manhole.

internal_image

Text

(Internal image) Filename

External reference to Internal image attachment. Maybe a hardcopy reference or an original source for the attachment.

internal_image_filename

Text

255

(Internal image) Description

Optional description or notes regarding the Internal image attachment.

internal_image_ref

Text

Upstream pipe image

Applies to Collection network pipes and connection pipes.

Internal reference to a photo of the upstream end of the pipe

us_image

Text

(Upstream pipe image) Filename

External reference to Upstream pipe image attachment. Maybe a hardcopy reference or an original source for the attachment.

us_image_filename

Text

255

(Upstream pipe image) Description

Optional description or notes regarding the Upstream pipe image attachment.

us_image_ref

Text

Downstream pipe image

Applies to Collection network pipes and connection pipes.

Internal reference to a photo of the downstream end of the pipe

ds_image

Text

(Downstream pipe image) Filename

External reference to Downstream pipe image attachment. Maybe a hardcopy reference or an original source for the attachment.

ds_image_filename

Text

255

(Downstream pipe image) Description

Optional description or notes regarding the Downstream pipe image attachment.

ds_image_ref

Text

US photo

Applies to Collection network smoke tests and dye tests.

Internal reference to a photo of the upstream end of the pipe.

us_photo

Text

(US photo) Filename

External reference to US photo attachment. Maybe a hardcopy reference or an original source for the attachment.

us_photo_filename

Text

255

(US photo) Description

Optional description or notes regarding the US photo attachment.

us_photo_ref

Text

DS photo

Applies to Collection network smoke tests and dye tests, and

Internal reference to a photo of the downstream end of the pipe.

ds_photo

Text

(DS photo) Filename

External reference to DS photo attachment. Maybe a hardcopy reference or an original source for the attachment.

ds_photo_filename

Text

255

(DS photo) Description

Optional description or notes regarding the DS photo attachment.

ds_photo_ref

Text

Other image

Apples to Collection network drain tests.

Internal reference to drain test image.

other_image

Text

(Other image) Filename

External reference to Other image attachment. Maybe a hardcopy reference or an original source for the attachment.

other_image_filename

Text

255

(Other image) Description

Optional description or notes regarding the Other image attachment.

other_image_ref

Text

Injection point image

Applies to Collection network drain tests.

Internal reference to image of location where dye was injected.

injection_point_image

Text

(Injection point image) Filename

External reference to Injection point image attachment. Maybe a hardcopy reference or an original source for the attachment.

injection_point_image_filename

Text

255

(Injection point image) Description

Optional description or notes regarding the Injection point image attachment.

injection_pont_image_ref

Text

Internal photo

Applies to Distribution network pipe samples.

Internal reference to photo of pipe interior.

internal_photo

Text

(Internal photo) Filename

External reference to Internal photo attachment. Maybe a hardcopy reference or an original source for the attachment.

internal_photo_filename

Text

255

(Internal photo) Description

Optional description or notes regarding the Internal photo attachment.

internal_photo_ref

Text

External photo

Applies to Distribution network pipe samples.

Internal reference to photo of pipe exterior.

external_photo

Text

(External photo) Filename

External reference to External photo attachment. Maybe a hardcopy reference or an original source for the attachment.

external_photo_filename

Text

255

(External photo) Description

Optional description or notes regarding the External photo attachment.

external_photo_ref

Text

User Fields

User fields are used to store any additional information for an object that is not stored in the object's other data fields.

The column name of any User field can be changed for the current network (and any subsequent networks based on the current network). See Renaming Additional User Fields.

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Field Name	Help Text	Database Field	Data Type	Size	Precision
User number 1	Used to store any additional number value in the database.	user_number_1	Double		3
User number 2 to User number 40	See User Number 1 Note User number fields 21 to 40 are only available via the Object Properties Window.	user_number_2 to user_number_40	Double		3
User text 1	Used to store any additional string value in the database.	user_text_1	Text	250	0
User text 2 to User text 40	See User Text 1 Note User text fields 21 to 40 are only available via the Object Properties Window.	user_text_2 to user_text_40	Text	250	0
User date 1	Used to store any additional date value in the database.	user_date_1	Date/Time		3
User date 2 to User date 5	See User date 1	user_date_1 to user_date_5

General properties

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

Notes

You can keep freeform notes about any object in your network. The notes field can be up to 64,000 characters in size, or about 10 pages of printed text.

The usual Windows text-editing facilities are available when editing notes. Pressing ENTER starts a new paragraph. Use CTRL-C and CTRL-V for copy and paste.

To move out of the text area, click on a button or press the TAB key.

Scheduled tasks (surveys and repairs) whose cost is greater than the related approval level may have an additional Approval history box in the Notes (tabbed property sheet) or the Schedule Info section (Object Properties Window) of their property sheet. This box is only visible once the task approval has been managed in InfoAsset Manager and shows read-only data relating to the approval history.

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Field Name	Help Text	Database Field	Data Type	Size	Units	Default	Error Lower Limit	Error Upper Limit	Warning Lower Limit	Warning Upper Limit
Approval history	Box displaying the task approval history. It contains the result of the task approval, the names of the approving officers, a user and date stamp as well as any comments that may have been added at approval time, all in read-only mode.	approval_history	Memo

notes

Memo

Hyperlinks

Hyperlinks can be typed in using the Name and Filename or URL fields, or you can browse for a file located on your local machine, or elsewhere on your network. Alternatively, you can drag and drop filenames or internet URLs from various sources, including Windows Explorer and your web browser.

For full details of the methods involved, see Using Hyperlinks.

Database Table Name: hyperlink

Show Columns	Database Names
	Size, Type and Units
	Defaults and Error Limits

Position in Data Structure	Field Name	Help Text	Database Field	Data Type	Size	Units	Default	Error Lower Limit	Error Upper Limit	Warning Lower Limit	Warning Upper Limit
1	Description	Description of the hyperlinked file	description	Text	1024
2	URL	The path or URL for the file. Browse for a local file using the Browse button	url	Text	1024