<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Reports > Standard Reports > v54 EQuIS Reports

The v54 EQuIS reports, such as Analytical Results and Water Levels, are precursors to current EQuIS reports, such as Analytical Results II and Water Levels II. These reports exist as database functions or stored procedures in the 'v54' database schema, rather than class reports like newer EQuIS reports. Changes to the v54 reports occur with updates to the schema.StandardReports.xme file.

 

 

As of EQuIS 7.25.1 Build

 

As of the EQuIS 7.25.1 Build, v54 reports without dependencies reports were deprecated and stopped being published to the database for new databases, although the underlying database objects are still created. Any v54 reports with dependencies continue to be published.

 

Deprecated and Inactive v54 Reports

 

In databases where deprecated v54 reports have been published (i.e., databases created prior to the 7.25.1 Build), these reports will have ST_REPORT.STATUS_FLAG set to 'R'. The list of deprecated reports is as follows:

•Action Level Exceedance – Database Object: v54.action_level_exceedance

•Action Level Exceedance (by EDD) – Database Object: v54.action_level_exceedance_ebatch

•Anaylte Exceedance – Database Object: v54.analyte_exceedance

•Analytical Results (Aggregate) – Database Object: v54.analytical_result_aggregate

•Analytical Results (QC) – Database Object: v54.analytical_results_qc

•Basic Results – Database Object: v54.basic_results

•Facility Results – Database Object: v54.facility_results

•Location Information – Database Object: v54.location_info

•Location Parameter Exceedance – Database Object: v54.location_parameter_exceedance

•Location Parameters (Most Recent) – Database Object: v54.location_parameter_recent

•Sample Holding Time – Database Object: v54.sample_holding_time

•Sample Parameters – Database Object: v54.sample_parameters

•Sample Parameters (Exceedance) – Database Object: v54.sample_parameter_exceedance

•Sample Parameters (Most Recent) – Database Object: v54.sample_parameter_recent

 

Deprecated but Active v54 Reports

 

A new folder will be created in the RT_GROUP table named 'Deprecated v54 reports.', and the following v54 reports will be moved into the folder. These reports remain active (STATUS_FLAG = 'A') due to dependencies or lack of replacements.

•Analytical Results – Database Object: v54.analytical_results

•Analytical Results (Aggregate) – Database Object: v54.analytical_result_aggregate

•Location Parameters – Database Object: v54.location_parameters

•Location Parameters (Action Level Exceedance) – Database Object: v54.location_parameter_exceedance_al

•Water Levels – Database Object: v54.water_level

 

Retained v54 Reports

 

The following v54 reports are published to the database with ST_REPORT.STATUS_FLAG set to 'A'.

•Analytical Results (Hits) – Database Object: v54.analytical_results_hits

•Facility Results (Summary) – Database Object: v54.facility_results_summary

•Location Parameters (Rollup) – Database Object: v54.location_parameters_rollup

•Sample Parameters (Action Level Exceedance) – Database Object: v54.sample_parameter_exceedance_al

•Soil Gas Survey – Database Object: v54.soil_gas

•Water Levels (Most Recent) – Database Object: v54.water_levels_recent