[xls] · web viewthe alpha-numeric code assigned by the owning organization which uniquely...

Category Sub Category Data Element XML Tag WQX Definition Optionality Data Type Business Rule or Additional DescriptionSchema File Name

STORET Definition EDSC Data Element EDSC Definition EDSC ComplianceORGANIZATION ORG Description 01.00.00 Header

ORG Description 01.00.01 OrganizationIdentifier Mandatory string max 30 Contact OrganizationIdentifier Compliant

ORG Description 01.00.02 Mandatory string max 120 Organization Name according to Trading Partner NAME Contact OrganizationFormalName Compliant

ORG Description 01.00.03 Optional string max 500

ORG Description 01.00.04 TribalCode Optional Yes Tribal TribalCode Compliant

ORG Electronic Address 01.01.00 Header ElectronicAddress

ORG Electronic Address 01.01.01 ElectronicAddressText string max 120 Required if electronic address type name is present Contact ElectronicAddressText Compliant

ORG Electronic Address 01.01.02 Required if electronic address text is present Contact ElectronicAddressTypeName Compliant

ORG Telephonic 01.02.00 Header Telephonic

ORG Telephonic 01.02.01 TelephoneNumberText String max 15 Required if telephone number type name is present WQX_Telephonic_v1.0.xsd Contact TelephoneNumberText Compliant

ORG Telephonic 01.02.02 Required if telephone number text is present WQX_Telephonic_v1.0.xsd Contact TelephoneNumberTypeName Compliant

ORG Telephonic 01.02.03 Optional String max 6 Optional WQX_Telephonic_v1.0.xsd Contact Compliant

ORG Organization Address 01.03.00 Header OrganizationAddress

ORG Organization Address 01.03.01 AddressTypeName Required if organization address is present.

ORG Organization Address 01.03.02 AddressText string max 50 Required if Address Type Name is supplied. Contact

ORG Organization Address 01.03.03 Optional string max 120 Contact

ORG Organization Address 01.03.04 LocalityName Optional String max 30 Contact

ORG Organization Address 01.03.05 StateCode Required if Organization County Code is reported. Contact

ORG Organization Address 01.03.06 PostalCode Optional string max 10 Contact

Sort Within Category

Domain List?

Table Name

Field Name

Mapping

Comments

EDSC Data Standard

OrganizationDescription

HeaderThe particular word(s) regularly connected with a unique framework of authority within which a person or persons act, or are designated to act, towards some purpose.

Mandatory1 instance of OrganizationDescription for Organization

A designator used to uniquely identify a unique business establishment within a context.

Primary key for everything, unique on the planet, supplied by EPA upon application of trading partner.

WQX_OrganizationDescription_v1.0.xsd

ORGANIZATION

ORG_ID

The user-defined code that uniquely identifies an Organization. Organization IDs are registered centrally with STORET so that they are guaranteed to be unique on the

A designator used to uniquely identify a unique business establishment within a context.

OrganizationFormalName

The legal designator (i.e. formal name) of an organization.


ORGANIZATION

The formal full-length name of the Organization.

The legal designator (i.e. formal name) of an organization.

OrganizationDescriptionText

Information that further describes an organization.


ORGANIZATION

DESCRIPTION_TEXT

The text describing details of the Organization that users may wish to provide. For example, this text may be used to describe the purpose, mission, or goals of the Organization.

Business Decision: No corresponding element found in EDSC standards.

The code that represents the American Indian tribe or Alaskan Native entity.

From domain valuesstring max 3


TSMORGAN

TYPE_CODE

The code that describes the type of Organization.

Not exact match

The code that represents the American Indian tribe or Alaskan Native entity.

HeaderThis section allows for the description of many electronic addresses per owning Organization.

Optional;0 to many instances of ElectronicAddress allowed per Organization

A resource address, usually consisting of the access protocol, the domain name, and optionally, the path to a file or location.

Conditional (see business rule)

WQX_ElectronicAddress_v1.0.xsd

TSMEADDR

ADDRESS_TEXT

Text or codes which are used to specify an Electronic Address for an Organization or an individual.

A resource address, usually consisting of the access protocol, the domain name, and optionally, the path to a file or location.

ElectronicAddressTypeName

The name that describes the electronic address type.



Yes WQX_ElectronicAddress_v1.0.xsd

TSMEADDR

TYPE_CODE

The code designating the type of Electronic Address.

The name that describes the electronic address type.

HeaderThis section allows for the description of many telephone numbers per owning Organization.

Optional;0 to many instances of Telephonic allowed per Organization

The number that identifies a particular telephone connection.


TSMEADDR

ADDRESS_TEXT

Text or codes which are used to specify an Electronic Address for an Organization or an individual.

The number that identifies a particular telephone connection.

TelephoneNumberTypeName

The name that describes a telephone number type.



Yes TSMEADDR

TYPE_CODE

The code designating the type of Electronic Address.

The name that describes a telephone number type.

TelephoneExtensionNumberText

The number assigned within an organization to an individual telephone that extends the external telephone number.

No exact match found

TelephoneExtensionNumberText

The number assigned within an organization to an individual telephone that extends the external telephone number.

HeaderThis section allows for the description of up to three physical addresses for the owning Organization.

Optional;0 to 3 instances of OrganizationAddress allowed per OrganizationOnly one address of each type permitted

Categorizes an address as either location, shipping, or mailing address.



Yes WQX_OrganizationAddress_v1.0.xsd

TSMADDR

TYPE_CODE

The code designating the type of Address.


The address that describes the physical (geographic), shipping, or mailing location of an organization.


WQX_OrganizationAddress_v1.0.xsd

TSMADDR

LINE_ONE_TEXT AND LINE_TWO_TEXT

The first line of an Address which usually denotes the company or individual name.ANDThe second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also contain company name in addition.

Not exact match

MailingAddressText or LocationAddressText

"The exact address where a mail piece is intended to be delivered, including urban-style street address, rural route, and PO Box"or"The address that describes the physical (geographic) location of the front door or main entrance of a facility site, including urban-style street address or rural address."

Business Decision: WQX exchange did not want duplicate elements to track mailing and location addresses and thus combined them using an AddressType desgnator.

SupplementalAddressText

The text that provides additional information about an address, including a building name with its secondary unit and number, an industrial park name, an installation name or descriptive text where no formal address is available.


TSMADDR

LINE_TWO_TEXT and LINE_THREE_TEXT

The second line of an Address usually denotes the mail routing code, p.o. box number, or suite but can also contain company name in addition.ANDThe third line of an Address usually denotes the street address including street name and type, house/office number, or sector designation.

Not exact match

SupplementalAddressText or SupplementalLocationText

The text that provides additional information about a place, including a building name with its secondary unit and number, an industrial park name, an installation name or descriptive text where no formal address is available.OrThe text that provides additional information to facilitate the delivery of a mail piece, including building name, secondary units, and mail stop or local box numbers not serviced by the U.S. Postal Service.


The name of a city, town, village or other locality.


TSMADDR

LINE_FOUR_TEXT

The name of the city, state, and zip code in an Address.

Not exact match

MailingAddressCityName or LocalityName

The name of the city, town, or village where the mail is delivered.OrThe name of the city, town, village or other locality, when identifiable, within whose boundaries (the majority of) the facility site is located. This is not always the same as the city used for USPS mail delivery.


A code designator used to identify a principal administrative subdivision of the United States, Canada, or Mexico.



Yes WQX_OrganizationAddress_v1.0.xsd

TSMADDR

LINE_FOUR_TEXT


Not exact match

MailingAddressStateCode or LocationAddressStateCode



The combination of the 5-digit Zone Improvement Plan (ZIP) code and the four-digit extension code (if available) that represents the geographic segment that is a subunit of the ZIP Code, assigned by the U.S. Postal Service to a geographic location to facilitate mail delivery; or the postal zone specific to the country, other than the U.S., where the mail is delivered.


TSMADDR

LINE_FOUR_TEXT


Not exact match

MailingAddressPostalCode or LocationAddressPostalCode

The combination of the 5-digit Zone Improvement Plan (ZIP) code and the four-digit extension code (if available) that represents the geographic segment that is a subunit of the ZIP Code, assigned by the U.S. Postal Service to a geographic location to facilitate mail delivery; or the postal zone specific to the country, other than the U.S., where the mail is delivered.


ORG Organization Address 01.03.07 CountryCode Optional Yes Contact

ORG Organization Address 01.03.08 CountyCode Optional County codes must be reported using 3-digit FIPS codes. Yes Contact LocationAddressCountyCode

PROJECT PROJ Description 02.00.00 Header Project

PROJ Description 02.00.01 ProjectIdentifier Mandatory string max 35 WQX_Project_v1.0.xsd ESAR Project Identifier Compliant

PROJ Description 02.00.02 ProjectName Mandatory string max 120 WQX_Project_v1.0.xsd NAME ESAR Project Name Compliant

PROJ Description 02.00.03 ProjectDescriptionText Optional string max 1999 WQX_Project_v1.0.xsd ESAR

PROJ Binary Object 02.01.00 Header Optional

PROJ Binary Object 02.01.01 BinaryObjectFileName string max 255 ESAR - Binary BinaryObjectFileName Compliant

PROJ Binary Object 02.01.02 string max 6 ESAR - Binary BinaryObjectFileType Compliant

Monitoring Location Identity 03.00.00 Header

Monitoring Location Identity 03.00.01 Mandatory String max 35 ESAR Monitoring Location Identifier Compliant

Monitoring Location Identity 03.00.02 Mandatory string max 255 NAME ESAR MonitoringLocationName Compliant

Monitoring Location Identity 03.00.03 Mandatory ESAR MonitoringLocationTypeName Compliant

Monitoring Location Identity 03.00.04 Optional string max 1999 ESAR

