IDENTIFIER
Description: Identifier table

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKIDENTIFIERUSEID 2 LKIDENTIFIERUSE
LKIDENTIFIERTYPEID 3 LKIDENTIFIERTYPE
ASSIGNERORGANIZATIONID 8 ORGANIZATION

Column Information
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