SFS Analytics for Advanced Users

1 Contents subject to change._{Contents subject to change.}

December 10, 2020

SFS Analytics for Advanced Users

2 Contents subject to change.

||

 Recorded demonstration with a live question and answer session to follow.

 Please type in questions and comments into the chat window at any time during the recorded presentation.

Housekeeping Items

3 Contents subject to change.

||

 Introduction to ESA

 Project Costing Report Overview

• DW897 Project Summary Report • DW838 Project Budget Overview

 DW114 COVID-19 Tracking Overview

 Business Cases

• DW720 General Ledger by Tree: Cash Projections

• DW264 KK Financial Plan Budget Overview: Managing Cash Ceiling

• DW468 – Purchase Order PSP Overview – Monitoring and Managing PSP

Agenda

4 Contents subject to change._{Contents subject to change.}

Presenter – Joe LeDuc

ESA and Project Costing

6 Contents subject to change.

||

 Enterprise Services Automation (ESA) - a group of interrelated PeopleSoft modules that include:

• Project Costing • Grants

• Program Management • Customer Contracts • Billing Integration

 A central repository for project information

What is ESA?

7 Contents subject to change.

||

 DW897 – Project Summary

• View summary of project information and related customer contract information

 DW838 – Project Budget Overview

• Monitor project child budgets and all activity associated to the budget since EE1 data conversion or on a LTD basis

 DW365 – Project Financial Overview – Coming soon

• This report is used to view budgetary, expense, and disbursement information for grant and non-grant related projects

• Rollout will be ESA only. Phase 2 will include non-ESA agency project information

ESA and Project Costing Reports

8 Contents subject to change._{Contents subject to change.}

DW897 – Project Summary and DW838- Project Budget Overview

Project Report Demos

9 Contents subject to change._{Contents subject to change.}

Presenter – Rebecca Jones

DW114 – Covid Tracking and Report Use Cases

10 Contents subject to change._{Contents subject to change.}

Rebecca Jones

DW114-Covid-19 Tracking Report

Overview

11 Contents subject to change.

||

DW114 – COVID-19 Tracking - Navigation

12 Contents subject to change.

||

 Intended to be a one-stop-shop for COVID-19 reporting requirements.

 Multiple tabs provide a wide scope of COVID spending metrics.

 All tabs of the report are filtered for spending for only the COVID-19 project.

 Chartfield1, 2 and 3 entries utilizing COVID activity codes (as aligned in the Budget Bulletin H-0501) are also hard coded within the reports to include spending for COVID against federal grant projects with COVID spending.

 Added prompts aid the user in limiting returned results.

DW114 – Covid Tracking Report

13 Contents subject to change.

||

 Chartfield 1, 2 and 3 entries utilizing COVID activity codes (as aligned in the Budget Bulletin H-0501) are also hard coded within the reports to include spending for COVID against federal grant projects with COVID spending.

 Depending on the tab, prompt defaults to user’s agency or Business Unit. User can make different selections or multi-select.

 Additional prompts aid the user in limiting returned results for only desired spending.

• E.g. – Use the Activity prompt for reporting only desired project activities such as testing or cleaning supplies

DW114 – Covid Tracking Report

14 Contents subject to change.

||

DW114- Commitment and Actuals Tab

12/10/2020

• Provides aggregate KK and GL spending

• Drill down capability on aggregate spending metrics to view underlying document detail • View selector provides alternate levels of detail for report output

15 Contents subject to change.

||

DW114 – Disbursement Detail Tab

12/10/2020

• View Cash Disbursements and associated documents

• Drill down capability to view relevant document details

• View selector provides

alternate levels of detail for report output.

16 Contents subject to change.

||

DW-114 General Ledger Actuals Tab

12/10/2020

• Chose from Cash or Modified Accrual actuals

• Leverages SFS Tree structure to prompt for relevant spending; narrow down to various levels along the trees.

• Drill down capabilities for

actuals to view document details

• View selector provides alternate levels of detail for report output.

17 Contents subject to change.

||

DW114 – Purchase Orders

12/10/2020

• View associated Purchase Order details, including descriptions, supplier, quantities, status, and amount.

18 Contents subject to change.

||

DW114- Encumbrances by Purchase Order

12/10/2020

• View total encumbered, liquidated, and remaining

encumbered amounts against purchase orders.

• View Contracts associated to the Purchase Orders

• Drill down on documents to view details

• View selector provides

alternate levels of detail for report output.

19 Contents subject to change.

||

DW114 –Requisition Tab

12/10/2020

20 Contents subject to change.

||

DW114 – Contracts Tab

12/10/2020

• View relevant COVID associated contracts

• Use contract attribute prompts to narrow choices

• Leverages SFS Reporting Trees to limit data

• View selector provides alternate levels of detail for report output.

21 Contents subject to change._{Contents subject to change.}

DW720 – General Ledger by Tree

DW264 – KK Financial Plan Budget Overview DW468 - Purchase Order PSP Overview

Report Demos: Cash Projections,

Managing Cash Ceiling, Monitoring

Quarterly Budget and PSP

22 Contents subject to change._{Contents subject to change.}

Question and Answer