Tables [dbo].[Organization]
Organization.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Organization_ID: IDForeign Keys FK_Organization_ID_Business_Entity_ID: [dbo].[Business_Entity].IDIDnumeric(8,0)5NOT NULLKey to the Organization table.
Namevarchar(60)60NOT NULLOrganization Name
Check Constraints CK_Organization_ExternalOrganizationFLAG_Yes_Or_No : ([ExternalOrganizationFLAG]='N' OR [ExternalOrganizationFLAG]='Y')ExternalOrganizationFLAG[dbo].[BOOL]1NOT NULLExternal Organization (Y/N)
Check Constraints CK_Organization_IsEnterpriseFLAG_Yes_Or_No : ([IsEnterpriseFLAG]='N' OR [IsEnterpriseFLAG]='Y')IsEnterpriseFLAG[dbo].[BOOL]1NOT NULLEnterprise (Y/N). THe enterprise is always ID = 0
Check Constraints CK_Organization_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULL('N')Inactive (Y/N)
Check Constraints CK_Organization_HasADTInterfaceFlag_Yes_Or_No : ([HasADTInterfaceFlag]='N' OR [HasADTInterfaceFlag]='Y')HasADTInterfaceFlag[dbo].[BOOL]1NOT NULL('N')Is the an ADT (Admission, Discharge, and Transfer) interface for this organization (Y/N)
BaseRatenumeric(4,3)5NULL allowed(0.100)Base rate for dictations
CharactersPerLinenumeric(4,1)5NULL allowed(65.0)Charaters per line for dictations
Foreign Keys FK_Organization_OrgSharingDE_Org_Sharing_DE_ID: [dbo].[Org_Sharing_DE].OrgSharingDEOrgSharingDE[dbo].[dict_id]5NOT 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')ConnectARNFLAG[dbo].[BOOL]1NOT 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')ParticipateInDataExchangeFlag[dbo].[BOOL]1NOT 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')ParticipateInCommunityIntegrationFlag[dbo].[BOOL]1NOT NULL('N')Organization participates in a community (Y/N)?
CommunityOIDvarchar(75)75NOT NULL('')Organization Identifier (OID) for communitiy integration.
PatientMRNForCommunityvarchar(50)50NOT NULL('')Which MRN (Medical Record number) to use with Community Integration (Organization or Enterprise)