Versions Compared

Old Version 53

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


Vendor Integration ObjectFrequency DirectionBusiness ContactRoleEmailPhone
Accounts Receivable

Customer Load,

Invoices

MonthlyInboundAngela PielaAdministrative Servicesangela.piela@uconn.edu 860-486-5995




Dan LisAdministrative ServicesAccounts Receivable Supervisordaniel.lis@uconn.edu860-486-3335




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




Nicole KuligManager - AR, Cash Opsnicole.kulig@uconn.edu860-486-0588




Vickie Weidig  Pathobiologyvickie.weidig@uconn.edu860-486-5014




Jeff PasiukParking Servicesjeffrey.pasiuk@uconn.edu860-486-5204

.

.

.

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




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

.

.

.

VendorIntegration ObjectFrequencyDirectionBusiness 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

.

.

.

VendorIntegration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
Check Reconciliation (Bank of America)Reconcile all bank checks plus Student Financial checksMonthlyInboundJames KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-3778




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

.

.

.

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




Joey O'SheaDeveloperjoseph.oshea@uconn.edu860-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-2837




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

.

.

.

Vendor Integration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
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-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

.

.

.

VendorIntegration ObjectFrequency DirectionBusiness ContactRoleEmailPhone
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-4559

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




James Chabot-WeingartSAIT Technical Supportjames.chabot-weingart@uconn.edu860-486-4559

.

.

.

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




Jeanette Jamieson
jeanette.jamieson@uconn.edu860-486-3129




James Chabot-WeingartSAIT Technical Supportjames.chabot-weingart@uconn.edu860-486-4559

.

.

.

Supplier SyncKathy.Avery@uconn1418Kathy AveryKathyAvery@uconn1418DailyJamesKlaben@uconnShannon.Page@uconn0410Kathy.Avery@uconn.edu
Vendor Integration ObjectFrequency FrequencyDirectionBusiness ContactRoleEmailPhoneConcurEmployeeInboundConcurConnected ListInboundConcurCost Object ApproversInboundConcurChart of AccountsInboundConcurValidation TableInboundConcurStandard Accounting ExtractOutboundConcurDeclining Balance Card UsersOutboundConcurTravel Insurance UsersOutboundJaggaerCustom Field ExportRealtimeInboundJaggaerInvoice Status ExportRealtimeInboundJaggaerUpdate LDAP RolesRealtimeInboundJaggaerUser ExportRealtimeInboundJaggaerInvoice Import - includes Payment Requests, Credit Memos, and Disbursement VouchersRealtimeOutboundJaggaerPurchase Order Import - includes Purchase Orders and Purchase Order AmendmentsRealtimeOutboundJaggaerRequisition ValidationRealtimeOutboundJaggaerRealtimeOutbound
Page-Up - Recruiting Solutions

Account Import,

Appointment Import,

Business Unit Import,

Primary Team Import

DailyOutboundKathy AveryTechnical Support - ITSShannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410




James KlabenFinance Systems Business AnalystJamesjames.Klaben@uconnklaben@uconn.edu860-486-3778




Shannon PageFunctional StaffShannon.Page@uconnKathy AveryTechnical Support - ITSkathy.avery@uconn.edu860-486-04101418Appointment

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




James KlabenFinance Systems Business AnalystJamesjames.Klaben@uconnklaben@uconn.edu860-486-3778

Fire/Police Import,

AJO Import,

Math Import

Twice Daily
Shannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410Business Unit ImportOutboundKathy Avery




Technical Support - ITSKathy.Avery@uconn.edu860-486-1418James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-3778Shannon PageFunctional Staff




Richard RitchieTechnical Lead - ITS Financial Systemsrichard.ritchie@uconn.edu860-486-Primary Team ImportDailyOutboundKathy AveryTechnical Support - ITS2837

.

.

.

1418
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-0121James KlabenFinance Systems Business AnalystJames.Klaben@uconn.edu860-486-3778Shannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410User ImportTwice DailyOutboundJames KlabenFinance Systems Business AnalystJames.Klaben@uconn.edu860-486-3778




Dylan MarquisLDAP Technical SupportDylan.Marquis@uconnRuben MercadoTechnical Support - ITS/EASruben.mercado@uconn.edu

