Department of Administration

1. Department of Administration System Updates ASTRA November 2015

2. Department of Administration • SHARP Transition to Host and SMART Upgrade to Host • Sarah Gigous • Kansas Treasury Offset Program • Doug Craig • SMART Updates • Sunni Zentner • Vendor Maintenance and Financial Desk Updates • Mitzi Cafer-Rogers

3. Department of Administration Sarah Gigous, Director Office of Systems Management SHARP Transition to Host and SMART Upgrade to Host

4. Department of Administration • Over the last six months we’ve had a team working on a Request for Proposal for a managed Service/Hosting agreement for our PeopleSoft Systems. • We signed a contract on October 31st with Sierra-Cedar • Will consist of a lift and shift for SHARP in April 2015 • In parallel, SMART will be upgraded to V9.2 as the system is moved to the hosted environment. • Expected Go Live date for SMART is November of 2015.

5. Department of Administration • What is a hosted environment? • Hosted environment is where the hardware is purchased and maintained by someone outside the SOK. • Hosting will improve the quality of service since experts provide it using specialized tools, processes, facilities and talent.

6. Department of Administration Benefits: • Tier 3 Data Center • Round the clock general support in the area of break fix & system verification & validation • Team of skilled technical developers • Lab Services for upgrades • Manages all hardware • Assist with keeping data protected according to state, federal & international requirements • Provides support by applying maintenance updates such as tax updates or maintenance packs from Oracle • We get to focus on the needs of Kansas.

7. Department of Administration • SMART Upgrade • 12 month project since Sierra-Cedar will assisting. • We will be looking for agency experts with particular modules to attend Fit Gap meetings. • Fit Gap meetings compare current processes to changes with the new version of software. • Agency experts will have the opportunity to provide recommendation for approach. • If you are interested, contact Sunni Zentner by November 28th with your contact information and area(s) of expertise.

8. Department of Administration Doug Craig, Manager of Setoff Program Office of Financial Management KTOP - Kansas Treasury Offset Program

9. Department of Administration Reciprocal Agreement with Federal Government • SMART payment file to US Treasury • SMART payments applied to federal debts • Kansas debt file to US Treasury • Federal payments applied to state debts

10. Department of Administration KTOP system will look very similar to KDRS, the Setoff Program system. State agencies details and agencies users in KDRS will be copied into KTOP.

11. Department of Administration KDRS and KTOP will interface with each other so that the state agency doesn’t have to make duplicate entries into both systems. KDRS records and forms will change some in order to accommodate KTOP requirements.

12. Department of Administration KTOP debt requirements include: • Delinquency date of the debt • Debtor notified of intent to use Treasury Offset Program (TOP) 60 days prior to submitting debt to TOP More announcements and information will be made available.

13. Other SMART Updates • Sunni Zentner • Treasury Offset Program and Impact on SMART Processing • Update on SMART User’s Group Request List • Security reminders when SMART users leave • Long running queries and reports • How to sign-up for SMART Announcements • Transfer of Printing Functions to DofA Printing • Address Verification Software

14. Kansas Treasury Offset Program (KTOP) Impact on SMART Processing • SMART and KTOP will interface data back and forth, and KTOP will also interface with the federal government. • SMART vendor payments will be subject to offset if the vendor has a debt in the federal program, similar to how vendor payment are currently subject to offset for state debts in KDRS.

15. Kansas Treasury Offset Program Impact on SMART Processing • Since the transfer of data will take time, we are estimating that the SMART cutoff for having vouchers included for paycycle on the same date will be 10 am. • This means vouchers have to be approved, budget checked, matched, and ready for paycycle by 10 am.

16. Kansas Treasury Offset Program Impact on SMART Processing • If a vendor is found to have a federal debt, the payment will be further delayed by one business day. • We have discussed the federal program with other participating states and found some have processes that delay vendor payments significantly longer. For example, Minnesota’s process delays their vendor payment by five days.

17. Kansas Treasury Offset Program Impact on SMART Processing • Testing with the federal government is scheduled for January and February 2015. • We are estimating this program go to production in SMART in March 2015.

18. Update on SMART User’s Group Request List • The SMART Team has recently re-evaluated this list and determined the following: • 58 total reported system issues • 21 have been resolved • 23 have been cancelled (no longer an issue, part of system learning curve, not practical) • 15 are on the list to be addressed during upgrade or after

19. 90 requested enhancements: • 18 have been implemented • 15 have been cancelled • 57 are in progress or not started yet The next slide contains a list of outstanding requests that will be re-evaluated during the SMART upgrade.

21. Security reminders when SMART users leave Prior to the user’s last day, find out if the user has: • private queries that need to be transferred to a different user • Enter a ticket in ManageEngine (SMART Service Desk) requesting for the query(s) to be transferred. • recurring reports or queries • Recurring reports should be cancelled and scheduled by a different user, if still needed. • For ending or cancelling recurring queries, see the Job Aid, Scheduling a Query, (http://smartweb.ks.gov/docs/default-source/reporting---job-aids/scheduling-a-query.pdf?sfvrsn=6).

22. Security reminders when SMART users leave • Find out if the user is included in any Workflow. • Take the steps necessary to set-up a different agency user to take over the responsibility. • Complete a security request to end the user’s access effective at the end of the day of termination. • Questions about security or workflow should be submitted on a ManageEngine (SMART Service Desk) ticket.

23. Long running queries and reports • Long running queries and report take system resources and can cause other processes to be delayed. • Reports or queries that continue past 6 pm can cause serious problems during nightly batch processing. • Users can cancel a report or a scheduled query by going to Process Monitor, selecting “Details” on the row for that process instance, and select the radio button “Cancel Request”.

24. Process Monitor page

26. Long running queries and reports • If a query has been executed in Query Viewer and needs to be cancelled, you can submit a ticket in ManageEngine (SMART Service Desk) to request for the query to be cancelled.

27. How to sign-up for SMART Announcements • Go to the SMART Web web site (http://smartweb.ks.gov/home) and enter your e-mail address and name in the Stay Informed box.

28. How to sign-up for SHARP Announcements • Go to the SHARP Customer Service page at http://www.da.ks.gov/sharp/, and follow the instructions.

29. Last items • Printing functions will transition from OITS to DofA Printing at the end of this November 2014. This should be transparent to agencies. • New address verification software is being considered. • Questions?