| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
CREDIT_CARD_PAYMENT_IND
|
Determines whether the gift payment was made with a credit card.
|
NUMBER
|
EXPRESSION
|
CREDIT_CARD_PAYMENT_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
CREDIT_CARD_PAYMENT_IND_LD
|
Credit card payment indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
CREDIT_CARD_PAYMENT_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
CREDIT_CARD_PAYMENT_IND_SD
|
Credit card payment indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
CREDIT_CARD_PAYMENT_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ACKNOWLEDGED_IND
|
Determines whether the gift was acknowledged.
|
NUMBER
|
EXPRESSION
|
GIFT_ACKNOWLEDGED_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ACKNOWLEDGED_IND_LD
|
Gift acknowledged indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_ACKNOWLEDGED_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ACKNOWLEDGED_IND_SD
|
Gift acknowledged indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_ACKNOWLEDGED_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ADJUSTED_IND
|
Determines whether the gift was adjusted.
|
NUMBER
|
EXPRESSION
|
GIFT_ADJUSTED_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ADJUSTED_IND_LD
|
Gift adjusted indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_ADJUSTED_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ADJUSTED_IND_SD
|
Gift adjusted indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_ADJUSTED_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ANONYMOUS_IND
|
Determines whether the gift was anonymous.
|
NUMBER
|
EXPRESSION
|
GIFT_ANONYMOUS_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ANONYMOUS_IND_LD
|
Gift anonymous indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_ANONYMOUS_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_ANONYMOUS_IND_SD
|
Gift anonymous indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_ANONYMOUS_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CAE_TYPE
|
Predefined code describing the purpose for giving as defined for Voluntary Support of Education (VSE) reporting.
|
VARCHAR2(63)
|
ATVGIFT
|
ATVGIFT_CFAE_GIFT_CATG
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CAE_TYPE_LD
|
Gift type for Voluntary Support of Education reporting long description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_CAE_TYPE_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CAE_TYPE_SD
|
Gift type for Voluntary Support of Education reporting short description.
|
VARCHAR2(255)
|
EXPRESSION
|
GIFT_CAE_TYPE_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_1
|
First gift classification such as anonymous, memorial, etc..
|
VARCHAR2(63)
|
AGBGIFT_1
|
AGBGIFT_GCLS_CODE
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_1_LD
|
First gift classification long description.
|
VARCHAR2(255)
|
ATVGCLS
|
ATVGCLS_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_1_SD
|
First gift classification short description.
|
VARCHAR2(255)
|
ATVGCLS
|
ATVGCLS_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_2
|
Second gift classification.
|
VARCHAR2(63)
|
AGBGIFT_1
|
AGBGIFT_GCLS_CODE_2
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_2_LD
|
Second gift classification long description.
|
VARCHAR2(255)
|
ATVGCLS
|
ATVGCLS_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_2_SD
|
Second gift classification short description.
|
VARCHAR2(255)
|
ATVGCLS
|
ATVGCLS_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_3
|
Third gift classification.
|
VARCHAR2(63)
|
AGBGIFT_1
|
AGBGIFT_GCLS_CODE_3
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_3_LD
|
Third gift classification long description.
|
VARCHAR2(255)
|
ATVGCLS
|
ATVGCLS_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_CLASS_3_SD
|
Third gift classification short description.
|
VARCHAR2(255)
|
ATVGCLS
|
ATVGCLS_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_EXCLUDE_IND
|
Determines whether to exclude the gift amounts in total giving.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
GIFT_EXCLUDE_IND_LD
|
Gift exclude indicator long description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
GIFT_EXCLUDE_IND_SD
|
Gift exclude indicator short description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
GIFT_KEY
|
System generated, unique, internal primary key for a gift.
|
NUMBER
|
|
|
|
NO
|
|
|
GIFT_PAYMENT_CAE_TYPE
|
Predefined code describing the type of gift payment as defined for Voluntary Support of Education (VSE) reporting.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_CAE_TYPE_LD
|
Long description for the gift payment type used for Voluntary Support of Education reporting.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_CAE_TYPE_SD
|
Gift payment type Voluntary Support of Education short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_EFT_TYPE
|
Gift payment electronic funds transfer type.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_EFT_TYPE_LD
|
Gift payment electronic funds transfer type long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_EFT_TYPE_SD
|
Gift payment electronic funds transfer type short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_TENDER
|
Gift type of payment.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_TENDER_LD
|
Gift payment tender long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_TENDER_SD
|
Gift payment tender short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_TYPE
|
Type of gift payment.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_TYPE_LD
|
Long description for the gift payment type.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_PAYMENT_TYPE_SD
|
Short description for the gift payment type.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
GIFT_TYPE
|
Gift vehicle for example in honor of, In memory of, anonymous.
|
VARCHAR2(63)
|
AGBGIFT_1
|
AGBGIFT_GIFT_CODE
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
GIFT_TYPE_LD
|
Long description for the type of gift.
|
VARCHAR2(255)
|
ATVGIFT
|
ATVGIFT_DESC
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
GIFT_TYPE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ATVGIFT
|
ATVGIFT_DESC
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
MATCH_CLAIM_EXISTS_IND
|
Determines whether a match claim exists for this gift.
|
NUMBER
|
EXPRESSION
|
MATCH_CLAIM_EXISTS_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
MATCH_CLAIM_EXISTS_IND_LD
|
Match claim exists indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
MATCH_CLAIM_EXISTS_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
MATCH_CLAIM_EXISTS_IND_SD
|
Match claim exists indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
MATCH_CLAIM_EXISTS_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
MATCH_GIFT_EXISTS_IND
|
Determines whether a match gift exists for this gift.
|
NUMBER
|
EXPRESSION
|
MATCH_GIFT_EXISTS_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
MATCH_GIFT_EXISTS_IND_LD
|
Match gift exists indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
MATCH_GIFT_EXISTS_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
MATCH_GIFT_EXISTS_IND_SD
|
Match gift exists indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
MATCH_GIFT_EXISTS_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
REALIZED_BEQUEST_IND
|
Determines whether the gift was a realized bequest.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
REALIZED_BEQUEST_IND_LD
|
Realized bequest indicator long description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
REALIZED_BEQUEST_IND_SD
|
Realized bequest indicator short description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
RECEIPT_REQUIRED_IND
|
Determines whether the gift receipt was required.
|
NUMBER
|
EXPRESSION
|
RECEIPT_REQUIRED_IND_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
RECEIPT_REQUIRED_IND_LD
|
Receipt required indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
RECEIPT_REQUIRED_IND_LD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
RECEIPT_REQUIRED_IND_SD
|
Receipt required indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
RECEIPT_REQUIRED_IND_SD_EXPRESSION
|
NO
|
NO
|
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, GIFT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'GIFT_D1B'
|
NO
|
NO
|
ANALYZE FUNDRAISING, GIFT
|
|
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
|
|