{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":117,"n_cols":1,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
["Annexure C1: High Level Business Requirements"]
[]
[]
["Oracle Finance/Procurement"]
["Requirement"]
["Procurement:Enable supplier collaboration"]
["Procurement: Automate supplier registration "]
["Procurment:Automate sourcing of procurement goods and services to exploit savings opportunities "]
["Procurment:automate the creationg of BPA upon contract approval."]
["Contract management solution with capability to sign legal documents online on thr system"]
["All financial reports and accounting process on the system must be aligned to IFRS"]
["Provide an end-to-end revenue management solution (aligned with IFRS, PAIA and CPA ) that will integrate all sources (Banks, students, legacy systems) of UNISA's revenue. The solution will include but not limited to the following: \n\n\n• Fees management.\n• Service revenue management\n• Debtor’s management.\n• Goods revenue management\n• Research revenue management\n• Manage staff recoveries\n• Pricing\n• Business Intelligence Dashboard\n• Integration to other existing solutions"]
["Automate the  tendering process "]
["Cash Mananagement:Automate allocation of payment to student accounts. Automation of bank reconciliations."]
["Cash Management: Enable creation of receipt & automate allocation of payment"]
["Asset: The lifespan of an asset is determined per asset category in consultation with Financial Governance. It is set ONCE only by Financial System Support and then hardcoded. Additions to a particular asset category will automatically take the hardcoded lifespan. LIFESPAN HAS TO BE IN LINE WITH UNISA FINANCIAL GOVERNANCE POLICY. If they change, for example, the lifespan of a computer from 3 to 8 years then that change must follow to the asset workbench otherwise it remains the same."]
["Asset:Asset reports must be in EXCEL format."]
["Asset:Automate the reconciliation of GL to asset registe"]
["Asset:Automate the asset verification process"]
["Asset:Automate the transfer and movement of assets."]
["Asset:Automate asset removals(permit to move an asset, known as F5)"]
["AP:AP  report to show the aging for each month"]
["AP:Petty Cash and Paycard development - Online application and Management of Settlements"]
["AP:Automate expense claims"]
["AP:Automate the capturing of supplier invoices"]
["GL:Additional adjustment period required based on how opening balances are reported on in the new financial year (1st Jan to 31st Dec)"]
["Budget:Provide an end-to-end budget solution to manage the planning, capturing and reporting"]
["Budget:Encumbrance account is required"]
["Finance and Procurement Analytics"]
["Budget: Old open requisitions with no Pos. Automate the reversal (Cancelled) of historic transactions  to release the Encumbrance"]
["Auto create an invoice from GRV "]
[]
[]
[]
[]
["Oracle HRMS/Payroll"]
["Requirement"]
["Organizational Design and Effectiveness\n• Position history to be stored\n• Skills and competencies to be linked to positions to ensure integration to the Talent Management, Performance Management and other systems\n• Automated online Job Description / profile capably linked to Organisation structure and competency framework"]
["Visual presentation of organization structure\n• Integrated organograms\n• Identification of competency gaps\n• Drill down functionality\n• Drag and drop functionality to see impact of changes and if approved via workflow changes to be effected on HR Core\n• Position and person reporting lines\n• Integration with intranet\n• Integration with all HR systems / modules\n• See organisational depth, headcount, total salary etc.(linking to BI)\n"]
["Integrated reporting tool that does not need any ICT intervention when a new report is requested"]
["Standard statutory reports updated when statutory requirements change"]
["HR Analytics\n• Integrated, real-time HR information\n• Available in multi formats (including Excel, Word etc.)\n• Dashboards – to include data of ALL HR modules\n• Standard and personalised dashboards and metrics\n• Analytical modeling\n• Visual presentation of data with drill down functionality\n• Access to data governed by security levels\n"]
["Online fully integrated recruitment system:\no Advert\no Application\no Selection process\no Extending offer\no Onboarding process\n"]
["Renumeration and Benefit Management\n• Salary Survey\n• What if salary scenarios (employee salary structuring)\n• Impact of remuneration changes (e.g. annual salary increases, pay progression) scenarios"]
["Talent\n• Career discussions, talent conversations with goals in line with Performance Management and Personal Development Plans\n• Manage succession planning"]
["Performance Management\n• Integrated with all HR modules especially Talent Management and Employee Relations for under performers\n• Fully online driven by workflows \n• Automated performance agreement and review process with templates based on organisational deliverables (APP)\n• 360 performance assessment functionality that includes behavioral and managerial competencies"]
["Employee Relations and Wellness\n• Integrated Employee Relations system \n• Case management system\n"]
["Employee Wellness\n• Integration with external service provider to enable real-time HR information and BI dashboards\n• Functionality to manage the HIV and campus clinic functions "]
["Employee Selfservice\n• HR app to enable offsite application of leave, leave balances, access to pay slips, increase letters, apply or training, benefit statements,  etc.\n• Integration with external service providers to enable employee to view Retirement fund balances\n• Attachment capability via camera phones or downloads\n• HR app to enable line managers to approve leave, have a global overview of leave in department, leave trend identification, training applications, performance reviews etc. via the app\n• Enable line manager to view employee detail / overview\n• Employee App to link employee to 3rd party site including Employee Wellness provider, Pension fund administrator\n• Employee to be able to update information via App\n• Compliance and governance wrt polices\n• Automated process initiation for identified process. E.g acting\n• Automated alerts and notifications of process that needs actioned e.g. approvals, acting and secondment end date up for review"]
["Appointment Process\n• Automate the recruitment process for permanent staff and eTutors\n• Integrate the appointment process of ETutors with teaching & learning systems\n• The appointment solution must integrate with the Oracle HR Claims solution( custom built or extension of HRMS as per Oracle standards).\n"]
["Cut-off dates must be captured on a table that will sweep transactions over to the following month should the capturing be done after the cut-off date. Appointments captured after the cut off dates must go through workflow for approval or decline by Payroll Manager.\""]
["HR Practitioners' SIT leave capturing must be automated to calculate leave payout amount upon employment termination."]
["Multiple Tax Certificates for one employee must be populated on self-service and availble for bursting(email to staff)"]
["Payroll must be integrated with banks to verify whether the person is banking with the bank. "]
["Integrate Payroll to Home Affairs databse, validation on ID and passport numbers as well as passport expiry dates and work permits."]
["Accumulated Vacation and Vacation leave types must be payable after termination of employment/contract. Integrate Absence Management between HR, Line Manager and Payroll."]
["Payroll:Selfservice functionality for staff to change banking details"]
["Payroll:Enable payments for 3rd Parties .This is deducted via payroll but must be paid via AP."]
["The payment of independent contract is done via a third-party custom built HR claims system using OAF.It is a complete claims module with approvals and contracting. This solution is integrated with payroll to pay the claims via payroll. When current HR moves to HCM cloud, UNISA will need a solution( either by means of synching HCM with EBS HRMS or alternative claims on cloud) to manage the claims  to avoid using two applications(EBS On-Prem and HCM cloud)"]
{"$rows_empty":8}
["SMPD"]
["Requirement"]
["Application Principles:\nThe interface must be centralized\nThe solution must have access control management\nUsers should be able to control content presentation. To be able to change look and feel of the application e.g. colours, fonts, styles, etc.\nUnisa branding elements should be accommodated in the style sheets of the web interface \nA User-friendly URL should be available for embedding on UNISA's intranet for easy linking, referencing and redirecting\nUsers should be able to access help documentation and user manual\nUsers should be able to navigate easily from one function to the other, backward and forward links between pages\nThe solution must be able to support hundreds of end-users and be scalable\nThe solution must be provisioned with enterprise grade real-time interaction platforms, autonomous capabilities for routine tasks and personalisation\nThe presentation layer of the application must be web based and where required be viewed on portal technology\nThe solution must have functionality to segregate duties\nReal-time management information (dashboards and analytics) is required to coordinate planning and execution of all activities in the value chain\nThe user interface layer must be easy to use and intuitive. User Experience is important.\n\n"]
["Planning:\nAcademics must have a platform to develop study material using various layout formats\nStudy material units that are due for revision must be automatically flagged\nThe solution must have business intelligence capabilities that highlight extent of late and outstanding study material units and certain instances compelling process custodians to act\nThe platform must have approval capabilities.\nThe platform must have version control capabilities\nThe platform must have engineering change order capabilities\nThe platform must have an archiving repository\nThe platform must be configurable to define templates to which academics must be able to upload print ready study material units\nThe print job request must assume a job number that will be used as a primary identifier throughout production lifecycle of the study material unit\nThe print job request, its status and all attributes must be visible to all internal stakeholders\nThe solution must be integrated with a forecasting tool that has capabilities to use multiple data sources to generate a forecast for each study material unit\nThe forecast must be configured to recommend print route of a study material unit\nUsers must be able to accept, override or reject the recommended forecast\nAcademics must be able to release print ready study material to SMPD\nDuring the development phase of the study material and when releasing the study material for printing, Academics must be able write notes and instructions that are to be released together with the print job request\nWhen releasing a print job request, machine constraints must be taken into account. In this regard, rescheduling must be considered.\n"]
["Sourcing:\nThe print job request, its status and all attributes must be visible to all internal stakeholders\nThe solution must be integrated with a forecasting tool that has capabilities to use multiple data sources to generate a forecast for each study material unit\nThe forecast must be configured to recommend print route of a study material unit\nUsers must be able to accept, override or reject the recommended forecast\nAcademics must be able to release print ready study material to SMPD\nDuring the development phase of the study material and when releasing the study material for printing, Academics must be able write notes and instructions that are to be released together with the print job request\nWhen releasing a print job request, machine constraints must be taken into account. In this regard, rescheduling must be considered.\n"]
[]
[]
["Printing:\nThe final product is the printed study material unit\nCosting of each print run must be captured for every standard operation\nThe business unit is comprised of various service divisions. \n"]
["Distribution:\nThe business unit responsible for delivery of study material is Despatch.\na) Once an item is in the store and allocated to a shelf, it becomes available for distribution to students via the postal system or by courier or to be collected by the student concerned.\nb) The study material is picked from the forward pick area shelves, packed into parcels and handed to either SAPO, a courier service provider for delivery to students or to internal Counter Services for collection.\nA mobile application is required to execute most of the warehouse management tasks. To this end, SMPD has handheld devices that have scanning capabilities\n"]
["Warehouse management, planning and demand analytics"]
[]
[]
["Integration requirements"]
["Requirement"]
["SMPD SAPO integration for student parcels"]
["Travel system for budget vaklidation"]
["Travel system for the creation travel invoices"]
["Travel system for the creation travel purchase orders"]
["Integrate the solution as per Annexure C2:Integration Requirements"]
["Travel system integration to pull HR hierarchy"]
["Travel system integration with Payroll for subsistance allowance"]
[]
["Network requirements"]
["Requirement"]
["Is the IPsec Tunnel enabled on the cloud side (If not, provide cloud security feature in place)?"]
[" "]
["Security requirements"]
["Requirement"]
["Is the proposed system able to not persist personnel data in the cloud, this in line with the Protection of Personal Information Act No 4 of 2013"]
["Does the application use the extended validation for encryption"]
["The system must be able to control access to a resource by granting or denying access to individual users or named groups of users. Users must identify themselves in a unique manner, such as by password, when they log on. All editable actions must identify the user performing the action."]
["Can the system enable the administrators to audit security-related events. However, access to the security-related events audit data must be limited to authorized administrators?"]
["Is the system protected from external interference or tampering, such as modification of the running system or of system files stored on disk?"]
["The system must be able to authenticate via AD"]
[]
["EBS 12.1.3 Payroll Upgrade Requirements"]
["Requirement"]
["Lift and shift EBS 12.1.3 to cloud"]
["Upgrade 12.1.3 Payroll to the latest release 12.2 version"]
["Retrofit   the extended or custom built HR claims solutions to make sure it works on the upgraded environment. Please see Annexure C1 Claims Process for further details on what this solution is about"]
["Retrofit all custom built solution to work on the upgraded environment"]
[]
["Training requirements"]
["Requirement"]
["Customer Specific Onsite Training"]
["Train the trainer"]
["Train user community"]
["Introductory technical and functional support training"]
["Training Material"]
["Training Schedule"]