| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
EXPECTANCY_IND
|
Determines whether this transaction is counted in the total expectancy totals in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
EXPECTANCY_IND_LD
|
Expectancy indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
EXPECTANCY_IND_SD
|
Expectancy indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
GIFT_IND
|
Determines whether this transaction is totaled as a gift for campaign totals.
|
NUMBER
|
|
|
|
NO
|
|
|
GIFT_IND_LD
|
Gift indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
GIFT_IND_SD
|
Gift indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
GIFT_IN_KIND_IND
|
Determines whether this transaction is counted in the gift-in-kind totals in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
GIFT_IN_KIND_IND_LD
|
Gift-in-kind indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
GIFT_IN_KIND_IND_SD
|
Gift-in-kind indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
GIFT_REPORTING_INDICATOR_KEY
|
|
NUMBER
|
|
|
|
NO
|
|
|
IGNORE_TRANSACTION_IND
|
Indicates this transaction should be ignored for Advance only.
|
NUMBER
|
|
|
|
NO
|
|
|
IGNORE_TRANSACTION_IND_LD
|
Ignore transaction indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
IGNORE_TRANSACTION_IND_SD
|
Ignore transaction indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
LIFE_INCOME_IND
|
Determines whether this transaction is counted in the life income totals in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
LIFE_INCOME_IND_LD
|
Life income indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
LIFE_INCOME_IND_SD
|
Life income indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
MATCH_IND
|
Determines whether this transaction is counted in the matching gift totals in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
MATCH_IND_LD
|
Match indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
MATCH_IND_SD
|
Match indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
OUTSIDE_TRUST_IND
|
Determines whether this transaction is counted in the outside trust totals in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
OUTSIDE_TRUST_IND_LD
|
Outside trust indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
OUTSIDE_TRUST_IND_SD
|
Outside trust indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
PAYMENT_EXCEPTION_IND
|
Determines whether this transaction is an exception, or credited to a different campaign than the pledge that originally created it. Then it is counted as a payment exception in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
PAYMENT_EXCEPTION_IND_LD
|
Payment exception indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
PAYMENT_EXCEPTION_IND_SD
|
Payment exception indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
PLEDGE_IND
|
Determines whether the transaction is counted as a pledge total in the campaign reports
|
NUMBER
|
|
|
|
NO
|
|
|
PLEDGE_IND_LD
|
Pledge indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
PLEDGE_IND_SD
|
Pledge indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
REALIZED_EXPECTANCY_IND
|
Determines whether this transaction is counted in the realized expectancy totals in campaign gift reports.
|
NUMBER
|
|
|
|
NO
|
|
|
REALIZED_EXPECTANCY_IND_LD
|
Realized expectancy long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
REALIZED_EXPECTANCY_IND_SD
|
Realized expectancy short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
|
|
|
NO
|
|
|
TOTAL_IND
|
Determines whether this transaction is included in campaign totals
|
NUMBER
|
|
|
|
NO
|
|
|
TOTAL_IND_LD
|
Total indicator long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
TOTAL_IND_SD
|
Total indicator short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_01
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_01_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_01_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_02
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_02_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_02_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_03
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_03_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_03_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_04
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_04_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_04_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_05
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_05_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_05_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|