| |
| Table title |
Roles of main contact |
| NDAD reference |
CRDA/12/DS/3/18 |
| Table name |
ROLE |
| Dataset |
Final database |
| Scope and content |
"Role of main contact in coded form". This table holds information on the roles (eg Domus Contact, Curatorial Adviser) filled by persons for institutions. Note that the schematic diagram of the MGC Core Database (see the Documentation Catalogue, reference CRDA/12/DD/6/1) identifies 2 relationships between this table and INST ie ONO_A ONO and ONO_B ONO; currently only the latter has been implemented within the NDAD system (ie the relationship between ONO_A and ONO is not functioning)
|
| 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.
|
| Number of Fields |
7 |
| Number of Records |
2,969 |
| |
| Fields |
|
|
| 1 |
ONO_A
¤
|
Positive Integer(Short) |
Unique identifer of the first institution |
| 2 |
ONO_B
¤
|
Positive Integer(Short) |
Unique identifer of the second institution |
| 3 |
PERSON
¤
|
Positive Integer(Short) |
Unique identifer of the Person filling the ROLE |
| 4 |
FROM_DATE
|
Date as Variable Length String |
Date of commencement of role |
| 5 |
TO_DATE
|
Date as Variable Length String |
Date of end of role |
| 6 |
ROLE_TYPE
|
Positive Integer(Byte) |
Role of the person |
| 7 |
ADDRID
¤
|
Positive Integer(Short) |
Code for Address of the person |
|
| |
|
|
| |
* maximum list length: 1000
derived field: § key field: ¤
|
Contact us
Table details: CRDA/12/DS/3/18
