Versions Compared

Old Version 47

changes.mady.by.user Kathleen Avery

Saved on

compared with

New Version Current

changes.mady.by.user Kathleen Avery

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Billing Files

Collector File Format

Collector File Document Numbers

Collector Flat File Directories

Collector mapping - generic

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

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


Dailycourtney.wiley@uconn.edu7984joseph.oshea@uconnrichard.ritchie@uconn2837brett.paulson@uconn9364bruce.lindemann@uconn
Vendor Integration ObjectFrequency DirectionBusiness ContactRoleEmailPhoneCIDERBilling Collector File
Accounts Receivable

Customer Load,

Invoices

MonthlyInboundCourtney WileyAdministratorAngela PielaAdministrative Servicesangela.piela@uconn.edu 860-486-Joey O'SheaDeveloper5995




Dan LisAccounts Receivable Supervisordaniel.lis@uconn.edu860-679-8144Account APIDailyInbound/OutboundBruce LindemannBusiness Analystbruce.lindemann@uconn486-3335




Hayley HesseManager - AR, Cash Opshayley.hesse@uconn.edu860-486-1676




Nicole KuligManager - AR, Cash Opsnicole.kulig@uconn.edu860-486-05310588Richard RitchieTechnical Lead




Vickie Weidig  Pathobiologyvickie.weidig@uconn.edu860-486-5014Brett PaulsonManager Financial Systems




Jeff PasiukParking Servicesjeffrey.pasiuk@uconn.edu860-486-Account Balance APIDailyInbound/OutboundBruce Lindemann Business Analyst5204

.

.

.

0531Richard Ritchie Leadrichard.ritchie@uconn2837
VendorIntegration ObjectFrequency DirectionBusiness ContactRoleEmailPhone

ACH Table Load

 Auto Load the ACH Payee Table from Payroll extract file provided by Core-CT Bi-Weekly (Paycheck week)InboundDan WarrenDirector-Accounts Payabledaniel.warren@uconn.edu860-486-1654




Keerthi ChamalaTechnical Support -  ITS ETLkeerthi.chamala@uconn.edu860-486-1031




Brett PaulsonManager Richard RitchieTechnical Lead - ITS Financial Systemsbrettrichard.paulson@uconnritchie@uconn.edu860-486-93642837

.

...

.

...

.

InboundConcurConnected ListInbound
VendorIntegration ObjectFrequencyDirectionConcurCost Object ApproversInboundConcurChart of AccountsInboundConcurValidation TableInboundConcurStandard Accounting ExtractOutboundConcurDeclining Balance Card UsersOutboundConcurTravel Insurance UsersOutboundJaggaerCustom Field ExportRealtimeInbound  JaggaerInvoice Status ExportRealtimeInboundJaggaerUpdate LDAP RolesRealtimeInboundJaggaerUser ExportRealtimeInboundJaggaerInvoice Import - includes Payment Requests, Credit Memos, and Disbursement VouchersRealtimeOutboundJaggaerPurchase Order Import - includes Purchase Orders and Purchase Order AmendmentsRealtimeOutboundJaggaerRequisition ValidationRealtimeOutboundJaggaerSupplier SyncRealtimeOutbound

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

External SystemBusiness ContactRoleEmailPhone
Capital Assets - UConn

Asset Global,

Asset Retirement Global

Daily BatchInboundDave FerreiraCapital Assetsdavid.ferreira@uconn.edu860-486-0940




Richard RitchieTechnical Lead - ITS Financial Systemsrichard.ritchie@uconn.edu860-486-2837
Asset Inventory Management(AIM) - System of Record

Building Updates (Building),

Room Updates (Room)

Batch - WeeklyInboundDave FerreiraCapital Assetsdavid.ferreira@uconn.edu860-486-0940




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-3778




Matt GrimmTechnical Support AIM - ITSmatthew.grimm@uconn.edu860-486-3015




Kathy AveryTechnical Support -ITSkathy.avery@uconn.edu860-546-9651
Barcode Upload (Asset Panda)Update Asset record with scanned informationDailyInboundDave FerreiraCapital Assetsdavid.ferreira@uconn.edu860-486-0940




Richard RitchieTechnical Lead - ITS Financial Systemsrichard.ritchie@uconn.edu860-486-2837

.

.

.

CIDER to KFS

courtney.wiley@uconn.edu

joseph.oshea@uconn

gayle.meisner@uconn.edu 

james.chabot-weingart@uconn
VendorIntegration ObjectFrequencyDirectionBusiness ContactRole RoleEmail Email PhonePhone
Check Reconciliation (Bank of America)Reconcile all bank checks plus Student Financial checksMonthlyInbound

