<< Click to Display Table of Contents >> Navigation: AQS Module > AQS Formats > COLLECT_INSPECTION_AQS |
The COLLECT_INSPECTION_AQS Format is a simplified EDD format for use with EQuIS Collect and Collect data forms. The format includes sections that allow for the mapping of various types of data that may be gathered using Collect forms, including:
•Equipment
•Equipment_Location_AQS
•Equipment_Notes
•Equipment_Parameter
•Facility_Parameter
•File
•File_Parameter
•Flow
•Geography
•Location
•Location_Parameter
•Note
•Precipitation
•Task
•Task_Parameter
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. For example, data field in the Location_Parameter section would map to fields of the same name in the DT_LOCATION_PARAMETER table; Equipment_Notes to the DT_EQUIPMENT_NOTE table; etc.
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. |
---|
Copyright © 2023 EarthSoft, Inc • Modified: 15 Nov 2022