Description: Tracking table to keep a log of the different locations a patient / encounter has used throughout the encounter
| Column Name |
Ordinal Position |
|
|
Name |
Type |
|
| 1 |
ENCOUNTERLOCATIONID |
INT |
|
|
Description: The unique Id for the EncounterLocation table
|
|
Name |
Type |
|
| 2 |
UUID |
UNIQUEIDENTIFIER |
|
|
Description: The universally unique Id for the record
|
|
Name |
Type |
|
| 3 |
ENCOUNTERID |
INT |
|
|
Description: EncounterId is a foreign key to the Encounter table
|
|
Name |
Type |
|
| 4 |
LOCATIONID |
INT |
|
|
Description: LocationId is a foreign key to the Location table
|
|
Name |
Type |
|
| 5 |
LKENCOUNTERLOCATIONSTATUSID |
INT |
|
|
Description: LkEncounterLocationStatusId is a foreign key to the LkEncounterLocationStatus table
|
|
Name |
Type |
|
| 6 |
PERIODSTARTDATETIME |
DATETIMEOFFSET |
|
|
Description: Period Start date time in UTC
|
|
Name |
Type |
|
| 7 |
PERIODSTARTDATETIMEOFFSET |
INT |
|
|
Description: Offset for the locationid
|
|
Name |
Type |
|
| 8 |
PERIODENDDATETIME |
DATETIMEOFFSET |
|
|
Description: Period End date time in UTC
|
|
Name |
Type |
|
| 9 |
PERIODENDDATETIMEOFFSET |
INT |
|
|
Description: Offset for the locationid
|
|
Name |
Type |
|
| 11 |
CREATEDDATETIME |
DATETIMEOFFSET |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 13 |
LASTMODIFIEDDATETIME |
DATETIMEOFFSET |
|
|
Description: Record Last Modified time
|