Tables [dbo].[Person_XID]
This table is a cross reference between external PM systems and Our Person table
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes xCPerson_XID_IDForeign Keys FK_Person_XID_ID_Person_ID: [dbo].[Person].IDID[dbo].[uniqueid]9NOT NULLIdentifier for this record that points to the ID in the Person table.
Cluster Primary Key PK_Person_XID_ID_PersonXID: PersonXID\RegSystemIndexes TWstat_Person_XID_JITFlag_PersonXID_RegSystem, TWstat_Person_XID_RegSystem_PersonXID(2)PersonXIDvarchar(255)255NOT NULLThis is the value maintained by the External system for the Patient
Cluster Primary Key PK_Person_XID_ID_PersonXID: PersonXID\RegSystemIndexes TWstat_Person_XID_JITFlag_PersonXID_RegSystem, TWstat_Person_XID_RegSystem_PersonXID(2)RegSystemvarchar(80)80NOT NULLThis 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
Indexes TWstat_Person_XID_JITFlag_PersonXID_RegSystemCheck Constraints CK_Person_XID_JITFlag_Yes_Or_No : ([JITFlag]='N' OR [JITFlag]='Y')JITFlag[dbo].[BOOL]1NOT NULLThis hold a flag indicating whether the record was added through JIT processing ([JITFlag]='N' OR [JITFlag]='Y')