Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
DATE_HIGHEST_GIFT_YEAR_1
|
This is the date of the highest gift amount for year 1
|
DATE
|
|
|
DATE_HIGHEST_GIFT_YEAR_2
|
This is the date of the highest gift amount for year 2
|
DATE
|
|
|
DATE_HIGHEST_GIFT_YEAR_3
|
This is the date of the highest gift amount for year 3
|
DATE
|
|
|
DATE_HIGHEST_GIFT_YEAR_4
|
This is the date of the highest gift amount for year 4
|
DATE
|
|
|
DATE_HIGHEST_GIFT_YEAR_5
|
This is the date of the highest gift amount for year 5
|
DATE
|
|
|
DATE_HIGHEST_GIFT_YEAR_6
|
This is the date of the highest gift amount for year 6
|
DATE
|
|
|
DCNP_CODE_1_1
|
This is the gift society code 1 for year 1
|
VARCHAR2(4)
|
|
|
DCNP_CODE_1_2
|
This is the gift society code 1 for year 2
|
VARCHAR2(4)
|
|
|
DCNP_CODE_1_3
|
This is the gift society code 1 for year 3
|
VARCHAR2(4)
|
|
|
DCNP_CODE_1_4
|
This is the gift society code 1 for year 4
|
VARCHAR2(4)
|
|
|
DCNP_CODE_1_5
|
This is the gift society code 1 for year 5
|
VARCHAR2(4)
|
|
|
DCNP_CODE_1_6
|
This is the gift society code 1 for year 6
|
VARCHAR2(4)
|
|
|
DCNP_CODE_2_1
|
This is the gift society code 2 for year 1
|
VARCHAR2(4)
|
|
|
DCNP_CODE_2_2
|
This is the gift society code 2 for year 2
|
VARCHAR2(4)
|
|
|
DCNP_CODE_2_3
|
This is the gift society code 2 for year 3
|
VARCHAR2(4)
|
|
|
DCNP_CODE_2_4
|
This is the gift society code 2 for year 4
|
VARCHAR2(4)
|
|
|
DCNP_CODE_2_5
|
This is the gift society code 2 for year 5
|
VARCHAR2(4)
|
|
|
DCNP_CODE_2_6
|
This is the gift society code 2 for year 6
|
VARCHAR2(4)
|
|
|
DCNP_DESC_1_1
|
This is the description of gift society code 1 for year 1
|
VARCHAR2(30)
|
|
|
DCNP_DESC_1_2
|
This is the description of gift society code 1 for year 2
|
VARCHAR2(30)
|
|
|
DCNP_DESC_1_3
|
This is the description of gift society code 1 for year 3
|
VARCHAR2(30)
|
|
|
DCNP_DESC_1_4
|
This is the description of gift society code 1 for year 4
|
VARCHAR2(30)
|
|
|
DCNP_DESC_1_5
|
This is the description of gift society code 1 for year 5
|
VARCHAR2(30)
|
|
|
DCNP_DESC_1_6
|
This is the description of gift society code 1 for year 6
|
VARCHAR2(30)
|
|
|
DCNP_DESC_2_1
|
This is the description of gift society code 2 for year 1
|
VARCHAR2(30)
|
|
|
DCNP_DESC_2_2
|
This is the description of gift society code 2 for year 2
|
VARCHAR2(30)
|
|
|
DCNP_DESC_2_3
|
This is the description of gift society code 2 for year 3
|
VARCHAR2(30)
|
|
|
DCNP_DESC_2_4
|
This is the description of gift society code 2 for year 4
|
VARCHAR2(30)
|
|
|
DCNP_DESC_2_5
|
This is the description of gift society code 2 for year 5
|
VARCHAR2(30)
|
|
|
DCNP_DESC_2_6
|
This is the description of gift society code 2 for year 6
|
VARCHAR2(30)
|
|
|
DCST_CODE_1_1
|
This is the gift society type code 1 for year 1
|
VARCHAR2(2)
|
|
|
DCST_CODE_1_2
|
This is the gift society type code 1 for year 2
|
VARCHAR2(2)
|
|
|
DCST_CODE_1_3
|
This is the gift society type code 1 for year 3
|
VARCHAR2(2)
|
|
|
DCST_CODE_1_4
|
This is the gift society type code 1 for year 4
|
VARCHAR2(2)
|
|
|
DCST_CODE_1_5
|
This is the gift society type code 1 for year 5
|
VARCHAR2(2)
|
|
|
DCST_CODE_1_6
|
This is the gift society type code 1 for year 6
|
VARCHAR2(2)
|
|
|
DCST_CODE_2_1
|
This is the gift society type code 2 for year 1
|
VARCHAR2(2)
|
|
|
DCST_CODE_2_2
|
This is the gift society type code 2 for year 2
|
VARCHAR2(2)
|
|
|
DCST_CODE_2_3
|
This is the gift society type code 2 for year 3
|
VARCHAR2(2)
|
|
|
DCST_CODE_2_4
|
This is the gift society type code 2 for year 4
|
VARCHAR2(2)
|
|
|
DCST_CODE_2_5
|
This is the gift society type code 2 for year 5
|
VARCHAR2(2)
|
|
|
DCST_CODE_2_6
|
This is the gift society type code 2 for year 6
|
VARCHAR2(2)
|
|
|
DCST_DESC_1_1
|
This is the description of gift society type code 1 for year 1
|
VARCHAR2(30)
|
|
|
DCST_DESC_1_2
|
This is the description of gift society type code 1 for year 2
|
VARCHAR2(30)
|
|
|
DCST_DESC_1_3
|
This is the description of gift society type code 1 for year 3
|
VARCHAR2(30)
|
|
|
DCST_DESC_1_4
|
This is the description of gift society type code 1 for year 4
|
VARCHAR2(30)
|
|
|
DCST_DESC_1_5
|
This is the description of gift society type code 1 for year 5
|
VARCHAR2(30)
|
|
|
DCST_DESC_1_6
|
This is the description of gift society type code 1 for year 6
|
VARCHAR2(30)
|
|
|
DCST_DESC_2_1
|
This is the description of gift society type code 2 for year 1
|
VARCHAR2(30)
|
|
|
DCST_DESC_2_2
|
This is the description of gift society type code 2 for year 2
|
VARCHAR2(30)
|
|
|
DCST_DESC_2_3
|
This is the description of gift society type code 2 for year 3
|
VARCHAR2(30)
|
|
|
DCST_DESC_2_4
|
This is the description of gift society type code 2 for year 4
|
VARCHAR2(30)
|
|
|
DCST_DESC_2_5
|
This is the description of gift society type code 2 for year 5
|
VARCHAR2(30)
|
|
|
DCST_DESC_2_6
|
This is the description of gift society type code 2 for year 6
|
VARCHAR2(30)
|
|
|
DONOR_ADD_DONOR_CAT_FLAG
|
This is the additional donor categories flag indicator
|
VARCHAR2(1)
|
|
|
DONOR_BIRTH_MAIDEN_NAME
|
This is the donor birth/maiden last name
|
VARCHAR2(25)
|
|
|
DONOR_COMBINED_MAIL_NAME
|
This is the donor combined mail name
|
VARCHAR2(50)
|
|
|
DONOR_DECEASED_DATE
|
This is the donor deceased date
|
DATE
|
|
|
DONOR_DECEASED_IND
|
This is the donor deceased indicator
|
VARCHAR2(1)
|
|
|
DONOR_ENTITY_IND
|
This is the entity indicator
|
VARCHAR2(1)
|
|
|
DONOR_FIRST_NAME
|
This is the donor first name
|
VARCHAR2(15)
|
|
|
DONOR_ID
|
This is the donor ID number
|
VARCHAR2(9)
|
|
|
DONOR_LAST_NAME
|
This is the donor last name
|
VARCHAR2(60)
|
|
|
DONOR_MIDDLE_INITIAL
|
This is the donor middle initial
|
VARCHAR2(1)
|
|
|
DONOR_MIDDLE_NAME
|
This is the donor middle name
|
VARCHAR2(15)
|
|
|
DONOR_NAME_PREFIX
|
This is the donor name prefix
|
VARCHAR2(20)
|
|
|
DONOR_NAME_SUFFIX
|
This is the donor name suffix
|
VARCHAR2(20)
|
|
|
DONOR_NICK_NAME
|
This is the donor nick name
|
VARCHAR2(40)
|
|
|
DONOR_OTHER_ALUM_IND_1
|
This is the donor other alumni indicator 1
|
VARCHAR2(1)
|
|
|
DONOR_OTHER_ALUM_IND_2
|
This is the donor other alumni indicator 2
|
VARCHAR2(1)
|
|
|
DONOR_OTHER_ALUM_IND_3
|
This is the donor other alumni indicator 3
|
VARCHAR2(1)
|
|
|
DONOR_OTHER_DONR_CODE_1
|
This is the donor other donor code 1
|
VARCHAR2(4)
|
|
|
DONOR_OTHER_DONR_CODE_2
|
This is the donor other donor code 2
|
VARCHAR2(4)
|
|
|
DONOR_OTHER_DONR_CODE_3
|
This is the donor other donor code 3
|
VARCHAR2(4)
|
|
|
DONOR_OTHER_DONR_DESC_1
|
This is the description of donor other donor code 1
|
VARCHAR2(30)
|
|
|
DONOR_OTHER_DONR_DESC_2
|
This is the description of donor other donor code 2
|
VARCHAR2(30)
|
|
|
DONOR_OTHER_DONR_DESC_3
|
This is the description of donor other donor code 3
|
VARCHAR2(30)
|
|
|
DONOR_PREF_ADDRESS_NAME
|
This is the donor preferred address name
|
VARCHAR2(35)
|
|
|
DONOR_PREF_ADDRESS_TYPE
|
This is the donor preferred address type code
|
VARCHAR2(2)
|
|
|
DONOR_PREF_ALUM_IND
|
This is the preferred donor alumni indicator
|
VARCHAR2(1)
|
|
|
DONOR_PREF_CLASS
|
This is the donor preferred class year
|
VARCHAR2(4)
|
|
|
DONOR_PREF_COLL
|
This is the donor preferred college code
|
VARCHAR2(2)
|
|
|
DONOR_PREF_DONR_CODE
|
This is the donor preferred donor code
|
VARCHAR2(4)
|
|
|
DONOR_PREF_DONR_DESC
|
This is the description of the donor preferred donor code
|
VARCHAR2(30)
|
|
|
DONOR_SSN
|
This is the donor social security number
|
VARCHAR2(9)
|
|
|
FISC_CODE_1
|
This is the fiscal year code 1
|
NUMBER
|
|
|
FISC_CODE_2
|
This is the fiscal year code 2
|
NUMBER
|
|
|
FISC_CODE_3
|
This is the fiscal year code 3
|
NUMBER
|
|
|
FISC_CODE_4
|
This is the fiscal year code 4
|
NUMBER
|
|
|
FISC_CODE_5
|
This is the fiscal year code 5
|
NUMBER
|
|
|
FISC_CODE_6
|
This is the fiscal year code 6
|
NUMBER
|
|
|
HIGHEST_GIFT_YEAR_1
|
This is the highest gift amount for year 1
|
NUMBER
|
|
|
HIGHEST_GIFT_YEAR_2
|
This is the highest gift amount for year 2
|
NUMBER
|
|
|
HIGHEST_GIFT_YEAR_3
|
This is the highest gift amount for year 3
|
NUMBER
|
|
|
HIGHEST_GIFT_YEAR_4
|
This is the highest gift amount for year 4
|
NUMBER
|
|
|
HIGHEST_GIFT_YEAR_5
|
This is the highest gift amount for year 5
|
NUMBER
|
|
|
HIGHEST_GIFT_YEAR_6
|
This is the highest gift amount for year 6
|
NUMBER
|
|
|
HIGHEST_PLEDGE_AMT_YEAR_1
|
This is the highest pledge amount for year 1
|
NUMBER
|
|
|
HIGHEST_PLEDGE_AMT_YEAR_2
|
This is the highest pledge amount for year 2
|
NUMBER
|
|
|
HIGHEST_PLEDGE_AMT_YEAR_3
|
This is the highest pledge amount for year 3
|
NUMBER
|
|
|
HIGHEST_PLEDGE_AMT_YEAR_4
|
This is the highest pledge amount for year 4
|
NUMBER
|
|
|
HIGHEST_PLEDGE_AMT_YEAR_5
|
This is the highest pledge amount for year 5
|
NUMBER
|
|
|
HIGHEST_PLEDGE_AMT_YEAR_6
|
This is the highest pledge amount for year 6
|
NUMBER
|
|
|
LIFE_DCNP_CODE
|
This is the lifetime gift society code
|
VARCHAR2(4)
|
|
|
LIFE_DCNP_DESC
|
This is the description of the lifetime gift society code
|
VARCHAR2(30)
|
|
|
LIFE_DCST_CODE
|
This is the lifetime gift society type code
|
VARCHAR2(2)
|
|
|
LIFE_DCST_DESC
|
This is the description of the lifetime gift society type code
|
VARCHAR2(30)
|
|
|
LIFE_TOTAL_COMMITMENT
|
This is the lifetime total commitments
|
NUMBER
|
|
|
LIFE_TOTAL_GIVING
|
This is the lifetime total giving
|
NUMBER
|
|
|
LIFE_TOTAL_PLEDGE_AMT
|
This is the lifetime total pledged amount
|
NUMBER
|
|
|
LIFE_TOTAL_PLEDGE_PAY
|
This is the lifetime total pledge payments
|
NUMBER
|
|
|
MOST_RECENT_GIFT_AMT
|
This is the most recent gift amount
|
NUMBER
|
|
|
MOST_RECENT_GIFT_DATE
|
This is the most recent gift date
|
DATE
|
|
|
MOST_RECENT_PLEDGE_AMT
|
This is the most recent pledge amount
|
NUMBER
|
|
|
MOST_RECENT_PLEDGE_DATE
|
This is the most recent pledge date
|
DATE
|
|
|
NUMBER_GIFT_YEAR_1
|
This is the number of gifts for year 1
|
NUMBER
|
|
|
NUMBER_GIFT_YEAR_2
|
This is the number of gifts for year 2
|
NUMBER
|
|
|
NUMBER_GIFT_YEAR_3
|
This is the number of gifts for year 3
|
NUMBER
|
|
|
NUMBER_GIFT_YEAR_4
|
This is the number of gifts for year 4
|
NUMBER
|
|
|
NUMBER_GIFT_YEAR_5
|
This is the number of gifts for year 5
|
NUMBER
|
|
|
NUMBER_GIFT_YEAR_6
|
This is the number of gifts for year 6
|
NUMBER
|
|
|
NUMBER_PLEDGE_YEAR_1
|
This is the number of the pledges for year 1
|
NUMBER
|
|
|
NUMBER_PLEDGE_YEAR_2
|
This is the number of the pledges for year 2
|
NUMBER
|
|
|
NUMBER_PLEDGE_YEAR_3
|
This is the number of the pledges for year 3
|
NUMBER
|
|
|
NUMBER_PLEDGE_YEAR_4
|
This is the number of the pledges for year 4
|
NUMBER
|
|
|
NUMBER_PLEDGE_YEAR_5
|
This is the number of the pledges for year 5
|
NUMBER
|
|
|
NUMBER_PLEDGE_YEAR_6
|
This is the number of the pledges for year 6
|
NUMBER
|
|
|
PIDM_KEY
|
This is the personal ID master number
|
NUMBER(8)
|
|
|
SPOUSE_BIRTH_MAIDEN_NAME
|
This is the birth/maiden last name of spouse
|
VARCHAR2(60)
|
|
|
SPOUSE_CLASS_YEAR
|
This is the preferred class year of spouse
|
VARCHAR2(4)
|
|
|
SPOUSE_DECEASED_DATE
|
This is the deceased date of spouse
|
DATE
|
|
|
SPOUSE_DECEASED_IND
|
This is the deceased indicator of spouse
|
VARCHAR2(1)
|
|
|
SPOUSE_FIRST_NAME
|
This is the first name of spouse
|
VARCHAR2(15)
|
|
|
SPOUSE_ID
|
This is the ID of spouse
|
VARCHAR2(9)
|
|
|
SPOUSE_IND
|
This is the marital status indicator of spouse
|
VARCHAR2(1)
|
|
|
SPOUSE_LAST_NAME
|
This is the last name of spouse
|
VARCHAR2(60)
|
|
|
SPOUSE_LOST_ALUMNUS_IND
|
This is the lost alumnus indicator of spouse
|
VARCHAR2(1)
|
|
|
SPOUSE_NAME_PREFIX
|
This is the name prefix of spouse
|
VARCHAR2(20)
|
|
|
SPOUSE_NAME_SUFFIX
|
This is the name suffix of spouse
|
VARCHAR2(20)
|
|
|
SPOUSE_PIDM
|
This is the personal ID master number of spouse
|
NUMBER
|
|
|
SPOUSE_PREF_COLL
|
This is the preferred college code of spouse
|
VARCHAR2(2)
|
|
|
SPOUSE_PREF_DONR_CODE
|
This is the preferred donor code of spouse
|
VARCHAR2(4)
|
|
|
SPOUSE_PREF_DONR_DESC
|
This is the description of preferred donor code of spouse
|
VARCHAR2(30)
|
|
|
TOTAL_ANT_MATCH_GIFT_ONE_TIM_1
|
This is the total anticipated matching gifts for one time payments for year 1
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_ONE_TIM_2
|
This is the total anticipated matching gifts for one time payments for year 2
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_ONE_TIM_3
|
This is the total anticipated matching gifts for one time payments for year 3
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_ONE_TIM_4
|
This is the total anticipated matching gifts for one time payments for year 4
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_ONE_TIM_5
|
This is the total anticipated matching gifts for one time payments for year 5
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_ONE_TIM_6
|
This is the total anticipated matching gifts for one time payments for year 6
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_PAY_1
|
This is the total anticipated matching gifts for payments for year 1
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_PAY_2
|
This is the total anticipated matching gifts for payments for year 2
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_PAY_3
|
This is the total anticipated matching gifts for payments for year 3
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_PAY_4
|
This is the total anticipated matching gifts for payments for year 4
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_PAY_5
|
This is the total anticipated matching gifts for payments for year 5
|
NUMBER
|
|
|
TOTAL_ANT_MATCH_GIFT_PAY_6
|
This is the total anticipated matching gifts for payments for year 6
|
NUMBER
|
|
|
TOTAL_GIVING_YEAR_1
|
This is the total giving for year 1
|
NUMBER
|
|
|
TOTAL_GIVING_YEAR_2
|
This is the total giving for year 2
|
NUMBER
|
|
|
TOTAL_GIVING_YEAR_3
|
This is the total giving for year 3
|
NUMBER
|
|
|
TOTAL_GIVING_YEAR_4
|
This is the total giving for year 4
|
NUMBER
|
|
|
TOTAL_GIVING_YEAR_5
|
This is the total giving for year 5
|
NUMBER
|
|
|
TOTAL_GIVING_YEAR_6
|
This is the total giving for year 6
|
NUMBER
|
|
|
TOTAL_NON_MATCH_GIFT_MEMO_1
|
This is the non-matching gift memo total for year 1
|
NUMBER
|
|
|
TOTAL_NON_MATCH_GIFT_MEMO_2
|
This is the non-matching gift memo total for year 2
|
NUMBER
|
|
|
TOTAL_NON_MATCH_GIFT_MEMO_3
|
This is the non-matching gift memo total for year 3
|
NUMBER
|
|
|
TOTAL_NON_MATCH_GIFT_MEMO_4
|
This is the non-matching gift memo total for year 4
|
NUMBER
|
|
|
TOTAL_NON_MATCH_GIFT_MEMO_5
|
This is the non-matching gift memo total for year 5
|
NUMBER
|
|
|
TOTAL_NON_MATCH_GIFT_MEMO_6
|
This is the non-matching gift memo total for year 6
|
NUMBER
|
|
|
TOTAL_PLEDGE_AMT_YEAR_1
|
This is the total pledged amount for year 1
|
NUMBER
|
|
|
TOTAL_PLEDGE_AMT_YEAR_2
|
This is the total pledged amount for year 2
|
NUMBER
|
|
|
TOTAL_PLEDGE_AMT_YEAR_3
|
This is the total pledged amount for year 3
|
NUMBER
|
|
|
TOTAL_PLEDGE_AMT_YEAR_4
|
This is the total pledged amount for year 4
|
NUMBER
|
|
|
TOTAL_PLEDGE_AMT_YEAR_5
|
This is the total pledged amount for year 5
|
NUMBER
|
|
|
TOTAL_PLEDGE_AMT_YEAR_6
|
This is the total pledged amount for year 6
|
NUMBER
|
|
|
TOTAL_PLEDGE_PAY_YEAR_1
|
This is the total pledge payments for year 1
|
NUMBER
|
|
|
TOTAL_PLEDGE_PAY_YEAR_2
|
This is the total pledge payments for year 2
|
NUMBER
|
|
|
TOTAL_PLEDGE_PAY_YEAR_3
|
This is the total pledge payments for year 3
|
NUMBER
|
|
|
TOTAL_PLEDGE_PAY_YEAR_4
|
This is the total pledge payments for year 4
|
NUMBER
|
|
|
TOTAL_PLEDGE_PAY_YEAR_5
|
This is the total pledge payments for year 5
|
NUMBER
|
|
|
TOTAL_PLEDGE_PAY_YEAR_6
|
This is the total pledge payments for year 6
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_ONE_TIM_1
|
This is the total realized matching gifts for one time payments for year 1
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_ONE_TIM_2
|
This is the total realized matching gifts for one time payments for year 2
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_ONE_TIM_3
|
This is the total realized matching gifts for one time payments for year 3
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_ONE_TIM_4
|
This is the total realized matching gifts for one time payments for year 4
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_ONE_TIM_5
|
This is the total realized matching gifts for one time payments for year 5
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_ONE_TIM_6
|
This is the total realized matching gifts for one time payments for year 6
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_PAY_1
|
This is the total realized matching gifts for payments for year 1
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_PAY_2
|
This is the total realized matching gifts for payments for year 2
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_PAY_3
|
This is the total realized matching gifts for payments for year 3
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_PAY_4
|
This is the total realized matching gifts for payments for year 4
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_PAY_5
|
This is the total realized matching gifts for payments for year 5
|
NUMBER
|
|
|
TOTAL_RLZ_MATCH_GIFT_PAY_6
|
This is the total realized matching gifts for payments for year 6
|
NUMBER
|
|
|