Tables [dbo].[Location_DE]
Scheduling Location
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Location_DE_ID: IDIndexes XAK5Location, XAK4Location, TWstat_Location_DE_EnterpriseEntryID_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryCode_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryMnemonic_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Location_DE_IsCurrentFLAG_DefinitionSetID_EntryName_ID, TWstat_Location_DE_IsInactiveFLAG_DefinitionSetID_EntryName_IsCurrentFLAG_ID(8)Foreign Keys FK_Location_DE_ID_Location_DE_ID: [dbo].[Location_DE].IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Location_DE table.
Indexes TWstat_Location_DE_EnterpriseEntryID_DefinitionSetID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes XAK5Location, XAK4Location, TWstat_Location_DE_EnterpriseEntryID_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryCode_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryMnemonic_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Location_DE_IsCurrentFLAG_DefinitionSetID_EntryName_ID, TWstat_Location_DE_IsInactiveFLAG_DefinitionSetID_EntryName_IsCurrentFLAG_ID(8)DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes XAK5LocationEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Location_DE_EntryCode_WithIncludeColumns, NIX_Location_DE_EntryMnemonic_WithIncludeColumns, NIX_Location_DE_EntryName_WithIncludeColumns, TWstat_Location_DE_EntryCode_DefinitionSetID_EntryName_IsCurrentFLAG_ID(4)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes NIX_Location_DE_EntryCode_WithIncludeColumns, NIX_Location_DE_EntryMnemonic_WithIncludeColumns, NIX_Location_DE_EntryName_WithIncludeColumns, TWstat_Location_DE_EnterpriseEntryID_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryCode_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryMnemonic_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Location_DE_IsCurrentFLAG_DefinitionSetID_EntryName_ID, TWstat_Location_DE_IsInactiveFLAG_DefinitionSetID_EntryName_IsCurrentFLAG_ID(9)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Location_DE_EntryCode_WithIncludeColumns, NIX_Location_DE_EntryMnemonic_WithIncludeColumns, NIX_Location_DE_EntryName_WithIncludeColumns, TWstat_Location_DE_EntryMnemonic_DefinitionSetID_EntryName_IsCurrentFLAG_ID(4)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes NIX_Location_DE_EntryCode_WithIncludeColumns, NIX_Location_DE_EntryMnemonic_WithIncludeColumns, NIX_Location_DE_EntryName_WithIncludeColumns, TWstat_Location_DE_IsInactiveFLAG_DefinitionSetID_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Location_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)
Check Constraints CK_Location_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes XAK5Location, NIX_Location_DE_EntryCode_WithIncludeColumns, NIX_Location_DE_EntryMnemonic_WithIncludeColumns, NIX_Location_DE_EntryName_WithIncludeColumns, TWstat_Location_DE_EnterpriseEntryID_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryCode_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryMnemonic_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Location_DE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Location_DE_IsCurrentFLAG_DefinitionSetID_EntryName_ID, TWstat_Location_DE_IsInactiveFLAG_DefinitionSetID_EntryName_IsCurrentFLAG_ID(10)Check Constraints CK_Location_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.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Foreign Keys FK_Location_DE_LocationTypeDE_Location_Type_DE_ID: [dbo].[Location_Type_DE].LocationTypeDELocationTypeDE[dbo].[dict_id]5NOT NULLType. Link to Location_Type_DE.ID
Indexes XAK4LocationFacilityDE[dbo].[dict_id]5NOT NULLFacility. Link to dbo.Facility_de.id
ParentLocationDE[dbo].[dict_id]5NOT NULL(0)Parent Location. Link to dbo.Location_de.ID
Check Constraints CK_Location_DE_IsClinicFLAG_Yes_Or_No : ([IsClinicFLAG]='N' OR [IsClinicFLAG]='Y')IsClinicFLAG[dbo].[BOOL]1NOT NULLClinic? Y/N
PhoneAreasmallint2NOT NULLarea code of phone number
PhoneExchangesmallint2NOT NULLexchange number of phone number
PhoneLast4smallint2NOT NULLLast 4 of phone number
PhoneExtension[dbo].[extension]5NOT NULLextension
PhoneInternational[dbo].[int_phone]21NOT NULLInternational phone number
FaxAreasmallint2NOT NULLarea code of fax number
FaxExchangesmallint2NOT NULLexchange number of fax machine
FaxLast4smallint2NOT NULLlast 4 of fax number
FaxExtension[dbo].[extension]5NOT NULL(' ')extension
FaxInternational[dbo].[int_phone]21NOT NULLInternational FAX number
LMRPint4NULL allowedLocal Medical Review Policy. Not Used.
Foreign Keys FK_Location_DE_SiteDE: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULL((0))Site. Link to Site_DE.ID.
AddressLine1varchar(35)35NOT NULL('')Location address line 1
AddressLine2varchar(35)35NOT NULL('')Location address line 2
Cityvarchar(20)20NOT NULL('')City of the location
Statechar(2)2NOT NULL('')State of the location
ZipCodechar(10)10NOT NULL('')Location zip code
Countyvarchar(35)35NOT NULL('')County of the location
ContactFirstNamevarchar(18)18NOT NULL('')Contact first name
ContactLastNamevarchar(35)35NOT NULL('')Contact last name
Countryvarchar(30)30NOT NULL('')Country of the location