Monitoring Location Identity 03.00.05 HUCEightDigitCode Optional string max 8

Monitoring Location Identity 03.00.06 HUCTwelveDigitCode Optional string max 12

Monitoring Location Identity 03.00.07 TribalLandIndicator Optional boolean Contact TribalLandIndicator Compliant

Monitoring Location Identity 03.00.08 TribalLandName Optional string max 200 Contact TribalLandName Compliant

Monitoring Location Identity 03.00.09

Monitoring Location Identity 03.00.09.01 String max 35 Required if AlternateMonitoringLocationIdentity is reported TSMERS NAME ESAR Monitoring Location Identifier Compliant

Monitoring Location Identity 03.00.09.02 String max 120 Required if AlternateMonitoringLocationIdentity is reported TSMERS ESAR Compliant

A code designator used to identify a primary geopolitical unit of the world.



TSMADDR

COUNTRY_CODE

The code for the country in an Address.

MailingAddressCountryCode or LocationAddressCountryCode



A code designator used to identify a U.S. county or county equivalent.






Header;This section allows for the description of Organization Projects.

Optional: 0 to many instances

A designator used to uniquely identify a data collection project within a context of an organization.

This short identifier supports the requirement to update or edit an existing project, subsequent to its initial entry, without repeating all of its component parts.

TSMPROJ

IDENTIFICATION_CD

The code (combination of text or numbers) used by the owning Organization to uniquely identify the Project or Survey

A designator used to uniquely identify the project to organizations sharing data.

The name assigned by the Organization (project leader or principal investigator) to the project.

TSMPROJ

The name assigned by the owning Organization to the Project or Survey.

The name assigned to the Project by the project leader or principal investigator.

Project description, which may include a description of the project purpose, summary of the objectives, or brief summary of the results of the project.

Must provide either ProjectDescriptionText or supply a Project Attached Binary Object.

TSMGNTXT

DESCRIPTION_TEXT

The specific text to be linked to the given table and field.

ProjectPurposeTextOR ProjectObjectiveText ORProjectOutcomeDescription

A summary description of thepurpose of, or the hypothesis to betested by the project.OR Summary of the objectives to be accomplished by the project.OR A brief summary of the results ofthe project.

Business Decision: Data standard breaks out to further detail than desired for WQX sharing.

ProjectAttachedBinaryObject

Header;This section allows for the association of References and electronic attachments to the project, including formal Project Plan and any other documents, images, maps, photos, laboratory materials, geospatial coverages, and other objects associated with the Project..

Multiple instances of ProjectAttachedBinaryObject per Organization instance.

The text describing the descriptive name used to represent the file, including file extension.


Required only when ProjectAttachedBinaryObject is reported.Must provide either ProjectDescriptionText or supply a Project Attached Binary Object.

WQX_AttachedBinaryObject_v1.0.xsd

TSMPROJ

BLOB_TITLE

User-defined Title of the BLOB Content.


BinaryObjectFileTypeCode

The text or acronym describing the binary content type of a file.


File text extension, free text not domain list validation.

Required only when ProjectAttachedBinaryObject is reported.


TSMPROJ

BLOB_TYPE

File types permitted for BLOB content. BLOBs (Binary Large Objects) are typically entire files whos content extends and further defines the Project. A single BLOB of type PDF might contain the complete project design specification as published by the projectmanager.


MONITORING LOCATION

MonitoringLocationIdentity

HeaderThis section allows the owning Organization to describe monitoring locations.

Conditional: 0 to many instances

Monitoring Location Identity block is required for certain Activity Types.

MonitoringLocationIdentifier

A designator used to describe the unique name, number, or code assigned to identify the monitoring location.

This short identifier supports the requirement to update or edit an existing station, subsequent to its initial entry, without repeating all of its component parts.

WQX_MonitoringLocationIdentity_v1.0.xsd

TSMSTATN

IDENTIFICATION_CD

The alpha-numeric code assigned by the owning Organization which uniquely identifies the Station within the Organization.

A designator used to uniquely identify the Monitoring Location.

MonitoringLocationName

The designator specified by the sampling organization for the site at which sampling or other activities are conducted.

Free text name assigned to the Monitoring Location by the Trading Partner.


TSMSTATN

The name by which an Organization refers to a Station.

The designator specified by the sampling organization for the site at which sampling or other activities are conducted.

MonitoringLocationTypeName

The descriptive name for a type of monitoring location.


Yes WQX_MonitoringLocationIdentity_v1.0.xsd

TSMSTATN

TSMVSTC_IS_NUMBER

Primary / Secondary Station Combination…The foreign key to TSMVSTC implements "One Valid Station Type Code Combination may be assigned to many Stations."


The descriptive name for a type of monitoring location.

MonitoringLocationDescriptionText

Text description of the monitoring location.


TSMSTATN

DESCRIPTION_TEXT

The Organization user-defined description of a Station. May include distance to left shore or right shore to the Station.

MonitoringLocationDescriptionText

Text description of the location of the monitoring location.

Compliant (uses EN Shared Schema Component definition)

The 8 digit federal code used to identify the hydrologic unit of the monitoring location to the cataloging unit level of precision.



The 12 digit federal code used to identify the hydrologic unit of the monitoring location to the subwatershed level of precision.



An indicator denoting whether the location is on a tribal land.


An indicator denoting whether the location is on a tribal land.

The name of an American Indian or Alaskan native area where the location exists.


The name of an American Indian or Alaskan native area where the location exists.

AlternateMonitoringLocationIdentity

Alternate identifications of a monitoring location.

Optional; may have 0 to many for each instance of Monitoring Location




WQX_AlternateMonitoringLocationIdentity_v1.0.xsd

The name of the external reference scheme in which the Station participates.

A designator used to uniquely identify the Monitoring Location.

MonitoringLocationIdentifierContext

Identifies the source or data system that created or defined the monitoring location identifier


WQX_AlternateMonitoringLocationIdentity_v1.0.xsd

ACRONYM

The abbreviation or acronym by which this scheme is commonly known. For example, if the reference is to the National Pollution Discharge Elimination System the acronym is NPDES.

Monitoring Location Identifier Context

Monitoring Location Geospatial 03.01.00 Header Only 1 instance allowed per Monitoring Location instance

Monitoring Location Geospatial 03.01.01 LatitudeMeasure Mandatory Decimal 6-8 digits TSMALP Lat/Long LatitudeMeasure Compliant

Monitoring Location Geospatial 03.01.02 LongitudeMeasure Mandatory Decimal 6-9 digits TSMALP Lat/Long LongitudeMeasure Compliant

Monitoring Location Geospatial 03.01.03 non Negative Integer TSMALP Lat/Long SourceMapScaleNumeric Compliant

Monitoring Location Geospatial 03.01.04 Mandatory TSMALP Lat/Long Compliant

Monitoring Location Geospatial 03.01.05 Mandatory TSMALP Lat/Long Compliant

Monitoring Location Geospatial 03.01.06 VerticalMeasure

Monitoring Location Geospatial 03.01.06.01 MeasureValue Optional string max 12 Required if VerticalMeasure block is reported TSMALP Lat/Long Compliant

Monitoring Location Geospatial 03.01.06.02 MeasureUnitCode Required if VerticalMeasure block is reported TSMALP Measure Compliant

Monitoring Location Geospatial 03.01.07 Required if Vertical Measure/MeasureValue is supplied TSMALP Lat/Long VerticalCollectionMethodName Compliant

Monitoring Location Geospatial 03.01.08 Required if Vertical Measure/MeasureValue is supplied TSMALP Lat/Long Compliant

Monitoring Location Geospatial 03.01.09 CountryCode A code designator Optional TSMALP Contact

Monitoring Location Geospatial 03.01.10 StateCode Required if Monitoring Location CountyCode is reported. TSMALP Contact

Monitoring Location Geospatial 03.01.11 CountyCode Optional County codes must be reported using 3-digit FIPS codes. TSMALP Contact LocationAddressCountyCode

03.02.00 Header AttachedBinaryObject

03.02.01 BinaryObjectFileName string max 255 ESAR - Binary BinaryObjectFileName Compliant

03.02.02 string max 6 ESAR - Binary BinaryObjectFileType Compliant

04.00.00 Header Activity

04.00.01 ActivityIdentifier Mandatory string max 35 ESAR Field Activity Identifier

MonitoringLocationGeospatial

Header;This section allows for the geospatial description of a monitoring station. This section records the location in 3 dimensions.

Mandatory;one and only one allowed per instance of Monitoring Location.

The measure of the angular distance on a meridian north or south of the equator.

Signed Decimal Latitude with positive values north of the Equator

WQX_MonitoringLocationGeospatial_v1.0.xsd

LAT_DEC_DEG_MSR

The measure of latitude in decimal degrees (- 90.0 to 90.0), indicating angular distance North or South of the equator.

