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

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 Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
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

NO

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

SPRIDEN

SPRIDEN_ENTITY_IND

NO

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

AARMEMB

AARMEMB_PIDM

NO

NO
ENTRY_DATE Membership start date. DATE

AARMEMB

AARMEMB_ENTRY_DATE

NO

NO
EXPIRATION_DATE Membership expiration date. DATE

AARMEMB

AARMEMB_EXP_DATE

NO

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

SPRIDEN

SPRIDEN_ID

NO

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

AARMEMB

AARMEMB_ACTIVITY_DATE

NO

NO
MEMBERSHIP_ASSIGNMENT Membership assignment method. VARCHAR2(63)

AARMEMB

AARMEMB_DCAM_CODE

NO

NO
MEMBERSHIP_ASSIGNMENT_DESC Membership assignment description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AARMEMB

AARMEMB_CARD_IND

NO

NO
MEMBERSHIP_CARD_SENT_DATE Date card was sent. DATE

AARMEMB

AARMEMB_CARD_DATE

NO

NO
MEMBERSHIP_CATEGORY Membership category code. VARCHAR2(63)

AARMEMB

AARMEMB_AMCT_CODE

NO

NO
MEMBERSHIP_CATEGORY_DESC Membership category code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_DUES_AMOUNT Membership qualification amount is the minimum amount of dues required for membership. NUMBER

AARMEMB

AARMEMB_AMT_QUALIFY

NO

NO
MEMBERSHIP_DUES_AMOUNT_OWED Membership amount due. NUMBER

CALCULATION

AARMEMB_AMT_QUALIFY - AOKODSF.F_GET_MEMBER_AMT_PAID

NO

NO
MEMBERSHIP_DUES_AMOUNT_PAID Summarized amounts of the membership payments. NUMBER

AARMINT

AARMINT_AMOUNT

NO

NO
MEMBERSHIP_DURATION Length of membership. NUMBER

AARMEMB

AARMEMB_DURATION

NO

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

AARMEMB

AARMEMB_MEMB_NAME

NO

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

AARMEMB

AARMEMB_MEMB_NO

NO

NO
MEMBERSHIP_PROCESSED_DATE Membership status date. DATE

AARMEMB

AARMEMB_AMST_DATE

NO

NO
MEMBERSHIP_PROGRAM Association membership code. VARCHAR2(63)

AARMEMB

AARMEMB_MEMBERSHIP

NO

NO
MEMBERSHIP_PROGRAM_NAME Membership program name. VARCHAR2(255)

AABMSHP

AABMSHP_NAME

NO

NO
MEMBERSHIP_PROGRAM_TYPE Membership type code. VARCHAR2(63)

AARMEMB

AARMEMB_AMTP_CODE

NO

NO
MEMBERSHIP_PROG_TYPE_DESC Membership type code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_STATUS Individual membership status code. VARCHAR2(63)

AARMEMB

AARMEMB_AMST_CODE

NO

NO
MEMBERSHIP_STATUS_DESC Membership status code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

NA

NA

NO

NO
RENEWAL_DATE Renewal date for future memberships. DATE

AARMEMB

AARMEMB_RENEWAL_DATE

NO

NO


Ver: 9.2