Data Logger Data Fields (Collection)

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: cams_data_logger

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

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 operational status:

Database Value

Description

AB

Abandoned

INUSE

In Use

STANDBY

Standby

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

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.

Database Value

Description

M1L

Microlog 1L

M2L

Microlog 2L

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

Database Value

Description

MAN

Manual Read

SCADA

Scada

TEL

Telephone

RADIO

Radio

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

Database Value

Description

MAIN

Mains

BAT

Battery

NONE

None

UNKNOWN

Unknown

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 logger on the 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 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.                    
Time series links

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 data logger.

tsdb_links                  
Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Data Logger

Asset Grid