Copy of Application Inventory of Integrations


Integration

Name

Producer

Consumer(s)TechnologyData TypeRead/Write

Frequency

(required/actual)

When implementedNotesCaptured
PS_UC_CTO_STDNT_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of All Students?✓
PS_UC_CTO_CLASS_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of Courses✓
PS_UC_CTO_FEE_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of Fees✓
PS_UC_CTO_WSDTS_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of Work Study Dates✓
PS_UC_CTO_PKDED_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of Parking Deductions✓
PS_UC_CTO_INSTR_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of Instructor and Courses✓
PS_UC_CTO_WSTDY_VWStudent AdminCoreCToracle view

db link

Read
Sept 2016*SA to verify View of Work Study Awards✓
Employee IDS/CORECT FeedIdentity ManagementKFSREST ServiceXML
Daily Batch3rd QTR 2019Created for Concur Integrations.✓
Expense validation notificationCONCURKFSREST ServiceXML
Real-Time3rd QTR 2019
✓
KFS Concur file exports (Employee, Connected List, Cost Object Approvers, Chart of Accounts, Validation Table)KFSCONCURSFTP

CSV with pgp encryption


Daily Batch3rd QTR 2019
✓
Concur File Exports (Standard Accounting Extract, Declining Balance Card Users, Travel Insurance Users)CONCURKFSSFTPCSV with pgp encryption
Daily Batch3rd QTR 2019
✓
Custom Field ExportKFSJaggaerJava REST serviceXML
Daily BatchJuly 2018


✓
Invoice Status ExportKFSJaggaerJava REST serviceXML
Daily BatchJuly 2018


✓
Update LDAP RolesKFSJaggaerJava REST serviceXML
Daily BatchJuly 2018


✓
User ExportKFSJaggaerJava REST serviceXML
Daily BatchJuly 2018


✓
Invoice ImportJaggaerKFSWeb ServiceXML
Real-TimeJuly 2018


✓
Purchase Order ImportJaggaerKFSWeb ServiceXML
Real-TimeJuly 2018


✓
Requisition ValidationJaggaerKFSWeb ServiceXML
Real-TimeJuly 2018


✓
Supplier SyncJaggaerKFSWeb ServiceXML
Real-TimeJuly 2018


✓
invoiceInquiryKFS







chartOfAccountsInquiryKFS







kfsAcctInfoServiceKFS







uconnLdapServiceKFS







accountBalanceInquiryKFS







vendorInquiryKFS







workFlowsWsServiceKFS







ucMudOrgWsServiceKFS







invoiceInquiry, chartOfAccountsInquiry, kfsAcctInfoService, uconnLdapService, accountBalanceInquiry, vendorInquiry, workFlowWsService, 

ucMudOrgWsService

KFSUnifier, AiM, CIDER, DTW, FEBJava, TomcatSOAP, XMLBoth, ReadReal-time2015-2017
✓
Billing,  Other "Collector" FilesKFSFoodPro, Pinnacle, Public Safety Locksmith, Facilities + ResLife, Husky-One (OneCard), Law Library, TravelJavaFTP, CSV, flat file
Batch
2012
✓
Disbursement Voucher uploadsKFS FoodPro, Pinnacle, Facilities + ResLife, Husky-One (OneCard), Travel JavaFTP, CSV, XML 
Batch 2012 - 2013 
✓
Customers and Customer Invoice uploadsKFS  LIMS (Patho lab), TicketPro (Parking) JavaFTP, CSV, XML 
Batch 2012? 

Student Receipts, Payment Distribution, Student Disbursements, Student Refund, Checks

KFSPeopleSoft Student FinancialsJavaFTP, CSV, XML
Batch2015?

ACHKFSCore-CT
Direct table load via ETL (Datastage)
Batch2015update of ACH info for Payees
Check & ACHBottomLineKFS
FTP, CSVBothBatch2015BottomLine transmits to Bank of America
Check ReconciliationBank of America KFS  JavaFlat file 
Batch 


 Pro-Card transactions JP Morgan-ChaseKFS  JavaFTP, flat file 
Batch 


Vendor List, Delinquent VendorsDept. of Revenue ServicesKFS / Jaggaer
FTP, flat file
Batch2012 - 2018

Asset upload, Asset Retirement uploadAsset Panda KFS 
FTP, CSV 
Batch 2012 - rev 2018 

Buildings, Floors and RoomsIWMSMeridianMS SQLMS SQLReadDaily2018MS SQL Stored Procedures
Purchase Request, Purchase Order AmendmentUnifierJaggaerC# .NETSOAP, RESTBothReal-TimeJuly 2018

Purchase Request Acknowledgement, Purchase Order, Change OrderJaggaerUnifierC# .NETSOAP, RESTBothReal-TimeJuly 2018

AiM RestAPIAiMConsumers (FEB, NetENG, OTE, etc.)PHPRESTReadReal-TimeOct 2017

Unifier RestAPIUnifierFEBPHPSOAP, RESTBothReal-TimeOct 2018

