| |
|
|
|
|
| |
Top of page
|
Summary |
| Title |
Site Types Lookup Table |
| NDAD reference |
CRDA/17/DS/1/1/7 |
| Scope & content |
Acts as a lookup table for the SITE_TYPE 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 |
SITE_TYPES |
| Number of records |
14 |
| SIZE of file (bytes) |
710 |
| Maximum record size (bytes) |
84 |
| ISAD(G) level of description |
Item |
|
| |
| Top of page
|
Description |
| Field descriptions |
|
|
| |
| Top of page
|
Fields |
| Number of fields |
3 |
| |
|
| 1 |
| Field name: |
TYPE_KEY |
| Data type: |
Fixed Length String (length 1) |
| Original description: |
|
| Further descriptive information: |
Code for type of Site This is the key to the file. {Maximum length 3} |
| Missing value(s): |
[not permitted for this field] |
| Attributes: |
This field forms a 1 - Many relationship with the following tables: via the field SITE_TYPE |
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
TYPE_WORD |
| Data type: |
Variable Length String |
| Original description: |
|
| Further descriptive information: |
Type of Site {Maximum length 14} |
| 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: |
EXPLAIN |
| Data type: |
Variable Length String |
| Original description: |
Fuller explanation of code |
| Further descriptive information: |
Explanation of Site Type {Maximum length 40} |
| Missing value(s): |
One or more spaces |
| 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/7
