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

Ver: 8.2