Description: A person who is directly or indirectly involved in the provisioning of healthcare
Column Name |
Ordinal Position |
|
Column Name |
Ordinal Position |
Referenced Table |
|
LKBIRTHSEXID |
9 |
LKBIRTHSEX
|
|
|
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
|