Tables [dbo].[Site_DE]
The Site dictionary is a generic dictionary that is used to identify clinics where providers practice within a larger organization.        
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Site_DE_ID: IDCluster Key XAK1SiteDE: EntryName\IsCurrentFLAG\IDIndexes XAK2SiteDE, XAK3SiteDE, Site_DE_Nix_IDIIF, Nix_Site_DE_ID_OrganizationID, TWstat_Site_DE_Address1_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_Address2_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_AdminFrequency_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_City_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ClinicalMsgFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_IsCurrentFLAG_EntryName_ID, TWstat_Site_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneArea_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneExchange_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneLast4_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PrintRxCopyForFileFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ProvID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ZipCD_EntryName_IsCurrentFLAG_ID(21)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Site_DE table.
Indexes TWstat_Site_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Site_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_Site_DE_Entry_EntryName_IsCurrentFLAG_IDEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes XAK2SiteDEEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Cluster Key XAK1SiteDE: EntryName\IsCurrentFLAG\IDIndexes IX_Site_DE, TWstat_Site_DE_Address1_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_Address2_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_AdminFrequency_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_City_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ClinicalMsgFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_IsCurrentFLAG_EntryName_ID, TWstat_Site_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneArea_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneExchange_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneLast4_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PrintRxCopyForFileFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ProvID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ZipCD_EntryName_IsCurrentFLAG_ID(18)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3SiteDEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes Site_DE_Nix_IDIIFCheck Constraints CK_Site_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Indexes TWstat_Site_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Site_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1SiteDE: EntryName\IsCurrentFLAG\IDIndexes XAK2SiteDE, XAK3SiteDE, TWstat_Site_DE_Address1_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_Address2_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_AdminFrequency_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_City_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ClinicalMsgFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_IsCurrentFLAG_EntryName_ID, TWstat_Site_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneArea_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneExchange_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PhoneLast4_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_PrintRxCopyForFileFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ProvID_EntryName_IsCurrentFLAG_ID, TWstat_Site_DE_ZipCD_EntryName_IsCurrentFLAG_ID(19)Check Constraints CK_Site_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
Indexes TWstat_Site_DE_EffectiveDT_EntryName_IsCurrentFLAG_IDEffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Indexes Nix_Site_DE_ID_OrganizationIDOrganizationIDnumeric(18,0)9NULL allowedLink to Organization.ID
ACCT_IDchar(20)20NULL allowedPoints to Account.ACCT_ID, a unique identifier provided by Allscripts that is tied to the customer ID
Indexes IX_Site_DE_1SITE_IDchar(20)20NULL allowedA unique identifier generated when new sites are added.
Indexes TWstat_Site_DE_ProvID_EntryName_IsCurrentFLAG_IDProvIDchar(10)10NULL allowedUnused
Indexes TWstat_Site_DE_Address1_EntryName_IsCurrentFLAG_IDAddress1varchar(35)35NULL allowedFirst line of the address for the site
Indexes TWstat_Site_DE_Address2_EntryName_IsCurrentFLAG_IDAddress2varchar(35)35NULL allowedSecond line of the address for the site
Indexes TWstat_Site_DE_City_EntryName_IsCurrentFLAG_IDCityvarchar(20)20NULL allowedCity for the site
Statechar(2)2NULL allowedLink to State.State_Abbr
Indexes TWstat_Site_DE_ZipCD_EntryName_IsCurrentFLAG_IDZipCDchar(10)10NULL allowedZip code (optionally includes dash and zip 4)
Indexes TWstat_Site_DE_PhoneArea_EntryName_IsCurrentFLAG_IDPhoneAreasmallint2NOT NULL(0)Site telephone area code
Indexes TWstat_Site_DE_PhoneExchange_EntryName_IsCurrentFLAG_IDPhoneExchangesmallint2NOT NULL(0)Site telephone exchange
Indexes TWstat_Site_DE_PhoneLast4_EntryName_IsCurrentFLAG_IDPhoneLast4smallint2NOT NULL(0)Site telephone remaining four digits
Indexes TWstat_Site_DE_ClinicalMsgFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Site_DE_ClinicalMsgFLAG_Yes_Or_No : ([ClinicalMsgFLAG]='N' OR [ClinicalMsgFLAG]='Y')ClinicalMsgFLAG[dbo].[BOOL]1NOT NULL('Y')Y=show optional clinical messages to provider at login;  N=suppress
Indexes TWstat_Site_DE_PrintRxCopyForFileFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Site_DE_PrintRxCopyForFileFLAG_Yes_Or_No : ([PrintRxCopyForFileFLAG]='N' OR [PrintRxCopyForFileFLAG]='Y')PrintRxCopyForFileFLAG[dbo].[BOOL]1NOT NULL('N')Y=print an extra patient prescription copy on the default printer for the provider's records
Indexes TWstat_Site_DE_AdminFrequency_EntryName_IsCurrentFLAG_IDAdminFrequencyvarchar(12)12NOT NULL('0')Pipe-delimited schedule interval used by the Medication_Admin_Record job
PhoneExtensionchar(5)5NOT NULL('')Site telephone extension
FaxAreasmallint2NOT NULL(0)Site fax number area code
FaxExchangesmallint2NOT NULL(0)Site fax number exchange
FaxLast4smallint2NOT NULL(0)Site fax number remaining four digits
ContactLastNamevarchar(35)35NOT NULL('')Primary contact person last name
ContactFirstNamevarchar(18)18NOT NULL('')Primary contact person first name
ContactTitleNamevarchar(20)20NOT NULL('')Primary contact person job title
EmergencyAreasmallint2NOT NULL(0)Site emergency contact telephone area code
EmergencyExchangesmallint2NOT NULL(0)Site emergency contact telephone exchange
EmergencyLast4smallint2NOT NULL(0)Site emergency contact telephone remaining four digits
URLvarchar(255)255NULL allowedSite website URL
Foreign Keys FK_Site_DE_RegistryRegionDE_Registry_Region_DE_ID: [dbo].[Registry_Region_DE].RegistryRegionDERegistryRegionDE[dbo].[dict_id]5NOT NULL((0))Link to Registry_Region_DE.ID for the Immunization Registry
SiteNPIchar(20)20NOT NULL('')The National Provider Identifier assigned to this site that is submitting the Syndromic Surveillance transactions
Countyvarchar(35)35NOT NULL('')Site county
Foreign Keys FK1_Site_DE_SyndromicRegionDE: [dbo].[Syndromic_Registry_Region_DE].SyndromicRegionDESyndromicRegionDE[dbo].[dict_id]5NOT NULL((0))Link to Syndromic_Registry_Region_DE.ID
SendingFacilityNamevarchar(20)20NULL allowedOptional Sending Facility Name
Check Constraints CK_Site_DE_DischargeDsptnRequiredFLAG_Yes_Or_No : ([DischargeDsptnRequiredFLAG]='N' OR [DischargeDsptnRequiredFLAG]='Y')DischargeDsptnRequiredFLAG[dbo].[BOOL]1NOT NULL('N')Discharge disposition flag used for Syndromic surveillance. Y=Discharge disposition is required;  N=not required
Foreign Keys FK_Site_DE_PrintServerID: [dbo].[Printing_Server].PrintServerIDPrintServerID[dbo].[uniqueid]9NULL allowedDefault Print Server. Link to Printing_Server.ID