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.
Reporting Services Reports
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