Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_PROGRAM_PROSPECT_COUNT	Number of active prospects for this program.	NUMBER	EXPRESSION_1	ACTIVE_PROGRAM_PROSPECT_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ACTIVE_PROPOSAL_COUNT	Number of active proposals.	NUMBER	EXPRESSION_1	ACTIVE_PROPOSAL_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ACTIVE_PROSPECT_COUNT	Number of active prospects.	NUMBER	EXPRESSION_1	ACTIVE_PROSPECT_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ADDRESS_GROUP_KEY		NUMBER	EXPRESSION_1	ADDRESS_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ADVANCEMENT_ACTIVITY_GROUP_KEY		NUMBER	EXPRESSION_1	ADVANCEMENT_ACTIVITY_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ADVANCEMENT_DEGREE_GROUP_KEY		NUMBER	EXPRESSION_1	ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ADVANCEMENT_PROGRAM_KEY		NUMBER	EXPRESSION_1	ADVANCEMENT_PROGRAM_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ADVANCEMENT_PROGRAM_YEAR_KEY		NUMBER	EXPRESSION_1	ADVANCEMENT_PROGRAM_YEAR_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
AFFILIATION_GROUP_KEY		NUMBER	EXPRESSION_1	AFFILIATION_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
AWARD_HONOR_GROUP_KEY		NUMBER	EXPRESSION_1	AWARD_HONOR_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CE_TYPE_GROUP_KEY		NUMBER	EXPRESSION_1	CE_TYPE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CLEARANCE_START_DATE	Date clearance was granted or is to begin for a program prospect.	DATE	EXPRESSION_1	CLEARANCE_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CLEARANCE_STOP_DATE	Date clearance ceased or is to stop for a program prospect.	DATE	EXPRESSION_1	CLEARANCE_STOP_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
COMMITTEE_GROUP_KEY		NUMBER	EXPRESSION_1	COMMITTEE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CONSTITUENT_ENTITY_ATTRIB_KEY		NUMBER	EXPRESSION_1 WFT_RELATIONSHIP	CONSTITUENT_ENTITY_ATTRIB_KEY_EXPRESSION CONSTITUENT_ENTITY_ATTRIB_KEY_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE  MANAGE PROSPECT PIPELINE
CONSTITUENT_EVAL_GROUP_KEY		NUMBER	EXPRESSION_1	CONSTITUENT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CONSTITUENT_INTEREST_GROUP_KEY		NUMBER	EXPRESSION_1	CONSTITUENT_INTEREST_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CONSTITUENT_PROFILE_GROUP_KEY		NUMBER	EXPRESSION_1	CONSTITUENT_PROFILE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CONST_EMPLOYMENT_GROUP_KEY		NUMBER	EXPRESSION_1	CONST_EMPLOYMENT_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CONT_REP_PROSPECT_GROUP_KEY		NUMBER	EXPRESSION_1	CONT_REP_PROSPECT_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CURRENT_GIVING_TOTAL_KEY		NUMBER	EXPRESSION_1	CURRENT_GIVING_TOTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
CURRENT_SP_GIVING_TOTAL_KEY		NUMBER	EXPRESSION_1	CURRENT_SP_GIVING_TOTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
DEMOGRAPHIC_KEY		NUMBER	EXPRESSION_1	DEMOGRAPHIC_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
DONOR_SUMMARY_KEY		NUMBER	WDT_DONOR_SUMMARY	DONOR_SUMMARY_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
EMAIL_GROUP_KEY		NUMBER	EXPRESSION_1	EMAIL_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ENTITY_ID	Constituent entity's identification number used to access the records associated with that constituent.	VARCHAR2(63)	EXPRESSION_1	ENTITY_ID_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	WFT_RELATIONSHIP	ENTITY_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WFT_RELATIONSHIP	ENTITY_UID_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
EXCLUSION_GROUP_KEY		NUMBER	EXPRESSION_1	EXCLUSION_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
FIRST_PROPOSAL_RESULT_DATE	First date a proposal result was recorded.	DATE	EXPRESSION_1	FIRST_PROPOSAL_RESULT_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
GIFT_SOCIETY_GROUP_KEY		NUMBER	EXPRESSION_1	GIFT_SOCIETY_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LAST_ENT_CRPT_ATTRIB_KEY		NUMBER	EXPRESSION_1	LAST_ENT_CRPT_ATTRIB_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LAST_ENT_CRPT_AUTH_STAFF_KEY		NUMBER	EXPRESSION_1	LAST_ENT_CRPT_AUTH_STAFF_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LAST_ENT_CRPT_KEY		NUMBER	EXPRESSION_1	LAST_ENT_CRPT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LAST_PROS_CRPT_ATTRIB_KEY		NUMBER	EXPRESSION_1	LAST_PROS_CRPT_ATTRIB_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LAST_PROS_CRPT_AUTH_STAFF_KEY		NUMBER	EXPRESSION_1	LAST_PROS_CRPT_AUTH_STAFF_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LAST_PROS_CRPT_KEY		NUMBER	EXPRESSION_1	LAST_PROS_CRPT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LATEST_ENTITY_CONTACT_DATE	Date the contact was made representing the last contact for the entity.	DATE	EXPRESSION_1	LATEST_ENTITY_CONTACT_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LATEST_PROPOSAL_ASK_AMOUNT	Proposal last requested ask amount.	NUMBER	EXPRESSION_1	LATEST_PROPOSAL_ASK_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LATEST_PROSPECT_CONTACT_DATE	Date the contact was made representing the last contact for the prospect.	DATE	EXPRESSION_1	LATEST_PROSPECT_CONTACT_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LG_HARD_GIVING_TOTAL_KEY		NUMBER	EXPRESSION_1	LG_HARD_GIVING_TOTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LG_HARD_SP_GIVING_TOTAL_KEY		NUMBER	EXPRESSION_1	LG_HARD_SP_GIVING_TOTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LG_SOFT_GIVING_TOTAL_KEY		NUMBER	EXPRESSION_1	LG_SOFT_GIVING_TOTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
LG_SOFT_SP_GIVING_TOTAL_KEY		NUMBER	EXPRESSION_1	LG_SOFT_SP_GIVING_TOTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
MAILING_HISTORY_GROUP_KEY		NUMBER	EXPRESSION_1	MAILING_HISTORY_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
MAILING_LIST_GROUP_KEY		NUMBER	EXPRESSION_1	MAILING_LIST_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
MAIL_TRACKING_GROUP_KEY		NUMBER	EXPRESSION_1	MAIL_TRACKING_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
MEMBERSHIP_GROUP_KEY		NUMBER	EXPRESSION_1	MEMBERSHIP_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
MULTI_SOURCE_KEY		NUMBER	WFT_RELATIONSHIP	MULTI_SOURCE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PGM_PROSPECT_EVAL_GROUP_KEY		NUMBER	EXPRESSION_1	PGM_PROSPECT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PGM_PROSPECT_SHARED_ATTRIB_KEY		NUMBER	EXPRESSION_1	PGM_PROSPECT_SHARED_ATTRIB_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PGM_PROSPECT_STAGE_START_DATE	Stage start date for the prospect's program.	DATE	EXPRESSION_1	PGM_PROSPECT_STAGE_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PHONE_GROUP_KEY		NUMBER	EXPRESSION_1	PHONE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PREFERRED_ADDRESS_TYPE_KEY		NUMBER	EXPRESSION_1	PREFERRED_ADDRESS_TYPE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PREFERRED_CLASS_SCHOOL_KEY		NUMBER	EXPRESSION_1 WFT_RELATIONSHIP	PREFERRED_CLASS_SCHOOL_KEY_EXPRESSION PREFERRED_CLASS_SCHOOL_KEY_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE  MANAGE PROSPECT PIPELINE
PREFERRED_POSTAL_KEY		NUMBER	EXPRESSION_1	PREFERRED_POSTAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PREFERRED_STREET_LINE_KEY		NUMBER	EXPRESSION_1	PREFERRED_STREET_LINE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_ASSIGNMENT_ENTITY_KEY		NUMBER	EXPRESSION_1	PRIMARY_ASSIGNMENT_ENTITY_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_ASSIGNMENT_ENTITY_UID	System generated unique internal identification number assigned to this staff where this is the primary assignment.	NUMBER	EXPRESSION_1	PRIMARY_ASSIGNMENT_ENTITY_UID_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_ASSIGNMENT_KEY		NUMBER	EXPRESSION_1	PRIMARY_ASSIGNMENT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_ASSIGNMENT_OFFICE_KEY		NUMBER	EXPRESSION_1	PRIMARY_ASSIGNMENT_OFFICE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_ASSIGNMENT_STAFF_KEY		NUMBER	EXPRESSION_1	PRIMARY_ASSIGNMENT_STAFF_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_ASSIGNMENT_UNIT_KEY		NUMBER	EXPRESSION_1	PRIMARY_ASSIGNMENT_UNIT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PRIMARY_CE_TYPE_KEY		NUMBER	EXPRESSION_1 WFT_RELATIONSHIP	PRIMARY_CE_TYPE_KEY_EXPRESSION PRIMARY_CE_TYPE_KEY_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE  MANAGE PROSPECT PIPELINE
PRIMARY_PROSPECT_ENTITY_COUNT	Number of constituents that are considered to be a primary prospect.	NUMBER	EXPRESSION_1	PRIMARY_PROSPECT_ENTITY_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_ASSIGNMENT_GROUP_KEY		NUMBER	EXPRESSION_1	PROGRAM_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_ASSIGNED_IND	Determines whether a program prospect has an active assignment of the type defined by the institution via a parameter map.	NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_ASSIGNED_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_ATTRIBUTE_KEY		NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_ATTRIBUTE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_COUNT	Number of prospects for this program.	NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_RATED_AMOUNT	Rated amount for the Advance program prospect.	NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_RATED_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_RESULT_AMOUNT	Result amount for the Advance program prospect.	NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_RESULT_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_RESULT_DATE	Result date for the Advance program prospect result.	DATE	EXPRESSION_1	PROGRAM_PROSPECT_RESULT_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_STAGE_KEY		NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_STAGE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_START_DATE	Program start date for the prospect.	DATE	EXPRESSION_1	PROGRAM_PROSPECT_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_STOP_DATE	Program stop date for the prospect.	DATE	EXPRESSION_1	PROGRAM_PROSPECT_STOP_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_TARGET_DATE	Expected date for the Advance program prospect.	DATE	EXPRESSION_1	PROGRAM_PROSPECT_TARGET_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROGRAM_PROSPECT_UNIT_KEY		NUMBER	EXPRESSION_1	PROGRAM_PROSPECT_UNIT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ASK_AMOUNT	Proposal actual ask amount.	NUMBER	EXPRESSION_1	PROPOSAL_ASK_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ASK_DATE	Proposal date an ask amount was requested.	DATE	EXPRESSION_1	PROPOSAL_ASK_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ASK_MADE_IND	Indicates whether this proposal had an ask made for the prospect.	NUMBER	EXPRESSION_1	PROPOSAL_ASK_MADE_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ASSIGNED_IND	Indicates whether the proposal has been assigned to a fundraiser, staff member or other representative of the institution.	NUMBER	EXPRESSION_1	PROPOSAL_ASSIGNED_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ASSIGNMENT_GROUP_KEY		NUMBER	EXPRESSION_1	PROPOSAL_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ATTRIBUTE_KEY		NUMBER	EXPRESSION_1	PROPOSAL_ATTRIBUTE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_CAMPAIGN_KEY		NUMBER	EXPRESSION_1	PROPOSAL_CAMPAIGN_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_COUNT	Number of proposals.	NUMBER	EXPRESSION_1	PROPOSAL_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_DURATION	Proposal duration.	NUMBER	EXPRESSION_1	PROPOSAL_DURATION_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_GRANTED_AMOUNT	Proposal granted amount.	NUMBER	EXPRESSION_1	PROPOSAL_GRANTED_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_GRANTED_IND	Indicates whether the proposal has been granted by the prospect. This indicator is set to an affirmative if the proposal granted amount is greater than zero.	NUMBER	EXPRESSION_1	PROPOSAL_GRANTED_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_INIT_CONTRIB_AMOUNT	Proposal initial contribution amount.	NUMBER	EXPRESSION_1	PROPOSAL_INIT_CONTRIB_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_INIT_CONTRIB_DATE	Proposal initial contribution date.	DATE	EXPRESSION_1	PROPOSAL_INIT_CONTRIB_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_KEY		NUMBER	EXPRESSION_1	PROPOSAL_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_ORIGINAL_ASK_AMOUNT	Proposal original ask amount.	NUMBER	EXPRESSION_1	PROPOSAL_ORIGINAL_ASK_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_RESULT_IND	Indicates whether this proposal has had any results or amounts gifted or pledged.	NUMBER	EXPRESSION_1	PROPOSAL_RESULT_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_STAGE_KEY		NUMBER	EXPRESSION_1	PROPOSAL_STAGE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_STAGE_START_DATE	Stage start date of the proposal.	DATE	EXPRESSION_1	PROPOSAL_STAGE_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_START_DATE	Proposal start date.	DATE	EXPRESSION_1	PROPOSAL_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_STOP_DATE	Proposal stop date.	DATE	EXPRESSION_1	PROPOSAL_STOP_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_TARGET_AMOUNT	Proposal targeted amount.	NUMBER	EXPRESSION_1	PROPOSAL_TARGET_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_TARGET_DATE	Proposal target date.	DATE	EXPRESSION_1	PROPOSAL_TARGET_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_TOTAL_RESULT_AMOUNT	Total of all results for the proposal.	NUMBER	EXPRESSION_1	PROPOSAL_TOTAL_RESULT_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROPOSAL_UNIT_KEY		NUMBER	EXPRESSION_1	PROPOSAL_UNIT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_ASSIGNED_IND	Indicates whether the prospect was assigned staff.	NUMBER	EXPRESSION_1	PROSPECT_ASSIGNED_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_ASSIGNMENT_GROUP_KEY		NUMBER	EXPRESSION_1	PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_ATTRIBUTE_KEY		NUMBER	EXPRESSION_1	PROSPECT_ATTRIBUTE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_CAMPAIGN_KEY		NUMBER	EXPRESSION_1	PROSPECT_CAMPAIGN_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_CATEGORY_GROUP_KEY		NUMBER	EXPRESSION_1	PROSPECT_CATEGORY_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_COUNT	Number of prospects.	NUMBER	EXPRESSION_1	PROSPECT_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_ENTITY_COUNT	Number of constituents considered to be an active prospect.	NUMBER	EXPRESSION_1	PROSPECT_ENTITY_COUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_EVAL_GROUP_KEY		NUMBER	EXPRESSION_1	PROSPECT_EVAL_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_KEY		NUMBER	EXPRESSION_1	PROSPECT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_PIPELINE_GROUP_A_KEY		NUMBER	EXPRESSION_1	PROSPECT_PIPELINE_GROUP_A_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_PIPELINE_GROUP_B_KEY		NUMBER	EXPRESSION_1	PROSPECT_PIPELINE_GROUP_B_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_RATED_AMOUNT	Prospect rated amount.	NUMBER	EXPRESSION_1	PROSPECT_RATED_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_RATE_ENTRY_DATE	Date the prospect rating was entered.	DATE	EXPRESSION_1	PROSPECT_RATE_ENTRY_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_RESULT_AMOUNT	Prospect result amount.	NUMBER	EXPRESSION_1	PROSPECT_RESULT_AMOUNT_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_RESULT_DATE	Date the prospect result was recorded.	DATE	EXPRESSION_1	PROSPECT_RESULT_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_SHARED_ATTRIBUTE_KEY		NUMBER	EXPRESSION_1	PROSPECT_SHARED_ATTRIBUTE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_STAGE_KEY		NUMBER	EXPRESSION_1	PROSPECT_STAGE_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_STAGE_START_DATE	Stage start date of the prospect.	DATE	EXPRESSION_1	PROSPECT_STAGE_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_START_DATE	Date the constituent was identified as a prospect.	DATE	EXPRESSION_1	PROSPECT_START_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_STOP_DATE	Date a prospect is no longer being actively cultivated.	DATE	EXPRESSION_1	PROSPECT_STOP_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_TARGET_DATE	Prospect manually entered target ask date.	DATE	EXPRESSION_1	PROSPECT_TARGET_DATE_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROSPECT_UNIT_KEY		NUMBER	EXPRESSION_1	PROSPECT_UNIT_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
PROS_INT_MEASURE_FILTER_IND	Indentifies a single row for each prospect. Used to create a prospect interest measure filter.	NUMBER	EXPRESSION_1	PROS_INT_MEASURE_FILTER_IND_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
RELATIONSHIP_GROUP_KEY		NUMBER	EXPRESSION_1 WFT_RELATIONSHIP	RELATIONSHIP_GROUP_KEY_EXPRESSION RELATIONSHIP_GROUP_KEY_EXPRESSION	NO NO	NO	MANAGE PROSPECT PIPELINE  MANAGE PROSPECT PIPELINE
SPECIAL_PURPOSE_GROUP_KEY		NUMBER	EXPRESSION_1	SPECIAL_PURPOSE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
SPORT_GROUP_KEY		NUMBER	EXPRESSION_1	SPORT_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
SPOUSE_DONOR_SUMMARY_KEY		NUMBER	WDT_DONOR_SUMMARY	DONOR_SUMMARY_KEY	NO	NO	MANAGE PROSPECT PIPELINE
SPOUSE_ENTITY_KEY		NUMBER	EXPRESSION_1	SPOUSE_ENTITY_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
SPOUSE_NON_ENTITY_KEY		NUMBER	EXPRESSION_1	SPOUSE_NON_ENTITY_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
SPOUSE_UID	System generated unique internal identification number assigned to the constituent entity's spouse.	NUMBER	EXPRESSION_1	SPOUSE_UID_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
STUDENT_ACTIVITY_GROUP_KEY		NUMBER	EXPRESSION_1	STUDENT_ACTIVITY_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'MANAGE_PROSPECT_PIPELINE_A1'	NO	NO	MANAGE PROSPECT PIPELINE
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
VARIABLE_PURPOSE_GROUP_KEY		NUMBER	EXPRESSION_1	VARIABLE_PURPOSE_GROUP_KEY_EXPRESSION	NO	NO	MANAGE PROSPECT PIPELINE

Ver: 9.0