Table of Contents
maxLevel 8

...

Billing Files

Collector File Document Numbers

Collector Flat File Directories

Collector mapping - generic

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

DV Upload KFS field mapping - Generic

Disbursement Voucher Files Control-M Jobs

Disbursement Voucher Create Jobs

How to Automate Disbursement Voucher File Uploads

Original ProCard(Mastercard) Processing

pcd_process_v2.png

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	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

.

DanielWarren@uconn: Keerthi860-486-2837

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	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
Asset Global	Create many edocs with a .csv upload	Batch	Inbound	Dave Ferreira	Capital Assets	d avid.ferreira@uconn.edu	860-486-0940
Richard Ritchie	Technical Lead	richard.ritchie@uconn.edu

.

Update Building Table within KFS Ferreira Capital JamesKlaben@uconnMatthewGrimm@uconn Ferreira courtney.wiley@uconn

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	Phone
Capital Assets - UConn	Asset Global, Asset Retirement Global	Create many edocs with a .csv upload	Daily Batch	Inbound	Dave Ferreira	Capital Assets	d avid.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	d avid.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
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@uconnKathy Avery	Technical Support -ITS	kathy.avery@uconn.edu	860-486546-30159651
Barcode Upload (Asset Panda)	Update Asset record with scanned information	Daily	Inbound	Dave	Ferreira	Capital Assets	d avid.ferreira@uconn.edu	860-486-0940
				Richard Ritchie	Technical Lead - ITS Financial Systems	richard.ritchie@uconn.edu	860-486-2837	CIDER	Billing Collector File	Daily	Inbound	Courtney Wiley	Administrator

.

7984joseph.oshea@uconn

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	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-	Joey O'Shea	Developer	3778
				Brett Paulson	Manager Financial Systems	brett.paulson@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@uconn486-9364

.

2837brett.paulson@uconn486-9364 API Lindemann Concur

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	Phone
CIDER	Billing Collector File	Daily	Inbound	Courtney Wiley	Administrator	courtney.wiley@uconn.edu	860-486-	Brett Paulson	Manager Financial Systems	7984
				Joey O'Shea	Developer	joseph.oshea@uconn.edu	860-	679-8144
	Chart of Accounts Inquiry, Account Balance	Inquiry	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

.

...

.

...

.

JamesKlaben@uconn

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	Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	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
	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	Jamesjames.Klaben@uconnklaben@uconn.edu	860-486-3778

.

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	Phone
FoodPro (uses Aurora)	Billing Collector File

Weekly

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

FoodPro (uses Aurora)


	Disbursement Voucher .csv

Daily

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

.

Jaggaer

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	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

.

...

.

...

.

External SystemDescription Inbound

Vendor	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 Document Numbers

Collector Flat File Directories

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

ACH Table Load

Integration Object	Frequency	Direction	Business Contact	Role	Email	Phone
Page-Up - Recruiting Solutions	Account Import, Appointment Import, Business Unit Import, Primary Team Import	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

.

ConcurTravel ApplicationPaul MoranoTechnical Support

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	Phone

Accounts ReceivableCustomer Load MonthlyInbound to KFS

Carleen Wells

Angela Piela

Nicole Kulig

Assistant Finance Director

Administrative Services

Functional Staff

carleen.wells@uconn.edu

angela.piela@uconn.edu

nicole.kulig@uconn.edu

860-486-3335

860-486-5995

860-486-0588

Accounts ReceivableInvoices Monthly Inbound to KFS

Carleen Wells

Angela Piela

Nicole Kulig

Assistant Finance Director

Administrative Services

Functional Staff

carleen.wells@uconn.edu

angela.piela@uconn.edu

nicole.kulig@uconn.edu

860-486-3335

860-486-5995

860-486-0588

BottomLine Check & ACHCheck and ACH payments to PayBase DailyOutbound from KFSBrett PaulsonManager Finance Systemsbrett.paulson@uconn.edu860-486-9364Check ReconciliationReconcile all bank checks plus Student Financial checksMonthlyInbound to KFSBrett PaulsonManager Finance Systemsbrett.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

bruce.lindemann@uconn.edu

brett.paulson@uconn.edu

860-486-0531

860-486-9364

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	Direction	Business Contact	Role	Email	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 (

Mastercard and Concur

)

Credit Card Transactions

Daily (Mon-Sat) Inbound

Services

Validation and Reallocation

Daily

Inbound

Nancy Patrylak

Elise Fiorentino

Procurement Card Administrator

Nancy.Patrylak@uconn.edu	860-486-2622
				Elise Fiorentino	Procurement Card Administrator	Elise.Fiorentino@uconn.edu

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

kathy.avery@uconn.edu

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

Vendor	Integration Object	Frequency	Direction	Business Contact	Role	Email	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	Email	Phone
Unifier	Capital Projects - Chart of Accounts, requisitions, Purchase Orders, Amendments, and Electronic Invoice

Daily

Inbound/

Outbound

Technical Support

richard

Outbound

Richard Ritchie

Technical Lead - ITS Financial Systems

Richard.ritchie@uconn.edu

860-486-2837

GENESYS<==>KFS Interfaces (OBSOLETE) - Feed is now from Core-CT

External SystemDescription

.

Vendor	Integration Object	Frequency	Direction

Business

Business Contact	Role	Email	Phone

GENESYS<==>KFS

Interfaces

See each Interface for details.

Varies - see detail.

Inbound/

Outbound

Kelly Wihbey

Brett Paulson

Richard Ritchie

KFS SME:

Budget Office

Manager Finance Systems

Technical Support:

kelly.wihbey@uconn.edu

brett.paulson@UConn.edu

richard.ritchie@uconn

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	Email	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-

0532

0531
				James Klaben	Finance Systems Business Analyst	james.klaben@uconn.edu	860-486-

9364

3778
				Brett Paulson	Manager Finance Systems	brett.paulson@uconn.edu	860-486-

2837

9364

.

Student Administration (SA) - Student Financials Interfaces

External System

Vendor

Description

Integration Object

Frequency

Frequency	Direction

Business

Business Contact

Role

Role	Email

Phone

PeopleSoft Student Financials

Student Receipts,

Payment Distribution,

Student Disbursements

Student Refund

Checks

Daily

Daily (Sun-Sat)

Monthly (On request)

Inbound

Kelly Shedd

Tanya Osuba

Naomi McKenna

Bruce Kwon

Kathy Avery

Other contacts as above.

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:

UITS kelly.shedd@uconn

ITS SA-Student Financials

Technical Support: UITS KFS Support

bruce.kwon@uconn.edu

tanya.osuba@uconn.edu

naomi.mckenna@uconn.edu

bruce.kwon@uconn.edu

kathy.avery@uconn

860-486-2539

.

GENESYS<==>KFS Interfaces - Feed is now from Core-CT

External System

Description

Frequency

Direction

Business

Contact

Role

Email

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-

5070

0532
				Brett Paulson	Manager Finance Systems	brett.paulson@UConn.edu	860-486-

9208

860-486-2819

860-486-2539

9364
				Richard Ritchie	Technical Lead - ITS Financial Systems	Richard.ritchie@uconn.edu	860-486-

1418

2837

Page Comparison

Versions Compared

Key

Table of ContentsmaxLevel8

Billing Files

Disbursement Voucher Files

Original ProCard(Mastercard) Processing

Billing Files

Disbursement Voucher Files

Other File Interfaces

GENESYS<==>KFS Interfaces (OBSOLETE) - Feed is now from Core-CT

GENESYS<==>KFS Interfaces - Feed is now from Core-CT

Table of Contents
maxLevel 8