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 | Administrative Services | 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 |
.
...
.
...
.
| Kathy Avery | Technical Support - ITS | Kathy.Avery@uconn.edu | 860-486-1418 | James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | User Import | Twice Daily | Outbound | James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | Dylan Marquis | LDAP Technical Support | Dylan.Marquis@uconn.edu | 860-486-9458 | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | Fire/Police Import | Twice Daily | Rich Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | AJO Import | Twice Daily | Rich Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | Math Import | Twice Daily | Rich Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | James Klaben | Finance Systems Business Analyst | James.Klaben@uconn.edu | 860-486-3778 | Shannon Page | Functional Staff | Shannon.Page@uconn.edu | 860-486-0410 | Vendor | Integration Object | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Unifier | Capital Projects - Chart of Accounts, requisitions, Purchase Orders, Amendments, and Electronic Invoice | Daily | Inbound/Outbound | Rich Ritchie | Technical Lead | richard.ritchie@uconn.edu | 860-486-2837 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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
Department of Revenue Services (DRS) Vendor List
Department of Revenue Services (DRS) Delinquent Vendor File
MasterCard (Procurement Card) Processing
Other Files Control-M Jobs
...
| 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 | |
| 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 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 | ||
| 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 |
...