Reporting View Target: MEMBERSHIP

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

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	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