Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
LATEST_PROPOSAL_STAGE_IND	Indicates whether this is the last proposal purpose stage.	NUMBER	CONSTANT	1	NO	NO	PROPOSAL STAGE
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PROPOSAL STAGE
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	CLN_PROPOSAL	PROPOSAL_KEY	NO	NO	PROPOSAL STAGE
PROPOSAL_STAGE_END_DATE	Stage end date of the proposal.	DATE	CONSTANT	TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' )	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 STAGE
PROPOSAL_STAGE_START_DATE	Stage start date of the proposal.	DATE	EXPRESSION	PROPOSAL_STAGE_START_DATE_EXPRESSION	NO	NO	PROPOSAL STAGE
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	PROPOSAL STAGE
STAGE_ID	Stage unique identification.	NUMBER	CONSTANT	0	NO	NO	PROPOSAL STAGE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'PROPOSAL_STAGE_F1B'	NO	NO	PROPOSAL STAGE
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