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
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Accounts Receivable | Customer Load, Invoices | Monthly | Inbound | Angela Piela | Administrative Services | angela.piela@uconn.edu | 860-486-5995 |
Dan Lis | Accounts Receivable Supervisor | daniel.lis@uconn.edu | 860-486-3335 | ||||
Hayley Hesse | Manager - AR, Cash Ops | hayley.hesse@uconn.edu | 860-486-1676 | ||||
Nicole Kulig | Manager - AR, Cash Ops | nicole.kulig@uconn.edu | 860-486-0588 | ||||
Vickie Weidig | Pathobiology | vickie.weidig@uconn.edu | 860-486-5014 | ||||
Jeff Pasiuk | Parking Services | jeffrey.pasiuk@uconn.edu | 860-486-5204 |
.
.
.
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 - ITS Financial Systems | richard.ritchie@uconn.edu | 860-486-2837 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Capital Assets - UConn | Asset Global, Asset Retirement Global | Daily Batch | Inbound | Dave Ferreira | Capital Assets | david.ferreira@uconn.edu | 860-486-0940 |
Richard Ritchie | Technical Lead - ITS Financial Systems | richard.ritchie@uconn.edu | 860-486-2837 | ||||
Asset Inventory Management(AIM) - System of Record | Building Updates (Building), Room Updates (Room) | 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 - ITS | matthew.grimm@uconn.edu | 860-486-3015 | ||||
Kathy Avery | Technical Support -ITS | kathy.avery@uconn.edu | 860-546-9651 | ||||
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 - ITS Financial Systems | richard.ritchie@uconn.edu | 860-486-2837 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Check Reconciliation (Bank of America) | Reconcile all bank checks plus Student Financial checks | Monthly | Inbound | James Klaben | Finance Systems Business Analyst | james.klaben@uconn.edu | 860-486-3778 |
Brett Paulson | Manager Financial Systems | brett.paulson@uconn.edu | 860-486-9364 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
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 | ||||
Daily | Inbound/Outbound | Bruce Lindemann | Finance Systems Business Analyst | bruce.lindemann@uconn.edu | 860-486-0531 | ||
Richard Ritchie | Technical Lead - ITS Financial Systems | richard.ritchie@uconn.edu | 860-486-2837 | ||||
Brett Paulson | Manager Financial Systems | brett.paulson@uconn.edu | 860-486-9364 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
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 | ||||
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 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
FoodPro (uses Aurora) | Billing Collector File | Daily | Inbound | Gayle Meisner | Dining Services Area Manager | gayle.meisner@uconn.edu | 860-486-9467 |
James Chabot-Weingart | SAIT Technical Support | james.chabot-weingart@uconn.edu | 860-486-4559 | ||||
Disbursement Voucher .csv | Weekly | Inbound | Gayle Meisner | Dining Services Area Manager | gayle.meisner@uconn.edu | 860-486-9467 | |
James Chabot-Weingart | SAIT Technical Support | james.chabot-weingart@uconn.edu | 860-486-4559 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Husky-One (OneCard) | Disbursement Voucher .csv | Weekly | Inbound | Stephanie Kernozicky | OneCard Manager | stephanie.kernozicky@uconn.edu | 860-486-3129 |
Jeanette Jamieson | jeanette.jamieson@uconn.edu | 860-486-3129 | |||||
James Chabot-Weingart | SAIT Technical Support | james.chabot-weingart@uconn.edu | 860-486-4559 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Page-Up - Recruiting Solutions | Daily | Outbound | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | |
James Klaben | Finance Systems Business Analyst | james.klaben@uconn.edu | 860-486-3778 | ||||
Kathy Avery | Technical Support - ITS | kathy.avery@uconn.edu | 860-486-1418 | ||||
User Import | Daily | Outbound | Dylan Marquis | Technical Support - ITS LDAP | Dylan.Marquis@uconn.edu | 860-486-9458 | |
James Klaben | Finance Systems Business Analyst | james.klaben@uconn.edu | 860-486-3778 | ||||
Fire/Police Import, AJO Import, Math Import | Twice Daily | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | ||
James Klaben | Finance Systems Business Analyst | james.klaben@uconn.edu | 860-486-3778 | ||||
Richard Ritchie | Technical Lead - ITS Financial Systems | richard.ritchie@uconn.edu | 860-486-2837 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Pinnacle (uses Calero) | Telecom Billing Collector 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 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Travel - Concur Solutions | Standard Accounting Extract, Declining Balance Card Users, Travel Insurance Users | Outbound | Garrett Heinze | Assistant Director, Procurement Systems | heinze@uchc.edu | 860.335.6782 | |
Paul Morano | Technical Support - ITS | paul.morano@uconn.edu | 860-486-2336 | ||||
Travel - Concur Solutions | Employee, Connected List, Cost Object Approvers, Chart of Accounts, Validation Table | Outbound | Garrett Heinze | Assistant Director, Procurement Systems | heinze@uchc.edu | 860.335.6782 | |
Paul Morano | Technical Support - ITS | paul.morano@uconn.edu | 860-486-2336 | ||||
Mastercard and Concur Services | Validation and Reallocation | Daily | Inbound | Nancy Patrylak | Procurement Card Administrator | Nancy.Patrylak@uconn.edu | 860-486-2622 |
Elise Fiorentino | Procurement Card Administrator | Elise.Fiorentino@uconn.edu | 860-486-5924 |
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
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 | Garrett Heinze | Assistant Director, Procurement Systems | heinze@uchc.edu | 860.335.6782 |
Jaggaer | Purchase Order Import - includes Purchase Orders and Purchase Order Amendments | Realtime | Outbound | Garrett Heinze | Assistant Director, Procurement Systems | heinze@uchc.edu | 860.335.6782 |
Jaggaer | Requisition Validation | Realtime | Outbound | ||||
Jaggaer | Supplier Sync | Realtime | Outbound |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Unifier | Capital Projects - Chart of Accounts, requisitions, Purchase Orders, Amendments, and Electronic Invoice | Daily | Inbound/Outbound | Richard Ritchie | Technical Lead - ITS Financial Systems | Richard.ritchie@uconn.edu | 860-486-2837 |
.
.
.
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Utilities | Facilities + ResLife - Disbursement Vouchers | Batch- Monthly | Inbound | Tia Shackett | Administrative Assistant | tia.Shackett@uconn.edu | 860-486-5436 |
.
.
.
External System | Description | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
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 |
Centrally Funded CBI | Budget Construction | On Request | Inbound to KFS | Bruce Lindemann | Finance Systems Business Analyst | bruce.lindemann@uconn.edu | 860-486-0531 |
James Klaben | Finance Systems Business Analyst | james.klaben@uconn.edu | 860-486-3778 | ||||
Brett Paulson | Manager Finance Systems | brett.paulson@uconn.edu | 860-486-9364 |
.
.
.
Student Administration (SA) - Student Financials Interfaces
Vendor | Integration Object | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
PeopleSoft Student Financials | Student Receipts, Payment Distribution, Student Disbursements | Daily (Sun-Sat) | Inbound | Kelly Shedd | KFS SME: Bursar's Office | kelly.shedd@uconn.edu | 860-486- 5070 |
Tanya Osuba | KFS SME: Bursar's Office | tanya.osuba@uconn.edu | 860-486-9208 | ||||
Naomi McKenna | KFS SME - Financial Aid | naomi.mckenna@uconn.edu | 860-486-2819 | ||||
Student Refund Checks | Monthly (On request) | Inbound | Bruce Kwon | Technical Support: ITS SA-Student Financials | bruce.kwon@uconn.edu | 860-486-2539 | |
.
.
.
GENESYS<==>KFS Interfaces - Feed is now from Core-CT
External System | Description | Frequency | Direction | Business Contact | Role | Phone | |
---|---|---|---|---|---|---|---|
Core-CT | See each Interface for details. | Varies - see detail. | Inbound/ Outbound | Kelly Wihbey | KFS SME: Budget Office | kelly.wihbey@uconn.edu | 860-486-0532 |
Brett Paulson | Manager Finance Systems | brett.paulson@UConn.edu | 860-486-9364 | ||||
Richard Ritchie | Technical Lead - ITS Financial Systems | Richard.ritchie@uconn.edu | 860-486-2837 |