Smoke Test Survey Data Fields

Information relating to a Smoke Test Survey can be viewed and edited on the Smoke Test Grid Window of the Survey Grid or the Smoke Test Property Sheet.

To view and edit all smoke test survey data, use the Property Sheet.

The following describes all the data which can be used to define a smoke test survey.

Common Data Fields

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

Smoke Test Survey Data

Database Table Name: cams_smoke_test

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

ID

Unique identifier for the survey. This is based on the associated pipe by default.

id

Text

40

 

0

 

 

 

 

 

Date

Survey date.

date

Date / Time

 

 

0

 

 

 

 

 

Status

The current status of the survey in relation to completion:

Database Value

Description

PLAN

Planned

ONGOING

Ongoing

COMP

Complete

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 / description of the location of the surveyed pipe.

location

Text

100

 

0

 

 

 

 

 

Ground condition

Database Value

Description

Road

Road

Pavement

Pavement

Field

Field

Unpaved

Unpaved

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

ground_condition

Text

20

 

0

 

 

 

 

 

Defects found

Check box used to indicate whether any Smoke Defect Observations were made during the survey. If this field is flagged #D, the box will automatically be checked if there are any smoke defect observations associated with the smoke test.

defects_found

Boolean

 

 

3

 

 

 

 

 

Comments

Any additional comments relating to the survey.

comments

Text

64

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

US node ID

Upstream node identifier of the surveyed pipe.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

Downstream node identifier of the surveyed pipe.

ds_node_id

Text

40

 

0

 

 

 

 

 

Link suffix

Link suffix of the surveyed pipe.

link_suffix

Text

1

 

0

 

 

 

 

 
Connection pipe ID Identifier of the surveyed connection pipe. connection_pipe_id Text 40   0          

Job number

Job reference number.

job_number

Text

32

 

0

 

 

 

 

 

PLR / Asset ID

Pipe reference code.

plr

Text

40

 

0

 

 

 

 

 

Pipe material

Material of pipe surveyed:

Database Value

Description

AC

Asbestos Cement

AK

Alkathene

BL

Bitumen (Lining)

BR

Brick

CC

Concrete Box Culvert

CI

Cast Iron

CL

Cement Mortar (Lining)

CO

Concrete

CSB

Concrete Segments Bolted

CSU

Concrete Segments Unbolted

DI

Ductile Iron

EP

Epoxy

FC

Fibre Cement

FRP

Fibre Reinforced Plastics

GI

Grey Cast Iron

GRC

Glass Reinforced Concrete

GRP

Glass Reinforced Plastic

MAC

Masonry, Coursed

MAR

Masonry, Random

PE

Polyethylene

PF

Pitch Fibre

PP

Polypropylene

PS

Polyester

PSC

Plastic/Steel Composite

PVC

Polyvinyl Chloride

RC

Reinforced Concrete

RPM

Reinforced Plastic Matrix

SI

Spun Iron

SPC

Sprayed Concrete

ST

Steel

U

Unspecified

VC

Vitrified Clay

X

Unidentified Material

XI

Unidentified Type of Iron/Steel

XP

Unidentified type of Plastics

Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

pipe_material

Text

64

 

0

 

 

 

 

 

Pipe size

Diameter of pipe surveyed.

pipe_size

Double

 

CAMS_PS

0

 

 

 

 

 
Details

A read-only grid which displays the following information from any smoke defect observation surveys which this smoke test survey is associated with:

Field Name

Description
ID The identifier assigned to the smoke defect observation object.
Defect type The defect type assigned to the smoke defect observation.
Severity The severity assigned to the smoke defect observation.
Owner The proprietor of the asset.
cctv_defects                  
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 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 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.                    

Creating a Smoke Test Survey

Survey Grid

Network Data Fields

Common Data Fields