Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ASSIGNMENT		Specifies whether the member was added by the system via a batch job or manually by a user.	VARCHAR2(2)		APRDCLB	APRDCLB_DCAM_CODE
ASSIGNMENT_DESC		Gift society assignment code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		APRDCLB	APRDCLB_PIDM
GIFT_SOCIETY		Gift society code.	VARCHAR2(4)		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.	NUMBER		NA	NA
GIFT_SOCIETY_CATEGORY		Category of gift societies.	VARCHAR2(2)		ATVDCNP	ATVDCNP_DCST_CODE
GIFT_SOCIETY_CATEGORY_DESC		Society category description.	VARCHAR2(30)		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.	NUMBER(2)		ATVDCST	ATVDCST_PRI_IND
GIFT_SOCIETY_DESC		Gift society description.	VARCHAR2(60)		ATVDCNP	ATVDCNP_DESC
GIFT_SOCIETY_END_YEAR		Ending society year of the gift society. No members are allowed after this year.	NUMBER(4)		ATVDCNP	ATVDCNP_DCYR_CODE
GIFT_SOCIETY_END_YEAR_DESC		Gift society club year description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_SOCIETY_LEADER_POSN		Indicates a leadership position whether it be an officer, honorary, or chair.	VARCHAR2(0)		NA	NA
GIFT_SOCIETY_LEADER_POSN_DESC		Leadership position.	VARCHAR2(0)		NA	NA
GIFT_SOCIETY_NAME	Gift Society Name	Gift society name that defaults from the constituent or organization record when a membership is created. The name can be changed for each membership created.	VARCHAR2(120)		APRDCLB	APRDCLB_SOCIETY_NAME
GIFT_SOCIETY_PRIORITY		Unique priority indicator of the gift society. Lowest number is the highest priority.	NUMBER(2)		ATVDCNP	ATVDCNP_PRIORITY_IND
GIFT_SOCIETY_YEAR		Gift society year for which the constituent/organization is a member.	NUMBER(4)		APRDCLB	APRDCLB_DCYR_CODE
GIFT_SOCIETY_YEAR_DESC		Gift society club year description.	VARCHAR2(30)		ATVDCYR	ATVDCYR_DESC
IND_GIFT_SOCIETY_QUALIFY_AMT		Qualifying gift amount for the identification number.	NUMBER		NA	NA
LIFETIME_GIFT_SOCIETY_IND		Indicates whether the gift society is a lifetime membership.	VARCHAR2(1)		CALCULATION	DECODE(APRDCLB_DCYR_CODE,'9999','Y','N')
MANUAL_ENTRY_IND		Indicates whether gift society members must be entered into this society manually; i.e. not computer calculated.	VARCHAR2(1)		ATVDCNP	ATVDCNP_MANL_ENTRY_IND
MEMBER_DELETE_IND		Specifies whether member may be deleted from the gift society.	VARCHAR2(1)		ATVDCNP	ATVDCNP_DELETE_IND
MIF_DESC		Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
QUALIFY_DATE		Date on which the member qualified for the society.	DATE		APRDCLB	APRDCLB_QUALIFY_DATE
RULE_NUMBER		Rule number by which the member qualified for the gift society.	NUMBER(2)		APRDCLB	APRDCLB_RULE_NO
YEAR_END_DATE		Ending date of the gift society year.	DATE		ATVDCYR	ATVDCYR_END_DATE
YEAR_START_DATE		Beginning date of the gift society year.	DATE		ATVDCYR	ATVDCYR_START_DATE
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: