Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			APRDCLB	APRDCLB_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
DECEASED_STATUS	Deceased Status	Indicates whether a person is deceased.	VARCHAR2(1)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
DECEASED_DATE	Deceased Date	Date the person died.	DATE			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
LIFETIME_GIFT_SOCIETY_IND	Lifetime Gift Society Indicator	Indicates whether the gift society is a lifetime membership.	VARCHAR2(1)			CALCULATION	DECODE(APRDCLB_DCYR_CODE,'9999','Y','N')	NO	NO
GIFT_SOCIETY_YEAR	Gift Society Year	Gift society year for which the constituent/organization is a member.	VARCHAR2(63)			APRDCLB	APRDCLB_DCYR_CODE	NO	NO
GIFT_SOCIETY_YEAR_DESC	Gift Society Year Description	Gift society club year description.	VARCHAR2(255)			ATVDCYR	ATVDCYR_DESC	NO	NO
YEAR_START_DATE	Year Start Date	Beginning date of the gift society year.	DATE			ATVDCYR	ATVDCYR_START_DATE	NO	NO
YEAR_END_DATE	Year End Date	Ending date of the gift society year.	DATE			ATVDCYR	ATVDCYR_END_DATE	NO	NO
GIFT_SOCIETY	Gift Society	Gift society code.	VARCHAR2(63)			APRDCLB	APRDCLB_DCNP_CODE	NO	NO
GIFT_SOCIETY_DESC	Gift Society Description	Gift society description.	VARCHAR2(255)			ATVDCNP	ATVDCNP_DESC	NO	NO
GIFT_SOCIETY_NAME	Gift Society Name	Gift society name. The name defaults from the constituent or organization record when a membership is created. The name may be changed for each membership created.	VARCHAR2(255)			APRDCLB	APRDCLB_SOCIETY_NAME	NO	NO
GIFT_SOCIETY_PRIORITY	Gift Society Priority	Unique priority indicator of the gift society. Lowest number is the highest priority.	NUMBER			ATVDCNP	ATVDCNP_PRIORITY_IND	NO	NO
ASSIGNMENT	Assignment	Specifies whether the member was added by the system via a batch job or manually by a user.	VARCHAR2(63)			APRDCLB	APRDCLB_DCAM_CODE	NO	NO
ASSIGNMENT_DESC	Assignment Description	Gift society assignment code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
QUALIFY_DATE	Qualify Date	Date the membe+G11442r qualified for the society.	DATE			APRDCLB	APRDCLB_QUALIFY_DATE	NO	NO
RULE_NUMBER	Rule Number	Rule number by which the member qualified for the gift society.	NUMBER			APRDCLB	APRDCLB_RULE_NO	NO	NO
MEMBER_DELETE_IND	Member Delete Indicator	Specifies whether a member may be deleted from the gift society.	VARCHAR2(1)			ATVDCNP	ATVDCNP_DELETE_IND	NO	NO
GIFT_SOCIETY_CATEGORY	Gift Society Category	Category of gift societies.	VARCHAR2(63)			ATVDCNP	ATVDCNP_DCST_CODE	NO	NO
GIFT_SOCIETY_CATEGORY_DESC	Gift Society Category Description	Society category description.	VARCHAR2(255)			ATVDCST	ATVDCST_DESC	NO	NO
GIFT_SOCIETY_CATEGORY_PRIORITY	Gift Society Category Priority	Society type priority. Lowest number is the highest priority. A number may only be used once in the priority field.	NUMBER			ATVDCST	ATVDCST_PRI_IND	NO	NO
GIFT_SOCIETY_END_YEAR	Gift Society End Year	Ending society year of the gift society. No members are allowed after this year.	VARCHAR2(63)			ATVDCNP	ATVDCNP_DCYR_CODE	NO	NO
GIFT_SOCIETY_END_YEAR_DESC	Gift Society End Year Description	Gift society club year description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MANUAL_ENTRY_IND	Manual Entry Indicator	Indicates whether gift society members must be entered into this society manually, not computer calculated.	VARCHAR2(1)			ATVDCNP	ATVDCNP_MANL_ENTRY_IND	NO	NO
GIFT_SOCIETY_LEADER_POSN	Gift Society Leader Posn	Indicates a leadership position whether it be an officer, honorary, or chair.	VARCHAR2(63)			NA	NA	NO	NO
GIFT_SOCIETY_LEADER_POSN_DESC	Gift Society Leader Posn Description	Leadership position.	VARCHAR2(255)			NA	NA	NO	NO
IND_GIFT_SOCIETY_QUALIFY_AMT	Indicator Gift Society Qualify Amount	Qualifying gift amount for the identification number.	NUMBER			NA	NA	NO	NO
GIFT_SOCIETY_BASE_AMOUNT	Gift Society Base Amount	Base amount for the gift society that would qualify an identification number to be part of the society.	NUMBER			NA	NA	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO

Ver: 9.2