| |
| Table title |
Institutions (from the old INST table) |
| NDAD reference |
CRDA/12/DS/3/31 |
| Table name |
T_INST_FROM_INST |
| Dataset |
Final database |
| Scope and content |
The documentation produced by LISU listing the 'DOMUS Table names and their content' (see Documentation Catalogue CRDA/12/DD/7/6) gives the 'Content' of this table as 'Old coding for institutions''. It is thought, and this is perhaps indicated by the name of the table, that this table contains a subset of the data (on institutions) held in the INST table (ie CRDA/12/DS/2/5) in the DOMUS system.
|
| 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 |
8 |
| Number of Records |
528 |
| |
| Fields |
|
|
| 1 |
ONO
|
Positive Integer(Short) |
Unique identifer of the Institution. |
| 2 |
ONO_OLD
|
Fixed Length String |
Previous identifier of the institution. |
| 3 |
ORGNAME
|
Variable Length String |
Name of the organisation. |
| 4 |
ORGTYPE
|
Positive Integer(Short) |
Organisation type |
| 5 |
TELEPHONE
|
Variable Length String |
Organisation Telephone number. |
| 6 |
FAX
|
Variable Length String |
FAX number. |
| 7 |
ADDRID
|
Positive Integer(Short) |
Code indicating the address record (ie in table ADDRESS). |
| 8 |
POSTCODE
|
Variable Length String |
Postcode of the organisation. |
|
| |
|
|
| |
* maximum list length: 1000
derived field: § key field: ¤
|
Contact us
Table details: CRDA/12/DS/3/31
