Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_GIVING

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    


Ver: