Database view that stores Project String amounts

Description of Issue

What is the database view/table that stores Project String amounts

Expense String and Funding Source amounts

Context
  • Project Strings
  • Project Expense String
  • Project Funding Source String
  • Monthly Amounts
Cause

Project String amount view needed for SSRS report

Resolution

The Project balances are stored on the dbo.pamthamt view.

This view will provide monthly records for the Project String information, Budget, Paid Actuals, Unpaid Actuals, Encumbrances, and Requisitions. 

Additional Information