Table: Demo_Idonate

Purpose

The Demo_Idonate table stores the answers to demographic questions that were filled in by donors for each donation.

The original gift activity can be referenced indirectly using the InvoiceNumber column:

Demo_Idonate.InvoiceNumber > Invoice.REFERENCE_NUM > Trans.INVOICE_REFERENCE_NUM > Trans.TRANS_NUMBER > Activity.ORIGINATING_TRANS_NUM

Column Name	Column Type (iMIS)	Column Type (SQL)	Notes
ID (Created automatically by iMIS)	`AUTOMATIC`	`VARCHAR(10)`	iMIS ID field
SEQN (Created automatically by iMIS)	`AUTOMATIC`	`INT`	SEQN field.
QuestionCode	`CHAR (Length: 30)`	`VARCHAR(30)`	The question code. This is the `Code` value from the IDONATE_QUESTIONS gen table. To get the question description, join `Gen_Tables` and read the `Description` field.
SelectedAnswer	`CHAR (Length: 60)`	`VARCHAR(60)`	The answer that the user selected or typed in. This is one of the possible values in the `Gen_Tables.Substitute` field, or the text that the donor entered for freeform answers.
InvoiceNumber	`INT`	`INT`	The invoice reference number for the donation.
Create_Date	`DATETIME`	`DATETIME`	The date/time that the donation occurred and the question was answered.