Flow Data

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Flow >

Flow Data

Report Name: Flow Data (example)

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

Dependencies: This report does not have any dependencies.

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The Flow Data Report presents the data information of DT_FLOW that meet users’ selected parameters. When action level parameters are selected, the report examines 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:

 

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


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

 

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.