The National Archives

Monday 23 November

   
 
 NDAD: The National Digital Archive of Datasets
Welcome (home page) About NDAD Users Contributors  
Search Browse News Help (new window)  
 
 

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

Record Types Lookup Table (RECORD_TYPES)

 
 
Quick reference Full details Order copies
Search this table Download as CSV
 
  View in hierarchy
 

Jump to :  Context  |  Summary  |  Identity statement  |  Description  |  Fields  | 

Context

AH/17  Nature Conservation Departments
  CRDA/17  British Bats
  CRDA/17/DS/1  English Nature
  CRDA/17/DS/1/1  1999 snapshot
 
Top of pagetop of page

Summary

Title Record Types Lookup Table
NDAD reference CRDA/17/DS/1/1/6
Scope & content Acts as a lookup table for the RTYPE_CODE field in the BATDATA table. Identifies how the bats/site were identified.
Access conditions

There are no access restrictions on this table.

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

 
Top of pagetop of page

Identity statement

Table name RECORD_TYPES
Number of records 5
SIZE of file (bytes) 83
Maximum record size (bytes) 22
ISAD(G) level of description Item
 
Top of pagetop of page

Description

Field descriptions
 
Top of pagetop of page

Fields

Number of fields 2
 
1
Field name: RT_KEY
Data type: Positive Integer(Byte)
Original description:
Further descriptive information:

Code for Record Type

This is the key to the file. {Maximum length 1}

Missing value(s): [not permitted for this field]
Attributes:

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

From CRDA/17/DS/1/1 to BATDATA (CRDA/17/DS/1/1/1)

via the field RTYPE_CODE


Values range from 1 to 5
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
2
Field name: RT_TEXT
Data type: Variable Length String
Original description: Type of record
Further descriptive information:

Record Type: description of how the bats were identified

{Maximum length 20}

Missing value(s): [not permitted for this field]
Attributes:
Constraints: This field may take any value appropriate to its datatype.
Encoding: [No encoding used]
 
 
Top of pagetop of page

* maximum list length 500

 
 

NDAD v3.0