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.