Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_PROSPECT_COUNT	Number of active prospects.	NUMBER	PROSPECT_SHARED_ATTRIBUTE_EXPR	ACTIVE_PROSPECT_COUNT_EXPRESSION	NO	NO	PROSPECT
CONT_REP_PROSPECT_GROUP_KEY		NUMBER	NO SOURCE	NO SOURCE	NO	NO
MAJOR_PROSPECT_COUNT	Number of major prospects.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	WFT_ASSIGNMENT	MULTI_SOURCE_KEY	NO	NO	PROSPECT
PG_PROSPECT_COUNT	Number of planned giving prospects.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PRIMARY_ASSIGNMENT_ENTITY_KEY		NUMBER	EXPRESSION_NVL	PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION	NO	NO	PROSPECT
PRIMARY_ASSIGNMENT_ENTITY_UID		NUMBER	EXPRESSION_NVL	PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION	NO	NO	PROSPECT
PRIMARY_ASSIGNMENT_KEY		NUMBER	EXPRESSION_NVL	PRIMARY_ASSIGNMENT_KEY_EXPRESSION	NO	NO	PROSPECT
PRIMARY_ASSIGNMENT_OFFICE_KEY		NUMBER	EXPRESSION_NVL	PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION	NO	NO	PROSPECT
PRIMARY_ASSIGNMENT_STAFF_KEY		NUMBER	EXPRESSION_NVL	PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION	NO	NO	PROSPECT
PRIMARY_ASSIGNMENT_UNIT_KEY		NUMBER	EXPRESSION_NVL	PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION	NO	NO	PROSPECT
PROSPECT_ASSIGNED_IND	Indicates whether the prospect was assigned staff.	NUMBER	ASSIGNED_IND_AND_DATES	PROSPECT_ASSIGNED_IND_EXPRESSION	NO	NO	PROSPECT
PROSPECT_ASSIGNMENT_GROUP_KEY		NUMBER	EXPRESSION	PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	PROSPECT
PROSPECT_ATTRIBUTE_KEY	System generated, unique, internal primary key for a prospect attribute.	NUMBER	CLN_PROSPECT_ATTRIBUTE	PROSPECT_ATTRIBUTE_KEY	NO	NO	PROSPECT
PROSPECT_CAMPAIGN_KEY	System generated, unique, internal primary key for a campaign.	NUMBER	CONSTANT	0	NO	NO	PROSPECT
PROSPECT_COUNT	Number of prospects.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	PROSPECT
PROSPECT_EVAL_GROUP_KEY		NUMBER	EXPRESSION	PROSPECT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	PROSPECT
PROSPECT_INTEREST_GROUP_KEY		NUMBER	EXPRESSION	PROSPECT_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	PROSPECT
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	WFT_ASSIGNMENT	PROSPECT_KEY	NO	NO	PROSPECT
PROSPECT_RATED_AMOUNT	Prospect rated amount.	NUMBER	LKUP_EXPRESSIONS	PROSPECT_RATED_AMOUNT_EXPRESSION	NO	NO	PROSPECT
PROSPECT_RATE_ENTRY_DATE	Date the prospect rating was entered.	DATE	ASSIGNED_IND_AND_DATES	PROSPECT_RATE_ENTRY_DATE_EXPRESSION	NO	NO	PROSPECT
PROSPECT_RESULT_AMOUNT	Prospect result amount.	NUMBER	CONSTANT	0	NO	NO	PROSPECT
PROSPECT_RESULT_DATE	Date the prospect result was recorded.	DATE	CONSTANT	TRUNC ( TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' ) )	NO	NO	PROSPECT
PROSPECT_SHARED_ATTRIBUTE_KEY	System generated, unique, internal primary key for a prospect shared attribute.	NUMBER	CLN_PROSPECT_SHARED_ATTRIBUTE	PROSPECT_SHARED_ATTRIBUTE_KEY	NO	NO	PROSPECT
PROSPECT_STAGE_KEY	System generated, unique, internal primary key for the stage of a prospect.	NUMBER	CLN_STAGE	STAGE_KEY	NO	NO	PROSPECT
PROSPECT_START_DATE	Date the constituent was identified as a prospect.	DATE	CONSTANT	TRUNC ( TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' ) )	NO	NO	PROSPECT
PROSPECT_STOP_DATE	Date a prospect is no longer being actively cultivated.	DATE	CONSTANT	TRUNC ( TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' ) )	NO	NO	PROSPECT
PROSPECT_TARGET_DATE	Prospect manually entered target ask date.	DATE	ASSIGNED_IND_AND_DATES	PROSPECT_TARGET_DATE_EXPRESSION	NO	NO	PROSPECT
PROSPECT_UNIT_KEY	System generated, unique, internal primary key for the school or unit.	NUMBER	CONSTANT	0	NO	NO	PROSPECT
PROS_PGM_YR_ID	System generated identification using the prospect identification, program code, and program year.	VARCHAR2(63)	CONSTANT	NULL	NO	NO	PROSPECT
RATED_PROSPECT_COUNT	Number of rated prospects.	NUMBER	PROSPECT_SHARED_ATTRIBUTE_EXPR	RATED_PROSPECT_COUNT_EXPRESSION	NO	NO	PROSPECT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'PROSPECT_F1B'	NO	NO	PROSPECT
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