Courtney Wiley

Joey O'Shea

Admin

Developer

James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-3778




Brett PaulsonManager Financial Systemsbrett.paulson@uconn.edu860-486-7984

860-679-8144

FoodPro (uses Aurora Software)

Weekly (Wednesday)Inbound to KFS

Gayle Meisner

James Chabot-Weingart

Dining Services Area Manager

Technical Support

9364

.

.

.

Danielle Farrands 

Ruben Mercado

Vendor Integration ObjectFrequency DirectionBusiness ContactRoleEmailPhone
CIDERBilling Collector FileDailyInboundCourtney WileyAdministratorcourtney.wiley@uconn.edu860-486-9467 7984




Joey O'SheaDeveloperjoseph.oshea@uconn.edu860-486-4559Pinnacle (uses Calero)Monthly (end of month)Inbound to KFS

Pinnacle Support - UITS/Business Office 

Technical Support - UITS/EAS

danielle.farrands@uconn.edu 

ruben.mercado@uconn.679-8144

Chart of Accounts Inquiry,

 Account Balance Inquiry


DailyInbound/OutboundBruce LindemannFinance Systems Business Analystbruce.lindemann@uconn.edu860-486-0531




Richard RitchieTechnical Lead - ITS Financial Systemsrichard.ritchie@uconn.edu860-486-01212837

  

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




Brett PaulsonManager Financial Systemsbrett.paulson@uconn.edu860-486-9364

.

.

.

External SystemDescription Frequency

ellen.prairie@uconn.edu

stephanie.kernozicky@uconn.edu

james.chabot-weingart@uconn3129

860-486-3129

860-486-4559

Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone

Facilities (Utilities) + ResLife (Utilities)

Monthly

Inbound to KFS

Terri Richard

Brett Paulson

Tia Shackett

Accounts Payable

Manager Finance Systems

Administrative Assistant

terri.richard@uconn.edu

brett.paulson@uconn.edu

tia.Shackett@uconn.edu

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

gayle.meisner@uconn.edu

james.chabot-weingart@uconn.edu

860-486-9467

860-486-4559

Husky-One (OneCard)

Weekly

Inbound to KFS

Elly Prairie

Stephanie Kernozicky

James Chabot-Weingart

OneCard Supervisor

OneCard Manager

Technical Support

Department of Revenue Services - CTVendor List to DRSFeb 15, May 15, Aug 15, Nov 15OutboundChristine NobileAccounts PayableChristine.nobile@uconn.edu860-486-1641




Cary M. PaulTax Hearings OfficerCary.Paul@po.state.ct.us860-297-5974




Gary CyrTax Managergary.cyr@po.state.ct.us860-297-5623




Kevin KennedyOperations Supervisorkevin.kennedy@po.state.ct.us860-297-5763




Phil SoucyIT Supervisorphil.soucy@po.state.ct.us860-297-7518




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-

Law Library (uses Millenium software) 

Daily 

Inbound to KFS 

Elisabeth Umpleby

Ricardo Mardales 

Librarian Law School

Technical Support 

elisabeth.umpleby@uconn.edu

ricardo.mardales@uconn.edu 

860-570-5007

860-570-5233 

 TravelBi-weekly Inbound to KFS 

Leshonda Owens

Dan Warren

Accounts Payable - Travel

Director-Accounts Payable

leshonda.owens@uconn.edu

Daniel.Warren@uconn.edu

860-486-1647Image Removed
860-486-1654 

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

ACH Table Load

3778

Delinquent vendors from DRSmid-Jan, mid-Apr, mid-July, mid-OctInboundChristine NobileAccounts PayableChristine.nobile@uconn.edu860-486-1641




Cary M. PaulTax Hearings OfficerCary.Paul@po.state.ct.us860-297-5974




Gary CyrTax Managergary.cyr@po.state.ct.us860-297-5623




Kevin KennedyOperations Supervisorkevin.kennedy@po.state.ct.us860-297-5763




Phil SoucyIT Supervisorphil.soucy@po.state.ct.us860-297-7518




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-3778

.

.

.

860-486-3335

860-486-5995
VendorIntegration ObjectFrequency DirectionBusiness ContactRoleEmailPhone
 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

FoodPro (uses Aurora)Billing Collector FileDailyInboundGayle MeisnerDining Services Area Managergayle.meisner@uconn.edu 860-486-9467




James Chabot-WeingartSAIT Technical Supportjames.chabot-weingart@uconn.edu860-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

 
4559

