• No results found

SFS Analytics for Advanced Users

N/A
N/A
Protected

Academic year: 2021

Share "SFS Analytics for Advanced Users"

Copied!
21
0
0

Loading.... (view fulltext now)

Full text

(1)

1 Contents subject to change.Contents subject to change.

December 10, 2020

SFS Analytics for Advanced Users

(2)

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)

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)

4 Contents subject to change.Contents subject to change.

Presenter – Joe LeDuc

ESA and Project Costing

(5)

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?

(6)

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

(7)

8 Contents subject to change.Contents subject to change.

DW897 – Project Summary and DW838- Project Budget Overview

Project Report Demos

(8)

9 Contents subject to change.Contents subject to change.

Presenter – Rebecca Jones

DW114 – Covid Tracking and Report Use Cases

(9)

10 Contents subject to change.Contents subject to change.

Rebecca Jones

DW114-Covid-19 Tracking Report

Overview

(10)

11 Contents subject to change.

||

DW114 – COVID-19 Tracking - Navigation

(11)

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

(12)

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

(13)

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

(14)

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.

(15)

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.

(16)

17 Contents subject to change.

||

DW114 – Purchase Orders

12/10/2020

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

(17)

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.

(18)

19 Contents subject to change.

||

DW114 –Requisition Tab

12/10/2020

(19)

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.

(20)

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

(21)

22 Contents subject to change.Contents subject to change.

Question and Answer

References

Related documents

I will continue to promote the concept within my classroom that, “we are a learning team: Sharing, working, and learning together.” Finally, I will continue to model my belief in

In this study numerical and experimental studies are car- ried out for steady laminar flows of both Newtonian fluid around the confined square cylinder to reach physical

It has been accepted for inclusion in Mathematics, Physics, and Computer Science Faculty Articles and Research by an authorized administrator of Chapman University Digital Commons..

• Interoperable with existing data sources, applications, messaging platforms and analytics solutions, and enabling rapid, cost effective business solution or operating

Consideration should be given to replacing these bolted nozzles with API 650 welded roof nozzle details (Ref. 3-16) or appropriate measures should be taken to insure that

They also showed that a long position in such an index had a positive risk premium that exceeded that of bonds and matched that of equities, that the historical risk of an

Evidence from randomised controlled trials not included in these systematic reviews suggests that: physiotherapy and relaxation might be more effective than acupuncture for

Continue up the left side of the arena, circle the top of the arena, and stay- ing at least twenty feet (six meters) from the walls or fence, run straight down the opposite or