Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_PROPOSAL_PURPOSE_COUNT	Number of active proposal purposes.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
ADVANCEMENT_PROGRAM_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
ADVANCEMENT_PROGRAM_YEAR_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
DESIGNATION_DETAIL_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
DESIGNATION_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
FIRST_PROP_PURPOSE_RESULT_DATE	First date a proposal purpose result was recorded.	DATE	EXPRESSION_1	FIRST_PROP_PURPOSE_RESULT_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
FUNDRAISING_INITIATIVE_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
LAST_PROPOSAL_PURPOSE_ASK_AMT	Last proposal purpose ask amount.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
LAST_PROPOSAL_PURPOSE_ASK_DATE	Last date an ask amount was recorded for the proposal purpose.	DATE	EXPRESSION_1	LAST_PROPOSAL_PURPOSE_ASK_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
MULTI_SOURCE_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_ACTIVE_IND	Indicates whether this proposal purpose is active.	NUMBER	EXPRESSION_1	PROPOSAL_PURPOSE_ACTIVE_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_ASK_AMOUNT	Proposal purpose ask amount.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_ASK_MADE_IND	Indicates whether this proposal purpose had an ask made for the prospect.	NUMBER	EXPRESSION_1	PROPOSAL_PURPOSE_ASK_MADE_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_COUNT	Number of proposal purposes.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_END_DATE	Proposal purpose end date.	DATE	EXPRESSION_1	PROPOSAL_PURPOSE_END_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_GRANTED_AMT	Proposal purpose granted amount.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_GRANTED_IND	Indicates whether the proposal purpose has been granted by the prospect. This indicator is set to an affirmative if the proposal purpose granted amount is greater than zero.	NUMBER	EXPRESSION_1	PROPOSAL_PURPOSE_GRANTED_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_ORIG_ASK_AMT	Original requested ask amount for the proposal purpose.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_RESULT_AMOUNT	Proposal purpose value.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_RESULT_IND	Indicates whether the proposal purpose resulted in an amount greater than zero.	NUMBER	EXPRESSION_1	PROPOSAL_PURPOSE_RESULT_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_STAGE_DATE	System generated, unique, internal primary key for the stage of a proposal purpose.	DATE	EXPRESSION_1	PROPOSAL_PURPOSE_STAGE_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_STAGE_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_START_DATE	Proposal purpose start date.	DATE	EXPRESSION_1	PROPOSAL_PURPOSE_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_TARGET_AMOUNT	Proposal purpose targeted amount.	NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_TARGET_DATE	Proposal purpose target ask date.	DATE	EXPRESSION_1	PROPOSAL_PURPOSE_TARGET_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE B
PROPOSAL_PURPOSE_UNIT_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
PROSPECT_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
PROSPECT_PIPELINE_GROUP_B_KEY		NUMBER	CONSTANT	0	NO	NO	MANAGE PROSPECT PIPELINE B
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'MANAGE_PROSPECT_PIPELINE_B_A1'	NO	NO	MANAGE PROSPECT PIPELINE B
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 B
USER_MEASURE_02		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
USER_MEASURE_03		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
USER_MEASURE_04		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B
USER_MEASURE_05		NUMBER	CONSTANT	NULL	NO	NO	MANAGE PROSPECT PIPELINE B

Ver: 9.0