Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_PROPOSAL_COUNT	Number of active proposals.	NUMBER	DEPENDENT_EXPR	ACTIVE_PROPOSAL_COUNT_EXPRESSION	NO	NO	PROPOSAL
FIRST_PROPOSAL_RESULT_DATE	First date a proposal result was recorded.	DATE	EXPRESSIONS	FIRST_PROPOSAL_RESULT_DATE_EXPRESSION	NO	NO	PROPOSAL
LATEST_PROPOSAL_ASK_AMOUNT	Proposal last requested ask amount.	NUMBER	EXPRESSIONS	LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION	NO	NO	PROPOSAL
LATEST_PROPOSAL_ASK_DATE	Proposal last date an ask amount was requested.	DATE	EXPRESSIONS	LATEST_PROPOSAL_ASK_DATE_EXPRESSION	NO	NO	PROPOSAL
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PROPOSAL
PROPOSAL_ASK_AMOUNT	Proposal actual ask amount.	NUMBER	EXPRESSIONS	PROPOSAL_ASK_AMOUNT_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_ASK_MADE_IND	Indicates whether this proposal has had an ask amount requested.	NUMBER	EXPRESSIONS	PROPOSAL_ASK_MADE_IND_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_ASSIGNED_COUNT	Number of assigned proposals.	NUMBER	DEPENDENT_EXPR	PROPOSAL_ASSIGNED_COUNT_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_ASSIGNED_IND	Indicates whether this proposal has been assigned.	NUMBER	EXPRESSIONS	PROPOSAL_ASSIGNED_IND_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_ATTRIBUTE_KEY	System generated, unique, internal primary key for donor proposal attributes.	NUMBER	CLN_PROPOSAL_ATTRIBUTE	PROPOSAL_ATTRIBUTE_KEY	NO	NO	PROPOSAL
PROPOSAL_CAMPAIGN_KEY	System generated, unique, internal primary key for a campaign.	NUMBER	DEFAULTS	0	NO	NO	PROPOSAL
PROPOSAL_COUNT	Number of proposals.	NUMBER	CLN_PROPOSAL	PROPOSAL_KEY	NO	NO	PROPOSAL
PROPOSAL_DURATION	Proposal duration.	NUMBER	EXPRESSIONS	PROPOSAL_DURATION_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_GIFT_RESULT_AMOUNT	Total of all gift amounts for the proposal.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_GRANTED_AMOUNT	Proposal granted amount.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_GRANTED_COUNT	Number of granted proposals.	NUMBER	DEFAULTS	NULL	NO	NO	PROPOSAL
PROPOSAL_GRANTED_IND	Indicates whether this proposal has been granted.	NUMBER	DEFAULTS	NULL	NO	NO	PROPOSAL
PROPOSAL_INIT_CONTRIB_AMOUNT	Proposal initial contribution amount.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_INIT_CONTRIB_DATE	Proposal initial contribution date.	DATE	DEFAULTS	TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' )	NO	NO	PROPOSAL
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	CLN_PROPOSAL	PROPOSAL_KEY	NO	NO	PROPOSAL
PROPOSAL_ORIGINAL_ASK_AMOUNT	Proposal original ask amount.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_PLEDGE_PMT_RESULT_AMT	Total of all pledge payments for the proposal.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_PLEDGE_RESULT_AMOUNT	Total of all pledge amounts for the proposal.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_STAGE_KEY	System generated, unique, internal primary key for the stage of a proposal.	NUMBER	CLN_STAGE	STAGE_KEY	NO	NO	PROPOSAL
PROPOSAL_START_DATE	Proposal start date.	DATE	EXPRESSIONS	PROPOSAL_START_DATE_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_STOP_DATE	Proposal stop date.	DATE	EXPRESSIONS	PROPOSAL_STOP_DATE_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_TARGET_AMOUNT	Proposal targeted amount.	NUMBER	AMBPROP	AMBPROP_ASK_AMOUNT	NO	NO	PROPOSAL
PROPOSAL_TARGET_DATE	Proposal target date.	DATE	EXPRESSIONS	PROPOSAL_TARGET_DATE_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_TOTAL_RESULT_AMOUNT	Total of all results for the proposal.	NUMBER	EXPRESSIONS	PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION	NO	NO	PROPOSAL
PROPOSAL_UNIT_KEY	System generated, unique, internal primary key for the school or unit.	NUMBER	DEFAULTS	0	NO	NO	PROPOSAL
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	PROPOSAL
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	DEFAULTS	'PROPOSAL_F1B'	NO	NO	PROPOSAL
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