Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ePA_Transaction_Questions
Touchworks 25.2
[dbo].[ePA_Transaction_Questions]
MS_Description
Questions that have come as part of ESI response. This is a child table.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Link to the ePA_Transaction_Questions table.
HeaderID
[dbo].[uniqueid]
9
NOT NULL
Header question. Key to the ePA_Transaction_Questions_Header table.
QuestionID
varchar(50)
50
NULL allowed
Question Identifier
Sequence
int
4
NULL allowed
Question Sequence
QuestionSetGroupID
varchar(50)
50
NULL allowed
Question Set Identifier
QuestionText
varchar(8000)
8000
NULL allowed
Text of the Question
DefaultNextQuestionID
varchar(50)
50
NULL allowed
Reference to the next question for specific answers for this question.
QuestionType
varchar(50)
50
NULL allowed
Type of question.
ComparisonType
varchar(50)
50
NULL allowed
Type of comparison to be made for answers.
Choice
varchar(max)
max
NULL allowed
The control that needs to be shown in the UI.
Comments
varchar(2000)
2000
NULL allowed
Any comments about the question.
RecordedDTTM
datetime
8
NULL allowed
Original Recorded time
LastUpdatedDTTM
datetime
8
NULL allowed
Last Updated time