| |
|
|
|
|
| |
Top of page
|
Summary |
| Title |
Bat Species Lookup Table |
| NDAD reference |
CRDA/17/DS/1/1/8 |
| Scope & content |
Acts as a lookup table for the SPECIES_CODE field in the BATDATA table, providing the English and scientific names of the bat species. |
| 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 page
|
Identity statement |
| Table name |
SPECIES_CODES |
| Number of records |
20 |
| SIZE of file (KB) |
1.17 |
| Maximum record size (bytes) |
80 |
| ISAD(G) level of description |
Item |
|
| |
| Top of page
|
Description |
| Field descriptions |
|
|
| |
| Top of page
|
Fields |
| Number of fields |
5 |
| |
|
| 1 |
| Field name: |
CODE |
| Data type: |
Positive Integer(Byte) |
| Original description: |
Species code |
| Further descriptive information: |
This is the key to the file. {Maximum length 2} |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
This field forms a 1 - Many relationship with the following tables: via the field SPECIES_CODE
Values range from 0 to 19 |
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
ENGNAME |
| Data type: |
Variable Length String |
| Original description: |
English name of species |
| Further descriptive information: |
{Maximum length 22} |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 3 |
| Field name: |
SCINAME |
| Data type: |
Variable Length String |
| Original description: |
Scientific name of species |
| Further descriptive information: |
{Maximum length 26} |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 4 |
| Field name: |
SPNAME |
| Data type: |
Variable Length String |
| Original description: |
Short name for species |
| Further descriptive information: |
{Maximum length 15} |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 5 |
| Field name: |
RCODE |
| Data type: |
Positive Integer(Short) |
| Original description: |
Recorder species code |
| Further descriptive information: |
{Maximum length 14}. Recorder is software, also written in Advanced Revelation, used by many Biological Records Centres. It was originally written by English Nature and became available semi-commercially. |
| 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 page
|
* maximum list length 500
|
Table details: CRDA/17/DS/1/1/8
