Tables [dbo].[ePA_Transaction_Questions_Header]
Header table for the questions received from ESI.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_ePA_Transaction_Questions_Header_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the ePA_Transaction_Questions_Header table.
Indexes NIX_ePA_Transaction_Questions_Header_TransactionLogIDForeign Keys FK_ePA_Txn_Qn_Header_TxnLogID: [dbo].[ePA_Transaction].TransactionLogIDTransactionLogID[dbo].[uniqueid]9NOT NULLePA_Transaction. Key to the ePA_Transaction table.
QuestionSetIDvarchar(50)50NULL allowedQuestion Set Identifier
QuestionSetTitlevarchar(2000)2000NULL allowedQuestion Set Title
QuestionSetDescriptionvarchar(2000)2000NULL allowedQuestion Set Description
AnswerTxnLogID[dbo].[uniqueid]9NOT NULLID of the transaction log for the answers
Indexes NIX_ePA_Transaction_Questions_Header_ItemID_HasAnswersItemID[dbo].[uniqueid]9NOT NULLLink to the Item level table
Indexes NIX_ePA_Transaction_Questions_Header_ItemID_HasAnswersHasAnswerschar(1)1NULL allowedDetermines if there are any answers for the question.
RecordedDTTMdatetime8NULL allowedOriginal Recorded time
LastUpdatedDTTMdatetime8NULL allowedLast Updated time
IsSubmittedchar(1)1NULL allowedHave the questions been sent?