Results

<< 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

 
Y

 

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

 
Y

 

date (mm/dd/yyyy)

dt_sample.sample_date
(just date part)

 

6

 



 

Field_Collection_Start_Time

 

time (hh:mm:ss)

24hour time

dt_sample.sample_date
(just time part)

 

7

 



Field_Collection_End_Date

 

 
date (mm/dd/yyyy)

 
No Map

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
Normal Samples.

 
If dt_sample.sample_type = "FDS", "FSS", "FRS" or "N"

(assuming N = Normal Environmental Sample).

 
If dt_sample.sample_type_code = "FDS" or "FRS", populate

"Sample Field Replicate ID" = "1".

 
If dt_sample.sample_type_code = "FSS" populate "Sample Sub 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
not handle as conditional. The value in the dt_field.sample.composite-yn will be exported. If this is null on import, EQuIS will default to "N".


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
Import/Export: add remap


 

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(20)

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

 

 
Y

 

 

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)

 
No Map

 

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