Disbursement Voucher .csvWeeklyInboundGayle MeisnerDining Services Area Managergayle.meisner@uconn.edu860-486-
3335
9467
860-486-5995




James Chabot-WeingartSAIT Technical Supportjames.chabot-weingart@uconn.edu860-486-
0588  ACH Table Load Auto Load the ACH Payee Table from Payroll extract file  Bi-Weekly (Paycheck week) Inbound Dan Warren

Keerthi Chamala

Kathy Avery

Director-Accounts Payable

Technical Support: UITS Datastage Support

Technical Support: UITS KFS Support

Daniel.Warren@uconn.edu

Keerthi.chamala@uconn.edu

kathy.avery@uconn
4559

.

.

.

Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
Husky-One (OneCard)Disbursement Voucher .csvWeeklyInboundStephanie KernozickyOneCard Managerstephanie.kernozicky@uconn.edu860-486-
1654
3129




Jeanette Jamieson
jeanette.jamieson@uconn.edu860-486-
0669 
3129
860-486-1031




James Chabot-WeingartSAIT Technical Supportjames.chabot-weingart@uconn.edu860-486-
1418Asset Inventory Management(AIM) - System of Record

Update Building Table within KFS

Update Room Table within KFS

Dave Ferreira

James Klaben

Matt Grimm

Kathy Avery

AIM Subject Matter Expert 

Business Analyst

Technical Support: UITS for AIM

Technical Support: UITS KFS Support

david.ferreira@uconn.edu

James.Klaben@uconn.edu

Matthew.Grimm@uconn.edu

Kathy.avery@uconn
4559

.

.

.

Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
Page-Up - Recruiting Solutions

Account Import,

Appointment Import,

Business Unit Import,

Primary Team Import

DailyOutboundShannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-
0940

860-486-

860-486-

david.ferreira@uconn.edu 

richard.ritchie@uconn
3778




Kathy AveryTechnical Support - ITSkathy.avery@uconn.edu860-486-1418
Asset Global Upload Create many Asset Global eDocs at one timeOn request Inbound to KFS 

Dave Ferreira 

Richard Ritchie

Capital Asset Subject Matter Expert 

Technical Support


User ImportDailyOutboundDylan MarquisTechnical Support - ITS LDAPDylan.Marquis@uconn.edu860-486-
0940Image Removed 
9458




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-
2837Image RemovedBarcode Upload (Asset Panda)Update Asset record with scanned informationDaily Inbound to KFS 

Dave Ferreira 

Richard Ritchie

  Capital Asset Subject Matter Expert 

Technical Support

david.ferreira@uconn.edu 

richard.ritchie@uconn.edu

 860-486-0940 
3778

Fire/Police Import,

AJO Import,

Math Import

Twice Daily
Shannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-3778




Richard RitchieTechnical Lead - ITS Financial Systemsrichard.ritchie@uconn.edu860-486-2837

.

.

...

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

...

.

Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
Pinnacle (uses Calero)Telecom Billing Collector Files (Storrs+Branch)Batch-MonthlyInboundDanielle FarrandsPinnacle Support - ITS/Business Officedanielle.farrands@uconn.edu 860-486-0121




Ruben MercadoTechnical Support - ITS/EASruben.mercado@uconn.edu

.

.

.

860-297-5763

860-297-7518

860-297-5623

MasterCard (Concur)

 Credit Card Transactions

 Daily (Mon-Sat) Inbound

Nancy Patrylak

Elise Fiorentino

Procurement Card Administrator
Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
Travel - Concur Solutions

Standard Accounting Extract,

Declining Balance Card Users,

Travel Insurance Users


OutboundGarrett HeinzeAssistant Director, Procurement Systemsheinze@uchc.edu860.335.6782




Paul MoranoTechnical Support - ITSpaul.morano@uconn.edu860-486-2336
Dept. of Revenue Services - State of CT

Vendor List to DRS

Delinquent vendors from DRS

(Vendor Offset List)

Feb 15, May 15, Aug 15, Nov 15

mid-Jan, mid-Apr, mid-July, mid-Oct

Outbound from KFS

Inbound to KFS

Kevin Kennedy

Phil Soucy

Gary Cyr

Karen Straut

Supervisor

IT Supervisor

Tax Manager

kevin.kennedy@po.state.ct.us

phil.soucy@po.state.ct.us

gary.cyr@po.state.ct.us

karen.straut@po.state.ct.us

Travel - Concur Solutions

Employee,

Connected List,

Cost Object Approvers,

Chart of Accounts,

Validation Table


OutboundGarrett HeinzeAssistant Director, Procurement Systemsheinze@uchc.edu860.335.6782




