# eCAPRIS

## Pull eCAPRIS funding and statuses to Moped (one-way)

### Summary

**Add 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 the [EDP dataset](https://datahub.austintexas.gov/dataset/TPW-Program-and-Subprogram-by-FDU/s4mj-68pg/data_preview) that can matches FDUs to a Moped project using by subproject ID. See more information in the [user guide](https://atd-dts.gitbook.io/moped-documentation/user-guides/add-funding-to-a-project).

**Sync eCAPRIS statuses into Moped:** Moped users can associate an eCAPRIS subproject ID to a project. The Notes tab on a project has a switch that is disabled on projects without a subproject ID set. There is also a filter button that is disabled without a subproject ID set. 

When a subproject id is added to a Moped project, the switch enables and can be toggled on or off. Toggling the switch on happens automatically when a subproject id is added to a project. Once the switch is toggled on, we have an ETL running in the background that queries the Moped project table and looks for projects that have `should_sync_ecapris_statuses` to `true` and also have an eCAPRIS subproject id stored on them. The ETL will then queries the FSD Data Warehouse for any new statuses for that id and add new rows to the `ecapris_subproject_statuses` table. These rows can be used by any projects that share the same eCAPRIS subproject id association.

eCAPRIS statuses are viewed in the same timeline as Moped status updates and internal notes. They also appear as the latest status update in the Moped dashboard, the project summary page, and in the AGOL components dataset if the syncing is toggled on.

## Current resources

* <ecaprishelp@austintexas.gov>
  * Create a ticket for help or reaching developers to request new database views or updates to existing views
* TPW Program and Subprogram by FDU <https://datahub.austintexas.gov/dataset/TPW-Program-and-Subprogram-by-FDU/s4mj-68pg/about_data>

## Legacy resources

In January 2026, in [version 3.0](https://github.com/cityofaustin/atd-moped/releases/tag/v3.0.0), we moved from sourcing FDU information from the two datasets below along with Fund codes in the `deprecated.moped_funds` database table to sourcing from the resource described above.&#x20;

* 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 and where `ATD_FDUS_VW` and `ATD_SUB_PROJECT_STATUS_VW` views which power the FDU and status integrations live.**
      * \~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
      * See also <https://github.com/cityofaustin/atd-finance-data>
    * Source side
      * less latency
      * `fsaprod` service name


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://atd-dts.gitbook.io/moped-documentation/product-management/integrations/ecapris.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.