Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ePA_Transaction_Questions_Header
Touchworks 25.2
[dbo].[ePA_Transaction_Questions_Header]
MS_Description
Header table for the questions received from ESI.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the ePA_Transaction_Questions_Header table.
TransactionLogID
[dbo].[uniqueid]
9
NOT NULL
ePA_Transaction. Key to the ePA_Transaction table.
QuestionSetID
varchar(50)
50
NULL allowed
Question Set Identifier
QuestionSetTitle
varchar(2000)
2000
NULL allowed
Question Set Title
QuestionSetDescription
varchar(2000)
2000
NULL allowed
Question Set Description
AnswerTxnLogID
[dbo].[uniqueid]
9
NOT NULL
ID of the transaction log for the answers
ItemID
[dbo].[uniqueid]
9
NOT NULL
Link to the Item level table
HasAnswers
char(1)
1
NULL allowed
Determines if there are any answers for the question.
RecordedDTTM
datetime
8
NULL allowed
Original Recorded time
LastUpdatedDTTM
datetime
8
NULL allowed
Last Updated time
IsSubmitted
char(1)
1
NULL allowed
Have the questions been sent?