Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
CASHIER_SESSION_NUMBER	Session number assigned to each cashier session.	NUMBER	AABDUES	AABDUES_SESSION_NUMBER	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
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	NO	NO
ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	AARDUES	AARDUES_PIDM	NO	NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	NUMBER	AABDUES	AABDUES_FISC_YEAR	NO	NO
MEMBERSHIP_NUMBER	System-generated number that uniquely identifies a membership.	VARCHAR2(7)	AARDUES	AARDUES_MEMB_NO	NO	NO
MEMBERSHIP_PAYMENT_TYPE	Membership payment type.	VARCHAR2(2)	AABDUES	AABDUES_GIFT_CODE	NO	NO
MEMBERSHIP_PAYMENT_TYPE_DESC	Membership payment type description.	VARCHAR2(30)	AABDUES	AABDUES_GIFT_DESC	NO	NO
MEMBERSHIP_PAYOR_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	AARDUES	AARDUES_PAYOR_PIDM	NO	NO
MEMBERSHIP_PROGRAM	Association membership code.	VARCHAR2(5)	AARDUES	AARDUES_MEMBERSHIP	NO	NO
MEMBERSHIP_PROMOTION	Membership promotion.	VARCHAR2(5)	AARDUES	AARDUES_AMPM_CODE	NO	NO
MEMBERSHIP_PROMOTION_DESC	Membership promotion description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MEMBERSHIP_TRANSACTION_NUMBER	System generated unique internal identification number that identifies the transaction number for the ID.	VARCHAR2(7)	AARDUES	AARDUES_TRANS_NO	NO	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	NO	NO
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	NO	NO
PAYMENT_POSTING_DATE	Date the dues payment transaction was interfaced to the financial ledgers.	DATE	AABDUES	AABDUES_FEED_DATE	NO	NO
PAYMENT_POSTING_DOCUMENT	Document code generated to identify and feed this transaction to Finance.	VARCHAR2(8)	AABDUES	AABDUES_FEED_DOC_CODE	NO	NO
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	NO	NO
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	NO	NO

Ver: