Site and Location Cross-Reference Table

<< Click to Display Table of Contents >>

Navigation:  Table Descriptions > Group 1 >

Site and Location Cross-Reference Table

Name

Location/Site Cross Reference

Short Name

SLX

ERPIMS Supplied

Yes

Number of Fields

5

Total Record Length

30

Child Tables

 

Information about locations associated with a site that has been selected for study.

 

Information about locations associated with a site that have been selected for study.  An ERPIMS site is an area that has been defined in terms of a contaminant release or a proposed (or active) remedial activity.  A location is a specific point where environmental sampling has taken place or where a measurement has been taken.  A location can be associated with more than one site, in which case a record should be created for each site-location combination.  The purpose of capturing site and location information is to establish the spatial and hydrologic relationships between locations and sites.

Site cross reference data has become increasingly more important and it is used by numerous reporting and GIS applications.

This table is a required part of the Group One data submission, and must be submitted for all new locations.  SLX records will also be required when existing locations are sampled and a SLX record does not exist in ERPIMS. Changes to existing AFCEC supplied data should be coordinated with the ERPIMS Data Support Group.

 

 

Short Field Name

Import Required?

Delivery Required

Start

End

AFIID

Yes

C

1

5

SITEID

Yes

V

7

10

LOCID

Yes

Y

12

26

GFCCODE

No

V

28

28

SPCODE

No

V

30

30