Alive – Analytical Survey Results

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Alive Module >

Alive – Analytical Survey Results

Report Name: Analytical Survey Results (example)

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

Dependencies: EarthSoft.Reports.Library.50943.dll and EarthSoft.Reports.Library.77486.dll

Software: EQuIS Professional, EQuIS Alive, EQuIS Enterprise

Source: EQuIS Professional install (Alive Module)

Language: English

Output Type: Excel1

 

Description: The Analytical Survey Results Report combines the Analytical Results with Survey Results (Survey Types) Reports into one report.

 

Installation Instructions: This report requires a licensed EQuIS Alive Module and the Alive Schema applied to the database. The report is included in the EQuIS Professional install when the Alive Module feature has been enabled during installation. For more information see: Alive Installation. For Enterprise use, EarthSoft.Reports.Library.77486.dll file must be copied into the Enterprise bin directory.

 

Overview:

This report is accessible via Enterprise provided that any parameter selection(s) are made in Professional, and saved as a User Report.

 

The join by parameter determines the join by condition:

 

Sample – Will link observations to samples based on the AT_SAMPLE_OBSERV table. More information on AT_SURVEY_OBSERV is found in the help article Database - Linking Samples to Observations.

 

Location – Will link survey data to analytic data, based on locations that belong to the survey's subfacility. This link is made in the AT_SUBFACILITY_LOCATION table.

 

Details about the Analytical Results portion of the report, and the Survey Results (Survey Types) portion are found in the following help articles:

Analytical Results II Report

Survey Results (Survey Type)

 

Tables: AT_SUBFACILITY_LOCATION, DT_SAMPLE, DT_TEST, DT_RESULT, RT_ANALYTE, DT_COORDINATE, VW_LOCATION, DT_SURVEY, DT_SURVEY_PARAM, DT_SURVEY_OBSERV, DT_SURVEY_OBSERV_PARAM, RT_SURVEY_TYPE, RT_TAXONOMY, DT_SUBFACILITY, DT_SPATIAL_EXTENT

 

Report Parameters

Join By

Parameter for selecting join by conditions: Sample or Location.

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Use DT_GEOGRAPHY for coordinate data

Toggle to use DT_GEOGRAPHY for coordinate data.

Sample


Type(s)

Select one or more sample types.

Date Range

Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events.

Matrix(es)

Select one or more sample matrix.

Task(s)

Select one or more tasks.

Task_Code_2(s)


Field SDG(s)

Select one or more Field SDG.

Depth

Section for selecting the minimum and maximum start and end depths as well as depth unit.

Minimum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) above that value will be included. Sample with null START_DEPTH will be excluded.

Maximum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) below that value will be included. Sample with null END_DEPTH will be excluded.

Maximum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) below that value will be included. Sample with null START_DEPTH will be excluded.

Minimum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) above that value will be included. Sample with null END_DEPTH will be excluded.

Unit

Select the desired unit for sample depth min/max.

Test


Method(s)

Select one or more test method.

Fraction(s)

Select one or more fraction.

Column Number(s)

Select one or more column number.

Type(s)

Select one or more test type.

Lab Matrix(es)

Select one or more lab matrixes.

Prep Method(s)

Select one or more prep methods.

Lab SDG(s)

Select one or more Lab SDGs.

Result


Analyte

Section for selecting analytes and/or analyte groups.

Unit

Selection for report result units.

Type(s)

Select one or more result type.

Detect Flag(s)

Select one or more options for detect flag.

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Non-Detect Symbol

Enter the desired non-detect symbol ("< ?", "ND", ...).  "?" will be replaced with reporting limit multiplied by non-detect multiplier.

Non-Detect Qualifier

Enter the desired non-detect qualifier (e.g., "U") to have that qualifier override the DETECT_FLAG column.

Reportable

Select one or more options for reportable result.

Validated

Selection for whether the result is validated or not.

Reporting Limit

Select which reporting limit to use (REPORTING_DETECTION_LIMIT, METHOD_DETECTION_LIMIT, etc.)

Format Results\Format Code

Select one format code (e.g., 0.########, 0.0E-00 etc.) predefined or defined in RT_LOOKUP.LOOKUP_DESC with LOOKUP_TYPE = 'ARII_FORMAT'. It applies to REPORT_RESULT_TEXT, REPORT_RESULT_VALUE, and REPORT_RESULT_LIMIT and defaults to empty with no formats applied.

Additional Fields

Additional fields parameter.

Survey


Subfacility

Section for selecting individual and group subfacilities as well as whether or not to include child subfacilities.

Habitat(s)

Parameter for selecting habitat(s).

Observation


Subfacility

Section for selecting individual and group subfacilities as well as whether or not to include child subfacilities.

Taxonomy

Select taxonomy ranks to include (selecting a parent rank will also include all children).

Categories

Select all or individual categories.

Condition(s)

Select all or individual conditions.

Gender(s)

Select all or individual genders.

Life Stage(s)

Select all or individual life stages.

Quantity Estimated

Select blank for all, Y for only estimated quantities, or N for exact quantities only.

Evidence Only

Select blank for all, Y for observations where only evidence was found, or N for only visual observations of the animal.

DT_SURVEY


Vegetation

This section includes parameter selections for ASPECT (Min/Max), DISTURBANCE_TYPE, MOISTURE_REGIME, NATURAL_SUBREGION, PLOTSIZE_FORBGRASS (Min/Max), PLOTSIZE_SHRUB (Min/Max), PLOTSIZE_TREE (Min/Max), SLOPE (Min/Max), STANDING_WATER_CONDITION (Min/Max), STANDING_WATER_PH (Min/Max) and STRUCTURAL_STAGE.

dt_survey_observ


Vegetation

This section includes parameter selections for LAYER, PERCENT (Min/Max), SPP_LINE_NO (Min/Max), and VIGOUR_CLASS.

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

 

 

1Excel report output requires a valid license of Microsoft Excel to view the output.