EIA: Samples by Type Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > EIAs (EQuIS Information Agents) >

EIA: Samples by Type Report

Report Name: EIA: Samples by Type (example)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

 

Description: The EIA: Samples by Type report generates a summary of data from the DT_SAMPLE table based on a user-defined DT_SAMPLE.SAMPLE_TYPE value. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

 

Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database. For SPM usage, no additional steps are necessary. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

 

Overview:

When run as an EDD-triggered EIA in EQuIS Enterprise, the report will check the incoming EDD for SAMPLE_TYPE values matching the selection parameter. For example, if a SAMPLE_TYPE of "NST" (no sample taken) is selected and exists in the EDD, the report will generate output.

 

Tables: DT_FIELD_SAMPLE, DT_SAMPLE

 

Report Parameters *

Sample Type

Parameter to select sample type.

 

* This report contains the following hidden parameter(s) that could affect the outcome of the report:

ebatch

Facility_ID

 

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

 

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

 

 

 

Report Output

FACILITY_ID

SAMPLE_ID

SYS_SAMPLE_CODE

SAMPLE_NAME

DATA_PROVIDER

SAMPLE_CLASS

SYS_LOC_CODE

CAT_SAMPLE_CODE

START_DEPTH

SAMPLE_SOURCE

SAMPLE_TYPE_CODE

DEPTH_UNIT

END_DEPTH

SAMPLE_DESC

DURATION

DURATION_UNIT

SAMPLE_METHOD

SAMPLE_DATE

REMARK

TASK_CODE

LAB_SOLUTION_SOURCE

EQUIPMENT_CODE

PARENT_SAMPLE_CODE

MEDIUM_CODE

MATRIX_CODE

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

EBATCH

ALT_LIMITS

BASELINE_YN

TASK_CODE_2

EUID

WEATHER_CONDITION

SAMPLE_START_DATE

SPM_SAMPLE_ID

FACILITY_ID1

SAMPLE_ID1

CHAIN_OF_CUSTODY

EQUIPMENT_CAL_DATE

FIELD_SDG

COLL_PROC_CODE

COLLECTION_QUARTER

SENT_TO_LAB_DATE

SAMPLE_RECEIPT_DATE

COMPOSITE_YN

COMPOSITE_DESC

SAMPLER

SAMPLING_COMPANY

SAMPLING_REASON

FILTER_TYPE

AIR_VOLUME

AIR_VOLUME_UNIT

REMARK1

EBATCH1

EUID1

FLD_QUALIFIER

FLD_QUALIFIER_NOTE

FILTERED_DATE

 

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