Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: MEMBERSHIP_INTEREST

Description Contains listing of all interests to which this constituent is associated in this membership program. Includes general membership information and interest related details such as promotion type, transaction posting date and type of payment.
Key & Frequency One row per entity per membership program per membership number per interest per membership transaction number.
Recommended Search Columns ENTITY_UID, MEMBERSHIP_PROGRAM, MEMBERSHIP_NUMBER, MEMBERSHIP_TRANSACTION_NUMBER
MEMBERSHIP_PROMOTION
MEMBERSHIP_PROGRAM, ENTITY_UID, MEMBERSHIP_NUMBER
MEMBERSHIP_CATEGORY
INTEREST

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
ENTITY_UID Entity UID System-generated unique internal identification number assigned to this person or organization entity. NUMBER    

AARMEMB

AARMINT

AARMEMB_PIDM

AARMINT_PIDM

NO

NO

NO
ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
NAME Name Organization's name or last name, first name, middle initial of the person. VARCHAR2(255)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ENTITY_IND Entity Indicator Indicates whether the entity is a person or an organization. VARCHAR2(1)    

CONSTANT

CONSTANT

'O'

'P'

NO

NO

NO
ENTRY_DATE Entry Date Membership start date. DATE    

AARMEMB

AARMEMB_ENTRY_DATE

NO

NO
EXPIRATION_DATE Expiration Date Membership expiration date. DATE    

AARMEMB

AARMEMB_EXP_DATE

NO

NO
INTEREST_APPLIED_AMOUNT Interest Applied Amount Membership payment amount. NUMBER    

AARMINT

AARMINT_AMOUNT

NO

NO
INTEREST Interest Interest code. VARCHAR2(63)    

AARMINT

AARMINT_INTEREST

NO

NO
INTEREST_NAME Interest Name Interest name. VARCHAR2(255)    

AABMINT

AABMINT_NAME

NO

NO
INTEREST_COLLEGE Interest College College code associated with the interest. VARCHAR2(63)    

AABMINT

AABMINT_COLL_CODE

NO

NO
INTEREST_COLLEGE_DESC Interest College Description College or school description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
INTEREST_GROUP Interest Group Group code. VARCHAR2(63)    

AABMINT

AABMINT_AMGP_CODE

NO

NO
INTEREST_GROUP_DESC Interest Group Description Interest group code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
INTEREST_TYPE Interest Type Interest type code. VARCHAR2(63)    

AABMINT

AABMINT_AMIN_CODE

NO

NO
INTEREST_TYPE_DESC Interest Type Description Interest type description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_ASSIGNMENT Membership Assignment Membership assignment method. VARCHAR2(63)    

AARMEMB

AARMEMB_DCAM_CODE

NO

NO
MEMBERSHIP_ASSIGNMENT_DESC Membership Assignment Description Membership assignment description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_CARD_IND Membership Card Indicator Indicates if membership card was sent. VARCHAR2(1)    

AARMEMB

AARMEMB_CARD_IND

NO

NO
MEMBERSHIP_CARD_SENT_DATE Membership Card Sent Date Date card was sent. DATE    

AARMEMB

AARMEMB_CARD_DATE

NO

NO
MEMBERSHIP_CATEGORY Membership Category Membership category code. VARCHAR2(63)    

AARMEMB

AARMEMB_AMCT_CODE

NO

NO
MEMBERSHIP_CATEGORY_DESC Membership Category Description Membership category code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_DURATION Membership Duration Length of membership. NUMBER    

AARMEMB

AARMEMB_DURATION

NO

NO
RENEWAL_DATE Renewal Date Renewal date for future memberships. DATE    

AARMEMB

AARMEMB_RENEWAL_DATE

NO

NO
MEMBERSHIP_NAME Membership Name Default membership name for member references. Membership card for example. VARCHAR2(255)    

AARMEMB

AARMEMB_MEMB_NAME

NO

NO
MEMBERSHIP_NUMBER Membership Number System-generated number that uniquely identifies a membership. VARCHAR2(63)    

AARMINT

AARMINT_MEMB_NO

NO

NO
MEMBERSHIP_TRANSACTION_NUMBER Membership Transaction Number Transaction number for the membership payment. VARCHAR2(63)    

AARMINT

AARMINT_TRANS_NO

NO

NO
MEMBERSHIP_PROCESSED_DATE Membership Processed Date Membership status date. DATE    

AARMEMB

AARMEMB_AMST_DATE

NO

NO
MEMBERSHIP_PROGRAM Membership Program Association membership code. VARCHAR2(63)    

AARMINT

AARMINT_MEMBERSHIP

NO

NO
MEMBERSHIP_PROGRAM_NAME Membership Program Name Membership program name. VARCHAR2(255)    

AABMSHP

AABMSHP_NAME

NO

NO
MEMBERSHIP_PROGRAM_TYPE Membership Program Type Membership type code. VARCHAR2(63)    

AARMEMB

AARMEMB_AMTP_CODE

NO

NO
MEMBERSHIP_PROG_TYPE_DESC Membership Prog Type Description Membership type code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_STATUS Membership Status Individual membership status code. VARCHAR2(63)    

AARMEMB

AARMEMB_AMST_CODE

NO

NO
MEMBERSHIP_STATUS_DESC Membership Status Description Membership status code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
AUTO_STATUS_UPDATE_IND Auto Status Update Indicator Determines if the status will be over written automatically by incoming dues prior to the renewal and expiration dates. VARCHAR2(1)    

AARMEMB

AARMEMB_STATUS_OVERRIDE_IND

NO

NO
MEMBERSHIP_PAYMENT_TYPE Membership Payment Type Membership payment type. VARCHAR2(63)    

AABDUES

AABDUES_GIFT_CODE

NO

NO
MEMBERSHIP_PAYMENT_TYPE_DESC Membership Payment Type Description Membership payment type description. VARCHAR2(255)    

AABDUES

AABDUES_GIFT_DESC

NO

NO
MEMBERSHIP_PROMOTION Membership Promotion Membership promotion. VARCHAR2(63)    

AARDUES

AARDUES_AMPM_CODE

NO

NO
MEMBERSHIP_PROMOTION_DESC Membership Promotion Description Membership promotion description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PAYMENT_POSTING_DATE Payment Posting Date Date the dues payment transaction was interfaced to the financial ledgers. DATE    

AABDUES

AABDUES_FEED_DATE

NO

NO
PAYMENT_POSTING_DOCUMENT Payment Posting Document Document code generated to identify and feed this transaction to Finance. VARCHAR2(63)    

AABDUES

AABDUES_FEED_DOC_CODE

NO

NO
PAYMENT_POSTING_STATUS Payment Posting Status Indicates the status of the transaction in the accounting feed process as ready to feed, or transaction has been fed. VARCHAR2(63)    

AABDUES

AABDUES_FEED_IND

NO

NO
FISCAL_YEAR Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)    

AABDUES

AABDUES_FISC_YEAR

NO

NO
CASHIER_SESSION_NUMBER Cashier Session Number Session number assigned to each cashier session. NUMBER    

AABDUES

AABDUES_SESSION_NUMBER

NO

NO
MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)    

NA

NA

NO

NO
MULTI_SOURCE_DESC Multi Source Description Institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)    

NA

NA

NO

NO
PROCESS_GROUP Process Group Institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)    

NA

NA

NO

NO
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)    

NA

NA

NO

NO


Ver: 9.2