RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: AARMEMB Advancement Composite View Reports
SGHE Operational Data Store Composite View Source: AARMEMB

Source Column Source Form Target Type Target Target Column Calculation Formula
AARMEMB_ACTIVITY_DATE AAAMINT COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_ACTIVITY_DATE

NA
AARMEMB_AMCT_CODE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_CATEGORY

NA
AARMEMB_AMST_CODE AAAMSHP COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_STATUS

NA
AARMEMB_AMST_DATE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_PROCESSED_DATE

NA
AARMEMB_AMTP_CODE AAAMSHP COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_PROGRAM_TYPE

NA
AARMEMB_AMT_QUALIFY AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_DUES_AMOUNT

NA
AARMEMB_CARD_DATE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_CARD_SENT_DATE

NA
AARMEMB_CARD_IND AAAMEMB       NA
AARMEMB_DCAM_CODE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_ASSIGNMENT

NA
AARMEMB_DURATION AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_DURATION

NA
AARMEMB_ENTRY_DATE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

ENTRY_DATE

NA
AARMEMB_EXP_DATE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

EXPIRATION_DATE

NA
AARMEMB_MEMBERSHIP AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_PROGRAM

NA
AARMEMB_MEMB_NAME AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_NAME

NA
AARMEMB_MEMB_NO AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

MEMBERSHIP_NUMBER

NA
AARMEMB_PIDM NA COMPOSITE VIEW

AA_MEMBERSHIP

ENTITY_UID

NA
AARMEMB_RENEWAL_DATE AAAMEMB COMPOSITE VIEW

AA_MEMBERSHIP

RENEWAL_DATE

NA
AARMEMB_STATUS_OVERRIDE_IND AAAMEMB       NA


Ver: 3.1