STORET Interface Module (SIM)
Version 2.0
User Guide and
Reference Manual
STORET
US Environmental Protection Agency
Gold Systems, Inc
Updated June 16,2003
Technical Support:
1-800-424-9067
-------
Contents
1: Introduction 1
2: Formatting Your Data 2
3: Tutorial I. Defining an Import Configuration 4
4: Tutorial II. Using SIM to Migrate Data to STORET 8
5: Tutorial III. Advanced Functions 11
6: System Configuration Definitions 16
Appendix A: Listing of Available STORET Data Elements for Each File Type 18
-------
SIM v2.0 User Guide
Build Number 9
Introducing SIM v2.0
The STORET Interface Module (SIM) Version 2.0 is a software program that helps users load
data into STORET Version 2.0. STORET is an EPA-maintained database of ambient
environmental data. STORET is a distributed system where individual agencies manage their
own data at a local level and can use a national data warehouse to share it with others. Both
STORET and SIM operate in an Oracle environment and can be implemented on a personal
desktop or on a client/server basis.
To use SIM, you must perform the following tasks:
Organize your data into delimited text files
Establish SIM Import Configurations that describe the format of your text files
Import your text files into SIM and migrate the data that passes validation into
STORET
This User Guide and Reference Manual will:
Provide guidance to you as you create your delimited text files
Teach you how to create a SIM Import Configuration
Walk you through the process of using SIM to load data into STORET
The successful use of SIM is dependant on your clear understanding of STORET. You
should establish all relevant metadata defaults in STORET before you begin to use SIM.
Using this Tutorial
This tutorial is designed to provide you with "hands on" instruction for using SIM. Each
lesson focuses on different pieces of functionality included in SIM. There are text descriptions
of the functions and associated concepts, and then there are step-by-step instructions for using
the tools. The step-by-step instructions for you to follow on your PC are called out into text
boxes, separate from the text.
1 .This is an example of a text box that contains instructions for using the Toolkit with the sample
data.
STORET Interface Module (SIM)
-------
SIMv2.0 User Guide
Build Number 9
Formatting Your Data
Before using SIM, you must organize your data into delimited text files. Most organizations use common
software products such as Excel, Access, or Lotus 1-2-3 to create data tables, which can be saved and exported
as delimited text files. Larger organizations may produce these files as exports from existing Data Management
or Laboratory Information Management Systems (LIMS). SIM accepts six different file types:
1. Project Descriptions
Initiatives or reasons why data was collected.
2. Station Descriptions
Points or areas where field measurements are made or samples are collected.
3. Additional Locations
Points that define boundaries, sample locations, or observation sites within a station.
4. Wells
Wells that are constructed to gather samples or field measurements.
5. Field Measurements and Non-biological Samples
Results of field measurements or the analysis of non-biological samples.
6. Biological Samples
Results associated with biological samples.
The data in the six file types complement each other and the order in which you migrate data files to
STORET is important. Station Descriptions should always be loaded before Additional Locations and Wells.
Project Descriptions and all the station information files should always be loaded before your result files. This
insures that the key data elements will be registered in STORET and are ready for results to be associated with
them.
The data elements or fields in each file type are organized in a tabular format where the column delimiter is
either a Tab (), Pipe (|), Tilde (~), or Comma Q.1 Additionally, a sub-delimiter (\) is available for columns that
can accept multiple values.2 The required and optional elements for each file type are described in Appendix A.
Note that many of these data elements have a list of valid values that the user must select from. The order in
which you place the data elements in your delimited text files is not important as SIM allows you to define that
order before you import your file. Do not include a header row in the delimited text files that you create.
1 If any of these characters appear in your data, you should NOT use that character as a delimiter since there is no way for SIM to tell
which is the delimiter and which is simply part of the data.
2 Certain fields such as Project ID in the 'Field Measurements and Non-Biological Samples' can accept multiple values in a single
column and row of the import file. See Appendix A for a list of columns that support loading multiple values.
STORET Interface Module (SIM)
-------
SIMv2.0 User Guide
Build Number 9
There are several example text files in the C:\STORET\orasto2\SIM\SIM200_EXAMPLES directory that
may help you as you organize your data.
STORET Interface Module (SIM)
-------
SIMv2.0 User Guide
Build Number 9
Tutorial I. Defining an Import Configuration
The following lesson will show you how to create a custom Import Configuration that will describe the
format of your text files.
1. Begin by starting SIM.
SIM vj.00
Slviret luiertiK-e Module
^^J
2. From this screen, you can either start a new import of data or access an existing import that you may
have brought into SIM but have yet to migrate to the STORET database.
Wlial type of cbla da you wish to
import f« naanton into STORET?
Projrcl Dcvcnpbon*
Slitions md Slition I
imp
3. From this New Import menu, you select the type of file that you wish to import into SIM. If you
choose Stations and Station Details, you will be prompted to select a secondary type.
Click [Field Measurements and Non-biological Samples.
STORET Interface Module (SIM)
4
-------
SIMv2.0 User Guide
Build Number 9
4. This menu allows you to specify the Import Configuration and the path to the text file that you want
to import.
Click Define New Import Configuration
mportType \
Import .
Configuration '
Organization ID |
Deling Men Impart Configuration
5. From this SIM Import Configuration menu, you can:
a) Provide a name and description for the Import Configuration
b) Define the organization that this data will load into.
c) Indicate the delimiter that will be used in the text file.
d) Select the data elements that will be included in the text file.
e) Define the position or order in which the data elements will appear in the file.
f) Establish default values for the data elements in the import file that are left null or blank.
g) View the format that each row in the import file must adhere to if this configuration is used.
h) Establish how individual data elements will be additionally formatted (if appropriate).
i) Establish translation parameters that change values while a file is being imported.
STORET Interface Module (SIM)
-------
SIMv2.0 User Guide
Build Number 9
7. You can establish a translation by defining the "Code" that should be translated and the value that it
should be "Translated To". Users can use the arrows at the end row of each data elements to translate to
valid STORET values (if they exist).
Click |Close| and then the llnstructionsi tab on the Import Configuration menu.
8. You can use this menu to establish general import instructions. Change an instruction by
highlighting a row and clicking the relevant arrow. If you choose to "create translations...", the
software will populate the "Code" field on the Translations menu with any values that do not match
required valid values. You must then fill in the "Translate To" field and re-import the file for the
changes to take place. Other instructions allow you to auto-generate Trip IDs and Visit Numbers.
STORET Interface Module (SIM)
6
-------
SIMv2.0 User Guide
Build Number 9
Summary
The purpose of an import configuration is to set up a pattern to translate your data file into
STORET by using SIM. SIM import configurations can help you set up the order of fields,
format data, and perform simple data translations.
In Tutorial I. Defining an Import Configuration, you learned how to:
Define a new import configuration
Save a new import configuration
Use translations to change values while a file is being imported.
STORET Interface Module (SIM)
-------
SIMv2.0 User Guide
Build Number 9
Tutorial II. Using SIM to Migrate Data to STORET
This tutorial illustrates the following:
The Import of a text file into SIM so that it can be validated against the STORET database.
The Migration of data that passes validation from the temporary SIM tables into STORET.
]
(
1
. Follow Steps 1-3 in Tutorial 1 to reach the Import File menu for Field Measurements and Non-biological
Samples.
^E ^|9[©]u]
ImportType |n
Configuration '
Organization ID
Define Wen Import Configuration
Textfile name CAOrs£lij2\iirri\iirri2l]CLejr
r~n i
I
>. This screen provides a list of Import Configurations that have been created in SIM. Highlight "Example-
"ield Measurements" and click OK.
yj^ ^|B@£
ImportType |
Configuration lEpb ' Fldd M==»» I
Organization ID pEMi
Deline New Import Configuiation Edit Existing Import Contjguiation
Text tile name |C:VOrasto2\sim\sim200_ examples Browse
STORET Interface Module (SIM)
-------
SIM v2.0 User Guide
Build Number 9
4. The name of the Import Configuration and the Organization to which the data will be associated should
now appear on the Import File menu. You can review the configuration details by clicking the button
labeled "Edit Existing Import Configuration".
You must now define the path to the file that you want to import. Click [Browse
.
5. This menu allows you to navigate your drives and directories to locate the appropriate file.
Select "C:\STORET\orasto2\SIM\SIM200_EXAMPLES\Example - Field Measurements" and click [Open
Note - Based on your original installation parameters, the example files may be located on a different path
on your system.
ImportType ft'
"npotl
Co i
infiguration |E,Ple- Field M8a,u,emenS
Organization ID |
Deline Hew Import Configuration
Textile name |C:\STORET\orasto2\SIM\SIM:
IMPORT
6. The name of the text file should now appear on the Import File menu.
Now click |IMPORT| and then |OK| when the import is complete.
STORET Interface Module (SIM)
-------
SIM v2.0 User Guide
Build Number 9
7. SIM checked the file for errors that would prevent the data from being loaded to STORET and it has
imported the data into a series of temporary tables.
From this Import Status menu, you can:
a) Review the number of records that that SIM imported, the number of those records that had errors,
and the number of those records that are ready to be migrated to STORET.
b) View import errors for the entire file and/or preview records with errors on a record-by-record basis.
c) Delete an import from SIM's temporary tables. All data remains in the SIM temporary tables until
the import is deleted. You should delete your imports once you are satisfied that your data has been
accurately loaded to STORET.
d) Export records with errors after an Export Path and an Export File Name have been designated.
e) Reference and/or edit the Import Configuration that was used for this import.
f) Click [Migrate Records to STORET| and move the data you imported from the temporary SIM
tables to STORET's permanent tables.
hipDrtD | Import T>f» |
OaC- |
IrrpjrtCortijjnrton p»sr"C»^ * w Nt«&».« if*«y*:
Edl t*nl Lrt virtBn
_
Dote knpartid
hWrtboriErm
POTH Ftewi \ hi^wftrait **i Em: |
Rows MifiEiiOif
Inlt rrt-i \ I*»W B«fc*FkKKntaHtiEr>n |
H<^. rfe*
Summary
In Tutorial II. Using SIM to Migrate Data to STORET, you learned how to:
Import files to SIM using a pre-defined import configuration and text file.
Migrate data into STORET.
STORET Interface Module (SIM)
10
-------
SIM v2.0 User Guide
Build Number 9
Tutorial III. Advanced Functions
This tutorial illustrates the following:
Viewing the status of import files brought into SIM but not migrated or purged
Removing (undo) a migration of data from STORET
Generating an error report to print or save
Reordering field positions in an Import Configuration
Saving and loading Import Configurations
Viewing data that has been imported to SIM
1. View the status of an import that was brought into SIM but was not migrated or
purged
There may be cases where you have previously imported files to SIM, but did not migrate them to
STORET. This may occur because you had to stop your session, you wanted to review a file, or for another
reason. Other times, you may not recall whether you migrated a particular file to STORET, or purged it from
STORET. This tutorial helps you review your imports to determine their status.
From the SIM Welcome menu, click Existing Imports
M v2,0.0
ni, slum 1 v:n
Store! Inttrface Module
SIM v2
for use will
-i I Mm I
STORET Interface Module (SIM)
11
-------
SIM v2.0 User Guide
Build Number 9
There are four different categories of imports that you can access: Projects, Stations, Results, and
Biological. To review the status of the import that was performed in Tutorial II, click RESULTS.
Win
PROJECTS STA
Help 1
type of Existiii? Import do
you irish 10 view?
TONS 1 MSUITS
BIOLOOICAL
Close |
Click on the row that represents the relevant import and click [Status] at the end of the line. You will
return to the Import Status menu that you saw in Step 4 of Tutorial II.
-101*1
2. Remove or undo a migration of data from STORET
Select "Advanced" then "Migration Log" from the SIM windows menu.
STORET Interface Module (SIM)
12
-------
SIM v2.0 User Guide
Build Number 9
Highlight the migration that you would like to remove from STORET and click the appropriate
Clear Migration from STORET| button
5 ' C.-.A.irj ^,/-|W"J UllUU-,1 .,,|.,,y : =
.-v"., ...
1 . :i
\
J
^C^^^^H
---. :'
.. ^.., : :.
«Mb1(i1 Cb* UoiKr.bn OK
XWlfSl CMMQMtfcrn DM !
1
II
HI
HI
1
,1
II
II
|
IMp t^n.
Note that SIM cannot undo a migration once the import has been deleted from SIM. Additionally, you
cannot undo a migration once any changes or additions have been made to the migrated data through the
STORET interface.
3. Generate an error report file to print or save
Select "Advanced" then "Import Error Report" from the SIM windows menu.
Use the down-turned arrow to select the file that was imported. Next, click [Run Report
Import Status Report
The dropdown h:.t contains the names of imported files. Select
8 file, then click the 'Run Report' button to display import errots
*
: Suppress Warnings
Run Report Close
STORET Interface Module (SIM)
13
-------
SIM v2.0 User Guide
Build Number 9
A report of errors that occurred during import is displayed. From this screen, you can print the report or
save it to a file.
4. Reordering field positions in an Import Configuration
Field or column positions can be reordered from the Import Configuration menu. Suppose Start Date
needs to be in the second position instead of the third You can change the position number from 3 to a
number between 1 and 2 (such as 1.5) and click Save to reorder the columns.
STORET Interface Module (SIM)
14
-------
SIM v2.0 User Guide
Build Number 9
5. Saving and loading Import Configurations
From the Import Configuration menu: you can save import configurations to a external file and load
copied configurations using the |Copy ConfigurationsI and [Load Configurations] buttons.
6. Viewing Data that has been imported to SIM
View data that is in SIM using the View.. .List capability that can be found under the Projects, Stations,
or Results and Activities menus. Double-click an individual record to recall and view the data. Each
record will have a status of:
Approved for migration to STORET
Not approved for migration to STORET
Exported (migrated) from SIM to STORET
Uploaded if SIM copied data from STORET itself
SIM v2.0.0
for use \viih STORET \2.0
STORET Interface Module (SIM)
15
-------
SIM v2.0 User Guide
Build Number 9
System Configuration Definitions
Under the Advanced/System Config menu option in SIM v2.0, there are several user-defined settings used to
configure your system. The definitions for each of the configuration settings are listed below.
BUILD_NUMBER
The Build Number configuration item displays the four digit Gold Systems release number for this
installation for SIM. This number is displayed in the description column. The value column is not used.
DFLT ORG
The Default Organization configuration item allows the user to identify a STORET organization that
will default throughout the SIM application when the user is prompted to enter an organization. This
will not prohibit the user from selecting another valid organization if desired.
IMPORT PATH
The Import Path configuration item allows the user to set a path to a directory where text files are
located for import into SIM. When the user clicks the Browse button in the Import File form, the user
will automatically be directed to the directory named in the Import Path configuration item value. If the
ALLOW_LONG_LINES configuration item is set to "Yes", the import path must be entered from the
server's perspective and the browse button will be disabled.
DFLT_EXPORT_PATH
The Default Export Path configuration item allows the user to set a path to a directory where files will
be created if errors were found in the import. In the Import Status window, the user can view/edit the
export path and click the Export Records with Errors button to create the export file.
DFLT_EXPORT_FILE
The Default Export File configuration item allows the user to define the default name of a file, which
will be created if errors were found in the import. In the Import Status window, the user can view/edit
the export filename and click the Export Records with Errors button to create the export file.
HELP_PATH
The Help Path configuration item allows the user to point to a directory that contains the files needed to
access the general help window. The chosen directory path must contain the files sim2_gen.gid and
sim2_gen.hlp. In a standard SIM v2.0 installation, the files will be contained in the directory where the
software was installed.
SINGLE_USER_ENVIRONMENT
The Single User Environment configuration item allows the user to set a value for either a single or
multiple user environments. If only one user will be accessing the SIM and STORET databases at any
given time set this to "YES". If the value is set to "Yes", the speed of the migration will increase.
16
STORET Interface Module (SIM)
-------
SIM v2.0 User Guide
Build Number 9
COPY PATH
The Copy Path configuration item allows the user to set a default path to a directory where the copy/load
utility will read/write the import configuration files. In the Copy and Load Configuration forms, the
user can view/edit the default copy path and file name.
ALLOW_LONG_LINES
The Allow Long Lines configuration item allows the user to configure the system to read ASCII files
with very long lines. When the configuration value is set to "Yes", the user can import files with lines
longer than 1000 characters. When the system is configured to allow long lines, the import file is parsed
by the database rather than the client machine. As a result, the browse button is disabled and you must
enter the full path and file name as it could be found from the database server. DO NOT alter this value
without consulting USER MANUAL.
DIRLIST_PATH
The Directory Path configuration item allows the user to choose the FTP Directory Path. This
configuration item value is not used in the standard SIM v2.0 installation.
DIRLIST_NAME
The Directory List Name configuration item allows the user to choose the FTP Directory List Name.
This configuration item value is not used in the standard SIM v2.0 installation.
DO PRE CHECK
The Do Pre-Check configuration item allows the user to ascertain whether data files contain errors
before they are stored in the SIM database. This configuration item value is not used in the standard
SIM v2.0 installation.
17
STORET Interface Module (SIM)
-------
SIM v2.0 User Guide
Build Number 9
Appendix A.
Listing of Available STORET Data Elements
for Each File Type
18
STORET Interface Module (SIM)
-------
SIM v2.0 User Guide
Build Number 9
1. Project Descriptions
Data Element | Required Allowed Values
Project ID
Name
Start Date
Duration
Purpose
Contact
h'es |
Fes" !
Fes" I
Fes I
Fes !
2. Station Descriptions
Data Element
Required [Allowed Values
Station ID
Station Name
Primary Type
Secondary Type
Esta bl ish me nt Date
Point Name
Water Depth
Water Depth Units
P.e..?9.d p'.'9.n.
yes
Fes
""Fes'"
Fes
iConditional
jYes
Fes"
h'es
Latitude
Latitude Direction
Longitude
Longitude Direction
Lat/Long Mejiajje merit Date
Ge o posit io n j ng Dat u m
Ge oposit io n i ng Met ho d
Scale
State
County
ID
JYes i
|Defeultstp"N" Fes
'"Fes' 1
iDefauitsto'W'Fes
Yes
JYes
Fes"
iConditional
Fes
""Fes
Influence Area
T.51Y.?.! .9.!.[?9.l-!
Zi Relation
Yes
Native American Land State i
Elevation i
Elevation Units iConditional
iConditional
Elevation Dat urn iConditional
Elevation Measurement Date i
Ocean Name
Shore Relation
Additional Ocean Name \
Ocean Station Dist to Shore j
°..c.e.an. Sla.?i9n. P.M! t° Shore Units iConditional
Ocean Station Ref Point \
Ocean Station Bottom .l9P99r.aPhy i
iConditional
iConditional
h'es
Secondary Estuary
Estuary State
Other Estuary
Additional Estuary Name
Estuary Distance to Shore
Estuary Dist to Shore Units
Estuary Reference Point
iConditional h'es
STORET Interface Module (SIM)
19
-------
SIM v2.0 User Guide
Build Number 9
Data Element
Required [Allowed Values
Estuary State
Great Lake
Additional Great Lake Name
Great Lake Dist to Shore
Great Lakei Dist to'..Shore.Unjts....
Great Lake Reference Point
IConditional
Conditional Yes
STORET Interface Module (SIM)
20
-------
SIM v2.0 User Guide
Build Number 9
3. Additional Locations
Data Element [Required
Allowed Values
Yes
Yes
Station ID I
Point Type j
Point Name I
Sequence Number \ Yes
Latitude | Yes
Latitude Direction I Defaults to "N"
Longitude \ Yes
Longitude Direction \ Defaults to "W"
Lat/Long Measurement Date j
Geopositio n i n g Datu m
Ge oposit |p n i n g Method
Elevation
Elevation U nits
.Yatip.O. Method
Elevation Datum
Elevation Measurement Date
Scale
Yes
Conditional
Conditional
Conditional
Mu.st .?.*!.?! in STORE!
Yes
Yes
Yes
Yes
Yes
Yes
Conditional
4 Wells
Data Element
StatipnlD
Weil Number
Well Name
Weii Status
Wejiyse
Well Head Latitude
Well Head Latitude Direction
Well Head Longitude
Well Head Longitude Direction
Well Head Geopositioning Datum
Well Head Geopositioning Method
Weif Head Scale
Well Head Measurement Date
Well Head Elevation
Well Head Elevation Units
Well Head Elevation Method
Well Head Elevation Datum
Elevation Measurement Date
(Required
\ Yes
\ Yes
] Yes
1 Yes
] Yes
|
| Conditional.
1 Defaults to "N"
I Conditional.
i Defaults to "N"
1 Conditional
j Conditional
i Conditional
| Conditional
| Conditional
| Conditional
Allowed Values
Must Exist in STORET
Yes
IIIIIII^IIIIIII
Yes
Yes
Yes
IlZZI^ies^
Yes
Yes
Yes
5. Field Measurements and Non-biological Samples
Data Element
Required | Allowed Values
Multiple Allowed
Trip ID
Trip Start Date
Trip Stop Date
Trip Name
Station ID
Point Type
Sequence Number
Well or Pipe ID
Additional Location Information
Station Visit Number
ati°D YJ^it Arrival Date
Visit Comments
Project ID
Yes i Must Exist in STORE!
Yes
Yes
i Must Exist in STORET
xist in STORET
9.° !?.!!!!! 90?!
Conditional
Yes I Must Exist in STORE!
Yes. Separate with "\"
STORET Interface Module (SIM)
21
-------
SIM v2.0 User Guide
Build Number 9
Data Element Required Allowed Values
Activity ID | Yes
Medium | Yes | Yes
Activity Type | Yes | Yes
Activity Category ( Conditional j Yes
Trip QC Type j Conditional j Yes
QC Indicator \ \ Yes
Sample Matrix j | Yes
Chain of Custody i 6 j |
Replicate Number ! Conditional |
Activity Start Date j Yes |
Activity Start Time | |
Activity Start Time Zone | Conditional | Yes
Activity End Date | |
Activity End Time j j
Activity End Time Zone I Conditional | Yes
Total Sample Weight j j
Total Sample Weight Units j Conditional i Yes
Depth to Activity j |
Depth to Activity Units j Conditional | Yes
Relative Depth j | Yes
Depth Measured From i |
Lower Depth j j
Upper Depth i i
Upper/Lower Depth Units 1 Conditional | Yes
Depth Zone Type j j Yes
Thermocline I i Yes
Halocline I i Yes
Pycnocline | | Yes
Personnel | i Must Exist in STORET
Activity Comments \ \
Sample Collection Procedure ID j Conditional j Must Exist in STORET
Gear ID \ Conditional i Yes
Gear Configuration ID ! | Must Exist in STORET
Gear Deployment Comments j i
Sample Preservation, Transport & Storage ID j | Must Exist in STORET
Sample Transport and Storage Comments j |
Field Set Name (Conditional |
Field Set ID (Conditional i
Detection Condition | | Yes
Characteristic Group ID ponditional j Must Exist in STORET
Characteristic Row ID (Conditional | Must Exist in STORET
Characteristic Name (Conditional j Yes
Result Value (Conditional i Yes*
Result Value Units (Conditional | Yes
Result Status (Defaults to \ Yes
("F" j
Sample Fraction (Conditional | Yes
Statistic Type ! i Yes
Value Type (Defaults to i
("Actual" | Yes
Precision | |
Confidence Level j j Yes
Bias |
CL Corrected for Bias ( | Yes
Duration Basis ( i Yes
Temperature Basis ( | Yes
Weight basis ( | Yes
Result Comment ( (
Laboratory i'6 I Must Exist in 5j5R'£j
Multiple Allowed
Yes. Separate with "\"
STORET Interface Module (SIM)
22
-------
SIM v2.0 User Guide
Build Number 9
Data Element
Required
Allowed Values
Multiple Allowed
Field/Lab Procedure
Field/Lab Procedure Source
Laboratory Certified
Laboratory Batch ID
Analysis Date
Analysis Time
alysis I!m? .?P.ne
Lab Sample Prep Procedure
Lab Samp|e Prep Procedure source
Quantification Low
9.u?n?'J'.9.?l'o..n. H'sh
Detection Limit
Detection Limit Unit
Detection Limit Comment
[Conditional j Must Exist in STORET
Yes
Yes
iConditiona| | Yes
jIIIIIIIII]Eyi''I^ijK'
(Conditional I Yes
(Conditional
Yes
STORET Interface Module (SIM)
23
-------
SIM v2.0 User Guide
Build Number 9
6. Biological Samples
Data Element
Required | Allowed Values
Multiple Allowed
Trip ID I Yes
Trip Start Date !
Trip Stop Date I
Trip Name \
Station ID 1 Yes'"
Point Type \
Sequence Number j Conditional |
Well or Pipe ID [Conditional]
Additional Location Information j i
Station Visit Number j Yes |
Station Visit Arrival Date j j
Visit Comments I |
Project ID j Yes
Activity ID | Yes |
Medium | Yes I
Activity Type | Yes |
Activity Category j Yes \
QC Indicator j \
Sample Matrix j |
Chain of;Custody ID j j
Rep] [cat e Number ! Conditional |
Intent j Yes I
Parent Sample ID | Conditional I
Community j Conditional |
Bio Part j Conditional i
S u bject Taxo n j Co n d it i p n a 11
Subject Taxpn Species Number j I
Total Sample Weight | I
Total Sample Weight Units | Con d it ion a 11
Activity Start Date | Yes 1
Activity Start Time j |
Activity Start Time Zone I Conditional i
Activity End Date j j
Activity End Time I i
Activity End Time Zone j Conditional |
P!!ll 5.9. Activity i |
9.?.Plt!).!° Actiyjty Units ! Conditional |
Relative Depth \ \
Depth Measured From j |
Lower Depth \ i
Upper Depth I |
ypper/Lpwer Depth yn|ts ! Cond|t|pnal!
Depth Zone Type I i
Thermocline i I
Halocline \ \
Pycnocline I i
Personnel \
Activity Comments \ \
Sample Co I lection Procedure ID \ Conditional!
Gear ID !Cpnd|t|pnaM
Gear Configuration ID I |
Gear Deploy me nt Comments !
?amP!? Ere..s..e..!y.?!-!9.0' Ira.DsP9.d: * Storage ID |
Sam pi e Jra n spo rt a nd Sto rag e Comments j j
Field Set ID I Conditional i
Must Exist in STORET
Must Exist in STORET
Must Exist in SJORET
B |plogical
Yes
Yes
Yes
Yes
Yes i
Must Exist in STORET 1
or Current Data File |
Yes 1
Yes i
Yes 1
Yes j
Yes 1
Yes
Yes
Yes
"Yes""
Yes
Yes
Yes
Yes
Yes
Must Exist in STORET
Must Exist in STORET
................................... Yes ....................................
Must Exist in I'
Must Exist in
Yes. Separate with "\"
Yes. Separate with "\"
STORET Interface Module (SIM)
24
-------
SIM v2.0 User Guide
Build Number 9
Data Element Required
Field Set Name I Conditional
Distance Fished |
Distance Fished Units | Conditional
Fished Duration j
Fished Duration Units j Conditional
Trap or Net Sampling Duration j
Trap or Net Sampling Duration Units j Conditional
Relative Current Direction j
Relative Wind Direction j
Orientation to Current j
Trap or Net Comments |
Bio Results Group ID | Conditional
Bio Results Type | Conditional
Bio Results Group Description j
Bio Group Count Type I Conditional
Total Number in Group j Conditional
Frequency Analysis Type I Conditional
Primary Class Descriptor j Conditional
Secondary Class Descriptor j
Primary Class Value I Conditional
Secondary Class Value \
Common Class Descriptor j Conditional
Common Class Descriptor Units j Conditional
Sex ]
Life Stage !
Frequency Class Count I Conditional
Lower Class Bound I Conditional
Upper Class Bound | Conditional
Number of Individuals in Group | Conditional
Individual Number | Conditional
Detection Condition j
Characteristic Group ID j Conditional
Characteristic Row ID j Conditional
Characteristic Name j Conditional
Characteristic Species Number j
Result Value j Conditional
Result Value Units | Conditional
Result Status | Defaults to
| "F"
Sample Fraction j Conditional
Allowed Values Multiple Allowed
I
IIIIIIlYes^^
IIIIIIlYies^^^^^
IIIIIIZYies^^
Yes j
Yes 1
:::::::::::::::::i::::::::::::::::i
Yes |
Yes I
Yes
Yes
Yes
Yes
Yes
IIIIIIlYes^^
|
Yes
...^.^...^^..^...^^^^
...^.^...^^..^...^^^^
^
Yes*
Yes
Yes
Yes
Statistic Type ] Yes
Value Type j Defaults to
j "Actual"
Precision j
Confidence Level j
Bias j
CL Corrected for Bias j
Duration Basis I
Temperature Basis |
Weight basis |
Cell Form |
Cell Shape j
Habit ]
Voltinism !
Taxon Pollution Tolerance j
Trophic Level j
Result Comment j
Laboratory ID I
Field/Lab Procedure j Conditional
Yes
Ye^
Yes
Yes
Yes
Yes
Yes
Yes
Yes
IlllllZxiesZIIIIII
jyiust Exist in STORE?
Jvjust Exist in STORET
STORET Interface Module (SIM)
25
-------
SIM v2.0 User Guide
Build Number 9
Data Element Required
Field/Lab Procedure Source i
Laboratory Certified |
Laboratory Batch ID |
Analysis Date \
Analysis Time j
Lab Sample Prep Procedure j
Lab Sample Prep Procedure Source j
Quantification Low !
Detection Limit !
Detection Limit Unit i Conditional
Detection Limit Comment 1
Allowed Values
Yes
Yes
Yes
Must Exist in STORET
IIIIIII^IIIIIII
Yes
Multiple Allowed
*Result values can be numbers or, in some cases they are chosen from lists of allowable values.
STORET Interface Module (SIM)
26
------- |