Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.
Derivation Tables
Derivation | |||
Name | Type | Properties | Notes |
termLc1 | CHAR(99) | Index Key | Uninflected Term 1 in lowercase |
term1 | CHAR(99) | Uninflected Term 1 | |
cat1 | INT | Category 1 | |
eui1 | CHAR(8) | EUI 1 | |
termLc2 | CHAR(99) | Index | Uninflected Term 2 in LowerCase |
term2 | CHAR(99) | Uninflected Term 2 | |
cat2 | INT | Category 2 | |
eui2 | CHAR(8) | EUI 2 | |
nagation | CHAR(1) | N|O for negative or otherwise derivation | |
type | CHAR(1) | P|S|Z for prefix, suffix, or zero derivation | |
prefix | CHAR(10) | prefix or "none" for suffixD and zeroD |
Notes:
The maximum length for term1 is 96. We use CHAR(99) for this column.
The maximum length for term2 is 96. We use CHAR(99) for this column.
The maximum length for prefix is 8. We use CHAR(10) for this column.