Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACTIVITY_COUNT	Count of distninct activity code for the constituent.	VARCHAR2(252)	GROUP_COUNT_EXPRESSIONS	ACTIVITY_COUNT_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_FIRST_YEAR	First year of participation associated to this activity.	NUMBER	EXPRESSION	ACTIVITY_FIRST_YEAR_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_LAST_YEAR	Last year of participation associated to this activity.	NUMBER	EXPRESSION	ACTIVITY_LAST_YEAR_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_LEADERSHIP_ROLE_IND	Indicates if the constituent held a leadership poistion for this activity.	NUMBER	EXPRESSION	ACTIVITY_LEADERSHIP_ROLE_IND_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_LEADERSHIP_SEQ_NUMBER	Unique one-up sequence number assigned to each activity leadership role identified for this constituent.	NUMBER	EXPRESSION	ACTIVITY_LEADERSHIP_SEQ_NUMBER_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_LEADERSHIP_START_DATE	Date the activity leadership role began.	DATE	APRACLD	APRACLD_BEGIN_DATE	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_LEADERSHIP_STOP_DATE	Date the activity leadership role ended.	DATE	APRACLD	APRACLD_END_DATE	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_RECORD_COUNT		NUMBER	GROUP_COUNT_EXPRESSIONS	ACTIVITY_RECORD_COUNT_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_TOTAL_YEARS	Total number of years of participation associated with this activity.	NUMBER	EXPRESSION	ACTIVITY_TOTAL_YEARS_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ACTIVITY_YEAR	Year of activity participation.	NUMBER	EXPRESSION	ACTIVITY_YEAR_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ADVANCEMENT_ACTIVITY_KEY	System generated, unique, internal primary key for an advancement activity.	NUMBER	EXPRESSION_NVL	ADVANCEMENT_ACTIVITY_KEY_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ADVANCEMENT_ACT_COMMENT_KEY	System generated, unique, internal primary key for an advancement activity comment.	NUMBER	EXPRESSION_NVL	ADVANCEMENT_ACT_COMMENT_KEY_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ADVANCEMENT_ACT_GROUP_KEY		NUMBER	GROUP_COUNT_EXPRESSIONS	ADVANCEMENT_ACT_GROUP_KEY_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ADVANCEMENT_ACT_LEADERSHIP_KEY	System generated, unique, internal primary key for an advancement activity leadership.	NUMBER	EXPRESSION_NVL	ADVANCEMENT_ACT_LEADERSHIP_KEY_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	EXPRESSION_NVL	ENTITY_KEY_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
ENTITY_UID	System generated unique internal identification number assigned to this constituent.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	ADVANCEMENT ACTIVITY
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	EXPRESSION_NVL	MULTI_SOURCE_KEY_EXPRESSION	NO	NO	ADVANCEMENT ACTIVITY
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'ADVANCEMENT_ACTIVITY_F1B'	NO	NO	ADVANCEMENT ACTIVITY
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