Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	Gift society assignment code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DECEASED_DATE	Date the person died.	DATE	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
DECEASED_STATUS	Indicates whether a person is deceased.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRDCLB	APRDCLB_PIDM	NO	NO
GIFT_SOCIETY	Gift society code.	VARCHAR2(63)	APRDCLB	APRDCLB_DCNP_CODE	NO	NO
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
GIFT_SOCIETY_CATEGORY	Category of gift societies.	VARCHAR2(63)	ATVDCNP	ATVDCNP_DCST_CODE	NO	NO
GIFT_SOCIETY_CATEGORY_DESC	Society category description.	VARCHAR2(255)	ATVDCST	ATVDCST_DESC	NO	NO
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_DESC	Gift society description.	VARCHAR2(255)	ATVDCNP	ATVDCNP_DESC	NO	NO
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 club year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	Leadership position.	VARCHAR2(255)	NA	NA	NO	NO
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	Unique priority indicator of the gift society. Lowest number is the highest priority.	NUMBER	ATVDCNP	ATVDCNP_PRIORITY_IND	NO	NO
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 club year description.	VARCHAR2(255)	ATVDCYR	ATVDCYR_DESC	NO	NO
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
IND_GIFT_SOCIETY_QUALIFY_AMT	Qualifying gift amount for the identification number.	NUMBER	NA	NA	NO	NO
LIFETIME_GIFT_SOCIETY_IND	Indicates whether the gift society is a lifetime membership.	VARCHAR2(1)	CALCULATION	DECODE(APRDCLB_DCYR_CODE,'9999','Y','N')	NO	NO
MANUAL_ENTRY_IND	Indicates whether gift society members must be entered into this society manually, not computer calculated.	VARCHAR2(1)	ATVDCNP	ATVDCNP_MANL_ENTRY_IND	NO	NO
MEMBER_DELETE_IND	Specifies whether a member may be deleted from the gift society.	VARCHAR2(1)	ATVDCNP	ATVDCNP_DELETE_IND	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
QUALIFY_DATE	Date the membe+G11442r qualified for the society.	DATE	APRDCLB	APRDCLB_QUALIFY_DATE	NO	NO
RULE_NUMBER	Rule number by which the member qualified for the gift society.	NUMBER	APRDCLB	APRDCLB_RULE_NO	NO	NO
YEAR_END_DATE	Ending date of the gift society year.	DATE	ATVDCYR	ATVDCYR_END_DATE	NO	NO
YEAR_START_DATE	Beginning date of the gift society year.	DATE	ATVDCYR	ATVDCYR_START_DATE	NO	NO

Ver: 9.2