Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADVANCEMENT_PROGRAM_KEY	System generated, unique, internal primary key for advancement program.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
ASK_AMOUNT	Requested donation amount on the contact.	NUMBER	AMRCONT	AMRCONT_ASK_AMT	NO	NO	CONTACT REPORT
AUTHOR_ENTITY_KEY	System generated, unique, internal primary key for an author entity.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
AUTHOR_ENTITY_UID	System generated, unique, internal primary key for an author entity.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
AUTHOR_STAFF_KEY	System generated, unique, internal primary key for staff assigned to an entity.	NUMBER	CLN_STAFF	STAFF_KEY	NO	NO	CONTACT REPORT
CONFIDENTIAL_CONTACT_IND	Indicates that this contact report is flagged as confidential.	NUMBER	EXPRESSION	CONFIDENTIAL_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
CONTACTED_CONSTITUENT_COUNT	Number of constituents contacted by the contact author.	NUMBER	EXPRESSION_0	CONTACTED_CONSTITUENT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
CONTACTED_PROSPECT_COUNT	Count of unique visits (contacts) per prospect.	NUMBER	EXPRESSION_0	CONTACTED_PROSPECT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
CONTACT_ACTION_DATE	Next action date related to this contact.	DATE	EXPRESSION	CONTACT_ACTION_DATE_EXPRESSION	NO	NO	CONTACT REPORT
CONTACT_COUNT	Count of unique contacts per constituent.	NUMBER	EXPRESSION_0	CONTACT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
CONTACT_DATE	Date the contact was made.	DATE	EXPRESSION	CONTACT_DATE_EXPRESSION	NO	NO	CONTACT REPORT
CONTACT_REPORT_ATTRIBUTE_KEY	System generated, unique, internal primary key for contact report attribute.	NUMBER	CLN_CONTACT_REPORT_ATTRIBUTE	CONTACT_REPORT_ATTRIBUTE_KEY	NO	NO	CONTACT REPORT
CONTACT_REPORT_KEY	System generated, unique, internal primary key for a contact report.	NUMBER	CLN_CONTACT_REPORT	CONTACT_REPORT_KEY	NO	NO	CONTACT REPORT
CONTACT_REPORT_UNIT_KEY	System generated, unique, internal primary key for the school or unit.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
CONT_REP_CREDIT_GROUP_KEY		NUMBER	EXPRESSION_0	CONT_REP_CREDIT_GROUP_KEY_EXPRESSION	NO	NO	CONTACT REPORT
CONT_REP_ENTITY_GROUP_KEY		NUMBER	EXPRESSION_0	CONT_REP_ENTITY_GROUP_KEY_EXPRESSION	NO	NO	CONTACT REPORT
CONT_REP_PROSPECT_GROUP_KEY		NUMBER	EXPRESSION_0	CONT_REP_PROSPECT_GROUP_KEY_EXPRESSION	NO	NO	CONTACT REPORT
ENTITY_CONTACT_COUNT	Number of contacts made for this entity.	NUMBER	EXPRESSION_0	ENTITY_CONTACT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	CONTACT REPORT
ENTITY_UID	System generated unique internal identification number assigned to this entity.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	CONTACT REPORT
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal purpose contact or contact purpose.	NUMBER	CLN_FUNDRAISING_INITIATIVE	FUNDRAISING_INITIATIVE_KEY	NO	NO	CONTACT REPORT
ID2_ENTITY_KEY	System generated, unique, internal primary key for a second constituent entity.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
ID2_ENTITY_UID	System generated, unique, internal primary key for an entity.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
INITIAL_ENTITY_CONTACT_IND	Indicates whether this is the first contact for the entity.	NUMBER	EXPRESSION	INITIAL_ENTITY_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
INITIAL_INTEREST_CONTACT_IND	Indicates whether this is the first contact for this prospect's interest not associated to a proposal.	NUMBER	EXPRESSION	INITIAL_INTEREST_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
INITIAL_PROPOSAL_CONTACT_IND	Indicates whether this is the first contact for this prospect's proposal.	NUMBER	EXPRESSION	INITIAL_PROPOSAL_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
INITIAL_PROP_PURP_CONTACT_IND	Indicates whether this is the first contact for this prospect's proposal purpose.	NUMBER	EXPRESSION	INITIAL_PROP_PURP_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
INITIAL_PROSPECT_CONTACT_IND	Indicates whether this is the first contact for the prospect.	NUMBER	EXPRESSION	INITIAL_PROSPECT_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
INTEREST_ASK_CONTACT_IND	Indicates whether this is a contact for a prospect's interest not associated to a proposal where an ask amount was requested.	NUMBER	EXPRESSION_0	INTEREST_ASK_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_ENTITY_CONTACT_IND	Indicates whether this is the last contact for the entity.	NUMBER	EXPRESSION	LATEST_ENTITY_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_INTEREST_ASK_IND	Indicates whether this is the last contact for this prospect's interest not associated to a proposal where an ask amount was requested.	NUMBER	EXPRESSION	LATEST_INTEREST_ASK_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_INTEREST_CONTACT_IND	Indicates whether this is the last contact for this prospect's interest not associated to a proposal.	NUMBER	EXPRESSION	LATEST_INTEREST_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_PROPOSAL_ASK_IND	Indicates whether this is the last contact for this prospect's proposal where an ask amount was requested.	NUMBER	EXPRESSION	LATEST_PROPOSAL_ASK_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_PROPOSAL_CONTACT_IND	Indicates whether this is the last contact for this prospect's proposal.	NUMBER	EXPRESSION	LATEST_PROPOSAL_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_PROP_PURP_ASK_IND	Indicates whether this is the last contact for this prospect's proposal purpose where an ask amount was requested.	NUMBER	EXPRESSION	LATEST_PROP_PURP_ASK_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_PROP_PURP_CONTACT_IND	Indicates whether this is the last contact for this prospect's proposal purpose.	NUMBER	EXPRESSION	LATEST_PROP_PURP_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_PROSPECT_CONTACT_IND	Indicates whether this is the last contact for the prospect.	NUMBER	EXPRESSION	LATEST_PROSPECT_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
LATEST_VISIT_IND	Indicates the last in-person visit contact with this constituent.	NUMBER	EXPRESSION_1	LATEST_VISIT_IND_EXPRESSION	NO	NO	CONTACT REPORT
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	CONTACT REPORT
PROGRAM_PROSPECT_CONTACT_COUNT	Number of contacts to the prospect for this program.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_ASK_CONTACT_IND	Indicates whether this is a contact for a prospect's proposal where an ask amount was requested.	NUMBER	EXPRESSION_0	PROPOSAL_ASK_CONTACT_IND_EXPRESSION	NO	NO	CONTACT REPORT
PROPOSAL_ATTRIBUTE_KEY	System generated, unique, internal primary key for donor proposal attributes.	NUMBER	CLN_PROPOSAL_ATTRIBUTE	PROPOSAL_ATTRIBUTE_KEY	NO	NO	CONTACT REPORT
PROPOSAL_CONTACT_COUNT	Number of contacts to the prospect for this proposal.	NUMBER	EXPRESSION_0	PROPOSAL_CONTACT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	CLN_PROPOSAL	PROPOSAL_KEY	NO	NO	CONTACT REPORT
PROPOSAL_PURPOSE_ASK_CONT_IND	Indicates whether this is a contact for a prospect's proposal purpose where an ask amount was requested.	NUMBER	EXPRESSION_0	PROPOSAL_PURPOSE_ASK_CONT_IND_EXPRESSION	NO	NO	CONTACT REPORT
PROSPECT_CONTACT_COUNT	Number of prospecting contacts made for this entity.	NUMBER	EXPRESSION_0	PROSPECT_CONTACT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	CONTACT REPORT
PROSPECT_VISIT_COUNT	Count of unique visits (contacts) per prospect.	NUMBER	EXPRESSION_0	PROSPECT_VISIT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT
REP_ID_ENTITY_KEY	System generated, unique, internal primary key for a report contact constituent entity.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
REP_ID_ENTITY_UID	System generated, unique, internal primary key for an report contact constituent entity.	NUMBER	CONSTANT	0	NO	NO	CONTACT REPORT
STAFF_KEY		NUMBER	CLN_STAFF	STAFF_KEY	NO	NO	CONTACT REPORT
STRATEGY_CONTACT_COUNT	Number of contacts to the prospect for this strategy plan.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'CONTACT_REPORT_F1B'	NO	NO	CONTACT REPORT
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
VISIT_COUNT	Count of unique visits (contacts) per constituent.	NUMBER	EXPRESSION_0	VISIT_COUNT_EXPRESSION	NO	NO	CONTACT REPORT

Ver: 9.0