Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ALL_PROSPECT_ENTITY_COUNT	Number of constituents considered to be an active or inactive prospect.	NUMBER	EXPRESSION_0	ALL_PROSPECT_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
ALUM_ENTITY_COUNT	Number of constituents considered to be an alumni.	NUMBER	EXPRESSION_0	ALUM_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
ASSIGNED_ENTITY_COUNT	Number of constituents assigned staff.	NUMBER	EXPRESSION_0	ASSIGNED_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
CONSTITUENT_ENTITY_ATTRIB_KEY	System generated, unique, internal primary key for constituents.	NUMBER	CLN_CONSTITUENT_ENTITY_ATTRIB	CONSTITUENT_ENTITY_ATTRIB_KEY	NO	NO	CONSTITUENT ENTITY
CONTACTED_ENTITY_COUNT	Number of constituents contacted.	NUMBER	EXPRESSION_0	CONTACTED_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
DEMOGRAPHIC_KEY	System generated, unique, internal primary key for a person demographic.	NUMBER	CLN_DEMOGRAPHIC	DEMOGRAPHIC_KEY	NO	NO	CONSTITUENT ENTITY
DONOR_SUMMARY_KEY	System generated, unique, internal primary key for a donor.	NUMBER	WDT_DONOR_SUMMARY	DONOR_SUMMARY_KEY	NO	NO	CONSTITUENT ENTITY
ENTITY_COUNT	Number of people or organizations considered to be a constituent.	NUMBER	LKP_EXPRESSIONS	ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
ENTITY_ID	Constituent entity's identification number used to access the records associated with that constituent.	VARCHAR2(63)	LKP_EXPRESSIONS	ENTITY_ID_EXPRESSION	NO	NO	CONSTITUENT ENTITY
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONSTITUENT ENTITY
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	CLN_ENTITY	ENTITY_UID_EXPRESSION	NO	NO	CONSTITUENT ENTITY
MAJOR_PROSPECT_ENTITY_COUNT	Number of constituents considered to be an active major prospect.	NUMBER	CONSTANT	NULL	NO	NO	CONSTITUENT ENTITY
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	CONSTITUENT ENTITY
PG_PROSPECT_ENTITY_COUNT	Number of constituents considered to be an active planned giving prospect.	NUMBER	CONSTANT	NULL	NO	NO	CONSTITUENT ENTITY
PREFERRED_ADDRESS_TYPE_KEY	System generated, unique, internal primary key for the constituent preferred address type.	NUMBER	CLN_ADDRESS_TYPE	ADDRESS_TYPE_KEY	NO	NO	CONSTITUENT ENTITY
PREFERRED_CLASS_SCHOOL_KEY	System generated, unique, internal primary key for the preferred constituent and associated class year.	NUMBER	CLN_CLASS_SCHOOL	CLASS_SCHOOL_KEY	NO	NO	CONSTITUENT ENTITY
PREFERRED_POSTAL_KEY	System generated, unique, internal primary key for the constituent preferred postal zip code.	NUMBER	CLN_POSTAL	POSTAL_KEY	NO	NO	CONSTITUENT ENTITY
PREFERRED_STREET_LINE_KEY	System generated, unique, internal primary key for the constituent preferred street address.	NUMBER	CLN_STREET_ADDRESS	STREET_ADDRESS_KEY	NO	NO	CONSTITUENT ENTITY
PRIMARY_CE_TYPE_KEY	System generated, unique, internal primary key for the preferred constituent category.	NUMBER	CLN_CONSTITUENT_ENTITY_TYPE	CONSTITUENT_ENTITY_TYPE_KEY	NO	NO	CONSTITUENT ENTITY
PRIMARY_PROSPECT_ENTITY_COUNT	Number of constituents that are considered to be a primary prospect.	NUMBER	EXPRESSION_0	PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
PROGRAM_PROSPECT_ENTITY_COUNT	Number of constituents considered to be a prospect.	NUMBER	CONSTANT	NULL	NO	NO	CONSTITUENT ENTITY
PROSPECT_ENTITY_COUNT	Number of constituents considered to be an active prospect.	NUMBER	EXPRESSION_0	PROSPECT_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
RATED_ENTITY_COUNT	Number of constituents that have been rated.	NUMBER	CONSTANT	NULL	NO	NO	CONSTITUENT ENTITY
RATED_PROSPECT_ENTITY_COUNT	Number of constituents considered to be an active prospect and rated.	NUMBER	EXPRESSION_0	RATED_PROSPECT_ENTITY_COUNT_EXPRESSION	NO	NO	CONSTITUENT ENTITY
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'CONSTITUENT_ENTITY_F1B'	NO	NO	CONSTITUENT ENTITY
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