Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ENTITY_KEY	System generated, unique, internal primary key for a prospect entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	PROPOSAL PURPOSE RESULT
ENTITY_UID	System generated unique internal identification number assigned to this prospect.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PROPOSAL PURPOSE RESULT
FIRST_PROPOSAL_PURP_RESULT_IND	Indicates whether this is the first proposal purpose result.	NUMBER	EXPRESSION	FIRST_PROPOSAL_PURP_RESULT_IND_EXPRESSION	NO	NO	PROPOSAL PURPOSE RESULT
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal and proposal purpose.	NUMBER	CLN_FUNDRAISING_INITIATIVE	FUNDRAISING_INITIATIVE_KEY	NO	NO	PROPOSAL PURPOSE RESULT
LAST_PROPOSAL_PURP_RESULT_IND	Indicates whether this is the last proposal purpose result.	NUMBER	EXPRESSION	LAST_PROPOSAL_PURP_RESULT_IND_EXPRESSION	NO	NO	PROPOSAL PURPOSE RESULT
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PROPOSAL PURPOSE RESULT
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	CLN_PROPOSAL	PROPOSAL_KEY	NO	NO	PROPOSAL PURPOSE RESULT
PROPOSAL_PURPOSE_RESULT_AMOUNT	Proposal purpose value.	NUMBER	EXPRESSION	PROPOSAL_PURPOSE_RESULT_AMOUNT_EXPRESSION	NO	NO	PROPOSAL PURPOSE RESULT
PROPOSAL_PURPOSE_RESULT_DATE	Date the proposal purpose result was recorded.	DATE	EXPRESSION	PROPOSAL_PURPOSE_RESULT_DATE_EXPRESSION	NO	NO	PROPOSAL PURPOSE RESULT
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	PROPOSAL PURPOSE RESULT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'PROPOSAL_PURPOSE_RESULT_F1B'	NO	NO	PROPOSAL PURPOSE RESULT
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