Tables [dbo].[ePA_Transaction_Answers]
Answers for the ePA response questions.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_ePA_Transaction_Answers_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the ePA_Transaction_Answers table.
Indexes NIX_ePA_Transaction_Answers_QuestionsIDForeign Keys FK_ePA_Txn_Ans_QuestionsID: [dbo].[ePA_Transaction_Questions].QuestionsIDQuestionsID[dbo].[uniqueid]9NOT NULLQuestion Header. Link to the ePA_Transaction_Questions table.
AnswerTextvarchar(max)maxNULL allowedAnswer Text
Choicevarchar(2000)2000NULL allowedThe actual answer choice(s) selected by user.
UserID[dbo].[uniqueid]9NOT NULLUser Providing the answer
RecordedDTTMdatetime8NULL allowedOriginal Recorded time
LastUpdatedDTTMdatetime8NULL allowedLast Updated time
Sequenceint4NULL allowedAnswer Sequence