|
<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > Standard Reports > Flow > Flow Rate Report |
Report Name: Flow Rate (example1) (example2)
File Name: EarthSoft.Reports.Library.95862.dll
Dependencies: N/A
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install
Language: English
Output Type: Report Grid1
Description: The Flow Rate Report calculates the volumes and rates of instant flow and cumulative flow per selected time interval based on the data from the DT_FLOW table. It also compares flow rate (for Flow-Inst) or flow volume (for Flow-Daily, etc.) to action levels, if action level data are provided.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.
Flow Volume and Rate Calculations:
The report first sorts the data from the DT_FLOW table by SYS_LOC_CODE, EQUIPMENT_CODE, PARAM_CODE, and MEASUREMENT_DATE. For general output, DT_FLOW must be populated. Specifically, DT_FLOW.EQUIPMENT_CODE must be populated before the report will produce an output. For action level output for all flow rate types, the action level must include a flow rate volume parameter with DT_ACTION_LEVEL_PARAMETER.PARAM_CODE = Flowratevol.
For Summary Method = Flow - Inst (instant flow volume), the report output columns are calculated as follows:
TIME_INT = DT_FLOW.MEASUREMENT_START_DATE2 – .MEASUREMENT_START_DATE1
REPORT_FLOW_VOLUME = DT_FLOW.INSTANT_FLOW (or CUMULATIVE_FLOW)2 – instant_flow (or cumulative_flow)1
REPORT_FLOW_RATE = (instant_flow (or cumulative_flow)2 – instant_flow (or cumulative_flow)1)/time_int
Where,
1 means the measurement at a datetime
2 means the measurement immediately after 1
Note that Unit from screen prompt = volume unit / time unit (e.g., gal/day). TIME_INT will be converted from day to the time unit if the time unit is not day; INSTANT_FLOW_UNIT or CUMULATIVE_FLOW_UNIT are converted to the volume unit.
For all other flow rates ("Flow - Daily", "Flow - Weekly", "Flow - Monthly", "Flow - Quarterly" or "Flow - Annual"), the report does the calculations in the selected time interval below:
TIME_INT = Sum of the TIME_INT of the Flow – Inst
REPORT_FLOW_VOLUME = Sum of REPORT_FLOW_VOLUME of the Flow –Inst
REPORT_FLOW_RATE = Average of the REPORT_FLOW_RATE of the Flow – Inst
Action Level and Violation:
DT_ACTION_LEVEL_PARAMETER.PARAM_CODE = Flowratevol is required.
The flow MEASUREMENT_DATE output is greater than or equal to DT_ACTION_LEVEL.START_DATE but less than DT_ACTION_LEVEL.END_DATE.
When a grouped action level is selected, the action level data associated to SYS_LOC_CODEs comes from DT_ACTION_LEVEL/parameter links: RT_GROUP_MEMBER on FACILITY_ID and ACTION_LEVEL_CODE = MEMBER_CODE, at_SUBFACILITY_LOCATION on FACILITY_ID and MEMBER_CODE = SUBFACILITY_CODE, and DT_PERMIT on FACILITY_ID and PERMIT_NUMBER.
When an action level is selected, the action level data associated to SYS_LOC_CODEs come from DT_ACTION_LEVEL/parameter links: DT/AT_SUBFACILITY on FACILITY_ID and SUBFACILITY_CODE, and DT_PERMIT on FACILITY_ID and PERMIT_NUMBER.
When there are no SYS_LOC_CODEs associated action levels, non-located action level data come from DT_ACTION_LEVEL/parameter.
MAX_WARNING_LEVEL_HIT/MAX_ACTION_LEVEL_HIT is 'Y' if REPORT_FLOW_VOLUME is greater than or equal to WARNING_LEVEL/ACTION_LEVEL.
MIN_WARNING_LEVEL_HIT/MIN_ACTION_LEVEL_HIT is 'Y' if REPORT_FLOW_VOLUME is less than or equal to WARNING_LEVEL_MIN/ACTION_LEVEL_MIN.
Action Level Data Examples

Notes: •To display the action level and action level group parameters, the report must be published to toggle those settings to visible in the ST_REPORT_PARAMETER table. •By default, the available input units for this report are limited to those where RT_UNIT.UNIT_TYPE = rate-v (volume rate). The default may be revised. For additional information, see Adding Unit Types to Report Parameter Selections. |
Tables: DT_FLOW
Data Requirements: For general output, DT_FLOW must be populated. Specifically, DT_FLOW.EQUIPMENT_CODE must be populated before the report will produce an output. For action level output for all flow rate types, the action level must include a flow rate volume parameter with DT_ACTION_LEVEL_PARAMETER.PARAM_CODE = Flowratevol.
Report Parameters |
||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 |
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2026 EarthSoft, Inc. • Modified: 03 Nov 2026