Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 ![Foreign Keys FK_Organization_ID_Business_Entity_ID: [dbo].[Business_Entity].ID Foreign Keys FK_Organization_ID_Business_Entity_ID: [dbo].[Business_Entity].ID](../../../../Images/fk.png) | ID | numeric(8,0) | 5 | NOT NULL | | Key to the Organization table. |
| Name | varchar(60) | 60 | NOT NULL | | Organization Name |
![Check Constraints CK_Organization_ExternalOrganizationFLAG_Yes_Or_No : ([ExternalOrganizationFLAG]='N' OR [ExternalOrganizationFLAG]='Y') Check Constraints CK_Organization_ExternalOrganizationFLAG_Yes_Or_No : ([ExternalOrganizationFLAG]='N' OR [ExternalOrganizationFLAG]='Y')](../../../../Images/c-constraint.png) | ExternalOrganizationFLAG | [dbo].[BOOL] | 1 | NOT NULL | | External Organization (Y/N) |
![Check Constraints CK_Organization_IsEnterpriseFLAG_Yes_Or_No : ([IsEnterpriseFLAG]='N' OR [IsEnterpriseFLAG]='Y') Check Constraints CK_Organization_IsEnterpriseFLAG_Yes_Or_No : ([IsEnterpriseFLAG]='N' OR [IsEnterpriseFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnterpriseFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Enterprise (Y/N). THe enterprise is always ID = 0 |
![Check Constraints CK_Organization_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Organization_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Inactive (Y/N) |
![Check Constraints CK_Organization_HasADTInterfaceFlag_Yes_Or_No : ([HasADTInterfaceFlag]='N' OR [HasADTInterfaceFlag]='Y') Check Constraints CK_Organization_HasADTInterfaceFlag_Yes_Or_No : ([HasADTInterfaceFlag]='N' OR [HasADTInterfaceFlag]='Y')](../../../../Images/c-constraint.png) | HasADTInterfaceFlag | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is the an ADT (Admission, Discharge, and Transfer) interface for this organization (Y/N) |
| BaseRate | numeric(4,3) | 5 | NULL allowed | (0.100) | Base rate for dictations |
| CharactersPerLine | numeric(4,1) | 5 | NULL allowed | (65.0) | Charaters per line for dictations |
![Foreign Keys FK_Organization_OrgSharingDE_Org_Sharing_DE_ID: [dbo].[Org_Sharing_DE].OrgSharingDE Foreign Keys FK_Organization_OrgSharingDE_Org_Sharing_DE_ID: [dbo].[Org_Sharing_DE].OrgSharingDE](../../../../Images/fk.png) | OrgSharingDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Organization sharing pool. link to Org_Sharing_DE.ID. Organizations in the same pool share patient charts with all other organizations in the same sharing pool.. Organizations in sharing pool 0 do not share patient charts. |
![Check Constraints CK_Organization_ConnectARNFLAG_Yes_Or_No : ([ConnectARNFLAG]='N' OR [ConnectARNFLAG]='Y') Check Constraints CK_Organization_ConnectARNFLAG_Yes_Or_No : ([ConnectARNFLAG]='N' OR [ConnectARNFLAG]='Y')](../../../../Images/c-constraint.png) | ConnectARNFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Organization is connected to the Allscripts Referral network (Y/N) |
![Check Constraints CK_Organization_ParticipateInDataExchangeFlag_Yes_Or_No : ([ParticipateInDataExchangeFlag]='N' OR [ParticipateInDataExchangeFlag]='Y') Check Constraints CK_Organization_ParticipateInDataExchangeFlag_Yes_Or_No : ([ParticipateInDataExchangeFlag]='N' OR [ParticipateInDataExchangeFlag]='Y')](../../../../Images/c-constraint.png) | ParticipateInDataExchangeFlag | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Whether the organization participates in the Allscripts Data Exchange (Y/N)? |
![Check Constraints CK_Organization_ParticipateInCommunityIntegrationFlag_Yes_Or_No : ([ParticipateInCommunityIntegrationFlag]='N' OR [ParticipateInCommunityIntegrationFlag]='Y') Check Constraints CK_Organization_ParticipateInCommunityIntegrationFlag_Yes_Or_No : ([ParticipateInCommunityIntegrationFlag]='N' OR [ParticipateInCommunityIntegrationFlag]='Y')](../../../../Images/c-constraint.png) | ParticipateInCommunityIntegrationFlag | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Organization participates in a community (Y/N)? |
| CommunityOID | varchar(75) | 75 | NOT NULL | ('') | Organization Identifier (OID) for communitiy integration. |
| PatientMRNForCommunity | varchar(50) | 50 | NOT NULL | ('') | Which MRN (Medical Record number) to use with Community Integration (Organization or Enterprise) |