1 / 46

SoftWorkload 2013 Excels Excursion and Views

This report defines SoftWorkload activities and captures workload data from American and Canadian clients. It includes reports, statistical analysis, and access to Oracle Views for advanced reporting.

pdobbs
Download Presentation

SoftWorkload 2013 Excels Excursion and Views

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SoftWorkload 2013Excels Excursionand Views Presented by: Betty Kramer . Michal Kukula . Jaleh Siyan

  2. Excursion Objectives SoftWorkload System Purpose American Canadian Journey Reports … Reports … Reports SA Base Report Defining SoftScape Report Defining New WKL Excels = SoftReport New WKL Excels = Ftp VIEWS = Oracle New SoftBI =Business Intelligence

  3. Purpose SoftWorkload accomplishes 2 goals … CAPTURES soft data REPORTS soft data

  4. Workload CAPTURES from …

  5. SoftWorkload Activities  Time SoftWorkload is all about … LIS Activities and your working time! Activities SoftWorkload captures Activities defined & saved in SoftWorkload SETUP SoftWorkload Activities are module specific – LAB, MIC, BB, AP, GENE, Rx SoftWorkload Activities are Service Recipient and Non-Service Recipient Time In SoftWorkload, the Unit Value is the “element of time” EXAMPLE: Unit Value 1.0 is the equivalent of 1 minute of TECH time EXAMPLE: Unit Value 5.0 is the equivalent of 5 minutes of TECH time MIS Standards drive SoftWorkload Activities for Canadian Clients MIS Standards 2013 2011 2009 …. Resource Allocation FTE’s LMIP and CAP drive SoftWorkload Activities for American Clients Managerial Reporting Statistical Reporting FTE’s

  6. MIS Standards 2013 for Canadian Clients Workload Measurement – Clin Lab • Schedule of unit values updated as part of the ongoing MIS maintenance process • MIS Enhancements include: • adding Activities, previously not defined • clarification of some Activities • wording enhancements • Unit Values adjusted according to new information received

  7. WKL Reports - old & new Legacy Reports – SA Base SoftReport Reports – pdf Excel Reports – SoftReports Excel Reports – Ftp Oracle VIEWS - External Reports

  8. Where can I generate Reports? 1-CAPTURING Monitor Reports 2-Non-Patient Non-Patient Activities Reports 3-REPORTS Weekly Monthly Quarterly Yearly Standard Calendar or Fiscal Calendar Reports COLUMN Category – define 1 COLUMN ROWS Categories – define 1, 2, 3, 4, 5, 6 up to 7 ROWS 4-SETUP Statistical Report Definition is the defining format for “Custom Reports” Automated Non-Patient Scheduler Reports Print Scheduler – “Automated Reports” 4 Reporting Time Frames forPrint SchedulerReports: Weekly Monthly Quarterly Yearly

  9. WKL Reports – more about it Excel Reports:Ftp accessible, Csv file, Can work as interface Excel Reports inSoftReports: .pdf to .xlsTransition, browser accessible User interaction Oracle VIEWS:For external reporting tools;Supports Workload logic for uv and no.

  10. SoftWorkload Report Defining – Screen 1

  11. SoftWorkload Report Defining – Screen 2

  12. SoftWorkload Report Defining – Screen 3

  13. WKL Ftp Excel EXAMPLE 1 Ftp no. Ftp uv

  14. Workload Ftp Excel Value: no.EXAMPLE 1 enlarged

  15. Workload Ftp Excel Value: uv EXAMPLE 1 enlarged

  16. Workload Ftp Excels SoftWorkload Excel Reports in new csv format with access through ftp Reports divided into 2 separate files “no” value file – number “uv.” value file - unit value Last COLUMN is the “Total” sum of Columns, formula Last ROW is the “Total” sum of ROWS, formula Filter Value Capability, Usability Precision by uv acceptance 0.0 0.00 0.000 Ftp Directory Storage Provided Print Scheduler Usability – WldCsv printer

  17. SoftWorkload SoftScape Report Defining - Screen 1

  18. SoftWorkload SoftScape Report Defining - Screen 2

  19. SoftWorkload SoftScape Report - Screen 3 View_file V

  20. SoftWorkload SoftReports Excel EXAMPLE 2

  21. WKL SoftReport Excels Workload Soft Report Excel Reports with access through popping up Internet browser Reports contents divided into 2 separate sections “no” value file – number “uv.” value file - unit value Filter Value Capability, Usability Precision by uv acceptance 0.0 0.00 0.000 Designed for interaction – user can manually print and instantly get report Prints toView only

  22. View– Oracle Object View is an object of Oracle Views enable user to pull raw data from Oracle Database and to display that data in a manner the user desires to see Each View is created according to user’s needs Many different Views can be created

  23. View– Workload Workload Views provide easy access to the Workload Working Database Internally, Workload Views use Oracle functions and implement Workload business logic. SQL Developer allows easy access to display views (it is part of Oracle package)

  24. SQL Developer a

  25. Four Workload Views VW_WLD_METH_FIRST VW_WLD_METH_SECOND VW_WLD_METH_THIRD VW_WLD_METH_FORTH

  26. View – First Methodology

  27. View – First Methodology

  28. View – First Methodology

  29. View – First Methodology

  30. View – Single Record

  31. View – Query

  32. View – Query

  33. View– Advanced Reporting • Views enable users to access any advanced reporting tools • Building Oracle Views for Workload brings us a new possibility to further expand the system with new Custom Report Tools • SCC has built an advanced reporting tool called “SoftBI” • Different modules like SoftAR, SoftExpress, SoftLAB have been utilizing SCC’s SoftBI

  34. SCC’s Business Intelligence reports platform Powerful engine for data mining and data transformation Statistical and analytical utility for executive users Access large amounts of data quickly and efficiently Provides dynamic and interactive reports (flexible and not static) Advanced Report Visualization Tool (graphics) SoftBI Soft Business Intelligence

  35. SoftBI–Workload

  36. Report – Text Table Format

  37. Report – Stacked Bar Format

  38. Report – Data Visualization

  39. Report –Data Visualization

  40. Report – Side By Side Bar Format

  41. Publish to server for end user

  42. PDF Format

  43. Crosstab Spreadsheet Format

  44. Build - Test - Validate Build Your WMS Build Workload Activities using hard coded Basic Routines for Templates Test Your WMS Test the Workload Activities that you build by processing orders & cases Validate Your WMS Validate each and every Workload Activity you build. You want to be sure your Workload captures and report correctly. Save a hard copy of your SETUPS.

  45. SoftWorkload Team Rafal Wojnar, Development Manager Ela Wiercioch, Architect Programmer Michal Kukula, Programmer Jaleh Siyan, Oracle Specialist Betty Kramer, Product Specialist THANK YOU for attending!

  46. Questions?We Welcome Questions!

More Related