EDGE Equipment and Datalogger Report

Report Name: EDGE Equipment and Datalogger Report (example1) (example2) (example3)

File Name: EarthSoft.Reports.Library.112235.dll

Dependencies: Licensed EDGE Module and EDGE Schema

Software: EDGE

Source: EDGE install

Language: English

Output Type: Excel1

Description: The EDGE Equipment and Datalogger Report creates three different reports (Data Logger Device History, Data Logger Site Visit History, and Data Logger Device Location) based on selection of the Report Type parameter.

Installation Instructions: This report requires a licensed EDGE Module and the EDGE Schema applied to the database. For EQuIS Professional use, copy the EarthSoft.Reports.Library.112235.dll file from the EDGE\reports installation directory to the EQuIS Professional installation folder. For default installations, this directory is C:\Program Files\EarthSoft\EQuIS. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview:

Report Parameters

Facility(s)	Parameter for selecting facility(s).
Equipment
Type(s)	Parameter for selecting equipment type(s).
Code(s)	Parameter for selecting equipment code(s).
Location(s)	Parameter for selecting equipment location(s).
Data Logger
Activity	Parameter for selecting data logger activity.
Parameter(s)	Parameter for selecting data logger parameter(s).
Date Range	Parameter for selecting start and end date ranges.
Report Type	Parameer for selecting report type: Data Logger Device History, Data Logger Site Visit History, or Data Logger Device Location.

Report Parameters

Data Logger Device History

EQuIS Data Tables	Output
DT_FACILITY.FACILITY_CODE	Facility Code
DT_LOCATION_PARAMETER.SYS_LOC_CODE	Location
DT_EQUIPMENT.EQUIPMENT_CODE	DEVICE
DT_EQUIPMENT.EQUIPMENT_TYPE	Model
DT_EQUIPMENT.REMARK	Device Comment
DT_LOCATION_PARAMETER.MEASUREMENT_DATE	Session Date
RT_LOCATION_PARAM_TYPE.PARAM_DESC	Activity
DT_LOCATION_PARAMETER.PARAM_VALUE	Value
DT_LOCATION_PARAMETER.REMARK	Comments

Data Logger Site Visit History

EQuIS Data Tables	Output
DT_FACILITY.FACILITY_CODE	Facility Code
DT_LOCATION_PARAMETER.MEASUREMENT_DATE	Measurement Date
DT_LOCATION_PARAMETER.SYS_LOC_CODE	Location Code
DT_EQUIPMENT.EQUIPMENT_CODE	Equipment Code
DT_EQUIPMENT.EQUIPMENT_TYPE	Model Number
RT_LOCATION_PARAM_TYPE.PARAM_DESC	Activity
When RT_LOCATION_PARAM_TYPE.PARAM_DESC='comment' then DT_LOCATION_PARAMETER.REMARK else DT_LOCATION_PARAMETER.PARAM_VALUE	Value

Data Logger Device History

EQuIS Data Tables	Output
DT_FACILITY.FACILITY_CODE	Facility Code
DT_EQUIPMENT.SYS_LOC_CODE	Location
DT_EQUIPMENT.INSTALL_DATE	Date Installed
DT_EQUIPMENT.EQUIPMENT_CODE	Serial #
DT_EQUIPMENT.OPERATION_STATUS	Operation Status

1Excel report output requires a valid license of Microsoft Excel to view the output.