Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to theCED_Endpoints table. |
 | CommunityCode | [dbo].[name] | 255 | NOT NULL | | | Unique Code identifying the messaging enabled community |
| CommunityName | [dbo].[name] | 255 | NOT NULL | | | Name identifying the messaging enabled community |
| XDSReg | [dbo].[name] | 255 | NOT NULL | | | Cross-Enterprise Document Registry |
| XDSRep | [dbo].[name] | 255 | NOT NULL | | | Cross-Enterprise Document Repository |
| LastUpdateDTTM | datetime | 8 | NOT NULL | | | Datetime this entry was last updated |
| PixManager | [dbo].[name] | 255 | NOT NULL | | | Patient Information Exchange Identifier |
![Check Constraints CK_CED_Endpoints_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_CED_Endpoints_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Inactive entry indicator |
| AutoSubmitFLAG | varchar(10) | 10 | NOT 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') Check Constraints CK_CED_Endpoints_Direct_HISP_Yes_Or_No : ([Direct_HISP]='N' OR [Direct_HISP]='Y')](../../../../Images/c-constraint.png) | Direct_HISP | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Direct Health Information Service Provider FLAG |
![Foreign Keys FK_CED_Endpoints_DocumentTypeDE: [dbo].[Document_Type_de].DocumentTypeDE Foreign Keys FK_CED_Endpoints_DocumentTypeDE: [dbo].[Document_Type_de].DocumentTypeDE](../../../../Images/fk.png) | DocumentTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Document Type. Link to Document_Type_DE.ID |
| IsFMHPortal | bit | 1 | NOT NULL | | ((0)) | Is this the Follow My Health Portal (Y/N)? |