Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ANONYMOUS_TYPE	Level of anonymity associated with this gift credit.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ANONYMOUS_TYPE_LD	Anonymous type long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ANONYMOUS_TYPE_SD	Anonymous type short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DONOR_ASSOCIATION	Type of association this donor has with the primary transaction (either gift or pledge). Example values could be: (P)rimary, (J)oint, (H)onorary, and (M)emorial, (PD) for primary donor, (HR) for hard credit recipient, (SR) for soft credit recipient, and (MD) for matching donor.	VARCHAR2(63)	DONOR_ASSOCIATIONS	'PD'	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
DONOR_ASSOCIATION_LD	Donor association long description.	VARCHAR2(255)	EXPRESSION	DONOR_ASSOCIATION_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
DONOR_ASSOCIATION_SD	Donor association short description.	VARCHAR2(255)	EXPRESSION	DONOR_ASSOCIATION_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
GIFT_IND	Determines whether this transaction is a gift.	NUMBER	EXPRESSION	GIFT_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
GIFT_IND_LD	Gift indicator long description.	VARCHAR2(63)	EXPRESSION	GIFT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
GIFT_IND_SD	Gift indicator short description.	VARCHAR2(63)	EXPRESSION	GIFT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
GIVING_ATTRIBUTE_KEY	System generated, unique, internal primary key for a giving attribute.	NUMBER				NO
GIVING_VEHICLE	Method by which the prospect is expected to donate.	VARCHAR2(63)	AGBGIFT	AGBGIFT_PGVE_CODE	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
GIVING_VEHICLE_LD	Giving vehicle long description.	VARCHAR2(255)	ATVPGVE	ATVPGVE_DESC	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
GIVING_VEHICLE_SD	Giving vehicle short description.	VARCHAR2(255)	ATVPGVE	ATVPGVE_DESC	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
MATCHING_CLAIM_IND	Determines whether this transaction is a matching claim.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
MATCHING_CLAIM_IND_LD	Matching claim indicator long description.	VARCHAR2(63)	EXPRESSION	MATCHING_CLAIM_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
MATCHING_CLAIM_IND_SD	Matching claim indicator short description.	VARCHAR2(63)	EXPRESSION	MATCHING_CLAIM_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
MATCHING_GIFT_IND	Determines whether this transaction is a matching gift.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
MATCHING_GIFT_IND_LD	Matching gift indicator long description.	VARCHAR2(63)	EXPRESSION	MATCHING_GIFT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
MATCHING_GIFT_IND_SD	Matching gift indicator short description.	VARCHAR2(63)	EXPRESSION	MATCHING_GIFT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
PLEDGE_IND	Determines whether this transaction is a pledge.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
PLEDGE_IND_LD	Pledge indicator long description.	VARCHAR2(63)	EXPRESSION	PLEDGE_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
PLEDGE_IND_SD	Pledge indicator short description.	VARCHAR2(63)	EXPRESSION	PLEDGE_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
SOURCE_OF_INFORMATION	Internal institution source of this transaction. For example, Athletic Dept., Dean's Office, etc..	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SOURCE_OF_INFORMATION_LD	Source of information long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
SOURCE_OF_INFORMATION_SD	Source of information short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
SPECIAL_HANDLING	Indicates whether this gift is to receive any special handling.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SPECIAL_HANDLING_LD	Special handling long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
SPECIAL_HANDLING_SD	Special handling short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(63)	SYSTEM_LOAD_PROCESS	'GIVING_ATTRIBUTE_D1B'	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
TRANSACTION_TYPE	Type of transaction is defined as (PL) for pledge, (GF) for gift, (MG) for matching gift, (MC) for matching claim, and (PP) for pledge payment.	VARCHAR2(63)	TRANSACTION_TYPES	'GF'	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
TRANSACTION_TYPE_LD	Transaction type long description.	VARCHAR2(255)	EXPRESSION	TRANSACTION_TYPE_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
TRANSACTION_TYPE_SD	Transaction type short description.	VARCHAR2(255)	EXPRESSION	TRANSACTION_TYPE_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE
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