other alternative fields (LAT_DEGREE


The measure of the angular distance on a meridian east or west of the prime meridian.

Signed Decimal Longitude with neg values west of Greenwich


LONG_DEC_DEG_MSR

The measure of longitude in decimal degrees (- 180.0 to 180.0) indicating angular distance west or east of the prime meridian.

other alternative fields (GPS_L


SourceMapScaleNumeric

The number that represents the proportional distance on the ground for one unit of measure on the map or photo.


Mandatory only when HorizonitalCollectionMethod Code is "INTERPOLATION MAP"


GEOPSTNG_SCALE_TXT

The text that describes the Geopositioning Scale of a map. Example: 1:1000. NOTE: When GEOPOSITIONING METHOD = 'MAP' this attribute is mandatory, and the map scale (in part) determines the expected accuracy of the latitude/longitude.


HorizontalCollectionMethodName

The name that identifies the method used to determine the latitude and longitude coordinates for a point on the earth.


Valid code values correspond to those enumerated for this data element in the FRS XML schema.

Yes WQX_MonitoringLocationGeospatial_v1.0.xsd

GEOPSTNG_METHOD_CD

The code that represents the method used to determine geographic coordinates of a locational point.



HorizontalCoordinateReferenceSystemDatumName

The name that describes the reference datum used in determining latitude and longitude coordinates.


Valid code values correspond to those enumerated for this data element in the FRS XML schema.


GEOPSTNG_DATUM_CD

The code that represents an acknowledged standard reference scheme of known coordinates from which calculations or measurements may be taken.



Header;The measure of elevation (i.e., the altitude), above or below a reference datum.

Optional;Up to one allowed per instance of MonitoringLocationGeospatial

The recorded dimension, capacity, quality, or amount of something ascertained by measuring or observing.

WQX_MeasureCompact_v1.0.xsd

ELEVATION_MSR

The measure in feet or meters from the reference datum to the point of interest.

VerticalMeasure / MeasureValue


The code that represents the unit for measuring the item.


From domain values (MeasureUnitCode)string max 12

Yes WQX_MeasureCompact_v1.0.xsd

ELVTN_UNT_CD

The code that represents the name of the units associated with the ground elevation of a locational point on the earth's surface.

VerticalMeasure / MeasureUnitCode


VerticalCollectionMethodName

The name that identifies the method used to collect the vertical measure (i.e. the altitude) of a reference point.




ELVTN_METHOD_CD

The code that represents the method used to determine elevation of a point of interest.

The name that identifies the method used to collect the vertical measure (i.e. the altitude) of a reference point.

VerticalCoordinateReferenceSystemDatumName

The name of the reference datum used to determine the vertical measure (i.e., the altitude).




ELEVATION_DATUM_CD

A permanently established horizontal plane, surface, or level to which soundings, ground elevations, depths, water surface elevations, and tidal data are referred.

VerticalCoordinateReferenceSystemDatumName

The name of the reference datum used to determine the vertical measure (i.e., the altitude).




TSMGEOPA0ORG_ID

The TSMORGAN portion of the foreign key to TSMGEOPA

Valid values are stored in table TSMGEOPA.

MailingAddressCountryCode or LocationAddressCountryCode


Business Decision: No direct link found in ESAR-Monitoring location, so definitions pulled from Contact standard.





TSMGEOPA0ORG_ID



MailingAddressStateCode or LocationAddressStateCode






TSMGEOPA0ORG_ID





Monitoring Location Binary Object

Header;This section allows for the association of References and electronic attachments to the Monitoring Location description including any other documents, images, maps, photos, laboratory materials, geospatial coverages, and other objects associated with the Project.

Optional; may have 0 to many for each instance of Monitoring Location

Multiple instances of StationAttachedBinaryObject per Monitoring Location instance




Required if Monitoring Location AttachedBinaryObject present


TSMPROJ

BLOB_TITLE







Required if Monitoring Location AttachedBinaryObject present


TSMPROJ

BLOB_TYPE



MONITORING ACTIVITY

ACTIVITY Description

Header;This section allows for the reporting of monitoring activities conducted at a Monitoring Location

OptionalMay have 0 to many for each instance of Organization


Designator that uniquely identifies an activity within an organization.

This short identifier supports the requirement to update or edit an existing activity, subsequent to its initial entry, without repeating all of its component parts.

WQX_ActivityDescription_v1.0.xsd

TSRFDACT

ID_CODE

The Organization-assigned alphanumeric code that identifies a Field Activity, sometimes called Sample ID. The combination of Activity/Sample ID and Replicate Number must be unique among all samples collected during all station visits conducted during any oneTrip.

A designator used to uniquely identify a field activity within a context.

Business Decision: WQX needed more generic term to incorporate non-field related activities.

04.00.02 ActivityTypeCode Mandatory ESAR Field Activity Type

04.00.03 ActivityMediaName Mandatory ESAR Sample Media Name

04.00.04 Optional ESAR

04.00.05 ActivityStartDate Mandatory ESAR Field Activity Start Date

04.00.06 ActivityStartTime Optional

04.00.06.01 Time Required only when ActivityStartTime is reported WQX_WQXTime_v1.0.xsd ESAR Field Activity Start Time

04.00.06.02 TimeZoneCode string max 4 Required only when ActivityStartTime is reported Yes WQX_WQXTime_v1.0.xsd

04.00.07 ActivityEndDate Optional Date that the Field Activity ended. ESAR Field Activity End Date

04.00.08 ActivityEndTime Optional

04.00.08.01 Time Required only when ActivityEndTime is reported WQX_WQXTime_v1.0.xsd Time that the Field Activity ended. ESAR Field Activity End Time

04.00.08.02 TimeZoneCode string max 4 Required only when ActivityEndTime is reported Yes WQX_WQXTime_v1.0.xsd

04.00.09 Optional string max 15 Yes

04.00.10

04.00.10.01 MeasureValue Optional string max 12 Required if ActivityDepthHeightMeasure block is reported. ESAR

04.00.10.02 MeasureUnitCode Optional string max 12 Required if ActivityDepthHeightMeasure block is reported. Yes ESAR

04.00.11

04.00.11.01 MeasureValue Optional string max 12 ESAR

04.00.11.02 MeasureUnitCode Optional string max 12 Yes ESAR


The text describing the type of activity.


Yes WQX_ActivityDescription_v1.0.xsd

TSRFDACT

CATEGORY_TYPE_NAME

A descriptor used to distinguish different kinds of samples and different kinds of Measurements & Observations. The permittedvalue list is controlled by the choice of TYPE_NAME (above), with the entries in TSMPRMVL for CATEGORY_TYPE_NAME_M used for activities of type Msr/Obs, while CATEGORY_TYPE_NAME_S is used for activities of type Sample.

The text describing the type of field activity being performed

Business Decision: WQX needed more generic term to incorporate non-field related activities.


Name or code indicating the environmental medium where the sample was taken.



TSRFDACT

MEDIUM_TYPE_NAME

The name of the medium or matrix where the Field Activity occurred.

Name or code indicating the environmental medium where the sample was taken.

Business Decision: The team needed to use this field for potentially more than sample collection, so broader term was used.


ActivityMediaSubDivisionName

Name or code indicating the environmental matrix as a subdivision of the sample media.




Sample Media Subdivision Name

Name or code indicating the environmental matrix as a subdivision of the sample media.

Business Decision: The team needed to use this field for potentially more than sample collection, so broader term was used.


The calendar date on which the field activity was started.

Date(YYYY-MM-DD)


TSRFDACT

START_DATE

For Samples Collected or for Measurements/Observations made - the date that the Field Activity began. For Samples Createdfrom other samples - the date on which a sample is created by compositing, splitting, or subsampling from a parent sample.

The starting date that a field activity was started.

Business Decision: The team needed to use this field for more than just field activities, so broader term was used.


The measure of clock time when the field activity began.


The time of day that is reported.

Conditional (see business rules)

Time - (hh:mm:ss)

TSRFDACT

START_TIME

For Samples Collected or for Measurements/Observations made - the time that the Field Activity began. For Samples Created from other samples - the time at which a sample is created by compositing, splitting, or subsampling from a parent sample.

The starting time that a field activity was started.



The time zone for which the time of day is reported. Any of the longitudinal divisions of the earth's surface in which a standard time is kept.


TSRFDACT

START_TIME_ZONE

Any of the longitudinal divisions of the earth's surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately to the east.



The calendar date when the field activity was completed.

Date(YYYY-MM-DD)


TSRFDACT

STOP_DATE

The ending date that a field activity was finished.



The measure of clock time when the field activity ended.




Time - (hh:mm:ss)

TSRFDACT

STOP_TIME

The ending time that a field activity was finished.





TSRFDACT

STOP_TIME_ZONE

Any of the longitudinal divisions of the earth's surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately to the east.



ActivityRelativeDepthName

The name that indicates the approximate location within the water column at which the activity occurred.


TSRFDACT

RELTV_DEPTH_NAME

The name that indicates the approximate location within the water column at which the activity occurred.



ActivityDepthHeightMeasure

Header;A measurement of the vertical location (measured from a reference point) at which an activity occurred.

Optional (see business rules);Up to one allowed per instance of ActivityDescription

Optional;May not exist with ActivityTopDepthHeightMeasureValue




TSRFDACT

DEPTH_TO_ACTIVITY

Distance from the surface to the point in the water column at which the activity is conducted.

SampleEventDepthHeightMeasure/MeasureValue


Business Decision: Team used term Activity over SampleEvent to make usage more generic.




SampleEventDepthHeightMeasure/MeasureUnitCode




ActivityTopDepthHeightMeasure

Header;A measurement of the upper vertical location of a vertical location range (measured from a reference point) at which an activity occurred.

Conditional (see business rules);Up to one allowed per instance of ActivityDescription

Conditional: May not exist with ActivityDepthHeightMeasureValue.Requied if activity type is Sample-Integrated Vertical Profile



Required if ActivityTopDepthHeightMeasure block is reported.


TSRFDACT

UPPER_DEPTH_TO_ACT

This measure is associated with an activity that is normally conducted over or within a vertical depth range within 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.

SampleEventTopDepthHeightMeasure/MeasureValue





Required if ActivityTopDepthHeightMeasure block is reported.


SampleEventTopDepthHeightMeasure/MeasureUnitCode



04.00.12

04.00.12.01 MeasureValue Optional string max 12 ESAR

04.00.12.02 MeasureUnitCode Optional string max 12 Yes ESAR

04.00.13 Optional string max 125 ESAR

04.00.14 ProjectIdentifier Mandatory string max 35 Multiple instances possible for each Activity instance

04.00.15 Optional string max 120

04.00.16 String max 35

04.00.17 ActivityCommentText Optional String max 4000

04.01.00 Header ActivityLocation Only 1 instance allowed per Sample instance

04.01.01 LatitudeMeasure Decimal 6-8 digits TSMALP Lat/Long LatitudeMeasure

04.01.02 LongitudeMeasure Decimal 6-9 digits TSMALP Lat/Long LongitudeMeasure

04.01.03 non Negative Integer TSMALP Lat/Long SourceMapScaleNumeric

04.01.04 TSMALP Lat/Long

04.01.05 TSMALP Lat/Long

04.02.00 Header SAMPLE Description


ActivityBottomDepthHeightMeasure

Header;A measurement of the lower vertical location of a vertical location range (measured from a reference point) at which an activity occurred.

Conditional (see business rules);Up to one allowed per instance of ActivityDescription

Conditional:May not exist with ActivityDepthHeightMeasureValue.Requied if activity type is Sample-Integrated Vertical Profile



Required if ActivityBottomDepthHeightMeasure block is reported.


TSRFDACT

LOWER_DEPTH_TO_ACT

This measure is associated with an activity that is normally conducted over or within a vertical depth range within 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.

SampleEventBottomDepthHeightMeasure/MeasureValue





Required if ActivityBottomDepthHeightMeasure block is reported.


SampleEventTopDepthHeightMeasure/MeasureUnitCode




ActivityDepthAltitudeReferencePointText

The reference used to indicate the datum or reference used to establish the depth/altitude of an activity.


TSRFDACT

DEPTH_REF_POINT

The text that describes the reference point from which the depth is measured, typically "Surface".

SampleEventDepthAltitudeReferencePointText

The reference used to indicate the datum or reference used to establish the depth/altitude of collection.



A designator used to uniquely identify a data collection project within a context of an organization.


TSRFAPRA

TSMPROJ_IS_NUMBER

The foreign key to TSMPROJ implements "One Project may be supported by many Field Activities."

Business Decision: This is a linkage element; No corresponding element found in EDSC standards at this level of hierarchy.


ActivityConductingOrganizationText

A name of the Organization conducting an activity.

Multiple instances possible for each Monitoring Activity instance


TSRFDACT

TSRFDACT_ORG_ID

The user-defined code that uniquely identifies the Organization to which each occurrence of this table applies. This identifying attributehas been added to this table for purposes of application security. Security is driven by user access to a given Organization(s).

NOT EXACT MATCH






Although the schema doesn't enforce this, some activity types will require that a monitoring location is present.

This MonitoringLocationIdentifer needs to correspond to either a MonitoringLocationIdentifier reported in the MonitoringLocationIdentity block of this submission or previously submitted to the system.




General comments concerning the activity.


TSRFDACT

COMMENT_TEXT

Free text comments usually originating from members of the field crew regarding the Field Activity.

Business Decision: The team chose ActivityComments since the term is more generic and also to be consistent with the use of the term “Comments’ in other areas of the schema.

ACTIVITYLocation

Header;This section allows for the geospatial description of actual monitoring site, if it is different from that described for in the formal station description.

Optional;defaults to Station Lat/Long reported in the formal Station Description if not present

ACTIVITYLocation



Signed Decimal Latitude with positive values north of the Equator.Required if ActivityLocation is supplied.

WQX_ActivityLocation_v1.0.xsd

LAT_DEC_DEG_MSR

The measure of latitude in decimal degrees (- 90.0 to 90.0), indicating angular distance North or South of the equator.

other alternative fields (LAT_DEGREE_MSR, GPS_LAT_DEGREE_MSR exist)


Compliant (ESAR has no geospatial elements tracked at activity level. Element mapping from Lat/Long standard used.)

ACTIVITYLocation



Signed Decimal Longitude with neg values west of GreenwichRequired if ActivityLocation is supplied.


LONG_DEC_DEG_MSR

The measure of longitude in decimal degrees (- 180.0 to 180.0) indicating angular distance west or east of the prime meridian.

other alternative fields (GPS_LONG_DEGREE_MSR exist)



ACTIVITYLocation

SourceMapScaleNumeric



Mandatory only when HorizonitalCollectionMethod Code is "INTERPOLATION MAP"


GEOPSTNG_SCALE_TXT

The text that describes the Geopositioning Scale of a map. Example: 1:1000. NOTE: When GEOPOSITIONING METHOD = 'MAP' this attribute is mandatory, and the map scale (in part) determines the expected accuracy of the latitude/longitude.



ACTIVITYLocation





Valid code values correspond to those enumerated for this data element in the FRS XML schema.Required if ActivityLocation is supplied.

Yes WQX_ActivityLocation_v1.0.xsd

GEOPSTNG_METHOD_CD

The code that represents the method used to determine geographic coordinates of a locational point.




ACTIVITYLocation





Valid code values correspond to those enumerated for this data element in the FRS XML schema.Required if ActivityLocation is supplied.

Yes WQX_ActivityLocation_v1.0.xsd

GEOPSTNG_DATUM_CD

The code that represents an acknowledged standard reference scheme of known coordinates from which calculations or measurements may be taken.

HorizontalCoordinateReferenceSystemDatumName or Code

The code that represents the reference datum used in determining latitude and longitude coordinates.


SAMPLE Description

Header;header in schema for Sample only

Optional May have 0 to 1 for each instance of Activity

Several elements are required when SampleDescription block is reported (see below)

04.02.01 ESAR Compliant

04.02.01.01 MethodIdentifier String max 20 Required when SampleCollectionMethod is present. ESAR / Method Compliant

04.02.01.02 String max 120 Required when SampleCollectionMethod is present. ESAR / Method Compliant

04.02.01.03 MethodName String max 120 Required when SampleCollectionMethod is present. ESAR / Method Compliant

04.02.01.04 Optional string max 25 ESAR / Method Compliant

04.02.01.05 MethodDescriptionText Optional string max 500 ESAR / Method Compliant

04.02.02

04.02.03 NAME

04.02.04 Required when SampleCollectionMethod is present. ESAR

04.02.05 Optional String max 4000 ESAR

SAMPLE Prep 04.03.00 Header SamplePreparation

SAMPLE Prep 04.03.01 Required if Sample Preparation block is reported NAME ESAR Sample Preparation Method Compliant

SAMPLE Prep 04.03.01.01 MethodIdentifier string max 20 Required if Sample Preparation Method block is reported. ESAR - Method Compliant

SAMPLE Prep 04.03.01.02 string max 120 Required if Sample Preparation Method block is reported. ESAR - Method Compliant

SAMPLE Prep 04.03.01.03 MethodName string max 120 Required if Sample Preparation Method block is reported. ESAR - Method Compliant

SAMPLE Prep 04.03.01.04 Optional string max 25 ESAR - Method Compliant

SAMPLE Prep 04.03.01.05 MethodDescriptionText Optional string max 500 ESAR - Method Compliant

SAMPLE Prep 04.03.02 Required if Sample Preparation block is reported ESAR SampleContainerTypeName Compliant

SAMPLE Prep 04.03.03 Required if Sample Preparation block is reported ESAR SampleContainerColorName Compliant

SAMPLE Prep 04.03.04 string max 250 Compliant

SAMPLE Prep 04.03.05 Compliant

SAMPLE Prep 04.03.06 string max 250 Required if Sample Preparation block is reported

Activity Binary Object 04.04.00 Header

Activity Binary Object 04.04.01 BinaryObjectFileName string max 255 Required if ActivityAttachedBinaryObject present ESAR - Binary BinaryObjectFileName Compliant

SAMPLE Description

SampleCollectionMethod

Header:Identifies sample collection or measurement method procedures. Where a documented sample collection method has been employed, this enables the data provider to indicate the documented method that was employed during the field sample collection. Otherwise, the sample collection procedure will best be described in a freeform text.


Conditional:Required if Sample Description block is reported.Required if Activity Type contains the term 'Sample'

Field Sample Collection Method

Identifies sample collection or measurement method procedures.

SAMPLE Description

The identification number or code assigned by the method publisher.


WQX_ReferenceMethod_v1.0.xsd

Field Sample Collection Method / Method Identifier


SAMPLE Description

MethodIdentifierContext

Identifies the source or data system that created or defined the identifier.



Field Sample Collection Method / Method Identifier (metadata)


SAMPLE Description

The title that appears on the method from the method publisher.



TSRFLDPR

DESCRIPTION_TEXT

A long description that provides further information about the Field Sampling Procedure.

Field Sample Collection Method / Method Name

Identifying information about the method(s) followed to prepare a sample for analysis.

SAMPLE Description

MethodQualifierTypeName

Identifier of type of method that identifies it as reference, equivalent, or other.


Field Sample Collection Method / MethodQualifierType


SAMPLE Description

A brief summary that provides general information about the method.


Sample Preparation Method / MethodDescriptionText


SAMPLE Description

SampleTissueTaxonomicName

The name of the organism from which a tissue sample was taken.



Required if Activity Media Text is 'Biological Tissue'. Mandatory if SampleTissueTaxonomicName is present.

Yes WQX_SampleDescription_v1.0.xsd

TSRFDACT

TSRCHAR_IS_NUMBER

The foreign key to TSRCHAR implements "One Taxon Characteristic may be the Subject Taxon for many Field Activities whose medium isbiological and whose intent is Individual or Tissue.

foreign key


SAMPLE Description

SampleTissueAnatomyName

The name of the anatomy from which a tissue sample was taken.



Required if Activity Media Text is 'Biological Tissue'. Mandatory if SampleTissueTaxonomicName is present.


TSRBIOPT

The usual anatomical term which identifies the portion of an organism to be analyzed.

Linked via TSRBIOPT_IS_NUMBER in TSRFDACT


SAMPLE Description

SampleCollectionEquipmentName

The name that represents equipment used in collecting the sample.




TSRFLDGR

ID_CODE

An Organization-assigned cryptic ID Code that identifies a specific instance of Field Gear. Note: One Field Gear may have many GearConfigurations. Used as a shorthand or abbreviation to represent the Field Gear in batch data update runs.

Linked via TSRFLDGR_IS_NUMBER in

FieldActivityEquipment / EquipmentName

A designator used to uniquely identify the instrument or equipment used for the activity.

Business Decision: Team used term Sampling over FieldActivity to make usage more specific.

SAMPLE Description

SampleCollectionEquipmentCommentText

Free text with general comments further describing the sample collection equipment.

WQX_SampleDescription_v1.0.xsd

FieldActivityEquipment / EquipmentDescription

Description of instrument or equipment or configuration used for the activity.

Business Decision: Team used term Sampling over FieldActivity to make usage more specific.

HeaderThis section describes a sample preparation procedure which may be conducted on an initial Sample or on subsequent subsamples.

OptionalMay have 0 to 1 for each instance of Activity

SamplePreparationMethod

HeaderIdentifying information about the method(s) followed to prepare a sample for analysis.


TSRLSPP

The long name of the Sample Preparation Procedure.





SamplePreparationMethod / MethodIdentifier






SamplePreparationMethod / MethodIdentifier Context (meta data)





SamplePreparationMethod / MethodName





SamplePreparationMethod / MethodQualifierType




SamplePreparationMethod / MethodDescriptionText


SampleContainerTypeName

The text describing the sample container type.



Yes WQX_SamplePreparation_v1.0.xsd

TSRSMPLE (or TSRFQS)

CONTAINER_TYPE_NM

The name of the style and material of the container which is used to collect and transport the sample.

Multiple map destinations

The text describing the sample container type.

SampleContainerColorName

The text describing the sample container color.




TSRSMPLE (or TSRFQS)

CONTAINER_COLOR

The color of the container which is used to collect and transport the sample.

Multiple map destinations

The text describing the sample container color.

ChemicalPreservativeUsedName

Information describing the chemical means to preserve the sample.


Either ChemicalPreservativeUsedName or ThermalPreservativeUsedName are required if Sample Preparation block is reported

WQX_SamplePreparation_v1.0.xsd

TSRSMPLE

PRESRV_STRGE_PRCDR

Free text description providing additional information about the preservation and storage of the sample.

NOT EXACT MATCH

ESAR - Sample Treatment

ChemicalPreservativeUsedName

Information describing the chemical means to preserve the sample.

ThermalPreservativeUsedName

Information describing the temperature means used to preserve the sample.



Either ChemicalPreservativeUsedName or ThermalPreservativeUsedName are required if Sample Preparation block is reported


TSRSMPLE

TEMP_PRESERVN_TYPE

A default for the name of the type of temperature based physical preservation.

ESAR - Sample Treatment

ThermalPreservativeUsedName

Information describing the temperature means used to preserve the sample.

SampleTransportStorageDescription

The text describing sample handling and transport procedures used.


WQX_SamplePreparation_v1.0.xsd

TSRSMPLE

TRANSPORT_STORAGE

Free text description providing additional information about the handling, transport, and storage of the sample.


ActivityAttachedBinaryObject

Header;This section allows for the association of References and electronic attachments to the Activity description including any other documents, images, maps, photos, laboratory materials, geospatial coverages, and other objects associated with the Project..

Optional; may have 0 can have many per instance of Activity.

Multiple instances of SampleAttachedBinaryObject per Sample instance




TSMPROJ

BLOB_TITLE



Activity Binary Object 04.04.02 string max 6 Required if ActivityAttachedBinaryObject present ESAR - Binary BinaryObjectFileType Compliant

Activity 04.05.01 ResultCount Optional string WQX_Activity_v1.0.xsd

RESULT Result Description 05.00.00 Header Result

Result Description 05.00.01 DataLoggerLineName string max 15 TSRDLIN

Result Description 05.00.02

Result Description 05.00.03 CharacteristicName Required if ResultValue/ValueMeasure is reported ESAR Substance Identifier

Result Description 05.00.04 Required for certain characteristics. ESAR Result Basis Name

Result Description 05.00.05 ResultMeasure

Result Description 05.00.05.01 ResultMeasureValue String max 60 WQX_Measure_v1.0.xsd Compliant

Result Description 05.00.05.02 MeasureUnitCode WQX_Measure_v1.0.xsd Compliant

Result Description 05.00.05.03 MeasureQualifierCode Optional Yes WQX_Measure_v1.0.xsd Compliant

Result Description 05.00.06 ResultStatusIdentifier Required if result is reported. ESAR Result Status Identifier Compliant

Result Description 05.00.07 StatisticalBaseCode Optional ESAR StatisticalBaseCode Compliant

Result Description 05.00.08 ResultValueTypeName Required if result is non text, Default is actual.

Result Description 05.00.09 ResultWeightBasisText Optional ESAR





TSMPROJ

BLOB_TYPE



Identifies the number of result records that exist for a particular activity.

This element is optional and is used for WQX outbound services; WQX submitters are not expected to provide this ResultCount element.


Header;This section describes the results of a field measurement, observation, or laboratory analysis.

Optional; Each instance of Activity may have 0 to many results allowed

The unique line identifier from a data logger result text file, normally a date/time format but could be any user defined name, e.g. "surface", "midwinter", and or "bottom".)


Required when Activity Type contains phrase "Data Logger". Must be unique within Activity.

WQX_ResultDescription_v1.0.xsd

LINE_NUMBER

The mandatory, user-assigned number representing a single recording event during the deployment of a hand-held data logger.


ResultDetectionConditionText

The textual descriptor of a result.

Conditional:(see business rule)


Required if "ResultValue/ValueMeasure" is blank. Detection condition explains why there is no result measure value.

Yes WQX_ResultDescription_v1.0.xsd

TSRRSULT

DETECT_COND_CD

The text indicating whether a characteristic was detected, and if it was detected whether or not it was in a range which permitted it tobe quantified.


The object, property, or substance which is evaluated or enumerated by either a direct field measurement, a direct field observation, or by laboratory analysis of material collected in the field.




TSRRSULT

TSRCHAR_IS_NUMBER

The foreign key to TSRCHAR implements "One Characteristic may be the thing measured or reported for many results."

foreign key

A designator used to uniquely identify a substance.

Business Decision: The team gave this much consideration and felt that CharacteristicName was a more appropriate term since non-substance related field assessment characteristics could be included.

ResultSampleFractionText

The text name of the portion of the sample associated with results obtained from a physically-partitioned sample.




TSRRSULT

SMPL_FRAC_TYPE_NM

Description: The text name of the portion of the sample associated with results obtained from a physically-partitioned sample. Examples: - dissolved - suspended - tot

The basis upon which the results were Calculated, within the Result Basis Category.

Business Decision: Instead of breaking these out individually, ESAR uses the generic Result Basis Category and Result Basis Name, which could be repeated. The team felt that separating out to specific Weight, Time, Temperature, etc elements would be more easily understood by the reporting community.

Header;The reportable measure of the result for chemical, microbiological, or other characteristics being analyzed.

Conditional (see business rules);Up to one allowed per instance of ResultDescription

Required if Detection Condition is blank. No entry is allowed here if there is an entry in the ResultDectionConditionText

The reportable measure of the result for the chemical, microbiological or other characteristic being analyzed.


Required if Detection Condition is blank. No entry is allowed here if there is an entry in the ResultDectionConditionText.

ResultValueMeasure must match a domain list value if the CharacteristicName ends with the phrase 'Choice List'

Conditional (see note)

TSRRSULT

VALUE_MEASURE

The numeric representation of the result of analyzing a Characteristic with an Analytical Procedure. Note: This value will be determined by converting the text values from Value Text. This conversion to numeric is always attempted during data entry, and when successful, its result is placed in this field.

ESAR / Measure

Result Value Measure / Measure Value


The code that represents the unit for measuring the chemical substance, microbiological substance or other characteristic.


From domain valuesstring max 12(Measure Unit Code)

Required if a non text result is reported; can also be reported for non-numeric results.

Yes TSRRSULT

TSRUOM_IS_NUMBER

The foreign key to TSRUOM implements "One Unit of Measure may apply to many Results."

foreign key

ESAR / Measure

Result Value Measure / Measure Unit Code


A code used to identify any qualifying issues that affect the results.


ESAR / Measure

Result Value Measure / Measure Qualifier Code

A code used to identify any qualifying issues that affect the results.

Indicates acceptability of the result with respect to QA/QC criteria.




TSRRSULT

VALUE_STATUS

Result value is either Preliminary or Final. This attribute will be used for query purposes. Values marked as Preliminary are not displayed for public access on STORET Internet sites.

Indicates the acceptability of the result with respect to QA/QC criteria.

The code for the method used to calculate derived results.



TSRRSULT

STATISTIC_TYPE_NM

A statistic or calculation type which describes the reported result (e.g., average, mode, median, MPN).

Identifier or code for the method used to calculate derived results.

A name that qualifies the process which was used in the determination of the result value (e.g., actual, estimated, calculated).




TSRRSULT

VALUE_TYPE_NAME

A name that represents the process which was used in the determination of the result value(e.g., actual, estimated, calculated).


The name that represents the form of the sample or portion of the sample which is associated with the result value (e.g., wet weight, dry weight, ash-free dry weight).



TSRRSULT

WT_BASIS_TYPE_NM

The name that represents the form of the sample or portion of the sample which is associated with the result value (e.g., wet weight, dry weight, ash-free dry weight).

Result Basis CategoryandResult Basis Name

ESAR uses these two fields to capture multiple basis types.


Result Description 05.00.10 ResultTimeBasisText Optional ESAR

Result Description 05.00.11 Optional ESAR

Result Description 05.00.12 Optional string max 15 TSRRCI ESAR

Result Description DataQuality

Result Description 05.00.13.01 PrecisionValue Optional string max 60 PrecisionValue Compliant

Result Description 05.00.13.02 BiasValue Optional String max 60 BIAS ESAR BiasValue Compliant

Result Description 05.00.13.03 Optional String max 15 ESAR ConfidenceIntervalValue Compliant

Result Description 05.00.13.04 Optional String max 15 ESAR UpperConfidenceLimitValue Compliant

Result Description 05.00.13.05 Optional String max 15 ESAR LowerConfidenceLimitValue Compliant

Result Description 05.00.14 ResultCommentText Optional string max 4000 Comments made about the result. ESAR Substance Analysis Comments

Result Description 05.00.15

Result Description 05.00.15.01 MeasureValue Optional string max 12 Required if ResultDepthHeightMeasure block is reported.

Result Description 05.00.15.02 MeasureUnitCode Optional string max 12 Required if ResultDepthHeightMeasure block is reported. Yes

Result Description 05.00.16 Optional string max 125

Result Binary Object 05.01.00 Header

Result Binary Object 05.01.01 BinaryObjectFileName string max 255 Required if ResultAttachedBinaryObject present ESAR - Binary BinaryObjectFileName Compliant

Result Binary Object 05.01.02 string max 6 Required if ResultAttachedBinaryObject present RESULT ESAR - Binary BinaryObjectFileType Compliant

The period of time (in days) over which a measurement was made. For example, BOD can be measured as 5 day or 20 day BOD.



TSRRSULT

DUR_BASIS_TYPE_NM

The period of time (in days) over which a measurement was made. For example, BOD can be measured as 5 day or 20 day BOD.




ResultTemperatureBasisText

The name that represents the controlled temperature at which the sample was maintained during analysis, e.g. 25 deg BOD analysis.



TSRRSULT

TEMP_BASIS_LVL_NM

The name that represents the controlled temperature at which the sample was maintained during analysis.




ResultParticleSizeBasisText

User defined free text describing the particle size class for which the associated result is defined.

This is usually done for a physical sediment analysis, where the user is free to document the particle size classification structure used in the analysis.


PARTICLE_SIZE_BASIS

User defined free text describing the particle size class for which the associated result is defined..




05.00.13Header

Header;The quantitative statistics and qualitative descriptors that are used to interpret the degree of acceptability or utility of data to the user.

Optional May have 0 to 1 for each instance of ResultDescription

A measure of mutual agreement among individual measurements ofthe same property usually under prescribed similar conditions.

WQX_DataQualityIndicator_v1.0.xsd

TSRRSULT

PRECISION_AMT_TEXT Estimate of the maximum possible error in

the result. (e.g., Counting error in determiningradiological beta particle counts.)

ESAR / Measure

A measure of mutual agreement among individual measurements ofthe same property usually under prescribed similar conditions.

The systematic or persistent distortion of a measurement process which causes error in one direction.


TSRRSULT

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 specimen of known properties.

The systematic or persistent distortion of a measurement process which causes error in one direction.

ConfidenceIntervalValue

A range of values constructed so that this range has a specified probability of including the true population mean.


A range of values constructed so that this range has a specified probability of including the true population mean.

UpperConfidenceLimitValue

Value of the upper end of the confidence interval.


Value of the upper end of the confidence interval.

LowerConfidenceLimitValue

Value of the lower end of the confidence interval.


Value of the lower end of the confidence interval.

Free text with general comments concerning the result.


TSMGNTXT

DESCRIPTION_TEXT

Comments related to the analysis of a particular substance.

Business Decision: Team needed term not explicitely linked to 'Substance')

