Tables [dbo].[PIXEntries]
Patient Identifier Cross Referencing (PIX) Entries. A PIX Feed is used to generate an ADT type message. Only used for clients with PIX Feed’s.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key cix_PIXEntries_PatientID: PatientIDForeign Keys FK_PIXEntries_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient Identifier. Link to Person.ID
UserID[dbo].[uniqueid]9NOT NULLUser Identifier. Link to IDX_User table
OldPatientID[dbo].[uniqueid]9NOT NULLPrevious Patient Identifier. Link to Person.ID
Statusvarchar(8)8NULL allowedStatus
SiteDE[dbo].[dict_id]5NOT NULLSite Identifier. Link to Site_DE.ID
RegSystemvarchar(255)255NULL allowedRegistration System Name
LastUpdatedDTTMdatetime8NULL allowedLast edited date and time