.

.

.

2837
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-9458Shannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410Fire/Police ImportTwice DailyRich RitchieTechnical Leadrichard.ritchie@uconn.edu860-486-2837James KlabenFinance Systems Business AnalystJames.Klaben@uconn.edu860-486-3778Shannon PageFunctional StaffShannon.Page@uconn2336
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-0410AJO ImportTwice DailyRich RitchieTechnical Leadrichard.ritchie@uconn2336
Mastercard and Concur ServicesValidation and ReallocationDailyInboundNancy PatrylakProcurement Card AdministratorNancy.Patrylak@uconn.edu860-486-2622




James KlabenFinance Systems Business AnalystJames.Klaben@uconnElise FiorentinoProcurement Card AdministratorElise.Fiorentino@uconn.edu860-486-3778Shannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410Math ImportTwice DailyRich RitchieTechnical Leadrichard.ritchie@uconn.edu860-486-2837James KlabenFinance Systems Business AnalystJames.Klaben@uconn.edu860-486-3778Shannon PageFunctional StaffShannon.Page@uconn.edu860-486-0410
Pinnacle (uses Calero)Telecom Billing Files (Storrs+Branch)Batch-MonthlyInboundDanielle FarrandsPinnacle Support - ITS/Business Officedanielle.farrands@uconn.edu 860-486-0121
Ruben MercadoTechnical Support - ITS/EASruben.mercado@uconn.edu5924


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 DailyInbound/Outbound
Rich
Richard RitchieTechnical Lead - ITS Financial Systems
richard
Richard.ritchie@uconn.edu860-486-2837

.

.

.

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

ACH Table Load

.

.

.

External SystemDescription FrequencyDirectionBusiness 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

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 
PayBaseDailyOutbound from KFSBrett PaulsonManager Finance Systemsbrett.paulson@uconn.edu860-486-9364
Centrally Funded
CBI 
CBIBudget
Construction 
ConstructionOn
Request 
RequestInbound to
KFS 
KFSBruce Lindemann
Brett Paulson 
Finance Systems Business Analyst
Manager Finance Systems 
bruce.lindemann@uconn.edu

brett.paulson@uconn.edu 

860-486-0531




James KlabenFinance Systems Business Analystjames.klaben@uconn.edu860-486-
9364paul.morano@uconn.edu
3778
ConcurTravel ApplicationPaul MoranoTechnical Support




Brett PaulsonManager Finance Systems brett.paulson@uconn.edu 860-486-
2336 MasterCard (Concur)

 Credit Card Transactions

 Daily (Mon
9364

.

.

.

Student Administration (SA) - Student Financials Interfaces

VendorIntegration ObjectFrequencyDirectionBusiness ContactRoleEmailPhone
PeopleSoft Student Financials

Student Receipts,

Payment Distribution,

Student Disbursements

Daily (Sun-Sat) Inbound

Nancy Patrylak

Elise Fiorentino

Procurement Card Administrator

Procurement Card Administrator

Nancy.Patrylak@uconn.edu

Elise.Fiorentino@uconn
Kelly 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-
2622
2819

Student Refund

Checks

Monthly (On request)InboundBruce KwonTechnical Support: ITS SA-Student Financialsbruce.kwon@uconn.edu860-486-
5924
2539








.

.

.

GENESYS<==>KFS Interfaces

...

 - Feed is now from Core-CT

External System
Description           Interfaces
DescriptionFrequencyDirection

Business       

Contact

RoleEmailPhone

GENESYS<==>KFS

Core-CTSee 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.edu860-486-0532




Brett PaulsonManager Finance Systems brett.paulson@UConn.edu
 

richard.ritchie@uconn.edu

860-486
-0532860
-
486-
9364 

860-486-2837

Student Administration (SA) - Student Financials Interfaces

External           SystemDescription Frequency       DirectionBusiness               ContactRole                       EmailPhone              PeopleSoft Student Financials

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

 kelly.shedd@uconn.edu

tanya.osuba@uconn.edu

naomi.mckenna@uconn.edu

bruce.kwon@uconn.edu

kathy.avery@uconn.edu

860-486- 5070

860-486-9208

860-486-2819

860-486-2539

  

860-486-1418




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