Tables [dbo].[CED_Endpoints]
CED Messaging connected systems
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Key UQ_CED_Endpoints_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to theCED_Endpoints table.
Primary Key PK_CED_Endpoints_ID: CommunityCodeCommunityCode[dbo].[name]255NOT NULLUnique Code identifying the messaging enabled community
CommunityName[dbo].[name]255NOT NULLName identifying the messaging enabled community
XDSReg[dbo].[name]255NOT NULLCross-Enterprise Document Registry
XDSRep[dbo].[name]255NOT NULLCross-Enterprise Document Repository
LastUpdateDTTMdatetime8NOT NULLDatetime this entry was last updated
PixManager[dbo].[name]255NOT NULLPatient Information Exchange Identifier
Check Constraints CK_CED_Endpoints_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLInactive entry indicator
AutoSubmitFLAGvarchar(10)10NOT NULL('N')Message Auto Submission Enabled to this Community
Check Constraints CK_CED_Endpoints_Direct_HISP_Yes_Or_No : ([Direct_HISP]='N' OR [Direct_HISP]='Y')Direct_HISP[dbo].[BOOL]1NOT NULL('N')Direct Health Information Service Provider FLAG
Foreign Keys FK_CED_Endpoints_DocumentTypeDE: [dbo].[Document_Type_de].DocumentTypeDEDocumentTypeDE[dbo].[dict_id]5NOT NULLDocument Type. Link to Document_Type_DE.ID
IsFMHPortalbit1NOT NULL((0))Is this the Follow My Health Portal (Y/N)?