ResultDepthHeightMeasure

Header;A measurement of the vertical location (measured from a reference point) at which a result is obtained.

Optional;Up to one allowed per instance of Result



Business Decision: No corresponding element found in EDSC standards at the result level.




ResultDepthAltitudeReferencePointText

The reference used to indicate the datum or reference used to establish the depth/altitude of a result.



ResultAttachedBinaryObject

Header;This section allows for the association of References and electronic attachments to a Result description including any other documents, images, maps, photos, laboratory materials, geospatial coverages, and other objects associated with the Project..

Optional; may have 0 can have many per instance of Result

Multiple instances of AnalysisAttachedBinaryObject per Analysis instance




TSMPROJ

BLOB_TITLE

User-defined Title defining or describing the BLOB Content.






BLOB_TYPE

A result may be further described by a Binary Large Object, or BLOB. The BLOB may be a document or a graphic object. This field defines the type of BLOB which further defines this result. A foreign key in table TSMBLOB identifies the BLOB which is linked to the Station.


Result Analytical Method 05.02.00 Header

Result Analytical Method 05.02.01 MethodIdentifier string max 20 ESAR Compliant

Result Analytical Method 05.02.02 string max 120 Required if Result Analytical Method block is reported. ESAR Compliant

Result Analytical Method 05.02.03 MethodName string max 120 NAME ESAR Compliant