Purchase Order, Purchase Order AmendmentJaggaerAiMJavaSOAP, XMLBothReal-TimeJuly 2018

Purchase RequestAiMJaggaerJavaSOAP, XMLBothReal-TimeJuly 2018

Facilities InvoicesKFSAiMJavaSOAP, XMLReadDailyApril 2018

Chart of AccountsKFSAiMETL, Data StageSOAP, XMLReadWeeklyNov 2017

OrganizationsKFDMAiMETL, Data StageSOAP, XMLReadWeeklyNov 2017

EmployeesCoreCTAiMETL, Data StageSOAP, XMLReadWeeklyNov 2017

Contractor/VendorsKFSAiMETL, Data StageSOAP, XMLReadWeeklyNov 2017

Work Study BalancesCoreCTSAoracle viewdb link
Read
Real-TimeSept 2016

GA dataCoreCTSAoracle viewdb linkReadReal-TimeSept 2016

KFS Chart of Accounts InboundKFSCoreCTjava

flat file


Read

daily

Sept 2016

KFS Encumbrance Balances InboundKFSCoreCTjavaflat fileReaddailySept 2016

KFS Fiscal Period InboundKFSCoreCTjavaflat fileReaddailySept 2016

UOC Payroll Integration Outbound - Salary Expense (Actuals)CoreCTKFSPeoplesoft App Engineflat fileReadbi-weeklySept 2016

UOC Payroll Integration Outbound - GL Cash (collector)CoreCTKFSPeoplesoft App Engineflat fileReadbi-weeklySept 2016

UOC Payroll Integration Outbound - Encumbrance LiquidationsCoreCTKFSPeoplesoft App Engineflat fileReadbi-weeklySept 2016

UOC Payroll Integration Outbound - Accruals (Actuals)CoreCTKFSPeoplesoft App Engineflat fileReadbi-weeklySept 2016

UOC Payroll Integration Outbound - Accrual EncumbrancesCoreCT
KFS
Peoplesoft App Engineflat fileReadbi-weeklySept 2016

Encumbrance Adjustments OutboundCoreCT
KFS
Peoplesoft App Engineflat fileReadbi-weeklySept 2016

Position Interface OutboundCoreCTKFSPeoplesoft App Engineflat file
Read
?Sept 2016

activeStudents-CT_ACTV_STUD_VWCoreCTSA
oracle view

db link

ReadReal-TimeSept 2016

adjunctCourseInfo-CT_COURSE_CR_VWCoreCTSAoracle viewdb linkReadReal-TimeSept 2016

employeeData-CT_EMP_DATA_VWCoreCTRecruiting Solutions, ID Systemoracle viewdb linkReadReal-TimeSept 2016

EmployeeData2-CT_EMPL_DATA_VWCoreCTRecruiting Solutions, ID Systemoracle viewdb linkReadReal-TimeSept 2016

configFlatTree-CT_FLAT_TREE_VWCoreCTRecruiting Solutions, ID Systemoracle viewdb linkReadReal-TimeSept 2016

gradDeductions-CT_GRAD_DEDN_VWCoreCTSAoracle viewdb linkReadReal-TimeSept 2016

prkgDedns-CT_PRKG_DEDN_VWCoreCTParkingoracle viewdb linkReadReal-TimeSept 2016

prkgEmpls-CT_PRKG_EMPL_VWCoreCTParkingoracle viewdb linkReadReal-TimeSept 2016

diningStudentinfo-CT_STUD_DS_VWCoreCTDining Servicesoracle viewdb linkReadReal-TimeSept 2016

employeeTBHData-CT_TBH_DTA_VWCoreCTID systemoracle viewdb linkReadReal-TimeSept 2016

FootprintsFootprintsCentral CalendarCalendar.sh/sqlCSVRead4 times day

12/1/2014



FootprintsFootprintsITS Status Pagefeeds.sh/sqlCSVReadevery 3 min4/1/2015

PinnacleWindstreamPinnaclesftp_get_windstream_csv_v65.sh/sftpcsvread/writemonthly12/1/2014

PinnaclePinnacleE911daily_911_pinn651.sh/perlcard columnreaddaily7/20/2009

PinnaclePinnacleFTP Server (Telecomm)run_get_daily_acus.sh/perlcard columnreaddaily7/31/2007

PinnaclePinnacleFTP Server (sa.uconn.edu)process_reslife_locations.sh/SQLcsvreaddaily9/20/2002

SADMPeopleSoft(- Student Financials, Student Records, Admissions)MultipleDatastageExadataReadDaily(Sunday-Friday)Jan 2019

KFDMKFS,LDAP,CoreCT,Active DirectoryMultipleDatastageOracle DBReadDaily


Student PayrollLocal Time Card SystemCoreCTDataStageXMLReadFriday (Payweek 11:30am)


HR-Payroll DatamartCoreCT, Recruiting Solution,KFDM, LDAP, Active Directory,MultipleOracle Data Integrator(ODI)ExadataReadDaily2017



