Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CASHIER_SESSION_NUMBER		Session number assigned to each cashier session.	NUMBER(6)		AABDUES	AABDUES_SESSION_NUMBER
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)		NA	NA
ENTITY_UID		System generated unique internal identification number assigned to this person or organization entity.	NUMBER(8)		AARDUES	AARDUES_PIDM
FISCAL_YEAR		Unique identifier or code for the fiscal year.	NUMBER(4)		AABDUES	AABDUES_FISC_YEAR
MEMBERSHIP_NUMBER		System-generated number that uniquely identifies a membership.	VARCHAR2(7)		AARDUES	AARDUES_MEMB_NO
MEMBERSHIP_PAYMENT_TYPE		Membership payment type.	VARCHAR2(2)		AABDUES	AABDUES_GIFT_CODE
MEMBERSHIP_PAYMENT_TYPE_DESC		Membership payment type description.	VARCHAR2(30)		AABDUES	AABDUES_GIFT_DESC
MEMBERSHIP_PAYOR_UID		System generated unique internal identification number assigned to this person or organization entity.	NUMBER(8)		AARDUES	AARDUES_PAYOR_PIDM
MEMBERSHIP_PROGRAM		Association membership code.	VARCHAR2(5)		AARDUES	AARDUES_MEMBERSHIP
MEMBERSHIP_PROMOTION		Membership promotion.	VARCHAR2(5)		AARDUES	AARDUES_AMPM_CODE
MEMBERSHIP_PROMOTION_DESC		Membership promotion description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
MEMBERSHIP_TRANSACTION_NUMBER		System generated unique internal identification number that identifies the transaction number for the ID.	VARCHAR2(7)		AARDUES	AARDUES_TRANS_NO
MIF_DESC		The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)		NA	NA
MIF_VALUE		The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)		NA	NA
PAYMENT_POSTING_DATE		Date the dues payment transaction was interfaced to the financial ledgers.	DATE		AABDUES	AABDUES_FEED_DATE
PAYMENT_POSTING_DOCUMENT		Document code generated to identify and feed this transaction to Finance.	VARCHAR2(8)		AABDUES	AABDUES_FEED_DOC_CODE
PAYMENT_POSTING_STATUS		Indicates the status of the transaction in the accounting feed process as ready to feed, or transaction has been fed.	VARCHAR2(1)		AABDUES	AABDUES_FEED_IND
ZONE_VALUE		The institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)		NA	NA

Ver: