Copy of Application Inventory of Integrations
- Richard Ritchie
Owned by Richard Ritchie
Integration Name | Producer | Consumer(s) | Technology | Data Type | Read/Write | Frequency (required/actual) | When implemented | Notes | Captured |
|---|---|---|---|---|---|---|---|---|---|
| PS_UC_CTO_STDNT_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of All Students? | ✓ | |
| PS_UC_CTO_CLASS_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of Courses | ✓ | |
| PS_UC_CTO_FEE_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of Fees | ✓ | |
| PS_UC_CTO_WSDTS_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of Work Study Dates | ✓ | |
| PS_UC_CTO_PKDED_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of Parking Deductions | ✓ | |
| PS_UC_CTO_INSTR_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of Instructor and Courses | ✓ | |
| PS_UC_CTO_WSTDY_VW | Student Admin | CoreCT | oracle view | db link | Read | Sept 2016 | *SA to verify View of Work Study Awards | ✓ | |
| Employee IDS/CORECT Feed | Identity Management | KFS | REST Service | XML | Daily Batch | 3rd QTR 2019 | Created for Concur Integrations. | ✓ | |
| Expense validation notification | CONCUR | KFS | REST Service | XML | Real-Time | 3rd QTR 2019 | ✓ | ||
| KFS Concur file exports (Employee, Connected List, Cost Object Approvers, Chart of Accounts, Validation Table) | KFS | CONCUR | SFTP | CSV with pgp encryption | Daily Batch | 3rd QTR 2019 | ✓ | ||
| Concur File Exports (Standard Accounting Extract, Declining Balance Card Users, Travel Insurance Users) | CONCUR | KFS | SFTP | CSV with pgp encryption | Daily Batch | 3rd QTR 2019 | ✓ | ||
| Custom Field Export | KFS | Jaggaer | Java REST service | XML | Daily Batch | July 2018 | ✓ | ||
| Invoice Status Export | KFS | Jaggaer | Java REST service | XML | Daily Batch | July 2018 | ✓ | ||
| Update LDAP Roles | KFS | Jaggaer | Java REST service | XML | Daily Batch | July 2018 | ✓ | ||
| User Export | KFS | Jaggaer | Java REST service | XML | Daily Batch | July 2018 | ✓ | ||
| Invoice Import | Jaggaer | KFS | Web Service | XML | Real-Time | July 2018 | ✓ | ||
| Purchase Order Import | Jaggaer | KFS | Web Service | XML | Real-Time | July 2018 | ✓ | ||
| Requisition Validation | Jaggaer | KFS | Web Service | XML | Real-Time | July 2018 | ✓ | ||
| Supplier Sync | Jaggaer | KFS | Web Service | XML | Real-Time | July 2018 | ✓ | ||
| invoiceInquiry | KFS | ||||||||
| chartOfAccountsInquiry | KFS | ||||||||
| kfsAcctInfoService | KFS | ||||||||
| uconnLdapService | KFS | ||||||||
| accountBalanceInquiry | KFS | ||||||||
| vendorInquiry | KFS | ||||||||
| workFlowsWsService | KFS | ||||||||
| ucMudOrgWsService | KFS | ||||||||
invoiceInquiry, chartOfAccountsInquiry, kfsAcctInfoService, uconnLdapService, accountBalanceInquiry, vendorInquiry, workFlowWsService, ucMudOrgWsService | KFS | Unifier, AiM, CIDER, DTW, FEB | Java, Tomcat | SOAP, XML | Both, Read | Real-time | 2015-2017 | ✓ | |
| Billing,  Other "Collector" Files | KFS | FoodPro, Pinnacle, Public Safety Locksmith, Facilities + ResLife, Husky-One (OneCard), Law Library, Travel | Java | FTP, CSV, flat file | Batch | 2012 | ✓ | ||
| Disbursement Voucher uploads | KFS | FoodPro, Pinnacle, Facilities + ResLife, Husky-One (OneCard), Travel |  Java | FTP, CSV, XML | Batch | 2012 - 2013 | ✓ | ||
| Customers and Customer Invoice uploads | KFS |  LIMS (Patho lab), TicketPro (Parking) |  Java | FTP, CSV, XML | Batch | 2012? | |||
Student Receipts, Payment Distribution, Student Disbursements, Student Refund, Checks | KFS | PeopleSoft Student Financials | Java | FTP, CSV, XML | Batch | 2015? | |||
| ACH | KFS | Core-CT | Direct table load via ETL (Datastage) | Batch | 2015 | update of ACH info for Payees | |||
| Check & ACH | BottomLine | KFS | FTP, CSV | Both | Batch | 2015 | BottomLine transmits to Bank of America | ||
| Check Reconciliation | Bank of America | KFS |  Java | Flat file | Batch | ||||
|  Pro-Card transactions |  JP Morgan-Chase | KFS |  Java | FTP, flat file | Batch | ||||
| Vendor List, Delinquent Vendors | Dept. of Revenue Services | KFS / Jaggaer | FTP, flat file | Batch | 2012 - 2018 | ||||
| Asset upload, Asset Retirement upload | Asset Panda | KFS | FTP, CSV | Batch | 2012 - rev 2018 | ||||
| Buildings, Floors and Rooms | IWMS | Meridian | MS SQL | MS SQL | Read | Daily | 2018 | MS SQL Stored Procedures | |
| Purchase Request, Purchase Order Amendment | Unifier | Jaggaer | C# .NET | SOAP, REST | Both | Real-Time | July 2018 | ||
| Purchase Request Acknowledgement, Purchase Order, Change Order | Jaggaer | Unifier | C# .NET | SOAP, REST | Both | Real-Time | July 2018 | ||
| AiM RestAPI | AiM | Consumers (FEB, NetENG, OTE, etc.) | PHP | REST | Read | Real-Time | Oct 2017 | ||
| Unifier RestAPI | Unifier | FEB | PHP | SOAP, REST | Both | Real-Time | Oct 2018 | ||
| Purchase Order, Purchase Order Amendment | Jaggaer | AiM | Java | SOAP, XML | Both | Real-Time | July 2018 | ||
| Purchase Request | AiM | Jaggaer | Java | SOAP, XML | Both | Real-Time | July 2018 | ||
| Facilities Invoices | KFS | AiM | Java | SOAP, XML | Read | Daily | April 2018 | ||
| Chart of Accounts | KFS | AiM | ETL, Data Stage | SOAP, XML | Read | Weekly | Nov 2017 | ||
| Organizations | KFDM | AiM | ETL, Data Stage | SOAP, XML | Read | Weekly | Nov 2017 | ||
| Employees | CoreCT | AiM | ETL, Data Stage | SOAP, XML | Read | Weekly | Nov 2017 | ||
| Contractor/Vendors | KFS | AiM | ETL, Data Stage | SOAP, XML | Read | Weekly | Nov 2017 | ||
| Work Study Balances | CoreCT | SA | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| GA data | CoreCT | SA | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| KFS Chart of Accounts Inbound | KFS | CoreCT | java | flat file | Read | daily | Sept 2016 | ||
| KFS Encumbrance Balances Inbound | KFS | CoreCT | java | flat file | Read | daily | Sept 2016 | ||
| KFS Fiscal Period Inbound | KFS | CoreCT | java | flat file | Read | daily | Sept 2016 | ||
| UOC Payroll Integration Outbound - Salary Expense (Actuals) | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | bi-weekly | Sept 2016 | ||
| UOC Payroll Integration Outbound - GL Cash (collector) | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | bi-weekly | Sept 2016 | ||
| UOC Payroll Integration Outbound - Encumbrance Liquidations | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | bi-weekly | Sept 2016 | ||
| UOC Payroll Integration Outbound - Accruals (Actuals) | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | bi-weekly | Sept 2016 | ||
| UOC Payroll Integration Outbound - Accrual Encumbrances | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | bi-weekly | Sept 2016 | ||
| Encumbrance Adjustments Outbound | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | bi-weekly | Sept 2016 | ||
| Position Interface Outbound | CoreCT | KFS | Peoplesoft App Engine | flat file | Read | ? | Sept 2016 | ||
| activeStudents-CT_ACTV_STUD_VW | CoreCT | SA | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| adjunctCourseInfo-CT_COURSE_CR_VW | CoreCT | SA | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| employeeData-CT_EMP_DATA_VW | CoreCT | Recruiting Solutions, ID System | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| EmployeeData2-CT_EMPL_DATA_VW | CoreCT | Recruiting Solutions, ID System | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| configFlatTree-CT_FLAT_TREE_VW | CoreCT | Recruiting Solutions, ID System | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| gradDeductions-CT_GRAD_DEDN_VW | CoreCT | SA | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| prkgDedns-CT_PRKG_DEDN_VW | CoreCT | Parking | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| prkgEmpls-CT_PRKG_EMPL_VW | CoreCT | Parking | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| diningStudentinfo-CT_STUD_DS_VW | CoreCT | Dining Services | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| employeeTBHData-CT_TBH_DTA_VW | CoreCT | ID system | oracle view | db link | Read | Real-Time | Sept 2016 | ||
| Footprints | Footprints | Central Calendar | Calendar.sh/sql | CSV | Read | 4 times day | 12/1/2014 | ||
| Footprints | Footprints | ITS Status Page | feeds.sh/sql | CSV | Read | every 3 min | 4/1/2015 | ||
| Pinnacle | Windstream | Pinnacle | sftp_get_windstream_csv_v65.sh/sftp | csv | read/write | monthly | 12/1/2014 | ||
| Pinnacle | Pinnacle | E911 | daily_911_pinn651.sh/perl | card column | read | daily | 7/20/2009 | ||
| Pinnacle | Pinnacle | FTP Server (Telecomm) | run_get_daily_acus.sh/perl | card column | read | daily | 7/31/2007 | ||
| Pinnacle | Pinnacle | FTP Server (sa.uconn.edu) | process_reslife_locations.sh/SQL | csv | read | daily | 9/20/2002 | ||
| SADM | PeopleSoft(- Student Financials, Student Records, Admissions) | Multiple | Datastage | Exadata | Read | Daily(Sunday-Friday) | Jan 2019 | ||
| KFDM | KFS,LDAP,CoreCT,Active Directory | Multiple | Datastage | Oracle DB | Read | Daily | |||
| Student Payroll | Local Time Card System | CoreCT | DataStage | XML | Read | Friday (Payweek 11:30am) | |||
| HR-Payroll Datamart | CoreCT, Recruiting Solution,KFDM, LDAP, Active Directory, | Multiple | Oracle Data Integrator(ODI) | Exadata | Read | Daily | 2017 | ||
| uchc_employees_hrs0031d.txt | UCH Banner | ID System | Banner, Python, Postgres | Fixed-width file | Read | Daily | 2016 | Employee information from Banner HR system | |
| uchc_employees_ssn_change.txt | UCH Banner | ID System | Banner, Python, Postgres | Fixed-width file | Read | Daily | 2016 | SSN Changes from Banner HR system | |
| StudentAffiliateEmployee.gpg | UCH FIM | ID System | Microsoft FIM | Delimited File | Read | Daily | 2016 | UCH student, resident and affiliate information | |
| usre052_honors.txt | Student Admin | ID System | Peoplesoft CS, Python, Postgres | Fixed-width file | Read | Daily | 2016 | Honors student information | |
| usre052_hscoop.txt | Student Admin | ID System | Peoplesoft CS, Python, Postgres | Fixed-width file | Read | Daily | 2016 | High school co-op instructors | |
| usre052_adjnct.txt | Student Admin | ID System | Peoplesoft CS, Python, Postgres | Fixed-width file | Read | Daily | 2016 | Adjunct Faculty | |
| usre055_studnt.txt | Student Admin | ID System | Peoplesoft CS, Python, Postgres | Fixed-width file | Read | Daily | 2016 | Student Identity Information | |
| usre057_ssnchg.txt | Student Admin | ID System | Peoplesoft CS, Python, Postgres | Fixed-width file | Read | Daily | 2016 | Student SSN changes | |
| SA_Affiliates_NetID_To_UITS.txt | SAIT | ID System | Python, Postgres | Fixed-width file | Read | Daily | 2016 | Dining Affiliates | |
| stu_room_phone.txt | ITS Telecom | ID System | Python, Postgres | Fixed-width file | Read | Daily | 2016 | Student dorm telephone number information | |
| uatucid.ftpucid.ucfaffl | UConn Foundation | ID System | Python, Postgres | Fixed-width file | Read | Daily | 2016 | Foundation Affiliates | |
| NetID_sis_hr_user_info.txt | Student Admin | ID System | Peoplesoft CS, Python, Postgres | Delimited File | Read | Daily | 2017 | TerraDotta international student information | |
| NetID_list*.csv | UCH Faculty Affairs | ID System | Filemaker, Python, Postgres | Delimited File | Read | Daily | 2018 | UCH Affiliate Faculty | |
| onecardpatrondata.csv | SAIT OneCard | ID System | Python, Postgres | Delimited File | Read | Daily | 2016 | OneCard magstrip and prox card information | |
| UAPUCID.FTPUCID.UITSAFFL | Affiliate Form | ID System | PHP, Python, Postgres | Fixed-width file | Read | Daily | 2016 | Affiliate information from the affiliate form | |
| Patron Application | Patron Application | ID System | Python, Postgres | Postgres Table | Read | Daily | 2017 | Affiliate information from the patron application | |
| DEPARTMENT_FLAT_TREE | ID System | Oracle Table | Python, Postgres, Oracle | Oracle Table | Write | Daily | 2017 | Department information for HR | |
| PSUSEREMAIL, PS_EMAIL_ADDRESSES | ID System | Core | Python, Postgres, Oracle | Oracle Table | Write | Daily | 2016 | Core email update | |
| PS_CT_NETID_TBL | ID System | Core | Python, Postgres, Oracle | Oracle Table | Write | Daily | 2016 | EMPLID to NetID mapping | |
| uconnpeople.txt | ID System | Active Directory, OpenLDAP | Active Directory, OpenLDAP, Python, Postgres | LDIF | Write | Daily | 2016 | Directory Information for active NetIDs | |
| sa_dining_affiliates.txt | ID System | SAIT | Python, Postgres | Fixed-width file | Write | Daily | 2016 | Dining affiliate NetID information | |
| sa_uconn_affiliates.txt | ID System | SAIT | Python, Postgres | Fixed-width file | Write | Daily | 2016 | Affiliate NetID information | |
| academic_listserv | ID System | Listserv | Python, Postgres | Fixed-width file | Write | Daily | 2016 | Listserv list for students | |
| foundation_listserv | ID System | Listserv | Python, Postgres | Fixed-width file | Write | Daily | 2016 | Listserv list for foundation | |
| employee_listserv | ID System | Listserv | Python, Postgres | Fixed-width file | Write | Daily | 2016 | Listserv lists for employees | |
| uchcnetids.txt | ID System | UCH/Banner | Python, Postgres | Fixed-width file | Write | Daily | 2016 | UCH NetID information | |
| idemail.txt | ID System | Student Admin | Python, Postgres | Fixed-width file | Write | Daily | 2016 | Email information for students | |
| corect_to_sa | ID System | Student Admin | Python, Postgres, Oracle | Fixed-width file | Write | Daily | 2016 | CoreCT duplicated tables | |
| uchc_appointed_org_new | ID System | Banner | Python, Postgres | Fixed-width file | Write | Daily | 2016 | UCH NetID and identity information | |
| ospfile.txt | ID System | OVPR | Python, Postgres | Fixed-width file | Write | Daily | 2016 | UCH identity information | |
| lib_patrons.csv | ID System | Library | Python, Postgres | Delimited File | Write | Daily | 2016 | Honors student information | |
| jorgensen_ticketing.csv | ID System | ChoiceCRM | Python, Postgres | Delimited File | Write | Daily | 2016 | Active NetID and Affiliation information | |
| unity_netid.csv | ID System | UCH FIM | Python, Postgres | Delimited File | Write | Daily | 2016 | NetID to UAR ID mapping | |
| SA.ISSS | ID System | TerraDotta | Python, Postgres | Delimited File | Write | Daily | 2017 | Transformed international student and advisor information | |
SABA_storrs_person.txt, SABA_storrs_org.txt, SABA_storrs_job.txt | ID System | Saba | Python, Postgres | Delimited File | Write | Daily | 2017 | File containing primary job and identity information for Saba training platform | |
| uchc_affliate_faculty.csv | ID System | UCH Faculty Advising | Python, Postgres | Delimited File | Write | Daily | 2018 | NetID to UCH affiliate faculty ID | |