Enter value for table_name: % 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW ACTIVITY_GROUP_DETAIL FK_ACTIVITY ACTIVITY_GROUP internal serial number. FK_ACTIVITY_GROUP Foreign Key referencing FA_ACTIVITY_GROUP. FK_ORG Foreign Key referencing DI_ORG. SOURCE_ACTGRP_UID ACTIVITY_GROUP_DETAIL internal serial number. ACTIVITY_METRIC_INDEX Table Comment Fa_activity_metric and Fa_bio_habitat_index association table FK_ACTIVITYMETRIC Foreign Key referencing FA_ACTIVITY_METRIC. FK_BIO_HABITAT_INDEX Foreign Key referencing FA_BIO_HABITAT_INDEX. APP_COLUMN_NAME Table Comment Warehouse Application column/Attribute Names ALL_COL_ORDER All results report element order number with in a group . ALL_ELEMENT_DEFAULT All results report element default status. ALL_REPORT_NUMBER All results report element order number. BIO_COL_ORDER Attribute order within a group reporting element for Bi ological Results BIO_ELEMENT_DEFAULT Default element selection flag for Biological Result re port customization. BIO_REPORT_NUMBER A number representing element display order for Biologi cal Result report customization. COL_NAME Name of the reporting element as in physical table stru cture. ELEMENT_NAME Name of element (individual or group) to be used in rep ort customization page. HAB_COL_ORDER Attribute order within a group reporting element for Ha bitat Results HAB_ELEMENT_DEFAULT Default element selection flag for Habitat Result repor t customization. HAB_REPORT_NUMBER A number representing element display order for Habitat Result report customization. HELP_LINK STORET help page internal anchor name. This will help point to specific location in the help document. IND_COL_ORDER Index results report element order number with in a gro up. IND_ELEMENT_DEFAULT Index results report element default status. IND_REPORT_NUMBER Index results report element order number. PRINT_NAME Name of the element to be used for reporting (download file). REG_COL_ORDER Attribute order within a group reporting element for Re gular Results 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW APP_COLUMN_NAME REG_ELEMENT_DEFAULT Default element selection flag for Regular Result repor t customization. REG_REPORT_NUMBER A number representing element display order for Regular Result report customization. STN_COL_ORDER Attribute order within a group reporting element for St ation reporting. STN_ELEMENT_DEFAULT Default element selection flag for Station report custo mization. STN_REPORT_NUMBER A number representing element display order for Station report customization. BIOLOGICAL_RESULT_PROJECT Table Comment Biological Result and Project association table FK_PROJECT Foreign Key referencing DI_PROJECT. FK_RESULT Foreign Key referencing DI_RESULT. CHARACTERISTIC_CHARTYPE Table Comment Characteristic CharType association table. FK_CHARACTERISTIC Foreign key referencing Characteristic. FK_CHARTYPE Foreign key referencing Chartype. DI_ACTIVITY_INTENT Table Comment Activity Intent Dimension table ACTIVITY_INTENT The primary reason the Field Activity occurred. Note: This is mandatory for Biological Medium, and not avail able for other media. PK_ISN Primary Key. Generated using sequence object SEQ_ACTIVI TY_INTENT. DI_ACTIVITY_MATRIX Table Comment Activity matrix dimension table MATRIX_CODE A cryptic code which represents the sampled matrix. Us ed as a shorthand or abbreviation to represent the Samp led Matrix in batch data update runs. MATRIX_DESCRIPTION Full description or definition of the sampled matrix. MATRIX_NAME The short name of the Sample Matrix. Used in populating the drop down list on data entry windows. PK_ISN Primary Key. Generated using sequence object SEQ_ACTIVI TY_MATRIX. DI_ACTIVITY_MEDIUM Table Comment Activity medium dimension table ACTIVITY_MEDIUM The name of the medium or matrix where the Field Activi ty occurred. PK_ISN Primary Key. Generated using sequence object SEQ_ACTIVI TY_MEDIUM. DI_BIOPART Table Comment Biopart dimension table BIOPART_NAME The foreign key to TSRBIOPT inplements "One Biopart (ti ssue, organ) may be the subject tissue for many Field A ctivities/Samples whose medium is biological and whose intent is Tissue. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW DI_BIOPART PK_ISN Primary Key. Generated using sequence object SEQ_BIOPAR T. DI_CHARACTERISTIC Table Comment Characteristic dimension table CAS_NUMBER Registered Characteristic Name CHARACTERISTIC_GROUP_TYPE Type of the Characteristic Group CHARTYPE Characteristic Type DESCRIPTION Characteristic Description DISPLAY_NAME The name of the environmental characteristic as it is t o be displayed on windows and reports. FK_CHARGRPTYPE Foreign Key referencing Lookup Table Chargrptype. FK_CHARTYPE Foreign key referencing Lookup Table Chartype. ITIS_NUMBER Registered ITIS Taxanomic Serial Number (TSN) ITIS_PARENT Registered ITIS Parent Taxanomic Serial Number (PARENT_ TSN) KINGDOM_NAME A relative root position beginning the taxonomic hierar chy LAST_CHANGE_DATE Last Change Date of a Characteristc PK_ISN Primary Key. Generated using sequence object SEQ_CHARAC TERISTIC. RANK_NAME A relative position within the taxonomic hierarchy REGISTRY_NAME Registered Characteristic Name SEARCH_NAME The standardized form of the name as determined by EPA for use in searching the list of environmental characte ristics. All caps for consistent search results. SRS_ID Characteristic Register ID TYPE_CODE A code indicating type of characteristic. DI_COMMUNITY_SAMPLED Table Comment Community Sampled dimension table ACTIVITY_COMMUNITY The name of the Biological Community from which the Sam ple was taken. Note: This is only valid when MEDIUM_T YPE_NAME is BIOLOGICAL and INTENT_TYPE_NAME is TAXON AB UNDANCE. ACTIVITY_COMMUNITY_DESC Activity Community Description PK_ISN Primary Key. Generated using sequence object SEQ_COMMUN ITY_SAMPLED. DI_DATE Table Comment Date dimension table DAY_NUMBER_IN_MONTH Day number in the month DAY_NUMBER_OVERALL Cumulative Day number with reference to 01/01/1900. DAY_OF_WEEK Day of the Week FISCAL_PERIOD Calender fiscal year starts on January 1st and ends on December 31st. FULL_DATE Day, month and year of the date. LAST_DAY_IN_MONTH_FLAG Flag indicating last day of the month. MONTH Month of the year 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW DI_DATE MONTH_NUMBER_OVERALL Cumulative number of the month with reference to 01/01/ 1900. PK_ISN Primary Key. Generated using sequence object SEQ_DATE. QUARTER Quarter of the year. WEEKDAY_FLAG Weekday flag. Monday through Friday are weekdays. WEEK_NUMBER_IN_YEAR Number of the week in the year. WEEK_NUMBER_OVERALL Cumulative number of the week with reference to 01/01/1 900. DI_DB_CAT Table Comment Drainage Basin Cataloging unit dimension table GEOM The Oracle Spatial geometry for the Hydrologic Units, s tored in WGS84. HYDROLOGIC_UNIT_CODE The Federal Information Processing Standard (FIPS) code for Hydrologic Units, as defined in FIPS Publication 1 03. HYDROLOGIC_UNIT_NAME The Federal Information Processing Standard (FIPS) name associated with code established for Hydrologic Units, as defined in FIPS Publication 103. PK_ISN Primary Key. Generated using sequence object SEQ_COMMUN ITY_SAMPLED. DI_EPA_REGION Table Comment EPA Region dimension table EPA_REGION_CODE The code of the EPA region. EPA_REGION_NAME The name of the EPA region. PK_ISN Primary Key. Generated using sequence object SEQ_EPA_RE GION. DI_GEO_COUNTY Table Comment Geological county dimension table COUNTY_NAME The name of the county or county equivalent (when appli cable). FIPS_COUNTY_CODE The 3-character Federal Information Processing Standard (FIPS) code representing the county or county equivale nt (when applicable). FK_GEO_STATE Foreign Key referencing DI_GEO_STATE. GEOM The Oracle Spatial geometry for the Counties, stored in WGS84. PK_ISN Primary Key. Generated using sequence object SEQ_COMMUN ITY_SAMPLED. DI_GEO_STATE Table Comment Geological State dimension table COUNTRY_CODE The 2-character Federal Information Processing Standard (FIPS) code (ref FIPS Pub 10-3) representing the Count ry. COUNTRY_NAME The name of the Country. EPA_REGION_CODE The code of the EPA region. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW DI_GEO_STATE EPA_REGION_NAME The name of the EPA region. FIPS_STATE_CODE The 2-character Federal Information Processing Standard (FIPS) code representing the State, Province, or equiv alent. GEOM The Oracle Spatial geometry for the States, stored in W GS84. PK_ISN Primary Key. Generated using sequence object SEQ_COMMUN ITY_SAMPLED. STATE_NAME The name of the State, Province, or equivalent. STATE_POSTAL_CODE The official USPS 2-character postal abbreviation for t he State, Province, or equivalent. DI_GROUP_TYPE Table Comment Group type dimension table BIO_GROUP_TYPE The name of the kind of group. Examples include: 1. p opulation census by taxon (non- duplicative species cou nt) 2. Coliform bacteria census by taxon 3. Singl e taxon frequency class 4. Single taxon group summar y 5. Single taxon individual PK_ISN Primary Key. Generated using sequence object SEQ_GROUP_ TYPE. DI_METHOD Table Comment National Environmental Method dimension table AMCTX_UID WQX Analytical Method Context Foreign Key. LAST_CHANGE_DATE The date of the last change to data in this row. METHOD_DESC The formal full description of Information that further describes an Analytical Procedure. METHOD_ID The abbreviated name or identifying code of the analyti cal procedure/method assigned by the method publisher. METHOD_NAME The formal full name or title of the Analytical Procedu re given by the organization or author that published o r provides it. METHOD_QUAL_TYPE Identifier of type of method that identifies it as refe rence, equivalent, or other. METHOD_SOURCE The name of the Analytical Procedure Owner (method publ isher). Examples include the American Society for Test ing Materials, the United States Geological Survey, and the Environmental Protection Agency. METHOD_TYPE This field of information is designed to convey the app lication of the procedure/method. The following options are available: Sample analysis,Sample collection,Stati stical technique,Sample processing/preparation,Toxicity test procedure. METHOD_URL The description or reference for the literary citation 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- which details the full method documentation. STORETW DI_METHOD NEMI_ID The identification identification number or code assign ed by the method publisher. NEMI_SOURCE The name, address, and Internet web site of the organiz ation that published the method: (method publisher). PK_ISN Primary Key. Generated using sequence object SEQ_OGR. SOURCE_UID A system-generated value used to uniquely identify an o ccurrence of this table. DI_ORG Table Comment Organization dimension table ORGANIZATION_DESCRIPTION The text describing details of the Organization that us ers may wish to provide. For example, this text may be used to describe the purpose, mission, or goals of the Organization. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. ORGANIZATION_NAME The formal full-length name of the Organization. ORGANIZATION_TYPE The code that describes the type of Organization. PARENT_ORG The formal full name of a higher level organization whi ch directs, is responsible for, or has authority over t he activities and operations of the data-owning organiz ation. PK_ISN Primary Key. Generated using sequence object SEQ_OGR. DI_ORG_TYPES Table Comment Organization types dimension table ORGANIZATION_TYPE The code that represents the primary type designation o f a Organization. PK_ISN Primary Key. Generated using sequence object SEQ_ORG_TY PES. SORT_ORDER Sort order for station type selection box on web pages DI_PROJECT Table Comment Project dimension table BLOB_ID Project binary large object unique identifier BLOB_TITLE Project binary large object title FK_ORG Foreign Key referencing DI_ORG. FK_QA_AGENCY Registered Characteristic Name LAST_TRANSACTION_ID Charactristic Description OBTAIN_PLAN Project Obtain Plan PK_ISN Primary Key. Generated using sequence object SEQ_PROJEC T. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW DI_PROJECT PLANNED_DURATION The expected elapsed time of the project. Examples: 2 Year, Historical, Ongoing PROJECT_CD The code (combination of text or numbers) used by the o wning Organization to uniquely identify the Project or Survey. PROJECT_DESCRIPTION Project Description PROJECT_DESIGN The design assigned by the owning Organization to the P roject or Survey. PROJECT_NAME The name assigned by the owning Organization to the Pro ject or Survey. PROJECT_POR_END Charactristic Description PROJECT_POR_START Charactristic Description PURPOSE The purpose assigned by the owning Organization to the Project or Survey. QA_APPROVAL_AGENCY Registered Characteristic Name QA_APPROVED Characteristic Type QUALITY_ASSURANCE Project Quality Assurance information. QUALITY_OBJECTIVES The quality objectives assigned by the owning Organizat ion to the Project or Survey. SAMPLING_DESIGN_TYPE_CD Last Change Date of a Characteristc SOURCE_SYSTEM Registered Characteristic Name SOURCE_UID Characteristic Register ID START_DATE The date (in format MM-DD-YYYY) on which a Project or S urvey is scheduled to begin. STUDY_AREA The study area assigned by the owning Organization to t he Project or Survey. TSMPROJ_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. TSMPROJ_ORG_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). DI_STATN_TYPES Table Comment Station types dimension table PK_ISN Primary Key. Generated using sequence object SEQ_STATN_ TYPES. PRIMARY_TYPE The code that represents the primary type designation o f a Station. SECONDARY_TYPE The code that represents the secondary type designation of a Station. Not every combination requires a Second 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- ary Type. STORETW DI_STATN_TYPES SGO_INDICATOR Surface, Ground, Other indicator. Each of the primary s tation types were mapped to one of these three values. SORT_ORDER Sort order for station type selection box on web pages STATION_GROUP_TYPE Station Group Type DI_SUBJECT_TAXON Table Comment Subject Taxon dimension table ACTIVITY_SUBJECT_TAXON Subject Taxon identifies the organism that composes the sample when the activity intent is Tissue or Individua l. PK_ISN Primary Key. Generated using sequence object SEQ_SUBJEC T_TAXON. DW_DATA_REQUESTS ACTGRP_DATA_FLAG Activity Group data request flag BIO_DATA_FLAG Biological Result data request flag BQUERY_TEXT Biological Result query test. BQUERY_TEXT2 Biological Result query test2. B_RECORD_TITLE Biological Result record title. DATA_BY_ORG_ID List of delimited organization_ids DATETIME Timestamp when the request from warehouse was performed . DELIMITER File designated delimiter EMAIL_ADDRESS Text or codes which are used to specify an Electronic A ddress for an Organization or an individual. FILENAME Name of report file. FILESIZE_KB File size in Kilobytes. FORMAT_TYPE File format type F_ACT_INTENT Flag to indicate if Activity Intent was used in the que ry filters. F_ACT_MEDIUM Flag to indicate if Activity Medium was used in the que ry filters. F_ACT_STARTDATE Flag to indicate if Activity Start Date was used in the query filters. F_CHARACTERISTIC Flag to indicate if Characteristics was used in the que ry filters. F_CHARTYPE Chartype flag F_COMMUNITY_SAMPLED Flag to indicate if community sampled was used in the q uery filters. F_COUNTY Flag to indicate if County was used in the query filter s. F_HUC Flag to indicate if Hydrologic Unit Code was used in t he query filters. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW DW_DATA_REQUESTS F_LATLONG Flag to indicate if Latitude and Longitude were used in the query filters. F_ORGANIZATION Flag to indicate if Organization was used in the query filters. F_PROJECT Flag to indicate if Project was used in the query filte rs. F_STATE Flag to indicate if State was used in the query filters . F_STATION Flag to indicate if Stations were used in the query fil ters. F_STATIONTYPE Flag to indicate if Station Types were used in the quer y filters. HAB_DATA_FLAG Habitat Result data request flag HQUERY_TEXT Habitat query text HQUERY_TEXT2 Habitat query text2 H_RECORD_TITLE Habitat result record title IQUERY_TEXT Index Result query text. IQUERY_TEXT2 Index Result query text2. I_RECORD_TITLE Index Result record title. JOB_QUEUE_ID Batch Job queue ID. Issued by Oracle system when a job is schedule to run. MET_DATA_FLAG Metric Result data request flag MQUERY_TEXT Metric Result query text. MQUERY_TEXT2 Metric Result query text2. M_RECORD_TITLE Metric Result record title. NOTIFIED Flag to indicate if application user is notified of the batch job. PRJSTNWT_DATA_FLAG Project Station Weights data request flag PROCESSED_DATE Batch Job processed date. QUERY_REPORT Report of the user query QUERY_TEXT The 4000 characters of the query generated based on app lication users request. QUERY_TEXT2 The next 4000 characters of the query generated based o n application users request. RECORD_COUNT Report Record count of the user query. RECORD_TITLE Record Title for the creating the Report download file. This is generated based on the user selections in repo rt customization on Summary page. REG_DATA_FLAG Regular Result data request flag REQUEST_ID User report request ID. Generated by the application us ing a sequence number. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW DW_DATA_REQUESTS REQUEST_MODE Report request mode. Immediate and Overnight are valid Batch request options. Online is used for interactive data request. REQUEST_STATUS Status of the Batch request. REQUEST_TYPE Report request type representing the available report t ypes for data download. (Example: Biological, Regular, Habitat, station, etc.) RQUERY_TEXT Regular Result query test. RQUERY_TEXT2 Regular Result query test2. R_RECORD_TITLE Regular Result record title. STNSYN_DATA_FLAG Station Alias data request flag FA_ACTIVITY_GROUP Table Comment Activity Group fact table ACTIVITYGROUP_ID Activity Group identifier. ACTIVITYGROUP_NAME Activity Group name. ACTIVITYGROUP_TYPE_ID Activity Group Type identifier. FK_DATE_ACTGROUP_END Foreign Key to Date for Activity Group End Date FK_DATE_ACTGROUP_START Foreign Key to Date for Activity Group Start Date FK_DATE_LC Foreign Key to Date Last Change LAST_CHANGE_DATE Activity Group Last Change date LAST_TRANSACTION_ID Activity Group Last Transaction Identifier LAST_USERID Activity Group Last User Identifier ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. PK_ISN Primary Key. Generated using sequence object SEQ_FA_ACT IVITYGROUP. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier FA_ACTIVITY_METRIC Table Comment Activity Metric Result fact table ACTIVITY_CATEGORY A descriptor used to distinguish different kinds of sam ples and different kinds of Measurements and Observatio ns. The permitted value list is controlled by the choi ce of TYPE_NAME (above), with the entries in TSMPRMVL f or CATEGORY_TYPE_NAME_M used for activities of type Msr /Obs, while CATEGORY_TYPE_NAME_S is used for activities of type Sample. ACTIVITY_COMMENT Activity comment ACTIVITY_COMMUNITY The name of the Biological Community from which the Sam ple was taken. Note: This is only valid when MEDIUM_T YPE_NAME is BIOLOGICAL and INTENT_TYPE_NAME is TAXON AB UNDANCE. ACTIVITY_DEPTH Distance from the surface to the point in the water col umn at which the activity is conducted. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_ACTIVITY_METRIC ACTIVITY_DEPTH_REF_POINT The text that describes the reference point from which the depth is measured, typically "Surface". ACTIVITY_DEPTH_UNIT Activity Depth Unit ACTIVITY_ID User provided string that identifies the activity with in his/her organization. ACTIVITY_INTENT The primary reason the Field Activity occurred. Note: This is mandatory for Biological Medium, and not avail able for other media.. ACTIVITY_ISN STORET Activitys internal serial number. ACTIVITY_IS_NUMBER STORET Activitys internal serial number. ACTIVITY_LATITUDE Latitue at which activity occurred. ACTIVITY_LONGITUDE Longitude at which activity occurred. ACTIVITY_LOWER_DEPTH This measure is associated with an activity that is nor mally conducted over or within a vertical depth range w ithin the water column. This attribute is a measure of the distance from the surface to the lower boundary of the zone within which the activity is conducted or over which the activity is integrated. ACTIVITY_MEDIUM The name of the medium or matrix where the Field Activi ty occurred. ACTIVITY_REL_DEPTH Activity relative depth from the reference point ACTIVITY_START_DATE_TIME For Samples Collected or for Measurements/Observations made - the date that the Field Activity began. For Sam ples Created from other samples - the date on which a s ample is created by compositing, splitting, or subsampl ing from a parent sample. ACTIVITY_STOP_DATE_TIME Date and time at which the Activity was stopped. ACTIVITY_SUBJECT_TAXON Subject Taxon identifies the organism that composes the sample when the activity intent is Tissue or Individua l. ACTIVITY_TYPE Type of Activity. Example: Sample or Measurement/Obser vation. ACTIVITY_UPPER_DEPTH This measure is associated with an activity that is nor mally conducted over or within a vertical depth range w ithin the water column. This attribute is a measure of the distance from the surface to the upper boundary of the zone within which the activity is conducted or over which the activity is integrated. ACT_BLOB_ID Activity Binary Large Object identifier. ACT_BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. ACT_METRIC_COMMENT Activity metric comment. ACT_METRIC_SCORE Activity metric score. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_ACTIVITY_METRIC ACT_METRIC_UNIT Activity metric unit. ACT_METRIC_VALUE Activity metric value. ACT_START_TIME_ZONE Activity Start Time Zone ACT_STD_HDATUM Activity Standard Horizontal Datum. The user provided data is converted to this standard datum during the ETL . ACT_STD_LATITUDE Activity Latitude measure in Activity Standard Horizont al Datum. ACT_STD_LONGITUDE Activity Longitude measure in Activity Standard Horizon tal Datum. ACT_STOP_TIME_ZONE Activity Stop Time Zone. BLOB_ID Blob ID. Id used to fetch Document Graphic. BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. BOAT_SPEED The relative speed, through the water, of the boat duri ng Sample collection. CONTAINER_DESC Description of the Sample collection Container. FIELD_GEAR_ID Field Gear ID FIELD_PREP_PROCEDURE_ID The abbreviated name or identifying code of the prepara tion analytical procedure. FIELD_PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. FISHED_DURATION Fished duration. FK_ACT_INTENT Foreign Key referencing DI_ACT_INTENT. FK_ACT_MAD_HDATUM Foreign Key referencing DI_MAD_HDATUM. FK_ACT_MAD_HMETHOD Foreign Key referencing DI_ACT_MAD_HMETHOD. FK_ACT_MEDIUM Foreign Key referencing DI_ACT_MEDIUM. FK_CHARGRPTYPE Foreign Key referencing Lookup Table Chargrptype. FK_CHARTYPE Foreign key referencing Lookup Table Chartype. FK_COMMUNITY_SAMPLED Foreign Key referencing DI_COMMUNITY_SAMPLED. FK_DATE_ACT_START Foreign Key referencing DI_DATE_ACT_START. FK_DB_CAT Foreign Key referencing DI_DB_CAT. FK_GEN_DB_CAT Foreign Key referencing DI_GEN_DB_CAT. FK_GEN_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY (generated from s tation coordinates). FK_GEN_GEO_STATE Foreign Key referencing DI_GEO_STATE (generated from st ation coordinates). FK_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY. FK_GEO_STATE Foreign Key referencing DI_GEO_STATE. FK_METHOD Foreign Key referencing DI_METHOD. FK_METRICTYPE Foreign Key referencing LU_METRICTYPE. FK_ORG Foreign Key referencing DI_ORG. FK_STATION Foreign Key referencing DI_STATION. FK_STATN_TYPES Foreign Key referencing DI_STATN_TYPES. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_ACTIVITY_METRIC FK_STN_ACT_PT Foreign Key referencing DI_STN_ACT_PT. FORMULA_DESC Metric Formula description. GENERATED_HUC Generated HUC. If user provided the optional Hydrologic Unit Code, the HUC is generated based on the station l ocation information. HYDROLOGIC_UNIT_CODE The Federal Information Processing Standard (FIPS) code for Hydrologic Units, as defined in FIPS Publication 1 03. LAST_CHANGE_DATE Activity Group Last Change date LAST_TRANSACTION_ID Activity Group Last Transaction Identifier LAST_USERID Activity Group Last User Identifier LOCATION_POINT_TYPE Location Point Type MAP_SCALE Map Scale METRICTYPE_ID Metric Type identifier. METRIC_CONTEXT Metric Type context. METRIC_DETAIL_CITATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). METRIC_NAME Metric Type name. METRIC_SCALE Metric Scale. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PASS_COUNT Pass Count PASS_LENGTH Pass length PIPE_NUMBER Pipe Number PK_ISN Primary Key. Generated using sequence object SEQ_LU_IND EXTYPE. POINT_NAME User-specified free text name by which a specific absol ute location point will be known. POINT_SEQUENCE_NUMBER The number that indicates the sequence position of curr ent point among a group of points. For example, if seve ral points are recorded to mark the boundary of a stati on, the sequence number specifies the order in which th e system should "connect the dots." PRESRV_STRGE_PRCDR Free text description providing additional information about the handling, transport, preservation, and storag e of the sample. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_ACTIVITY_METRIC REPLICATE_NUMBER User-assigned number applied to samples of the same typ e, medium, etc. to differentiate between them (e.g., Wa ter Replicate 1 and Water Replicate 2, etc.) Note: Th is applies only to certain Activity Categories for Samp les (replicate, field replicate, depletion replicate, s ample created from sample) and Measurements (measuremen t replicate)- not Observations. SAMPLING_DURATION The length of time the Trap or Net is considered to be operational (i.e., collecting) SGO_INDICATOR Station SGO Indicator SOURCE_ACT_UID Source Activity Unique Identifier for traceability SOURCE_SYSTEM Data source system SOURCE_UID Source systems Unique ID for traceability. STATION_ID Station identifier. STATION_NAME Station name STN_HDATUM Station Horizontal Datum STN_LATITUDE Station Latitude measure STN_LONGITUDE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). STN_STD_HDATUM Station Standard Horizontal Datum STN_STD_LATITUDE Station Latitude measure in standard Hdatum STN_STD_LONGITUDE Station Longitude measure in standard Hdatum TAXON_DETAIL_CITATION_ID A code or identifier used by the Organization which own s the CITATION to identify it within their organization . Should be unique within the ORG. TEMP_PRESERVN_TYPE A default for the name of the type of temperature based physical preservation. TRIP_NAME Field Trip name TSRUOM_ORG_ID The TSMORGAN portion of the foreign key to TSRUOM. UPR_LWR_DEPTH_UNIT Unit code for Upper and Lower depth measure WELL_NUMBER Well Number FA_BIOLOGICAL_RESULT Table Comment Biological Result fact table ACTIVITY_CATEGORY A descriptor used to distinguish different kinds of sam ples and different kinds of Measurements and Observatio ns. The permitted value list is controlled by the choi ce of TYPE_NAME (above), with the entries in TSMPRMVL f or CATEGORY_TYPE_NAME_M used for activities of type Msr /Obs, while CATEGORY_TYPE_NAME_S is used for activities of type Sample. ACTIVITY_COMMENT Activity comment ACTIVITY_COMMUNITY The name of the Biological Community from which the Sam ple was taken. Note: This is only valid when MEDIUM_T YPE_NAME is BIOLOGICAL and INTENT_TYPE_NAME is TAXON AB UNDANCE. ACTIVITY_COND_ORG_TEXT Name of Activity Condition Organization 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT ACTIVITY_DEPTH Distance from the surface to the point in the water col umn at which the activity is conducted. ACTIVITY_DEPTH_REF_POINT The text that describes the reference point from which the depth is measured, typically "Surface". ACTIVITY_DEPTH_UNIT Activity Depth Unit ACTIVITY_ID User provided string that identifies the activity with in his/her organization. ACTIVITY_INTENT The primary reason the Field Activity occurred. Note: This is mandatory for Biological Medium, and not avail able for other media.. ACTIVITY_ISN STORET Activitys internal serial number. ACTIVITY_IS_NUMBER STORET Activitys internal serial number. ACTIVITY_LATITUDE Latitue at which activity occurred. ACTIVITY_LONGITUDE Longitude at which activity occurred. ACTIVITY_LOWER_DEPTH This measure is associated with an activity that is nor mally conducted over or within a vertical depth range w ithin the water column. This attribute is a measure of the distance from the surface to the lower boundary of the zone within which the activity is conducted or over which the activity is integrated. ACTIVITY_MEDIUM The name of the medium or matrix where the Field Activi ty occurred. ACTIVITY_REL_DEPTH Activity relative depth from the reference point ACTIVITY_START_DATE_TIME For Samples Collected or for Measurements/Observations made - the date that the Field Activity began. For Sam ples Created from other samples - the date on which a s ample is created by compositing, splitting, or subsampl ing from a parent sample. ACTIVITY_STOP_DATE_TIME Date and time at which the Activity was stopped. ACTIVITY_SUBJECT_TAXON Subject Taxon identifies the organism that composes the sample when the activity intent is Tissue or Individua l. ACTIVITY_TYPE Type of Activity. Example: Sample or Measurement/Obser vation. ACTIVITY_UPPER_DEPTH This measure is associated with an activity that is nor mally conducted over or within a vertical depth range w ithin the water column. This attribute is a measure of the distance from the surface to the upper boundary of the zone within which the activity is conducted or over which the activity is integrated. ACT_BLOB_ID Activity Binary Large Object identifier. ACT_BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT ACT_START_TIME_ZONE Activity Start Time Zone ACT_STD_HDATUM Activity Standard Horizontal Datum. The user provided data is converted to this standard datum during the ETL . ACT_STD_LATITUDE Activity Latitude measure in Activity Standard Horizont al Datum. ACT_STD_LONGITUDE Activity Longitude measure in Activity Standard Horizon tal Datum. ACT_STOP_TIME_ZONE Activity Stop Time Zone. AMPERAGE_MEASURE The magnitude of the current (amperes) produced by the electroshock equipment used to collect the Sample. ANALYSIS_DATE_TIME Sample Analysis Date and time stamp ANALYSIS_TIME_ZONE The time zone for which the time of day is reported. A ny of the longitudinal divisions of the earths surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately t o the east. ANALYTICAL_METHOD_LIST_AGENCY Name of Analyitcal method List Agency ANALYTICAL_METHOD_LIST_VER Analytical method list Version ANALYTICAL_PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. ANALYTICAL_PROCEDURE_SOURCE The name of the Analytical Procedure Owner. Examples i nclude the American Society for Testing Materials, the United States Geological Survey, and the Environmental Protection Agency. BIAS A consistent deviation of measured values from the true value, caused by systematic errors in a procedure, as determined by applying identical procedures to a specim en of known properties. BIOPART_NAME The foreign key to TSRBIOPT inplements "One Biopart (ti ssue, organ) may be the subject tissue for many Field A ctivities/Samples whose medium is biological and whose intent is Tissue. BIO_GROUP_COUNT_TYPE Biological Group count Type BIO_GROUP_DESCRIPTION Biological Group Description. BIO_GROUP_ID Biological Group ID BIO_GROUP_SUBJECT_TXN Biological Group Subject Taxon. BIO_GROUP_TYPE The name of the kind of group. Examples include: 1. p opulation census by taxon (non- duplicative species cou nt) 2. Coliform bacteria census by taxon 3. Singl e taxon frequency class 4. Single taxon group summar y 5. Single taxon individual 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT BIO_RCI_UNITS Biological RCI units BLOB_ID Blob ID. Id used to fetch Document Graphic. BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. BOAT_SPEED The relative speed, through the water, of the boat duri ng Sample collection. CAS_NUMBER EPA CAS number. CELL_FORM Cell form CELL_SHAPE The cell shape of the phytoplankton organism. For examp le, a chrysophyta can have a form and a shape. CHARACTERISTIC_DESCRIPTION Characteristic Description CHARACTERISTIC_GROUP_TYPE Charactristic Group Type Name CHARACTERISTIC_NAME Name of physical/chemical, biological and habitat chara cteristics. It is also called Substance Name in Substa nce Registry System. COMMON_CLASS_DESC Common Class Descriptor CONFIDENCE_LEVEL Result Confidence level. CONF_LVL_CORR_BIAS A code indicating whether the confidence level has been corrected for Bias. CONTAINER_DESC Description of the Sample collection Container. CORRECTION_INDICATOR Correction Indicator. CURRENT_TYPE_CODE The code that represents the type of current produced b y the electroshock equipment. DETECTION_LIMIT Result value detection limit DETECTION_LIMIT_DESCRIPTION Result value detection value description. DILUTION_INDICATOR Sample dilution indicator. DISTANCE_MEASURE_FROM Distance measured from the location. DISTANCE_MEASURE_TO Distance measured to the location. DURATION_BASIS Duration Basis ELECTROSHOCK_COMMENT Electroshock comment EPA_REG_NUMBER EPA registry number. ETL_ID ETL ID FEEDING_GROUP Feeding group FIELD_GEAR_ID Field Gear ID FIELD_PREP_PROCEDURE_ID The abbreviated name or identifying code of the prepara tion analytical procedure. FIELD_PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. FIELD_SET Field Set. FISHED_DISTANCE The distance over which the trawl was operated for Samp le collection. FISHED_DURATION Fished duration. FK_ACT_INTENT Foreign Key referencing DI_ACT_INTENT. FK_ACT_MAD_HDATUM Foreign Key referencing DI_MAD_HDATUM. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT FK_ACT_MAD_HMETHOD Foreign Key referencing DI_ACT_MAD_HMETHOD. FK_ACT_MEDIUM Foreign Key referencing DI_ACT_MEDIUM. FK_BIOPART Foreign Key referencing DI_BIOPART. FK_CHAR Foreign Key referencing DI_CHAR. FK_CHARGRPTYPE Foreign Key referencing Lookup Table Chargrptype. FK_CHARTYPE Foreign key referencing Lookup Table Chartype. FK_COMMUNITY_SAMPLED Foreign Key referencing DI_COMMUNITY_SAMPLED. FK_DATE_ACT_START Foreign Key referencing DI_DATE_ACT_START. FK_DATE_LC Foreign Key to Date LC FK_DB_CAT Foreign Key referencing DI_DB_CAT. FK_GEN_DB_CAT Foreign Key referencing DI_GEN_DB_CAT. FK_GEN_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY (generated from s tation coordinates). FK_GEN_GEO_STATE Foreign Key referencing DI_GEO_STATE (generated from st ation coordinates). FK_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY. FK_GEO_STATE Foreign Key referencing DI_GEO_STATE. FK_GROUP_TYPE Foreign Key referencing DI_GROUP_TYPE. FK_METHOD Foreign Key referencing DI_METHOD. FK_ORG Foreign Key referencing DI_ORG. FK_STATION Foreign Key referencing DI_STATION. FK_STATN_TYPES Foreign Key referencing DI_STATN_TYPES. FK_STN_ACT_PT Foreign Key referencing DI_STN_ACT_PT. FK_SUBJECT_TAXON Foreign Key referencing DI_SUBJECT_TAXON. FK_UNIT_CONVERSION Foreign Key referencing DI_UNIT_CONVERSION. GEAR_CONFIG_ID The code that identifies a Gear Configuration within th e Organization. Note: Must be unique within the Organ ization. Used as a shorthand or abbreviation to repres ent the Gear Configuration in batch data update runs. GENERATED_HUC Generated HUC. If user provided the optional Hydrologic Unit Code, the HUC is generated based on the station l ocation information. GROUP_DESC_LIFESTAGE Group description Lifestage GROUP_DESC_SEX Group Description Sex HABIT Habit HORIZONTAL_ACCURACY_MEASURE Horizontal Accuracy Measure HYDROLOGIC_UNIT_CODE The Federal Information Processing Standard (FIPS) code for Hydrologic Units, as defined in FIPS Publication 1 03. INDIVIDUAL_NUMBER System assigned sequence number to the individual in ac cordance with the total number of individuals reported by the user. Once assigned, this number does not change and cannot be changed/deleted. Each defined group of individuals gets an increasing series of "individual n umbers" for the identification of individual specimens from the original group. Results then describe the spec ific individual. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT ITIS_NUMBER Integrated Taxonomy Information system number. LAB_ACCRED_AUTHORITY LAB ACCRED Authority LAB_BATCH_ID The code that represents the laboratory batch ID for a result or a group of results. Batch ID may be used to l ink with Laboratory Data files, which may contain usefu l information further describing the reported result. LAB_CERTIFIED Laboratory Certification information LAB_ID Laboratory Identification LAB_NAME Laboratory Name LAB_REMARK Laboratory Remark LAB_SAMP_PRP_DILUTION_FACTOR Lab SAMP PRP Dilution Factor LAB_SAMP_PRP_END_DATE_TIME Lab SAMP PRP End Date & Time LAB_SAMP_PRP_END_TMZONE Lab SAMP PRP End Time Zone LAB_SAMP_PRP_METHOD_CONTEXT Lab SAMP PRP Method Context LAB_SAMP_PRP_METHOD_ID Lab SAMP PRP Method identifier LAB_SAMP_PRP_METHOD_QUAL_TYPE Type of Lab SAMP PRP Method Qualifier LAB_SAMP_PRP_START_DATE_TIME Lab SAMP PRP Start Date & Time LAB_SAMP_PRP_START_TMZONE Lab SAMP PRP Start Time Zone LAST_CHANGE_DATE Biological Last Change date LAST_TRANSACTION_ID Lat Transaction Identifier LAST_USERID Biological Last User Identifier LOCATION_POINT_TYPE Location Point Type LOWER_BOUND_AMOUNT Lower bound amount LOWER_QUANTITATION_LIMIT Lower Quantitation Limit MAP_SCALE Map Scale NON_TOW_CURRENT_SPEED Non TOW Current Speed NON_TOW_NET_SURFACE_AREA Non TOW Net Surface Area NUMBER_IN_GROUP Number in the Group ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. ORIENTATION_TO_CURRENT Orientation to Current PARTICLE_SIZE User defined free text describing the particle size cla ss for which the associated result is defined.. PASS_COUNT Pass Count PASS_LENGTH Pass length PHYS_BIO_INDICATOR Indicator of Physical and Biological result type. PIPE_NUMBER Pipe Number PK_ISN Primary Key. Generated using sequence object SEQ_BIOLOG ICAL_RESULT. PLACE_IN_SERIES Place in Series POINT_NAME User-specified free text name by which a specific absol ute location point will be known. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT POINT_SEQUENCE_NUMBER The number that indicates the sequence position of curr ent point among a group of points. For example, if seve ral points are recorded to mark the boundary of a stati on, the sequence number specifies the order in which th e system should "connect the dots." POLLUTION_TOLERANCE Pollution tolerance. POLLUTION_TOLERANCE_SCALE Pollution Tolerance scale PRECISION Estimate of the maximum possible error in the result. ( e.g., Counting error in determining radiological beta p article counts.) PRESRV_STRGE_PRCDR Free text description providing additional information about the handling, transport, preservation, and storag e of the sample. PRIMARY_CLASS_DESC Primary Class Descriptor PROJECT_ID Project Name PULSE_RATE The number of times the electric current is interrupted in one second during use of the gear. Units are pulse/ second. REACH_LENGTH Reach Length REACH_WIDTH Reach Width RECOVERY_INDICATOR Recovery Indicator REL_CURRENT_DIR Relative current direction REL_WIND_DIR Relative wind direction REPLICATE_ANALYSIS_COUNT Replication Analysis count REPLICATE_NUMBER User-assigned number applied to samples of the same typ e, medium, etc. to differentiate between them (e.g., Wa ter Replicate 1 and Water Replicate 2, etc.) Note: Th is applies only to certain Activity Categories for Samp les (replicate, field replicate, depletion replicate, s ample created from sample) and Measurements (measuremen t replicate)- not Observations. RESULT_COMMENT Result comment RESULT_DEPTH_ALT_REF_PT_TXT Text of Result Depth alternate reference point RESULT_DEPTH_MEAS_UNIT_CODE Result Depth Measure Unit Code RESULT_DEPTH_MEAS_VALUE Result Depth Measure Value RESULT_GROUP_SUMMARY_CT_WT Weight of Result Group Summary CT RESULT_IS_NUMBER Result table internal serial number RESULT_MEAS_QUAL_CODE Name of Result Measure Qualifier Code RESULT_UNIT result value unit code RESULT_VALUE result value RESULT_VALUE_STATUS Result value status RESULT_VALUE_TEXT Result Value in text RESULT_VALUE_TYPE Result value type SAMPLE_COMPONENT_NAME Name of Sample Component SAMPLE_FRACTION_TYPE Sample Fraction Type SAMPLING_DURATION The length of time the Trap or Net is considered to be operational (i.e., collecting) 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT SAMPLING_POINT_NAME Name of sampling Point SECONDARY_CLASS_DESC Secondary Class descriptor SGO_INDICATOR Station SGO Indicator SMPRP_TRANSPORT_STORAGE_DESC SMPRP Transport Storage Desciption SOURCE_SYSTEM Source System SOURCE_UID Source Unique Idetifier STATION_ID Station identifier. STATION_NAME Station name STATION_VISIT_ID Station Visit identifier STATISTIC_TYPE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN (Most Pr obable Number). STD_UNIT Result value Standard unit STD_VALUE Result standard value STN_HDATUM Station Horizontal Datum STN_LATITUDE Station Latitude measure STN_LONGITUDE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). STN_STD_HDATUM Station Standard Horizontal Datum STN_STD_LATITUDE Station Latitude measure in standard Hdatum STN_STD_LONGITUDE Station Longitude measure in standard Hdatum SUBSTANCE_DILUTION_FACTOR Subatance Dilution Factor TAXONOMIST_ACCRED_AUTHORITY Name of Taxonomist ACCRED Authority TAXONOMIST_ACCRED_YN Yes or No of Taxonomist ACCRED TAXON_DETAIL_CITATION_ID Taxon Detail Citation Identifier TEMPERATURE_BASIS_LEVEL A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). TEMP_PRESERVN_TYPE A default for the name of the type of temperature based physical preservation. TEXT_RESULT Text result TOTAL_ENERGZD_TIME Total time during the sample collection event that the electrodes were in the water and effective voltage was applied. For pulsed or intermittent electroshock proce dures, this is not the same as elapsed time. TOW_CURRENT_SPEED TOW Curtrent Speed TOW_NET_MESH_SIZE TOW Net Mesh Size TOW_NET_SURFACE_AREA TOW Net Surface Area TOXICITY_TEST_TYPE Type of Toxicity Test TRAP_NET_COMMENT User-defined text that provides further information abo ut the Trap or Net Operation. TRAWL_COMMENT User-defined text that provides further information abo ut the Trawl Operation. TRIBAL_WATER_QUALITY_MEASURE Tribal Water Quality Measure TRIP_ID Field Trip Identifier TRIP_NAME Field Trip name 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIOLOGICAL_RESULT TROPHIC_LEVEL For entries representing taxa, a code representing the trophic level with which the reported taxon is typicall y assigned. TR_START_DEPTH The measure of the starting depth of a Well Interval as calculated from the reference point expressed in feet or meters. TR_START_HDATUM Trawl start Horizontal Datum TR_START_LATITUDE Trawl Start Latitude measure TR_START_LONGITUDE Trawl Start Longtitude measure TR_START_POINT_NAME Trawl Start Point Name TR_START_STD_HDATUM Trawl Start Standard Horizontal Datum TR_START_STD_LATITUDE Trawl Start Standard Latitude measure TR_START_STD_LONGITUDE Trawl Start Standard Longitude measure TR_STOP_DEPTH The measure of the stop (ending) depth of a Well Interv al as calculated from the reference point expressed in feet or meters. TR_STOP_HDATUM Trawl Stop Horizontal Datum TR_STOP_LATITUDE Trawl Stop Latitude TR_STOP_LONGITUDE Trawl Stop Longitude TR_STOP_POINT_NAME Point Name of Trawl Stop location TR_STOP_STD_HDATUM Standard Horizontal Datum for Trawl Stop location TR_STOP_STD_LATITUDE Standard Latitude value for Trawl Stop Location TR_STOP_STD_LONGITUDE Standard Longitude value for Trawl Stop Location TSRUOM_ORG_ID The TSMORGAN portion of the foreign key to TSRUOM. UPPER_BOUND_AMOUNT Upper bound amount UPPER_QUANTITATION_LIMIT upper quantitation limit UPR_LWR_DEPTH_UNIT Unit code for Upper and Lower depth measure VISIT_START_DATE_TIME Station Visit Start Date time VISIT_START_TIME_ZONE Station Visit Start Time Zone VISIT_STOP_DATE_TIME Station Visit Stop Date time VISIT_STOP_TIME_ZONE Station Visit Stop Time Zone VOLTAGE_MEASURE The magnitude of the electro-motive force (volts) appli ed to the electroshock equipment used to collect the Sa mple. VOLTINISM Voltinism information WEIGHT_BASIS_TYPE Weight Basis type WELL_NUMBER Well Number FA_BIO_HABITAT_INDEX Table Comment Biological habitat index table ACTIVITY_ID Field Activity Identifier BHI_SCORE Score. BIOHAB_INDEX_COMMENT Comment on Bio Habitat Index BIOHAB_INDEX_ID Biological habitat index identifier. CALCULATED_DATE Calculated date. FK_DATE_LC Foreign Key to Date Last Change FK_INDEX Foreign Key referencing LU_INDEXTYPE. FK_ORG Foreign Key referencing DI_ORG. FK_STATION Foreign Key referencing FA_STATION. INDEXTYPE_ID IndexType identifier. LAST_CHANGE_DATE Activity Group Last Change date 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_BIO_HABITAT_INDEX LAST_TRANSACTION_ID Activity Group Last Transaction Identifier LAST_USERID Activity Group Last User Identifier ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. PK_ISN Primary Key. Generated using sequence object SEQ_LU_IND EXTYPE. QUALIFIER_CODE Qualifier code. SOURCE_SYSTEM Data source system SOURCE_UID Source systems Unique ID for traceability. STATION_ID Station identifier. FA_BLOB Table Comment Binary Large Object fact table BLOB_CONTENT Binary Large Object content BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. BLOB_TYPE Type of Blob (Document/Graphic) D_LAST_UPDATE_TS A system-generated value that represents the calendar d ate and time on which this information was posted to th e data base or when a subsequent modification was made. D_USERID_CODE A code that identifies the specific person making chang es to the data. FK_DATE_LC Foreign Key to Date Last Change LAST_CHANGE_DATE Last Change Date LAST_TRANSACTION_ID Last Transaction identifier LAST_USERID Name of Last User ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. SOURCE_SYSTEM Source System SOURCE_TABLE_UID Source Table Unique Identifier SOURCE_UID Source Unique Identifier TABLE_NAME The name of the Oracle Table referenced or further desc ribed by thjis BLOB. TSMBLOB_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. TSMBLOB_ORG_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). TSMPROJ_IS_NUMBER The foreign key to TSMPROJ implements "One Project may be described by one or more (actually only one) BLOBs." 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- The BLOB may consist of the entire Project Plan Docum ent in PDF format. STORETW FA_BLOB TSMPROJ_ORG_ID The TSMORGAN portion of the foreign key to TSMPROJ. TSMSTATN_IS_NUMBER The foreign key to TSMSTATN implements "One Station may be further described by one or more (actually only one ) BLOBs." The BLOB may contain a photograph of the are a comprising the monitored site. TSMSTATN_ORG_ID The TSMORGAN portion of the foreign key to TSMSTATN. TSRCITN_IS_NUMBER The foreign key to TSRCITN implements "One Literature C itation may be further described by one or more (actual ly only one) BLOBs." The BLOB may contain the entire d ocument being cited. TSRCITN_ORG_ID The TSMORGAN portion of the foreign key to TSRCITN. TSRFDACT_IS_NUMBER The foreign key to TSRFDACT implements "One Field Activ ity may be alternatively described by one or more (actu ally only one) BLOBs." TSRFDACT_ORG_ID The TSMORGAN portion of the foreign key to TSRFDACT. TSROPPRD_IS_NUMBER The foreign key to TSROPPRD implements "One Operating P eriod may be alternatively described by one or more (ac tually only one) BLOBs." TSROPPRD_ORG_ID The TSMORGAN portion of the foreign key to TSROPPRD. TSRRSULT_IS_NUMBER The foreign key to TSRRSULT implements "One Result may be further described by one or more (actually only one) BLOBs." The BLOB might be a photograph, or a graphic reproduction of a laboratory result (e.g. GCMS Spectro graph). TSRRSULT_ORG_ID The TSMORGAN portion of the foreign key to TSRRSULT. TSRSTVST_IS_NUMBER The foreign key to TSRSTVST implements "One Station Vis it may be further described by one or more (actually on ly one) BLOBs." The BLOB may contain a photograph obta ined during the visit. TSRSTVST_ORG_ID The TSMORGAN portion of the foreign key to TSRSTVST. FA_HABITAT_RESULT Table Comment Habitat result fact table ACTIVITY_CATEGORY A descriptor used to distinguish different kinds of sam ples and different kinds of Measurements and Observatio ns. The permitted value list is controlled by the choi ce of TYPE_NAME (above), with the entries in TSMPRMVL f or CATEGORY_TYPE_NAME_M used for activities of type Msr /Obs, while CATEGORY_TYPE_NAME_S is used for activities of type Sample. ACTIVITY_COMMENT Activity comment ACTIVITY_COND_ORG_TEXT Name of Activity Condition Organization ACTIVITY_DEPTH_REF_POINT Activity Depth Reference Point ACTIVITY_ID Activity Identifier ACTIVITY_ISN Field activity internal serial number. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_HABITAT_RESULT ACTIVITY_IS_NUMBER Field activity internal serial number. ACTIVITY_LATITUDE activity Latitude measure ACTIVITY_LONGITUDE Activity Longitude measure. ACTIVITY_START_DATE_TIME For Samples Collected or for Measurements/Observations made - the date that the Field Activity began. For Sam ples Created from other samples - the date on which a s ample is created by compositing, splitting, or subsampl ing from a parent sample. ACTIVITY_STOP_DATE_TIME Field activity stop date time information. ACTIVITY_TYPE Field activity type. ACT_BLOB_ID Activity BLOB ID ACT_BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. ACT_START_TIME_ZONE Activity Start Time Zone ACT_STD_HDATUM Activity Standard Horizontal Datum. The user provided data is converted to this standard datum during the ETL . ACT_STD_LATITUDE Activity Standard Latitude ACT_STD_LONGITUDE Activity Standard Longitude ACT_STOP_TIME_ZONE Activity Stop Time Zone. ANALYSIS_DATE_TIME Sample Analysis Date and time stamp ANALYSIS_TIME_ZONE The time zone for which the time of day is reported. A ny of the longitudinal divisions of the earths surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately t o the east. ANALYTICAL_METHOD_LIST_AGENCY Name of Analyitcal method List Agency ANALYTICAL_METHOD_LIST_VER Analytical method list Version ANALYTICAL_PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. ANALYTICAL_PROCEDURE_SOURCE The name of the Analytical Procedure Owner. Examples i nclude the American Society for Testing Materials, the United States Geological Survey, and the Environmental Protection Agency. BIAS A consistent deviation of measured values from the true value, caused by systematic errors in a procedure, as determined by applying identical procedures to a specim en of known properties. BLOB_ID BLOB identifier. BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. CHARACTERISTIC_GROUP_TYPE Name of Characteristic Group Type CHARACTERISTIC_NAME Name of physical/chemical, biological and habitat chara cteristics. It is also called Substance Name in Substa nce Registry System. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_HABITAT_RESULT CONFIDENCE_LEVEL Result Confidence level. CONF_LVL_CORR_BIAS A code indicating whether the confidence level has been corrected for Bias. CORRECTION_INDICATOR Correction Indicator. DETECTION_LIMIT detection limit DETECTION_LIMIT_DESCRIPTION detection limit description DETECTION_LIMIT_UNIT Detection Limit Unit DILUTION_INDICATOR dilution indicator DISTANCE_MEASURE_FROM Distance measured from the location. DISTANCE_MEASURE_TO Distance measured to the location. DURATION_BASIS Duration Basis EPA_REG_NUMBER EPA registry number. ETL_ID ETL ID FIELD_SET Field Set. FK_ACT_MAD_HDATUM Foreign Key referencing DI_ACT_MAD_HDATUM. FK_ACT_MAD_HMETHOD Foreign Key referencing DI_ACT_MAD_HMETHOD. FK_CHAR Foreign Key referencing DI_CHAR. FK_CHARGRPTYPE Foreign Key referencing Lookup Table Chargrptype. FK_CHARTYPE Foreign key referencing Lookup Table Chartype. FK_DATE_ACT_START Foreign Key referencing DI_DATE_ACT_START. FK_DATE_LC Foreign Key to Date LC FK_DB_CAT Foreign Key referencing DI_DB_CAT. FK_GEN_DB_CAT Foreign Key referencing DI_GEN_DB_CAT. FK_GEN_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY (generated from s tation coordinates). FK_GEN_GEO_STATE Foreign Key referencing DI_GEO_STATE (generated from st ation coordinates). FK_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY. FK_GEO_STATE Foreign Key referencing DI_GEO_STATE. FK_ORG Foreign Key referencing DI_ORG. FK_STATION Foreign Key referencing DI_STATION. FK_STATN_TYPES Foreign Key referencing DI_STATN_TYPES. FK_STN_ACT_PT Foreign Key referencing DI_STN_ACT_PT. FK_UNIT_CONVERSION Foreign Key referencing DI_UNIT_CONVERSION. GENERATED_HUC Generated HUC. If user provided the optional Hydrologic Unit Code, the HUC is generated based on the station l ocation information. HABITAT_CLASS_NAME The name of the portion of the habitat which is being e valuated. e.g., Bank erosion, bank stability, stream fl ow characteristics, cloud cover, and others. The hab itat index, or overall score assigned to the habitat as sessment, is usually included in the list of characteri stics as a method of displaying its value. HORIZONTAL_ACCURACY_MEASURE Horizontal Accuracy Measure HYDROLOGIC_UNIT_CODE The Federal Information Processing Standard (FIPS) code for Hydrologic Units, as defined in FIPS Publication 1 03. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_HABITAT_RESULT LAB_ACCRED_AUTHORITY LAB ACCRED Authority LAB_BATCH_ID The code that represents the laboratory batch ID for a result or a group of results. Batch ID may be used to l ink with Laboratory Data files, which may contain usefu l information further describing the reported result. LAB_CERTIFIED Laboratory Certification information LAB_ID Laboratory Identification LAB_NAME Laboratory Name LAB_REMARK Laboratory Remark LAST_CHANGE_DATE Last Change Date LAST_TRANSACTION_ID Lat Transaction IDentifier LAST_USERID Name of Last User LOCATION_POINT_TYPE Location Point Type LOWER_QUANTITATION_LIMIT Lower Quantitation Limit MAP_SCALE map scale ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PIPE_NUMBER pipe number PK_ISN Primary Key. Generated using sequence object SEQ_HABITA T_RESULT. PLACE_IN_SERIES Place in Series POINT_NAME User-specified free text name by which a specific absol ute location point will be known. POINT_SEQUENCE_NUMBER The number that indicates the sequence position of curr ent point among a group of points. For example, if seve ral points are recorded to mark the boundary of a stati on, the sequence number specifies the order in which th e system should "connect the dots." PRECISION Estimate of the maximum possible error in the result. ( e.g., Counting error in determining radiological beta p article counts.) PROJECT_ID Project Name REACH_LENGTH Reach Length REACH_WIDTH Reach Width RECOVERY_INDICATOR Recovery Indicator REPLICATE_ANALYSIS_COUNT replicate analysis count REPLICATE_NUMBER User-assigned number applied to samples of the same typ e, medium, etc. to differentiate between them (e.g., Wa ter Replicate 1 and Water Replicate 2, etc.) Note: Th 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- is applies only to certain Activity Categories for Samp les (replicate, field replicate, depletion replicate, s ample created from sample) and Measurements (measuremen t replicate)- not Observations. STORETW FA_HABITAT_RESULT RESULT_COMMENT result comment RESULT_DEPTH_ALT_REF_PT_TXT Text of Result Depth alternate reference point RESULT_DEPTH_MEAS_UNIT_CODE Result Depth Measure Unit Code RESULT_DEPTH_MEAS_VALUE Result Depth Measure Value RESULT_IS_NUMBER result internal serial number RESULT_MEAS_QUAL_CODE Name of Result Measure Qualifier Code RESULT_UNIT result value unit code RESULT_VALUE result value RESULT_VALUE_STATUS result value status RESULT_VALUE_TEXT result value text RESULT_VALUE_TYPE result vaue type SAMPLE_COMPONENT_NAME Name of Sample Component SAMPLE_FRACTION_TYPE Sample Fraction Type SAMPLING_POINT_NAME Name of sampling Point SGO_INDICATOR Station SGO Indicator SMPRP_TRANSPORT_STORAGE_DESC SMPRP Transport Storage Desciption SOURCE_SYSTEM Source System SOURCE_UID Source Unique Idetifier STATION_ID Station identifier. STATION_NAME Station name STATION_VISIT_ID Station Visit identifier STATISTIC_TYPE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). STD_UNIT Standard Unit code STD_VALUE Standard Value STN_HDATUM Station Horizontal Datum STN_LATITUDE Station Latitude measure STN_LONGITUDE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). STN_STD_HDATUM Station Standard Horizontal Datum STN_STD_LATITUDE Station Standard Latitude measure STN_STD_LONGITUDE Station Standard Longitude measure TEMPERATURE_BASIS_LEVEL A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). TEXT_RESULT Text result TRIBAL_WATER_QUALITY_MEASURE Tribal Water Quality Measure TRIP_ID Field Trip Identifier TRIP_NAME upper quantitation limit UPPER_QUANTITATION_LIMIT upper quantitation limit VISIT_START_DATE_TIME Station visit start date time VISIT_START_TIME_ZONE Station Visit Start Time Zone VISIT_STOP_DATE_TIME station visit stop date time VISIT_STOP_TIME_ZONE Station Visit Stop Time Zone WEIGHT_BASIS_TYPE Weight Basis type WELL_NUMBER Well Number 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_REGULAR_RESULT Table Comment Regular result fact table ACTIVITY_CATEGORY A descriptor used to distinguish different kinds of sam ples and different kinds of Measurements and Observatio ns. The permitted value list is controlled by the choi ce of TYPE_NAME (above), with the entries in TSMPRMVL f or CATEGORY_TYPE_NAME_M used for activities of type Msr /Obs, while CATEGORY_TYPE_NAME_S is used for activities of type Sample. ACTIVITY_COMMENT Activity comment ACTIVITY_COND_ORG_TEXT Name of Activity Condition Organization ACTIVITY_DEPTH Distance from the surface to the point in the water col umn at which the activity is conducted. ACTIVITY_DEPTH_REF_POINT The text that describes the reference point from which the depth is measured, typically "Surface". ACTIVITY_DEPTH_UNIT Field Activity depth unit ACTIVITY_ID Field Activity Identifier ACTIVITY_INTENT The primary reason the Field Activity occurred. Note: This is mandatory for Biological Medium, and not avail able for other media.. ACTIVITY_ISN Field activity internal serial number. ACTIVITY_IS_NUMBER Field activity internal serial number. ACTIVITY_LATITUDE Field activity latitude measure ACTIVITY_LONGITUDE Field activity Longitude measure ACTIVITY_LOWER_DEPTH This measure is associated with an activity that is nor mally conducted over or within a vertical depth range w ithin the water column. This attribute is a measure of the distance from the surface to the lower boundary of the zone within which the activity is conducted or over which the activity is integrated. ACTIVITY_MATRIX Activity matrix ACTIVITY_MEDIUM The name of the medium or matrix where the Field Activi ty occurred. ACTIVITY_REL_DEPTH Activity relative depth from the reference point ACTIVITY_START_DATE_TIME For Samples Collected or for Measurements/Observations made - the date that the Field Activity began. For Sam ples Created from other samples - the date on which a s ample is created by compositing, splitting, or subsampl ing from a parent sample. ACTIVITY_STOP_DATE_TIME Activity Stop Date time ACTIVITY_TYPE Field activity type. ACTIVITY_UPPER_DEPTH This measure is associated with an activity that is nor mally conducted over or within a vertical depth range w ithin the water column. This attribute is a measure of the distance from the surface to the upper boundary of the zone within which the activity is conducted or over which the activity is integrated. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_REGULAR_RESULT ACT_BLOB_ID Activity BLOB identifier ACT_BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. ACT_START_TIME_ZONE Field activity start time zone ACT_STD_HDATUM field activity standard horizontal datum ACT_STD_LATITUDE Field activity standard latitude measure ACT_STD_LONGITUDE Field activity Standard Longitude measure ACT_STOP_TIME_ZONE Field activity stop time zone ANALYSIS_DATE_TIME Sample Analysis Date and time stamp ANALYSIS_TIME_ZONE The time zone for which the time of day is reported. A ny of the longitudinal divisions of the earths surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately t o the east. ANALYTICAL_METHOD_LIST_AGENCY Name of Analyitcal method List Agency ANALYTICAL_METHOD_LIST_VER Analytical method list Version ANALYTICAL_PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. ANALYTICAL_PROCEDURE_SOURCE The name of the Analytical Procedure Owner. Examples i nclude the American Society for Testing Materials, the United States Geological Survey, and the Environmental Protection Agency. BIAS A consistent deviation of measured values from the true value, caused by systematic errors in a procedure, as determined by applying identical procedures to a specim en of known properties. BLOB_ID BLOB Identifier BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. CAS_NUMBER EPA CAS number. CHARACTERISTIC_GROUP_TYPE Charactristic Group Type Name CHARACTERISTIC_NAME Name of physical/chemical, biological and habitat chara cteristics. It is also called Substance Name in Substa nce Registry System. CONFIDENCE_LEVEL confidence level CONF_LVL_CORR_BIAS A code indicating whether the confidence level has been corrected for Bias. CONTAINER_DESC sample collection container description CORRECTION_INDICATOR Correction Indicator. DETECTION_LIMIT detection limit DETECTION_LIMIT_DESCRIPTION detection limit description DETECTION_LIMIT_UNIT Detection Limit Unit DILUTION_INDICATOR dilution indicator DISTANCE_MEASURE_FROM Distance measured from the location. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_REGULAR_RESULT DISTANCE_MEASURE_TO Distance measured to the location. DURATION_BASIS Duration Basis EPA_REG_NUMBER EPA registry number. ETL_ID ETL ID FIELD_GEAR_ID Field Gear ID FIELD_PREP_PROCEDURE_ID The abbreviated name or identifying code of the prepara tion analytical procedure. FIELD_PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. FIELD_SET Field Set. FK_ACT_MAD_HDATUM Foreign Key referencing DI_ACT_MAD_HDATUM. FK_ACT_MAD_HMETHOD Foreign Key referencing DI_ACT_MAD_HMETHOD. FK_ACT_MATRIX Foreign Key referencing DI_ACT_MATRIX. FK_ACT_MEDIUM Foreign Key referencing DI_ACT_MEDIUM. FK_CHAR Foreign Key referencing DI_CHAR. FK_CHARGRPTYPE Foreign Key referencing Lookup Table Chargrptype. FK_CHARTYPE Foreign key referencing Lookup Table Chartype. FK_DATE_ACT_START Foreign Key referencing DI_DATE_ACT_START. FK_DATE_LC Foreign Key to Date LC FK_DB_CAT Foreign Key referencing DI_DB_CAT. FK_GEN_DB_CAT Foreign Key referencing DI_GEN_DB_CAT. FK_GEN_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY (generated from s tation coordinates). FK_GEN_GEO_STATE Foreign Key referencing DI_GEO_STATE (generated from st ation coordinates). FK_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY. FK_GEO_STATE Foreign Key referencing DI_GEO_STATE. FK_METHOD Foreign Key referencing DI_METHOD. FK_ORG Foreign Key referencing DI_ORG. FK_STATION Foreign Key referencing DI_STATION. FK_STATN_TYPES Foreign Key referencing DI_STATN_TYPES. FK_STN_ACT_PT Foreign Key referencing DI_STN_ACT_PT. FK_UNIT_CONVERSION Foreign Key referencing DI_UNIT_CONVERSION. GEAR_CONFIG_ID The code that identifies a Gear Configuration within th e Organization. Note: Must be unique within the Organ ization. Used as a shorthand or abbreviation to repres ent the Gear Configuration in batch data update runs. GENERATED_HUC Generated HUC. If user provided the optional Hydrologic Unit Code, the HUC is generated based on the station l ocation information. HORIZONTAL_ACCURACY_MEASURE Horizontal Accuracy Measure HYDROLOGIC_UNIT_CODE The Federal Information Processing Standard (FIPS) code for Hydrologic Units, as defined in FIPS Publication 1 03. ITIS_NUMBER Integrated Taxonomy Information system number. LAB_ACCRED_AUTHORITY LAB ACCRED Authority 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_REGULAR_RESULT LAB_BATCH_ID The code that represents the laboratory batch ID for a result or a group of results. Batch ID may be used to l ink with Laboratory Data files, which may contain usefu l information further describing the reported result. LAB_CERTIFIED Laboratory Certification information LAB_ID Laboratory Identification LAB_NAME Laboratory Name LAB_REMARK Laboratory Remark LAB_SAMP_PRP_DILUTION_FACTOR Lab SAMP PRP Dilution Factor LAB_SAMP_PRP_END_DATE_TIME Lab SAMP PRP End Date & Time LAB_SAMP_PRP_END_TMZONE Lab SAMP PRP End Time Zone LAB_SAMP_PRP_METHOD_CONTEXT Lab SAMP PRP Method Context LAB_SAMP_PRP_METHOD_ID Lab SAMP PRP Method identifier LAB_SAMP_PRP_METHOD_QUAL_TYPE Type of Lab SAMP PRP Method Qualifier LAB_SAMP_PRP_START_DATE_TIME Lab SAMP PRP Start Date & Time LAB_SAMP_PRP_START_TMZONE Lab SAMP PRP Start Time Zone LAST_CHANGE_DATE Last Change Date LAST_TRANSACTION_ID Last Transaction IDentifier LAST_USERID Name of Last User LOCATION_POINT_TYPE Location Point Type LOWER_QUANTITATION_LIMIT Lower Quantitation Limit MAP_SCALE map scale METHOD_SPECIATION Name of Method Speciation ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PARTICLE_SIZE User defined free text describing the particle size cla ss for which the associated result is defined.. PIPE_NUMBER Pipe Number PK_ISN Primary Key. Generated using sequence object SEQ_REGULA R_RESULT. POINT_NAME User-specified free text name by which a specific absol ute location point will be known. POINT_SEQUENCE_NUMBER The number that indicates the sequence position of curr ent point among a group of points. For example, if seve ral points are recorded to mark the boundary of a stati on, the sequence number specifies the order in which th e system should "connect the dots." PORTABLE_DATA_LOGGER Portable Data Logger PRECISION Estimate of the maximum possible error in the result. ( e.g., Counting error in determining radiological beta p 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- article counts.) STORETW FA_REGULAR_RESULT PRESRV_STRGE_PRCDR Free text description providing additional information about the handling, transport, preservation, and storag e of the sample. PROJECT_ID Project Name RECOVERY_INDICATOR Recovery Indicator REPLICATE_ANALYSIS_COUNT replicate analysis count REPLICATE_NUMBER User-assigned number applied to samples of the same typ e, medium, etc. to differentiate between them (e.g., Wa ter Replicate 1 and Water Replicate 2, etc.) Note: Th is applies only to certain Activity Categories for Samp les (replicate, field replicate, depletion replicate, s ample created from sample) and Measurements (measuremen t replicate)- not Observations. RESULT_COMMENT Result Comment RESULT_DEPTH_ALT_REF_PT_TXT Text of Result Depth alternate reference point RESULT_DEPTH_MEAS_UNIT_CODE Result Depth Measure Unit Code RESULT_DEPTH_MEAS_VALUE Result Depth Measure Value RESULT_IS_NUMBER result internal serial number RESULT_MEAS_QUAL_CODE Name of Result Measure Qualifier Code RESULT_UNIT Result Unit code RESULT_VALUE Result value RESULT_VALUE_STATUS Result value status RESULT_VALUE_TEXT Result value text RESULT_VALUE_TYPE Result Value type SAMPLE_FRACTION_TYPE Sample Fraction Type SAMPLING_POINT_NAME Name of sampling Point SGO_INDICATOR Station SGO Indicator SMPRP_TRANSPORT_STORAGE_DESC SMPRP Transport Storage Desciption SOURCE_SYSTEM Source System SOURCE_UID Source Unique Idetifier STATION_ID Station identifier. STATION_NAME Station Name STATION_VISIT_ID Station Visit identifier STATISTIC_TYPE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). STD_UNIT Standard Unit code STD_VALUE Standard Value STN_HDATUM Station Horizontal Datum STN_LATITUDE Station Latitude measure. STN_LONGITUDE A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). STN_STD_HDATUM Station Standard Horizontal Datum STN_STD_LATITUDE Station Standard Latitude measure STN_STD_LONGITUDE Station Standard Longitude measure TEMPERATURE_BASIS_LEVEL A statistic or calculation type which describes the rep orted result (e.g., average, mode, median, MPN). 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_REGULAR_RESULT TEMP_PRESERVN_TYPE A default for the name of the type of temperature based physical preservation. TEXT_RESULT Text result TRIBAL_WATER_QUALITY_MEASURE Tribal Water Quality Measure TRIP_ID Field Trip Identifier TRIP_NAME Field Trip name UPPER_QUANTITATION_LIMIT upper quantitation limit UPR_LWR_DEPTH_UNIT Unit code for Upper and Lower depth measure VISIT_START_DATE_TIME Station visit start date time VISIT_START_TIME_ZONE Station Visit Start Time Zone VISIT_STOP_DATE_TIME station visit stop date time VISIT_STOP_TIME_ZONE Station Visit Stop Time Zone WEIGHT_BASIS_TYPE Weight Basis type WELL_NUMBER Well Number FA_STATION Table Comment Station fact table BLOB_ID BLOB identifier. BLOB_TITLE User-defined Title defining or describing the BLOB Cont ent. DESCRIPTION_TEXT The Organization user-defined description of a Station. May include distance to left shore or right shore to t he Station. ELEVATION The date (in format MM-DD-YYYY) when elevation measurem ent was determined. ELEVATION_UNIT Elevation Units FK_COUNTRY_CODE Foreign Key referencing DI_COUNTRY_CODE. FK_DATE_LC Foreign Key to table DI_DATE FK_DB_CAT Foreign Key referencing DI_DB_CAT. FK_ELEVATION_DATUM Foreign Key referencing DI_ELEVATION_DATUM. FK_ELEVATION_METHOD Foreign Key referencing DI_ELEVATION_METHOD. FK_ESTRY_PRIMARY Foreign Key referencing DI_ESTRY_PRIMARY. FK_ESTRY_SECONDARY Foreign Key referencing DI_ESTRY_SECONDARY. FK_GEN_DB_CAT Foreign Key referencing DI_GEN_DB_CAT. FK_GEN_GEO_COUNTY Foreign Key to table DI_GEO_COUNTY FK_GEN_GEO_STATE Foreign Key to table DI_GEO_STATE FK_GEOPOSITIONING_METHOD Foreign Key referencing DI_GEOPOSITIONING_METHOD. FK_GEO_COUNTY Foreign Key referencing DI_GEO_COUNTY. FK_GEO_STATE Foreign Key referencing DI_GEO_STATE. FK_HORIZONTAL_DATUM Foreign Key referencing DI_HORIZONTAL_DATUM. FK_MAD_HDATUM Foreign Key referencing DI_MAD_HDATUM. FK_MAD_HMETHOD Foreign Key referencing DI_MAD_HMETHOD. FK_MAD_VDATUM Foreign Key referencing DI_MAD_VDATUM. FK_MAD_VMETHOD Foreign Key referencing DI_MAD_VMETHOD. FK_ORG Foreign Key referencing DI_ORG. FK_PRIMARY_ESTUARY Foreign Key referencing DI_PRIMARY_ESTUARY. FK_PRIMARY_TYPE Foreign Key referencing DI_PRIMARY_TYPE. FK_SECONDARY_ESTUARY Foreign Key referencing DI_SECONDARY_ESTUARY. FK_SECONDARY_TYPE Foreign Key referencing DI_SECONDARY_TYPE. FK_STATE_POSTAL_CODE Foreign Key referencing DI_STATE_POSTAL_CODE. FK_STATN_TYPES Foreign Key referencing DI_STATN_TYPES. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW FA_STATION FK_STD_HDATUM Foreign Key referencing DI_STD_HDATUM. FK_WGS84_HDATUM Foreign Key to table Horizontal DATUM FRS_KEY_IDENTIFIER FRS Key identifier GENERATED_HUC Generated HUC. If user provided the optional Hydrologic Unit Code, the HUC is generated based on the station l ocation information. GEN_HUCTWELVEDIGITCODE HUC Tweleve Digit Code GEOM GEOM GREAT_LAKE_NAME Great Lake Name HORIZONTAL_ACCURACY Horizontal Accuracy Measure HYDROLOGIC_UNIT_CODE The Federal Information Processing Standard (FIPS) code for Hydrologic Units, as defined in FIPS Publication 1 03. LAST_CHANGE_DATE Last Change Date LAST_TRANSACTION_ID Last Transaction Identifier LAST_USERID Name of the Last User LATITUDE Latitude measure LOCATION_POINT_TYPE Location Point Type LONGITUDE longitude measure MAP_SCALE map scale NAICS_CODE The CODE that represents a subdivision of an industry t hat accomodates user needs in the United States (North American U.S. National Industry Classification Code). NATV_AMERICAN_LAND_NAME Native American Land Name NRCS_WATERSHED_ID NRCS Watershed_ID OBJECTID Object Identifier OCEAN_NAME Ocean Name ON_REACH_IND On Reach Indicator ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. OTHER_ESTUARY_NAME The other/local name of the Estuary. Permits user to as sign an alternate name to the estuary. When estuary is selected as "OTHER", this is the primary name. PIPE_NUMBER Pipe Number PK_ISN Primary Key. Generated using sequence object SEQ_STATIO N. POINT_NAME User-specified free text name by which a specific absol ute location point will be known. POINT_SEQUENCE_NUMBER The number that indicates the sequence position of curr 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- ent point among a group of points. For example, if seve ral points are recorded to mark the boundary of a stati on, the sequence number specifies the order in which th e system should "connect the dots." STORETW FA_STATION PROGRAM_INDICATOR Indicates Program PROJECT_ID Name of the Project RF1_MILEAGE The upstream mileage from the downstream end of the ass ociated RF1 River Reach segment to the site being descr ibed. The mileage measure may not be greater than the t otal mileage of the associated RF1 River Reach segment. (If the total mileage is missing in the RF1 River Reac h do not enforce that rule.) RF1_SEGMENT_CODE RF1 Segment code RF1_SEGMENT_NAME RF1 Segment Name SGO_INDICATOR Station SGO Indicator SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier SPRING_OTHER_NAME Spring Other Name SPRING_PERMANENCE Spring Permanence SPRING_TYPE_IMPROVEMENT Spring Type Improvement SPRING_USGS_GEOLOGIC_UNIT Spring USGS Geologic Unit SPRING_USGS_LITHOLOGIC_UNIT Spring USGS Lithologic Unit STATION_GROUP_TYPE Name of the Station Group Type STATION_ID Station identifier. STATION_IS_NUMBER station internal serial number STATION_NAME Station name STATION_VISITED Station Visited indicator STD_LATITUDE Standard Latitude value STD_LONGITUDE Standard longitude value TRIBAL_WATER_QUALITY_MEASURE Tribal Water Quallity Measure TSMALP_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. WELL_AQUIFER_NAME Name of WELL Aquifer WELL_FORMATION_TYPE Type of WELL Formation WELL_HOLE_DEPTH Depth of WELL Hole WELL_NAME Well name WELL_NUMBER Well Number WELL_TYPE_NAME Name of WELL Type WGS84_LATITUDE WGS84 LATITUDE WGS84_LONGITUDE WGS84 LONGITUDE HABITAT_RESULT_PROJECT Table Comment Habitat result and project association table FK_PROJECT Foreign Key referencing DI_PROJECT. FK_RESULT Foreign Key referencing DI_RESULT. LU_CHARGRPTYPE Table Comment Characteristic Group Type lookup table CHARACTERISTIC_GROUP_TYPE WQP Characteristic group type short names. DESCRIPTION Water Quality Portal (NWIS parameter group) Characteris tic group type description. PK_ISN WQP Characteristic group type lookup table primary key LU_CHARTYPE Table Comment Characteristic Types lookup table. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW LU_CHARTYPE CHARTYPE Chartype shot names. DESCRIPTION Chartype description. PK_ISN Chartype lookup table primary key LU_CHAR_ALIAS Table Comment Characteristic alias lookup table CHAR_ALIAS Characteristic alias name FK_CHARACTERISTIC Foreign Key referencing DI_CHARACTERISTIC. FK_CHAR_ALIAS_TYPE Foreign Key referencing DI_CHAR_ALIAS_TYPE. PK_ISN Primary Key. Generated using sequence object SEQ_CHAR_A LIAS. LU_CHAR_ALIAS_TYPE Table Comment characteristic alias type lookup table CHAR_ALIAS_TYPE_CATEGORY characteristic alias type category CHAR_ALIAS_TYPE_NAME characteristic alias type name PK_ISN Primary Key. Generated using sequence object SEQ_CHAR_A LIAS_TYPE. LU_ESTRY_PRIMARY Table Comment Primary estuary lookup table PK_ISN Primary Key. Generated using sequence object SEQ_ESTRY_ PRIMARY. PRIMARY_ESTUARY primary estuary name LU_ESTRY_SECONDARY Table Comment secondary estuary lookup table PK_ISN Primary Key. Generated using sequence object SEQ_ESTRY_ SECONDARY. SECONDARY_ESTUARY seconary estuary name LU_EXTERNAL_REF_SCHEME Table Comment External Reference scheme lookup table DESCRIPTION_TEXT The text that provides detailed information about how S tations are numbered or otherwise identified using a st ated external reference scheme. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. PK_ISN Primary Key. Generated using sequence object SEQ_EXTERN AL_REF_SCHEME. REF_SCHEME_ACRONYM Reference scheme acronym REF_SCHEME_NAME Reference Scheme name LU_INDEXTYPE Table Comment Index Type lookup table CITATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). CONTEXT Context. FK_ORG Foreign Key referencing DI_ORG. INDEXTYPE_ID Index Type identifier. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW LU_INDEXTYPE NAME Index Type name ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. PK_ISN Primary Key. Generated using sequence object SEQ_LU_IND EXTYPE. SCALE Scale. LU_MAD_HDATUM Table Comment Horizontal Datum lookup table HORIZONTAL_DATUM Horizontal Datum ID_CODE A cryptic ID code assigned through EPA Locational Data Policy to represent the Method or Datum referenced. PK_ISN Primary Key. Generated using sequence object SEQ_MAD_HD ATUM. LU_MAD_HMETHOD Table Comment Horizontal Method lookup table GEOPOSITIONING_METHOD Geopositionig Method ID_CODE A cryptic ID code assigned through EPA Locational Data Policy to represent the Method or Datum referenced. PK_ISN Primary Key. Generated using sequence object SEQ_MAD_HM ETHOD. LU_MAD_VDATUM Table Comment Vertical Datum lookup table ELEVATION_DATUM A permanently established horizontal plane, surface, or level to which soundings, ground elevations, depths, w ater surface elevations, and tidal data are referred. ID_CODE A cryptic ID code assigned through EPA Locational Data Policy to represent the Method or Datum referenced. PK_ISN Primary Key. Generated using sequence object SEQ_MAD_VD ATUM. LU_MAD_VMETHOD Table Comment Vertical Method lookup table ELEVATION_METHOD The code that represents the method used to determine e levation of a point of interest. ID_CODE A cryptic ID code assigned through EPA Locational Data Policy to represent the Method or Datum referenced. PK_ISN Primary Key. Generated using sequence object SEQ_MAD_VM ETHOD. LU_METRICTYPE Table Comment Metric Type lookup table CITATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- le for purposes of application security. Security is dr iven by user access to a given Organization(s). STORETW LU_METRICTYPE FK_ORG Foreign Key referencing DI_ORG. FORMULA_DESC Formula description. METRICTYPE_ID Metric Type identifier. METRIC_CONTEXT Metric Type context. NAME Metric Type name. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. PK_ISN Primary Key. Generated using sequence object SEQ_LU_IND EXTYPE. SCALE Scale. LU_ORGTYPE FK_ORG Foreign Key to Organization LU_QA_AGENCY Table Comment QA agency look up table PK_ISN Primary Key. Generated using sequence object SEQ_LU_QA_ AGENCY. QA_AGENCY_NAME Agency name LU_STATION_ALIAS Table Comment Station alias lookup table FK_REF_SCHEME Foreign Key referencing DI_REF_SCHEME. FK_STATION Foreign Key referencing DI_STATION. PK_ISN Primary Key. Generated using sequence object SEQ_STATIO N_ALIAS. STATION_LABEL Station Label LU_UNIT_CONVERSION Table Comment Unit conversion lookup table CONVERSION_FACTOR Conversion Factor DESCRIPTION_TEXT Conversion description text PK_ISN Primary Key. Generated using sequence object SEQ_UNIT_C ONVERSION. SHORT_FORM_NAME The abbreviation for the name of the unit of measure. TARGET_UNIT Unit Conversion Target Unit UOM_TYPE The category that represents the broad class of a relat ed set of units. Examples: Volume, Concentration, Mas s, Area, Velocity, Flow, Length/width/height, Temperatu re, Energy, Work/power LU_WS_SERVICE Table Comment Web services lookup table. PK_ISN Primary key for lu_ws_service table WEB_SERVICE_NAME Web service name MD_ANALYTICAL_PROC Table Comment Analytical procedure metadata table ANLPR_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. CITATION A bibliographic reference cited to provide additional i 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- nformation concerning an Organizations procedures, meth ods and/or data. STORETW MD_ANALYTICAL_PROC EQUIPMENT_NAME Equipment Name FK_ORG Foreign Key referencing FK_ORG. NATIONAL_PROC_ID National Procedure Identifier ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PK_ISN Primary Key. Generated using sequence object SEQ_ANALYT ICAL_PROC. PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. PROCEDURE_NAME The full title of the analytical procedure. PROCEDURE_SOURCE The name of the Analytical Procedure Owner. Examples i nclude the American Society for Testing Materials, the United States Geological Survey, and the Environmental Protection Agency. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_CITATION Table Comment Citation metadata table AUTHOR The full name(s) of author(s) of the publication being cited. CITATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). CITATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. COMMENTS User-defined text that provides further information abo ut the Citation. FK_ORG Foreign Key referencing DI_ORG. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MD_CITATION ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PBLSHR_ORG_NAME The name of the organization which issued the publicati on being cited. PK_ISN Primary Key. Generated using sequence object SEQ_CITATI ON. PUBLISHING_YEAR The copyright year of the publication being cited. REFERENCE_ID A code or identifier used by the Organization which own s the CITATION to identify it within their organization . Should be unique within the ORG. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier TITLE The official name of the publication being cited. VOL_AND_PAGE Specific volume and page numbers within the literature cited which apply to data supported by the CITATION. " ALL" may be entered to indicate a reference to the enti re publication. MD_COOP Table Comment Cooperating Organization metadata table COOP_ORGANIZATION_NAME The formal full-length name of the Cooperating Organiza tion. Example: University of Hawaii COOP_ORG_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. FK_ORG Foreign Key referencing DI_ORG. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PK_ISN Primary Key. Generated using sequence object SEQ_COOP. PRIMARY_CONTACT_NAME The name of the point of contact for the Cooperating Or ganization who has knowledge of the relationship betwee n the Cooperating Organization and the data-owning Orga nization. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_COOP_ADDRESS Table Comment Cooperating Organization address metadata table ADDRESS_FOUR_TEXT Cooperating address text line 4 ADDRESS_ONE_TEXT The first line of an Address which usually denotes the company or individual name. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MD_COOP_ADDRESS ADDRESS_THREE_TEXT The third line of an Address usually denotes the street address including street name and type, house/office n umber, or sector designation. ADDRESS_TWO_TEXT The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also co ntain company name in addition. COOP_ADDR_IS_NUMBER Cooperating organization address internal serial number COOP_ADDR_TYPE cooperating address type COOP_ORG_IS_NUMBER cooperating org internal serial number COUNTRY_CODE The 2-character Federal Information Processing Standard (FIPS) code (ref FIPS Pub 10-3) representing the Count ry. FK_COOP Foreign Key referencing DI_COOP. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. PK_ISN Primary Key. Generated using sequence object SEQ_COOP_A DDRESS. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier START_DATE The date (in format MM-DD-YYYY) on which a Project or S urvey is scheduled to begin. MD_COOP_EADDRESS Table Comment Cooperating Organization electronic address metadata ta ble ADDRESS_ONE_TEXT The first line of an Address which usually denotes the company or individual name. ADDRESS_TWO_TEXT The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also co ntain company name in addition. COOP_EADDR_IS_NUMBER cooperating organization electronic address internal se rial number COOP_EADDR_TYPE cooperating organization electronic address type COOP_ORG_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. FK_COOP Foreign Key referencing DI_COOP. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. STORETW MD_COOP_EADDRESS PK_ISN Primary Key. Generated using sequence object SEQ_COOP_E ADDRESS. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_LAB Table Comment Laboratory metadata table FK_ORG Foreign Key referencing DI_ORG. LAB_ID Laboratory Identification LAB_IS_NUMBER The foreign key to TSRLAB implements "One Laboratory ma y have many addresses." LAB_NAME laboratory name ORGANIZATION_ID The TSMORGAN portion of the key in TSRLAB. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PK_ISN Primary Key. Generated using sequence object SEQ_LAB. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_LAB_ADDRESS Table Comment Laboratory address metadata table ADDRESS_FOUR_TEXT The name of the city, state, and zip code in an Address . ADDRESS_ONE_TEXT The first line of an Address which usually denotes the company or individual name. ADDRESS_THREE_TEXT The third line of an Address usually denotes the street address including street name and type, house/office n umber, or sector designation. ADDRESS_TWO_TEXT The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also co ntain company name in addition. ADDRESS_TYPE The code designating the type of Address. ADDR_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. COUNTRY_CODE The code for the country in an Address. FK_LAB Foreign Key referencing DI_LAB. LAB_IS_NUMBER The foreign key to TSRLAB implements "One Laboratory ma y have many addresses." ORGANIZATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MD_LAB_ADDRESS PK_ISN Primary Key. Generated using sequence object SEQ_LAB_AD DRESS. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier START_DATE The date (in format MM-DD-YYYY) the Address became effe ctive. FIELD NOT IN USE. MD_LAB_EADDRESS Table Comment Laboratory electronic address metadata table ADDRESS_ONE_TEXT The first line of an Address which usually denotes the company or individual name. ADDRESS_TWO_TEXT The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also co ntain company name in addition. EADDR_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. FK_LAB Foreign Key referencing DI_LAB. LAB_ADDR_TYPE The code designating the type of Address. LAB_IS_NUMBER The foreign key to TSRLAB implements "One Laboratory ma y have many Electronic Addresses." ORGANIZATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). PK_ISN Primary Key. Generated using sequence object SEQ_LAB_EA DDRESS SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_LAB_SAMPLE_PREP_PROCEDURE Table Comment Laboratory sample preparation procedure metadata table CITATION A bibliographic reference cited to provide additional i nformation concerning an Organizations procedures, meth ods and/or data. FK_ORG Foreign Key referencing DI_ORG. LSPP_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. LSPP_SOURCE When Nationally owned, the formal name of the organizat ion which publishes the official description of the pro cedure. e.g. American Public Health Association. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- Organization. STORETW MD_LAB_SAMPLE_PREP_PROCEDURE ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PK_ISN Primary Key. Generated using sequence object SEQ_LAB_SA MPLE_PREP_PROCEDURE. PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. PROCEDURE_NAME The full title of the analytical procedure. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_ORG_ADDRESS Table Comment Organization address metadata table ADDRESS_TYPE The code designating the type of Address. ADDR_FOUR_TEXT The name of the city, state, and zip code in an Address . ADDR_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. ADDR_ONE_TEXT The first line of an Address which usually denotes the company or individual name. ADDR_THREE_TEXT The third line of an Address usually denotes the street address including street name and type, house/office n umber, or sector designation. ADDR_TWO_TEXT The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also co ntain company name in addition. COUNTRY_CODE The code for the country in an Address. FK_ORG Foreign Key referencing DI_ORG. ORGANIZATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). ORGANIZATION_IS_NUMBER The foreign key to TSMORGAN implements "One Organizatio n may have many addresses." PK_ISN Primary Key. Generated using sequence object SEQ_ORG_AD DRESS. SOURCE_SYSTEM Source system acronym from which the record was extract ed, transformed and loaded into Warehouse. SOURCE_UID Unique Identifier of the record in the Source system. START_DATE The date (in format MM-DD-YYYY) the Address became effe ctive. FIELD NOT IN USE. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MD_ORG_EADDRESS Table Comment Organization electronic address metadata table ADDRESS_ONE_TEXT The first line of an Address which usually denotes the company or individual name. ADDRESS_TWO_TEXT The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also co ntain company name in addition. ADDRESS_TYPE The code designating the type of Address. EADDR_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. FK_ORG Foreign Key referencing DI_ORG. ORGANIZATION_ID The user-defined code that uniquely identifies the Orga nization to which each occurrence of this table applies . This identifying attribute has been added to this tab le for purposes of application security. Security is dr iven by user access to a given Organization(s). ORGANIZATION_IS_NUMBER The foreign key to TSMORGAN implements "One Organizatio n may have many electronic addresses." PK_ISN Primary Key. Generated using sequence object SEQ_ORG_EA DDRESS. SOURCE_ORGPH_UID source organization phone Uid SOURCE_SYSTEM Source system acronym from which the record was extract ed, transformed and loaded into Warehouse. SOURCE_UID Unique Identifier of the record in the Source system. MD_PROGRAM Table Comment Program metadata table DESCRIPTION A text description of the referenced Method or Datum. FK_ORG Foreign Key referencing DI_ORG. ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PK_ISN Primary Key. Generated using sequence object SEQ_PROGRA M. PROGRAM_IS_NUMBER Program internal serial number PROGRAM_NAME program name PROGRAM_TYPE program type PROJECT_ID Project identifier. This is uniquer with in an organiza tion. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MD_PROGRAM PROJECT_NAME The name assigned by the owning Organization to the Pro ject or Survey. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier MD_SAMPLE_GEAR Table Comment Sample Gear metadata table CONFIG_ID configuation identifier CONFIG_NAME configuration name FIELD_GEAR_ID Field Gear ID FK_ORG Foreign Key referencing DI_ORG. GEAR_GROUP_NAME Gear Group name GEAR_NAME Gear name ORGANIZATION_ID Organization identifier ORGANIZATION_IS_NUMBER The foreign key to TSMPRMVL implements "One Permitted V alue may be the Container Color for many Samples. PK_ISN Primary Key. Generated using sequence object SEQ_SAMPLE _GEAR. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier SPECIFICATION_TEXT Sample gear specification text MD_SAMPLE_PRESRV Table Comment Sample preservation metadata table CONTAINER_COLOR Default description of the color of the container used to collect and transport the sample. CONTAINER_SIZE A default for the measure of the size of the container for a Sample. CONTAINER_SIZE_UNIT The code that represents the default units in which the container size is expressed. CONTAINER_TYPE A default for the name of the type of temperature based physical preservation. FK_ORG Foreign Key referencing FK_ORG. ORGANIZATION_ID The TSMORGAN portion of the foreign key to TSMPRMVL. ORGANIZATION_IS_NUMBER The foreign key to TSMPRMVL implements "One Permitted V alue may be the Container Color for many Samples. PK_ISN Primary Key. Generated using sequence object SEQ_SAMPLE _PRESRV. PRESRV_DESC Sample preservation description SAMPLE_ID Sample preservation sample Identifier SAMPLE_NAME Sample preservation Sample name SDP_ORGANIZATION_IS_NUMBER Sample preservation organization internal serial number SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier TEMP_PRESERVATION A default for the name of the type of temperature based physical preservation. MD_SAMPLE_PROC Table Comment Sample procedure metadata table 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MD_SAMPLE_PROC CITATION A bibliographic reference cited to provide additional i nformation concerning an Organizations procedures, meth ods and/or data. DESCRIPTION Sample procedure description FK_ORG Foreign Key referencing DI_ORG. FLDPR_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. GEAR_GP_NAME Sample procedure gear group name ORGANIZATION_ID The user-defined code that uniquely identifies an Organ ization. Organization IDs are registered centrally wit h STORET so that they are guaranteed to be unique on th e National level. They become part of the Oracle Key o n every row in the STORET database that belongs to the Organization. ORGANIZATION_IS_NUMBER A system-generated value used to uniquely identify an o ccurrence of this table. PK_ISN Primary Key. Generated using sequence object SEQ_SAMPLE _PROC.. PROCEDURE_ID The abbreviated name or identifying code of the analyti cal procedure. PROCEDURE_NAME The full title of the analytical procedure. PROCEDURE_QUAL_TYPE Identifier of type of method that identifies it as refe rence, equivalent, or other. SOURCE_SYSTEM Metadata source system acronym SOURCE_UID Metadata source record unique identifier METRIC_RESULT_PROJECT Table Comment Activity Metric Result and Project association table FK_PROJECT Foreign Key referencing DI_PROJECT. FK_RESULT Foreign Key referencing DI_RESULT. MT_ATTRIBUTE_MAP ATTR_1 Attribute One ATTR_2 Attribute Two ATTR_3 Attribute Three ATTR_DESCRIPTION Attribute Description MAPPING_FIELD Mapping Field PK_ISN Primary Key. Generated using sequence object SORT_ORDER Sort Order STATUS Status STORET_NAME Storet Name STORET_NAME2 Secondary STORET Name WQX_NAME WQX Name WQX_NAME2 Secondary WQX Name MT_CHAR_CHARTYPE CHARACTERISTIC_GROUP_TYPE Characteristic Group Type CHARTYPE Characteristic Type CHAR_NAME Characteristic Name FK_CHARTYPE Foreign Characteristic Type MT_OBJECT_DDL_WQX_ETL DDL_GEN_DATE DDL Generated Date OBJECT_CREATE_DATE Object Create Date 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW MT_OBJECT_DDL_WQX_ETL OBJECT_CREATE_STATUS Object Create Status OBJECT_DDL Object DDL OBJECT_DELETE_STATUS Object Delete Status OBJECT_DROP_DATE Object Drop Date OBJECT_NAME Object Name OBJECT_TYPE Object Type TABLE_NAME Table Name MT_PROD_OBJECTS COMMENT_DESC Comment Description ONAME Object Name OTYPE Object Type OWNER Owner PRE_ETL REQUIRED TO BE PRESENT BEFORE WQX ETL. PRE_PROD REQUIRED TO PRESENT BEFORE MOVING TO PRODUCTION MT_WH_CONFIG APPLICATION Application Name DESCRIPTION Description PARAMETER_NAME Parameter Name PARAMETER_VALUE Parameter Value REGULAR_RESULT_PROJECT Table Comment Regular result and project association table FK_PROJECT Foreign Key referencing DI_PROJECT. FK_RESULT Foreign Key referencing DI_RESULT. SEQ_GEN COLUMN_NAME Column Name MAX_NUMBER Maximum Number SEQUENCE_NAME Sequence Name SEQ_CR_STMT Sequence CR Statement SEQ_CUR_VALUE Sequence Current Value SEQ_GEN_FLAG Sequence Generated Flag SEQ_NEW_VALUE Sequence New Value TABLE_NAME Table Name STATE_CHAR_YEAR Table Comment Summary by state, characteristic and year; table used f or dashboard. ACT_START_YEAR_DATE Year (numeric 4 digit). BIOLOGICAL_COUNT Biological result counts. DISPLAY_NAME Characteristic name (english) FK_CHAR Characteristic identifier. FK_GEN_GEO_STATE State identifier. HABITAT_COUNT Habitat result counts. INDEX_COUNT Index result counts. METRIC_COUNT Metric result counts. REGULAR_COUNT Regular result counts. RESULT_COUNT Total counts. STATE_NAME State name (english). STATE_ORG_CHAR_YEAR Table Comment Summary by state, organization, characteristic and year ; table used for dashboard. ACT_START_YEAR_DATE Year (numeric 4 digit). BIOLOGICAL_COUNT Biological result counts. DISPLAY_NAME Characteristic name (english) FK_CHAR Characteristic identifier. FK_GEN_GEO_STATE State identifier. FK_ORG Organization identifier. HABITAT_COUNT Habitat result counts. INDEX_COUNT Index result counts. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW STATE_ORG_CHAR_YEAR METRIC_COUNT Metric result counts. ORGANIZATION_ID Organization abbrev. (english) REGULAR_COUNT Regular result counts. RESULT_COUNT Total counts. STATE_NAME State name (english). STATE_ORG_YEAR Table Comment Summary by state, organization and year; table used for dashboard. ACT_START_YEAR_DATE Year (numeric 4 digit). BIOLOGICAL_COUNT Biological result counts. FK_GEN_GEO_STATE State identifier. FK_ORG Organization identifier. HABITAT_COUNT Habitat result counts. INDEX_COUNT Index result counts. METRIC_COUNT Metric result counts. ORGANIZATION_ID Organization abbrev. (english) REGULAR_COUNT Regular result counts. RESULT_COUNT Total counts. STATE_NAME State name (english). STATE_YEAR Table Comment Summary by state and year; table used for dashboard. ACT_START_YEAR_DATE Year (numeric 4 digit). BIOLOGICAL_COUNT Biological result counts. FK_GEN_GEO_STATE State identifier. HABITAT_COUNT Habitat result counts. INDEX_COUNT Index result counts. METRIC_COUNT Metric result counts. REGULAR_COUNT Regular result counts. RESULT_COUNT Total counts. STATE_NAME State name (english). STATION_CHAR Table Comment Station and characteristic association table ACT_MAX_START_DATE Activity maximum Start Date ACT_MIN_START_DATE Activity Minimum Start Date BIOLOGICAL_COUNT Biological result count CHAR_TYPE_CODE A code indicating type of characteristic. DISPLAY_NAME The name of the environmental characteristic as it is t o be displayed on windows and reports. FK_CHAR Foreign Key referencing DI_CHAR. FK_FA_STATN Foreign Key referencing DI_FA_STATN. HABITAT_COUNT Habitat result count HYDROLOGIC_UNIT_CODE Hydrologic Unit Code ORGANIZATION_ID Organization Identifier REGULAR_COUNT Regular result count RESULT_COUNT Total Result Count RSLT_AVG_VALUE_MEASURE Result Average Value Measure RSLT_MAX_VALUE_MEASURE Result Maximum Value Measure RSLT_MEASURE_UNIT Result Measure Unit RSLT_MIN_VALUE_MEASURE Result Minimum Value Measure SEARCH_NAME The name by which an Organization refers to a Station. For unambiguous search results, always contains the al l upper-case form of the Name. STATION_ID Station Identifier 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW STATION_CHAR STATION_NAME Station Name TRIBAL_WATER_QUALITY_MEASURE Tribal Water Quality Measure STATION_CHAR_MEDIUM Table Comment Station and characteristic association table ACT_MAX_START_DATE Activity maximum Start Date ACT_MAX_START_STOP_DATE Activity Maximum Start & Stop Date ACT_MIN_START_DATE Activity Minimum Start Date BIOLOGICAL_COUNT Biological result count CHARTYPE Characteristic Type CHAR_TYPE_CODE A code indicating type of characteristic. DISPLAY_NAME The name of the environmental characteristic as it is t o be displayed on windows and reports. FK_ACT_MEDIUM Foreign key to Activity Medium FK_CHAR Foreign Key referencing DI_CHAR. FK_FA_STATN Foreign Key referencing DI_FA_STATN. FK_GEN_DB_CAT Foeign Key Genarated to DI_DB_CAT FK_ORG Foeign key to Organization HABITAT_COUNT Habitat result count HYDROLOGIC_UNIT_CODE Hydrologiv Unit Code LAST_CHANGE_DATE User Last Change Date ORGANIZATION_ID Organization Identifier REGULAR_COUNT Regular result count RESULT_COUNT Result Count RSLT_AVG_VALUE_MEASURE Result Average Vakue Measure RSLT_MAX_VALUE_MEASURE Result Maximum Value Measure RSLT_MEASURE_UNIT Result Measure Unit RSLT_MIN_VALUE_MEASURE Result Minimum Value Measure SEARCH_NAME The name by which an Organization refers to a Station. For unambiguous search results, always contains the al l upper-case form of the Name. STATION_ID Station Identifier STATION_NAME Station Name STATION_CHAR_YEAR Table Comment Summary by station, characteristic and year; base table for dashboard. ACT_START_YEAR_DATE Year (numeric 4 digit). BIOLOGICAL_COUNT Biological result counts. DISPLAY_NAME Characteristic name (english) FK_CHAR Characteristic identifier. FK_FA_STATN Station identifier. FK_GEN_DB_CAT HUC8 identifier. FK_GEN_GEO_COUNTY County identifier. FK_GEN_GEO_STATE State identifier. FK_ORG Organization identifier. HABITAT_COUNT Habitat result counts. INDEX_COUNT Index result counts. METRIC_COUNT Metric result counts. ORGANIZATION_ID Organization abbrev. (english) REGULAR_COUNT Regular result counts. RESULT_COUNT Total counts. STATE_NAME State name (english). STATION_ID Station abbrev. (english) 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW STATION_CHAR_YEAR STATION_NAME Station name (english) STATION_PROJECT Table Comment Station and project association table CITATION_ID Citation Identifier FK_PROJECT Foreign Key referencing DI_PROJECT. FK_STATION Foreign Key referencing DI_STATION. ORGANIZATION_ID Organization identifier of the station PROJECT_CD Project code REFERENCE_LOCATION_CODE Reference Location Code REFERENCE_LOC_END_DATE Reference Location End Date REFERENCE_LOC_START_DATE Reference Location Start Date SITE_STATUS Station weight site status STATION_ID Station identifier STATION_WEIGHT Project station weight STATION_WEIGHT_CATEGORY Station weight category STATION_WEIGHT_COMMENT Station Weight Comment STRATUM Station weight stratum WEIGHT_UNIT_CODE Station weight unit code. STATION_YEAR Table Comment Summary by station and year. STG_ACTIVITY_PROJECT ACT_UID Activity Unique Identifier ERROR_MSG Error Message PRJ_UID Project Unique Identifier RES_TYPE Result Type STATUS Status TOAD_PLAN_TABLE ACCESS_PREDICATES Access Predicates BYTES Bytes CARDINALITY Cardinality COST Cost CPU_COST CPU Cost DEPTH Depth DISTRIBUTION Distribution FILTER_PREDICATES Filter Predicates ID Table Identifier OBJECT_ALIAS Object Alias OBJECT_INSTANCE Object Instance OBJECT_NAME Object Name OBJECT_NODE Object Node OBJECT_OWNER Object Owner OBJECT_TYPE Object Type OPERATION Operation OPTIMIZER Optimizer OPTIONS Options OTHER Other OTHER_TAG Other Tag OTHER_XML Other XML PARENT_ID Parent Identifier PARTITION_ID Partition Identifier PARTITION_START Partition Start PARTITION_STOP Partition Stop PLAN_ID Plan Identifier POSITION Position PROJECTION Projection QBLOCK_NAME QBlock Name REMARKS Remarks 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW TOAD_PLAN_TABLE SEARCH_COLUMNS Search Columns STATEMENT_ID Statement Identifier TEMP_SPACE Temp Space TIME Time TIMESTAMP System Time Stamp WS_HUC_CHAR_SUMMARY Table Comment Watershed Hydrologic characteristic Summary table. CHARACTERISTIC_ID Characteristic Identifier CHARTYPE_ID Chartype Identifier CHARTYPE_NAME Chartype Name CHAR_ACT_START_DATE activity start date for the characteristic with in the HUC CHAR_ACT_STOP_DATE activity stop date for the characteristic with in the H UC CHAR_DISPLAY_NAME Characteristic Display Name HYDROLOGIC_UNIT_CODE Hydrologic Unit code RESULT_COUNT Result count WS_HUC_ORG_CHAR_SUMMARY Table Comment Watershed Hydrologic Oganization Char Summary table CHARACTERISTIC_ID Characteristic Identifier CHARTYPE_ID Chartype Identifier CHARTYPE_NAME Chartype Name CHAR_ACT_START_DATE activity start date for the characteristic with in the HUC and ORG_ID CHAR_ACT_STOP_DATE activity stop date for the characteristic with in the H UC and ORG_ID CHAR_DISPLAY_NAME Characteristic Display Name HYDROLOGIC_UNIT_CODE Hydrologic Unit code ORGANIZATION_ID Organization Identifier RESULT_COUNT Results count WS_HUC_ORG_SUMMARY Table Comment Watershed Hydrologic Oganization Summary table. CHARACTERISTIC_COUNT Characteristic Count HYDROLOGIC_UNIT_CODE Hydrologic Unit code MAX_ACTIVITY_STOP_DATE_TIME Maximum Acitvity Stop Date Time MIN_ACTIVITY_START_DATE_TIME Minimum Activity Start Date Time ORGANIZATION_ID Organization Identifier ORGANIZATION_NAME Organization Name RESULT_COUNT Results count STATION_COUNT Station count WS_ORG_ACTIVITY ACTIVITY_COND_ORG_TEXT Activity Condition Organization Text ACTIVITY_DEPTH Activity Depth ACTIVITY_DEPTH_REF_POINT Activity Depth Reference Point ACTIVITY_DEPTH_UNIT Activity Depth Unit ACTIVITY_ID Activity Identifier ACTIVITY_LOWER_DEPTH Activity Lower Depth ACTIVITY_MATRIX Activity Matrix ACTIVITY_MEDIUM Activity Medium ACTIVITY_START_DATE Activity Start Date ACTIVITY_TYPE Activity Type ACTIVITY_UPPER_DEPTH Activity Upper Depth ORGANIZATION_ID Organization Identifier 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW WS_ORG_ACTIVITY RESULT_TYPE Result Type STATION_ID Station Identifier STATION_TYPE Station Type UPR_LWR_DEPTH_UNIT Upper & Lower Depth Unit WS_ORG_ACTIVITY_PROJECT ACTIVITY_ID Activity Identifier ACTIVITY_START_DATE Activity Start Date ORGANIZATION_ID Organization Identifier PROJECT_CD Project Code RESULT_TYPE Result Type WS_PROJECT_STATION_CHAR ACT_MAX_START_STOP_DATE Activity Maximum Start & Stop Date ACT_MIN_START_DATE Activity Minimum Start Date CHARACTERISTIC_NAME Characteristic Name CHARTYPE Characteristic Type FK_CHAR Foreign key to DI_Characteristic Table FK_ORG Foreign key to DI_ORG FK_PROJECT Foreign Key to DI_Project Table FK_STATION Foreign key to FA_Station HYDROLOGIC_UNIT_CODE Hydrologic Unit code ORGANIZATION_ID Organization Identifier ORGANIZATION_NAME Organization Name PROJECT_CD Project Name RESULT_COUNT Count of Result STATION_ID Station Identifier STATION_NAME Station Name STN_STD_LATITUDE Station Standard Latitude STN_STD_LONGITUDE Station standard Longitude WS_PROJECT_STATION_CHAR_TEMP ACT_MAX_START_STOP_DATE Activity Maximum Start & Stop Date ACT_MIN_START_DATE Activity Minimum Start Date FK_CHAR Foreign key to DI_Characteristic Table FK_ORG Foreign key to DI_ORG FK_PROJECT Foreign Key to DI_Project Table FK_STATION Foreign key to FA_Station RESULT_COUNT Count of Result WS_STATION_DATA CHARACTERISTIC_GROUP_TYPE Characteristic Group Type CHARACTERISTIC_ID Charactistic Identifier CHAR_DISPLAY_NAME Characteristic Display Name CHAR_RESULT_COUNT Characteristic Result Count FK_STATION Foreign key to FA_Station HYDROLOGIC_UNIT_CODE Hydrologic Unit code MAX_ACTIVITY_STOP_DATE_TIME Maximum Activity Stop Date & Time MIN_ACTIVITY_START_DATE_TIME Minimum Activity Start Date & Time ORGANIZATION_ID Organization Identifier ORGANIZATION_NAME Organization Name RSLT_AVG_VALUE_MEASURE Result Average Value Measure RSLT_MAX_VALUE_MEASURE Result Maximum value Measure RSLT_MEASURE_UNIT Result Measure Unit RSLT_MIN_VALUE_MEASURE Result Minimum Value Measure STATION_ID Station Identifier STATION_NAME Station Name STD_LATITUDE Standard Latitude STD_LONGITUDE Standard Longitude UNIQUE_STATION_IDENTIFIER Unique Station Identifier WS_STATION_SUMMARY Table Comment Watershed Station Summary table. 07-JUL-14 Table Comment Report OWNER TABLE_NAME HEADING COMMENTS --------------- ------------------------------ ------------------------------ ------------------------------------------------------- STORETW WS_STATION_SUMMARY CHARACTERISTIC_GROUP_TYPE Characteristic Group Type CHARACTERISTIC_ID Characteristic Identifier CHARACTERISTIC_RESULT_COUNT Characteristic Result Count CHARTYPE CharType CHARTYPE_ID Chartype Identifier CHAR_ACT_START_DATE station char activity start date time CHAR_ACT_STOP_DATE station char activity stop datetime CHAR_DISPLAY_NAME Characteristic Display Name FK_STATION Foreign Key to FA_STATION HYDROLOGIC_UNIT_CODE Hydrologic Unit code MAX_ACTIVITY_STOP_DATE_TIME Maximum Acivity Stop Date Time MIN_ACTIVITY_START_DATE_TIME Minimum Activity Start Date Time ORGANIZATION_ID Organization Identifier ORGANIZATION_NAME Organization Name RSLT_AVG_VALUE_MEASURE Result Average Value Measure RSLT_MAX_VALUE_MEASURE Result Maximum Value Measure RSLT_MEASURE_UNIT Result Measure Unit RSLT_MIN_VALUE_MEASURE Result Minimum Value Measure STATION_ID Station Identifier STATION_NAME Station Name STD_LATITUDE Station Latitude STD_LONGITUDE Station Longitude UNIQUE_STATION_IDENTIFIER Unique Station Identifier generated for application pur poses WS_WEB_METHOD Table Comment Web methods table. ENVIROMAPPER_FLAG Enviromapper flag FK_SERVICE Foreign key referencing lu_ws_service.pk_isn OUTPUT_FORMAT Format of the output generated by the web method PK_ISN Primary key for ws_web_method table SERVICE_PROTOCOL Service protocol used by the web method SUBMIT_METHOD Submit method for the web method WEB_METHOD_ID Identifier for the web method WEB_METHOD_NAME Name of the web method WS_WEB_METHOD_INPUT_PARAM Table Comment Web method input parameters table. DATA_TYPE Data type of the input param. FK_WEB_METHOD Foreign key referencing pk of ws_web_method. MAX_LENGTH Maximum length of data allowed. MULTIPLICITY Maximum Number of values allowed. PARAM_NAME Name of the input parameter. PK_ISN Primary key on ws_web_method_input_param table. SEQUENCE_NUMBER Ordinal position of the paramater, within the procedure call. TITLE Label used with the input parameter.