ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
ASSIGNMENT	Specifies whether the member was added by the system via a batch job or manually by a user.			APRDCLB	APRDCLB_DCAM_CODE
ASSIGNMENT_DESC	Gift society assignment code description.			FUNCTION	GOKODSF.F_GET_DESC
DECEASED_DATE	Date the person died.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
DECEASED_STATUS	Indicates whether a person is deceased.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.			APRDCLB	APRDCLB_PIDM
GIFT_SOCIETY	Gift society code.			APRDCLB	APRDCLB_DCNP_CODE
GIFT_SOCIETY_BASE_AMOUNT	Base amount for the gift society that would qualify an identification number to be part of the society.			NA	NA
GIFT_SOCIETY_CATEGORY	Category of gift societies.			ATVDCNP	ATVDCNP_DCST_CODE
GIFT_SOCIETY_CATEGORY_DESC	Society category description.			ATVDCST	ATVDCST_DESC
GIFT_SOCIETY_CATEGORY_PRIORITY	Society type priority. Lowest number is the highest priority. A number may only be used once in the priority field.			ATVDCST	ATVDCST_PRI_IND
GIFT_SOCIETY_DESC	Gift society description.			ATVDCNP	ATVDCNP_DESC
GIFT_SOCIETY_END_YEAR	Ending society year of the gift society. No members are allowed after this year.			ATVDCNP	ATVDCNP_DCYR_CODE
GIFT_SOCIETY_END_YEAR_DESC	Gift society club year description.			FUNCTION	GOKODSF.F_GET_DESC
GIFT_SOCIETY_LEADER_POSN	Indicates a leadership position whether it be an officer, honorary, or chair.			NA	NA
GIFT_SOCIETY_LEADER_POSN_DESC	Leadership position.			NA	NA
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.			APRDCLB	APRDCLB_SOCIETY_NAME
GIFT_SOCIETY_PRIORITY	Unique priority indicator of the gift society. Lowest number is the highest priority.			ATVDCNP	ATVDCNP_PRIORITY_IND
GIFT_SOCIETY_YEAR	Gift society year for which the constituent/organization is a member.			APRDCLB	APRDCLB_DCYR_CODE
GIFT_SOCIETY_YEAR_DESC	Gift society club year description.			ATVDCYR	ATVDCYR_DESC
ID	Person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
IND_GIFT_SOCIETY_QUALIFY_AMT	Qualifying gift amount for the identification number.			NA	NA
LIFETIME_GIFT_SOCIETY_IND	Indicates whether the gift society is a lifetime membership.			CALCULATION	DECODE(APRDCLB_DCYR_CODE,'9999','Y','N')
MANUAL_ENTRY_IND	Indicates whether gift society members must be entered into this society manually, not computer calculated.			ATVDCNP	ATVDCNP_MANL_ENTRY_IND
MEMBER_DELETE_IND	Specifies whether a member may be deleted from the gift society.			ATVDCNP	ATVDCNP_DELETE_IND
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
QUALIFY_DATE	Date the membe+G11442r qualified for the society.			APRDCLB	APRDCLB_QUALIFY_DATE
RULE_NUMBER	Rule number by which the member qualified for the gift society.			APRDCLB	APRDCLB_RULE_NO
YEAR_END_DATE	Ending date of the gift society year.			ATVDCYR	ATVDCYR_END_DATE
YEAR_START_DATE	Beginning date of the gift society year.			ATVDCYR	ATVDCYR_START_DATE

Ver: 8.3