Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
DONOR_MATCHED_GIFT_NUMBER	Donor's original gift number to be matched.	VARCHAR2(63)	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_BATCH_NUMBER	Batch number used to process this gift.	VARCHAR2(63)	EXPRESSION	GIFT_BATCH_NUMBER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_CHECK_NUMBER	Free format text field used to enter the check number corresponding to this gift. This can be used to link separate gift transactions together, especially in the case of a fund transfer where a gift may be split across several foundation allocations.	VARCHAR2(63)	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_COMMENT	Gift comment.	VARCHAR2(1200)	AGBGIFT	AGBGIFT_COMMENT	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_DETAIL_KEY	System generated, unique, internal primary key for a gift detail.	NUMBER				NO
GIFT_IND	Determines whether this is a gift.	NUMBER	CONSTANT	1	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_IND_LD	Gift indicator long description.	VARCHAR2(255)	DESCRIPTION_EXPRESSION	GIFT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_IND_SD	Gift indicator long description.	VARCHAR2(255)	DESCRIPTION_EXPRESSION	GIFT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_NUMBER	Gift transaction receipt number. All gifts associated with one primary gift or a matching gift will have the same gift number.	VARCHAR2(63)	AGRGPAY	AGRGPAY_GIFT_NO	NO	NO	ANALYZE FUNDRAISING, GIFT
GIFT_SEQUENCE	System generated one-up number uniquely identifying the gift record.	NUMBER	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, GIFT
MATCHING_GIFT_IND	Determines whether this is a matching gift.	NUMBER	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, GIFT
MATCHING_GIFT_IND_LD	Matching gift indicator long description.	VARCHAR2(255)	DESCRIPTION_EXPRESSION	MATCHING_GIFT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
MATCHING_GIFT_IND_SD	Matching gift indicator short description.	VARCHAR2(255)	DESCRIPTION_EXPRESSION	MATCHING_GIFT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
MATCH_GIFT_NUMBER	Matching gift transaction number.	VARCHAR2(63)	CONSTANT	NULL	NO	NO
PLEDGE_NUMBER	Pledge number paid by a gift.	VARCHAR2(63)	GIFT_EXPRESSION	PLEDGE_NUMBER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
PLEDGE_PAYMENT_IND	Determines whether this is a pledge payment.	NUMBER	GIFT_EXPRESSION	PLEDGE_PAYMENT_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
PLEDGE_PAYMENT_IND_LD	Pledge payment indicator long description.	VARCHAR2(255)	DESCRIPTION_EXPRESSION	PLEDGE_PAYMENT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
PLEDGE_PAYMENT_IND_SD	Pledge payment indicator short description.	VARCHAR2(255)	DESCRIPTION_EXPRESSION	PLEDGE_PAYMENT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'GIFT_DETAIL_D1B'	NO	NO	ANALYZE FUNDRAISING, GIFT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
THIRD_PARTY_PAYMENT_IND		NUMBER	GIFT_EXPRESSION	THIRD_PARTY_PAYMENT_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
THIRD_PARTY_PAYMENT_IND_LD		VARCHAR2(255)	DESCRIPTION_EXPRESSION	THIRD_PARTY_PAYMENT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
THIRD_PARTY_PAYMENT_IND_SD		VARCHAR2(255)	DESCRIPTION_EXPRESSION	THIRD_PARTY_PAYMENT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, GIFT
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