PRACTITIONER
Description: A person who is directly or indirectly involved in the provisioning of healthcare

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKBIRTHSEXID 9 LKBIRTHSEX

Column Information
Name Type
1 PRACTITIONERID INT
Description: The unique Id for the Practitioner table
Name Type
2 UUID UNIQUEIDENTIFIER
Description: The unique identifier of the practitioner
Name Type
3 PREFIX NVARCHAR
Description: The practitioner's name prefix
Name Type
4 FIRSTNAME NVARCHAR
Description: The practitioner's first name
Name Type
5 MIDDLENAME NVARCHAR
Description: The practitioner's middle name
Name Type
6 LASTNAME NVARCHAR
Description: The practitioner's last name
Name Type
7 SUFFIX NVARCHAR
Description: The practitioner's name suffix
Name Type
8 BIRTHDATE DATE
Description: The practitioner's birth date
Name Type
9 LKBIRTHSEXID INT
Description: LkBirthSexId is a foreign key to the LkBirthSex table
Name Type
10 CREATED DATETIME2
Description: Record created time
Name Type
12 LASTMODIFIED DATETIME2
Description: Record Last Modified time
Name Type
14 TEMPPHYSICIANID INT
Description: The temporary physician id for the practitioner
Name Type
15 CDAPREFERENCES NVARCHAR
Description: The practitioner's CDA preferences