<< Click to Display Table of Contents >> Navigation: AQS Module > AQS Formats > COLLECT_INSPECTION_AQS |
Format Name: COLLECT_INSPECTION_AQS
File Name: COLLECT_INSPECTION_AQS.zip
Source: Available for the EarthSoft Primary Point of Contact (POC) on the EarthSoft Community Center Downloads dashboard from the All Items > Products > AQS Module folder
Export: Not Applicable
Enum File: COLLECT_INSPECTION_AQS-enum.xml
Description: The COLLECT_INSPECTION_AQS Format is a simplified EDD format for use with EQuIS Collect and Collect data forms. EQuIS Collect can be used in conjunction with the EQuIS AQS format for AQS data collection and importation into the EQuIS database. Out-of-the-box Collect AQS templates can be used to record equipment calibration, maintenance information, flow rate data, and more. See the AQS and EQuIS Collect article for more information on using and modifying AQS templates.
Installation Instructions: This format requires a Premium Enterprise license and the AQS Schema applied to the database.
To access the format, download the COLLECT_INPSECTION_AQS format file (COLLECT_INSPECTION_AQS.zip) from the EarthSoft Community Center and copy the file to the location where other EQuIS format files are typically stored (e.g., C:\Program Files\EarthSoft\EQuIS\Formats\EarthSoft).
Overview: The COLLECT_INSPECTION_AQS format includes sections that allow for the mapping of various types of data that may be gathered using Collect forms. Each section is named after the EQuIS table to which its fields map. The field names within each section match with those in the corresponding EQuIS table.
The format has the following sections:
•Equipment_Location_AQS – Maps to the AT_EQUIPMENT_LOCATION table.
•Location – Maps to the DT_LOCATION and DT_COORDINATE tables.
•Location_Parameter – Maps to the DT_LOCATION_PARAMETER table.
•Facility_Parameter – Maps to the DT_FACILITY_PARAMETER table.
•Task – Maps to the DT_TASK table.
•Task_Parameter – Maps to the DT_TASK_PARAMETER table.
•Equipment – Maps to the DT_EQUIPMENT table.
•Equipment_Parameter – Maps to the DT_EQUIPMENT_PARAMETER table.
•Equipment_Notes – Maps to the DT_EQUIPMENT_NOTE table.
•Precipitation – Maps to the DT_PRECIPITATION table.
•Flow – Maps to the DT_FLOW and DT_SAMPLE tables.
•Note – Maps to the DT_NOTE table.
•File – Maps to the DT_FILE table.
•File_Parameter – Maps to the DT_FILE_PARAMETER table.
•Geography – Maps to the DT_GEOGRAPHY table.
The COLLECT_INSPECTION_AQS Format differs from the standard COLLECT_INSPECTION Format in that it includes the following AQS Schema fields:
•Equipment_Location_AQS:
•AQS_poc
•AQS_method_code
•AQS_parameter_code
•Equipment:
•g_value
•Equipment_Parameter:
•aqs_assesment_code
•aqs_parameter
•aqs_method_code
•aqs_poc
•aqs_assessment_number
Note: The Collect Inspection AQS Format supports linking File and Geography to all other sections. Users must understand foreign keys (e.g., NOTE_TYPE exists in the RT_NOTE_TYPE table). Use the EDD Description file to understand format structure. |
---|
See the Equipment, Personnel, and Action Levels sections in the Setup Reference Values for EQuIS AQS Module article for additional considerations when using the COLLECT_INSPECTION_AQS Format.
Copyright © 2025 EarthSoft, Inc. • Modified: 08 Jun 2025