Paul MoranoTechnical Support - ITSpaul.morano@uconn.edu860-486-2336
Mastercard and Concur ServicesValidation and ReallocationDailyInboundNancy PatrylakProcurement Card AdministratorNancy.Patrylak@uconn.edu860-486-2622




Elise FiorentinoProcurement Card AdministratorElise.Fiorentino@uconn.edu
860-486-2622
860-486-5924
PageUp

Recruiting Solutions:

Account Import

Appointment Import

Business Unit Import

Primary Team Import

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 ObjectFrequency DirectionBusiness ContactRoleEmailPhone
JaggaerCustom Field ExportRealtimeInbound



JaggaerInvoice Status ExportRealtimeInbound



JaggaerUpdate LDAP RolesRealtimeInbound



JaggaerUser ExportRealtimeInbound



JaggaerInvoice Import - includes Payment Requests, Credit Memos, and Disbursement VouchersRealtimeOutboundGarrett HeinzeAssistant Director, Procurement Systemsheinze@uchc.edu860.335.6782
JaggaerPurchase Order Import - includes Purchase Orders and Purchase Order AmendmentsRealtimeOutboundGarrett HeinzeAssistant Director, Procurement Systemsheinze@uchc.edu860.335.6782
JaggaerRequisition ValidationRealtimeOutbound



JaggaerSupplier SyncRealtimeOutbound



.

.

.


Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
UnifierCapital Projects - Chart of Accounts, requisitions, Purchase Orders, Amendments, and Electronic Invoice 
Daily 
DailyInbound/
Outbound  

Technical Support

 richard
OutboundRichard Ritchie
 
Technical Lead - ITS Financial SystemsRichard.ritchie@uconn.edu
 
860-486-2837
 

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

External SystemDescription           

.

.

.

VendorIntegration ObjectFrequencyDirection

Business       

Business ContactRoleEmailPhone

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
UtilitiesFacilities + ResLife - Disbursement VouchersBatch- MonthlyInboundTia ShackettAdministrative Assistanttia.Shackett@uconn.edu860-486-5436

.

.

.

External SystemDescription FrequencyDirectionBusiness ContactRoleEmailPhone
BottomLine Check & ACHCheck and ACH payments to PayBaseDailyOutbound from KFSBrett PaulsonManager Finance Systemsbrett.paulson@uconn.edu860-486-9364
Centrally Funded CBIBudget ConstructionOn RequestInbound to KFSBruce LindemannFinance Systems Business Analystbruce.lindemann@uconn.edu860-486-
0532
0531




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-
9364
3778




Brett PaulsonManager Finance Systems brett.paulson@uconn.edu 860-486-
2837
9364

.

.

.

Student Administration (SA) - Student Financials Interfaces

External           System
Vendor
Description 
Integration Object
Frequency       
FrequencyDirection
Business              
Business Contact
Role                       
RoleEmail
Phone              
Phone
PeopleSoft Student Financials

Student Receipts,

Payment Distribution,

Student Disbursements

Student Refund

Checks

 Daily
Daily (Sun-Sat)

Monthly (On request)

  Inbound

Inbound

 Kelly Shedd

Tanya Osuba

Naomi McKenna

Bruce Kwon

Kathy Avery

Other contacts as above.
 InboundKelly Shedd

KFS SME:

Bursar's Office

kelly.shedd@uconn.edu860-486- 5070




Tanya Osuba

KFS SME:

Bursar's Office

tanya.osuba@uconn.edu860-486-9208




Naomi McKennaKFS SME - Financial Aidnaomi.mckenna@uconn.edu860-486-2819

Student Refund

Checks

Monthly (On request)InboundBruce KwonTechnical Support:
UITS
ITS SA-Student Financials

Technical Support: UITS KFS Support

 kelly.shedd@uconn.edu

tanya.osuba@uconn.edu

naomi.mckenna@uconn.edu

bruce.kwon@uconn.edu

kathy.avery@uconn
bruce.kwon@uconn.edu860-486-2539








.

.

.

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

External SystemDescriptionFrequencyDirection

Business       

Contact

RoleEmailPhone
Core-CTSee each Interface for details.Varies - see detail.  

Inbound/

Outbound

Kelly Wihbey

KFS  SME:                       

Budget Office 

kelly.wihbey@uconn.edu860-486-
 5070
0532




Brett PaulsonManager Finance Systems brett.paulson@UConn.edu860-486-
9208

860-486-2819

860-486-2539

  
9364 




Richard RitchieTechnical Lead - ITS Financial SystemsRichard.ritchie@uconn.edu860-486-
1418
2837