Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADVANCEMENT_ADMISSION_YEAR_KEY	Entity's year of admission when applying to this institution.	NUMBER	CONSTANT_0	0	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEGREE_GROUP_KEY	Advancement Degree Group KEY.	NUMBER	GROUP_COUNT_EXPRESSIONS	ADVANCEMENT_DEGREE_GROUP_KEY_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEGREE_KEY	Advancement Degree KEY.	NUMBER	CLN_ADVANCEMENT_DEGREE	ADVANCEMENT_DEGREE_KEY	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEGREE_YEAR_KEY	Academic year which this degree was awarded.	NUMBER	CLN_ADVANCEMENT_DEG_YEAR	ADVANCEMENT_DEG_YEAR_KEY	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_ATTR_KEY	Advancement Degree Attribute KEY.	NUMBER	CONSTANT_0	0	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_COMMENTS_KEY	Advancement Degree Comments KEY.	NUMBER	CLN_ADVANCEMENT_DEG_COMMENTS	ADVANCEMENT_DEG_COMMENTS_KEY	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_CONC_GRP_KEY	Advancement Degree Concentration Group KEY.	NUMBER	NVL_GRP_KEY	ADVANCEMENT_DEG_CONC_GRP_KEY_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_DEPT_GRP_KEY	Advancement Degree Dept Group KEY.	NUMBER	NVL_GRP_KEY	ADVANCEMENT_DEG_DEPT_GRP_KEY_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_HONR_GRP_KEY	Advancement Degree Honor Group KEY.	NUMBER	NVL_GRP_KEY	ADVANCEMENT_DEG_HONR_GRP_KEY_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_MAJR_GRP_KEY	Advancement Degree Major Group KEY.	NUMBER	NVL_GRP_KEY	ADVANCEMENT_DEG_MAJR_GRP_KEY_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_DEG_MINR_GRP_KEY	Advancement Degree Minor Group KEY.	NUMBER	NVL_GRP_KEY	ADVANCEMENT_DEG_MINR_GRP_KEY_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_HON_DEGREE_KEY	Advancement Honorary Degree KEY.	NUMBER	CONSTANT_0	0	NO	NO	ADVANCEMENT DEGREE
ADVANCEMENT_INSTITUTION_KEY	Advancement Institution KEY.	NUMBER	CLN_ADVANCEMENT_INSTITUTION	ADVANCEMENT_INSTITUTION_KEY	NO	NO	ADVANCEMENT DEGREE
DEGREE_COUNT	Total number of degrees for the constituent.	NUMBER	GROUP_COUNT_EXPRESSIONS	DEGREE_COUNT_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
DEGREE_DATE	Date the degree was awarded to the constituent.	DATE	APRADEG	APRADEG_DATE	NO	NO	ADVANCEMENT DEGREE
DEGREE_SEQEUENCE_NUMBER	Unique one-up sequence number assigned to each degree identified for this constituent.	NUMBER	APRADEG	APRADEG_SEQ_NO	NO	NO	ADVANCEMENT DEGREE
DEGREE_START_DATE_PARTIAL	Start date for this person���������s acquisition of this degree.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DEGREE_STOP_DATE_PARTIAL	End date for this person���������s acquisition of this degree.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ENTITY_KEY	System generated, unique, internal primary key for a constituent entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	ADVANCEMENT DEGREE
ENTITY_UID	System generated unique internal identification number assigned to this constituent.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	ADVANCEMENT DEGREE
GRADUATION_DATE_PARTIAL	Graduation date for this degree.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
HOME_INSTITUTION_IND	Indicates whether the degree was awarded from this institution.	NUMBER	EXPRESSIONS	HOME_INSTITUTION_IND_EXPRESSION	NO	NO	ADVANCEMENT DEGREE
HONORARY_DEGREE_IND	Indicates whether the degree was an honorary degree.	NUMBER	CONSTANT_0	0	NO	NO	ADVANCEMENT DEGREE
MULTI_SOURCE_KEY	System generated, unique, internal primary key for the multi-institution facility.	NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	ADVANCEMENT DEGREE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'ADVANCEMENT_DEGREE_F1B'	NO	NO	ADVANCEMENT DEGREE
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