Collect Inspection Format

A simplified EDD format called COLLECT_INSPECTION has been created for use with EQuIS Collect 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

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

Note: The Collect Inspection 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.

The COLLECT_INSPECTION format comes only with a format definition file (*.xse) and a DLL file. This simplified approach improves performance when working with this format in the Collect Template Designer, and when loading data from Collect into EQuIS. Data integrity checks will be made on EDDs imported through this format, but are limited only to checks on:

•Primary Keys on each table

•Field data type

•Field length

It is assumed that the design of the template will ensure that other facets of data integrity are addressed. For example, setting an Options list for a field on the Collect template can ensure that the only values that can be recorded are contained in the database reference values.