Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CAMPAIGN	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_ACTIVE_IND	Indicates whether the campaign is active or inactive.	NUMBER	EXPRESSION	CAMPAIGN_ACTIVE_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_ACTIVE_IND_LD	Campaign active indicator long description.	VARCHAR2(255)	EXPRESSION	CAMPAIGN_ACTIVE_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_ACTIVE_IND_SD	Campaign active indicator short description.	VARCHAR2(255)	EXPRESSION	CAMPAIGN_ACTIVE_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_GOAL	Displays the campaign goal recorded for the campaign. This will be used to calculate metrics like the campaign goal percent or what percent of the campaign goal has been attained to date.	NUMBER	CAMPAIGN	CAMPAIGN_GOAL	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_KEY	System generated, unique, internal primary key for a campaign.	NUMBER				NO
CAMPAIGN_LD	Campaign long description.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_SD	Campaign short description.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(63)	ATVCMTP	ATVCMTP_CODE	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_TYPE_LD	Long description for the type of campaign.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMPAIGN_TYPE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMP_INCLUDE_IN_GIVING_IND	Indicates whether money received for this campaign is used in the calculation of a constituents giving level or not used in the calculation.	NUMBER	EXPRESSION	CAMP_INCLUDE_IN_GIVING_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMP_INCLUDE_IN_GIVING_IND_LD	Campaign include in giving indicator long description.	VARCHAR2(255)	EXPRESSION	CAMP_INCLUDE_IN_GIVING_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAMP_INCLUDE_IN_GIVING_IND_SD	Campaign include in giving indicator short description.	VARCHAR2(255)	EXPRESSION	CAMP_INCLUDE_IN_GIVING_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAPITAL_CAMPAIGN_IND	Indicates whether this is a capital campaign or not a capital campaign.	NUMBER	EXPRESSION	CAPITAL_CAMPAIGN_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAPITAL_CAMPAIGN_IND_LD	Long description for the capital campaign indicator.	VARCHAR2(255)	EXPRESSION	CAPITAL_CAMPAIGN_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
CAPITAL_CAMPAIGN_IND_SD	Capital campaign indicator short description.	VARCHAR2(255)	EXPRESSION	CAPITAL_CAMPAIGN_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CAMPAIGN_D1B'	NO	NO	ANALYZE FUNDRAISING, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, PROPOSAL, PROSPECT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0