RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE 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 Definition Database Data Type Source Name Source Column
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 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 Session number assigned to each cashier session. NUMBER

AABDUES

AABDUES_SESSION_NUMBER

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

CONSTANT

'O'

'P'

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

AARMEMB

AARMINT

AARMEMB_PIDM

AARMINT_PIDM

ENTRY_DATE Membership start date. DATE

AARMEMB

AARMEMB_ENTRY_DATE

EXPIRATION_DATE Membership expiration date. DATE

AARMEMB

AARMEMB_EXP_DATE

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER

AABDUES

AABDUES_FISC_YEAR

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INTEREST Interest code. VARCHAR2(63)

AARMINT

AARMINT_INTEREST

INTEREST_APPLIED_AMOUNT Membership payment amount. NUMBER

AARMINT

AARMINT_AMOUNT

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

AABMINT

AABMINT_COLL_CODE

INTEREST_COLLEGE_DESC College or school description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INTEREST_GROUP Group code. VARCHAR2(63)

AABMINT

AABMINT_AMGP_CODE

INTEREST_GROUP_DESC Interest group code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INTEREST_NAME Interest name. VARCHAR2(255)

AABMINT

AABMINT_NAME

INTEREST_TYPE Interest type code. VARCHAR2(63)

AABMINT

AABMINT_AMIN_CODE

INTEREST_TYPE_DESC Interest type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_ASSIGNMENT Membership assignment method. VARCHAR2(63)

AARMEMB

AARMEMB_DCAM_CODE

MEMBERSHIP_ASSIGNMENT_DESC Membership assignment description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

AARMEMB

AARMEMB_CARD_IND

MEMBERSHIP_CARD_SENT_DATE Date card was sent. DATE

AARMEMB

AARMEMB_CARD_DATE

MEMBERSHIP_CATEGORY Membership category code. VARCHAR2(63)

AARMEMB

AARMEMB_AMCT_CODE

MEMBERSHIP_CATEGORY_DESC Membership category code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_DURATION Length of membership. NUMBER

AARMEMB

AARMEMB_DURATION

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

AARMEMB

AARMEMB_MEMB_NAME

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

AARMINT

AARMINT_MEMB_NO

MEMBERSHIP_PAYMENT_TYPE Membership payment type. VARCHAR2(63)

AABDUES

AABDUES_GIFT_CODE

MEMBERSHIP_PAYMENT_TYPE_DESC Membership payment type description. VARCHAR2(255)

AABDUES

AABDUES_GIFT_DESC

MEMBERSHIP_PROCESSED_DATE Membership status date. DATE

AARMEMB

AARMEMB_AMST_DATE

MEMBERSHIP_PROGRAM Association membership code. VARCHAR2(63)

AARMINT

AARMINT_MEMBERSHIP

MEMBERSHIP_PROGRAM_NAME Membership program name. VARCHAR2(255)

AABMSHP

AABMSHP_NAME

MEMBERSHIP_PROGRAM_TYPE Membership type code. VARCHAR2(63)

AARMEMB

AARMEMB_AMTP_CODE

MEMBERSHIP_PROG_TYPE_DESC Membership type code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_PROMOTION Membership promotion. VARCHAR2(63)

AARDUES

AARDUES_AMPM_CODE

MEMBERSHIP_PROMOTION_DESC Membership promotion description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_STATUS Individual membership status code. VARCHAR2(63)

AARMEMB

AARMEMB_AMST_CODE

MEMBERSHIP_STATUS_DESC Membership status code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

AARMINT

AARMINT_TRANS_NO

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 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 Organization's name or last name, first name, middle initial of the person. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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(63)

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(63)

AABDUES

AABDUES_FEED_IND

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 for future memberships. DATE

AARMEMB

AARMEMB_RENEWAL_DATE



Ver: 3.1