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	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ADVANCEMENT_PROGRAM_YEAR_KEY	System generated, unique, internal primary key for an advancement program year.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ALLOCATION_ASSIGNMENT_IND	Indicates whether the assignment is for an Advance allocation.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ASSIGNMENT_ENTITY_KEY	System generated, unique, internal primary key for the assigned staff entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	ASSIGNMENT
ASSIGNMENT_ENTITY_UID	System generated unique internal identification number assigned to this staff.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	ASSIGNMENT
ASSIGNMENT_ID	System generated identification for an assignment.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ASSIGNMENT_KEY	System generated, unique, internal primary key for prospect staff assignments either directly or through a proposal.	NUMBER	CLN_ASSIGNMENT	ASSIGNMENT_KEY	NO	NO	ASSIGNMENT
ASSIGNMENT_OFFICE_KEY	System generated, unique, internal primary key for an advancement office assignment.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ASSIGNMENT_STAFF_KEY	System generated, unique, internal primary key for staff assigned to a prospect.	NUMBER	CLN_STAFF	STAFF_KEY	NO	NO	ASSIGNMENT
ASSIGNMENT_UNIT_KEY	System generated, unique, internal primary key for the assigned school or unit.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
COMMITTEE_ASSIGNMENT_IND	Determines whether the assignment is a committee assignment.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
COMMITTEE_KEY	System generated, unique, internal primary key for a committee.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
CONTRACT_GRANT_ASSIGNMENT_IND	Indicates whether the assignment has a grant contract.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
CONTRACT_GRANT_KEY	For future use: system generated, unique, internal key for an Advance Contract/Grant if the assignment is for a contract/grant .	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
DESIGNATION_ADV_PROGRAM_KEY	System generated, unique, internal primary key for advancement program.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
DESIGNATION_DETAIL_KEY	System generated, unique, internal primary key for a designation detail record.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
DESIGNATION_KEY	System generated, unique, internal primary key for a designation.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ENTITY_ASSIGNMENT_GROUP_KEY		NUMBER	NO SOURCE	NO SOURCE	NO	NO
ENTITY_ASSIGNMENT_IND	Indicates whether the assignment is for an Advance entity.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
ENTITY_KEY	System generated, unique, internal primary key for a constituent.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	ASSIGNMENT
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	ASSIGNMENT
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal and proposal purpose.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	ASSIGNMENT
PGM_PROSPECT_ASSIGNMENT_IND	Indicates whether the assignment has a program assigned to the prospect.	NUMBER	DEFAULT_VALUES	0	NO	NO	ASSIGNMENT
PRIMARY_ASSIGNMENT_IND	Indicates whether the staff assignment is the primary.	NUMBER	LKP_EXPRESSION	PRIMARY_ASSIGNMENT_IND_EXPRESSION	NO	NO	ASSIGNMENT
PROGRAM_ASSIGNMENT_GROUP_KEY	System generated, unique, internal primary key for grouping program staff assignments.	NUMBER	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_ASSIGNMENT_GROUP_KEY	System generated, unique, internal primary key for grouping proposal staff assignments.	NUMBER	DEPENDANT_EXPRESSION	PROPOSAL_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	ASSIGNMENT
PROPOSAL_ASSIGNMENT_IND	Indicates whether the assignment has a proposal.	NUMBER	DEPENDANT_EXPRESSION	PROPOSAL_ASSIGNMENT_IND_EXPRESSION	NO	NO	ASSIGNMENT
PROPOSAL_KEY	System generated, unique, internal primary key for a donor proposal.	NUMBER	CLN_PROPOSAL	PROPOSAL_KEY	NO	NO	ASSIGNMENT
PROSPECT_ASSIGNMENT_GROUP_KEY	System generated, unique, internal primary key for grouping prospect staff assignments.	NUMBER	DEPENDANT_EXPRESSION	PROSPECT_ASSIGNMENT_GROUP_KEY_EXPRESSION	NO	NO	ASSIGNMENT
PROSPECT_ASSIGNMENT_IND	Indicates whether the entity is a prospect.	NUMBER	DEFAULT_VALUES	1	NO	NO	ASSIGNMENT
PROSPECT_KEY	System generated, unique, internal primary key for a prospect.	NUMBER	CLN_PROSPECT	PROSPECT_KEY	NO	NO	ASSIGNMENT
PROS_PGM_YR_ID	System generated identification using the prospect identification, program code, and program year.	VARCHAR2(63)	DEFAULT_VALUES	NULL	NO	NO
START_DATE	Start date of the assignment.	DATE	DEPENDANT_EXPRESSION	START_DATE_EXPRESSION	NO	NO	ASSIGNMENT
STOP_DATE	Stop date for the entity.	DATE	DEPENDANT_EXPRESSION	STOP_DATE_EXPRESSION	NO	NO	ASSIGNMENT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	DEFAULT_VALUES	'ASSIGNMENT_F1B'	NO	NO	ASSIGNMENT
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