Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ePA_Transaction_Answers
Touchworks 25.2
[dbo].[ePA_Transaction_Answers]
MS_Description
Answers for the ePA response questions.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the ePA_Transaction_Answers table.
QuestionsID
[dbo].[uniqueid]
9
NOT NULL
Question Header. Link to the ePA_Transaction_Questions table.
AnswerText
varchar(max)
max
NULL allowed
Answer Text
Choice
varchar(2000)
2000
NULL allowed
The actual answer choice(s) selected by user.
UserID
[dbo].[uniqueid]
9
NOT NULL
User Providing the answer
RecordedDTTM
datetime
8
NULL allowed
Original Recorded time
LastUpdatedDTTM
datetime
8
NULL allowed
Last Updated time
Sequence
int
4
NULL allowed
Answer Sequence