| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACTIVE_MEMBER_STATUS
|
Active member status
|
VARCHAR2(63)
|
ATVAMST
|
ACTIVE_MEMBER_STATUS_EXPRESSION
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
ACTIVE_MEMBER_STATUS_LD
|
Active member status long description
|
VARCHAR2(255)
|
EXPRESSION
|
ACTIVE_MEMBER_STATUS_LD_EXPRESSION
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
ACTIVE_MEMBER_STATUS_SD
|
Active member status short description
|
VARCHAR2(255)
|
EXPRESSION
|
ACTIVE_MEMBER_STATUS_SD_EXPRESSION
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBERSHIP
|
Membership code ; in Banner Membership Program; Advance Membership Type
|
VARCHAR2(63)
|
AARMEMB
|
AARMEMB_MEMBERSHIP
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBERSHIP_KEY
|
|
NUMBER
|
|
|
|
NO
|
|
|
MEMBERSHIP_LD
|
Long description of membership
|
VARCHAR2(255)
|
AABMSHP
|
AABMSHP_NAME
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBERSHIP_SD
|
Short description of membership
|
VARCHAR2(255)
|
AABMSHP
|
AABMSHP_NAME
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBERSHIP_SOURCE
|
Membership source code
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBERSHIP_SOURCE_LD
|
Description of the source or area that 'owns' this membership.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBERSHIP_SOURCE_SD
|
Membership source short description
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_ASSOCIATON
|
Member association with other members on the membership account.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_ASSOCIATON_LD
|
Long description of member association.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_ASSOCIATON_SD
|
Short description of member association.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_CAMPAIGN
|
Campaign code associated with member
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_CAMPAIGN_LD
|
Campaign description associated with this member within a membership.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_CAMPAIGN_SD
|
Member Campaign short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_CATEGORY
|
Member category code.
|
VARCHAR2(63)
|
AARMEMB
|
AARMEMB_AMCT_CODE
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_CATEGORY_LD
|
Member category long description.
|
VARCHAR2(255)
|
ATVAMCT
|
ATVAMCT_DESC
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_CATEGORY_SD
|
Member category short description.
|
VARCHAR2(255)
|
ATVAMCT
|
ATVAMCT_DESC
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_PERIOD
|
Indicates the duration of the membership
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_PERIOD_LD
|
Description of the duration of the member within the membership
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_PERIOD_SD
|
Member short description
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MEMBER_STATUS
|
Member status for the individual.
|
VARCHAR2(63)
|
AARMEMB
|
AARMEMB_AMST_CODE
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_STATUS_LD
|
Member status description for the individual.
|
VARCHAR2(255)
|
ATVAMST
|
ATVAMST_DESC
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_STATUS_SD
|
Member status short description
|
VARCHAR2(255)
|
ATVAMST
|
ATVAMST_DESC
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_TYPE
|
Member type code.
|
VARCHAR2(63)
|
AARMEMB
|
AARMEMB_AMTP_CODE
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_TYPE_LD
|
Member type long description
|
VARCHAR2(255)
|
ATVAMTP
|
ATVAMTP_DESC
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
MEMBER_TYPE_SD
|
Member type short description.
|
VARCHAR2(255)
|
ATVAMTP
|
ATVAMTP_DESC
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
NEW_MEMBER_CODE
|
Membership code indicating new, renewal, reinstated.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
NEW_MEMBER_CODE_LD
|
Membership code long description
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
NEW_MEMBER_CODE_SD
|
Membership code short description
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'MEMBERSHIP_D1B'
|
NO
|
NO
|
MEMBERSHIP, MEMBERSHIP CLUB, MEMBERSHIP INTEREST
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_01
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_01_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_01_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_02
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_02_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_02_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_03
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_03_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_03_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_04
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_04_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_04_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_05
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_05_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_05_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|