WPP Annual Report

Date Published:

Published In:

01/04/2021

WI_Partnership_Program

Brief Description

WPP Annual Report

Data Classification

Internal

Developer

Melissa Chan

Primary Audience

Wisconsin Partnership Program Administrators

Data Sources

SFMRT: FINANCE_QVDs_WISDM: PROJECT_ACCOUNTING.QVD, PROJECTS_DIMENSION.QVD, GL_STAR_FACT.QVD, JOURNAL_REFERENCE_DIMENSION.QVD

Data Load Schedule

Daily

Definitions

Award Amount: Displays Budget_Trans_Amounts that are greater than zero.
Income Reversal: Displays Budget_Trans_Amounts that are less than or equal to zero.
Sales Credits: The Revenue_Amount for Accounts 905 and 906.
Revenue: Revenue_Amount minus Sales Credits.
Budget ITD: Budget_Amount
Budget Balance: Budget_Amount minus Expense_Amount - Sales Credits
Fund Balance (minus = credit = positive balance): Expense_Amount + Sales Credits + Revenue_Amount
WPP Type: Abbreviated name of WPP category. OAC represents Award_Sponsor_Id MSN102605. ICTR represents projects that contain '4358' in the Award_Agency_Reference_Nbr. PERC represents all other projects.
For all other terms see WISDM definition

Plans for Future Development


Additional Notes

This report includes data from the trailing 3 fiscal years.
The Revenue and Expense sheet does not include period 0.
The data schema for the Budget sheet is separate from the Revenue and Expense and Balance sheets. Therefore, filters applied to the Budget sheet do not automatically apply to the other two sheets and vice versa.
Data may lag up to two days behind WISER.

  • No labels