Soil Gas Survey

Report Name: Soil Gas Survey (example)

Stored Procedure: v54.soil_gas

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Description: The Soil Gas Survey Report is a simple report for soil gas survey data. Soil Gas data may be entered using the EDGE format.

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps necessary.

Instructions:

Note: The primary key for DT_SOIL_GAS_SURVEY includes SYS_LOC_CODE, SURVEY_DATE and PARAM_CODE. If readings from the same location/date need to be differentiated by depth, then a different time should be entered in SURVEY_DATE to accommodate this.

Input Parameters: A selection made to customize the output of a report.

Tables: RT_GROUP, DT_SOIL_GAS_SURVEY, DT_LOCATION, DT_TASK, DT_EQUIPMENT

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Parameter(s)	Parameter for selecign the param_code.
Date Range	Section to select the start date, and end date.

*This report contains hidden parameter: ebatch.

Report Output
FACILITY_ID FACILITY_CODE SYS_LOC_CODE SURVEY_DATE PARAM_CODE READING READING_UNIT	READING_DEPTH DEPTH_UNIT SAMPLING_METHOD INSTRUMENT_TYPE PARAM DESCRIPTION AREA_DESCRIPTION LITHOLOGY_CODE	EQUIPMENT CODE BOREHOLE_DRILL_METHOD REMARK TECHNICIAN TASK_CODE

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

SURVEY_DATE

PARAM_CODE

READING

READING_UNIT

READING_DEPTH

DEPTH_UNIT

SAMPLING_METHOD

INSTRUMENT_TYPE

PARAM DESCRIPTION

AREA_DESCRIPTION

LITHOLOGY_CODE

EQUIPMENT CODE

BOREHOLE_DRILL_METHOD

REMARK

TECHNICIAN

TASK_CODE

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