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

Banner Operational Data Store
Composite View Target: AA_MEMBERSHIP_INTEREST

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

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

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

AARMINT

AARMINT_PIDM

NO

NO
INTEREST Interest code. VARCHAR2(5)

AARMINT

AARMINT_INTEREST

NO

NO
INTEREST_APPLIED_AMOUNT Membership payment amount. NUMBER

AARMINT

AARMINT_AMOUNT

NO

NO
INTEREST_COLLEGE College code associated with the interest. VARCHAR2(2)

AABMINT

AABMINT_COLL_CODE

NO

NO
INTEREST_COLLEGE_DESC College or school description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
INTEREST_GROUP Group code. VARCHAR2(5)

AABMINT

AABMINT_AMGP_CODE

NO

NO
INTEREST_GROUP_DESC Interest group code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
INTEREST_NAME Interest description. VARCHAR2(60)

AABMINT

AABMINT_NAME

NO

NO
INTEREST_TYPE Interest type code. VARCHAR2(2)

AABMINT

AABMINT_AMIN_CODE

NO

NO
INTEREST_TYPE_DESC Interest type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AARMINT

AARMINT_MEMB_NO

NO

NO
MEMBERSHIP_PROGRAM Membership code for association. VARCHAR2(5)

AARMINT

AARMINT_MEMBERSHIP

NO

NO
MEMBERSHIP_TRANSACTION_NUMBER System generated unique internal identification number that identifies the transaction number for the ID. VARCHAR2(7)

AARMINT

AARMINT_TRANS_NO

NO

NO
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

NO

NO
ZONE_VALUE The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

NO


Ver: