| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
GIFT_SOCIETY
|
The gift society code.
|
VARCHAR2(63)
|
APRDCLB
|
APRDCLB_DCNP_CODE
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_ASSIGN_AUTHRZD
|
Code representing the person who authorized the assignment of the gift society.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_ASSIGN_AUTHRZD_LD
|
Long description for gift society authorization.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_ASSIGN_AUTHRZD_SD
|
Short description for gift society authorization.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_ASSIGN_METHOD
|
Code value indicating how the member was added to the gift society.
|
VARCHAR2(63)
|
APRDCLB
|
APRDCLB_DCAM_CODE
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_ASSIGN_METHOD_LD
|
Long description for gift society assignment method.
|
VARCHAR2(255)
|
ATVDCAM
|
ATVDCAM_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_ASSIGN_METHOD_SD
|
Short description for gift society assignment method.
|
VARCHAR2(255)
|
ATVDCAM
|
ATVDCAM_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_CATEGORY
|
The category of the gift society.
|
VARCHAR2(63)
|
ATVDCNP
|
ATVDCNP_CODE
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_CATEGORY_LD
|
Gift society category long description
|
VARCHAR2(255)
|
ATVDCNP
|
ATVDCNP_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_CATEGORY_SD
|
Gift society category short description
|
VARCHAR2(255)
|
ATVDCNP
|
ATVDCNP_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_COLLEGE
|
The college code associated with a gift society membership
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_COLLEGE_LD
|
Long description for the college associated with a gift society membership
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_COLLEGE_SD
|
Short description for the college associated with a gift society membership
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_FAMILY
|
Designates a group of like or similar gift societies.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_FAMILY_LD
|
Gift society family long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_FAMILY_SD
|
Gift society family short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_KEY
|
|
NUMBER
|
|
|
|
NO
|
|
|
GIFT_SOCIETY_LD
|
Long description of gift society
|
VARCHAR2(255)
|
ATVDCNP
|
ATVDCNP_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_MEMBER_STATUS
|
Status of gift society member.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_MEMBER_STATUS_LD
|
Long Description of gift society member status
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_MEMBER_STATUS_SD
|
Short description of gift society member status
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_OWNER_GROUP
|
Indicates the group that owns this gift society.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_OWNER_GROUP_LD
|
Long description of the group that owns this gift society
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_OWNER_GROUP_SD
|
Short description of the group that owns this gift society
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_SOCIETY_SD
|
Short description of gift society
|
VARCHAR2(255)
|
ATVDCNP
|
ATVDCNP_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_TYPE
|
The society type code, used to group gift societies.
|
VARCHAR2(63)
|
ATVDCST
|
ATVDCST_CODE
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_TYPE_LD
|
Long description for the society type code
|
VARCHAR2(255)
|
ATVDCST
|
ATVDCST_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_TYPE_PRI_NUMBER
|
The unique society type priority numeric indicator for the gift society. The lowest number is the highest priority.
|
NUMBER
|
ATVDCST
|
ATVDCST_PRI_IND
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
GIFT_SOCIETY_TYPE_SD
|
Short description for the society type code
|
VARCHAR2(255)
|
ATVDCST
|
ATVDCST_DESC
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'GIFT_SOCIETY_D1B'
|
NO
|
NO
|
GIFT SOCIETY, GIFT SOCIETY PREMIUM
|
|
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
|
|