uchc_employees_hrs0031d.txtUCH BannerID SystemBanner, Python, PostgresFixed-width fileReadDaily2016Employee information from Banner HR system
uchc_employees_ssn_change.txtUCH BannerID SystemBanner, Python, PostgresFixed-width fileReadDaily2016

SSN Changes from Banner HR system


StudentAffiliateEmployee.gpgUCH FIMID SystemMicrosoft FIMDelimited FileReadDaily2016UCH student, resident and affiliate information
usre052_honors.txtStudent AdminID SystemPeoplesoft CS, Python, PostgresFixed-width fileReadDaily2016Honors student information
usre052_hscoop.txtStudent AdminID SystemPeoplesoft CS, Python, PostgresFixed-width fileReadDaily2016High school co-op instructors
usre052_adjnct.txtStudent AdminID SystemPeoplesoft CS, Python, PostgresFixed-width fileReadDaily2016Adjunct Faculty
usre055_studnt.txtStudent AdminID SystemPeoplesoft CS, Python, PostgresFixed-width fileReadDaily2016Student Identity Information
usre057_ssnchg.txtStudent AdminID SystemPeoplesoft CS, Python, PostgresFixed-width fileReadDaily2016Student SSN changes
SA_Affiliates_NetID_To_UITS.txtSAITID System Python, PostgresFixed-width fileReadDaily2016Dining Affiliates
stu_room_phone.txtITS TelecomID SystemPython, PostgresFixed-width fileReadDaily2016Student dorm telephone number information
uatucid.ftpucid.ucfafflUConn FoundationID SystemPython, PostgresFixed-width fileReadDaily2016Foundation Affiliates
NetID_sis_hr_user_info.txtStudent AdminID SystemPeoplesoft CS, Python, PostgresDelimited FileReadDaily2017TerraDotta international student information
NetID_list*.csvUCH Faculty AffairsID SystemFilemaker, Python, PostgresDelimited FileReadDaily2018UCH Affiliate Faculty
onecardpatrondata.csvSAIT OneCardID SystemPython, PostgresDelimited FileReadDaily2016OneCard magstrip and prox card information
UAPUCID.FTPUCID.UITSAFFLAffiliate FormID SystemPHP, Python, PostgresFixed-width fileReadDaily2016Affiliate information from the affiliate form
Patron ApplicationPatron ApplicationID SystemPython, PostgresPostgres TableReadDaily2017Affiliate information from the patron application
DEPARTMENT_FLAT_TREEID SystemOracle TablePython, Postgres, OracleOracle TableWriteDaily2017Department information for HR
PSUSEREMAIL, PS_EMAIL_ADDRESSESID SystemCorePython, Postgres, OracleOracle TableWriteDaily2016Core email update
PS_CT_NETID_TBLID SystemCorePython, Postgres, OracleOracle TableWriteDaily2016EMPLID to NetID mapping
uconnpeople.txtID SystemActive Directory, OpenLDAPActive Directory, OpenLDAP, Python, PostgresLDIFWriteDaily2016Directory Information for active NetIDs
sa_dining_affiliates.txtID SystemSAITPython, PostgresFixed-width fileWriteDaily2016Dining affiliate NetID information
sa_uconn_affiliates.txtID SystemSAITPython, PostgresFixed-width fileWriteDaily2016Affiliate NetID information
academic_listservID SystemListservPython, PostgresFixed-width fileWriteDaily2016Listserv list for students
foundation_listservID SystemListservPython, PostgresFixed-width fileWriteDaily2016Listserv list for foundation
employee_listservID SystemListservPython, PostgresFixed-width fileWriteDaily2016Listserv lists for employees
uchcnetids.txtID SystemUCH/BannerPython, PostgresFixed-width fileWriteDaily2016UCH NetID information
idemail.txtID SystemStudent AdminPython, PostgresFixed-width fileWriteDaily2016Email information for students
corect_to_saID SystemStudent AdminPython, Postgres, OracleFixed-width fileWriteDaily2016CoreCT duplicated tables
uchc_appointed_org_newID SystemBannerPython, PostgresFixed-width fileWriteDaily2016UCH NetID and identity information
ospfile.txtID SystemOVPRPython, PostgresFixed-width fileWriteDaily2016UCH identity information
lib_patrons.csvID SystemLibraryPython, PostgresDelimited FileWriteDaily2016Honors student information
jorgensen_ticketing.csvID SystemChoiceCRMPython, PostgresDelimited FileWriteDaily2016Active NetID and Affiliation information
unity_netid.csvID SystemUCH FIMPython, PostgresDelimited FileWriteDaily2016NetID to UAR ID mapping
SA.ISSSID SystemTerraDottaPython, PostgresDelimited FileWriteDaily2017Transformed international student and advisor information

SABA_storrs_person.txt,

SABA_storrs_org.txt,

SABA_storrs_job.txt

ID SystemSabaPython, PostgresDelimited FileWriteDaily2017File containing primary job and identity information for Saba training platform
uchc_affliate_faculty.csvID SystemUCH Faculty AdvisingPython, PostgresDelimited FileWriteDaily2018NetID to UCH affiliate faculty ID