Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_MEMBERSHIP

Description Source composite view contains information on each membership program to which a person or organization is affiliated on a per interest basis.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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)       NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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 Expiration date of the membership. DATE

AARMEMB

AARMEMB_EXP_DATE

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

AARMEMB

AARMEMB_DCAM_CODE

NO

NO
MEMBERSHIP_ASSIGNMENT_DESC Membership assignment description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AARMEMB

AARMEMB_CARD_DATE

NO

NO
MEMBERSHIP_CATEGORY Membership category code. VARCHAR2(5)

AARMEMB

AARMEMB_AMCT_CODE

NO

NO
MEMBERSHIP_CATEGORY_DESC Membership category code description. VARCHAR2(30)

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 This field specifies the membership amount due. NUMBER       NO
MEMBERSHIP_DUES_AMOUNT_PAID Summarized amounts of the membership payments. NUMBER

FUNCTION

AOKODSF.F_GET_MEMB_AMT_PAID

NO

NO
MEMBERSHIP_DURATION Length of membership. NUMBER

AARMEMB

AARMEMB_DURATION

NO

NO
MEMBERSHIP_NAME Default membership name for membership card and other references to the member. VARCHAR2(120)

AARMEMB

AARMEMB_MEMB_NAME

NO

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

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

AARMEMB

AARMEMB_MEMBERSHIP

NO

NO
MEMBERSHIP_PROGRAM_NAME Membership program name. VARCHAR2(60)

AABMSHP

AABMSHP_NAME

NO

NO
MEMBERSHIP_PROGRAM_TYPE Membership type code. VARCHAR2(3)

AARMEMB

AARMEMB_AMTP_CODE

NO

NO
MEMBERSHIP_PROG_TYPE_DESC Membership type code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMBERSHIP_STATUS Individual membership status code. VARCHAR2(1)

AARMEMB

AARMEMB_AMST_CODE

NO

NO
MEMBERSHIP_STATUS_DESC Membership status code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

NO
RENEWAL_DATE Renewal date for future memberships. DATE

AARMEMB

AARMEMB_RENEWAL_DATE

NO

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

NA

NA

NO

NO


Ver: