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	PLEDGE
ADVANCEMENT_PROGRAM_KEY	System generated, unique, internal primary key for advancement program.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
ANTICIPATED_MATCH_AMOUNT	Amount of anticipated matching for this pledge.	NUMBER	EMPTY_KEY	NULL	NO	NO	PLEDGE
CAMPAIGN_KEY	System generated, unique, internal primary key for a campaign.	NUMBER	CLN_CAMPAIGN	CAMPAIGN_KEY	NO	NO	PLEDGE
CAMPAIGN_TRANSACTION_AMOUNT	Total transaction amount of the individual pledge received for this campaign.	NUMBER	AMOUNT_CALCULATIONS	CAMPAIGN_TRANSACTION_AMOUNT_EXPRESSION	NO	NO	PLEDGE
CLASS_SCHOOL_KEY	System generated, unique, internal primary key for constituent and associated class year.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
CONSTITUENT_ENTITY_TYPE_KEY	System generated, unique, internal primary key for constituent category.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
DESIGNATION_DETAIL_KEY	System generated, unique, internal primary key for a designation detail record.	NUMBER	CLN_DESIGNATION_DETAIL	DESIGNATION_DETAIL_KEY	NO	NO	PLEDGE
DESIGNATION_KEY	System generated, unique, internal primary key for a designation.	NUMBER	CLN_DESIGNATION	DESIGNATION_KEY	NO	NO	PLEDGE
DONOR_ENTITY_KEY	System generated, unique, internal primary key for a donor entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	PLEDGE
DONOR_UID	System generated, unique, internal identification number assigned to this person or organization entity that receives credit for the pledge.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PLEDGE
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal and proposal purpose, prospect interest or contact purpose.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
GIFT_REPORTING_INDICATOR_KEY		NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
GIVING_ATTRIBUTE_KEY	System generated, unique, internal primary key for a giving attribute.	NUMBER	CLN_GIVING_ATTRIBUTE	GIVING_ATTRIBUTE_KEY	NO	NO	PLEDGE
HARD_CREDIT_AMOUNT	Hard credit amount received by the donor for the pledge.	NUMBER	AMOUNT_CALCULATIONS	HARD_CREDIT_AMOUNT_EXPRESSION	NO	NO	PLEDGE
HARD_CREDIT_DONOR_COUNT	Count of all donors that pledged and received hard credit.	NUMBER	DEPENDANT_EXPRESSIONS	HARD_CREDIT_DONOR_COUNT_EXPRESSION	NO	NO	PLEDGE
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PLEDGE
OVERALL_PLEDGE_BALANCE	Total amount remaining on the pledge not met by gifting.	NUMBER	AMOUNT_CALCULATIONS	OVERALL_PLEDGE_BALANCE_EXPRESSION	NO	NO	PLEDGE
OVERALL_TRANSACTION_AMOUNT	Total transaction amount of the individual pledge received.	NUMBER	AMOUNT_CALCULATIONS	OVERALL_TRANSACTION_AMOUNT_EXPRESSION	NO	NO	PLEDGE
PLEDGE_AMOUNT_PAID	Pledge amount paid with pledge payments.	NUMBER	AMOUNT_CALCULATIONS	PLEDGE_AMOUNT_PAID_EXPRESSION	NO	NO	PLEDGE
PLEDGE_BALANCE	Amount remaining on the pledge not met by gifting.	NUMBER	DEPENDANT_EXPRESSIONS	PLEDGE_BALANCE_EXPRESSION	NO	NO	PLEDGE
PLEDGE_CAMPAIGN_GIVING_MONTH	Month of the fiscal year in which this pledge was credited for this campaign.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_CAMPAIGN_GIVING_YEAR	Unique identifier or code for the fiscal year in which this pledge was credited for this campaign.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_CURRENCY_AMOUNT	Pledged amount in foreign currency.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_DATE_OF_RECORD	Date a pledge is received.	DATE	DATE_TRANSFORMS	PLEDGE_DATE_OF_RECORD_EXPRESSION	NO	NO	PLEDGE
PLEDGE_DESIGNATION_COUNT	Count of all pledges associated to this designation.	NUMBER	DEPENDANT_EXPRESSIONS	PLEDGE_DESIGNATION_COUNT_EXPRESSION	NO	NO	PLEDGE
PLEDGE_DETAIL_KEY	System generated, unique, internal primary key for a pledge detail.	NUMBER	CLN_PLEDGE_DETAIL	PLEDGE_DETAIL_KEY	NO	NO	PLEDGE
PLEDGE_DONOR_COUNT	Count of all donors that pledged and received soft or hard credit.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PLEDGE
PLEDGE_ENTRY_DATE	Date the giving transaction was entered in the source system.	DATE				NO
PLEDGE_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping pledge payments.	NUMBER	AGRPDES	AGRPDES_PLEDGE_NO	NO	NO	PLEDGE
PLEDGE_KEY	System generated, unique, internal primary key for a pledge.	NUMBER	CLN_PLEDGE	PLEDGE_KEY	NO	NO	PLEDGE
PLEDGE_PREMIUM_COUNT	Count of premiums linked to the pledge.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_RECEIPT_DATE	Date a pledge receipt was generated by the system.	DATE	DATE_TRANSFORMS	PLEDGE_RECEIPT_DATE_EXPRESSION	NO	NO	PLEDGE
PLEDGE_WRITTEN_OFF_DATE	Date a pledge was written off.	DATE	DATE_TRANSFORMS	PLEDGE_WRITTEN_OFF_DATE_EXPRESSION	NO	NO	PLEDGE
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
REMINDER_ADDRESS_TYPE_KEY	System generated, unique, internal primary key for an address type.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
REUNION_CAMPAIGN_KEY	System generated, unique, internal primary key for a reunion campaign.	NUMBER	EMPTY_KEY	0	NO	NO	PLEDGE
SOFT_CREDIT_AMOUNT	Soft credit amount received by the donor for the pledge.	NUMBER	AMOUNT_CALCULATIONS	SOFT_CREDIT_AMOUNT_EXPRESSION	NO	NO	PLEDGE
SOFT_CREDIT_DONOR_COUNT	Count of all donors that pledged and received soft credit.	NUMBER	DEPENDANT_EXPRESSIONS	SOFT_CREDIT_DONOR_COUNT_EXPRESSION	NO	NO	PLEDGE
SOURCE_DONOR_ENTITY_KEY	System generated, unique, internal primary key for a source donor entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	PLEDGE
SOURCE_DONOR_UID	System generated, unique, internal identification number assigned to this person or organization entity that originally made the pledge.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PLEDGE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'PLEDGE_F1B'	NO	NO	PLEDGE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
TOTAL_PLEDGE_PREMIUM_AMOUNT	Total amount of premiums linked to the pledge.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TRANSACTION_COUNT	Count of all pledges.	NUMBER	AMOUNT_CALCULATIONS	TRANSACTION_COUNT_EXPRESSION	NO	NO	PLEDGE
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	PLEDGE

Ver: 9.0