Tables [dbo].[ePA_Transaction_Questions]
Questions that have come as part of ESI response. This is a child table.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_ePA_Transaction_Questions_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Link to the ePA_Transaction_Questions table.
Indexes NIX_ePA_Transaction_Questions_HeaderIDForeign Keys FK_ePA_Txn_Qns_HeaderID: [dbo].[ePA_Transaction_Questions_Header].HeaderIDHeaderID[dbo].[uniqueid]9NOT NULLHeader question. Key to the ePA_Transaction_Questions_Header table.
QuestionIDvarchar(50)50NULL allowedQuestion Identifier
Sequenceint4NULL allowedQuestion Sequence
QuestionSetGroupIDvarchar(50)50NULL allowedQuestion Set Identifier
QuestionTextvarchar(8000)8000NULL allowedText of the Question
DefaultNextQuestionIDvarchar(50)50NULL allowedReference to the next question for specific answers for this question.
QuestionTypevarchar(50)50NULL allowedType of question.
ComparisonTypevarchar(50)50NULL allowedType of comparison to be made for answers.
Choicevarchar(max)maxNULL allowedThe control that needs to be shown in the UI.
Commentsvarchar(2000)2000NULL allowedAny comments about the question.
RecordedDTTMdatetime8NULL allowedOriginal Recorded time
LastUpdatedDTTMdatetime8NULL allowedLast Updated time