COLLECT_INSPECTION_AQS

<< 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.