CTCLINK PROJECT UPDATE CTCLINK STEERING COMMITTEE April 23

  • Slides: 26
Download presentation
CTCLINK PROJECT UPDATE CTCLINK STEERING COMMITTEE April 23, 2019 • Choi Halladay - District

CTCLINK PROJECT UPDATE CTCLINK STEERING COMMITTEE April 23, 2019 • Choi Halladay - District Vice President for Administrative Services Pierce College, ctc. Link Steering Committee Chair • Christy Campbell – SBCTC ctc. Link Project Director Rev. 4/22/2019

AGENDA Item 1. 2. 3. 4. 5. 6. 7. 8. 9. Description Welcome Approval

AGENDA Item 1. 2. 3. 4. 5. 6. 7. 8. 9. Description Welcome Approval of Minutes ctc. Link Program Status Remediation (CCS, TCC Updates) Deployment Group 2 (Training, Testing, Deployment) Deployment Group 3 (BPFG. Data Validation) Deployment Group 4 (Initiation) Deployment Group 5 (Early Visits/Reporting) PM Summit, May 6 -7; May 8 for DG 5 & DG 6 Deployment Group Alignment Decision for Shoreline CC Revisit CPW Approvals by Governance (HRMC Request) RFP Updates: Continuing Education (Negotiations, New Requests) OAA (Discuss Approach to complete Moran Update Action Items Review and Agenda Items for Future Meeting Executive Sponsor Engagement • c. ELC/President Engagement • SC Charter – Executive Sponsor Role Meeting Closure Duration Facilitator 2 Minutes 30 Minutes Christy Choi Christy 15 Minutes 10 Minutes 20 Minutes Christy Dennis 5 Minutes 8 Minutes Paul Christy/Janelle/ Reuth Christy 2

CTCLINK MINUTES – APPROVAL • April 9, 2019 3

CTCLINK MINUTES – APPROVAL • April 9, 2019 3

CTCLINK PROGRAM STATUS Remediation (CCS, TCC Updates) Deployment Group 2 (Training, Testing, Deployment) Deployment

CTCLINK PROGRAM STATUS Remediation (CCS, TCC Updates) Deployment Group 2 (Training, Testing, Deployment) Deployment Group 3 (BPFG, Data Validation) Deployment Group 4 (Initiation) Deployment Group 5 (Early Visits/Reporting) PM Summit: 2 Days - Focused on College Implementation 4

PILOT REMEDIATION OVERVIEW & STATUS Date Total Open Items With a Plan to Complete

PILOT REMEDIATION OVERVIEW & STATUS Date Total Open Items With a Plan to Complete (Appendix A) • • • Open Items That Were Closed, but Open Items Reopened in Needing a Replacement Remediation Solution Agreement (Appendix A) (Appendix B) 2016, 2017, 2018 • Financial Books Absence Management • (DG 2) DRS Redistribution (In • Testing) Continuing Education Online Admissions Budget Planning • Financial Aid Customizations 11/29/17 195 101 10 84 12/13/18 41 29 10 2 4/01/19 23 11 10 2 *First. Link (pilot) colleges are validating open and closed items/numbers 5

ctc. Link Remediation Status Reports – April 1 to 12, 2019 Solution Status Due

ctc. Link Remediation Status Reports – April 1 to 12, 2019 Solution Status Due Date Campus Solutions 10 of 45 remain open DG 3 Financial Management 5 of 39 remain open DG 2 Human Capital Management 6 of 25 remain open DG 2 Faculty Workload Complete March 2019 DRS Redistribution Preparing for UAT April 2019 Absence Management Complete Security Audit Controls Chart of Accounts Due/Finish Status TCC Chart of Accounts Adoption Kickoff Dec. 12, 2018 Complete CCs Chart of Accounts Adoption Kickoff Feb. 1, 2019 Complete Foundational Chartfield Configuration March 22, 2019 Complete April 2019 College Configuration Review and Updates May 3, 2019 In Progress Security Redesign Mapping Framework FLC / DG 2 Functional and System Integration Testing May 10, 2019 In Progress Student Billing/Third-Party Billing Complete April 2019 User Acceptance Testing Not Started Budget Planning Form Work Group Jan 2020 May 10 - June 3, 2019 Online Admissions App Governance DG 2 Readiness Gate / Go-No Go Decision June 10, 2019 Not Started Continuing Education Vendor Negotiations DG 3 Production Cutover July 2019 Not Started Community Colleges of Spokane R Remediation Items progress this period ü Student Billing – UAT held Wed 4/11. CCS found two issues. ü Security Audit Controls – In progress. Bank Statement se ü Accurate Reporting for DRS & PEBB - Ready now for System Integration Testing. New SBCTC ticket created to address DRS redistribution ü Third-Party billing – Failing System Integration Testing. UAT TBD. ü FY Close – see previous slides. ü Book-to-Bank - Cash Reconciliation - Focus now is on reconciling the three cash accounts making up our $18 -million variance (same accounts for TCC). SBCTC Project team working on providing reports/workflow of behind the scenes ctc. Link processing of the transactions going into these accounts. Can’t close FY 16, 17, 18 without reconciling cash accounts. Tacoma Community College G Remediation Items progress this period ü See SBCTC status update for Remediation items, tickets, and worklist. Planned for next period q Receive detail for open and closed remediation tickets from Christy and team. First requested March 27; follow-up email April 12. q TCC SMEs participate in Budget Planning Tool workgroup. *If status is yellow or red, describe why. § Absence management passed UAT, but CCS validating some calculations. § Student Billing UAT complete, CCS had a couple issues. § Third-Party Billing & DRS pending UATs. § Unable to close FY 16, 17 & 18 until cash reconciliation is completed. § 39 open remediation tickets. 6

Project Status – April 1 to 12, 2019 Overall Project Status Summary Category Overall

Project Status – April 1 to 12, 2019 Overall Project Status Summary Category Overall Status Y Comments • • Schedule Y Scope Y Budget G Executive Summary • • • Program is on track, per timeline, scope and budget DG 2 Training content development and UAT framework making good progress Security Mapping activities impacting UAT Monitoring scope and timing of Budgeting Tool, Continuing Education, Online Admissions Application, Physical Assets and OBIA implementations Requirements Traceability Matrix (RTM) needs to be updated to validate original RFP requirements have been implemented, tested, and end users trained on the processes and functionality Currently tracking under budget New Technology Plan approved as well as Stage Gate #3 for OFM/OCIO Technology Pool funding Overall Status Summary per Deployment Group DG# Status Comments • DG 2 Y DG 3 G DG 4 DG 5 G • • • Significant progress in the build of Training content and UAT Framework Security Mapping activities impacting UAT College resources have been engaged in BPFG Workshops Conversion cycles have began DG 4 - College teams working on Initiation Phase activities DG 5 - Started tracking college Initiation and incorporated in status reports Christy The project is tracking per schedule and under budget. Review and definition of scope for each deployment continues due to the rework of key solutions. Each Deployment Group (DG) is now engaged in the project at some level. • DG 2 is in the Construct Phase and the ctc. Link project team is performing DG 2 System Integration Testing (SIT) and conversions. Conversations are underway to set go-live dates. • DG 3 is in the Structure Phase, focused on Business Process Fit/Gap sessions (BPFG) through May. • DG 4 is in the Initiation Phase, with most colleges nearing the halfway mark on deliverables. • DG 5 colleges have begun Initiation Phase and are learning the public status reporting process. DG 5’s first report is included in this status update. • DG 6 will soon begin initiation phase and reporting process. The spring 2019 Project Managers Summit will be held at Wenatchee Valley College, with May 6 -7 focused on overall Implementation Phase activities for all colleges and May 8 focused on the Initiation Phase for DG 5 and DG 6. Contract negotiations are underway for a new Continuing Education solution. The Online Admissions Application (OAA) work group is actively pursuing an OAA replacement. The Budget Planning Tool work group is reviewing and finalizing business and technical requirements. Overall Timeline (All Deployments) 7

Budget Status – as of March 31, 2019 G 8

Budget Status – as of March 31, 2019 G 8

Deployment Group 2 Self-Reported Status – April 1 to 12, 2019 Clark College Y

Deployment Group 2 Self-Reported Status – April 1 to 12, 2019 Clark College Y Planned for next period q Completion of Data Validation cycle #4 4/26 for HCM, 4/24 for FIN q Follow-up ADKAR overview 4/22 Planned for next period q Continue to assign people and timelines to Change action work plan. q Create an email user group for current legacy users. Planned, but not completed • n/a Planned, but not completed • Create an email user group for current legacy users. *If status is yellow or red, describe why. The Awareness overview has revealed a number of areas of opportunities to close gaps. *If status is yell or red, describe why. College is trending red due to discussion of date change for Go-Live. This has caused skepticism and uncertainty by SMEs and staff. UAT training plan also impacts college flexibility and schedule. Accomplished this period ü Local SMEs attended ctc. Link Security redesign group, ctc. Link PM groups, ctc. Link governance groups, various ctc. Link status meetings ü Participated in ctc. Link Security redesign activities ü Participated Chart of Accounts meetings. ü Provided UAT testers to SBCTC. ü Attempted to reserve a dedicated ctc. Link room for DG 2 at Tacoma. ü Participated Cycle 1 Data validation meeting. Planned for next period q Participate in Conversion Cycle Data Validation as needed q Local SMEs attend ctc. Link Security redesign group, ctc. Link PM groups, ctc. Link governance groups, various ctc. Link status meetings q Local SME participate in CE negotiations q Local SME attend Chart of Accounts meetings Y Accomplished this period ü HR (non Payroll) business processes reviewed for change impacts 4/10 ü “Awareness” Overview for the agency conducted 4/3 ü Working with Bill Welch and Johnathan Rider on security mapping. The plan is to use elevated permissions for the first UAT Sprint. 4/11 ü Risk Management team formed completing initial meeting 4/1 Accomplished this period ü Continued to work on course catalog cleanup. ü Completed 7. 5 hours of webex to review data validation materials for cycle 4. ü Prepared all materials for cycle 4 data validation. ü Financial Aid has planned out deadlines and system shut down for the Oct 28 Go Live. Tacoma Community College SBCTC Agency R Community Colleges of Spokane G R Accomplished this period ü Chart of Accounts Redesign • CCS Budget/Finance reviewing/validating mapping spreadsheets. 4/5 thru 4/19. In progress. • FY Close – CCS continues to adjust journal entries. • Uploaded schedule/Q&A/Check list to Box folder • UAT’s for Student Billing, POI security issues, and SSN new query security tree. Planned for next period q Security Role Redesign q Chart of Accounts Redesign q Security Issues *If status is yellow or red, describe why. § Remediation Conditions involving Absence Management UAT and open items. § FY 16, 17 & 18 unable to close until cash reconciliation is completed. § Co. A Activities – reviewing local mapping files. § Urgent Security Issues – sensitive financial and employee query data available across all FLCs. § Security Role Redesign: waiting on documents to assist with role mapping, and cutover/implementation process. Concerns with newly communicated plan to test new security roles. 9

Deployment Group 3 Self-Reported Status – April 1 to 12, 2019 Cascadia College G

Deployment Group 3 Self-Reported Status – April 1 to 12, 2019 Cascadia College G Accomplished this period ü Attended all BPFG sessions to date ü Completed all but 2 BPFG homework assignments due this period ü Initiated CS and HCM data validation Planned for next period q Continue data validation & OTM issue input for Cycle #1 q Initiate DG 3 Cycle #2 data error extract cleanup q Continue BPFG attendance and homework completion Planned, but not completed • Late completing 2 Finance BPFG homework assignments, Finance working with SBCTC CS Pillar PM to complete prior to 4/16/19 Olympic College Accomplished this period ü Attended BPFGs ü Submitted BPFG Homework ü Continued Data Cleansing ü Started Data Validation Cycle Planned for next period q Homework q Data Cleansing q Attend BPFGs q Hire third Analyst q Data Validation Planned, but not completed • Additional CIA Workshops G Lower Columbia College G Accomplished this period ü Work with Alignment Team to complete current BPFG sessions and homework ü Complete onboarding critical staff through PS fundamentals ü Work with staff to assemble training requirements and logistics for project team ü Onboarded LCC query developer team and started designing tracking mechanisms for query management ü Started work in Cycle 1 conversion validation work. Planned for next period q Continue SME participation in all GDA and BPFG sessions as needed. This includes completion of CIA work as an outcome of BPFG. q Continue on campus messaging and communication about ctc. Link q Continue to develop forecasting tools to track staff workload and project hours. q Complete Cycle 1 conversation validation and start prep for Cycle 2. Peninsula College G Accomplished this period ü Continued to participate in BPFG sessions. ü Submitted BPFG homework assignments per BPFG session requirements. ü Organizing Data Validation efforts to meet April 24 deadline Planned for next period q SMEs continue to participate in BPFG Sessions. q Continue to coordinate and submit BPFG homework assignments q Continue conversation regarding Go Live date. q Complete Bio/Demo data validation for both CS and HCM. Pierce College District G Accomplished this period ü FIN & HCM SMEs participated in BPFG sessions. ü SMEs participated in Data Validation Web. Ex sessions. ü SMEs participated in CPW kick-off ü Completed all homework to date. Planned for next period q SMEs complete data validation. q SMEs attend/participate in BPFG sessions in person and via Web. Ex. q SMEs complete homework assignments Planned, but not completed • Complete additional Change Impact Analyses (CIAs). • Review applicants for project positions. • Onboarding of newly hired project employees. • Review and update internal Training Plan with college Training Team. 10

Deployment Group 4 Dashboard Reports – April 1 to 12, 2019 DG 4 Initiation

Deployment Group 4 Dashboard Reports – April 1 to 12, 2019 DG 4 Initiation Phase Completion Summary As of April 12, 2019 College/District Centralia College 38% Edmonds Community College 60% Highline College 52% Seattle Colleges (3) 47% Wenatchee Valley College 45% Percentage of deliverables completed and tracked in Project Web App (PWA) by each college: • College Orientation & Resourcing • College Project Planning (from templates) • Conduct Initial Data Cleansing • Document Current Legacy Business Processes • Supplemental Systems Analysis DG 4 Pre-Implementation and General Timeline G 11

Deployment Group 5 Dashboard Reports – April 1 to 12, 2019 DG 5 Initiation

Deployment Group 5 Dashboard Reports – April 1 to 12, 2019 DG 5 Initiation Phase Completion Summary As of April 12, 2019 College/District Bellevue College No Data Reported Bellingham Technical College 14% Big Bend Community College 11% Everett Community College 6% Grays Harbor College 19% Green River College 6% Skagit Valley College 9% Whatcom Community College 17% Percentage of deliverables completed and tracked in Project Web App (PWA) by each college: • College Orientation & Resourcing • College Project Planning (from templates) • Conduct Initial Data Cleansing • Document Current Legacy Business Processes • Supplemental Systems Analysis DG 5 Pre-Implementation and General Timeline G 12

PM SUMMIT • Agenda Prep (Collaboration with College from each DG) • Dates: •

PM SUMMIT • Agenda Prep (Collaboration with College from each DG) • Dates: • May 6 & 7 – All Colleges (Implementation Activities) • May 8 - DG 5 & DG 6 (DG 4 optional) focused on Getting Ready for Implementation (Initiation Activities) • Location: Wenatchee Valley College 13

DEPLOYMENT GROUPS AND TIMELINE Deployment Changes: • Bellevue: DG 4 to DG 5 •

DEPLOYMENT GROUPS AND TIMELINE Deployment Changes: • Bellevue: DG 4 to DG 5 • Columbia Basin: DG 4 to DG 6 • Shoreline: DG 5 to DG 6 requested 14

INITIATION SCHEDULE HIGHLIGHTS This chart shows when each deployment group (DG) begins its first

INITIATION SCHEDULE HIGHLIGHTS This chart shows when each deployment group (DG) begins its first phase (initiation) and estimated Go-Live date. Dates subject to adjustment. Activity DG 3 DG 4 DG 5 DG 6 Feb 2018 March 2018 July 2018 March 2019 Dec 2018 Jan 2019 March 2019 Nov 2019 Gate 1: Implementation Readiness Dec 2018 July 2019 Oct 2019 July 2020 Implementation Phase Jan 2019 – Feb 2020 Nov 2019 Jan 2020 Sept 2020 (Depends on DG 2 Go-Live) (Depends on DG 3 Go-Live) (Depends on DG 4 Go-Live) Go-Live Feb 2020 Oct 2020 Feb 2021 Oct 2021 Begin Initiation Phase Work (Identify project manager, create project schedule, begin readiness efforts) Start Public Reporting (status reports, risks & issues) Revised 2/20/2019 15

DEPLOYMENT GROUP ALIGNMENT Background • Shoreline Community College requests to move from Deployment Group

DEPLOYMENT GROUP ALIGNMENT Background • Shoreline Community College requests to move from Deployment Group 5 to Deployment Group 6. • Discuss the impacts of adding a college to DG 6 or leaving DG 5 as is. Pros/Reasons for moving to DG 6 Considerations • Lack of readiness or participation in past and current PM/OCM activities • Peer Review for DG 5 colleges to enter implementation phase is only five months away • Resource challenged with new interim PM • Better for DG 5 overall, because DG 5 is the first deployment group with a technical college • Risk to DG 5 due to lack of readiness • Reduces impact to DG 6 • At nine colleges, this makes DG 6 the largest • Resource strain on project staff for large DG 6 Recommendations • The ctc. Link Project Management Office recommends granting Shoreline Community College’s request in order to minimize impact to both DG 5 and DG 6. • To ensure college readiness, no further college movements are recommended 16 within the deployment groups.

ONLINE ADMISSIONS (OAA) UPDATE • OAA Quick Wins (Current Improvements to Application in Production

ONLINE ADMISSIONS (OAA) UPDATE • OAA Quick Wins (Current Improvements to Application in Production for FLC’s) • Final Interviews with Colleges and Universities • OAA Work Group feedback • OAA Work Group Recommendation 17

CONTINUING EDUCATION UPDATE • Negotiations Update • Questions • Global Approach for consistent student

CONTINUING EDUCATION UPDATE • Negotiations Update • Questions • Global Approach for consistent student experience • Pricing aligned based upon college size and enrollment • Integration for ctc. Link Campus. CE baseline 18

ctc. Link Quality Assurance Scorecard Consulting March ctc. Link Quality Assurance. Moran Scorecard. Technology

ctc. Link Quality Assurance Scorecard Consulting March ctc. Link Quality Assurance. Moran Scorecard. Technology - Moran Technology Consulting. Report: , NOVEMBER 2018 2019 STATUS G G Y Y PROJECT AREA DESCRIPTION / NOTES SBCTC/Governance framework continues to work as expected. Meetings are held according to schedule, with materials distributed beforehand, and decisions made at the appropriate level. Project Management Office (PMO) is fully staffed, working well together and continuing to address improvements in project management processes. Phase Scope QA concerned about implementation schedules for replacement solutions. Impacts to scope and schedule for DG 2 and DG 3 will be more defined once solutions are selected. Schedule Status DG 2/DG 3/DG 4 schedules and resource constraints now directly impact all deployment groups. Schedule compression and key project resources are heavily allocated to tasks. The decisions and actions taken by PMO have enabled recovery of this key work stream. The external contractor supporting delivery of training materials has made good progress with the Finance and HCM pillars. PMO has decided to coincide just-in-time targeted training with UAT Sprints which achieves a number of positive benefits. Training This work stream is yellow, but is now trending green due to changes made by the PMO. The PMO has added another PS experienced key resource for this work stream. DG 2 Testing work stream relies heavily on availability and expertise of functional project staff. Testing Y Overall Status G Configurations / Data Conversion Technical work for DG 2 System Configurations and Data Conversion Cycle 4 is underway with good results reported. G Organizational Change Management (OCM) PMO/OCM is actively engaged with all colleges now involved with their Deployment Groups. QA concerned that PMO focus remains on the DG 2 schedule. G Y Project Staffing Technical Environment LEGEND Risk Description: Project staffing is adequate at this time and continues to make staffing adjustments as appropriate. QA and the PMO remain concerned that the overlap of DG 2/DG 3/DG 4 may require additional project and contractor resources. Project leadership and staff morale is positive given schedule pressures. Future PS updates/bundles and 3 rd party software installation and support work is being managed by the IT Division outside of the project responsibility. Overall planning of these changes needs to be tightly integrated with the ctc. Link DG 2/DG 3/DG 4 schedules. This becomes more challenging with the overlap in implementation schedules. GREEN Low risks may be encountered. NO immediate action needed YELLOW Moderate risks may be encountered. Serious deficiency and action item recommended. RED High risks may be encountered. Needs to be escalated and can impact project effort or cost. 19

OTHER DISCUSSION ITEMS • -Executive Sponsor Engagement • -c. ELC/President Engagement • -SC Charter

OTHER DISCUSSION ITEMS • -Executive Sponsor Engagement • -c. ELC/President Engagement • -SC Charter – Executive Sponsor Role • Subgroup to review Steering Committee Charter • Recommendations for addressing colleges in postproduction that may no longer have an Executive Sponsor • Executive Sponsor title is currently a requirement for nominee to serve on ctc. Link Steering Committee 20

QUESTIONS? Note: All material licensed under Creative Commons Attribution 4. 0 International License.

QUESTIONS? Note: All material licensed under Creative Commons Attribution 4. 0 International License.

REMEDIATION OPEN – FINANCE # Item # Description Status Planned Date Adjusted Date 1

REMEDIATION OPEN – FINANCE # Item # Description Status Planned Date Adjusted Date 1 19057 Ability for each organizational unit to develop and modify a budget at any level of the organizational structure and at any level of the program structure, throughout the budget development process. Open DG 3 2/1/2020 Needs RFP 2 19297 Distribute and report labor costs based on user-defined criteria, with full integration and reconciliation of data between GL, Payroll, and Student. Closed 8/1/2018 Updated Training Content 3 19299 Provide a journal entry toolset, including but not limited to a standardize spreadsheet template, to facilitate streamlined journal entry and upload. Closed 8/1/2018 Updated Training Content 4 19304 Standardize sub-objects and mapping to a system-wide structure for each unique GL created at the college-level. Closed 1/1/2018 7/1/2019 New COA Design 5 19323 Supports GL account verification across applications. Open 2/1/2018 TBD FY Deliverable 6 19342 Support vendor payment advance process based on user-defined criteria (e. g. , each college is authorized to draw an advance against the State Treasurer, with the amount equal to 17% of preceding biennium's monthly allocation). Closed 12/1/2017 SB Process Provided 7 19382 Integrate seamlessly with receivables processes to collect funds from vendors and recoverpayments. Closed 8/1/2018 Updated Training Content 22

REMEDIATION OPEN – FINANCE, CONT’D # Item # Description Status Planned Date Adjusted Date

REMEDIATION OPEN – FINANCE, CONT’D # Item # Description Status Planned Date Adjusted Date 8 19454 Create and maintain as many payment forms and templates, including remittance detail, as required to meet institutional needs and local needs of individual colleges. Closed 8/1/2018 Updated Training Content 9 19633 Enable reconciliation process based on user-defined business rules (e. g. , able to identify transaction source). Open 1/1/2018 TBD FY Deliverables 10 19747 Calculate and report indirect costs based on user-defined criteria. Closed 2/1/2019 ERP Support 11 19968 Track grants separately from G/L Chart of Accounts and reconcile the two. Closed 2/1/2019 Updated Training Content 12 20212 Comparison of Actual to Budget (Revenues/Receipts and Expenditures) Open 12/29/2017 2/1/2020 Need RFP 13 N/A - 39 Must configure system to utilize email correspondence to vendors for all PO’s. Closed 1/1/2019 Updated Training Content 14 N/A - 41 College needs a budget development system that allows for adequate budget building process. Open DG 3 2/1/2020 Need RFP 15 19713 Dispose of financial and non-financial assets. Closed DG 2 Updated Training Content 23

REMEDIATION OPEN – HUMAN RESOURCES # Item # Description Status Plan Date Adjusted Date

REMEDIATION OPEN – HUMAN RESOURCES # Item # Description Status Plan Date Adjusted Date 1 20596 Faculty Workload to generate and modify documents and pay for adjunct faculty based on user-defined criteria (4 Phases to resolve / 2 Phases remaining) Closed 3/1/2018 Package 1. 75 -12/31/2018 Package 2 – 3/1/2019 2 29976 Develop and Re-run the ESD report Closed 12/1/2017 TBD - TCC to Test 3 37532 Bio-Demo data values not aligned with CS and HCM Closed 12/1/2017 12/31/2018 4 20753 Establish contract pay based on user-defined criteria. Open 1/1/2019 TBD - Needs CPW 5 20573 Need ability to report on department budgets Open 1/1/2019 TBD Needs Budget Tool 6 N/A - 0 DRS Redistribution Open 4/30/2019 – ERP SIT 7 N/A - 27 Step Movement / Needs CEMLI Open 1/1/2019 DG 2 - 10/24/2019 In Development 8 N/A - 29 Spokane would like to participate in UAT process for upcoming DGs implementing the Recruitment module. Closed DG 2 4/29/2019 9 N/A - 31 Migrate ctc. Link framework to Wave 1 framework (related to Absence Management) Open DG 2 - 10/24/2019 10 N/A - 32 Create “day” definition / Absence Management and Time & Labor issue Open 12/1/2017 DG 2 - 10/24/2019 11 N/A - 34 Provide list of employees missing area codes / Legacy Data Issue Closed 12/1/2017 9/14/2018 24

REMEDIATION OPEN – CAMPUS SOLUTIONS # Item # Description Status Planned Date Adjusted Date

REMEDIATION OPEN – CAMPUS SOLUTIONS # Item # Description Status Planned Date Adjusted Date 1 20797 Support continuing education registration process where student can browse courses without logging on Open DG 3 2/1/2020 In Negotiations 2 20901 Provide the ability for continuing education students to enroll directly in classes (i. e. , application is not required). Open DG 3 2/1/2020 In Negotiations 3 21359 Allow payment online for continuing education based on user name and password. Open DG 3 2/1/2020 In Negotiations 4 21505 Perform third-party billing based on user-defined criteria (e. g. , by student, consolidated). Closed 5/1/2018 10/24/2019 GDR Approved 5 20814 Provide the ability for continuing education students to enroll directly in classes (i. e. , application is not required). Open DG 3 2/1/2020 In Negotiations 6 21293 Support streamlined admissions processing and user interface. (Online Admissions Application) Open DG 3 2/1/2020 Evaluation 7 N/A - 13 Effective Dating: FA Term, FA Budget and other areas have defective Effective Dating Closed 12/1/2017 TBD 8 N/A - 15 Reconciliation queries haven’t worked correctly or accurately since Go Live. Open 3/1/2018 5/30/2019 FY Deliverable 9 N/A - 22 Error/exception report identifying discrepancies between financial aid system and the general ledger (2 nd Journal Set) Open 12/1/2017 5/30/2019 FY Deliverable 25

REMEDIATION OPEN – CAMPUS SOLUTIONS, CONT’D # Item # Description Status Planned Date Adjusted

REMEDIATION OPEN – CAMPUS SOLUTIONS, CONT’D # Item # Description Status Planned Date Adjusted Date 10 N/A – 12 SAP Setup Effective Dating doesn’t work (Oracle Bug ID 24667042) Open 6/1/2018 TBD Waiting on fix from Oracle Workaround in place 11 N/A – 17 Converted student account balances must be completely audited / corrected to reflect the ending balances from Legacy. Open 6/1/2018 5/30/2019 FY Deliverable 12 N/A – 18 Reports to reconcile student financial transactions for a given day to the general ledger by item type, chartstring and fund. Open 5/1/2018 5/30/2019 FY Deliverable 13 N/A – 19 Need accurate reports in the CS pillar for Student Financials to summarize data such as insurance, fees, waivers, etc. Open 5/1/2018 9/30/2018 14 21451 Maintain academic standing for financial aid eligibility, based on multiple, user-defined criteria Closed N/A 9/30/2018 15 21338 Track satisfactory academic progress (SAP). Closed N/A 9/30/2018 26