Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
LATEST_PROSPECT_STAGE_IND	Determines whether this is the last stage for the prospect.	TABLE	EXPRESSION	LATEST_PROSPECT_STAGE_IND_EXPRESSION	NO	NO	PROSPECT STAGE
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	TABLE	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	PROSPECT STAGE
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	TABLE	CLN_PROSPECT	PROSPECT_KEY	NO	NO	PROSPECT STAGE
PROSPECT_STAGE_END_DATE	Stage ending date of the prospect.	TABLE	EXPRESSION	PROSPECT_STAGE_END_DATE_EXPRESSION	NO	NO	PROSPECT STAGE
PROSPECT_STAGE_KEY	System generated, unique, internal primary key for the stage of a prospect.	TABLE	CLN_STAGE	STAGE_KEY	NO	NO	PROSPECT STAGE
PROSPECT_STAGE_START_DATE	Stage start date of the prospect.	TABLE	EXPRESSION	PROSPECT_STAGE_START_DATE_EXPRESSION	NO	NO	PROSPECT STAGE
PROS_PGM_YR_ID	System generated identification using the prospect identification, program code, and program year.	TABLE	NO SOURCE	NO SOURCE	NO	NO
STAGE_ID	Stage unique identification.	TABLE	EXPRESSION	STAGE_ID_EXPRESSION	NO	NO	PROSPECT STAGE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	TABLE	SYSTEM_LOAD_PROCESS	'PROSPECT_STAGE_F1B'	NO	NO	PROSPECT STAGE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	TABLE	NA	SYSDATE	NO	NO	PROSPECT STAGE

Ver: 8.2