Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CLASS_SCHOOL_KEY	System generated, unique, internal primary key for constituent and associated class year.	NUMBER				NO
CLASS_YEAR	Preferred class year for a person entity.	VARCHAR2(63)	APBCONS	CLASS_YEAR_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY
SCHOOL	School within the institution with which the constituent prefers to be associated.	VARCHAR2(63)	APBCONS	SCHOOL_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY
SCHOOL_LD	School long description.	VARCHAR2(255)	EXPRESSION	SCHOOL_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY
SCHOOL_SD	School short description.	VARCHAR2(255)	EXPRESSION	SCHOOL_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'CLASS_SCHOOL_D1B'	NO	NO	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY
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