eCapris
eCapris is the capital projects and information system for the City of Austin maintained by FSD (Financial Services Division)
Resources
ecaprishelp@austintexas.gov
Create a ticket for help or reaching developers to request new database views or updates to existing views
Transportation Capital Project Financial Codes dataset https://data.austintexas.gov/Transportation-and-Mobility/Transportation-Capital-Project-Financial-Codes/jega-nqf6/data_preview
Transportation Department Financial Codes dataset https://data.austintexas.gov/Transportation-and-Mobility/Transportation-Department-Financial-Codes/bgrt-2m2z/data_preview
eCapris Tech
ColdFusion front end with some Java and Javascript
Oracle database
Database views can query:
Data Warehouse
This is the preferred data source for integrations.
~30 min behind data updates written to eCapris database
Financial data like FDUs is current up to the EOB of the previous day
infoprod
service name
Source side
less latency
fsaprod
service name
Moped <> eCapris
Summary
Adding funding sources from eCapris data: Moped users can add an eCapris subproject ID to a project. This unlocks the ability to add funding sources to the funding table from an open dataset (jega-nqf6) that can match funding sources to the subproject ID.
Creating new funding sources using Fund and Dept-unit dropdowns: Moped users can add a blank funding source row and populate the Fund and Dept-unit inputs using dropdown options provided by an open dataset (bgrt-2m2z)
Last updated
Was this helpful?