Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE				NO
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)				NO
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)				NO
CAMPAIGN	User defined code for a campaign.	VARCHAR2(5)				NO
CAMPAIGN_END_DATE	Last date when the campaign accepts donations.	DATE				NO
CAMPAIGN_GOAL	Amount of the campaign goal.	NUMBER(20, 2)				NO
CAMPAIGN_NAME	Campaign Name.	VARCHAR2(30)				NO
CAMPAIGN_START_DATE	First date when the campaign accepts donations.	DATE				NO
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(2)				NO
CAMPAIGN_TYPE_DESC	Campaign type description.	VARCHAR2(30)				NO
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)				NO
COUNT_IN_GIVING_IND	Indicates if money received for this campaign is used in the calculation of a constituents giving level.	VARCHAR2(1)				NO
CURRENT_DATE	This is a the system current date (sysdate).	DATE				NO
DEFAULT_DESIGNATION	Designation to use when pledges for the campaign are created.	VARCHAR2(10)				NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)				NO
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)				NO
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)				NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)				NO

Ver: