| |
|
|
|
|
| |
Top of page
|
Summary |
| Title |
Organisations Lookup Table |
| NDAD reference |
CRDA/17/DS/1/1/5 |
| Scope & content |
Acts as a lookup table for the DEAL_CODE and INVOLVED fields in the BATDATA table, providing the name or type of the organisation. |
| 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 |
ORGANISATION_CODES |
| Number of records |
21 |
| SIZE of file (bytes) |
327 |
| Maximum record size (bytes) |
27 |
| ISAD(G) level of description |
Item |
|
| |
| Top of page
|
Description |
| Field descriptions |
|
|
| |
| Top of page
|
Fields |
| Number of fields |
2 |
| |
|
| 1 |
| Field name: |
ORG_CODE_KEY |
| Data type: |
Positive Integer(Byte) |
| Original description: |
|
| Further descriptive information: |
Code for organisation / type 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 DEAL_CODE
Values range from 1 to 21 |
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
ORG_CODE_NAME |
| Data type: |
Variable Length String |
| Original description: |
|
| Further descriptive information: |
Organisation name / type Note that ITE = Institute of Terrestrial , RSNC = Royal Society for Nature Conservation. {Maximum length 30} |
| 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/5
