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	CONSTANT EXPRESSION	NULL ACTIVE_PROSPECT_INTEREST_COUNT_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
ADVANCEMENT_PROGRAM_KEY		NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 ADVANCEMENT_PROGRAM_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
ADVANCEMENT_PROGRAM_YEAR_KEY		NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 ADVANCEMENT_PROGRAM_YEAR_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
FUNDRAISING_INITIATIVE_KEY		NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 FUNDRAISING_INITIATIVE_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
LAST_PROSP_INT_ASK_AMOUNT	Last ask amount recorded for this prospect's interest.	NUMBER	CONSTANT WFT_PROSPECT_INTEREST	NULL PROSPECT_INT_LATEST_ASK	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
LAST_PROSP_INT_ASK_DATE	Last date an ask amount was recorded for this prospect's interest.	DATE	CONSTANT EXPRESSION_0	TO_DATE('31-DEC-2099','DD-MON-YYYY') LAST_PROSP_INT_ASK_DATE_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
MULTI_SOURCE_KEY		NUMBER	CONSTANT WFT_PROSPECT	0 MULTI_SOURCE_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_ACTIVE_IND	Indicates whether the prospect interest is active.	NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 PROSPECT_INT_ACTIVE_IND	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_ASK_AMOUNT	Prospect interest ask amount.	NUMBER	CONSTANT WFT_PROSPECT_INTEREST	NULL PROSPECT_INT_ASK_AMOUNT	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_COUNT	Number of prospects with this interest.	NUMBER	CONSTANT WFT_PROSPECT_INTEREST	NULL PROSPECT_INTEREST_ID	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_END_DATE	Prospect interest ending date.	DATE	CONSTANT EXPRESSION_0	TO_DATE('31-DEC-2099','DD-MON-YYYY') PROSPECT_INTEREST_END_DATE_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_ID	Prospect interest identification.	NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 PROSPECT_INTEREST_ID	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_STAGE_KEY		NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 PROSPECT_INTEREST_STAGE_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_START_DATE	Prospect interest start date.	DATE	CONSTANT EXPRESSION_0	TO_DATE('31-DEC-2099','DD-MON-YYYY') PROSPECT_INTEREST_START_DATE_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_STATUS_DATE	Date the prospect interest was created or last updated.	DATE	CONSTANT EXPRESSION_0	TO_DATE('31-DEC-2099','DD-MON-YYYY') PROSPECT_INTEREST_STATUS_DATE_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_TARGET_AMT	Target ask amount for the constituent's interest.	NUMBER	CONSTANT WFT_PROSPECT_INTEREST	NULL PROSPECT_INT_TARGET_AMOUNT	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_TARGET_DATE	Target ask date for the constituent's interest.	DATE	CONSTANT EXPRESSION_0	TO_DATE('31-DEC-2099','DD-MON-YYYY') PROSPECT_INTEREST_TARGET_DATE_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INTEREST_UNIT_KEY		NUMBER	CONSTANT WFT_PROSPECT_INTEREST	0 PROSPECT_INTEREST_UNIT_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_INT_ASK_MADE_IND	Indicates whether and ask amount was made for this prospect's interest.	NUMBER	CONSTANT EXPRESSION	1 PROSPECT_INT_ASK_MADE_IND_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_KEY		NUMBER	CONSTANT WFT_PROSPECT	0 PROSPECT_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  MANAGE PROSPECT PIPELINE A
PROSPECT_PIPELINE_GROUP_A_KEY		NUMBER	CONSTANT WFT_PROSPECT	0 PROSPECT_KEY	NO NO	NO	MANAGE PROSPECT PIPELINE A  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: 9.0