Description: Identifier table
Column Name |
Ordinal Position |
|
|
Name |
Type |
|
1 |
IDENTIFIERID |
INT |
|
|
Description: The unique Id for the Identifier table
|
|
Name |
Type |
|
2 |
LKIDENTIFIERUSEID |
INT |
|
|
Description: LkIdentifierUseId is a foreign key to the LkIdentifierUse table
|
|
Name |
Type |
|
3 |
LKIDENTIFIERTYPEID |
INT |
|
|
Description: LkIdentifierTypeId is a foreign key to the LkIdentifierType table
|
|
Name |
Type |
|
4 |
SYSTEM |
NVARCHAR |
|
|
Description: The code system associated with this identifier
|
|
Name |
Type |
|
5 |
VALUE |
NVARCHAR |
|
|
Description: The value of the identifier
|
|
Name |
Type |
|
6 |
STARTDATE |
DATE |
|
|
Description: The start date of the identifier
|
|
Name |
Type |
|
7 |
ENDDATE |
DATE |
|
|
Description: The end date of the identifier
|
|
Name |
Type |
|
8 |
ASSIGNERORGANIZATIONID |
INT |
|
|
Description: AssignerOrganizationId is a foreign key to the Organization table
|