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	CONSTANTS	NULL	NO	NO	ANALYZE FUNDRAISING
ADDRESS_GROUP_KEY		NUMBER	TRANSLATIONS	ADDRESS_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
ADVANCEMENT_ACTIVITY_GROUP_KEY		NUMBER	TRANSLATIONS	ADVANCEMENT_ACTIVITY_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
ADVANCEMENT_APPEAL_KEY		NUMBER	WFT_PLEDGE	ADVANCEMENT_APPEAL_KEY	NO	NO	ANALYZE FUNDRAISING
ADVANCEMENT_DEGREE_GROUP_KEY		NUMBER	TRANSLATIONS	ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
ADVANCEMENT_PROGRAM_KEY		NUMBER	WFT_PLEDGE	ADVANCEMENT_PROGRAM_KEY	NO	NO	ANALYZE FUNDRAISING
AFFILIATION_GROUP_KEY		NUMBER	TRANSLATIONS	AFFILIATION_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
ANTICIPATED_MATCH_AMOUNT	Amount of anticipated matching for this pledge.	NUMBER	WFT_PLEDGE	ANTICIPATED_MATCH_AMOUNT	NO	NO	ANALYZE FUNDRAISING
AWARD_HONOR_GROUP_KEY		NUMBER	TRANSLATIONS	AWARD_HONOR_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CAMPAIGN	User defined code for a campaign toward which contributions are to be counted.	VARCHAR2(63)	WDT_CAMPAIGN	CAMPAIGN	NO	NO	ANALYZE FUNDRAISING
CAMPAIGN_DESIGNATION_GOAL_KEY		NUMBER	WDT_FUNDRAISING_GOAL	FUNDRAISING_GOAL_KEY	NO	NO	ANALYZE FUNDRAISING
CAMPAIGN_GOAL_KEY		NUMBER	WDT_FUNDRAISING_GOAL	FUNDRAISING_GOAL_KEY	NO	NO	ANALYZE FUNDRAISING
CAMPAIGN_KEY		NUMBER	WFT_PLEDGE	CAMPAIGN_KEY	NO	NO	ANALYZE FUNDRAISING
CAMPAIGN_TRANSACTION_AMOUNT	Total transaction amount of the individual pledge or indiviudal gift/payment received for this campaign.	NUMBER	WFT_PLEDGE	CAMPAIGN_TRANSACTION_AMOUNT	NO	NO	ANALYZE FUNDRAISING
CLASS_SCHOOL_KEY		NUMBER	WFT_PLEDGE	CLASS_SCHOOL_KEY	NO	NO	ANALYZE FUNDRAISING
COMMITTEE_GROUP_KEY		NUMBER	TRANSLATIONS	COMMITTEE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CONSTITUENT_ENTITY_TYPE_KEY		NUMBER	WFT_PLEDGE	CONSTITUENT_ENTITY_TYPE_KEY	NO	NO	ANALYZE FUNDRAISING
CONSTITUENT_EVAL_GROUP_KEY		NUMBER	TRANSLATIONS	CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CONSTITUENT_INTEREST_GROUP_KEY		NUMBER	TRANSLATIONS	CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CONSTITUENT_PROFILE_GROUP_KEY		NUMBER	TRANSLATIONS	CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CONST_EMPLOYMENT_GROUP_KEY		NUMBER	TRANSLATIONS	CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CONT_REP_ENTITY_GROUP_KEY		NUMBER	TRANSLATIONS	CONT_REP_ENTITY_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
CURRENCY_AMOUNT	Pledged or gift/payment amount in foreign currency.	NUMBER	WFT_PLEDGE	PLEDGE_CURRENCY_AMOUNT	NO	NO	ANALYZE FUNDRAISING
DESIGNATION	Designation.	VARCHAR2(63)	WDT_DESIGNATION_DETAIL	DESIGNATION	NO	NO	ANALYZE FUNDRAISING
DESIGNATION_ATTRIB_GROUP_KEY		NUMBER	TRANSLATIONS	DESIGNATION_ATTRIB_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
DESIGNATION_COUNT	Count of all designations receiving gift credit , pledge credit, or matching claim credit.	NUMBER	WFT_PLEDGE	PLEDGE_DESIGNATION_COUNT	NO	NO	ANALYZE FUNDRAISING
DESIGNATION_DETAIL_KEY		NUMBER	WFT_DESIGNATION_ATTRIBUTE	DESIGNATION_DETAIL_KEY	NO	NO	ANALYZE FUNDRAISING
DESIGNATION_KEY		NUMBER	WFT_PLEDGE	DESIGNATION_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_CE_ATTRIB_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	CONSTITUENT_ENTITY_ATTRIB_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_CE_TYPE_GROUP_KEY		NUMBER	TRANSLATIONS	DONOR_CE_TYPE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
DONOR_COUNT	Count of all donors that gave or received soft or hard credit for pledges or gifts.	NUMBER	WFT_PLEDGE	PLEDGE_DONOR_COUNT	NO	NO	ANALYZE FUNDRAISING
DONOR_DEMOGRAPHIC_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	DEMOGRAPHIC_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_ENTITY_KEY		NUMBER	AGGREGATOR	DONOR_ENTITY_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_ID	The ID number of the relation.	VARCHAR2(63)	WFT_CONSTITUENT_ENTITY	ENTITY_ID	NO	NO	ANALYZE FUNDRAISING
DONOR_PREF_ADDRESS_TYPE_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_ADDRESS_TYPE_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_PREF_CLASS_SCHOOL_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_CLASS_SCHOOL_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_PREF_POSTAL_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_POSTAL_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_PREF_STREET_LINE_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_STREET_LINE_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_PRIMARY_CE_TYPE_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PRIMARY_CE_TYPE_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_SPOUSE_ENTITY_KEY		NUMBER	WFT_RELATIONSHIP	RELATED_ENTITY_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_SPOUSE_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping donor spouse relationships.	VARCHAR2(63)	SPOUSE_GROUP_IDENTIFIERS	DONOR_SPOUSE_GROUP_IDENTIFIER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
DONOR_SPOUSE_NON_ENTITY_KEY		NUMBER	WFT_RELATIONSHIP	NON_ENTITY_RELATION_KEY	NO	NO	ANALYZE FUNDRAISING
DONOR_SPOUSE_UID	System generated unique internal identification number assigned to the spouse of the donor.	NUMBER	WFT_RELATIONSHIP	RELATED_ENTITY_UID	NO	NO	ANALYZE FUNDRAISING
DONOR_UID	System generated unique internal identification number assigned to this person or organization who is a donor.	NUMBER	WFT_PLEDGE	DONOR_UID	NO	NO	ANALYZE FUNDRAISING
EMAIL_GROUP_KEY		NUMBER	TRANSLATIONS	EMAIL_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
ENTITY_ASSIGNMENT_GROUP_KEY		NUMBER	TRANSLATIONS	ENTITY_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
ENTITY_PROS_INTEREST_GROUP_KEY		NUMBER	TRANSLATIONS	ENTITY_PROS_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
EXCLUSION_GROUP_KEY		NUMBER	TRANSLATIONS	EXCLUSION_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
FIRST_GIFT_DATE_OF_RECORD	First date a gift transaction is received.	DATE	TRANSLATIONS	FIRST_GIFT_DATE_OF_RECORD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
FIRST_GIFT_IND	First gift recorded for the donor.	NUMBER	TRANSLATIONS	FIRST_GIFT_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
FIRST_GIFT_OR_PLEDGE_IND	First gift or pledge recorded for the donor.	NUMBER	TRANSLATIONS	FIRST_GIFT_OR_PLEDGE_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
FIRST_GIFT_OR_PLEDGE_REC_DATE	First date a gift receipt or pledge receipt was system generated.	DATE	TRANSLATIONS	FIRST_GIFT_OR_PLEDGE_REC_DATE_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
FUNDING_PURPOSE_GROUP_KEY		NUMBER	TRANSLATIONS	FUNDING_PURPOSE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
FUNDRAISING_INITIATIVE_KEY		NUMBER	WFT_PLEDGE	FUNDRAISING_INITIATIVE_KEY	NO	NO	ANALYZE FUNDRAISING
GIFT_CREDIT2_AMOUNT	Alternate credit amount.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
GIFT_DETAIL_KEY		NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
GIFT_KEY		NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
GIFT_REPORTING_INDICATOR_KEY		NUMBER	WFT_PLEDGE	GIFT_REPORTING_INDICATOR_KEY	NO	NO	ANALYZE FUNDRAISING
GIFT_SOCIETY_GROUP_KEY		NUMBER	TRANSLATIONS	GIFT_SOCIETY_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
GIVING_ATTRIBUTE_KEY		NUMBER	WFT_PLEDGE	GIVING_ATTRIBUTE_KEY	NO	NO	ANALYZE FUNDRAISING
GIVING_CODE_GROUP_KEY		NUMBER	TRANSLATIONS	GIVING_CODE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
HARD_CREDIT_AMOUNT	Hard credit amount received by the donor for the pledge or gift/payment.	NUMBER	WFT_PLEDGE	HARD_CREDIT_AMOUNT	NO	NO	ANALYZE FUNDRAISING
HARD_CREDIT_DONOR_COUNT	Count of all donors that received hard credit for gifts or pledges.	NUMBER	WFT_PLEDGE	HARD_CREDIT_DONOR_COUNT	NO	NO	ANALYZE FUNDRAISING
MAILING_HISTORY_GROUP_KEY		NUMBER	TRANSLATIONS	MAILING_HISTORY_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
MAILING_LIST_GROUP_KEY		NUMBER	TRANSLATIONS	MAILING_LIST_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
MAIL_TRACKING_GROUP_KEY		NUMBER	TRANSLATIONS	MAIL_TRACKING_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
MATCHING_CLAIM_COUNT	Count of the number of matching claims.	NUMBER	CONSTANTS	NULL	NO	NO	ANALYZE FUNDRAISING
MATCHING_CLAIM_DETAIL_KEY		NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
MATCHING_CLAIM_KEY		NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
MATCH_CLAIM_AMOUNT	Claim amount to be matched.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
MATCH_CLAIM_FORM_RECEIVED_DATE	Date the matching claim form was received.	DATE	CONSTANTS	TO_DATE('31-DEC-2099', 'DD-MON-YYYY')	NO	NO	ANALYZE FUNDRAISING
MATCH_CLAIM_STATUS_DATE	Matching claim status date.	DATE	CONSTANTS	TO_DATE('31-DEC-2099', 'DD-MON-YYYY')	NO	NO	ANALYZE FUNDRAISING
MATCH_CREDIT_RECIPIENT_COUNT	Count of all donors that received soft credit from matching gifts.	NUMBER	CONSTANTS	NULL	NO	NO	ANALYZE FUNDRAISING
MATCH_GIFT_AMOUNT	Matching gift amount.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
MATCH_GIFT_COUNT	Count of all expected or paid matching gifts associated to this gift/payment.	NUMBER	CONSTANTS	NULL	NO	NO	ANALYZE FUNDRAISING
MATCH_GIFT_DONOR_COUNT	Count of all donors that gave matching gifts.	NUMBER	CONSTANTS	NULL	NO	NO	ANALYZE FUNDRAISING
MATCH_GIFT_SOFT_CREDIT_AMOUNT	Matching gift soft credit amount given to the donor being matched.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
MEMBERSHIP_GROUP_KEY		NUMBER	TRANSLATIONS	MEMBERSHIP_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
MG_CREDIT_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping matched gifts.	VARCHAR2(63)	TRANSLATIONS	MG_CREDIT_GROUP_IDENTIFIER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
MULTI_SOURCE_KEY		NUMBER	WFT_ADDRESS WFT_MAIL_TRACKING	MULTI_SOURCE_KEY MULTI_SOURCE_KEY	NO NO	NO	ANALYZE FUNDRAISING  ANALYZE FUNDRAISING
NET_PRESENT_VALUE_AMOUNT	Gift net present value.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
NEW_GIFT_DONOR_COUNT	Count of donors receiving credit for their first gift.	NUMBER	TRANSLATIONS	NEW_GIFT_DONOR_COUNT_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
NEW_GIFT_OR_PLEDGE_DONOR_COUNT	Count of donors receiving credit for their first gift or pledge.	NUMBER	TRANSLATIONS	NEW_GIFT_OR_PLEDGE_DONOR_COUNT_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
NON_MATCHED_SOFT_CREDIT_AMOUNT	Gift soft credit amount given to the donor that does not belong to matching.	NUMBER	WFT_PLEDGE	SOFT_CREDIT_AMOUNT	NO	NO	ANALYZE FUNDRAISING
OUTRIGHT_GIFT_AMOUNT	Hard credit amount received by the donor for a gift not associated to a pledge.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
OUTRIGHT_GIFT_SOFT_CREDIT_AMT	Soft credit amount received by the donor for a gift not associated to a pledge.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
OVERALL_PLEDGE_BALANCE	Total amount remaining on the pledge not met by gifting.	NUMBER	WFT_PLEDGE	OVERALL_PLEDGE_BALANCE	NO	NO	ANALYZE FUNDRAISING
OVERALL_TRANSACTION_AMOUNT	Total transaction amount of the individual gift/payment or individual pledge received.	NUMBER	WFT_PLEDGE	OVERALL_TRANSACTION_AMOUNT	NO	NO	ANALYZE FUNDRAISING
PHONE_GROUP_KEY		NUMBER	TRANSLATIONS	PHONE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PLEDGE_AMOUNT	Hard credit amount received by the donor for the pledge.	NUMBER	WFT_PLEDGE	HARD_CREDIT_AMOUNT	NO	NO	ANALYZE FUNDRAISING
PLEDGE_AMOUNT_PAID	Pledge amount paid with pledge payments.	NUMBER	WFT_PLEDGE	PLEDGE_AMOUNT_PAID	NO	NO	ANALYZE FUNDRAISING
PLEDGE_BALANCE	Amount remaining on the pledge not met by gifting.	NUMBER	WFT_PLEDGE	PLEDGE_BALANCE	NO	NO	ANALYZE FUNDRAISING
PLEDGE_DETAIL_KEY		NUMBER	WFT_PLEDGE	PLEDGE_DETAIL_KEY	NO	NO	ANALYZE FUNDRAISING
PLEDGE_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping pledge payments for a gift.	VARCHAR2(63)	TRANSLATIONS	PLEDGE_GROUP_IDENTIFIER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PLEDGE_KEY		NUMBER	WFT_PLEDGE	PLEDGE_KEY	NO	NO	ANALYZE FUNDRAISING
PLEDGE_PAYMENT_AMOUNT	Hard credit amount received by the donor for a gift made as a pledge payment.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
PLEDGE_PAYMENT_SOFT_CREDIT_AMT	Soft credit amount received by the donor for a gift made as a pledge payment.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
PLEDGE_SOFT_CREDIT_AMOUNT	Soft credit amount received by the donor for the pledge.	NUMBER	WFT_PLEDGE	SOFT_CREDIT_AMOUNT	NO	NO	ANALYZE FUNDRAISING
PLEDGE_WRITTEN_OFF_DATE	Date a pledge was written off.	DATE	TRANSLATIONS	PLEDGE_WRITTEN_OFF_DATE_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PREMIUM_COUNT	Count of premiums linked to the pledge or gift.	NUMBER	WFT_PLEDGE	PLEDGE_PREMIUM_COUNT	NO	NO	ANALYZE FUNDRAISING
PRIMARY_ASSIGNMENT_ENTITY_KEY		NUMBER	TRANSLATIONS	PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PRIMARY_ASSIGNMENT_ENTITY_UID	System generated unique internal identification number assigned to this primary assigned staff member.	NUMBER	TRANSLATIONS	PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PRIMARY_ASSIGNMENT_KEY		NUMBER	TRANSLATIONS	PRIMARY_ASSIGNMENT_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PRIMARY_ASSIGNMENT_OFFICE_KEY		NUMBER	TRANSLATIONS	PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PRIMARY_ASSIGNMENT_STAFF_KEY		NUMBER	TRANSLATIONS	PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PRIMARY_ASSIGNMENT_UNIT_KEY		NUMBER	TRANSLATIONS	PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
PROPOSAL_KEY		NUMBER	WFT_PLEDGE	PROPOSAL_KEY	NO	NO	ANALYZE FUNDRAISING
PROPOSAL_PROSPECT_KEY		NUMBER	WFT_PROPOSAL	PROSPECT_KEY	NO	NO	ANALYZE FUNDRAISING
RELATIONSHIP_GROUP_KEY		NUMBER	TRANSLATIONS	RELATIONSHIP_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
REUNION_CAMPAIGN_KEY		NUMBER	WFT_PLEDGE	REUNION_CAMPAIGN_KEY	NO	NO	ANALYZE FUNDRAISING
SOFT_CREDIT_AMOUNT	Soft credit amount received by the donor for the pledge or gift/payment.	NUMBER	WFT_PLEDGE	SOFT_CREDIT_AMOUNT	NO	NO	ANALYZE FUNDRAISING
SOFT_CREDIT_DONOR_COUNT	Count of all donors that received soft credit for gifts or pledges.	NUMBER	WFT_PLEDGE	SOFT_CREDIT_DONOR_COUNT	NO	NO	ANALYZE FUNDRAISING
SOURCE_CE_ATTRIB_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	CONSTITUENT_ENTITY_ATTRIB_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_CE_TYPE_GROUP_KEY		NUMBER	TRANSLATIONS	SOURCE_CE_TYPE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
SOURCE_DEMOGRAPHIC_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	DEMOGRAPHIC_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_DONORSPSE_NONENTITY_KEY		NUMBER	WFT_RELATIONSHIP	NON_ENTITY_RELATION_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_DONOR_ENTITY_KEY		NUMBER	WFT_PLEDGE	SOURCE_DONOR_ENTITY_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_DONOR_ID	Source donor's identification number used to access the records associated with that donor. Source donor is the donor of origin associated with the giving transaction.	VARCHAR2(63)	WFT_CONSTITUENT_ENTITY	ENTITY_ID	NO	NO	ANALYZE FUNDRAISING
SOURCE_DONOR_SPOUSE_ENTITY_KEY		NUMBER	WFT_RELATIONSHIP	RELATED_ENTITY_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_DONOR_SPOUSE_UID	System generated, unique, internal identification number assigned to the spouse entity that is related to the source donor.	NUMBER	WFT_RELATIONSHIP	RELATED_ENTITY_UID	NO	NO	ANALYZE FUNDRAISING
SOURCE_DONOR_UID	System generated, unique, internal identification number assigned to this source donor (person or organization entity) that has a relationship of some kind.	NUMBER	WFT_PLEDGE	SOURCE_DONOR_UID	NO	NO	ANALYZE FUNDRAISING
SOURCE_PREF_ADDRESS_TYPE_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_ADDRESS_TYPE_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_PREF_CLASS_SCHOOL_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_CLASS_SCHOOL_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_PREF_POSTAL_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_POSTAL_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_PREF_STREET_LINE_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PREFERRED_STREET_LINE_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_PRIMARY_CE_TYPE_KEY		NUMBER	WFT_CONSTITUENT_ENTITY	PRIMARY_CE_TYPE_KEY	NO	NO	ANALYZE FUNDRAISING
SOURCE_SPOUSE_GROUP_IDENTIFIER	System generated, unique, internal primary key for grouping source donor spouse relationships.	VARCHAR2(63)	SPOUSE_GROUP_IDENTIFIERS	SOURCE_SPOUSE_GROUP_IDENTIFIER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
SPECIAL_PURPOSE_GROUP_KEY		NUMBER	TRANSLATIONS	SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
SPORT_GROUP_KEY		NUMBER	TRANSLATIONS	SPORT_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
STUDENT_ACTIVITY_GROUP_KEY		NUMBER	TRANSLATIONS	STUDENT_ACTIVITY_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'ANALYZE_FUNDRAISING_A1'	NO	NO	ANALYZE FUNDRAISING
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
THIRD_PARTY_PAYMENT_AMOUNT		NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
TOTAL_COMMITTED_AMOUNT	Hard credit amount received by the donor for outright gifts, pledges or matching gifts.	NUMBER	WFT_PLEDGE	HARD_CREDIT_AMOUNT	NO	NO	ANALYZE FUNDRAISING
TOTAL_PREMIUM_AMOUNT	Total amount of premiums linked to the pledge or gift.	NUMBER	WFT_PLEDGE	TOTAL_PLEDGE_PREMIUM_AMOUNT	NO	NO	ANALYZE FUNDRAISING
TOTAL_RECEIVED_AMOUNT	Hard credit amount received by the donor for outright gifts, pledge payments or matching gifts.	NUMBER	CONSTANTS	0	NO	NO	ANALYZE FUNDRAISING
TRANSACTION_COUNT	Count of all pledges or gifts.	NUMBER	WFT_PLEDGE	TRANSACTION_COUNT	NO	NO	ANALYZE FUNDRAISING
TRANSACTION_DATE_OF_RECORD	Date a gift or pledge transaction is received.	DATE	WFT_PLEDGE	PLEDGE_DATE_OF_RECORD	NO	NO	ANALYZE FUNDRAISING
TRANSACTION_NUMBER	Gift transaction receipt number. All gifts associated with one primary gift or a matching gift will have the same gift number.	VARCHAR2(63)	TRANSLATIONS	TRANSACTION_NUMBER_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
TRANSACTION_RECEIPT_DATE	Date a gift receipt or pledge receipt was system generated.	DATE	TRANSLATIONS	TRANSACTION_RECEIPT_DATE_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
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
VARIABLE_PURPOSE_GROUP_KEY		NUMBER	TRANSLATIONS	VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING
YEAR_OF_GIVING	Unique identifier or code for the fiscal year in which this gift was credited.	VARCHAR2(63)	WDT_YEAR_OF_GIVING	YEAR_OF_GIVING	NO	NO	ANALYZE FUNDRAISING
YEAR_OF_GIVING_KEY		NUMBER	WFT_PLEDGE	YEAR_OF_GIVING_KEY	NO	NO	ANALYZE FUNDRAISING

Ver: 9.0