| |
| Table title |
Supplemental data |
| NDAD reference |
CRDA/12/DS/3/24 |
| Table name |
SUPPLEMENTAL |
| Dataset |
Final database |
| Scope and content |
"All the supplement details in coded form." This table holds the results of the 4 supplementary questionnaires.
|
| 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 |
10 |
| Number of Records |
548,155 |
| |
| Fields |
|
|
| 1 |
ONO
¤
|
Positive Integer(Short) |
Unique identifer of the Institution. |
| 2 |
SUPPL_ID
|
Positive Integer(Byte) |
Supplement year. Links to the CODES table where CODE_TYPE = SUPP. The CODE and DESCR ... |
| 3 |
QCYEAR
|
Positive Integer(Short) |
Year questionnaire sent out. |
| 4 |
CODE
|
Positive Integer(Short) |
Links to the CODES table where CODE_TYPE = S001,2,3,4 (depending on the supplementary... |
| 5 |
DOMCYEAR
|
Positive Integer(Short) |
The year to which the data relates (normally the year preceding QYEAR). |
| 6 |
EDIT_DATE
|
Date as Variable Length String |
Presumably the date when the record was last edited. |
| 7 |
ANS_VALUE
|
Double-Precision Floating-Point |
The answer to the question if the answer is a number. |
| 8 |
ANS_CODE
|
Yes/No |
The answer to the question if the answer is a code eg Y. |
| 9 |
ANS_DATE
|
Date as Variable Length String |
The answer to the question if the answer is a date. |
| 10 |
ANS_TEXT
|
Variable Length String |
The answer to the question if the answer is text. |
|
| |
|
|
| |
* maximum list length: 1000
derived field: § key field: ¤
|
Contact us
Table details: CRDA/12/DS/3/24
