Description: Describes entities and processes involved in producing and delivering or otherwise influencing a resource Provenance provides a critical foundation for assessing authenticity, enabling trust, and allowing reproducibility
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| LOCATIONID |
14 |
LOCATION
|
|
|
Name |
Type |
|
| 1 |
PROVENANCEID |
INT |
|
|
Description: The unique Id as int for the Provenance table
|
|
Name |
Type |
|
| 2 |
UUID |
UNIQUEIDENTIFIER |
|
|
Description: The unique Id as guid for the Provenance table
|
|
Name |
Type |
|
| 3 |
FHIRLASTUPDATEDDATETIME |
DATETIME2 |
|
|
Description: The date / time the record was last updated
|
|
Name |
Type |
|
| 4 |
FHIRLASTUPDATEDDATETIMEOFFSET |
INT |
|
|
Description: The date / time offset the record was last updated
|
|
Name |
Type |
|
| 5 |
TEXT |
NVARCHAR |
|
|
Description: A human-readable narrative that contains a summary of the resource and can be used to represent the content of the resource to a human The narrative need not encode all the structured data, but is required to contain sufficient detail to make it clinically safe for a human to just read the narrative Resource definitions may define what content should be represented in the narrative to ensure clinical safety
|
|
Name |
Type |
|
| 6 |
OCCURREDDATETIME |
DATETIME2 |
|
|
Description: The date / time during which the activity occurred
|
|
Name |
Type |
|
| 7 |
OCCURREDDATETIMEOFFSET |
INT |
|
|
Description: The date / time offset of the period during which the activity occurred
|
|
Name |
Type |
|
| 8 |
OCCURREDPERIODSTARTDATETIME |
DATETIME2 |
|
|
Description: The start date/time during which the activity occurred
|
|
Name |
Type |
|
| 9 |
OCCURREDPERIODSTARTDATETIMEOFFSET |
INT |
|
|
Description: The start date / time offset during which the activity occurred
|
|
Name |
Type |
|
| 10 |
OCCURREDPERIODENDDATETIME |
DATETIME2 |
|
|
Description: The end date / time during which the activity occurred
|
|
Name |
Type |
|
| 11 |
OCCURREDPERIODENDDATETIMEOFFSET |
INT |
|
|
Description: The end date/time offset during which the activity occurred
|
|
Name |
Type |
|
| 12 |
RECORDEDDATETIME |
DATETIME2 |
|
|
Description: The date / time at which the activity was recorded
|
|
Name |
Type |
|
| 13 |
RECORDEDDATETIMEOFFSET |
INT |
|
|
Description: The date / time offset at which the activity was recorded
|
|
Name |
Type |
|
| 14 |
LOCATIONID |
INT |
|
|
Description: Where the activity occurred, if relevant. LocationId is a foreign key to the Location table
|