THIS IS A READ_ME FILE FOR MODERN STORET V2.0.x FROM ftp://ftp.epa.gov/storet/modern/reference_tables/storet_v2.0.x/ TABLE NAME COLUMNS (TAB DELIMITED) APP_HELP APP_NAME APP_TITLE FORMS_HELP HELP_ID APP_NAME MODULE_NAME BLOCK_NAME ITEM_NAME HELP_TITLE HELP_TEXT FATHER_ID EXAMPLE_TEXT SORT_ID HELP_KEYWORDS HELP_ID APP_NAME KEY_ID KEY_NAME HELP_RELATED HELP_ID APP_NAME COUNTER HELP_ID_RELATED APP_NAME_RELATED TSMERMSG TSMERMSG_IS_NUMBER TSMERMSG_ORG_ID MESSAGE_ID MESSAGE_TEXT DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDATE_TS TSMESTRY TSMESTRY_IS_NUMBER TSMESTRY_ORG_ID NAME COUNTRY_CODE STATE_PROVINCE_NAME PRIMARY_INDICATOR D_USERID_CODE D_LAST_UPDT_TS TSMESTRY0ORG_ID TSMESTRY0IS_NUMBER TSMFHU TSMFHU_IS_NUMBER TSMFHU_ORG_ID HYDROLOGIC_UNIT_CD NAME STATES_NAME LAT_MAX_DEGREE LAT_MIN_DEGREE LONG_MAX_DEGREE LONG_MIN_DEGREE D_USERID_CODE D_LAST_UPDT_TS TYPE_CODE TSMGEOPA TSMGEOPA_IS_NUMBER TSMGEOPA_ORG_ID LAT_MIN_DEGREE LAT_MAX_DEGREE LONG_MIN_DEGREE LONG_MAX_DEGREE FIPS_COUNTY_CODE COUNTY_NAME STATE_FIPS_CODE STATE_NAME STATE_POSTAL_CODE COUNTRY_CODE COUNTRY_NAME COASTAL_IND_CD GREAT_LAKE_IND_CD D_USERID_CODE D_LAST_UPDT_TS TSMGEOUN TSMGEOUN_CD TSMGEOUN_ORG_ID TYPE_CODE STATE_CODE NAME D_USERID_CODE D_LAST_UPDT_TS TSMLTHUN TSMLTHUN_CD TSMLTHUN_ORG_ID NAME D_USERID_CODE D_LAST_UPDT_TS TSMMAD TSMMAD_IS_NUMBER TSMMAD_ORG_ID ID_CODE CATEGORY SUBCATEGORY DESCRIPTION D_USERID_CODE D_LAST_UPDATE_TS EDR_CODE TSMNAICS TSMNAICS_IS_NUMBER TSMNAICS_ORG_ID TSMNAICS_CODE TITLE EDR_SERIAL_NUMBER D_USERID_CODE D_LAST_UPDT_TS TSMNAL TSMNAL_CD TSMNAL_STATE TSMNAL_ORG_ID NAME D_USERID_CODE D_LAST_UPDT_TS TSMPRMVL TSMPRMVL_IS_NUMBER TSMPRMVL_ORG_ID TABLE_NAME FIELD_NAME SEQUENCE_NUMBER FIELD_VALUE FIELD_DESC D_USERID_CODE D_LAST_UPDATE_TS TSMPROLE TSMPROLE_IS_NUMBER TSMPROLE_ORG_ID TITLE TYPE_CODE D_USERID_CODE D_LAST_UPDATE_TS TSMPSR TSMPSR_IS_NUMBER TSMPSR_ORG_ID TYPE_NAME D_USERID_CODE D_LAST_UPDATE_TS TSMRRR TSMRRR_IS_NUMBER TSMRRR_ORG_ID HYDROLOGIC_UNIT_CD SEGMENT_CODE NAME TYPE_CODE LEVEL_CODE MILE_LENGTH LAT_MAX_DEGREE LAT_MIN_DEGREE LONG_MAX_DEGREE LONG_MIN_DEGREE D_USERID_CODE D_LAST_UPDT_TS TSMSIC TSMSIC_CODE TSMSIC_ORG_ID NAME D_USERID_CODE D_LAST_UPDT_TS TSMVSTC TSMVSTC_IS_NUMBER TSMVSTC_ORG_ID PRIMARY_TYPE_CD SECONDARY_TYPE_CD NATURAL_IND_CD D_USERID_CODE D_LAST_UPDT_TS TSRANLEQ TSRANLEQ_IS_NUMBER TSRANLEQ_ORG_ID TYPE_NAME NAME D_USERID_CODE D_LAST_UPDATE_TS TSRBIOPT TSRBIOPT_IS_NUMBER TSRBIOPT_ORG_ID NAME D_USERID_CODE D_LAST_UPDT_TS TSRCALT TSRCALT_IS_NUMBER TSRCALT_ORG_ID TYPE_NAME TYPE_CATEGORY D_USERID_CODE D_LAST_UPDATE_TS TSRCHALS TSRCHAR_IS_NUMBER TSRCHAR_ORG_ID TSRCHALS_IS_NUMBER TYPE_NAME NAME D_USERID_CODE D_LAST_UPDATE_TS TSRCALT_IS_NUMBER TSRCALT_ORG_ID SEARCH_NAME TSRCHAR TSRCHAR_IS_NUMBER TSRCHAR_ORG_ID EXTRNL_SERIAL_NUM UOM_TYPE SEARCH_NAME DISPLAY_NAME D_SCR_TYPE_CD PROC_REQ_IND_CD VALID_FOR_QC_IND SAMP_FRAC_REQ_CD CHAR_TYPE_CODE TAXON_RANK_CODE D_USERID_CODE D_LAST_UPDATE_TS TRUE_NAME_TSN PARENT_TSN TAXON_SORT_CODE AUTHOR_DATE STATUS TAXON_RANK_NAME TSRCHTYP TSRCHTYP_CATEGORY TSRCHTYP_SUBCATGRY TSRCHTYP_ORG_ID D_USERID_CODE D_LAST_UPDATE_TS TSRCPV TSRCPV_IS_NUMBER TSRCPV_ORG_ID SHORT_NAME DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDATE_TS TSRCHAR_IS_NUMBER TSRCHAR_ORG_ID TSRCTCA TSRCHAR_IS_NUMBER TSRCHAR_ORG_ID TSRCHTYP_CATEGORY TSRCHTYP_SUBCATGRY TSRCHTYP_ORG_ID D_USERID_CODE D_LAST_UPDATE_TS TSRFLDGR TSRFLDGR_IS_NUMBER TSRFLDGR_ORG_ID ID_CODE TYPE_NAME NAME DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDATE_TS TSRLBRMK TSRLBRMK_IS_NUMBER TSRLBRMK_ORG_ID SHORT_NAME DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDATE_TS TSRMATRX TSRMATRX_IS_NUMBER TSRMATRX_ORG_ID CODE NAME DESCRIPTION D_USERID_CODE D_LAST_UPDATE_TS TSRPROJSQ DESCRIPTION_NAME SQ DESCRIPTION TSRRLIST DISP_SEQ RPT_ID PT LVE TITLE FNAME TSRRPARM RPT_ID PARAM_NAME TSRUOM TSRUOM_IS_NUMBER TSRUOM_ORG_ID UOM_TYPE SHORT_FORM_NAME DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDATE_TS TARGET_UNIT CONVERSION_FACTOR ADJUSTMENT_FACTOR FILE/TABLE_NAME CONTENTS COPY OF LINE FROM FILE TSMERMSG PROCEDURES 149 ZZZZZZZZ B00237 Parent referenced more than once for this Field Activity. The Parent Field Activity appears in the input file more than once for a given child Field Activity creation. USERV20 01-DEC-03 TSMESTRY RIVER NAMES 1736 ZZZZZZZZ Quantico Creek US Virginia N USERV20 01-JAN-03 ZZZZZZZZ 1733 TSMFHU LOCATION DATA 1681 ZZZZZZZZ 15080102 Rio Sonoyta. AZ 32.1103 31.7969 -112.4567 -113.3925 USERV20 01-JAN-03 CATUNIT TSMGEOPA LOCATION DATA 1487 ZZZZZZZZ 34.6872 35.0314 -90.3819 -89.6889 033 DE SOTO 28 MISSISSIPPI MS US UNITED STATES N N USERV20 01-JAN-03 TSMGEOU SOIL/ROCK TYPE AK:000SELS ZZZZZZZZ G AK St Elias Schist USERV20 01-JAN-03 TSMLTHUN ROCK TYPE ALVM ZZZZZZZZ Alluvium USERV20 01-JAN-03 TSMMAD GPS MAP METHODS 1 ZZZZZZZZ 014 VERTICAL METHOD Topographic Map Interpolation USERV20 01-DEC-03 014 TSMNAICS FARMING 1 ZZZZZZZZ 11 Agriculture, Forestry, Fishing and Hunting 1 USERV20 01-JAN-03 TSMNAL TRIBES 3130 NV ZZZZZZZZ Reno-Sparks USERV20 01-JAN-03 TSMPRMVL SAMPLE CONTAINERS 1 ZZZZZZZZ TSRFQS CONTAINER_COLOR 1 Amber Amber (yellowish brown) USERV20 01-DEC-03 TSMPROLE PERSON ROLES 1 ZZZZZZZZ STORET Primary Contact ORG USERV20 01-DEC-03 TSMPSR PROJECT ROLES 1 ZZZZZZZZ Water Quality Monitoring USERV20 01-DEC-03 TSMRRR RF1 1 ZZZZZZZZ 01010001 001 ST JOHN R T 3 9.7 47.1424 47.0556 -67.7901 -67.9259 USERV20 01-JAN-03 TSMSIC INDUSTRY OR USE 0219 ZZZZZZZZ GENERAL LIVESTOCK, NEC USERV20 01-JAN-03 TSMVSTC WATER TYPES 1 ZZZZZZZZ River/Stream None Y USERV20 01-JAN-03 TSRANLEQ ANALYTICAL INSTRUMENTS 28 ZZZZZZZZ Acoustic Velocity Acoustic Flow Measuring System USERV20 01-DEC-03 TSRANLPR ANALYTICAL PROCEDURES 2922 ZZZZZZZZ NAT 1106.1 Enterococci in Water by Membrane Filtration Using membrane-Enterococcus-Esculin Iron Agar (mE-EIA) U.S. Environmental Protection Agency USEPA USERV202 30-MAR-04 382 ZZZZZZZZ TSRBIOPT ORGANISM DESCRIPTIONS 1 ZZZZZZZZ Whole organism USERV20 01-JAN-03 TSRCALT CODES 1 ZZZZZZZZ CAS NUMBER NT USERV20 01-DEC-03 TSRCHTYP CODES BIOLOGICAL PHYSICAL MEASUREMENTS ZZZZZZZZ USERV20 01-DEC-03 TSRCITN ANALYTICAL METHODS 291 ZZZZZZZZ NAT EPA 821/R-99-001 USEPA 1999 Method 1622: Crytosporidium in Water by Filtration/IMS/FA. USEPA EPA 821/R-99-001 18-JAN-01 2 TSRCPV WEATHER CODES 159 ZZZZZZZZ 15 Precipitation in sight, reaching the ground, g.t. 5km away. USERV20 01-DEC-03 534 ZZZZZZZZ TSRCTCA BIOLOGICAL TAXON 6675 ZZZZZZZZ BIOLOGICAL TAXON ZZZZZZZZ USERV20 01-DEC-03 TSRFLDGR SAMPLE PROCEDURES 1 ZZZZZZZZ BCBM Benthic Corer Boomerang corer USERV20 01-DEC-03 TSRLBRMK SAMPLE ERROR 1 ZZZZZZZZ AL Aldol condensation present. Analyte may not be present. USERV20 01-DEC-03 TSRLSPP SAMPLE PREPARATION 35 ZZZZZZZZ NAT OC010R Preparation of VOC Samples Containing Hydrocarbons US Department of Energy, Analytical Services Div. USDOE/ASD LJM 01-DEC-03 62 ZZZZZZZZ TSRMATRX SAMPLE MEDIA 1 ZZZZZZZZ AA Ambient Air Ambient Air USERV20 01-DEC-03 TSRUOM SAMPLE UNITS 2 ZZZZZZZZ SUBST pg picograms USERV20 01-DEC-03 TSMEISN TSMEISN_NAME TSMEISN_ORG_ID IS_NUMBER TABLE_VERSION V_USERID_CODE V_LAST_UPDATE_TS D_USERID_CODE D_LAST_UPDT_TS TSMGNTXT TSMGNTXT_IS_NUMBER TSMGNTXT_ORG_ID TABLE_NAME DESCRIPTION_NAME DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDATE_TS TSRRSULT_IS_NUMBER TSRRSULT_ORG_ID TSMPROJ_IS_NUMBER TSMPROJ_ORG_ID TSMPROGM_IS_NUMBER TSMPROGM_ORG_ID TSRGRCFG_IS_NUMBER TSRGRCFG_ORG_ID TSMORGAN TSMORGAN_IS_NUMBER TYPE_CODE ORG_ID NAME UNLOCK_KEY SHORT_NAME PARENT_ORG DESCRIPTION_TEXT D_USERID_CODE D_LAST_UPDT_TS SUPERFUND_SITE_ID TSMPROGM TSMPROGM_IS_NUMBER TSMPROGM_ORG_ID TYPE_CODE NAME D_USERID_CODE D_LAST_UPDATE_TS TSMORGAN_IS_NUMBER TSRANLPR TSRANLPR_IS_NUMBER TSRANLPR_ORG_ID OWNER_TYPE_CODE PROCEDURE_ID NAME SOURCE_NAME SOURCE_ACR D_USERID_CODE D_LAST_UPDATE_TS TSRCITN_IS_NUMBER TSRCITN_ORG_ID TSRANLPR0IS_NUMBER TSRANLPR0ORG_ID TSRANLEQ_IS_NUMBER TSRANLEQ_ORG_ID DESCRIPTION_TEXT TSRCITN TSRCITN_IS_NUMBER TSRCITN_ORG_ID ORG_TYPE_CODE ORG_REF_ID_NUM AUTHOR_NAME PUBLICATION_YEAR TITLE_NAME JRNL_OR_PBLSHR_NM VOL_AND_PG_NUM COMMENT_TEXT D_USERID_CODE D_LAST_UPDATE_TS TSMORGAN_IS_NUMBER BLOB_TYPE BLOB_TITLE IDENTIFICATION_CD TSRLSPP TSRLSPP_IS_NUMBER TSRLSPP_ORG_ID OWNER_TYPE_CODE PREPARATION_ID NAME SOURCE_NAME SOURCE_ACR D_USERID_CODE D_LAST_UPDATE_TS TSRCITN_IS_NUMBER TSRCITN_ORG_ID