Table details: CRDA/17/DS/1/1/1

The following fields are closed:

• SITE_NAME - until 2025
• GREF - until 2025
• LOCALITY - until 2025
• ADDRESS - until 2025
• VISITORS - until 2025
• NOTES - until 2025
• SURNAME - until 2025

This record was closed under the Public Records Act or is exempt under the Freedom of Information Act 2000. It is possible to request a review of the information it contains under the Freedom of Information Act 2000 and this will trigger a review. Request review.

You can use the NDAD Query Builder to view and query data in this and other tables in this dataset.

Unique identifier of the record; the key to the file. The first 2 numbers in the key are the region number ie the region which entered the record (the region number and name are held in the COUNTIES table); the remainder are a unique sequential number.

Records in which the BATKEY starts with the digits '99' were entered by the EN Ecologist who developed/administered the Bats database. When a copy of the BATDATA system is first installed in a region, a maintenance facility is run to set the regional code. The key numbers (BATKEY) assigned to records begin with the number of the region. {Maximum length 6}

This field is updated whenever the record is altered. This allows the selection, in order to transfer records to English Nature HQ, of all records added or updated since the last transfer. In the Batadata system, dates were held internally as the number of days since December 31st 1967 (day 0)

Identification of the user who added or last updated the record

For the ordinary user of the system, the user-id is of the form BAT.XX, where XX is the number of the user's region. Other entries in this field identify the user ids of individuals (mainly system administrators?). User names also controlled the user environment within the BATDATA system. {Maximum length 10}

{Maximum length 40}

During data entry, the grid reference is validated against the VCOUNTY table, to check that a record for the 10 km square exists in that table and that the county entered for this BATDATA record contains the 10km square defined by the grid reference. {Maximum length 10}

At data entry, the COUNTY_CODE is validated against the COUNTIES table, which holds the codes and names of the Counties. The region code is used to ensure that only the appropriate counties (ie those within the user's region) are presented to the user {Maximum length 6}

This field forms a Many - 1 relationship with the following tables:

via the field CNUMB

At data entry, the DISTRICT_CODE is validated against the LPAS table, which holds the codes and names of the Districts. {Maximum length 6}

This field forms a Many - 1 relationship with the following tables:

via the field LPA_KEY

EN have confirmed that for records converted from an earlier system, whatever was in the 2nd line of the address was copied over. For more recent records, the user consults the relevant OS map to identify the locality. {Maximum length 30}

At data entry, the SITE_TYPE is validated against the SITE_TYPES table, which holds the code / text for each type of site. {Multi-valued field. Maximum length 16}

This field forms a Many - 1 relationship with the following tables:

via the field TYPE_KEY

At data entry, the ENQTYPE_CODE is validated against the ENQTYPE table, which holds the codes and description of the types of enquiries. {Maximum length 10}

This field forms a Many - 1 relationship with the following tables:

via the field ENQUIRY_KEY