Description: Coded values used to determine which identifier to use for a specific purpose. HL7 Value Set.
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKIDENTIFIERTYPEID |
INT |
|
|
Description: The unique Id for the LkIdentifierType table
|
|
Name |
Type |
|
| 2 |
SYSTEM |
NVARCHAR |
|
|
Description: Coding System Utilized
|
|
Name |
Type |
|
| 3 |
CODE |
NVARCHAR |
|
|
Description: Value that identifies a concept as defined by the code system
|
|
Name |
Type |
|
| 4 |
DESCRIPTION |
NVARCHAR |
|
|
Description: Detailed Description
|
|
Name |
Type |
|
| 5 |
EDITABLE |
BIT |
|
|
Description: Editable flag
|
|
Name |
Type |
|
| 6 |
STARTDATE |
DATE |
|
|
Description: Start / Effective Date
|
|
Name |
Type |
|
| 7 |
ENDDATE |
DATE |
|
|
Description: End / Discontinue Date
|
|
Name |
Type |
|
| 9 |
CREATED |
DATETIMEOFFSET |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 11 |
LASTMODIFIED |
DATETIMEOFFSET |
|
|
Description: Record Last Modified time
|