Project Ledger Tables and Views

Owned by Knowledge Assistant
Last updated: Apr 09, 2024
1 min read



Description of Issue

What are the most common PL table and related views for reporting purposes?



Context

  • Standard Query Language (SQL)

  • SQL Server Reporting Services (SSRS)

  • Database Table & Views

  • Crystal Reports



Cause

View needed for reports and views receive data from Munis tables



Resolution

Site's can use reporting views, view are populated by SQL tables. The specific table and fields programs are for Tyler internally and sites should not be using tables.

  • pa_project_master equal to Project table

  • pa_segment equal to ProjectSegments table

  • pa_project_string equal to ProjectStrings table

  • pa_monthly_amounts equal to ProjectMonthAmounts table

  • pa_journal_detail equal to ProjectJournalLines table



Additional Information