Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (21) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Site_DE table. |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
 | Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
 | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
 (18) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
 | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
 ![Check Constraints CK_Site_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Site_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
 ![Check Constraints CK_Site_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Site_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
 (19)![Check Constraints CK_Site_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Site_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
 | EffectiveDT | datetime | 8 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
 | OrganizationID | numeric(18,0) | 9 | NULL allowed | | | Link to Organization.ID |
| ACCT_ID | char(20) | 20 | NULL allowed | | | Points to Account.ACCT_ID, a unique identifier provided by Allscripts that is tied to the customer ID |
 | SITE_ID | char(20) | 20 | NULL allowed | | | A unique identifier generated when new sites are added. |
 | ProvID | char(10) | 10 | NULL allowed | | | Unused |
 | Address1 | varchar(35) | 35 | NULL allowed | | | First line of the address for the site |
 | Address2 | varchar(35) | 35 | NULL allowed | | | Second line of the address for the site |
 | City | varchar(20) | 20 | NULL allowed | | | City for the site |
| State | char(2) | 2 | NULL allowed | | | Link to State.State_Abbr |
 | ZipCD | char(10) | 10 | NULL allowed | | | Zip code (optionally includes dash and zip 4) |
 | PhoneArea | smallint | 2 | NOT NULL | | (0) | Site telephone area code |
 | PhoneExchange | smallint | 2 | NOT NULL | | (0) | Site telephone exchange |
 | PhoneLast4 | smallint | 2 | NOT NULL | | (0) | Site telephone remaining four digits |
 ![Check Constraints CK_Site_DE_ClinicalMsgFLAG_Yes_Or_No : ([ClinicalMsgFLAG]='N' OR [ClinicalMsgFLAG]='Y') Check Constraints CK_Site_DE_ClinicalMsgFLAG_Yes_Or_No : ([ClinicalMsgFLAG]='N' OR [ClinicalMsgFLAG]='Y')](../../../../Images/c-constraint.png) | ClinicalMsgFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | Y=show optional clinical messages to provider at login; N=suppress |
 ![Check Constraints CK_Site_DE_PrintRxCopyForFileFLAG_Yes_Or_No : ([PrintRxCopyForFileFLAG]='N' OR [PrintRxCopyForFileFLAG]='Y') Check Constraints CK_Site_DE_PrintRxCopyForFileFLAG_Yes_Or_No : ([PrintRxCopyForFileFLAG]='N' OR [PrintRxCopyForFileFLAG]='Y')](../../../../Images/c-constraint.png) | PrintRxCopyForFileFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y=print an extra patient prescription copy on the default printer for the provider's records |
 | AdminFrequency | varchar(12) | 12 | NOT NULL | | ('0') | Pipe-delimited schedule interval used by the Medication_Admin_Record job |
| PhoneExtension | char(5) | 5 | NOT NULL | | ('') | Site telephone extension |
| FaxArea | smallint | 2 | NOT NULL | | (0) | Site fax number area code |
| FaxExchange | smallint | 2 | NOT NULL | | (0) | Site fax number exchange |
| FaxLast4 | smallint | 2 | NOT NULL | | (0) | Site fax number remaining four digits |
| ContactLastName | varchar(35) | 35 | NOT NULL | | ('') | Primary contact person last name |
| ContactFirstName | varchar(18) | 18 | NOT NULL | | ('') | Primary contact person first name |
| ContactTitleName | varchar(20) | 20 | NOT NULL | | ('') | Primary contact person job title |
| EmergencyArea | smallint | 2 | NOT NULL | | (0) | Site emergency contact telephone area code |
| EmergencyExchange | smallint | 2 | NOT NULL | | (0) | Site emergency contact telephone exchange |
| EmergencyLast4 | smallint | 2 | NOT NULL | | (0) | Site emergency contact telephone remaining four digits |
| URL | varchar(255) | 255 | NULL allowed | | | Site website URL |
![Foreign Keys FK_Site_DE_RegistryRegionDE_Registry_Region_DE_ID: [dbo].[Registry_Region_DE].RegistryRegionDE Foreign Keys FK_Site_DE_RegistryRegionDE_Registry_Region_DE_ID: [dbo].[Registry_Region_DE].RegistryRegionDE](../../../../Images/fk.png) | RegistryRegionDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Link to Registry_Region_DE.ID for the Immunization Registry |
| SiteNPI | char(20) | 20 | NOT NULL | | ('') | The National Provider Identifier assigned to this site that is submitting the Syndromic Surveillance transactions |
| County | varchar(35) | 35 | NOT NULL | | ('') | Site county |
![Foreign Keys FK1_Site_DE_SyndromicRegionDE: [dbo].[Syndromic_Registry_Region_DE].SyndromicRegionDE Foreign Keys FK1_Site_DE_SyndromicRegionDE: [dbo].[Syndromic_Registry_Region_DE].SyndromicRegionDE](../../../../Images/fk.png) | SyndromicRegionDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Link to Syndromic_Registry_Region_DE.ID |
| SendingFacilityName | varchar(20) | 20 | NULL allowed | | | Optional Sending Facility Name |
![Check Constraints CK_Site_DE_DischargeDsptnRequiredFLAG_Yes_Or_No : ([DischargeDsptnRequiredFLAG]='N' OR [DischargeDsptnRequiredFLAG]='Y') Check Constraints CK_Site_DE_DischargeDsptnRequiredFLAG_Yes_Or_No : ([DischargeDsptnRequiredFLAG]='N' OR [DischargeDsptnRequiredFLAG]='Y')](../../../../Images/c-constraint.png) | DischargeDsptnRequiredFLAG | [dbo].[BOOL] | 1 | NOT 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].PrintServerID Foreign Keys FK_Site_DE_PrintServerID: [dbo].[Printing_Server].PrintServerID](../../../../Images/fk.png) | PrintServerID | [dbo].[uniqueid] | 9 | NULL allowed | | | Default Print Server. Link to Printing_Server.ID |