| |
|
|
|
|
| |
Top of page
|
Summary |
| Title |
Enquiry Types Lookup Table |
| NDAD reference |
CRDA/17/DS/1/1/3 |
| Scope & content |
Acts as a lookup table for the ENQTYPE_CODE field in the BATDATA table |
| 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 |
ENQUIRY_TYPES |
| Number of records |
14 |
| SIZE of file (bytes) |
488 |
| Maximum record size (bytes) |
43 |
| ISAD(G) level of description |
Item |
|
| |
| Top of page
|
Description |
| Field descriptions |
|
|
| |
| Top of page
|
Fields |
| Number of fields |
2 |
| |
|
| 1 |
| Field name: |
ENQUIRY_KEY |
| Data type: |
Positive Integer(Byte) |
| Original description: |
Key to Enquiry_Types. Numeric code |
| Further descriptive information: |
Code for type of enquiry This is the key to the file. {Maximum length 4}. Note that in the third record in this file, WCA = Wildlife and Countryside Act 1981 |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
This field forms a 1 - Many relationship with the following tables: via the field ENQTYPE_CODE
Values range from 1 to 14 |
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
ENQUIRY_TEXT |
| Data type: |
Variable Length String |
| Original description: |
Description of enquiry type |
| Further descriptive information: |
{Maximum length 40} |
| 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/3
