RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

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

AARMINT

AARMINT_PIDM

INTEREST Interest code. VARCHAR2(5)

AARMINT

AARMINT_INTEREST

INTEREST_APPLIED_AMOUNT Membership payment amount. NUMBER(11, 2)

AARMINT

AARMINT_AMOUNT

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

AABMINT

AABMINT_COLL_CODE

INTEREST_COLLEGE_DESC College or school description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

INTEREST_GROUP Group code. VARCHAR2(5)

AABMINT

AABMINT_AMGP_CODE

INTEREST_GROUP_DESC Interest group code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

INTEREST_NAME Interest description. VARCHAR2(60)

AABMINT

AABMINT_NAME

INTEREST_TYPE Interest type code. VARCHAR2(2)

AABMINT

AABMINT_AMIN_CODE

INTEREST_TYPE_DESC Interest type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

AARMINT

AARMINT_MEMB_NO

MEMBERSHIP_PROGRAM Membership code for association. VARCHAR2(5)

AARMINT

AARMINT_MEMBERSHIP

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

AARMINT

AARMINT_TRANS_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

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

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



Ver: 3.1