...
Collector Flat File Directories
Billing Files Control-M Jobs
...
Disbursement Voucher File Directories
DV Upload KFS field mapping - Generic
Disbursement Voucher Files Control-M Jobs
...
How to Automate Disbursement Voucher File Uploads
Original ProCard(Mastercard) Processing
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 LisAdministrative | ServicesAccounts 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 Frequency | Direction | Business Contact | Role | Phone | 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|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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
.
.
.
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- |
Credit Card Transactions
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 |
Nancy Patrylak
Elise Fiorentino
Procurement Card Administrator
Procurement Card Administrator
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 |
---|
GENESYS<==>KFS
Interfaces
Core-CT | See each Interface for details. | Varies - see detail. |
Inbound/ Outbound | Kelly Wihbey |
Brett Paulson
Richard RitchieKFS SME: Budget Office |
Manager Finance Systems
Technical Support:
kelly.wihbey@uconn.edu | 860-486-0532 | |||||
Brett Paulson | Manager Finance Systems | brett.paulson@UConn |
.edu | 860-486- |
9364 |
860-486-2837
Student Administration (SA) - Student Financials Interfaces
Student Receipts
Payment Distribution
Student Disbursements
Student Refund
Checks
Daily (Sun-Sat)
Monthly (On request)
Inbound
Inbound
Kelly Shedd
Tanya Osuba
Naomi McKenna
Bruce Kwon
Kathy Avery
Other contacts as above.
KFS SME:
Bursar's Office
KFS SME: Bursar's Office
KFS SME - Financial Aid
Technical Support: UITS SA-Student Financials
Technical Support: UITS KFS Support
860-486- 5070
860-486-9208
860-486-2819
860-486-2539
860-486-1418
Richard Ritchie | Technical Lead - ITS Financial Systems | Richard.ritchie@uconn.edu | 860-486-2837 |