Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_MATCHING_CLAIM_COUNT	Count of the number of active matching claims.	NUMBER	EXPRESSION_0	ACTIVE_MATCHING_CLAIM_COUNT_EXPRESSION	NO	NO	MATCHING CLAIM
ADVANCEMENT_APPEAL_KEY	System generated, unique, internal primary key for an advancement appeal year.	NUMBER	CLN_ADVANCEMENT_APPEAL	ADVANCEMENT_APPEAL_KEY	NO	NO	MATCHING CLAIM
ADVANCEMENT_PROGRAM_KEY	System generated, unique, internal primary key for advancement program.	NUMBER	CONSTANT	0	NO	NO	MATCHING CLAIM
CAMPAIGN_KEY	System generated, unique, internal primary key for a campaign.	NUMBER	CLN_CAMPAIGN	CAMPAIGN_KEY	NO	NO	MATCHING CLAIM
CLASS_SCHOOL_KEY	System generated, unique, internal primary key for constituent and associated class year.	NUMBER	CONSTANT	0	NO	NO	MATCHING CLAIM
CONSTITUENT_ENTITY_TYPE_KEY	System generated, unique, internal primary key for constituent category.	NUMBER	CONSTANT	0	NO	NO	MATCHING CLAIM
DESIGNATION_COUNT	Count of the number of designations for matching claims.	NUMBER	EXPRESSION_0	DESIGNATION_COUNT_EXPRESSION	NO	NO	MATCHING CLAIM
DESIGNATION_DETAIL_KEY	System generated, unique, internal primary key for a designation detail record.	NUMBER	CLN_DESIGNATION_DETAIL	DESIGNATION_DETAIL_KEY	NO	NO	MATCHING CLAIM
DESIGNATION_KEY	System generated, unique, internal primary key for a designation.	NUMBER	CLN_DESIGNATION	DESIGNATION_KEY	NO	NO	MATCHING CLAIM
DONOR_MATCHED_ENTITY_KEY	System generated, unique, internal primary key for a matched donor entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	MATCHING CLAIM
DONOR_MATCHED_UID	System generated, unique, internal identification number assigned to the donor (employee) who's giving transaction triggered the creation of this matching claim.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	MATCHING CLAIM
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal and proposal purpose, prospect interest or contact purpose.	NUMBER	CONSTANT	0	NO	NO	MATCHING CLAIM
GIFT_DATE_OF_RECORD	Date a matching claim gift is received.	DATE	EXPRESSION_1	GIFT_DATE_OF_RECORD_EXPRESSION	NO	NO	MATCHING CLAIM
GIFT_RECEIPT_DATE	Date a matching claim gift receipt was generated by the system.	DATE	EXPRESSION_1	GIFT_RECEIPT_DATE_EXPRESSION	NO	NO	MATCHING CLAIM
GIVING_ATTRIBUTE_KEY	System generated, unique, internal primary key for a giving attribute.	NUMBER	CLN_GIVING_ATTRIBUTE	GIVING_ATTRIBUTE_KEY	NO	NO	MATCHING CLAIM
MATCHING_CLAIM_COUNT	Count of the number of matching claims.	NUMBER	EXPRESSION_0	MATCHING_CLAIM_COUNT_EXPRESSION	NO	NO	MATCHING CLAIM
MATCHING_CLAIM_DETAIL_KEY	System generated, unique, internal primary key for a matching claim detail.	NUMBER	CLN_MATCHING_CLAIM_DETAIL	MATCHING_CLAIM_DETAIL_KEY	NO	NO	MATCHING CLAIM
MATCHING_CLAIM_KEY	System generated, unique, internal primary key for a matching claim.	NUMBER	CLN_MATCHING_CLAIM	MATCHING_CLAIM_KEY	NO	NO	MATCHING CLAIM
MATCHING_COMPANY_ENTITY_KEY	System generated, unique, internal primary key for a matching company entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	MATCHING CLAIM
MATCHING_COMPANY_UID	System generated, unique, internal identification number assigned to this organization entity that is matching the claim.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	MATCHING CLAIM
MATCH_CLAIM_AMOUNT	Claim amount to be matched.	NUMBER	EXPRESSION	MATCH_CLAIM_AMOUNT_EXPRESSION	NO	NO	MATCHING CLAIM
MATCH_CLAIM_ENTRY_DATE	Date the giving transaction was entered in the source system.	DATE				NO
MATCH_CLAIM_FORM_RECEIVED_DATE	Date the matching claim form was received.	DATE	DEFAULT_VALUES	TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' )	NO	NO	MATCHING CLAIM
MATCH_CLAIM_STATUS_DATE	Matching claim status date.	DATE	DEFAULT_VALUES	TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' )	NO	NO	MATCHING CLAIM
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	MATCHING CLAIM
OVERALL_TRANSACTION_AMOUNT	Total transaction amount of the individual gift/payment for a matching claim.	NUMBER	AGBGIFT	AGBGIFT_AMT_TOT	NO	NO	MATCHING CLAIM
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	CONSTANT	0	NO	NO	MATCHING CLAIM
REUNION_CAMPAIGN_KEY	System generated, unique, internal primary key for a reunion campaign.	NUMBER	CONSTANT	0	NO	NO	MATCHING CLAIM
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	DEFAULT_VALUES	'MATCHING_CLAIM_F1B'	NO	NO	MATCHING CLAIM
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
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	MATCHING CLAIM

Ver: 9.0