Alumni & Development

Business Intelligence for Alumni and Development

Get a sense of the Alumni and Development data available to UT constituents.  To request access or to build something related, contact us.

Reports available in ANDI AWA

  • ANDIB0008 LEGO Combine Clipboards
  • ANDIB0010 Create Smart Call Appeal From Clipboard
  • ANDIB0012 Nightly Procedure Log
  • ANDIB0013 Nightly Batch – Error Table Audit
  • ANDIB0014 Nightly Batch – ZZGP Procedure Log
  • ANDIB0015 Nightly Batch – ZZGP Error Log
  • ANDIB0017 ACH Interface
  • ANDIB0018 ACH File Transmission Trigger
  • ANDIB0025 Payroll Deduction Interface No Donor
  • ANDIB0026 Payroll Deduction Interface No Pledge
  • ANDIB0030 Appeals List Report
  • ANDIB0031 New Appeal Code Report
  • ANDIB0032 Clipboard to Direct Mail Appeal Report
  • ANDIB0033 Pledge Renewal Interface Report
  • ANDIB0034 Demo Bio Load
  • ANDIB0035 Demo Bio Student Act Social Network Load
  • ANDII0002 Payroll Ded Not Paid
  • ANDII0004 Payroll Deduction ID Check

  • ANDIC0002 Campaign Largest Commitments
  • ANDIC0004 Campaign Status Report
  • ANDIC0007 Campaign New Commitments Report
  • ANDIC0009 Campaign Analysis by Source
  • ANDIC0010 Campaign Analysis by Purpose
  • ANDIC0011 Campaign Analysis Giving Cat

  • ANDID0003 Alumni Counts by County
  • ANDID0006 Sport Report
  • ANDID0007 Vol Activity Report
  • ANDID0016 Awards Report
  • ANDID0017 LEGO Clipboard Member List
  • ANDID0018 LEGO Invalid Address List
  • ANDID0020 LEGO Entity Geo
  • ANDID0021 LEGO Entity Academic
  • ANDID0022 LEGO Entity Giving
  • ANDID0023 LEGO Prospect Geo
  • ANDID0024 LEGO Prospect Academic
  • ANDID0025 LEGO Prospect Giving
  • ANDID0026 Label Processing Status Report
  • ANDID0028 LEGO Oneline Club List
  • ANDID0039 Labels Parameter Entry/View
  • ANDID0040 Limited Solicitation
  • ANDID0041 Class Roster
  • ANDID0042 Alumni Alpha List
  • ANDID0043 Athletics Donor Change Report
  • ANDID0044 ID Decryption
  • ANDID0046 LEGO Medical Residents/Affiliates Report
  • ANDID0047 Labels Custom Format
  • ANDID0048 LEGO Alumni Chapter Report
  • ANDID0050 Limited Solicitation Update

  • ANDIG0002 Pending Club Memberships
  • ANDIG0003 Processing Statistics Report
  • ANDIG0004 Database Health Report
  • ANDIG0006 Planned Giving Mailing Response
  • ANDIG0008 PG Donation Summary
  • ANDIG0009 Active/Recent Pledges
  • ANDIX0001 Prospect Detail
  • ANDIX0002 LEGO Basic Profile – Person
  • ANDIX0004 LEGO Basic Profile – Organizations
  • ANDIX0027 Solicitation Control Code Update
  • ANDIX0028 User Lock Unlock Activate Deactivate
  • ANDIS0001 Endowment Main Report
  • ANDIS0013 Endowment Report with R Balances

  • ANDIM0001 Geo Source
  • ANDIM0004 Allocation Detail Report
  • ANDIM0004 Allocation Detail Rpt
  • ANDIM0004 Allocation Report
  • ANDIM0009 Major Commitments Report
  • ANDIM0011 Pledges Completed
  • ANDIM0017 Allocation Summary Report
  • ANDIM0020 Matching Gift Allocation Detail Report
  • ANDIM0021 Matching Gift Allocation Summary Report
  • ANDIM0022 FYTD Comparison Report
  • ANDIM0026 Special Handling Reminders
  • ANDIM0035 FYE Payroll Gifts and Pledges by Allocation – Deta
  • ANDIM0037 FYE Corporate Matching Gift Report
  • ANDIM0038 FYTD Comparison (Annual)
  • ANDIM0044 Giving Analysis
  • ANDIM0046 FYTD Comparison (Organizations)
  • ANDIM0047 Giving Summary Report
  • ANDIM0049 Active (Open) Pledge Rpt
  • ANDIM0050 Top X Donors
  • ANDIM0053 New Donors Report
  • ANDIM0055 ACH Pledge Payment Data Entry
  • ANDIM0057 ACH Pledge Data Display
  • ANDIM0059 Acknowledgment Mail Merge Report
  • ANDIM0060 FYTD Commitments by Purpose
  • ANDIM0061 ACH Account List
  • ANDIM0065 UT Foundation Report
  • ANDIM0068 Donor Profile Report
  • ANDIM0069 Annual Giving Levels Report
  • ANDIM0070 Annual Giving Progress Report
  • ANDIM0071 Annual Giving Source Report
  • ANDIM0073 GPS Report
  • ANDIM0074 Pledge Write-Off Report
  • ANDIM0076 Gift Receipts
  • ANDIM0077 Non-Philanthropic Transaction Report
  • ANDIM0078 Athletics NP Account Activity Summary
  • ANDIM0080 Credit Card Pledge Payment Batch Creation Report
  • ANDIM0081 Annual Giving Appeal Statistics
  • ANDIM0084 Cash Receipts by Campus and School
  • ANDIM0085 Number of Donors Comparison
  • ANDIM0086 Online Giving Report
  • ANDIM0087 Campus Development
  • ANDIM0088 Net Progress
  • ANDIM0089 FYTD Comparison
  • ANDIM0090 Five Year Giving Comp
  • ANDIM0091 Gift Buy Back Update

  • ANDIP0001 Prospect Progress Report
  • ANDIP0004 Prospects with No Activity Report
  • ANDIP0005 Contact Report Detail
  • ANDIP0006 Contact Report Summary
  • ANDIP0007 Prospect Assignmt Dtl
  • ANDIP0008 Prospect Assignment Summary
  • ANDIP0011 Contact Activity for Organizations
  • ANDIP0014 Proposal Monitoring Report
  • ANDIP0015 Prospect Status
  • ANDIP0016 Contact Monitoring Report
  • ANDIP0018 P!N Prospect Report
  • ANDIP0019 Pin Activity Report
  • ANDIP0020 Proposal Detail Report
  • ANDIP0022 Develoment Activity Report
  • ANDIP0024 Development Officer Metrics Report
  • ANDIP0025 Prospect Tracking Report

