PAT_FHIR_MERGE_UNMERGE_HX
Description:
This table contains history of merge/unmerge info received via FHIR from another organization.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 RCVD_UTC_DTTM DATETIME (UTC) No
The instant of update when merge/unmerge info is received.
4 ORG_IDENTIFIER VARCHAR No
The unique identifier for an organization that sent merge/unmerge information for the patient.
5 SRC_PAT_FHIR_IDENTIFIER VARCHAR No
Other organization's original source patient FHIR ID.
6 MERGE_UNMERGE_UTC_DTTM DATETIME (UTC) No
Other organization's merge/unmerge event instant for this patient.
7 MERGE_ACTION_TYPE_C_NAME VARCHAR No
Other organization's merge/unmerge action type for this patient.
May contain organization-specific values: No
Category Entries:
Merge
Unmerge
8 RVCD_DTTM DATETIME (Local) No
The instant of update when merge/unmerge info is received in the local time.
9 MERGE_UNMERGE_DTTM DATETIME (Local) No
Other organization's merge/unmerge event instant for this patient in the local time.