Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
DONOR_UID	System generated number that is internally generated to uniquely identify the donor.	NUMBER	PLEDGE_AMTS	DONOR_UID	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
GIVING_TOTAL_KEY		NUMBER	EXPRESSION	GIVING_TOTAL_KEY_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
GIVING_YEAR	System generated number that is internally generated to uniquely identify the donor.	VARCHAR2(63)	WDT_YEAR_OF_GIVING	YEAR_OF_GIVING	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'GIVING_TOTAL_D3B'	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
TOTAL_AMOUNT_MATCHED	Total matching gift amount credited to this constituent for the Year of Giving. For a person, this includes the total amount of realized matching gift credit for this person's giving. For an organization, this includes the total matching gift payments made by this organization.	NUMBER	EXPRESSION	TOTAL_AMOUNT_MATCHED_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
TOTAL_ANNUAL_AMOUNT_MATCHED	Total matching gifts amount credited to this donor for annual giving allocations during this fiscal year. For a person, this field contains matching gift amounts that matched this person's gifts. For an organization, this field contains matching gift amounts made by this organization.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_ANNUAL_HARD_CREDIT	Total legal gift amount credited to this donor for annual giving designations during this fiscal year.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_ANNUAL_SOFT_CREDIT	Total associated gift credit amount credited to this donor for annual giving allocations during this fiscal year.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_CREDIT2_AMOUNT	Total credit2 amounts credited to this donor for non-annual giving allocations during this fiscal year.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_HARD_CREDIT	Total legal gift amount credited to this donor for both annual and non-annual giving allocations during this fiscal year.	NUMBER	EXPRESSION	TOTAL_HARD_CREDIT_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
TOTAL_OTHER_AMOUNT_MATCHED	Total matching gifts amount credited to this donor for non-annual giving allocations during this fiscal year. For a person, this field contains matching gift amounts that matched this person's gifts. For an organization, this field contains matching gift amounts made by this organization.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_OTHER_HARD_CREDIT	Total legal gift amount credited to this entity for non annual giving designations during this fiscal year.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_OTHER_SOFT_CREDIT	Total associated gift credit amount credited to this donor for non-annual giving allocations during this fiscal year.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
TOTAL_PLEDGE_BALANCE_AMOUNT	Total pledge balance contains the amount still due on 'qualifying' pledge(s).	NUMBER	EXPRESSION	TOTAL_PLEDGE_BALANCE_AMOUNT_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
TOTAL_SOFT_CREDIT	Total associated gift credit amount credited to this donor for annual and non-annual giving allocations during this fiscal year.	NUMBER	EXPRESSION	TOTAL_SOFT_CREDIT_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION
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