2-Appendix A.pdf
PDF 38 KB Posted
- Attached to
- Risk Management Information Systems
- Solicitation number
- RFP Doc1925792577
- Issued by
- Harris County, Houston City, Texas
About this file
This is a Data Source-Interface Appendix document for the Metropolitan Transit Authority of Harris County (MTAHC) Risk Management Information Systems contract in Texas. The appendix outlines the data interfaces and integration requirements for a comprehensive risk management system that consolidates information from multiple data sources including workers' compensation platforms (Verisk, GENEX, Mitchell), financial systems (SAP), claims management tools (ISOCLAIM), and internal HR and operations databases. The system requires daily, quarterly, yearly, and one-time data imports and exports across fourteen primary interfaces, including First Report of Injury acknowledgements and notices, claim extracts, vendor information, invoice processing, employee records, vehicle data, and compliance reporting. The scope encompasses both routine operational data feeds such as check processing and payment verification, as well as specialized safety and risk data including incident investigations, transit worker assaults, hazardous events, and corrective actions tracked across multiple Metro facilities and departments.
The appendix specifies bidirectional data flow requirements with varying frequencies to support claims administration, billing and invoice management, CMS reporting obligations, and safety analytics. Key data categories include employee rosters, vendor information, vehicle and facility inventories, mileage records, and safety investigation details sourced from EHS systems, bus operations, and Metro Rail facilities. The one-time data migration requirements indicate this represents either a system implementation or significant platform transition. No pricing terms, set-asides, incumbent information, or funding amounts are detailed in this appendix, which functions as a technical specification document defining the data integration architecture necessary for operational risk management across the transit authority's business lines.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1-RFP Risk Management Information System.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
Data Source-Interface Appendix A
Data Interface Name Type/Usage Direction of Interface
Frequency
MTAHC - Verisk First Report of Injury (FROI) - Acknowledgement
EDI (FROI) Acknowledgement Import daily
MTAHC - Verisk First Report of Injury (FROI) Notice
EDI (FROI) Notice Export daily
MTAHC - GENEX EXTRACT -Claim Extract Employee information for analyst and Bill review
Import
MTAHC - GENEX EXTRACT -Vendor Medical provider Export daily
MTAHC - GENEX EXTRACT-Paid Date Check date and payment of Invoices Export daily
MTAHC - GENEX LOAD Invoices for Payment Import daily
MTAHC - IMO - Load Pre authorities that are required by the state.
Import daily
MTAHC - ISOCLAIM Historical reference for claims search import daily
MTAHC - Mitchell MMSEA Claim Input Extract
Genex- Mitchell pays benefit manager (Eynetel-extract bills for review report
Import daily
MTAHC - Mitchell MMSEA Query Extract
(CMS)
CMS reporting Export quarterly
MTAHC - Mitchell MMSEA Query Response (CMS)
CMS numbers Export quarterly
MTAHC - SAP AP (checks) Checks No. Payment Date Import daily
MTAHC - SAP AP Extract (invoices) Claims Invoices payment Export daily
MTAHC - SAP Exposure Once
MTAHC - SAP HR (employees) SAP all employees Import daily
MTAHC - SAP Vendor SAP -Vendors Import daily
MTAHC-ISO-Error Report No match Import daily
MTAHC-ISO-Match Report Match Export daily
SAP Vehicles (manually) All Vehicles in SAP Import monthly
SAP Location (GL/codes-cost center)(manually)
SAP Hierarchy Import yearly
Routes(manually) SAP Import quarterly
Mileage Data for each Metro site (Rail) and (Bus) (monthly) Facility
SAP Import monthly
Facilities(manually) SAP Import quarterly
Safety Data Source
Investigation object and all the data SAP-HR-Facilities, Vehicle, Contractors
Import One time
Data from EHS Import One time
Contractors Data from Bus Operation facilities
Metro Lift, Transdev employee Import One time
Non-Revenue accidents/incidents Data SAP-Vendor-HR-Vehicle-Facilities Import One time
EHS_ Safety Events Investigations Import One time
Transit Worker Assaults SAP-HR Import One time
Corrective Actions SAP-HR Import One time
Metrorail Hazardous Events SAP-HR Import One time
EH Portal SAP-HR and Contractor Info Import One time
File details come from the government source that posted it. Updated .