Collect Inspection Format

<< Click to Display Table of Contents >>

Navigation:  Collect >

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.