Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Where_Performed_DE
Touchworks 25.2
[dbo].[Where_Performed_DE]
MS_Description
Where Performed dictionary. These are for orders.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
(3)
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the Where_Performed_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
(3)
EntryCode
[dbo].[code]
10
NOT NULL
Unique alphanumeric code. Brief but cryptic.
(6)
EntryName
[dbo].[name]
255
NOT NULL
Unique alphanumeric "friendly" display name
(3)
EntryMnemonic
[dbo].[code]
10
NOT NULL
Typically the same as the Code value, but can be blank. If present, it must be unique.
(4)
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history)
IsEnforcedFLAG
[dbo].[BOOL]
1
NOT NULL
Y=row is readonly; N=row is modifiable
(6)
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")
AddressLine1
varchar(35)
35
NULL allowed
First line of Address
AddressLine2
varchar(35)
35
NULL allowed
Second line of Address
City
varchar(35)
35
NULL allowed
City
State
varchar(35)
35
NULL allowed
State
ZipCode
char(10)
10
NULL allowed
Zip Code
PhoneArea
smallint
2
NULL allowed
Phone Area Code
PhoneExchange
smallint
2
NULL allowed
Phone Exchange
PhoneLast4
smallint
2
NULL allowed
Phone Last 4 digits
PhoneExtension
[dbo].[extension]
5
NULL allowed
Phone Extension
FaxArea
smallint
2
NULL allowed
Fax Area Code
FaxExchange
smallint
2
NULL allowed
Fax Exchange
FaxLast4
smallint
2
NULL allowed
Fax Last 4 digits
Custom1
varchar(35)
35
NULL allowed
Custom Field 1
Custom2
varchar(35)
35
NULL allowed
Custom Field 2
Custom3
varchar(35)
35
NULL allowed
Custom Field 3
Custom4
varchar(35)
35
NULL allowed
Custom Field 4
Custom5
varchar(35)
35
NULL allowed
Custom Field 5
DefaultBillingLocationDE
[dbo].[dict_id]
5
NOT NULL
(0)
Default Billing Location. Link to Billing_Location_DE.ID
ReqPerfLocationDE
[dbo].[dict_id]
5
NULL allowed
(0)
Requested Performing Location. Link to Req_Perf_Location_DE.ID
ServiceLocationDE
[dbo].[dict_id]
5
NULL allowed
Healthcare Service Delivery Location. Link to Service_Location_DE.ID.