Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	CLN_ENTITY	ENTITY_KEY	NO	NO	GIFT SOCIETY
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_COUNT	Count of unique gift societies for which a constituent is a member.	VARCHAR2(252)	GROUP_COUNT_EXPRESSIONS	GIFT_SOCIETY_COUNT_EXPRESSION	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_DETAIL_KEY		NUMBER				NO
GIFT_SOCIETY_EXP_DT_PARTIAL	The expiration date for participation in this gift society for this constituent/organization.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
GIFT_SOCIETY_GROUP_KEY		NUMBER	GROUP_COUNT_EXPRESSIONS	GIFT_SOCIETY_GROUP_KEY_EXPRESSION	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_JOINT_MEMBER_IND	Indicates if this is a joint gift society membership; 1= Yes, 0 = No.	NUMBER	CONSTANT_0	1	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_JOINT_UID	System generated ID number of the person that is the second (joint) member of this gift society.	NUMBER	CONSTANT_0	0	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_KEY		NUMBER	CLN_GIFT_SOCIETY	GIFT_SOCIETY_KEY	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_PREMIUM_GROUP_KEY		NUMBER	GROUP_COUNT_EXPRESSIONS	GIFT_SOCIETY_PREMIUM_GROUP_KEY_EXPRESSION	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_PRI_NUMBER	The unique priority numeric indicator of the gift society. The lowest number is the highest priority.	NUMBER	ATVDCNP	ATVDCNP_PRIORITY_IND	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_QUALIFY_DATE	The date on which the member qualified for the society.	DATE	APRDCLB	APRDCLB_QUALIFY_DATE	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_RECORD_COUNT	Count of total gift society records for the constituent.	NUMBER	GROUP_COUNT_EXPRESSIONS	GIFT_SOCIETY_RECORD_COUNT_EXPRESSION	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_SEQ_NUMBER	This field assures that gift society records for the same entity with the same code and end date have unique keys. This MUST be a unique number within the gift_club_id_number and be greater than zero. If the partner ID is greater than zero, then the sequence number of this row must match the sequence number of the partner ID row	NUMBER	CONSTANT_0	1	NO	NO	GIFT SOCIETY
GIFT_SOCIETY_START_DT_PARTIAL	The date the constituent/organization became a member of this gift society.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
GIFT_SOCIETY_YEAR_KEY		NUMBER	CLN_GIFT_SOCIETY_YEAR	GIFT_SOCIETY_YEAR_KEY	NO	NO	GIFT SOCIETY
LIFETIME_GIFT_SOCIETY_IND	Indicates a gift society lifetime membership	NUMBER	EXPRESSIONS	LIFETIME_GIFT_SOCIETY_IND_EXPRESSION	NO	NO	GIFT SOCIETY
MULTI_SOURCE_KEY		NUMBER	CLN_MULTI_SOURCE	MULTI_SOURCE_KEY	NO	NO	GIFT SOCIETY
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT_1	'GIFT_SOCIETY_F1B'	NO	NO	GIFT SOCIETY
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
UNIT_KEY		NUMBER	CONSTANT_0	0	NO	NO	GIFT SOCIETY
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