Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADVANCEMENT_PROGRAM_KEY	System generated, unique, internal primary key for advancement program.	NUMBER	CONSTANT	0	NO	NO	PROSPECT INTEREST
ADVANCEMENT_PROGRAM_YEAR_KEY	System generated, unique, internal primary key for an advancement program year.	NUMBER	CONSTANT	0	NO	NO	PROSPECT INTEREST
ENTITY_KEY	System generated, unique, internal primary key for a prospect entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	PROSPECT INTEREST
ENTITY_PROS_INTEREST_GROUP_KEY		NUMBER	EXPRESSION	ENTITY_PROS_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	PROSPECT INTEREST
ENTITY_UID	System generated unique internal identification number assigned to this prospect.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PROSPECT INTEREST
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a prospect purpose.	NUMBER	CLN_FUNDRAISING_INITIATIVE	FUNDRAISING_INITIATIVE_KEY	NO	NO	PROSPECT INTEREST
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PROSPECT INTEREST
PROSPECT_INTEREST_GROUP_KEY		NUMBER	EXPRESSION	PROSPECT_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INTEREST_ID	Prospect interest identification.	NUMBER	EXPRESSION	PROSPECT_INTEREST_ID_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INTEREST_STAGE_KEY	System generated, unique, internal primary key for the stage of a prospect interest.	NUMBER	CLN_STAGE	STAGE_KEY	NO	NO	PROSPECT INTEREST
PROSPECT_INTEREST_UNIT_KEY	System generated, unique, internal primary key for the school or unit.	NUMBER	CONSTANT	0	NO	NO	PROSPECT INTEREST
PROSPECT_INT_ACTIVE_IND	Indicates whether the prospect interest is active.	NUMBER	EXPRESSIONS	PROSPECT_INT_ACTIVE_IND_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_ASK_AMOUNT	Prospect interest ask amount.	NUMBER	EXPRESSIONS	PROSPECT_INT_ASK_AMOUNT_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_END_DATE	Prospect interest ending date.	DATE	EXPRESSIONS	PROSPECT_INT_END_DATE_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_LATEST_ASK	Last ask amount recorded for this prospect's interest.	NUMBER	EXPRESSIONS	PROSPECT_INT_LATEST_ASK_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_LATEST_ASK_DATE	Last date an ask amount was recorded for this prospect's interest.	DATE	EXPRESSIONS	PROSPECT_INT_LATEST_ASK_DATE_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_START_DATE	Prospect interest start date.	DATE	EXPRESSIONS	PROSPECT_INT_START_DATE_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_STATUS_DATE	Date the prospect interest was created or last updated.	DATE	EXPRESSIONS	PROSPECT_INT_STATUS_DATE_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_TARGET_AMOUNT	Target ask amount for the constituent's interest.	NUMBER	EXPRESSIONS	PROSPECT_INT_TARGET_AMOUNT_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_INT_TARGET_DATE	Target ask date for the constituent's interest.	DATE	EXPRESSIONS	PROSPECT_INT_TARGET_DATE_EXPRESSION	NO	NO	PROSPECT INTEREST
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	PROSPECT INTEREST
PROS_PGM_YR_ID	System generated identification using the prospect identification, program code, and program year.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'PROSPECT_INTEREST_F1B'	NO	NO	PROSPECT INTEREST
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

Ver: 9.0