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

SGHE 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, ENTITY_UID, MEMBERSHIP_NUMBER
MEMBERSHIP_CATEGORY
ENTITY_UID, MEMBERSHIP_PROGRAM, MEMBERSHIP_NUMBER, MEMBERSHIP_TRANSACTION_NUMBER
MEMBERSHIP_PROMOTION
INTEREST

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)  

NA

NA

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

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

AABDUES

AABDUES_SESSION_NUMBER

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

CONSTANT

CONSTANT

'O'

'P'

ENTITY_UID Entity UID System-generated unique internal identification number assigned to this person or organization entity. NUMBER  

AARMEMB

AARMINT

AARMEMB_PIDM

AARMINT_PIDM

ENTRY_DATE Entry Date Membership start date. DATE  

AARMEMB

AARMEMB_ENTRY_DATE

EXPIRATION_DATE Expiration Date Membership expiration date. DATE  

AARMEMB

AARMEMB_EXP_DATE

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

AABDUES

AABDUES_FISC_YEAR

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INTEREST Interest Interest code. VARCHAR2(63)  

AARMINT

AARMINT_INTEREST

INTEREST_APPLIED_AMOUNT Interest Applied Amount Membership payment amount. NUMBER  

AARMINT

AARMINT_AMOUNT

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

AABMINT

AABMINT_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

INTEREST_GROUP Interest Group Group code. VARCHAR2(63)  

AABMINT

AABMINT_AMGP_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

INTEREST_NAME Interest Name Interest name. VARCHAR2(255)  

AABMINT

AABMINT_NAME

INTEREST_TYPE Interest Type Interest type code. VARCHAR2(63)  

AABMINT

AABMINT_AMIN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_ASSIGNMENT Membership Assignment Membership assignment method. VARCHAR2(63)  

AARMEMB

AARMEMB_DCAM_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

AARMEMB

AARMEMB_CARD_IND

MEMBERSHIP_CARD_SENT_DATE Membership Card Sent Date Date card was sent. DATE  

AARMEMB

AARMEMB_CARD_DATE

MEMBERSHIP_CATEGORY Membership Category Membership category code. VARCHAR2(63)  

AARMEMB

AARMEMB_AMCT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_DURATION Membership Duration Length of membership. NUMBER  

AARMEMB

AARMEMB_DURATION

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

AARMEMB

AARMEMB_MEMB_NAME

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

AARMINT

AARMINT_MEMB_NO

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

AABDUES

AABDUES_GIFT_CODE

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

AABDUES

AABDUES_GIFT_DESC

MEMBERSHIP_PROCESSED_DATE Membership Processed Date Membership status date. DATE  

AARMEMB

AARMEMB_AMST_DATE

MEMBERSHIP_PROGRAM Membership Program Association membership code. VARCHAR2(63)  

AARMINT

AARMINT_MEMBERSHIP

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

AABMSHP

AABMSHP_NAME

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

AARMEMB

AARMEMB_AMTP_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_PROMOTION Membership Promotion Membership promotion. VARCHAR2(63)  

AARDUES

AARDUES_AMPM_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

AARMEMB

AARMEMB_AMST_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

AARMINT

AARMINT_TRANS_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

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

AABDUES

AABDUES_FEED_DATE

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

AABDUES

AABDUES_FEED_DOC_CODE

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

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

RENEWAL_DATE Renewal Date Renewal date for future memberships. DATE  

AARMEMB

AARMEMB_RENEWAL_DATE



Ver: 9.0