Smoke Defect Observation Data Fields
Information relating to a Smoke Defect Observation can be viewed and edited on the Smoke Defect Observation Grid Window of the Survey Grid or the Smoke Defect Observation Property Sheet.
To view and edit all smoke defect observation data, use the Property Sheet.
The following describes all the data which can be used to define a smoke defect observation.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Smoke Defect Observation Data
Database Table Name: cams_smoke_defect
|
Field Name |
Help Text |
Database Field |
Type |
Size |
Units |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
Unique identifier for the smoke defect observation object. |
id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Defect type |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
defect_type |
Text |
64 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Severity |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
severity |
Text |
64 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Location |
Address / description of the location where the smoke defect is observed. |
location |
Text |
100 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Building |
Name of address of building at which smoke defect is observed. |
building |
Text |
64 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Owner |
The proprietor of the asset. |
owner |
Text |
64 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Ground condition |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
ground_condition |
Text |
20 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Comments |
Any additional comments regarding smoke defect observation details. |
comments |
Text |
64 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
ID of associated Smoke Test Survey. |
test_id |
Text |
40 |
|
0 |
|
|
|
|
|
|||||||||||||||||
|
X coord |
X coordinate of smoke defect observation. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||||||||
|
Y coord |
Y coordinate of smoke defect observation. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||||||||
|
Direction |
Direction from which distance measurements are made. Used in conjunction with the Distance along pipe and Direction fields to calculate the X and Y coordinates of the Smoke Defect. See Locating Smoke Defects from Distance Measurements for more information.
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. |
direction |
Text |
15 |
|
0 |
|
|
|
|
|
||||||||||||||||
|
Distance along pipe |
Distance of Smoke Defect Observation from upstream / downstream node (as defined in the Direction field) of surveyed pipe, measured longitudinally along the straight line between pipe connecting nodes. Used in conjunction with the Distance along pipe and Direction fields to calculate the X and Y coordinates of the Smoke Defect. See Locating Smoke Defects from Distance Measurements for more information. |
distance_along_pipe |
Double |
|
L |
2 |
|
|
|
|
|
||||||||||||||||
|
Distance across pipe |
Distance of Smoke Defect Observation from surveyed pipe, measured perpendicular to the pipe. Positive / Negative values represent distance right / left from the pipe, facing it he direction defined in the Direction field. Used in conjunction with the Distance across pipe and Direction fields to calculate the X and Y coordinates of the Smoke Defect. See Locating Smoke Defects from Distance Measurements for more information. |
distance_across_pipe |
Double |
|
L |
2 |
|
|
|
|
|
||||||||||||||||
| Date opened | The date when the smoke observation was opened. | date_opened | Date / Time | 0 | |||||||||||||||||||||||
| Completed | Indicates whether task has been completed or is still pending. | completed | Boolean | 0 | |||||||||||||||||||||||
| Date completed | Date observation was completed. | date_completed | Date / Time | 0 | |||||||||||||||||||||||
| Closed | A checked field indicates that the observation has been closed. | closed | Boolean | 0 | |||||||||||||||||||||||
| Date closed | Date observation was closed. | date_closed | Date / Time | 0 | |||||||||||||||||||||||
| 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 Network Data Fields Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.
