Flow Statistics

Report Name: Flow Statistics (example)

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

Dependencies:N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Flow Statistics Report presents the statistics of DT_FLOW that meet users’ selected parameters. When action level parameters are selected, the report examines the statistical values of instant_flow, average_flow or cumulative_flow with the selected action levels and flags a value if it breaks an action level value.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

Statistical Calculation:

1.First, select a field of DT_FLOW to be calculated in the Statistics\Flow Type: parameter.

2.Second, select the Statistics\Aggregate By parameter as explained below.

a.When Statistics\Aggregate By is Year, the statistical values are calculated for each group of facility_id, sys_loc_code, flow_unit and the year of the measurement_start_date.

b.When Statistics\Aggregate By is Month, the statistical values are calculated for each group of facility_id, sys_loc_code, flow_unit and the year-month of the measurement_start_date.

c.When Statistics\Aggregate By is All, the statistical values are calculated for each group of facility_id, sys_loc_code, flow_unit and the (minimum – maximum) of the measurement_start_date.

Action level and violation:

Naming convention and the logic on linking action_level to flow measurement:

1.DT_ACTION_LEVEL_PARAMETER.PARAM_CODE must start with instant_, average_ or cumulative_ in order to link an action level to instant_flow, average_flow or cumulative_flow respectively.
Warning: The report will ignore action level information if a selected action level code with the DT_ACTION_LEVEL_PARAMETER.PARAM_CODE of no prefix instant_, average_ or cumulative_.

2.The final field name of an action level of DT_ACTION_LEVEL_PARAMETER in the report result is constructed with PARAM_CODE_ACTION_LEVEL_CODE.

3.The final field name of flagging an action level is constructed with param_code_action_level_code_flag.

4.If a value of the Flow Unit parameter is selected, the report will do a unit conversion for an action level from DT_ACTION_LEVEL_PARAMETER.UNIT to the flow unit.

5.Action level violation or flagging exceedances: when an instant_flow, average_flow or cumulative_flow exceeds the action_level value of its param_code, the value of the param_code_action_level_code_flag is populated with x.

Tables: DT_FLOW

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations
Group(s)	Parameter for selecting location groups
Flow
Date Range (Start\|End)	Section to select the flow start date, and end date
Task(s)
Method(s)
Unit
Statistics
Flow Type	Select one or more flow methods from DT_FLOW
Aggregate By
Action Level
Action Level(s)
Comparison
Operator

Report Output
SYS_LOC_CODE EQUIPMENT_CODE PARAM_CODE INTERVAL_START_DATE or MEASUREMENT_DATE or MYYEAR TIME_INT REPORT_FLOW_VOLUME WARNING_LEVEL_MAX	ACTION_LEVEL_MAX MAX_WARNING_LEVEL_HIT MAX_ACTION_LEVEL_HIT WARNING_LEVEL_MIN ACTION_LEVEL_MIN MIN_WARNING_LEVEL_HIT	MIN_ACTION_LEVEL_HIT REPORT_FLOW_VOLUME_UNIT ACTION_LEVEL_REMARK AVERAGE_REPORT_FLOW_RATE or REPORT_FLOW_RATE REPORT_FLOW_RATE_UNIT

Report Output

SYS_LOC_CODE

EQUIPMENT_CODE

PARAM_CODE

INTERVAL_START_DATE

or MEASUREMENT_DATE

or MYYEAR

TIME_INT

REPORT_FLOW_VOLUME

WARNING_LEVEL_MAX

ACTION_LEVEL_MAX

MAX_WARNING_LEVEL_HIT

MAX_ACTION_LEVEL_HIT

WARNING_LEVEL_MIN

ACTION_LEVEL_MIN

MIN_WARNING_LEVEL_HIT

MIN_ACTION_LEVEL_HIT

REPORT_FLOW_VOLUME_UNIT

ACTION_LEVEL_REMARK

AVERAGE_REPORT_FLOW_RATE

or REPORT_FLOW_RATE

REPORT_FLOW_RATE_UNIT

Data Requirements: For general output, DT_FLOW must be populated. For action level output, DT_ACTION_LEVEL_PARAMETER.PARAM_CODE must start with instant_, average_ or cumulative_ in order to link an action level to instant_flow, average_flow or cumulative_flow respectively.

Report Requirements: N/A

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML or a printer.