Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE
ALLOW_WEB_GIFT_IND	Indicates if gifts for this campaign will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.	VARCHAR2(1)
ALLOW_WEB_PLEDGE_IND	Indicates if pledges for this campaign will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.	VARCHAR2(1)
CAMPAIGN	User defined code for a campaign.	VARCHAR2(5)
CAMPAIGN_END_DATE	Last date when the campaign accepts donations.	DATE
CAMPAIGN_GOAL	Amount of the campaign goal.	NUMBER(20, 2)
CAMPAIGN_NAME	Campaign Name.	VARCHAR2(30)
CAMPAIGN_START_DATE	First date when the campaign accepts donations.	DATE
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(2)
CAMPAIGN_TYPE_DESC	Campaign type description.	VARCHAR2(30)
CAPITAL_CAMPAIGN_IND	Indicates if this is a capital campaign. (Y)es for a capital campaign. (N)o for a non-capital campaign.	VARCHAR2(1)
COUNT_IN_GIVING_IND	Indicates if money received for this campaign is used in the calculation of a constituents giving level.	VARCHAR2(1)
CURRENT_DATE	This is a the system current date (sysdate).	DATE
DEFAULT_DESIGNATION	Designation to use when pledges for the campaign are created.	VARCHAR2(10)
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)

Ver: