|
<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Custom Reports > EIM Export > EIM Export Mapping > Results |
Field Name |
Required |
Datatype |
EQuIS Mapping |
Sort Order |
Remap |
Notes |
Default |
Study_ID |
Y |
varchar(20) |
dt_sample.task_code dt_task.task_code |
1 |
|
||
Location_ID |
Y |
varchar(15) |
dt_location.sys_loc_code |
2 |
|
||
Study_Specific_Location_ID |
Y |
varchar((40) |
dt_location.sys_loc_code |
3 |
|
Export/Report: same mapping as Location_ID |
|
Field_Collection_Type |
|
varchar(11) |
No Map |
4 |
|
Enum: Sample; Measurement; Observation Import/Export: This field is referenced from other fields |
default "Sample" |
Field_Collector |
Y |
varchar(15) |
No Map |
5 |
|
enumeration |
|
Field_Collection_Start_Date |
|
date (mm/dd/yyyy) |
dt_sample.sample_date |
6 |
|
||
Field_Collection_Start_Time |
|
time (hh:mm:ss) 24hour time |
dt_sample.sample_date |
7 |
|
||
Field_Collection_End_Date |
|
|
|
8 |
|
Import/Export: this could be figured out from dt_sample.duration and duration_unit |
|
Field_Collection_End_Time |
|
time (hh:mm:ss) 24hour time |
No Map |
9 |
|
Import/Export: see note above |
|
Field_Collection_Comment |
|
varchar(20000) |
dt_field_sample.remark |
10 |
|
||
Field_Collection-Area |
|
numeric |
No Map |
11 |
|
Import/Export: this can be mapped if Alive structure is used |
|
Field_Collection_Area_Units |
|
varchar(10) |
No Map |
12 |
|
Import/Export: see note above |
|
Field_Collection_Reference_Point |
|
varchar(30) |
No Map |
13 |
|
Import/Export: enum: Land Surface; Water Surface; Sediment Surface; Floor of Structure |
|
Field_Collection_Upper_Depth |
|
numeric |
dt_sample.start_depth |
14 |
|
||
Field_Collection_Lower_Depth |
|
numeric |
dt_sample.end_depth |
15 |
|
||
Field_Collection_Depth_Units |
|
varchar(10) |
dt_ample.depth_unit |
16 |
|
cm; rn; in; ft |
|
Well_Water_Level_Measuring_Point_or_TOC_ID |
|
varchar(8) |
No Map |
17 |
|
Import/Export: add logic - if this field is populated, display warning that says, "Use Water Levels template to submit water level data" |
|
Sample_ID |
Y |
varchar(50) |
dt_sample.sys_sample_code |
18 |
|
||
Sample_Field_Replicate_ID |
|
varchar(4) |
No Map |
19 |
|
Import/Export: add logic for populating |
|
Sample_Replicate_Flag |
|
varchar(1) |
Version 1 of the Export/Report EarthSoft encourages only selecting normal samples.
Export/Report: check the dt_sample.sample_type_code to make sure it is a normal field sample.
Check the sample_type_code against rt_sample_type.sample_type_class if <> to "NF" then Export/Report = "N" Sample_type_class will indicate if the sample is a normal field sample or qc.
For Version 1 of the export only normal samples will be exported. |
20 |
|
Export/Report: Version 1 of this export. EarthSoft will export only (assuming N = Normal Environmental Sample). "Sample Field Replicate ID" = "1". Import/Export: add logic for populating dt_sample.sample_type_code |
|
Sample_Sub_ID |
|
varchar(4) |
No Map |
21 |
|
Import/Export: add logic for populating |
|
Sample_Composite_Flag |
Y |
varchar(1) |
dt_field_sample.composite_yn |
22 |
|
This is handled as a conditionally required field in WA-EIM. EQuIS does |
|
Storm_Event_Qualifier |
|
varchar(3) |
No Map |
23 |
|
EIM enumeration lookup list |
|
Sample_Matrix |
Y |
varchar(14) |
dt_sample.medium_code rt_medium.medium_code |
24 |
Y |
Report/Export: export value in dt_sample.medium_code |
|
Sample_Source |
Y |
varchar(30) |
rt_matrix.matrix_desc |
25 |
|
Report/Export: export value in dt_sample.matrix_desc Import/Export: add remap |
|
Sample_Use |
|
varchar(1) |
No Map |
26 |
|
Import/Export: add logic for conditionally required |
|
Sample_Collection_Method |
|
varchar(20) |
dt_sample.sample_method rt_sample_method.method_code |
27 |
Y |
Import/Export: remap |
|
Sample_Preparation_Method |
|
varchar(20) |
dt_test.prep_method rt_prep_method.prep_method |
28 |
Y |
Import/Export: remap |
|
Sample_Method_Other |
|
varchar(60) |
dt_test.preservative rt_preservative.preservative |
29 |
Y |
Import/Export: remap |
|
Sample_Taxon_Name |
|
varchar(254) |
No Map |
30 |
|
Import/Export: this can be mapped if Alive structure is used |
|
Sample_Taxon_TSN |
|
varchar(10) |
No Map |
31 |
|
Import/Export: this can be mapped if Alive structure is used |
|
Sample_Tissue_Type |
|
varchar(254) |
No Map |
32 |
|
Import/Export: this can be mapped if Alive structure is used |
|
Sample_Percent_Sorted |
|
numeric(3) |
No Map |
33 |
|
||
Result_Parameter_Name |
Y |
varchar(254) |
rt_analyte_var.chemical_name_var var_system = "EIM_EXPORT" |
34 |
|
||
Result_Parameter_CAS_Number |
|
varchar(15) |
dt_result.cas_rn Report/Export: rt_analyte_var.cas_rn_var var_system = "EIM_EXPORT" |
35 |
|
||
Lab_Analysis_Date |
Y |
date (mm/dd/yyyy) |
dt_test.analysis_date (date only) |
36 |
|
||
Lab_Analysis_Date_Accuracy |
|
varchar(1) |
No Map |
37 |
|
||
Lab_Analysis_Time |
|
time (hh:mm:ss) 24hour time |
dt_test.analysis_date (time only) |
38 |
|
||
Result_Value |
Y |
numeric |
dt_result.result_text |
39 |
|
||
Result_Value_Units |
Y |
varchar(10) |
dt_result.result_unit |
40 |
|
||
Result_Reporting_Limit |
|
numeric |
dt_result.reporting_detection_limit |
41 |
|
Import: populate dt_result.detection_limit_unit with "Result_Value_Units" |
|
Result_Reporting_Limit_Type |
|
varchar(9) |
No Map Export/Report default: "MRL" if dt_result.reporting_detection limit is populated |
42 |
|
MRL; PQL; EQL; LOQ; SQL; CRQL; LabDef; UNKNOWN |
|
Result_Detection_Limit |
|
numeric |
dt_result.method_detection_limit |
43 |
|
||
Result_Detection_Limit_Type |
|
varchar(9) |
No Map Export/Report default: "MDL" if dt_result.method_detection_limit is populated |
44 |
|
MDL; EDL; LOD; IDL; CRDL; UNKNOWN |
|
Result_Data_Qualifier |
|
varchar(3) |
dt_result.interpreted_qualifiers |
45 |
Y |
Import/Export: remap |
|
Fraction_Analyzed |
|
varchar(15) |
dt_test.fraction rt_fraction.fraction (possibly export fraction_desc) |
46 |
Y |
Import/Export: possible remap or export rt_fraction.fraction.desc |
|
Field_Filtered_Flag |
|
varchar(1) |
No Mapping Export/Report - if dt_test.fraction=D then export "Y" |
47 |
|
Y;N;U |
|
Result_Basis |
|
varchar(3) |
dt_test.basis |
48 |
|
Wet; Dry |
|
Digestion_Method |
|
varchar(20) |
No Map |
49 |
|
Total; Complete |
|
Water_Level_Accuracy |
|
varchar(3) |
|
50 |
|
Import/Export: enum |
Null for leachate fraction |
Result_Method |
Y |
varchar(20) |
dt_test.analytic_method |
51 |
Y |
Import/Export: remap |
|
Result_Comment |
|
varchar(2000) |
dt_result.remark |
52 |
|
||
Result_Additional_Comment |
|
varchar(2000) |
dt_test.remark |
53 |
|
||
Result_Lab_Replicate_ID |
|
varchar(4) |
No Map |
54 |
|
Import/Export: need to add logic for populating |
|
Result_Lab_Name |
|
varchar(254) |
dt_test.lab_name_code |
55 |
Y |
Import/Export: remap |
|
Result_Validation_Level |
|
varchar(5) |
No Map |
56 |
Import/Export: use same mapping as EPA formats |
||
Result_Taxon_Name |
|
varchar(254) |
No Map |
57 |
Import/Export: this can be mapped if Alive structure is used |
||
Result_Taxon_TSN |
|
varchar(10) |
No Map |
58 |
Import/Export: this can be mapped if Alive structure is used |
||
Result_Taxon_Unidentified_Species |
|
varchar(10) |
No Map |
59 |
Import/Export: this can be mapped if Alive structure is used |
||
Result_Taxon_Life_Stage |
|
varchar(50) |
No Map |
60 |
Import/Export: this can be mapped if Alive structure is used |
||
|
|
||||||
Notes - Export/Report |
|
|
|||||
Selection should include sample_type_code, matrix, sample_date, analyte or analyte_group (if there are no results for one of the group members, do not include in the report). Export only results where dt_result.reportable_result = "Y" and dt_result.result_type_code = "TRG". |
|
|
|||||
Locations for samples should correspond to the lcoations in the Locations tab. |
|
|
|||||
dt_sample.task_code does not need to be populated. User can enter their own EIM-correct value after report is run. |
|
|
|||||
|
|
||||||
Defaults |
|
Value |
Field |
Field |
|||
|
Y |
dt_result.reportable_result |
reportable_result |
Copyright © 2024 EarthSoft, Inc. • Modified: 11 Jun 2021