Argos Reports

  • Athletics Annual Giving Year to Date vs Prior Years ATHLE_18 & ATHLE_44 Report
  • Athletics Annual Giving Year to Date vs Prior Years Report
  • Athletics Capital Gifts Cash Flows
  • Athletics Capital Gifts Year to Date vs Prior Years Report
  • Summary For Specific Allocations – Capital Accounts Report
  • Summary For Specific Allocations
  • Summary of FY KMA Gifts to ATHLE_18 & ATHLE_44 by Amount Range Report

  • 1165-Invalid former spouse-missing spouse ID number Report
  • 1172-Address-phone unlisted date is null and phone_unlisted_ind=Y Report
  • 1241 one or more entity organization name components is different from its name component Report
  • 433–Verfies that address stop date is not prior to the start date and both are valid Report
  • 576-Verfity that activity stop date is not prior to the start date and both are valid Report
  • 652-In former_spouse one or more required fields is empty or date_modified less than date_added Report
  • 812-Verif that all required fields in Active have valueS Report
  • ANDI Users with the same ANDI ID for different username accounts Report
  • ANDI Users–log in frequency Report
  • ANDI_Ids_with_deceased_in_Mail_Control_Comment_Field Report
  • Active Entities Coded as Divorced Report
  • Active Entities over 110 years old Report
  • Active Entities with active address and not a preferred
  • Active Entity that should be Lost Report
  • Active Orgs without HEP ID Report
  • Active Record with Marital Status T or Z Report
  • Address Type K Report
  • Address Type P or Q Report
  • Allocation – Multiple – Short Names – Account Report
  • Allocations that have the same short_name text Report
  • Alums coded as Friends Report
  • Alums no degree ID Report
  • Bad Email Address Format Report
  • Birthdate Check Report
  • C_O in Address Report
  • CARE OF field too long 40 Report
  • City Field over 30 Characters Report
  • Current_Fac_Staff_also_coded_Former_Empl Report
  • Current_Fac_Staff_also_coded_Retiree Report
  • Deceased Spouse Relationship Present Report
  • Deceased in Mail Control Report
  • Duplicate 4H IDs Report
  • Duplicate Alternate IDs in ANDI Report
  • Duplicate Degrees Check Report
  • Duplicate Email Addresses Report
  • Duplicate Prospect ID Report
  • Duplicate Records that should be set to ‘P’ Report
  • Duplicate WUOT IDs in ANDI Report
  • Duplicate WUTC IDs in ANDI Report
  • Entities in ANDI with more than one Home
  • Entities who are Children but have Parent Relationship Report
  • Entities who are active and a have an active address but no preferred address Report
  • Entities with No Pref. Mail Name Report
  • Entity Record Type Friend with multiple record types Report
  • Esquire Prefix Clean-up Report
  • Faculty Staff bus address should link to the University of Tennessee entity record 0002693738 Report
  • Former Employee also coded Retiree Report
  • Foundations with wrong record type Report
  • GIFT CLUB – DUPLICATES Report
  • Inaccurate State and Zip Code Matches Report
  • Institution Code and Campus Codes 08112010 Report
  • Invalid Foreign Address Report
  • Invalid Prefixes Report
  • Lost Entities with Active Address Report
  • Lost Entities with Active email Address Report
  • Lost Entities(Also Check Spouse) Addresses should be InActive Report
  • Missing Area Codes Possible Address Report
  • Multiple Record Type Entities Report
  • Multiple Relationships to Same Entity Report
  • Multiple User IDs Report
  • Phone Number – Multiple Prefered Report
  • Pref address of married entity with too many label lines Report
  • Pref. school degree mismatched Report
  • Preferred Address with street1 or city field blank Report
  • Preferred Entity Address(Bio Overview) does not match Preferred Address(Address Section) Report
  • Preferred address is Cellphone Report
  • Prefix and Professional Suffix Clean Up Report
  • Spaces at Beginning of Name Report
  • State Code length greater that 2 digits Report
  • Too many lines on address label Report
  • US Addresses that contain a country code Report
  • UT Emp not linked to UT Report
  • UT_degrees_not_local Report
  • Wrong Record Type in Entity Report
  • allocations whose long names are greater than 80 characters Report
  • any allocations to an ‘S’ account that are do not have ‘UTF’ as the agency code Report
  • entities with multiple legacy club memberships Report
  • joint salutation not equal to husband and wife with names in Entity 2000 Report
  • lost Entities with Planned Giving Report
  • multiple active home or business addresses Report
  • multiple preferred addresses Report
  • salutation not equal to name in Entity 2000 Report
  • spouse_addr_status_different Report

  • ANDI ID Number in USER table not valid.
  • Active Pledge Payment Schedule
  • Active pledges with open payment frequencies excluding BE and DF
  • Active_Allo_Missing_CFAE_Purpose
  • Alloc dup name
  • Alloc with Gifts and No Category Code Report
  • Allocations with blank Div-Camp-school
  • Alloc Same Gift Not Same Appeal Code
  • Allocations with inactive alloc departments
  • Allocations which CFAE is CR and ATH indicator is Y
  • Allocations_with_incorrect_Div_Camp_School_Dept Report
  • Allocs with inactive alloc_divisions
  • Allocs With Inactive Alloc Schools
  • Appeal Headers Verify Unit Codes Report
  • Campaign Transactions not in Current Campaign or 9999 Report
  • Campaign Duplicate Gift-Pledge Rows
  • Campaign Missing CFAE
  • Checks deposited by others to Athletics
  • Deferred npv Blank
  • Duplicate Pledge Allocations
  • Duplicate segment rows
  • Entities with Invalid Characters
  • Entities with Multiple Club Memberships
  • gifts appeals one with unit code and one not
  • Gifts Date of Record Check
  • Gifts With Different Attributes
  • Gifts With Joints
  • Gifts
  • Gifts
  • Gifts test DemoBio
  • Gifts to annual allocation with no appeal code
  • Gifts with no Campaign Code
  • Incorrect Pledge Recognition Credit Report
  • Invalid Dates on Gifts
  • Invalid Dates on Pledge
  • LDRS Work File add spouse first name
  • Matching Claim received check box NOT checked Report
  • Matching gifts with different attributes
  • Mens Womens Allocations with Athletics Indicator = N
  • Monthly RGSF Holding Accounts Report
  • Multiple DCURR Segment Rows
  • NP gift transaction that are used as a pledge payment
  • Non-Fulfilled Matching Claims Report
  • Open Batch – 10 Days Report
  • Paid pledges – amounts over and under
  • Pledge Date of Record Check
  • Pledge Payments as Gifts
  • Pledge paid discrepancies
  • Pledge payment (PP) not linked to a pledge Report
  • Pledges Canceled but Active Report
  • Pledges and PSched with differences 2
  • Pledges and PSched with differences 1C
  • Pledges and PSched with differences-3
  • Pledges with a high number of scheduled payments
  • Pledges with balance greater than scheduled payoff
  • Pledges with different attributes
  • Pledges with no Campaign Code
  • Pledges with open payment frequencies excluding BE and DF
  • Pledges with scheduled payments past the year 2020
  • Pledges withe zero balance but status of active
  • Two Allocation Rows With P-Primary Associated Code
  • active pledges with more than one scheduled payment due
  • GIK -no tender type
  • matching claims with a dollar amount with a date prior to curren
  • Matching claims with zero amounts
  • Matching Gift Companies With Inactive Address
  • Matching Gift Companies With Inactive Address

  • JKW Contact Detail Report
  • JKW Proposals Ending Report
  • JKW Proposals Starting Report
  • R_HSC Report
  • U_HSC Report
  • HEALTH SCIENCE GIFT-IN-KIND SINCE FY2009 Report
  • HEALTH SCIENCE GIFTS SINCE FY2009 Report
  • HEALTH SCIENCE PLEDGE PAYMENTS SINCE FY2009 Report
  • HEALTH SCIENCE REALIZED BEQUEST SINCE FY2009 Report
  • Health Science Deferred Non-Bequest Gifts Since FY2009 Report
  • Health Science Deferred Pledges Since FY2009 Report
  • Health Science Non-Deferred Pledges Since FY2009 Report

  • ‘Estate of’ records not set to Z Report
  • A&S Pledge Donors to Each Alloc Over1000 Report
  • A&S Prev Month Donor to alloc over1000 Report
  • AGR Online Annual Gifts Report
  • AIM Alumni Giving Report
  • ANDI Users
  • ANDI Users without an Office Code Report
  • Active Assignments
  • Active UT-retiree-with-no-retired-UT-employment-record Report
  • Active and Paid Camp Pledges 25K+ (exclude BE&DF) by School
  • Active-retired-UT-employment-record-without-entity-record-type-UT-retiree Report
  • Address State Size Error Report
  • Allocations not on annual giving list
  • Alpha_24 & Alpha_26 Report
  • Appeal Headers May Need Unit Codes
  • Athletic Donors with new ANDI ID’s Report
  • Bi-Monthly UTK Gifts $300 to $25K Report- 2nd
  • Bi-Monthly UTK Gifts $300 to $25K Report
  • Young Alumni Birthday List (2)
  • Business Analytics and Statistics Alumni Report
  • CBA Alums_Donors_Faculty_Staff – Email File
  • CCI First Time Donors Report
  • CCI Weekly Report – All Donors Report
  • COE Monthly Annual Giving Report (3)
  • Contacts as Donors Report
  • County Endowment Accounts Report
  • Data Refresh Fail on IRIS SFTP files for table ADVUT.XRFV001_ACCTA for ANDI PROD
  • Data Refresh Fail on IRIS SFTP files for table ADVUT.XRFV002_GLACT for ANDI PROD
  • Data Refresh Fail on IRIS SFTP files for table ADVUT.XRFV003_ESEMPLY for ANDI PROD
  • Dead Entities with Active Def Pledge Report
  • Dr.Schwandt Has An Active Address Report
  • FYTD Payroll Deduction to UTM Athletics Report
  • Fail on sending IRIS table ADVUT.XRFV003_ESEMPLY from ANDI PROD to FLY UT
  • First Time Law Donors Report
  • First Time UTK Engineering Donors Report
  • First Time donrs to AGR Report
  • Allocation Donors List Report
  • GIK Commodity Report Report
  • Gift sum does not equal Primary Gift Report
  • Gifts_to_S_and_T_Accts Report
  • INACTIVE_ANDI_USER Report
  • IPS Fiscal Year Report
  • Incorrect Pledge Credit Report
  • Invalid Birthdates Report
  • Journey to Top 25 Report
  • Law Alumni and Donors Email List Report
  • Library First Time Donors Report
  • MCK Gifts Processed by Others – Payroll Deduction Report
  • MCK Gifts Processed by Others Report
  • Major Donors 16th to EoM Report
  • Major Donors 1st to 16th Report
  • Matching Gifts to Different Allocs (RGSF) Report
  • McClung Museum Payroll Deduction Report Report
  • Million Dollar Donors to UTK Birthday List Report
  • Missing Alumni Chapter Giving Codes Report
  • Monthly A&S Donors by Dept Report
  • Monthly A&S Donors by Dept Report
  • Monthly A&S Enrichment Allocs Report – CSV
  • Monthly A&S Enrichment Allocs Report – CSV
  • Monthly ACH Payments Report
  • Monthly ACH Payments Report
  • Monthly Equipment Report Report
  • Monthly S1301 Gift Amounts by Alloc Campus Report
  • Monthly UTC Athletics Report FYTD Report
  • Monthly UTC Athletics Report Report
  • Monthly UTHSC College of Allied Health Sciences Report
  • Monthly UTHSC College of Nursing Report
  • Monthly UTM Academic Gift Donors Report
  • Monthly UTM Athletics Gift Donors Report
  • Multiple Dr.Cheek Salutations Report
  • New employment with no matching employment row
  • Non-fulfilled match claims – ALL Report
  • Online Payroll Deduction Report (2)
  • Overnight Processes Completed- 1st Run
  • Overnight Processes Completed
  • Pledges Eligible to be Written Off Report
  • Pledges With Non-Active Donors
  • Pledges with Unpaid Payments over 200 Days Overdue Report
  • Pledges with Unpaid Payments over 200 Days Overdue Report
  • Proposal Monthly Report Report
  • Purgable With Gift Info Report
  • Purgable With Pledge Info Report
  • Purgable With “Other” ID Info Report
  • QualPro Report
  • Specialized Stewarding Reports
  • Strategic Dashboard Alumni Counts by Campus Report
  • Strategic Dashboard Alumni Counts by System Report
  • Strategic Dashboard Donor Alumni by Campus Report
  • Strategic Dashboard Donor Alumni by System Report
  • Student Affairs Gift Report Report
  • University of Tennessee -TRAVELERS LIST
  • Telefund Reminders – HSC Only Report
  • Telefund Reminders – non HSC Report
  • UCF Clearing Accounts Report
  • UTAWP New Members Report
  • UTAWP New Members Report
  • UTAWP New Members Report
  • UTC Alumni BOD Report
  • UTC Alumni Coded Deceased Report
  • UTC Committee Members Report
  • UTC First Time Donors Weekly Report
  • UTC GOLD Council Report
  • UTHSC Deceased Alumni Report
  • UTIA Gifts Pledges Matches Report
  • UTK 2nd Time in FY Donors Report
  • UTK 3rd Time in FY Donors Report
  • UTK 4th Time in FY Donors Report
  • UTK 5th Time in FY Donors Report
  • UTK 6th Time in FY Donors Report
  • UTK A&S First Time Donors Report
  • UTK Alumni Donors in GA Report
  • UTK Alumni Donors in NC_SC Report Report
  • UTK Alumni Donors in TX Report
  • UTK Alumni Donors in West TN Report
  • UTK Alumni Leaders Endowment Weekly Report
  • UTK Alumni Program Fund Weekly Report
  • UTK Board and Council Member Giving Totals Report
  • UTK Campus Fund Birthday List Report
  • UTK Champions Report
  • UTK Champions Report
  • UTK First Time Donors Report
  • UTK First Time in FY Donors Report
  • UTK Law Birthday List Report
  • UTK Library Birthday List Report
  • UTK Nursing Monthly Annual Giving Report (3)
  • UTK Rec Sports Accounts Report
  • UTK Weekly Major Commitments Report
  • UTK_Library_Prior_Month_Donors_over_$100
  • UTM Athletics TY_LY Comp Report
  • UTM Deceased Alumni Report
  • UTM First Time Donors Report
  • UTM Priorities 2 Report
  • UTM Priorities Report
  • UTMC Weekly Donors – Report
  • Volstarter Weekly Report Report
  • WUTC Monthly Gifts Report
  • WUTK FM Gift Fund Donors Report
  • Weekly Deceased Report Report
  • Wrong Credit Covering Report
  • E-receipts Updates
  • Agriculture Donors Thank You Cards
  • HSC First Time Donors Thank You Cards

  • PG_BE Pledge Quarterly Report
  • PG_BQ Gift Monthly Report
  • PG_BQ Gift Quarterly Report
  • PG_CL Gift Quarterly Report
  • PG_CR Gift Quarterly Report
  • PG_DF Pledge Quarterly Report
  • PG_GA Gift Quarterly Report
  • PG_IN Gift Quarterly Report
  • PG_PI Gift Quarterly Report
  • PG_RL Gift Quarterly Report
  • Real Estate Quarterly Report
  • Securities Quarterly Report

  • Deceased Entity Records with Active Prospects
  • Entities with 2+ prospects Report
  • Prospects with no Prospect assignments Report
  • Prospects with no primary assignment Report
  • Prospects with stewardship 1+ year Report