...
| Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACH Table Load | Auto Load the ACH Payee Table from Payroll extract file provided by Core-CT | Bi-Weekly (Paycheck week) | Inbound | Dan Warren | Director-Accounts Payable | Daniel.Warren@uconn.edu | 860-486-1654 | |||||||||||||||||||||||||||||
| Keerthi Chamala | Technical Support: ITS ETL | Keerthi.chamala@uconn.edu | 860-486-1031 | |||||||||||||||||||||||||||||||||
| Richard Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||
| Asset Global | Create many edocs with a .csv upload | Batch | Inbound | Dave Ferreira | Capital Assets | david.ferreira@uconn.edu | 860-486-0940 | |||||||||||||||||||||||||||||
| Richard Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||
| Asset Retirement Global | Create many edocs with a .csv upload | Batch | Inbound | Dave Ferreira | Capital Assets | david.ferreira@uconn.edu | 860-486-0940 | |||||||||||||||||||||||||||||
| Richard Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||
| Asset Inventory Management(AIM) - System of Record | Update Building Table within KFS | Batch - Weekly | Inbound | Dave Ferreira | Capital Assets | david.ferreira@uconn.edu | 860-486-0940 | |||||||||||||||||||||||||||||
| James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | |||||||||||||||||||||||||||||||||
| Matt Grimm | Technical Support AIM | Matthew.Grimm@uconn.edu | 860-486-3015 | |||||||||||||||||||||||||||||||||
| Asset Inventory Management(AIM) - System of Record | Update Room Table within KFS | Batch - Weekly | Inbound | Dave Ferreira | Capital Assets | david.ferreira@uconn.edu | 860-486-0940 | |||||||||||||||||||||||||||||
| James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | |||||||||||||||||||||||||||||||||
| Matt Grimm | Technical Support AIM | Matthew.Grimm@uconn.edu | 860-486-3015 | |||||||||||||||||||||||||||||||||
| Barcode Upload (Asset Panda) | Update Asset record with scanned information | Daily | Inbound | Dave Ferreira | Capital Assets | david.ferreira@uconn.edu | 860-486-0940 | |||||||||||||||||||||||||||||
| Richard Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||
| CIDER | Billing Collector File | Daily | Inbound | Courtney Wiley | Administrator | courtney.wiley@uconn.edu | 860-486-7984 | |||||||||||||||||||||||||||||
| Joey O'Shea | Developer | joseph.oshea@uconn.edu | 860-679-8144 | |||||||||||||||||||||||||||||||||
| Account API | Daily | Inbound/Outbound | Bruce Lindemann | Business Analyst | bruce.lindemann@uconn.edu | 860-486-0531 | ||||||||||||||||||||||||||||||
| Richard Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||
| Brett Paulson | Manager Financial Systems | brett.paulson@uconn.edu | 860-486-9364 | |||||||||||||||||||||||||||||||||
| Account Balance API | Daily | Inbound/Outbound | Bruce Lindemann | Business Analyst | bruce.lindemann@uconn.edu | 860-486-0531 | ||||||||||||||||||||||||||||||
| Richard Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||
| Brett Paulson | Manager Financial Systems | brett.paulson@uconn.edu | 860-486-9364 | |||||||||||||||||||||||||||||||||
| Concur | Employee | Inbound | ||||||||||||||||||||||||||||||||||
| Concur | Connected List | Inbound | ||||||||||||||||||||||||||||||||||
| Concur | Cost Object Approvers | Inbound | ||||||||||||||||||||||||||||||||||
| Concur | Chart of Accounts | Inbound | ||||||||||||||||||||||||||||||||||
| Concur | Validation Table | Inbound | ||||||||||||||||||||||||||||||||||
| Concur | Standard Accounting Extract | Outbound | ||||||||||||||||||||||||||||||||||
| Concur | Declining Balance Card Users | Outbound | ||||||||||||||||||||||||||||||||||
| Concur | Travel Insurance Users | Outbound | Jaggaer | Custom Field Export | Realtime | Inbound | Jaggaer | Invoice Status Export | Realtime | Inbound | Jaggaer | Update LDAP Roles | Realtime | Inbound | Jaggaer | User Export | Realtime | Inbound | Jaggaer | Invoice Import - includes Payment Requests, Credit Memos, and Disbursement Vouchers | Realtime | Outbound | Jaggaer | Purchase Order Import - includes Purchase Orders and Purchase Order Amendments | Realtime | Outbound | Jaggaer | Requisition Validation | Realtime | Outbound | Jaggaer | Supplier Sync | Realtime | Outbound |
Billing Files
Collector File Format
Collector File Document Numbers
Collector Flat File Directories
Billing Files Control-M Jobs
How to Automate Billing (Collector) File Upload
...
Courtney Wiley
Joey O'Shea
...
Admin
Developer
...
joseph.oshea@uconn.edu
...
860-486-7984
860-679-8144
...
FoodPro (uses Aurora Software)
...
Gayle Meisner
James Chabot-Weingart
...
Dining Services Area Manager
Technical Support
...
james.chabot-weingart@uconn.edu
...
860-486-9467
860-486-4559
...
Danielle Farrands
Ruben Mercado
...
Pinnacle Support - UITS/Business Office
Technical Support - UITS/EAS
860-486-0121
Disbursement Voucher Files
Disbursement Voucher .csv File Format
Disbursement Voucher .xml File Format
Disbursement Voucher Unit Codes
Disbursement Voucher File Directories
Disbursement Voucher Files Control-M Jobs
Disbursement Voucher Create Jobs
How to Automate Disbursement Voucher File Uploads
External System | Frequency | Direction | Business Contact | Role | Phone | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Facilities (Utilities) + ResLife (Utilities) | Monthly | Inbound to KFS | Terri Richard Brett Paulson Tia Shackett | Accounts Payable Manager Finance Systems Administrative Assistant | 860-486-1643 860-486-9364 860-486-5436 | |||||||
FoodPro (uses Aurora software) | Daily | Inbound to KFS | Gayle Meisner James Chabot-Weingart | Dining Services Area Manager Technical Support | Department of Revenue Services - CT | Vendor List to DRS | Feb 15, May 15, Aug 15, Nov 15 | Outbound | Christine Nobile | Accounts Payable | Christine.nobile@uconn.edu | 860-486-1641 |
| Cary M. Paul | Tax Hearings Officer | Cary.Paul@po.state.ct.us | 860-297-5974 | |||||||||
| Gary Cyr | Tax Manager | gary.cyr@po.state.ct.us | 860-297-5623 | |||||||||
| Kevin Kennedy | Operations Supervisor | kevin.kennedy@po.state.ct.us | 860-297-5763 | |||||||||
| Phil Soucy | IT Supervisor | phil.soucy@po.state.ct.us | 860-297-7518 | |||||||||
| James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | |||||||||
| Department of Revenue Services - CT | Delinquent vendors from DRS | mid-Jan, mid-Apr, mid-July, mid-Oct | Inbound | Christine Nobile | Accounts Payable | Christine.nobile@uconn.edu | 860-486-1641 | |||||
| Cary M. Paul | Tax Hearings Officer | Cary.Paul@po.state.ct.us | 860-297-5974 | |||||||||
| Gary Cyr | Tax Manager | gary.cyr@po.state.ct.us | 860-297-5623 | |||||||||
| Kevin Kennedy | Operations Supervisor | kevin.kennedy@po.state.ct.us | 860-297-5763 | |||||||||
| Phil Soucy | IT Supervisor | phil.soucy@po.state.ct.us | 860-297-7518 | |||||||||
| James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | |||||||||
| FoodPro (uses Aurora) | Billing Collector File | Weekly | Inbound | Gayle Meisner | Dining Services Area Manager | gayle.meisner@uconn.edu | 860-486-9467 | |||||
| James Chabot-Weingart | Technical Support | james.chabot-weingart@uconn.edu | 860-486-4559 | |||||||||
| FoodPro (uses Aurora) | Disbursement Voucher .csv | Daily | Inbound | Gayle Meisner | Dining Services Area Manager | gayle.meisner@uconn.edu | 860-486-9467 | |||||
| James Chabot-Weingart | Technical Support | james.chabot-weingart@uconn.edu | 860-486- | 9467860-486-4559 | ||||||||
| Husky-One (OneCard) | Disbursement Voucher .csv | Weekly | Inbound to KFS | Elly Prairie Stephanie KernozickyJames Chabot-Weingart OneCard Supervisor | OneCard Manager Technical Support ellen.prairie@uconn.edu | stephanie.kernozicky@uconn.edujames.chabot-weingart@uconn | 860-486-3129 | |||||
| Jeanette Jamieson | jeanette.jamieson@uconn.edu | 860-486-3129860-486-3129 | ||||||||||
| James Chabot-Weingart | Technical Support | james.chabot-weingart@uconn.edu | 860-486-4559 | |||||||||
Law Library (uses Millenium software) | Daily | Inbound to KFS | Elisabeth Umpleby Ricardo Mardales | Librarian Law School Technical Support | 860-570-5007 860-570-5233 | |||||||
| Travel | Bi-weekly | Inbound to KFS | Leshonda Owens Dan Warren | Accounts Payable - Travel Director-Accounts Payable | Daniel.Warren@uconn.edu | 860-486-1647 860-486-1654 | ||||||
| Jaggaer | Custom Field Export | Realtime | Inbound | |||||||||
| Jaggaer | Invoice Status Export | Realtime | Inbound | |||||||||
| Jaggaer | Update LDAP Roles | Realtime | Inbound | |||||||||
| Jaggaer | User Export | Realtime | Inbound | |||||||||
| Jaggaer | Invoice Import - includes Payment Requests, Credit Memos, and Disbursement Vouchers | Realtime | Outbound | |||||||||
| Jaggaer | Purchase Order Import - includes Purchase Orders and Purchase Order Amendments | Realtime | Outbound | |||||||||
| Jaggaer | Requisition Validation | Realtime | Outbound | |||||||||
| Jaggaer | Supplier Sync | Realtime | Outbound | |||||||||
| Pinnacle (uses Calero) | Telecom Billing Files (Storrs+Branch) | Batch-Monthly | Inbound | Danielle Farrands | Pinnacle Support - ITS/Business Office | danielle.farrands@uconn.edu | 860-486-0121 | |||||
| Ruben Mercado | Technical Support - ITS/EAS | ruben.mercado@uconn.edu | ||||||||||
| Utilities | Facilities + ResLife | Batch- Monthly | Inbound | Tia Shackett | Administrative Assistant | tia.Shackett@uconn.edu | 860-486-5436 |
Billing Files
Collector File Format
Collector File Document Numbers
Collector Flat File Directories
Billing Files Control-M Jobs
How to Automate Billing (Collector) File Upload
Disbursement Voucher Files
Disbursement Voucher .csv File Format
Disbursement Voucher .xml File Format
Disbursement Voucher Unit Codes
Disbursement Voucher File Directories
Disbursement Voucher Files Control-M Jobs
Disbursement Voucher Create Jobs
How to Automate Disbursement Voucher File Uploads
Other File Interfaces
Check Reconciliation Processing
...
| External System | Description | Frequency | Direction | Business Contact | Role | Phone | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Accounts Receivable | Customer Load | Monthly | Inbound to KFS | Carleen Wells Angela Piela Nicole Kulig | Assistant Finance Director Administrative Services Functional Staff | 860-486-3335 860-486-5995 860-486-0588 | ||||||||
| Accounts Receivable | Invoices | Monthly | Inbound to KFS | Carleen Wells Angela Piela Nicole Kulig | Assistant Finance Director Administrative Services Functional Staff | 860-486-3335 860-486-5995 860-486-0588 ACH Table Load | Auto Load the ACH Payee Table from Payroll extract file | Bi-Weekly (Paycheck week) | Inbound | Dan WarrenDirector-Accounts Payable Technical Support: UITS Datastage Support Technical Support: UITS KFS Support | Asset Inventory Management(AIM) - System of Record | AIM Subject Matter Expert Business Analyst Technical Support: UITS for AIM Technical Support: UITS KFS Support | ||
| Asset Global Upload | Create many Asset Global eDocs at one time | On request | Inbound to KFS | Dave Ferreira Richard Ritchie | Capital Asset Subject Matter Expert Technical Support | 860-486-0940 860-486-2837 | ||||||||
| Barcode Upload (Asset Panda) | Update Asset record with scanned information | Daily | Inbound to KFS | Dave Ferreira Richard Ritchie | Capital Asset Subject Matter Expert Technical Support | 860-486-0940 860-486-2837 | ||||||||
| BottomLine Check & ACH | Check and ACH payments to PayBase | Daily | Outbound from KFS | Brett Paulson | Manager Finance Systems | brett.paulson@uconn.edu | 860-486-9364 | |||||||
| Check Reconciliation | Reconcile all bank checks plus Student Financial checks | Monthly | Inbound to KFS | Brett Paulson | Manager Finance Systems | brett.paulson@uconn.edu | 860-486-9364 | |||||||
| Centrally Funded CBI | Budget Construction | On Request | Inbound to KFS | Bruce Lindemann Brett Paulson | Finance Systems Business Analyst Manager Finance Systems | 860-486-0531 860-486-9364 | ||||||||
| Concur | Travel Application | Paul Morano | Technical Support | paul.morano@uconn.edu | 860-486-2336 | Dept. of Revenue Services - State of CT | Kevin Kennedy Phil Soucy Gary Cyr Karen Straut | |||||||
| MasterCard (Concur) | Credit Card Transactions | Daily (Mon-Sat) | Inbound | Nancy Patrylak Elise Fiorentino | Procurement Card Administrator Procurement Card Administrator | 860-486-2622 860-486-5924 | ||||||||
| PageUp | Recruiting Solutions: User Import Fire/Poilce App AJO Math | Daily twice Daily | Outbound from PageUp | Kathy Avery Jim Klaben Shannon Page Richard Ritchie | Technical Support Business Analyst Functional Staff Technical Support | James.Klaben@uconn.edu Shannon.Page@uconn.edu Richard.Ritchie@uconn.edu | 860-486-1418 860-486-3778 860-486-0410 860-486-2837 | |||||||
| Unifier | Capital Projects - Chart of Accounts, requisitions, Purchase Orders, Amendments, and Electronic Invoice | Daily | Inbound/Outbound | Richard Ritchie | Technical Support | richard.ritchie@uconn.edu | 860-486-2837 |
...