Banner EDW Source: AARMEMB

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
AARMEMB_ACTIVITY_DATE	NO	REPORTING VIEW	MEMBERSHIP	MEMBERSHIP_ACTIVITY_DATE	NA	NO
AARMEMB_AMCT_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_MEMBERSHIP MEMBERSHIP_INTEREST MEMBERSHIP	MEMBER_CATEGORY MEMBERSHIP_CATEGORY MEMBERSHIP_CATEGORY	MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST NA NA	NO NO NO
AARMEMB_AMST_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_MEMBERSHIP MEMBERSHIP MEMBERSHIP_INTEREST	MEMBER_STATUS MEMBERSHIP_STATUS MEMBERSHIP_STATUS	MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST NA NA	NO NO NO
AARMEMB_AMST_DATE	NO	REPORTING VIEW	MEMBERSHIP_INTEREST MEMBERSHIP	MEMBERSHIP_PROCESSED_DATE MEMBERSHIP_PROCESSED_DATE	NA NA	NO NO
AARMEMB_AMTP_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_MEMBERSHIP MEMBERSHIP MEMBERSHIP_INTEREST	MEMBER_TYPE MEMBERSHIP_PROGRAM_TYPE MEMBERSHIP_PROGRAM_TYPE	MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST NA NA	NO NO NO
AARMEMB_AMT_QUALIFY	NO	REPORTING VIEW	MEMBERSHIP	MEMBERSHIP_DUES_AMOUNT	NA	NO
AARMEMB_CARD_DATE	NO	REPORTING VIEW	MEMBERSHIP_INTEREST MEMBERSHIP	MEMBERSHIP_CARD_SENT_DATE MEMBERSHIP_CARD_SENT_DATE	NA NA	NO NO
AARMEMB_CARD_IND	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	MEMBERSHIP_CARD_IND MEMBERSHIP_CARD_IND	NA NA	NO NO
AARMEMB_DCAM_CODE	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	MEMBERSHIP_ASSIGNMENT MEMBERSHIP_ASSIGNMENT	NA NA	NO NO
AARMEMB_DURATION	NO	REPORTING VIEW	MEMBERSHIP_INTEREST MEMBERSHIP	MEMBERSHIP_DURATION MEMBERSHIP_DURATION	NA NA	NO NO
AARMEMB_ENTRY_DATE	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	ENTRY_DATE ENTRY_DATE	NA NA	NO NO
AARMEMB_EXP_DATE	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	EXPIRATION_DATE EXPIRATION_DATE	NA NA	NO NO
AARMEMB_MEMBERSHIP	NO	DIMENSION TABLE REPORTING VIEW	WDT_MEMBERSHIP MEMBERSHIP	MEMBERSHIP MEMBERSHIP_PROGRAM	MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST NA	NO NO
AARMEMB_MEMB_NAME	NO	REPORTING VIEW	MEMBERSHIP_INTEREST MEMBERSHIP	MEMBERSHIP_NAME MEMBERSHIP_NAME	NA NA	NO NO
AARMEMB_MEMB_NO	NO	REPORTING VIEW	MEMBERSHIP	MEMBERSHIP_NUMBER	NA	NO
AARMEMB_PIDM	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	ENTITY_UID ENTITY_UID	NA NA	NO NO
AARMEMB_RENEWAL_DATE	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	RENEWAL_DATE RENEWAL_DATE	NA NA	NO NO
AARMEMB_STATUS_OVERRIDE_IND	NO	REPORTING VIEW	MEMBERSHIP MEMBERSHIP_INTEREST	AUTO_STATUS_UPDATE_IND AUTO_STATUS_UPDATE_IND	NA NA	NO NO

Ver: 9.0