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.