Moped Documentation
  • Welcome 👋
  • User Guides
    • Getting started
    • Map a project
  • Product Management
    • User communication
    • User management
    • User analytics
    • Local testing
    • Release process
    • Patch release process
    • MUI X Pro License
    • Integrations
      • Dataset documentation
      • ArcGIS Online
      • eCapris
      • Power BI
    • Features
  • Dev Guides
    • DB Docs & Data dictionary
    • Database backup policy
    • Moped Read Replica
    • How-to's
      • How do I start the Hasura cluster locally?
      • How do I launch the Hasura Console?
      • How do I get a JWT token?
      • How to ping the GraphQL API
      • How to ping the REST API
      • How do I connect a database with Postgres GUIs?
      • How do I connect to the RDS instance?
      • How to load production data into a local instance
      • How do I update seed data?
    • Hasura
      • Hasura Roles
      • Hasura Migrations
        • Getting Started
        • Installing the Hasura CLI
        • Configuration Files
        • Hasura Migration Principles
        • The Migration file format
        • Development
        • Hasura Seed Data
        • Running the Hasura Cluster Locally (video)
        • Create a migration: Exercise 1 (video)
        • Create a migration: Exercise 2 (video)
        • Latest hasura-cluster features
    • User Management
    • Authentication
      • Authentication Architecture
      • DynamoDB & Cognito
      • Secrets Manager & Cognito
      • Hasura & Cognito
      • React & Cognito
      • Flask API & Cognito
      • Single Sign-On with CTM
    • Code organization
    • API
      • Configuration Files
      • Testing
      • User Management API
    • Maps and geospatial data
      • Access tokens and API keys
      • Map libraries
      • Map data
      • Map styles
      • Map layers and basemaps
      • React patterns
      • V1 Archive
        • Map libraries
        • Map data
        • Map custom hooks
        • Map styles
        • Map layers and basemaps
    • UI access control
    • Design system
      • Branding
      • Component styles
      • Text content
    • Activity Log
      • Architecture
      • GitHub Actions and Deployment of Updates
      • Hasura Event Logs and Truncate Cron Job
      • Authentication
  • See also
  • Get Moped support, report a bug, or request an enhancement
  • Data & Technology Services
  • Github repository
Powered by GitBook
On this page
  • Resources
  • eCapris Tech
  • Moped <> eCapris
  • Summary

Was this helpful?

  1. Product Management
  2. Integrations

eCapris

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

PreviousArcGIS OnlineNextPower BI

Last updated 1 month ago

Was this helpful?

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

  • Transportation Department Financial Codes dataset

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

        • See also

      • 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 (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 (bgrt-2m2z)

https://data.austintexas.gov/Transportation-and-Mobility/Transportation-Capital-Project-Financial-Codes/jega-nqf6/data_preview
https://data.austintexas.gov/Transportation-and-Mobility/Transportation-Department-Financial-Codes/bgrt-2m2z/data_preview
https://github.com/cityofaustin/atd-finance-data
open dataset
open dataset