Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (8)![Foreign Keys FK_Location_DE_ID_Location_DE_ID: [dbo].[Location_DE].ID Foreign Keys FK_Location_DE_ID_Location_DE_ID: [dbo].[Location_DE].ID](../../../../Images/fk.png) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Location_DE table. |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
(8) | 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 |
(4) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
(9) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
(4) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
(4)![Check Constraints CK_Location_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Location_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_Location_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Location_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 |
(10)![Check Constraints CK_Location_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Location_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") |
![Foreign Keys FK_Location_DE_LocationTypeDE_Location_Type_DE_ID: [dbo].[Location_Type_DE].LocationTypeDE Foreign Keys FK_Location_DE_LocationTypeDE_Location_Type_DE_ID: [dbo].[Location_Type_DE].LocationTypeDE](../../../../Images/fk.png) | LocationTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Type. Link to Location_Type_DE.ID |
 | FacilityDE | [dbo].[dict_id] | 5 | NOT NULL | | | Facility. Link to dbo.Facility_de.id |
| ParentLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Parent Location. Link to dbo.Location_de.ID |
![Check Constraints CK_Location_DE_IsClinicFLAG_Yes_Or_No : ([IsClinicFLAG]='N' OR [IsClinicFLAG]='Y') Check Constraints CK_Location_DE_IsClinicFLAG_Yes_Or_No : ([IsClinicFLAG]='N' OR [IsClinicFLAG]='Y')](../../../../Images/c-constraint.png) | IsClinicFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Clinic? Y/N |
| PhoneArea | smallint | 2 | NOT NULL | | | area code of phone number |
| PhoneExchange | smallint | 2 | NOT NULL | | | exchange number of phone number |
| PhoneLast4 | smallint | 2 | NOT NULL | | | Last 4 of phone number |
| PhoneExtension | [dbo].[extension] | 5 | NOT NULL | | | extension |
| PhoneInternational | [dbo].[int_phone] | 21 | NOT NULL | | | International phone number |
| FaxArea | smallint | 2 | NOT NULL | | | area code of fax number |
| FaxExchange | smallint | 2 | NOT NULL | | | exchange number of fax machine |
| FaxLast4 | smallint | 2 | NOT NULL | | | last 4 of fax number |
| FaxExtension | [dbo].[extension] | 5 | NOT NULL | | (' ') | extension |
| FaxInternational | [dbo].[int_phone] | 21 | NOT NULL | | | International FAX number |
| LMRP | int | 4 | NULL allowed | | | Local Medical Review Policy. Not Used. |
![Foreign Keys FK_Location_DE_SiteDE: [dbo].[Site_DE].SiteDE Foreign Keys FK_Location_DE_SiteDE: [dbo].[Site_DE].SiteDE](../../../../Images/fk.png) | SiteDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Site. Link to Site_DE.ID. |
| AddressLine1 | varchar(35) | 35 | NOT NULL | | ('') | Location address line 1 |
| AddressLine2 | varchar(35) | 35 | NOT NULL | | ('') | Location address line 2 |
| City | varchar(20) | 20 | NOT NULL | | ('') | City of the location |
| State | char(2) | 2 | NOT NULL | | ('') | State of the location |
| ZipCode | char(10) | 10 | NOT NULL | | ('') | Location zip code |
| County | varchar(35) | 35 | NOT NULL | | ('') | County of the location |
| ContactFirstName | varchar(18) | 18 | NOT NULL | | ('') | Contact first name |
| ContactLastName | varchar(35) | 35 | NOT NULL | | ('') | Contact last name |
| Country | varchar(30) | 30 | NOT NULL | | ('') | Country of the location |