| |
|
|
|
|
| |
Top of page
|
Summary |
| Title |
Visit Codes Lookup Table. |
| NDAD reference |
CRDA/17/DS/1/1/11 |
| Scope & content |
Acts as a lookup table for values entered in the VISIT_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 |
VISIT_CODES |
| Number of records |
2 |
| SIZE of file (bytes) |
26 |
| Maximum record size (bytes) |
14 |
| ISAD(G) level of description |
Item |
|
| |
| Top of page
|
Description |
| Field descriptions |
|
|
| |
| Top of page
|
Fields |
| Number of fields |
2 |
| |
|
| 1 |
| Field name: |
KEY |
| Data type: |
Positive Integer(Byte) |
| Original description: |
Visit code |
| Further descriptive information: |
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 VISIT_CODE
Values range from 1 to 2 |
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
DESC |
| Data type: |
Variable Length String |
| Original description: |
Description |
| Further descriptive information: |
Category of the visitor {Maximum length 12} |
| 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/11
