Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AUTO_STATUS_UPDATE_IND		Determines if the status will be over written automatically by incoming dues prior to the renewal and expiration dates.	VARCHAR2(1)
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)		AARMEMB	AARMEMB_PIDM
ENTRY_DATE		Membership start date.	DATE		AARMEMB	AARMEMB_ENTRY_DATE
EXPIRATION_DATE		Expiration date of the membership.	DATE		AARMEMB	AARMEMB_EXP_DATE
MEMBERSHIP_ACTIVITY_DATE		System generated date that is updated on insert or update.	DATE		AARMEMB	AARMEMB_ACTIVITY_DATE
MEMBERSHIP_ASSIGNMENT		Membership assignment method.	VARCHAR2(2)		AARMEMB	AARMEMB_DCAM_CODE
MEMBERSHIP_ASSIGNMENT_DESC		Membership assignment description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
MEMBERSHIP_CARD_IND		Indicates if membership card was sent.	VARCHAR2(1)
MEMBERSHIP_CARD_SENT_DATE		Date card was sent.	DATE		AARMEMB	AARMEMB_CARD_DATE
MEMBERSHIP_CATEGORY		Membership category code.	VARCHAR2(5)		AARMEMB	AARMEMB_AMCT_CODE
MEMBERSHIP_CATEGORY_DESC		Membership category code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
MEMBERSHIP_DUES_AMOUNT		Membership qualification amount is the minimum amount of dues required for membership.	NUMBER(11, 2)		AARMEMB	AARMEMB_AMT_QUALIFY
MEMBERSHIP_DUES_AMOUNT_OWED		This field specifies the membership amount due.	NUMBER
MEMBERSHIP_DUES_AMOUNT_PAID		Summarized amounts of the membership payments.	NUMBER		FUNCTION	AOKODSF.F_GET_MEMB_AMT_PAID
MEMBERSHIP_DURATION		Length of membership.	NUMBER(3)		AARMEMB	AARMEMB_DURATION
MEMBERSHIP_NAME	Membership Name	Default membership name for membership card and other references to the member.	VARCHAR2(120)		AARMEMB	AARMEMB_MEMB_NAME
MEMBERSHIP_NUMBER		System-generated number that uniquely identifies a membership.	VARCHAR2(7)		AARMEMB	AARMEMB_MEMB_NO
MEMBERSHIP_PROCESSED_DATE		Membership status date.	DATE		AARMEMB	AARMEMB_AMST_DATE
MEMBERSHIP_PROGRAM		Association membership code.	VARCHAR2(5)		AARMEMB	AARMEMB_MEMBERSHIP
MEMBERSHIP_PROGRAM_NAME	Membership Program Name	Membership program name.	VARCHAR2(60)		AABMSHP	AABMSHP_NAME
MEMBERSHIP_PROGRAM_TYPE		Membership type code.	VARCHAR2(3)		AARMEMB	AARMEMB_AMTP_CODE
MEMBERSHIP_PROG_TYPE_DESC		Membership type code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
MEMBERSHIP_STATUS		Individual membership status code.	VARCHAR2(1)		AARMEMB	AARMEMB_AMST_CODE
MEMBERSHIP_STATUS_DESC		Membership status code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
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
RENEWAL_DATE		Renewal date for future memberships.	DATE		AARMEMB	AARMEMB_RENEWAL_DATE
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: