Appendix B_Interface Summary.pdf
PDF 7 KB Posted
- Solicitation number
- RFP GMAA 2015000072 2
- Issued by
- Denver County, Denver City, Colorado
About this file
This Interface Summary document outlines the system integration requirements for Colorado's Financial/Enterprise Resource Planning (ERP) System procurement (AHEC-15909-R). The document specifies 24 distinct interfaces required to connect the new ERP platform with existing financial, human resources, payroll, and operational systems. These interfaces include critical connections to Fundware, CORE accounting systems, banking platforms (ACH and check verification), Venice vendor management, CitiDirect banking services, iVantage, Attendance Enterprise, Benefit Solver, retirement systems (PERA, 401k, 457 plans, TIAA-CREF), state unemployment reporting, Family Support Registry, Sidewalk retirement provider feeds, EMS, TMA project management, CCM early learning systems, T2 FLEX general ledger feeds, Telecom, Mail Services (Pitney Bowes), and EnergyCap utility management systems.
The interfaces are categorized by frequency and criticality, with most classified as "Required" and some designated as "Desired" enhancements. Data exchange methods include flat file transfers, SQL Server batch feeds, MS Access database connections, and implementation-dependent configurations. Required interfaces mandate ongoing daily, weekly, monthly, quarterly, or bi-weekly data synchronization across general ledger, accounts payable, accounts receivable, human resources, payroll, and project management modules. The document establishes the technical specifications and integration priorities necessary for the new ERP system to function within Colorado's existing technology ecosystem and comply with state financial and personnel management requirements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment A_AHEC Model Contract.pdf | ||
| Appendix A_Basic Functional Requirements.docx | DOCX document | |
| Attachment B_AHEC-15909-R_PERA Certification.pdf | ||
| AHEC-15909-R_Questions and Answers_FINAL.pdf | ||
| AHEC-15909-R_AHEC ERP_FINAL.docx | DOCX document | |
| Attachment C_AHEC-15909-R_W-9.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Required/
System Type Interface Type Desired
Fundware UKN Implementation-dependent Required
CORE State Ongoing batch feed from new ERP G/L to Required
CORE - as needed
ACH UKN Export to bank for ACH deposits & Positive Required
Pay - as needed
Check Verification UKN Import from Bank for check verification Required
Reconciliation UKN Monthly configuration of bank account Required information needed for reconciliation
Venice SQL Server One time load - Vendor File Required
CitiDirect Flat File Weekly import to new ERP G/L Required iVantage UKN Implementation-dependent Required
Attendance Enterprise Flat File Ongoing interface to new ERP HR-Payroll Required
Benefit Solver State Ongoing import & export feeds to new ERP Desired
HR module
Xire Flat File Monthly feed of classified benefits Required
PERA Flat File Monthly feed to PERA Required
Unemployment Flat File Quarterly feed to State Required
401 Flat File Monthly feed of 401 contributions Required
457 Flat File Monthly feed of 457 contributions Required
Family Support Registry Flat File Bi-weekly or monthly feed to State Required
TIAACREF UKN Bi-weekly or monthly feed to Vendor Desired
Retirement Provider
Sidewalk Flat File Ongoing daily batch feed to new ERP G/L & A/P Required
EMS SQL Server Batch feed to new ERP A/R Desired
TMA SQL Server Batch feed to new ERP G/L & Project Module Required
CCM MS Access Batch feed from Early Learning Package Desired to new ERP A/R
T2 FLEX Flat File Ongoing daily batch feed to new ERP G/L Required
Telecom MS Access Batch feed to new ERP A/R Desired
Mail Services Pitney Bowes Batch feed to new ERP A/R Desired
EnergyCap UKN Ongoing batch feed to new ERP G/L Required
INTERFACE SUMMARY
APPENDIX B
File details come from the government source that posted it. Updated .