Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Additional_Information
Touchworks 25.2
[dbo].[Additional_Information]
MS_Description
Additional Information Questions instance data
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
(8)
ItemID
[dbo].[uniqueid]
9
NOT NULL
Order Header ID. Link to Item_plan.ID, Item_Immunization.ID, etc.
(5)
ItemType
varchar(50)
50
NULL allowed
('order')
Item Type. Allowed values 'Order', 'Charge', 'IM'
(12)
AdditionalInformationDE
[dbo].[dict_id]
5
NOT NULL
Additional Information Dictionary ID. Link to Additional_Information_DE.ID
(7)
patientid
[dbo].[uniqueid]
9
NOT NULL
Patient Identifier. Link toPatient_Member.ID
(2)
providerid
[dbo].[uniqueid]
9
NOT NULL
Provider Identifier. Link to Provider.ID
(4)
encounterid
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID.
datatype
varchar(50)
50
NULL allowed
('text')
Answer value Data Type
Example : DateTime
Numeric
Picklist
Text
USZipCode
thisvalue
varchar(7000)
7000
NULL allowed
Selected Answer for the Question
(5)
recordedDTTM
datetime
8
NOT NULL
(getdate())
Date and time the question was answered.
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Is this entry inactive (Y/N)? Always N.
Sequence
int
4
NOT NULL
(0)
Answer sequence
IsParentFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Is this question a parent question(Y/N)?
ParentAdditionalInformationID
[dbo].[dict_id]
5
NOT NULL
(0)
Parent Additional Information Identifier. Link to Additional_Information_DE.ID.
ConditionalQuestionsXML
varchar(max)
max
NULL allowed
Conditional questions in XML format
(2)
ReqPerfLocationDE
[dbo].[dict_id]
5
NOT NULL
(0)
Requested Performing Location. Link to Req_Perf_Location_DE.ID
OIDDE
[dbo].[dict_id]
5
NOT NULL
(0)
Orderable item. Qo_Classification_DE.ID
OIDType
char(1)
1
NOT NULL
('O')
Orderable item type. Allowed values 'O' or 'M'
ChildAdditionalInformationDEList
varchar(255)
255
NOT NULL
('')
List of Child additional information Dictionary ID's separated by comma.