XDSSubmissionSet.UniqueId identifies the submission set to which the documents belong. For use in tying all the documents together that came in the same submission set.
SiteDE
[dbo].[dict_id]
5
NOT NULL
((0))
Site. Link to Site_DE.ID.
OrgID
numeric(8,0)
5
NOT NULL
((0))
Organization. Link to Organization.ID.
RegSystem
varchar(255)
255
NOT NULL
('')
Registration System
SendingDirectID
varchar(255)
255
NOT NULL
('')
Sending Direct ID on the Submission Set
RecipientDirectIDList
varchar(1000)
1000
NOT NULL
('')
Recipient Direct ID list. Note: Only one recipient supported in Touchworks, so the rest remain as a static list to be presented in the task.
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Date created
LastUpdatedDTTM
datetime
8
NOT NULL
(getdate())
Date last updated
LockedDTTM
datetime2
8
NULL allowed
Time record was locked for patient matching
LockedByID
[dbo].[uniqueid]
9
NULL allowed
User who locked record for patient matching. Link to IDX_User.ID