Connection Pipe Data Fields

Information relating to a Connection Pipe can be viewed and edited on the Connection Pipe Grid Window of the Asset Grid or on the Connection Pipe Property Sheet.

Most data can be edited on the grid, but some fields cannot be displayed in the grid format.

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

The following describes all the data which can be used to define a connection pipe.

Common Data Fields

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

Connection Pipe Data

Database Table Name: cams_connection_pipe

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

Connection pipe ID

A unique identifier for the connection pipe.

Text

US node ID

ID of node to which upstream end of pipe is connected.

us_node_id

Text

DS node ID

ID of node to which downstream end of pipe is connected.

ds_node_id

Text

Property ID

ID of property from which pipe is connected.

property_id

Text

Asset ID

An optional reference - usually the asset database name for this network object (if applicable).

asset_id

Text

Description

Additional information.

description

Text

100

Owner

The proprietor of the asset.

owner

Text

Location

Address or description of site at which asset is located.

location

Text

100

System type / use

System type:

Database Value	Description
F	Foul
S	Surface
C	Combined
T	Transition
O	Overflow
U	Unspecified

Choices available depend on the CCTV Standard being used.

system_type

Text

Operational status

The current operational status:

Database Value	Description
AB	Abandoned
STANDBY	Standby
INUSE	In Use

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

status

Text

Type

Type of connection:

Database Value	Description
HOUSE	House connection
DRAIN	Drain connection

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

type

Text

Branch ID

Numeric field used to identify to which long section the link is associated. (See Defining Branches for further information).

branch_id

Long Integer

X start

X coordinate at upstream end of pipe.

x_start

Double

Y start

Y coordinate at upstream end of pipe.

y_start

Double

Z start

Elevation at upstream end of pipe.

z_start

Double

X end

X coordinate at downstream end of pipe.

x_end

Double

Y end

Y coordinate at downstream end of pipe.

y_end

Double

Z end

Elevation at downstream end of pipe.

z_end

Double

Shape ID

Cross-sectional shape of pipe.

Choices available depend on the CCTV Standard being used.

shape

Text

Diameter

Diameter of pipe.

diameter

Double

CAMS_PS

Pipe length

Pipe Length.

length

Double

Pipe material

Material of pipe.

Choices available depend on the CCTV Standard being used.

pipe_material

Text

Lining material

Material of pipe lining.

Choices available depend on the CCTV Standard being used.

pipe_lining_type

Text

Lining type

Type of lining.

Choices available depend on the CCTV Standard being used.

lining_material

Text

Date installed

Date of pipe installation.

year_laid

Date / Time

Year renewed

Year of pipe renewal.

year_renew

Date / Time

Ground level

Ground level at pipe location.

ground_level

Double

-99.99

999.99

Condition code

Indication of asset condition.

condition_code

Text

Critical / strategic sewer category

A measure of the likely impact of asset failure. The WRC SRM uses the codes A, B, C to represent "A" sewers where failures would be expensive to "C" where failures would be relatively cheap.

criticality

Text

Service condition grade

Service condition index calculated according to the chosen CCTV scoring scheme. May be updated automatically from CCTV Survey Data.

service_condition_score

Long Integer

Structural condition grade

Structural condition index calculated according to the chosen CCTV scoring scheme. May be updated automatically from CCTV Survey Data.

condition_score

Long Integer

Internal grade

Pipe condition index field available when using the CH2M HILL SCREAM™ CCTV scoring scheme. May be updated automatically from CCTV Survey Data.

internal_pipe_score

Long Integer

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

Date cleaned

The date the asset last underwent maintenance to improve performance (swabbing, scouring).

date_cleaned

Date / Time

Maintenance score

Maintenance Defect Score field available when using the CH2M HILL SCREAM™ CCTV scoring scheme. May be updated automatically from CCTV Survey Data.

int_pipe_CH2MHill_maint_scr

Long Integer

Structural score

Structural Defect Score field available when using the CH2M HILL SCREAM™ CCTV scoring scheme. May be updated automatically from CCTV Survey Data.

int_pipe_CH2MHill_struc_scr

Long Integer

Internal score

Pipe Internal Score field available when using the CH2M HILL SCREAM™ CCTV scoring scheme. May be updated automatically from CCTV Survey Data.

int_pipe_CH2MHill_scr

Long Integer

Rehabilitation cost

Rehabilitation costs to be incurred in bringing the asset to an acceptable condition. This is used in rehabilitation reports

rehab_cost

Double

WN_COST

Installation cost

The original installation cost of the asset. This generally includes all costs incurred (e.g. mantime, asset purchase costs etc). This information is used in depreciation reports

install_cost

Double

WN_COST

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

WN_COST

Expected lifetime

The expected lifetime of the asset. This is used in depreciation reports as the period over which installation costs may be depreciated.

lifetime

Long Integer

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

WN_COST

Current value

Current value of the asset. This gives an indication of depreciation costs as depreciation cost = installation cost - current value.

current_value

Double

WN_COST

Name groups

Click the

button to display the Name Groups Editor, used to view and edit the Asset Name Groups to which the object belongs.

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 data fields

See Common Data Fields for details of field in the General properties section of the property sheet.

User defined properties data fields

See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.

Time series links

Click the button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this channel.

tsdb_links

Pipes

Asset Grid