Pipe (Collection) Data Fields

US node ID

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

us_node_id

Text

40

0

DS node ID

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

ds_node_id

Text

40

0

Link suffix

A single character between A and Z or 0 and 9.

link_suffix

Text

1

0

Asset ID

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

asset_id

Text

40

0

Owner

The proprietor of the asset.

owner

Text

64

0

Location

Address or description of site at which asset is located.

location

Text

100

0

System type / use

System type:

Choices available depend on the CCTV Standard being used.

system_type

Text

10

0

Operational status

The current operational status of the asset:

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

status

Text

10

1

Pipe type

Type of pipe.

Choices available depend on the CCTV Standard being used.

pipe_type

Text

10

0

Flow control

Flow control.

Choices available depend on the CCTV Standard being used.

flow_control

Text

10

0

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

0

Drainage code

Drainage area code.

drainage_code

Text

10

0

Taking off reference

This field may be used to provide more detail for critical sewer classification.

taking_off_reference

Text

2

0

Code indicating pipe specification details, such as material, pressure rating, wall thickness etc.

Used by Lifetime Estimator to calculate expected lifetime and likelihood of failure.

Default choices:

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

US shape ID

Cross-sectional shape at upstream end of pipe.

Choices available depend on the CCTV Standard being used.

shape

Text

10

0

US height

Upstream height of the cross-section of the pipe.

height

Double

CAMS_PS

0

0

US width

Upstream width of the cross-section of the pipe.

width

Double

CAMS_PS

0

0

US depth from cover

Distance between cover level and pipe invert level at upstream end of pipe.

us_depth_from_cover

Double

Y

3

0

US invert level

Invert level for the upstream end of the link, measured above system datum.

us_invert

Double

Z

3

DS shape ID

Cross-sectional shape at downstream end of pipe.

Choices available depend on the CCTV Standard being used.

ds_shape

Text

10

0

DS height

Downstream height of the cross-section of the pipe.

ds_height

Double

CAMS_PS

0

0

DS width

Downstream width of the cross-section of the pipe.

ds_width

Double

CAMS_PS

0

0

DS depth from cover

Distance between cover level and pipe invert level at downstream end of pipe.

ds_depth_from_cover

Double

Y

3

0

DS invert level

Invert level for the downstream end of the link, measured above system datum.

ds_invert

Double

Z

3

Backdrop diameter

Diameter of backdrop pipe.

backdrop_diam

Double

CAMS_PS

3

Pipe length

Pipe Length.

length

Double

L

3

Gradient

Slope of the pipe.

gradient

Double

S

5

Pipe unit length

Length of the construction units used in the pipe (also referred to as pipe joint length).

unit_length

Double

L

3

Click the button to display the Dimensions editor, which can be used to view or edit the upstream, downstream and general pipe dimension data.

US pipe material

Material of upstream end of pipe.

Choices available depend on the CCTV Standard being used.

pipe_material

Text

64

0

US lining type

Type of lining at upstream end of pipe.

Choices available depend on the CCTV Standard being used.

lining_type

Text

10

0

US lining material

Material of lining at upstream end of pipe.

Choices available depend on the CCTV Standard being used.

lining_material

Text

10

0

DS pipe material

Material of downstream end of pipe.

Choices available depend on the CCTV Standard being used.

ds_pipe_material

Text

64

0

DS lining type

Type of lining at downstream end of pipe.

Choices available depend on the CCTV Standard being used.

ds_lining_type

Text

10

0

DS lining material

Material of lining at downstream end of pipe.

Choices available depend on the CCTV Standard being used.

ds_lining_material

Text

10

0

Site condition

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

site_condition

Text

10

0

Date installed

Date of pipe installation.

year_laid

Date / Time

0

Year renewed

Year of pipe renewal.

year_renew

Date / Time

0

The type of external protection:

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

Text

10

0

Year of pipe renewal.

year_renew

Date / Time

0

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

0

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

0

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

0

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

0

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

0

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

0

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

0

Date cleaned

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

date_cleaned

Date / Time

0

Conduit full capacity

The capacity of the link flowing just full.

capacity

Double

Q

3

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

5

0

Condition code

Indication of asset condition.

condition_code

Text

8

0

Security

The security of the asset from unauthorised access/tampering:

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

security

Text

10

0

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

2

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

WN_COST

2

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

0

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

2

Replacement cost

The estimated cost for completely replacing an asset

replace_cost

Double

WN_COST

2

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

2

Indicates ground condition.

Used when Calculating Consequence Scores.

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

Number of vehicles per day that use the road(s) the pipe intersects.

Used in the calculation of Traffic risk score when Calculating Consequence Scores.

Check this option to indicate that the road(s) the pipe intersects has adequate diversions.

Used in the calculation of Traffic risk score when Calculating Consequence Scores.

Restrictions in gaining access to land in which pipe is located.

Used when Calculating Consequence Scores.

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

Check this option to indicate that pipe runs under a building.

Used when Calculating Consequence Scores.

Risk associated with flooding in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk (flooding would affect a large number of properties, or a critical structure such as a hospital, airport etc.)

Used when Calculating Consequence Scores.

Risk associated with polluting a river, shell fishery, bathing area etc. due in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

Risk associated with odour / nuisance in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

Risk associated with flood discharge draining into a source protection zone etc. in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

Multiplying factor to be used when calculating traffic risk score.

Used when Calculating Consequence Scores.

May be calculated by the Consequence Calculation tool.

Risk associated with service interruption to rail, road, business, emergency services etc. in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

Risk associated with cost of repair in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

May be calculated by the Consequence Calculation tool.

Risk associated with traffic delays in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

May be calculated by the Consequence Calculation tool.

Overall consequence rating.

May be calculated by the Consequence Calculation tool.

Score indicating the likelihood of failure of the pipe.

May be calculated by the Lifetime Estimator tool.

Will be updated when Updating Pipe Condition from CCTV Data.

Overall risk of structural failure rating.

May be calculated by the Risk Assessment tool.

Click the button to display the Lateral Nodes editor, used to view lateral nodes on the pipe.

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.

Has photos

Check box indicating whether photos are associated with the pipe.

has_photos

Boolean

0

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 pipe.