Tables [dbo].[Reconciled_List]
data related to the reconciliation of Medication and Allergy Orders including the User ID for the reconciling User
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Reconciled_List: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Reconciled_List table
Indexes NIX_reconciled_list_PatientIDForeign Keys FK_Reconciled_List_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
UserID[dbo].[uniqueid]9NOT NULLReconciling User ID. Link to IDX_User.ID
Indexes NIX_Reconciled_List_EncounterID_ItemType_Inc_RecordedDTTMEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes NIX_Reconciled_List_EncounterID_ItemType_Inc_RecordedDTTMRecordedDTTMdatetime8NOT NULLRecorded Date
Indexes NIX_Reconciled_List_EncounterID_ItemType_Inc_RecordedDTTMItemTypechar(2)2NOT NULLItem Type i.e. ME,AL