Tables [dbo].[Where_Performed_DE]
Where Performed dictionary. These are for orders.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Where_Performed_DE_ID: IDIndexes TWstat_Where_Performed_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Where_Performed_DE_IsCurrentFLAG_EntryName_ID, TWstat_Where_Performed_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Where_Performed_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Where_Performed_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Where_Performed_DE_EntryCode_WithIncludeColumns, NIX_Where_Performed_DE_EntryMnemonic_WithIncludeColumns, NIX_Where_Performed_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Indexes NIX_Where_Performed_DE_EntryCode_WithIncludeColumns, NIX_Where_Performed_DE_EntryMnemonic_WithIncludeColumns, NIX_Where_Performed_DE_EntryName_WithIncludeColumns, TWstat_Where_Performed_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Where_Performed_DE_IsCurrentFLAG_EntryName_ID, TWstat_Where_Performed_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(6)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Where_Performed_DE_EntryCode_WithIncludeColumns, NIX_Where_Performed_DE_EntryMnemonic_WithIncludeColumns, NIX_Where_Performed_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes NIX_Where_Performed_DE_EntryCode_WithIncludeColumns, NIX_Where_Performed_DE_EntryMnemonic_WithIncludeColumns, NIX_Where_Performed_DE_EntryName_WithIncludeColumns, TWstat_Where_Performed_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Where_Performed_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_Where_Performed_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Where_Performed_DE_EntryCode_WithIncludeColumns, NIX_Where_Performed_DE_EntryMnemonic_WithIncludeColumns, NIX_Where_Performed_DE_EntryName_WithIncludeColumns, TWstat_Where_Performed_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Where_Performed_DE_IsCurrentFLAG_EntryName_ID, TWstat_Where_Performed_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(6)Check Constraints CK_Where_Performed_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")
AddressLine1varchar(35)35NULL allowedFirst line of Address
AddressLine2varchar(35)35NULL allowedSecond line of Address
Cityvarchar(35)35NULL allowedCity
Statevarchar(35)35NULL allowedState
ZipCodechar(10)10NULL allowedZip Code
PhoneAreasmallint2NULL allowedPhone Area Code
PhoneExchangesmallint2NULL allowedPhone Exchange
PhoneLast4smallint2NULL allowedPhone  Last 4 digits
PhoneExtension[dbo].[extension]5NULL allowedPhone Extension
FaxAreasmallint2NULL allowedFax Area Code
FaxExchangesmallint2NULL allowedFax Exchange
FaxLast4smallint2NULL allowedFax  Last 4 digits
Custom1varchar(35)35NULL allowedCustom Field 1
Custom2varchar(35)35NULL allowedCustom Field 2
Custom3varchar(35)35NULL allowedCustom Field 3
Custom4varchar(35)35NULL allowedCustom Field 4
Custom5varchar(35)35NULL allowedCustom Field 5
Foreign Keys FK_Where_Performed_DE_DefaultBillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].DefaultBillingLocationDEDefaultBillingLocationDE[dbo].[dict_id]5NOT NULL(0)Default Billing Location. Link to Billing_Location_DE.ID
Foreign Keys FK_WherePerfprmedDE_ReqPerfLocationDE: [dbo].[Req_Perf_Location_DE].ReqPerfLocationDEReqPerfLocationDE[dbo].[dict_id]5NULL allowed(0)Requested Performing Location. Link to Req_Perf_Location_DE.ID
Foreign Keys FK_Where_Performed_DE_ServiceLocationDE_Service_Location_DE_ID: [dbo].[Service_Location_DE].ServiceLocationDEServiceLocationDE[dbo].[dict_id]5NULL allowedHealthcare Service Delivery Location. Link to Service_Location_DE.ID.