eCapris

eCapris is the capital projects and information system for the City of Austin maintained by FSD (Financial Services Division)

Resources

• [e-mail]

  • 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:

    • Source side

      • less latency

      • fsaprod service name

    • Data Warehouse

      • ~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

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)