Result Analytical Method 05.02.04 Optional string max 25 ESAR Compliant

Result Analytical Method 05.02.05 MethodDescriptionText Optional string max 500 ESAR Compliant

Result LAB Info 05.03.00 Header ResultLabInformation

Result LAB Info 05.03.01 LaboratoryName Optional string max 60 NAME ESAR /Contact

Result LAB Info 05.03.02 AnalysisStartDate Optional ESAR Analysis Start Date Compliant

Result LAB Info 05.03.03 AnalysisStartTime Optional

Result LAB Info 05.03.03.01 Time Required only when AnalysisStartTime is reported WQX_WQXTime_v1.0.xsd ESAR Analysis Start Time Compliant

Result LAB Info 05.03.03.02 TimeZoneCode string max 4 Required only when AnalysisStartTime is reported Yes WQX_WQXTime_v1.0.xsd

Result LAB Info 05.03.04 AnalysisEndDate Optional ESAR Analysis End Date Compliant

Result LAB Info 05.03.05 AnalysisEndTime Optional

Result LAB Info 05.03.05.01 Time Required only when AnalysisEndTime is reported WQX_WQXTime_v1.0.xsd ESAR Analysis End TIme Compliant

Result LAB Info 05.03.05.02 TimeZoneCode string max 4 Required only when AnalysisEndTime is reported Yes WQX_WQXTime_v1.0.xsd

Result LAB Info 05.03.06 Optional

05.04.00 Header

05.04.01 ESAR

05.04.02

Result Analytical Method

Header:Allows for the optional association of an analytical method employed either in the Lab or in the Field with any result.

Conditional (see business rule);may have 0 can have 1 per Result

Required for certain ActivityTypeCodes. (Refer to Activity Type domain list for identification of Activity Types that require reporting of Analytical Method.)



Required if Result Analytical Method block is reported.

Domain Values: This field will be validated against a domain value list only if the MethodIdentifierContext element (05.02.02) is set to one of a predefined list of contexts (e.g. USEPA, ASTM, USDOI/USGS, etc.).

Yes, but see note in business rules.

WQX_ResultAnalyticalMethod_v1.0.xsd

TSRANLPR

PROCEDURE_ID

The abbreviated name or identifying code of the analytical procedure.

SampleAnalyticalMethod / MethodIdentifier






TSRANLPR

TSRANLPR_ORG_ID


SampleAnalyticalMethod / MethodIdentifier Context (meta data)




Required only if Method Identifier and Method Identifier Context are not from WQX Domain Value list (i.e. user-defined method)


TSRANLPR

The full title of the analytical procedure.

SampleAnalyticalMethod / MethodName





SampleAnalyticalMethod / MethodQualifierType




SampleAnalyticalMethod / MethodDescriptionText


Header;Information that describes information obtained by a laboratory related to a specific laboratory analysis.

Optional;may have 0 can have 1 per Result

The name of the Lab responsible for the result

WQX_ResultLabInformation_v1.0.xsd

LABORATORY

The formal title of the laboratory facility.

LaboratoryOrganizationContact / OrganizationFormalName

The principal organization to contact with questions about this laboratory analysis data.

Business Decision: WQX team decided not to reference ESAR Laboratory Contact (15 fields), since team needed only 1 field, or having an element name called OrganizationFormalName, which isn't as clear as term used.

The calendar date on which the analysis began.

date(YYYY-MM-DD)


TSRRSULT

ANALYSIS_DATE

The date on which laboratory analysis of the sample for this particular result was performed.

The calendar date on which the analysis began.

The local time and relative time zone when the analysis began.



Time - (hh:mm:ss)

TSRRSULT

ANALYSIS_TIME

The time of day at which laboratory analysis of the sample for this particular result was performed.

The local time when the analysis began.



TSRFDACT

ANALYSIS_TIME_ZONE

The time zone for which the time of day is reported. Any of the longitudinal divisions of the earth's surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately to the east.

The calendar date on which the analysis was finished.

date(YYYY-MM-DD)


TSRRSULT

ANALYSIS_DATE

The date on which laboratory analysis of the sample for this particular result was performed.

The calendar date on which the analysis was finished.

The local time and relative time zone when the analysis was finished.



Time - (hh:mm:ss)

TSRRSULT

ANALYSIS_TIME

The time of day at which laboratory analysis of the sample for this particular result was performed.

The local time when the analysis was finished.



TSRRSULT

ANALYSIS_TIME_ZONE

The time zone for which the time of day is reported. Any of the longitudinal divisions of the earth's surface in which a standard time is kept. Each zone observes a clock time one hour earlier than the zone immediately to the east.

ResultLaboratoryCommentCode

Remarks which further describe the laboratory procedures which produced the result.


Yes WQX_ResultLabInformation_v1.0.xsd

TSRLBRMK

SHORT_NAME

An Organization defined cryptic code which will represent a particular laboratory remark. Used as a shorthand or abbreviation torepresent the Laboratory Remark in batch data update runs.

No corresponding element found in EDSC data standards that specifically realtes to the laboratory comment code applied to the results.

Result Detection Quantitation Limit

ResultQuantitationLimit

Header;Information that describes one of a variety of detection or quantitation limits determined in a laboratory.

Optional;may have 0 can have many per Result Lab Information

Multiple instances of ResultQuantitationLimits per ResultLabInformation


DetectionQuantitationLimitTypeName

Text describing the type of detection or quantitation limit used in the analysis of a characteristic.



Required when ResultDetectioncondition is either*Not Detected""Present Above Quantification Limit"or "Present and Below Quantification Limit"

Yes WQX_DetectionQuantitationLimit_v1.0.xsd

TSRUOM_IS_NUMBER

Detection Limit Type orReporting Limit Type

One of a list of client, regulation, or organization defined acronyms or statistic methodologies that specify the type of detection limit used for analysis. OrOne of a list of client, regulation, or organization defined acronyms or statistical methodologies that specify the type of reporting limit.

Business Decision: ESAR uses Detection Limit and Reporting Limit as separate fields. The team decided to combine these into 1 field that could be reported multiple times for each result to simplify the reporting process. A type field is then used to distinguish the type of detection or Result Detection Quantitation

LimitDetectionQuantitationLimitMeasure

Constituent concentration that, when processed through the complete method, produces a signal that is statistically different from a blank.


Required when ResultDetectioncondition is either*Not Detected""Present Above Quantification Limit"or "Present and Below Quantification Limit"

05.04.02.01 MeasureValue string max 12 TSRDQL ESAR

05.04.02.02 MeasureUnitCode TSRDQL ESAR

LAB Sample Prep 05.05.00 Header

LAB Sample Prep

LAB Sample Prep 05.05.01.01 MethodIdentifier String max 20 Required when LaboratorySamplePreparation is present. Compliant

LAB Sample Prep 05.05.01.02 String max 120 Required when LaboratorySamplePreparation is present. Compliant

LAB Sample Prep 05.05.01.03 MethodName String max 120 Required when LaboratorySamplePreparation is present. NAME Compliant

LAB Sample Prep 05.05.01.04 Optional string max 25 Compliant

LAB Sample Prep 05.05.01.05 MethodDescriptionText Optional string max 500 Compliant

LAB Sample Prep 05.05.02 PreparationStartDate Optional ESAR PreparationStartDate Compliant

LAB Sample Prep 05.05.03 PreparationStartTime Optional


The reportable measure of the result for the chemical, microbiological or other characteristic being analyzed.


Required when ResultDetectioncondition is either*Not Detected""Present Above Quantification Limit"or "Present and Below Quantification Limit";Also required when DetectionQuantitationLimitMeasure block is reported.


MIN_DETECT_LIMIT OR MAX_QUANT_LIMIT OR MIN_QUANT_LIMIT

Represents the least amount of the target substance which could be detected by the instrument/analytical process employed to determine the result. Above this value the target substance is presumed to be present.ORRepresents the largest amount of the target substance which could be quantified by the instrument/analytical process employed todetermine the result. Values above the minimum and below the maximum quantitation limits are reported as valid numeric results.

Multiple map destinations / may not be exact match

Detection Limit / Measure Value orReporting Limit / Measure Value

Constituent concentration that produces a signal sufficiently greater than the blank and can be detected within specified levels by good laboratories during routine operating conditions.ORConstituent concentration that, when processed through the complete method, produces a signal that is statistically different from a blank.

Business Decision: ESAR uses Detection Limit and Reporting Limit as separate fields. The team decided to combine these into 1 field that could be reported multiple times for each result to simplify the reporting process. A type field is then used to distinguish the type


The code that represents the unit for measuring the chemical substance, microbiological substance or other characteristic.


From domain valuesstring max 12(MeasureUnitCode)

Required when ResultDetectioncondition is either*Not Detected""Present Above Quantification Limit"or "Present and Below Quantification Limit";Also required when DetectionQuantitationLimitMeasure block is reported.

Yes WQX_MeasureCompact_v1.0.xsd

TSRUOM_IS_NUMBER

The foreign key to TSRUOM implements "One Unit of Measure may qualify one or more detection/quantitation limits."

foreign key

Detection Limit / Measure Unit Code orReporting Limit / Measure Unit Code


Business Decision: ESAR uses Detection Limit and Reporting Limit as separate fields. The team decided to combine these into 1 field that could be reported multiple times for each result to simplify the reporting process. A type field is then used to distinguish the type of detection or reporting condition reported.

LabSamplePreparation

Header;Describes Lab Sample Preparation procedures which may alter the original state of the Sample and produce Lab subsamples. These Lab Subsamples are analyzed and reported by the Lab as Sample results.

Optional;may have 0 can have many per Result

05.05.01 Header

LabSamplePreparationMethod

Header;Identifying information about the method followed to prepare a sample for analysis




TSRLSPP

PREPARATION_ID

The cryptic code that represents a particular sample preparation procedure. Used as a shorthand or abbreviation to represent theSample Preparation Procedure in batch data update runs.

ESAR - Results / Method

Sample Preparation Method / Method Identifier






TSRLSPP

TSRLSPP_ORG_ID



Sample Preparation Method / Method Identifier (metadata)





TSRLSPP

The long name of the Sample Preparation Procedure.


Sample Preparation Method / Method Name






Sample Preparation Method / MethodQualifierType





Sample Preparation Method / MethodDescriptionText


The calendar date when on which the preparation/extraction of the sample for analysis began.

date(YYYY-MM-DD)

WQX_LabSamplePreparation_v1.0.xsd


The calendar date when on which the preparation/extraction of the sample for analysis began.

The local time when the preparation/extraction of the sample for analysis began.


Summary of Changes from Pilot to PostPilot Version of WQX Schema

Old ID Old Element New ID01.03.02 LocationAddressText 01.03.0201.03.06 AddressPostalCode 01.03.0602.00.00 Project 02.00.0002.00.03 ProjectDescriptionText 02.00.0302.01.01 BinaryObjectContent -02.01.02 BinaryObjectFileName 02.01.0102.01.03 BinaryObjectFileTypeCode 02.01.0203.00.00 MonitoringLocation 03.00.00- - 03.00.05- - 03.00.06- - 03.00.07- - 03.00.08- - 03.00.09- - 03.00.09.01- - 03.00.09.0203.01.03 SourceMapScaleNumber 03.01.0303.01.04 HorizontalCollectionMethodCode 03.01.0403.01.05 HorizontalReferenceDatumCode 03.01.05- 03.01.0603.01.06 VerticalMeasure 03.01.06.0103.01.07 VerticalMeasureUnitCode 03.01.06.0203.01.08 VerticalCollectionMethodCode 03.01.0703.01.09 VerticalReferenceDatumCode 03.01.0803.01.10 CountryCode 03.01.0903.01.11 StateCode 03.01.1003.01.12 CountyCode 03.01.1103.02.01 BinaryObjectContent -03.02.02 BinaryObjectFileName 03.02.0103.02.03 BinaryObjectFileTypeCode 03.02.0204.00.01 ActivityIdentifier 04.00.0104.00.03 ActivityMediaText 04.00.0304.00.04 ActivityMediaSubDivisionText 04.00.0404.00.06 ActivityStartTime 04.00.0604.00.08 ActivityEndTime 04.00.08- - 04.00.09- - 04.00.1004.00.09 ActivityDepthAltitudeMeasureValue 04.00.10.01- - 04.00.10.02

- - 04.00.1104.00.10 ActivityTopDepthAltitudeMeasureValue 04.00.11.01- - 04.00.11.02

- - 04.00.1204.00.11 ActivityBottomDepthAltitudeMeasureValue 04.00.12.01- - 04.00.12.02

04.00.12 ActivityDepthAltitudeMeasureUnitCode -04.00.14 ActivityAssignmentProjectIdentifier 04.00.14- - 04.00.16

04.00.16 ActivityCommentText 04.00.1704.01.03 SourceMapScaleNumber 04.01.0304.01.04 HorizontalCollectionMethodCode 04.01.0404.01.05 HorizontalReferenceDatumCode 04.01.0504.02.01 SampleCollectionMethodText 04.02.01- - 04.02.01.01- - 04.02.01.02- - 04.02.01.03- - 04.02.01.04- - 04.02.01.0504.02.04 SampleCollectionEquipmentCode 04.02.04- - 04.02.05

SamplePreparation

04.03.01 SamplePreparationMethodText 04.03.01- - 04.03.01.01- - 04.03.01.02- - 04.03.01.03- - 04.03.01.04- - 04.03.01.0504.03.02 SampleHoldingContainerMaterialCode 04.03.0204.03.03 SampleHoldingContainerColorCode 04.03.0304.03.04 SamplePreservationChemicalText 04.03.0404.03.05 SamplePreservationThermalCode 04.03.05

SampleSubsampleDescription-

04.04.01 SubsampleIdentifier -04.04.02 SubsampleCommentText -04.05.01 BinaryObjectContent -- - 04.05.0105.00.01 PortableDataLoggerLineName 05.00.01- - 05.00.0505.00.05 ResultValueMeasure 05.00.05.01

05.00.06 ResultValueMeasureUnitCode 05.00.05.02- - 05.00.05.0305.00.07 ResultStatusText 05.00.0605.00.08 ResultStatisticalBaseCode 05.00.0705.00.09 ResultValueTypeName 05.00.0805.00.10 ResultWeightBasisText 05.00.0905.00.11 ResultTimeBasisText 05.00.1005.00.12 ResultTemperatureBasisText 05.00.1105.00.13 ResultParticleSizeBasisText 05.00.12- - 05.00.1305.00.14 ResultValueMeasurePrecisionText 05.00.13.0105.00.15 ResultBiasText 05.00.13.02- - 05.00.13.03

04.03.00 Header

04.03.00 Header

04.04.00 Header

- - 05.00.13.04- - 05.00.13.05- - 05.00.15- - 05.00.1605.00.16 ResultCommentText 05.00.1405.00.17 SubsampleIdentifier -05.01.01 BinaryObjectContent -05.01.02 BinaryObjectFileName 05.01.0105.01.03 BinaryObjectFileTypeCode 05.01.0205.02.01 MethodIdentifierCode 05.02.0105.02.02 MethodIdentifierCodeListIdentifier 05.02.0205.02.03 MethodName 05.02.03- - 05.02.04- - 05.02.0505.03.02 AnalysisDate 05.03.0205.03.03 AnalysisTime 05.03.03

- - 05.03.04- - 05.03.05

05.03.04 ResultLaboratoryCommentCode 05.03.06ResultQuantitationLevel

05.04.01 DetectionQuantitationLevelTypeName 05.04.01- - 05.04.0205.04.02 DetectionQuantitationLevelMeasure 05.04.02.0105.04.03 DetectionQuantitationLevelMeasureUnitCode 05.04.02.0205.05.01 MethodIdentifierCode 05.05.01- - 05.05.01.0105.05.02 MethodIdentifierCodeListIdentifier 05.05.01.0205.05.03 MethodName 05.05.01.03- - 05.05.01.04- - 05.05.01.0505.05.04 LabSamplePreparationDate 05.05.02

05.05.05 LabSamplePreparationTime 05.05.03

- - 05.05.04

- - 05.05.05

- - 06.00.00

- -06.00.01

- -06.00.02

- -06.00.03

- -06.00.04

05.04.00 Header

05.04.00 Header

Summary of Changes from Pilot to PostPilot Version of WQX Schema

New ElementAddressTextPostalCodeProject ProjectDescriptionText-BinaryObjectFileNameBinaryObjectFileTypeCodeMonitoringLocationHUCEightDigitCodeHUCTwelveDigitCodeTribalLandIndicatorTribalLandNameAlternateMonitoringLocationIdentityMonitoringLocationIdentifierMonitoringLocationIdentifierContextSourceMapScaleNumericHorizontalCollectionMethodNameHorizontalCoordinateReferenceSystemDatumNameVerticalMeasureMeasureValueMeasureUnitCodeVerticalCollectionMethodName VerticalCoordinateReferenceSystemDatumNameCountryCodeStateCodeCountyCode-BinaryObjectFileNameBinaryObjectFileTypeCodeActivityIdentifierActivityMediaNameActivityMediaSubDivisionNameActivityStartTimeActivityEndTimeActivityRelativeDepthNameActivityDepthHeightMeasureMeasureValueMeasureUnitCode

ActivityTopDepthHeightMeasureMeasureValueMeasureUnitCode

ActivityBottomDepthHeightMeasureMeasureValueMeasureUnitCode

-ProjectIdentifierMonitoringLocationIdentifier

ActivityCommentTextSourceMapScaleNumericHorizontalCollectionMethodNameHorizontalCoordinateReferenceSystemDatumNameSampleCollectionMethodMethodIdentifierMethodIdentifierContextMethodNameMethodQualifierTypeNameMethodDescriptionTextSampleCollectionEquipmentNameSampleCollectionEquipmentCommentTextSamplePreparation

SamplePreparationMethodMethodIdentifierMethodIdentifierContextMethodNameMethodQualifierTypeNameMethodDescriptionTextSampleContainerTypeNameSampleContainerColorNameChemicalPreservativeUsedNameThermalPreservativeUsedName

----ResultCountDataLoggerLineNameResultMeasureResultMeasureValue

MeasureUnitCodeMeasureQualifierCodeResultStatusIdentifierStatisticalBaseCodeResultValueTypeNameResultWeightBasisTextResultTimeBasisTextResultTemperatureBasisTextResultParticleSizeBasisTextDataQualityPrecisionValueBiasValueConfidenceIntervalValue

UpperConfidenceLimitValueLowerConfidenceLimitValueResultDepthHeightMeasureResultDepthAltitudeReferencePointTextResultCommentText--BinaryObjectFileNameBinaryObjectFileTypeCodeMethodIdentifierMethodIdentifierContextMethodNameMethodQualifierTypeNameMethodDescriptionTextAnalysisStartDateAnalysisStartTime

AnalysisEndDateAnalysisEndTime

ResultLaboratoryCommentCodeResultQuantitationLimit

DetectionQuantitationLimitTypeNameDetectionQuantitationLimitMeasureMeasureValueMeasureUnitCodeLabSamplePreparationMethodMethodIdentifierMethodIdentifierContextMethodNameMethodQualifierTypeNameMethodDescriptionTextPreparationStartDate

PreparationStartTime

PreparationEndDate

PreparationEndTime

ActivityGroup

ActivityGroupIdentifier

ActivityGroupName

ActivityGroupTypeCode

ActivityIdentifier

ChangeUpdated definition in XML to reflect definition in Excel; updated nameUpdated element nameMade optionalUpdated definition to be more precise and better aligned with ESAR.Removed elementUpdated numberingUpdated numberingMade optionalNew elementNew elementNew elementNew elementNew complex blockNew element under Alternate Monitoring Location IdentityNew element under Alternate Monitoring Location IdentityUpdated element name to reflect EDSC standardsUpdated element name and definition to reflect EDSC standardsUpdated element name and definition to reflect EDSC standardsNew group added (referencing compact Measure block)Now uses referenced Measure block to harmonize with EDSC standardsNow uses referenced Measure block to harmonize with EDSC standardsUpdated element name and definition to reflect EDSC standardsUpdated element name and definition to reflect EDSC standardsUpdated numberingUpdated numberingUpdated numberingRemoved elementUpdated numberingUpdated numberingChanged max length to 35Updated to make more in line with ESAR, although still not completely compliantUpdated to make more in line with ESAR, although still not completely compliantAdded time zoneAdded time zoneNew elementNew group added (referencing compact Measure block); changed term to 'Height'Now uses referenced Measure block to harmonize with EDSC standards

New group added (referencing compact Measure block); changed term to 'Height'Now uses referenced Measure block to harmonize with EDSC standards

New group added (referencing compact Measure block); changed term to 'Height'Now uses referenced Measure block to harmonize with EDSC standards

New element incorporated via reference of measure block for ActivityDepthHeightMeasure

New element incorporated via reference of measure block for ActivityTopDepthHeightMeasure

New element incorporated via reference of measure block for ActivityBottomDepthHeightMeasure

Removed element (incorporated into 04.00.09.02, 04.00.10.02, and 04.00.11.02)Updated element name

Updated numberingUpdated element name to reflect EDSC standardsUpdated element name and definition to reflect EDSC standardsUpdated element name and definition to reflect EDSC standardsChanged from single element to header now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedModified element nameNew element

Updated this to have minoccurs=0 so it will be optionalChanged from single element to header now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedNew element now that Method block is referencedUpdated name and definition to be compliant with ESARUpdated name and definition to be compliant with ESARUpdated name and definition to be compliant with ESARUpdated name and definition to be compliant with ESARRemoved grouping

Removed elementRemoved elementRemoved elementNew element addedModified element nameNew group added (referencing Measure block)

New element incorporated via reference of measure blockNew element incorporated via reference of measure blockModified element name to be compliant with ESAR; updated numberingModified element name to be compliant with ESAR; updated numberingUpdated numberingUpdated numberingUpdated numberingUpdated numberingUpdated numberingNew group added (referencing QAQC block)Updated element name to be part of QAQC blockUpdated element name to be part of QAQC blockNew element added (as part of QAQC block)

New element added due to modification of schema structure to decouple monitoring location and activity

Now uses referenced Measure block to harmonize with EDSC standards; uses custom data type to capture Choise lists.

New element added (as part of QAQC block)New element added (as part of QAQC block)New element addedNew element addedUpdated numberingRemoved elementRemoved elementUpdated numberingUpdated numberingUpdated element name to be compliant with EDSCUpdated element name to be compliant with EDSCUpdated definition to be compliant with EDSCNew element added (as part of Method block)New element added (as part of Method block)Updated element (split into start and end dates) to be compliant with EDSC

Updated element (split into start and end dates) to be compliant with EDSC

Updated numbering and fixed definition in XML.Updated element name to be more compliant with EDSC

Updated element name to be more compliant with EDSCNew grouping (to now reference Measure block)Now uses referenced Measure block to better harmonize with EDSC standardsNow uses referenced Measure block to better harmonize with EDSC standardsChanged from single element to header now that Method block is referencedNew element now that Method block is referencedUpdated element name to be compliant with EDSCUpdated definition to be compliant with EDSCNew element now that Method block is referencedNew element now that Method block is referenced

Updated element (split into start and end dates) to be compliant with EDSC; also added time zone

Updated element (split into start and end dates) to be compliant with EDSC; also added time zone

Updated numbering and element (split into start and end dates) to be compliant with EDSCUpdated numbering and element (split into start and end dates) to be compliant with EDSC; also added time zoneUpdated numbering and element (split into start and end dates) to be compliant with EDSCUpdated numbering and element (split into start and end dates) to be compliant with EDSC; also added time zoneNew group added (new approach to handling subsamples and QC sample relationships)New element added (new approach to handling subsamples and QC sample relationships)New element added (new approach to handling subsamples and QC sample relationships)New element added (new approach to handling subsamples and QC sample relationships)New element added (new approach to handling subsamples and QC sample relationships)

General: updated namespace to new conventionGeneral: removed reference to SSC namespace in some files

[xls] · web viewthe alpha-numeric code assigned by the owning organization which uniquely...

Documents