Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_PROSPECT_INTEREST_COUNT	Number of active prospects with this interest.	NUMBER	EXPRESSION	ACTIVE_PROSPECT_INTEREST_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
ADVANCEMENT_PROGRAM_KEY		NUMBER	WFT_PROSPECT_INTEREST	ADVANCEMENT_PROGRAM_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
ADVANCEMENT_PROGRAM_YEAR_KEY		NUMBER	WFT_PROSPECT_INTEREST	ADVANCEMENT_PROGRAM_YEAR_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
FUNDRAISING_INITIATIVE_KEY		NUMBER	WFT_PROSPECT_INTEREST	FUNDRAISING_INITIATIVE_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
LAST_PROSP_INT_ASK_AMOUNT	Last ask amount recorded for this prospect's interest.	NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INT_LATEST_ASK	NO	NO	MANAGE PROSPECT PIPELINE A
LAST_PROSP_INT_ASK_DATE	Last date an ask amount was recorded for this prospect's interest.	DATE	EXPRESSION_0	LAST_PROSP_INT_ASK_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
MULTI_SOURCE_KEY		NUMBER	WFT_PROSPECT	MULTI_SOURCE_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_ACTIVE_IND	Indicates whether the prospect interest is active.	NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INT_ACTIVE_IND	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_ASK_AMOUNT	Prospect interest ask amount.	NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INT_ASK_AMOUNT	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_COUNT	Number of prospects with this interest.	NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INTEREST_ID	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_END_DATE	Prospect interest ending date.	DATE	EXPRESSION_0	PROSPECT_INTEREST_END_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_ID	Prospect interest identification.	NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INTEREST_ID	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_STAGE_KEY		NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INTEREST_STAGE_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_START_DATE	Prospect interest start date.	DATE	EXPRESSION_0	PROSPECT_INTEREST_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_STATUS_DATE	Date the prospect interest was created or last updated.	DATE	EXPRESSION_0	PROSPECT_INTEREST_STATUS_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_TARGET_AMT	Target ask amount for the constituent's interest.	NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INT_TARGET_AMOUNT	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_TARGET_DATE	Target ask date for the constituent's interest.	DATE	EXPRESSION_0	PROSPECT_INTEREST_TARGET_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_UNIT_KEY		NUMBER	WFT_PROSPECT_INTEREST	PROSPECT_INTEREST_UNIT_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_INT_ASK_MADE_IND	Indicates whether and ask amount was made for this prospect's interest.	NUMBER	EXPRESSION	PROSPECT_INT_ASK_MADE_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_KEY		NUMBER	WFT_PROSPECT	PROSPECT_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
PROSPECT_PIPELINE_GROUP_A_KEY		NUMBER	WFT_PROSPECT	PROSPECT_KEY	NO	NO	MANAGE PROSPECT PIPELINE A
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'MANAGE_PROSPECT_PIPELINE_A_A1'	NO	NO	MANAGE PROSPECT PIPELINE A
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	CONSTANT	SYSDATE	NO	NO
USER_MEASURE_01		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE A
USER_MEASURE_02		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE A
USER_MEASURE_03		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE A
USER_MEASURE_04		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE A
USER_MEASURE_05		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE A

Ver: 8.4.2