Site IntroductionΒΆ

This set of five transactions is used to create or update Site information.

  • Type AA, Basic Site Information (contains the Site location and other metadata),

  • Type AB, Site Street Information,

  • Type AC, Site Open Path Information,

  • Type AD, Site Sampler Information, and

  • Type AE, Sampler Channel Information

Insert transactions (i.e., transactions with Action Indicator I) are used to create new site-related data. When creating a new site, only one AA transaction is allowed and required, while multiple AB and AC transactions can be entered. Each AB transaction supplies information for one street near a site. Each AC transaction supplies information for one open path monitor at a site. Etc.

Update transactions (i.e., transactions with Action Indicator U) are used to change the contents of site-specific fields. Blank fields on an update transaction are ignored; they do not affect fields in the database. The values coded on an update transaction replace the values of the corresponding columns in the database. If no value existed previously, the value from the transaction is inserted into the corresponding column. Only non-key fields can be updated.

Delete transactions (i.e., transactions with Action Indicator D) are used to remove site-related information. Note: A site basic record may not be deleted once loaded into AQS.