Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_MEMBERSHIP_DUES

Description Composite view contains information on each dues payment for a membership program to which a person or organization is affiliated.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CASHIER_SESSION_NUMBER Session number assigned to each cashier session.    

AABDUES

AABDUES_SESSION_NUMBER

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.    

NA

NA

 
ENTITY_UID System generated unique internal identification number assigned to this person or organization entity.    

AARDUES

AARDUES_PIDM

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

AABDUES

AABDUES_FISC_YEAR

 
MEMBERSHIP_NUMBER System-generated number that uniquely identifies a membership.    

AARDUES

AARDUES_MEMB_NO

 
MEMBERSHIP_PAYMENT_TYPE Membership payment type.    

AABDUES

AABDUES_GIFT_CODE

 
MEMBERSHIP_PAYMENT_TYPE_DESC Membership payment type description.    

AABDUES

AABDUES_GIFT_DESC

 
MEMBERSHIP_PAYOR_UID System generated unique internal identification number assigned to this person or organization entity.    

AARDUES

AARDUES_PAYOR_PIDM

 
MEMBERSHIP_PROGRAM Association membership code.    

AARDUES

AARDUES_MEMBERSHIP

 
MEMBERSHIP_PROMOTION Membership promotion.    

AARDUES

AARDUES_AMPM_CODE

 
MEMBERSHIP_PROMOTION_DESC Membership promotion description.    

FUNCTION

GOKODSF.F_GET_DESC

 
MEMBERSHIP_TRANSACTION_NUMBER System generated unique internal identification number that identifies the transaction number for the ID.    

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.    

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.    

NA

NA

 
PAYMENT_POSTING_DATE Date the dues payment transaction was interfaced to the financial ledgers.    

AABDUES

AABDUES_FEED_DATE

 
PAYMENT_POSTING_DOCUMENT Document code generated to identify and feed this transaction to Finance.    

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.    

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.    

NA

NA

 


Ver: 8.3