Tables [dbo].[Inbound_SubmissionSet]
Submission sets coming from an external source. Currently, this will only hold referrals coming from non-Allscripts sources.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Inbound_SubmissionSet_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Inbound_SubmissionSet table
Indexes NIX_Inbound_SubmissionSet_PatientIDForeign Keys FK_Inbound_SubmissionSet_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULL((0))Patient. Link to Patient_Member.ID
TaskID[dbo].[uniqueid]9NOT NULL((0))Task. Link to IDX_Task.ID.
SubmissionSetUniqueIdvarchar(256)256NOT NULL('')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.
Foreign Keys FK_Inbound_SubmissionSet_SiteDE_Site_DE_ID: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULL((0))Site. Link to Site_DE.ID.
Foreign Keys FK_Inbound_SubmissionSet_OrgID_Organization_ID: [dbo].[Organization].OrgIDOrgIDnumeric(8,0)5NOT NULL((0))Organization. Link to Organization.ID.
RegSystemvarchar(255)255NOT NULL('')Registration System
SendingDirectIDvarchar(255)255NOT NULL('')Sending Direct ID on the Submission Set
RecipientDirectIDListvarchar(1000)1000NOT 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.
CreatedDTTMdatetime8NOT NULL(getdate())Date created
LastUpdatedDTTMdatetime8NOT NULL(getdate())Date last updated
LockedDTTMdatetime28NULL allowedTime record was locked for patient matching
LockedByID[dbo].[uniqueid]9NULL allowedUser who locked record for patient matching. Link to IDX_User.ID
CommunityID[dbo].[uniqueid]9NULL allowedCommunity. Link to CED_Endpoints.ID