RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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
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)

CALCULATION

AARMEMB_STATUS_OVERRIDE_IND

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

NA

NA

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

AARMEMB

AARMEMB_PIDM

ENTRY_DATE Membership start date. DATE

AARMEMB

AARMEMB_ENTRY_DATE

EXPIRATION_DATE Expiration date of the membership. DATE

AARMEMB

AARMEMB_EXP_DATE

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

AARMEMB

AARMEMB_ACTIVITY_DATE

MEMBERSHIP_ASSIGNMENT Membership assignment method. VARCHAR2(2)

AARMEMB

AARMEMB_DCAM_CODE

MEMBERSHIP_ASSIGNMENT_DESC Membership assignment description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

NVL(AARMEMB_CARD_IND,'N')

MEMBERSHIP_CARD_SENT_DATE Date card was sent. DATE

AARMEMB

AARMEMB_CARD_DATE

MEMBERSHIP_CATEGORY Membership category code. VARCHAR2(5)

AARMEMB

AARMEMB_AMCT_CODE

MEMBERSHIP_CATEGORY_DESC Membership category code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_DUES_AMOUNT Membership qualification amount is the minimum amount of dues required for membership. NUMBER(11, 2)

AARMEMB

AARMEMB_AMT_QUALIFY

MEMBERSHIP_DUES_AMOUNT_OWED This field specifies the membership amount due. NUMBER

CALCULATION

AARMEMB_AMT_QUALIFY - SUM(AARMINT_AMOUNT)

MEMBERSHIP_DUES_AMOUNT_PAID Summarized amounts of the membership payments. NUMBER

FUNCTION

AOKODSF.F_GET_MEMB_AMT_PAID

MEMBERSHIP_DURATION Length of membership. NUMBER(3)

AARMEMB

AARMEMB_DURATION

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

AARMEMB

AARMEMB_MEMB_NAME

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

AARMEMB

AARMEMB_MEMB_NO

MEMBERSHIP_PROCESSED_DATE Membership status date. DATE

AARMEMB

AARMEMB_AMST_DATE

MEMBERSHIP_PROGRAM Association membership code. VARCHAR2(5)

AARMEMB

AARMEMB_MEMBERSHIP

MEMBERSHIP_PROGRAM_NAME Membership program name. VARCHAR2(30)

AABMSHP

AABMSHP_NAME

MEMBERSHIP_PROGRAM_TYPE Membership type code. VARCHAR2(3)

AARMEMB

AARMEMB_AMTP_CODE

MEMBERSHIP_PROG_TYPE_DESC Membership type code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MEMBERSHIP_STATUS Individual membership status code. VARCHAR2(1)

AARMEMB

AARMEMB_AMST_CODE

MEMBERSHIP_STATUS_DESC Membership status code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

RENEWAL_DATE Renewal date for future memberships. DATE

AARMEMB

AARMEMB_RENEWAL_DATE

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

NA

NA



Ver: 3.1