EQEDD - Location Sections

Import

The EQEDD format can be used to load new locations (SYS_LOC_CODE) and to submit new information for location (SYS_LOC_CODE) records already in the database.

All sections containing the SYS_LOC_CODE column will function as explained below.

1.If the SYS_LOC_CODE field is populated, the format will check against the Location tab to see if this data exists.

2.If the Location section of the format file is empty, the SYS_LOC_CODE fields will check the database to see if the locations exist (Professional EDP Only).

3.If the location does not exist in the database or the Location section, an error will occur on the commit stage.

Export

In EQuIS v.7x, the EQEDD Location EDD Export returns all the selected locations for the given facility from DT_LOCATION.

In EQuIS v.6x, the EQEDD Location EDD Export returns only location records that have coordinates, and exports records from VW_LOCATION.