Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Person_XID
Touchworks 25.2
[dbo].[Person_XID]
MS_Description
This table is a cross reference between external PM systems and Our Person table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ID
[dbo].[uniqueid]
9
NOT NULL
Identifier for this record that points to the ID in the Person table.
(2)
PersonXID
varchar(255)
255
NOT NULL
This is the value maintained by the External system for the Patient
(2)
RegSystem
varchar(80)
80
NOT NULL
This contains a pointer to the RegSystem in the Reg_System_Map table. This column combined with the PersonXID make up a unique Key for the record
JITFlag
[dbo].[BOOL]
1
NOT NULL
This hold a flag indicating whether the record was added through JIT processing ([JITFlag]='N' OR [JITFlag]='Y')