Target Column	Business Definition	Database Data Type	Source Name	Source Column
CASHIER_SESSION_NUMBER	Session number assigned to each cashier session.	NUMBER	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	AARDUES	AARDUES_PIDM
FISCAL_YEAR	Unique identifier or code for the fiscal year.	NUMBER	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	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: