Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
AGE	Calculated by a function that subtracts the birth date from the load date.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
ALUMNI_HEADCOUNT	Headcount of all constituents that have a primary donor category specified in the the EDW Extract Parameter to identify them as an alumnus of the institution.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID- EDW_ADV_GIFT_EXTR.F_GET_ADVANCEMENT_GIFT : IF MAT_CONSTITUENT_ENTITY FOR THE CALENDAR YEAR AND PRIMARY_DONOR_CATEGORY = MTVPARM EXTRACT PARAMETER [ALUMNI_IND]	NO	NO	ADVANCEMENT GIFT
AUXILIARY_ACTUAL_VALUE	Dependent on the corresponding auxiliary code. May include the amount of the gift to be designated to a particular donor category or class year, the actual cost to the institution for a benefit/premium, or the face value of a gift.	NUMBER	GIFT_AUXILIARY	ACTUAL_VALUE	NO	NO	ADVANCEMENT GIFT
AUXILIARY_VALUE	Dependent on the corresponding auxiliary code. May include the fair market value of an associated benefit/premium, or the present market value of a gift.	NUMBER	GIFT_AUXILIARY	AUXILIARY_VALUE	NO	NO	ADVANCEMENT GIFT
CAMPAIGN_KEY	Key for the campaign dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
CONSTITUENT_KEY	Key for the constituent dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
DESIGNATION_DETAIL_KEY	System generated, unique, internal primary key for a designation detail record.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADVANCEMENT GIFT  ADVANCEMENT GIFT
DESIGNATION_KEY	Key for the designation dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
ENTITY_UID	Unique identifier for the person or organization.	NUMBER	CONSTITUENT ORGANIZATIONAL_CONSTITUENT	PERSON_UID ENTITY_UID	NO NO	NO	ADVANCEMENT GIFT  ADVANCEMENT GIFT
GIFT_AMOUNT	Amount raised in a calendar year. This may be used to calculate a sum of all gift amounts within a time frame or for a defined grouping of constituents such as alumni.	NUMBER	GIFT	GIFT_AMOUNT	NO	NO	ADVANCEMENT GIFT
GIFT_DETAIL_KEY	System generated, unique, internal primary key for a gift.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADVANCEMENT GIFT  ADVANCEMENT GIFT
GIFT_KEY	Key for the gift dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
GIFT_NUMBER	Gift number associated with the donation.	VARCHAR2(63)	GIFT_AUXILIARY	GIFT_NUMBER	NO	NO	ADVANCEMENT GIFT
GIVING_ATTRIBUTE_KEY	System generated, unique, internal primary key for a giving attribute.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADVANCEMENT GIFT  ADVANCEMENT GIFT
MAJOR_GIFT_AMOUNT	Identifies this gift amount is considered a major gift. This amount should be used in the calculation of the percent of gifts in the calendar year/calendar month considered major gifts.	NUMBER	GIFT	GIFT_AMOUNT- EDW_ADV_GIFT_EXTR.F_GET_ADVANCEMENT_GIFT :GIFT_AMOUNT EQUAL TO OR GREATER THAN MTVPARM EXTRACT PARAMETER [MAJOR_GIFT_AMOUNT]	NO	NO	ADVANCEMENT GIFT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
ORIGINAL_PLEDGE_AMOUNT	Amount assigned when this was pledged to the institution.	NUMBER	PLEDGE	PLEDGE_AMOUNT	NO	NO	ADVANCEMENT GIFT
OUTSTANDING_PLEDGE_AMOUNT	Amount of the original pledged amount that has not been collected.	NUMBER	PLEDGE	PLEDGE_BALANCE	NO	NO	ADVANCEMENT GIFT
PLEDGE_DETAIL_KEY	System generated, unique, internal primary key for a pledge detail.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADVANCEMENT GIFT  ADVANCEMENT GIFT
PLEDGE_KEY	Key for the pledge dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
PLEDGE_NUMBER	Match the PLEDGE_NUMBER on the GIFT with the PLEDGE_NUMBER on the PLEDGE.	VARCHAR2(63)	GIFT	PLEDGE_NUMBER	NO	NO	ADVANCEMENT GIFT
PLEDGE_RANGE_KEY	Key for the pledge range dimension.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADVANCEMENT GIFT  ADVANCEMENT GIFT
POSTAL_KEY	Key for the postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT

Ver: 9.0