Data Logger Data Fields (Distribution)
Data Logger data can be edited on either the Data Logger Grid Window of the Asset Grid or the Data Logger Property Sheet.
To view and edit all data logger data, use the Property Sheet.
The following describes all the data which can be used to define a data logger.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Data Logger Data
Database Table Name: wams_data_logger
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
The name of the object. The ID is the primary key in the database for the network object. This means that the ID field of each object must be unique for all objects of the same object type. |
id |
Text |
40 |
|
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 |
|
|
|
|
|
||||||||||
| Operational status |
Current status:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
operational_status | Text | 20 | 0 | ||||||||||||||||
|
X coord |
X coordinate of the object. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||
|
Y coord |
Y coordinate of the object. |
y |
Double |
|
XY |
0 |
|
|
|
|
|
||||||||||
|
Type |
The type of ancillary structure.
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
type |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Manufacturer |
The name of the company who fabricated the asset. |
manufacturer |
Text |
20 |
|
0 |
|
|
|
|
|
||||||||||
|
Communications link |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
comm_link |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Serial number |
Data logger serial number. |
serial_no |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Power supply |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
power_supply |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Battery life |
Design life of logger battery. |
battery_life |
Double |
|
TS |
2 |
|
|
|
|
|
||||||||||
|
Data storage capacity |
Number of readings that can be stored by logger. |
data_storage_capacity |
Double |
|
|
2 |
|
|
|
|
|
||||||||||
|
Inspection frequency |
Time interval between inspections of logger installation. |
inspection_frequency |
Double |
|
TS |
2 |
|
|
|
|
|
||||||||||
|
Programmed by |
Name of person or contractor that programmed the logger. |
programmed_by |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Date programmed |
Date logger was programmed. |
date_programmed |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||||||
|
Installed by |
Name of person or contractor that installed the logger on network |
installed_by |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Date installed |
The date when the asset was installed (DD/MM/YYYY). Used in costing reports in conjunction with the cost index. |
date_installed |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||||||
|
Removed by |
Name of person or contractor that removed logger from network. |
removed_by |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Date removed |
Date logger was removed from network. |
date_removed |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||||||
|
Downloaded by |
Name of person or contractor that downloaded logger readings. |
downloaded_by |
Text |
32 |
|
0 |
|
|
|
|
|
||||||||||
|
Date downloaded |
Date logger readings were downloaded. |
date_downloaded |
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. | ||||||||||||||||||||
| Time series links |
Click the |
tsdb_links |
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.
