Drain Test Survey Data Fields
Information relating to a Drain Test Survey can be viewed and edited on the Drain Test Grid Window of the Survey Grid or the Drain Test Property Sheet.
To view and edit all drain test survey data, use the Property Sheet.
The following describes all the data which can be used to define a drain test survey.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Drain Test Survey Data
Database Table Name: cams_drain_test
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Drain test ID |
Unique identifier for the survey. |
id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Drain test status |
The status of the drain test:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
drain_test_status |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Drain ID |
The dye injection point. |
drain_id |
Text |
40 |
|
0 |
|
0 |
0 |
0 |
0 |
||||||||||||||
|
Drain type |
The type of drain connected to the property:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
drain_type |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Drain status |
The status of the drain:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
drain_status |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Current |
The Current field shows which surveys are current for the associated property and drain ID. When the user chooses to run a query identifying all the current drain tests (See Identifying Current Drain Tests topic), the Current field of the most recent survey for a property/ drain ID combination will be checked. The Current field of earlier surveys (earlier Survey Dates / Times) related to the same property / drain ID will be unchecked. |
current |
Boolean |
|
|
0 |
|
0 |
0 |
0 |
0 |
||||||||||||||
|
Location |
Address or description of site at which asset is located. |
location |
Text |
100 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Property ID |
ID of a property in the collection or distribution network which is associated with this drain test. |
property_id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Sanitary manhole |
Node ID of the associated sanitary manhole. |
sanitary_manhole |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Storm manhole |
Node ID of the associated storm manhole. |
storm_manhole |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
PLR / asset ID |
Pipe reference code. |
plr |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Job number |
Job reference number. |
job_number |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Survey crew leader |
Name or identifier of the team leader in charge of the survey. |
survey_crew_leader |
Text |
100 |
|
0 |
|
|
|
|
|
||||||||||||||
|
Survey date / time |
Survey date and time. |
survey_date_time |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
X coord |
X coordinate of the object. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||||||
|
Y coord |
Y coordinate of the object. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||||||
|
Sanitary manhole observation |
Positive dye observation at the sanitary manhole. |
obs_sanitary_manhole |
Boolean |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
Storm manhole observation |
Positive dye observation at the storm manhole. |
obs_storm_manhole |
Boolean |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
Curb outlet observation |
Positive dye observation at the curb outlet. |
obs_curb_outlet |
Boolean |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
Drainage swale observation |
Positive dye observation at the drainage swale. |
obs_drainage_swale |
Boolean |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
Other observation |
Positive dye observation at the other location, defined in the Other Image field of the Photo page. |
obs_other |
Boolean |
|
|
0 |
|
|
|
|
|
||||||||||||||
|
None observed |
Negative dye observation at any of the monitored locations. |
obs_none |
Boolean |
|
|
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 | ||||||||||||||||||||||
| 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. |
button to display the 