Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: MEMBERSHIP

Description Contains detail information for all memberships to which a constituent is or has been a member including entry and expiration dates, duration, membership dues, dues amount paid/owed and member status.
Key & Frequency One row per entity per membership program per membership number.
Recommended Search Columns ENTITY_UID
MEMBERSHIP_PROGRAM, ENTITY_UID, MEMBERSHIP_NUMBER
MEMBERSHIP_CATEGORY

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. 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

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

SPRIDEN

SPRIDEN_ENTITY_IND

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

AARMEMB

AARMEMB_PIDM

ENTRY_DATE Membership start date. DATE

AARMEMB

AARMEMB_ENTRY_DATE

EXPIRATION_DATE Membership expiration date. DATE

AARMEMB

AARMEMB_EXP_DATE

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

SPRIDEN

SPRIDEN_ID

MEMBERSHIP_ACTIVITY_DATE System generated date that is updated on insert or update. DATE

AARMEMB

AARMEMB_ACTIVITY_DATE

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_DUES_AMOUNT Membership qualification amount is the minimum amount of dues required for membership. NUMBER

AARMEMB

AARMEMB_AMT_QUALIFY

MEMBERSHIP_DUES_AMOUNT_OWED Membership amount due. NUMBER

CALCULATION

AARMEMB_AMT_QUALIFY - SUM(AARMINT_AMOUNT)

MEMBERSHIP_DUES_AMOUNT_PAID Summarized amounts of the membership payments. NUMBER

AARMINT

AARMINT_AMOUNT

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)

AARMEMB

AARMEMB_MEMB_NO

MEMBERSHIP_PROCESSED_DATE Membership status date. DATE

AARMEMB

AARMEMB_AMST_DATE

MEMBERSHIP_PROGRAM Association membership code. VARCHAR2(63)

AARMEMB

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

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RENEWAL_DATE Renewal date for future memberships. DATE

AARMEMB

AARMEMB_RENEWAL_DATE



Ver: 8.0