| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
FINAL_INSTALL_MONTH
|
Month the final installment is scheduled to be received. Calculated based on the PLEDGE_INSTALLMENT reporting view - INSTALLMENT_DATE that is the greatest and using the Year part of the date.
|
VARCHAR2(63)
|
PLEDGE
|
FUNCTION
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
FINAL_INSTALL_MONTH_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
FINAL_INSTALL_MONTH_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
FINAL_INSTALL_YEAR
|
Year the final installment is scheduled to be received. Calculated based on the PLEDGE_INSTALLMENT reporting view - INSTALLMENT_DATE that is the greatest and using the month part of the date.
|
VARCHAR2(63)
|
PLEDGE
|
FUNCTION
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
FINAL_INSTALL_YEAR_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
FINAL_INSTALL_YEAR_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
ORIGINAL_PLEDGE_RANGE
|
Determined by the rules defined and the original PLEDGE_AMOUNT.
|
VARCHAR2(63)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
ORIGINAL_PLEDGE_RANGE_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
ORIGINAL_PLEDGE_RANGE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
OUTSTANDING_PLEDGE_RANGE
|
Determined by the rules defined and the PLEDGE_BALANCE.
|
VARCHAR2(63)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
OUTSTANDING_PLEDGE_RANGE_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
OUTSTANDING_PLEDGE_RANGE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
EDW CLEANSING PROCESS
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_KEY
|
Key for the pledge dimension
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_TYPE
|
Specifies the type of pledge recorded.
|
VARCHAR2(63)
|
PLEDGE
|
PLEDGE_TYPE
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_TYPE_LD
|
Long description of the pledge type code.
|
VARCHAR2(255)
|
PLEDGE
|
PLEDGE_TYPE_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_TYPE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PLEDGE
|
PLEDGE_TYPE_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_VEHICLE
|
Pledge gift vehicle code associated with this pledge. This might be cash, property, vehicle, etc.
|
VARCHAR2(63)
|
PLEDGE
|
PLEDGE_VEHICLE
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_VEHICLE_LD
|
Long description of the pledge gift vehicle.
|
VARCHAR2(255)
|
PLEDGE
|
PLEDGE_VEHICLE_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
PLEDGE_VEHICLE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PLEDGE
|
PLEDGE_VEHICLE_DESC
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
ADVANCEMENT GIFT
|