Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADVANCEMENT_APPEAL_KEY	System generated, unique, internal primary key for an advancement appeal year.	NUMBER	CLN_ADVANCEMENT_APPEAL	ADVANCEMENT_APPEAL_KEY	NO	NO	GIFT
ADVANCEMENT_PROGRAM_KEY	System generated, unique, internal primary key for advancement program.	NUMBER	DEFAULTS	0	NO	NO	GIFT
CAMPAIGN_KEY	System generated, unique, internal primary key for a campaign.	NUMBER	CLN_CAMPAIGN	CAMPAIGN_KEY	NO	NO	GIFT
CAMPAIGN_TRANSACTION_AMOUNT	Total transaction amount of the individual gift/payment received for this campaign.	NUMBER	COMBINED_EXPRESSIONS	CAMPAIGN_TRANSACTION_AMOUNT_EXPRESSION	NO	NO	GIFT
CLASS_SCHOOL_KEY	System generated, unique, internal primary key for constituent and associated class year.	NUMBER	DEFAULTS	0	NO	NO	GIFT
CONSTITUENT_ENTITY_TYPE_KEY	System generated, unique, internal primary key for constituent category.	NUMBER	DEFAULTS	0	NO	NO	GIFT
DESIGNATION_DETAIL_KEY	System generated, unique, internal primary key for a designation detail record.	NUMBER	CLN_DESIGNATION_DETAIL	DESIGNATION_DETAIL_KEY	NO	NO	GIFT
DESIGNATION_KEY	System generated, unique, internal primary key for a designation.	NUMBER	CLN_DESIGNATION	DESIGNATION_KEY	NO	NO	GIFT
DONOR_ENTITY_KEY	System generated, unique, internal primary key for a donor entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	GIFT
DONOR_UID	System generated, unique, internal identification number assigned to this person or organization entity that receives credit for the gift.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	GIFT
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal and proposal purpose, prospect interest or contact purpose.	NUMBER	DEFAULTS	0	NO	NO	GIFT
GIFT_CAMPAIGN_GIVING_MONTH	Month of the fiscal year in which this gift was credited for this campaign.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
GIFT_CAMPAIGN_GIVING_YEAR	Unique identifier or code for the fiscal year in which this gift was credited for this campaign.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
GIFT_CREDIT2_AMOUNT	Alternate credit amount.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
GIFT_CURRENCY_AMOUNT	Gift amount in foreign currency.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
GIFT_DATE_OF_RECORD	Date a gift is received.	DATE	COMBINED_EXPRESSIONS	GIFT_DATE_OF_RECORD_EXPRESSION	NO	NO	GIFT
GIFT_DESIGNATION_COUNT	Count of all designations receiving gift credit.	NUMBER	DEPENDANT_EXPRESSIONS	GIFT_DESIGNATION_COUNT_EXPRESSION	NO	NO	GIFT
GIFT_DETAIL_KEY	System generated, unique, internal primary key for a gift.	NUMBER	CLN_GIFT_DETAIL	GIFT_DETAIL_KEY	NO	NO	GIFT
GIFT_DONOR_COUNT	Count of all donors that gave or received soft or hard credit.	NUMBER	DEPENDANT_EXPRESSIONS	GIFT_DONOR_COUNT_EXPRESSION	NO	NO	GIFT
GIFT_ENTRY_DATE	Date the giving transaction was entered in the source system.	DATE				NO
GIFT_KEY	System generated, unique, internal primary key for a gift detail.	NUMBER	CLN_GIFT	GIFT_KEY	NO	NO	GIFT
GIFT_PREMIUM_COUNT	Count of premiums linked to the gift.	NUMBER	COMBINED_EXPRESSIONS	GIFT_PREMIUM_COUNT_EXPRESSION	NO	NO	GIFT
GIFT_RECEIPT_DATE	Date gift receipt was generated by the system.	DATE	COMBINED_EXPRESSIONS	GIFT_RECEIPT_DATE_EXPRESSION	NO	NO	GIFT
GIFT_REPORTING_INDICATOR_KEY	System generated, unique, internal primary key for a gift reporting indicator.	NUMBER	DEFAULTS	0	NO	NO	GIFT
GIVING_ATTRIBUTE_KEY	System generated, unique, internal primary key for a giving attribute.	NUMBER	CLN_GIVING_ATTRIBUTE	GIVING_ATTRIBUTE_KEY	NO	NO	GIFT
HARD_CREDIT_AMOUNT	Hard credit amount received by the donor for the gift.	NUMBER	COMBINED_EXPRESSIONS	HARD_CREDIT_AMOUNT_EXPRESSION	NO	NO	GIFT
HARD_CREDIT_DONOR_COUNT	Count of all donors that received hard credit.	NUMBER	DEPENDANT_EXPRESSIONS	HARD_CREDIT_DONOR_COUNT_EXPRESSION	NO	NO	GIFT
MATCHING_GIFT_IND	Determines whether this is a matching gift.	NUMBER	CLN_GIFT_DETAIL	MATCHING_GIFT_IND_WV	NO	NO	GIFT
MATCH_CREDIT_RECIPIENT_COUNT	Count of all donors that received soft credit from matching gifts.	NUMBER	DEPENDANT_EXPRESSIONS	MATCH_CREDIT_RECIPIENT_COUNT_EXPRESSION	NO	NO	GIFT
MATCH_GIFT_AMOUNT	Matching gift amount.	NUMBER	COMBINED_EXPRESSIONS	MATCH_GIFT_AMOUNT_EXPRESSION	NO	NO	GIFT
MATCH_GIFT_COUNT	Count of all expected or paid matching gifts associated to this gift/payment.	NUMBER	COMBINED_EXPRESSIONS	MATCH_GIFT_COUNT_EXPRESSION	NO	NO	GIFT
MATCH_GIFT_DONOR_COUNT	Count of all donors that gave matching gifts.	NUMBER	DEPENDANT_EXPRESSIONS	MATCH_GIFT_DONOR_COUNT_EXPRESSION	NO	NO	GIFT
MATCH_GIFT_SOFT_CREDIT_AMOUNT	Matching gift soft credit amount given to the donor being matched.	NUMBER	COMBINED_EXPRESSIONS	MATCH_GIFT_SOFT_CREDIT_AMOUNT_EXPRESSION	NO	NO	GIFT
MG_CREDIT_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping matched gifts.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	GIFT
NET_PRESENT_VALUE_AMOUNT	Gift net present value.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
NON_MATCHED_SOFT_CREDIT_AMOUNT	Gift soft credit amount given to the donor that does not belong to matching.	NUMBER	COMBINED_EXPRESSIONS	NON_MATCHED_SOFT_CREDIT_AMOUNT_EXPRESSION	NO	NO	GIFT
OVERALL_TRANSACTION_AMOUNT	Total transaction amount of the individual gift/payment received.	NUMBER	COMBINED_EXPRESSIONS	OVERALL_TRANSACTION_AMOUNT_EXPRESSION	NO	NO	GIFT
PLEDGE_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping pledge payments for a gift.	NUMBER	COMBINED_EXPRESSIONS	PLEDGE_GROUP_IDENTIFIER_EXPRESSION	NO	NO	GIFT
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	DEFAULTS	0	NO	NO	GIFT
REUNION_CAMPAIGN_KEY	System generated, unique, internal primary key for a reunion campaign.	NUMBER	DEFAULTS	0	NO	NO	GIFT
SOFT_CREDIT_AMOUNT	Soft credit amount received by the donor for the gift.	NUMBER	COMBINED_EXPRESSIONS	SOFT_CREDIT_AMOUNT_EXPRESSION	NO	NO	GIFT
SOFT_CREDIT_DONOR_COUNT	Count of all donors that received soft credit.	NUMBER	DEPENDANT_EXPRESSIONS	SOFT_CREDIT_DONOR_COUNT_EXPRESSION	NO	NO	GIFT
SOURCE_DONOR_ENTITY_KEY	System generated, unique, internal primary key for a source donor entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	GIFT
SOURCE_DONOR_UID	System generated, unique, internal identification number assigned to this person or organization entity that originally made the gift.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	GIFT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	DEFAULTS	'GIFT_F1B'	NO	NO	GIFT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
THIRD_PARTY_PAYMENT_AMOUNT		NUMBER	COMBINED_EXPRESSIONS	THIRD_PARTY_PAYMENT_AMOUNT_EXPRESSION	NO	NO	GIFT
TOTAL_GIFT_PREMIUM_AMOUNT	Total amount of premiums linked to the gift.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TRANSACTION_COUNT	Count of all expected or paid gifts associated to this gift/payment.	NUMBER	COMBINED_EXPRESSIONS	TRANSACTION_COUNT_EXPRESSION	NO	NO	GIFT
USER_MEASURE_01		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_02		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_03		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_04		NUMBER	NO SOURCE	NO SOURCE	NO	NO
USER_MEASURE_05		NUMBER	NO SOURCE	NO SOURCE	NO	NO
YEAR_OF_GIVING_KEY	System generated, unique, internal primary key for a year of giving.	NUMBER	CLN_YEAR_OF_GIVING	YEAR_OF_GIVING_KEY	NO	NO	GIFT

Ver: 9.0