Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVE_ASSIGNMENT_IND	Indicates whether the assignment is flagged as an active assignment to the prospect or program prospect under cultivation.	NUMBER	CONSTANT	1	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
ACTIVE_ASSIGNMENT_IND_LD	Active assignment indicator long description.	VARCHAR2(255)	CONSTANT	'YES'	NO	NO
ACTIVE_ASSIGNMENT_IND_SD	Active assignment indicator short description.	VARCHAR2(255)	CONSTANT	'YES'	NO	NO
ASSIGNMENT_KEY		NUMBER				NO
ASSIGNMENT_PRIORITY	Assignment priority allows a fundraiser to prioritize their top prospects, which may differ from another manager's top prospects.	VARCHAR2(63)	CONSTANT	NULL	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
ASSIGNMENT_PRIORITY_LD	Assignment priority long description.	VARCHAR2(255)	CONSTANT	NULL	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
ASSIGNMENT_PRIORITY_SD	Assignment priority short description.	VARCHAR2(255)	CONSTANT	NULL	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
ASSIGNMENT_TYPE	Assignment type identifies the type or nature of the staff assignment to the prospect or program prospect. Examples include Prospect Manager, Strategy team member, Solicitor, etc.	VARCHAR2(63)	ATVSTFT	ATVSTFT_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
ASSIGNMENT_TYPE_LD	Assignment type long description.	VARCHAR2(255)	EXPRESSION	ASSIGNMENT_TYPE_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
ASSIGNMENT_TYPE_SD	Assignment type short description.	VARCHAR2(255)	EXPRESSION	ASSIGNMENT_TYPE_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
SOLICITOR_IND	Indicates whether the staff person is a solicitor or not a solicitor.	NUMBER	EXPRESSION_0	SOLICITOR_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
SOLICITOR_IND_LD	Solicitor indicator long description.	VARCHAR2(255)	EXPRESSION_0	SOLICITOR_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
SOLICITOR_IND_SD	Solicitor indicator short description.	VARCHAR2(255)	EXPRESSION_0	SOLICITOR_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'ASSIGNMENT_D1B'	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, MANAGE PROSPECT PIPELINE, PROSPECT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0