Tables-Business Mapping

Each client has separate Schema where they share common tables most of the time

In this document we will try to add some mapping between business and technical part of things.

• programs ⇒ public service agency program ( in case of Alco and Oakland only ).

• progs ⇒ public service agency program for other jurisdictions.
  • in case of Alco and Oakland “progs“ its being used for pipeline and applications.

• projs ⇒ ( affordable portofolio/asset management/completed projects ) informations.

• props ⇒ ( affordable portofolio/asset management/completed projects ) units informations linked to projs using property column.

• reports ⇒ applications / reports data