Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PIXEntries
Touchworks 25.2
[dbo].[PIXEntries]
MS_Description
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.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient Identifier. Link to Person.ID
UserID
[dbo].[uniqueid]
9
NOT NULL
User Identifier. Link to IDX_User table
OldPatientID
[dbo].[uniqueid]
9
NOT NULL
Previous Patient Identifier. Link to Person.ID
Status
varchar(8)
8
NULL allowed
Status
SiteDE
[dbo].[dict_id]
5
NOT NULL
Site Identifier. Link to Site_DE.ID
RegSystem
varchar(255)
255
NULL allowed
Registration System Name
LastUpdatedDTTM
datetime
8
NULL allowed
Last edited date and time