Term
Terms are communicated “inline” in most data types so you will not find records for all terms used in each of the data records in the data set. The terms file includes terms that have been modified in the time frame appropriate to the data set. Typically the only field that would be modified on a term would be the “Name” or description.
| Field | Type | Length | Allow Null | Natural Key | Description | |
|---|---|---|---|---|---|---|
| 1 | Record Type ID | String |
Indicates the record type. For this record it will always be “Term”. |
|||
| 2 | ID | Int |
Surrogate Key |
|||
| 3 | Code | String | 128 |
A code for a given term, could be numeric or a string based code. Generally, received from a sources coding system. Could be nationally recognized vocabularies like ICD, CPT, SNOMED. |
||
| 4 | Name | String | 500 |
A name for a given term. This would be the description of the term. |
||
| 5 | Namespace Code | String | 128 |
Identifier for a given Terms source. Typically, the name of the source system |
||
| 6 | Family | String | 50 |
Family is an identifier used to group like terms together. |
||
| 7 | Inserted Audit Data | Audit |
Audit data for when the record was inserted/created |
|||
| 8 | Last Modified Audit Data | Audit |
Audit data for when the record was last modified |
