• • Model View
    
• Table AABDUES
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for AABDUES_PAYOR_PIDM (# 1)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_TRANS_NO (# 2)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_MEMBERSHIP (# 3)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_AMOUNT_TOT (# 4)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_GIFT_CODE (# 5)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_DUES_DATE (# 6)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_FISC_CODE (# 7)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_ACTIVITY_DATE (# 8)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_ENTRY_DATE (# 9)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_USER (# 10)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_FINAL_IND (# 11)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_ADJ_IND (# 12)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_GIFT_DESC (# 13)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_ACKN_IND (# 14)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_ACKN_DATE (# 15)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_RECPT_IND (# 16)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_RECPT_DATE (# 17)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_CARD_NO (# 18)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_CARD_EXP_DATE (# 19)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_SESSION_NUMBER (# 20)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_FEED_IND (# 21)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_FEED_DATE (# 22)
    
    • Source Code Comments
      
  • Columns Comments for AABDUES_FEED_DOC_CODE (# 23)
    
    • Source Code Comments
      
• Table AARDUES
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for AARDUES_PIDM (# 1)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_PAYOR_PIDM (# 2)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_TRANS_NO (# 3)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_MEMBERSHIP (# 4)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_MEMB_NO (# 5)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_AMCT_CODE (# 6)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_AMOUNT (# 7)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_ACTIVITY_DATE (# 8)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_AMPM_CODE (# 9)
    
    • Source Code Comments
      
  • Columns Comments for AARDUES_COMMENT (# 10)
    
    • Source Code Comments
      
• Table AARMEMB
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for AARMEMB_PIDM (# 1)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_MEMBERSHIP (# 2)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_MEMB_NO (# 3)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_LETR_CODE (# 4)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_AMCT_CODE (# 5)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_AMTP_CODE (# 6)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_ENTRY_DATE (# 7)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_AMST_CODE (# 8)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_AMST_DATE (# 9)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_ACTIVITY_DATE (# 10)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_REMINDER_PIDM (# 11)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_ATYP_CODE_REM (# 12)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_RENEWAL_PIDM (# 13)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_RENEWAL_DATE (# 14)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_ATYP_CODE_REN (# 15)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_DCAM_CODE (# 16)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_DURATION (# 17)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_RULE_NO (# 18)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_CARD_IND (# 19)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_CARD_DATE (# 20)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_GRACE_PERIOD (# 21)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_AMT_QUALIFY (# 22)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_EXP_DATE (# 23)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_MEMB_NAME (# 24)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_LETR_CODE_RENEW (# 25)
    
    • Source Code Comments
      
  • Columns Comments for AARMEMB_STATUS_OVERRIDE_IND (# 26)
    
    • Source Code Comments
      
• Table AARMINT
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for AARMINT_PIDM (# 1)
    
    • Source Code Comments
      
  • Columns Comments for AARMINT_MEMBERSHIP (# 2)
    
    • Source Code Comments
      
  • Columns Comments for AARMINT_MEMB_NO (# 3)
    
    • Source Code Comments
      
  • Columns Comments for AARMINT_INTEREST (# 4)
    
    • Source Code Comments
      
  • Columns Comments for AARMINT_TRANS_NO (# 5)
    
    • Source Code Comments
      
  • Columns Comments for AARMINT_AMOUNT (# 6)
    
    • Source Code Comments
      
  • Columns Comments for AARMINT_ACTIVITY_DATE (# 7)
    
    • Source Code Comments
      
• Table ATVAMCT
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for ATVAMCT_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for ATVAMCT_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for ATVAMCT_ACTIVITY_DATE (# 3)
    
    • Source Code Comments
      
  • Columns Comments for ATVAMCT_LIFETIME_IND (# 4)
    
    • Source Code Comments
      
• Table ATVFISC
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for ATVFISC_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for ATVFISC_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for ATVFISC_START_DATE (# 3)
    
    • Source Code Comments
      
  • Columns Comments for ATVFISC_END_DATE (# 4)
    
    • Source Code Comments
      
  • Columns Comments for ATVFISC_ACTIVITY_DATE (# 5)
    
    • Source Code Comments
      
• Table ATVGIFT
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for ATVGIFT_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_CREDIT_CARD_IND (# 3)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_MATCH_IND (# 4)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_CFAE_GIFT_CATG (# 5)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_GIFT_GROUP (# 6)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_GIFT_GROUP_DESC (# 7)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_ACTIVITY_DATE (# 8)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_RUCL_CODE (# 9)
    
    • Source Code Comments
      
  • Columns Comments for ATVGIFT_DB_GL_ACCT (# 10)
    
    • Source Code Comments
      
• Link between AARDUES and AARMINT
  
  • Join Information
    
• Link between AARMEMB and ATVAMCT
  
• Link between AABDUES and ATVFISC
  
• Link between AABDUES and ATVGIFT
  
• Link between AARMINT and AARMEMB
  
• Link between AARDUES and AABDUES
  
• Link between AARDUES and ATVAMCT