Description: Internal lookup for anatomical body structures
Column Name |
Ordinal Position |
|
Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
1 |
LKBODYSITEID |
INT |
|
|
Description: The unique Id for the LkBodySite table
|
|
Name |
Type |
|
2 |
SYSTEM |
NVARCHAR |
|
|
Description: The URI or OID of the defining terminology system
|
|
Name |
Type |
|
3 |
DISPLAY |
NVARCHAR |
|
|
Description: The user facing display value for the code
|
|
Name |
Type |
|
4 |
ABB |
NVARCHAR |
|
|
Description: Abbreviation of the body site
|
|
Name |
Type |
|
5 |
ACTIVE |
DATETIME2 |
|
|
Description: When this record became active
|
|
Name |
Type |
|
6 |
INACTIVE |
DATETIME2 |
|
|
Description: When this record became inactive
|