Project Overall Status July 8 to 19 2019

  • Slides: 15
Download presentation
Project Overall Status – July 8 to 19, 2019 Overall Y Schedule Y •

Project Overall Status – July 8 to 19, 2019 Overall Y Schedule Y • • • Program is on track, per timeline, scope and budget Security Mapping activities impacting completion of UAT Current DG 2 Schedule has no “float” remaining in timeline • Monitoring scope and timing of: Budgeting Tool, Continuing Education, Online Admissions Application, Physical Assets and OBIA implementations Executive Summary The project is tracking per schedule and under budget. Scope review and definition for each deployment continues due to rework of key solutions. Each Deployment Group (DG) is engaged and all colleges now have an Initiation or Implementation Work Plan: • DG 2 is in the Transition Phase. Colleges and SBCTC are engaged in User Acceptance Testing sprints. ctc. Link will be offline for the DG 2 upgrade Oct. 1114 and again for cutover activities Oct. 25 -28. • DG 3 is in the Construct Phase, focused on Conversion and Data Validation. DG 3 Testing/Training road shows are underway. • DG 4 is in the Initiation Phase, with all colleges past the halfway mark on deliverables. Gate 1 Initiation Phase Peer Review will be July 29 -30 at Highline College. • DG 5 colleges are in the Initiation Phase and have begun Initiation Deliverables public status reporting. PMO team visited colleges in June for Initiation road show. • DG 6 is in the Initiation Phase and will start public status reporting this fall. The Initiation Phase Road Show will be in Oct. 2019. Planning meetings have begun with technical colleges to capture differences between technical and community college business practices. The new Chart of Accounts was implemented in July for Spokane and Tacoma. Final contract negotiations continue for a new Continuing Education solution. An RFI is being developed for the Online Admissions Application (OAA), in parallel with additional improvements to the current OAA solution. The Budget Planning Tool work group is working on finalizing business and technical requirements. Many college PMs will participate in the Prosci 3 -day training in August in Centralia and Wenatchee to learn organizational change management principles. Scope Budget • 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 Budget required by OFM/OCIO has been submitted and approved Allotment for Gate 4 funding has been submitted Y G • Overall Status Summary per Deployment Group DG# PMOReported Comments Status College/ Agency Clark Mapping is in progress SBCTC and production security Spokane must be tested to complete UAT Tacoma G Cascadia G • Security Production DG 2 Y • College Configuration in LCC DG 3 G progress Olympic • Conversion cycles have Peninsula begun Pierce DG 4 G DG 5 G DG 6 G Self. Reported Status Y R G G G • College teams working Implementation begins Nov. 2019 on Initiation Phase activities • College teams working on Initiation Phase activities Implementation begins March 2020 • College teams working Implementation begins Nov 2020 on Initiation Phase activities 11

L Top Risks Reported – as of July 19, 2019 Risk Level H Risk

L Top Risks Reported – as of July 19, 2019 Risk Level H Risk Description C Critical H High M Submitted by (name, org/college), Deployment Group & Date Moderate Low Risk Owner (s) Chart of Accounts (Co. A): User adoption and successful deployment (scheduled for July 1, 2019) is critical for Deployment Group 2 (DG 2) timeline. Update: Phase 1 cutover activities completed. Phase 2 and subledger closing activities are in progress and were completed on July 10. Final configuration (Phase 3) completed the week of July 15. College SMEs and Emmett are continuing to work through and troubleshoot issues Clark: Student Financials – Clark submitted three risks. Update: Items related to Student Financials, Financial Aid, Susan Maxwell, Clark College PM General Ledger and coordination between Student Financials and Finance. These items have been discussed with Clark. DG 2 Impacted, Risk Date: 2/1/2019 Cycle 4 B is planned to mitigate these risks. A follow-up will be Risks #50, #51, #52 scheduled with Clark’s PM after Cycle 4 B is scheduled for July 12, 2019. Colleges will validate by 8/9. John Henry Whatley, Emmett Folk, Chandan Goel ctc. Link Team: The GL & SF Conversion logic/ requirements for the Go Live term has still not finalized. If not addressed soon, it creates a risk of not being made available for colleges validation and meeting the timeline for Cycle 4 B. Update: Finance team met with Student Financials team to discuss AR (Accounts Receivable) items and alignment in data conversion activities. Additional discussion are needed to further define the process. John Henry Whatley, Christyanna Dawson H H Mitigating Actions LEGEND: Emmett Folk, ctc. Link PM for FIN & HCM Team Emmett Folk DG 2 Impacted, Risk Date: 10/12/2018 *also Risk submitted by Matt Connelly, Spokane District PM on 10/23/2018 John Henry Whatley DG 2 Impacted, Risk Date: 7/8/2019 Risk #71 L Top Issues Reported – as of July 19, 2019 Issue Level H M Issue Description Status Update LEGEND: H High M Moderate Submitted by (name, org/college), Deployment Group & Date Low Issue Owner (s) Security Mapping activities to mitigate UAT timeline, have not addressed the new Security Design Production user access. Update: The ctc. Link team is highly concerned about the ctc. Link PMO submitted for ctc. Link CS, Production Security Mapping for DG 2 Colleges and entering HCM, FIN Team new Security into one of the UAT cycles. Although there are no other options due to the schedule, this will be a challenge DG 2 Impacted, Issue Date: 4/16/2019 for the DG Colleges and SBCTC as well as potential impact to the remaining UAT cycles. Tara Keen, Security Team Clark – Accessibility Items Clark has submitted issues around accessibility items they have identified. We are tracking these items and will provide this information to the vendors to review and test when they are onboard (estimated for August). Owners TBD Susan Maxwell, Clark College PM DG 2 Impacted, Issue Dates: 6/27/2019 Issues: #39 -48 2

ctc. Link Quality Assurance Scorecard / Moran Technology Consulting Report ctc. Link Quality Assurance

ctc. Link Quality Assurance Scorecard / Moran Technology Consulting Report ctc. Link Quality Assurance Scorecard - Moran Technology Consulting 2018 June, NOVEMBER 2019 STATUS G G Y DESCRIPTION / NOTES SBCTC/Governance Go-No Go Decision for FLC implementation of new Chart of Accounts was made by Steering Committee. The ctc. Link Executive Leadership Committee will have a change to voting members with the new WACTC-Tech appointed college presidents. Project Management Office (PMO) is fully staffed, working well together and continuing to address improvements in project management processes. PMO has hired a PM to manage Schedules (individual starts in July). Phase Scope QA remains concerned about the number of solutions to be re-implemented to replace/augment current PS functionality. Based on the May status of replacement solutions, it does not seem possible that these will be decided upon and readied for DG 2 scope inclusion. DG 2/DG 3/DG 4 schedule overlap and resource constraints directly impact all deployment groups. Schedule compression and key project resources are heavily allocated to multiple DG 2 workstreams and supporting DG 3 tasks. DG 2 schedule is dependent on Co. A implementation at CCS and TCC colleges. Priority must continue to be focused on DG 2 project and college readiness. QA recognizes that the high level of DG 2 related activities leading up to Go-live will be stressful to the ctc. Link project staff. QA is also concerned that the ctc. Link Project staff and ERP support team will be stressed for a number of months once DG 2 is live, with anticipation of a higher volume of new support tickets. Development of Training materials to support remaining Sprints was underway in June. Training team and consultants are working on preparing materials for Sprints 4/5/6. QA continues to be concerned that considerable development work still remains for the courses to support end-user training. Y Training Testing DG 2 UAT Sprints, were underway in June. Good sprint participation by the DG 2 colleges. UAT has identified configuration and process errors that have been resolved. Consultant contracted to fill Testing Manager role was delayed on-site and (expected to start in July). The DG 2 Testing workstream remains a major QA concern since it requires continued active DG 2 end-user participation. QA is also concerned about the execution of dual parallel testing for payroll, financial-aid, and tuition calculation. Configurations / Data Conversion Technical work for beginning Co. A implementation started in June once Go-live decision was made by Governance. This work required the ctc. Link Project team working closely with the ERP support team. Co. A implementation Steps 1 and 2 were completed as scheduled. Conversion and Production implementation of the Bio-Demo data for Clark College and SBCTC is scheduled for July. DG 2 Go-live production cutover planning sessions began in June. Organizational Change Management PMO/OCM is actively engaged with all colleges now involved with their DGs. QA is concerned that PMO remains focused on the DG 2 schedule/priority activities. The project is aware that effective communications and messaging is important to success of the project. QA supports the efforts the project is undertaking to prevent false messages from being sent. Project Staffing Project staffing is adequate at this time and continues to make staffing adjustments as appropriate. PMO is recruiting for open positions. PMO to begin using off-shore technical resources to perform and augment systems integration testing work. Technical Environment The IT division continues addressing processes and critical staffing. The ERP Change Management Board is being reimplemented to improve coordination and scheduling of changes. IT is reviewing staffing models at other People. Soft ERP community college systems for staff and budget sizing. The development/implementation of security roles for the colleges has now become a critical issue and is being addressed by the ctc. Link PMO. Service Level Agreement has been distributed to colleges. Y G G G Y PROJECT AREA Schedule Status Y Overall Status Y LEGEND Risk Description: 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. 3

WA State Office of the Chief Officer. Information (OCIO) Oversight WA State Office of.

WA State Office of the Chief Officer. Information (OCIO) Oversight WA State Office of. Information the Chief Officer (OCIO) Oversight WA State Office of the Chief Information Officer (OCIO) Oversight as of July 2019 OCIO Conditions to new ctc. Link Investment Plan Approval Status ctc. Link Technology Pool Status and Gate # 1 Planning & Remediation Approved 1/1/2018 G 2 DG 2 – Initiation & Structure Phase Approved 1/1/2018 G 3 DG 2 – Construct Phase DG 3 – Initiation & Structure Phase Approved 1/1/2019 G 4 DG 2 – Transition & Deploy Phase DG 3 – Construct Phase DG 4 – Initiation & Structure Phase Pending Approval 7/1/2019 G 5 DG 3 – Transition & Deploy Phase DG 4 – Construct Phase DG 5 – Initiation & Structure Phase Future 2/2020 G 6 DG 4 – Transition & Deploy Phase DG 5 – Construct Phase DG 6 – Initiation & Structure Phase Future 10/2020 Ongoing G -- G 2 QA (Moran) to report to ctc. Link executive sponsor and State CIO Complete G G 3 Follow pre-determined OFM funding gates and approvals Complete G 5 Continue reporting on Remediation items in Integrated Work Plan Y OCIO approval of the 4 remediation solutions: Budgeting tool, Continuing Education Application, Online Admissions Application 6 Complete In Progress Status Approved Project must remain in line with SBCTC and OCIO policies Monthly status reporting Y Pre-IT Pool Implementation, Stability & Remediation G 1 G 4 Overall Status G 7 OCIO must be notified prior to use of contingency funds N/A Planned as Activities in Project Work Plans G 7 G 8 Perform a post-implementation review (lessons learned) after each deployment and post on the OCIO dashboard within 30 days of go-live DG 5 – Transition & Deploy Phase DG 6 – Construct Phase Future 2/2021 G 8 DG 6 – Transition & Deploy Phase Future 10/2021 Complete G 9 Contingency Deployment N/A 2/2022 G 9 Process and timeline for filling the SBCTC CIO position by 1/31/2018 Note: New ctc. Link Investment Plan approved by OCIO, with above conditions, on Jan. 19, 2018. 4

Budget Status – as of June 30, 2019 G 5

Budget Status – as of June 30, 2019 G 5

Pillar Status – July 8 to 19, 2019 Campus Solutions Accomplished this period ü

Pillar Status – July 8 to 19, 2019 Campus Solutions Accomplished this period ü Clark Dual Processing SIT end to end (100% complete) ü Provide scheduling parameters to Legacy team for DG 2 Cycle 4 b ü Hand-Off DG 3 Cycle 3 College Optional Files to Legacy Team ü Continue reviewing requirements for Guided Pathways system configuration ü FAST Work Group meeting (SAP work) ü Review DG 2 Cycle 4 b crosswalks ü Clark Transfer Credit Rule Go Live Workshop Prep ü Review DG 3 assignment submissions for configuration ü DG 2 Sprint 3 CS UAT ü Continue DG 3 FIT ü Continue DG 2 SIT ü Continue UAT material planning/build Planned for next period q Hold Clark Transfer Credit Rule Go Live Workshop q Continue to review requirements for Guided Pathways system configuration q Validate DG 2 Cycle 4 b conversion q Support Security Redesign activities q Support UAT for DG 2 Colleges q FA Parallel Testing – Dual Processing q Prep for Parallel Testing – Tuition Calculation q Continue DG 3 FIT q Continue DG 2 SIT q Continue UAT material planning/build q Plan for EMPL ID conversion to PRD G Human Capital Management Y Status – as of 6/8/2018 Accomplished. Pillar this period ü Collected DG 3 Cycle 3 Data Files ü Continued DG 3 Cycle 3 Prep Activities ü Continued review of Security Redesign Role/Permission List Definitions ü Continued Payroll Parallel Testing Activities ü Continued UAT support activities ü Continued DG 2 UAT diagram/scenario updates ü Continued DG 2 UAT supporting content build ü Continued review of DG 2 Training content structure and materials ü Continued DG 2 and DG 3 configuration build-out in FNC environment Planned for next period q Begin DG 4 BPFG session planning q Continue DG 3 Cycle 3 Prep Activities q Continue review of Security Redesign Role/Permission List Definitions q Continue Payroll Parallel Testing Activities q Continue UAT support activities q Continue DG 2 UAT diagram/scenario updates q Continue DG 2 UAT supporting content build q Continue review of DG 2 Training content structure and materials q Continue DG 2 and DG 3 configuration build out in FNC environment *If status is yellow or red, describe why. DG 2 UAT and pre-UAT training supporting materials are being provided on a just in time basis. The concurrent DG 2 and DG 3 activities are causing the team to prioritize externally-/client-facing activities and deadlines/starts for certain internal tasks continue to get missed. Financial Services Y Accomplished this period ü Collected DG 3 Cycle 3 Data Files ü Continued DG 3 Cycle 3 Prep Activities ü Continued review of Security Redesign Role/Permission List Definitions ü Continued DG 2 UAT support activities ü Continued DG 2 SIT Test Execution ü Continued DG 2 UAT supporting content build ü Continued review of DG 2 Training content structure and materials ü Continued DG 2 and DG 3 configuration build-out in FNC environment Planned for next period q Begin DG 4 BPFG session planning q Continue DG 3 Cycle 3 Prep Activities ü Continue review of Security Redesign Role/Permission List Definitions q Continue DG 2 UAT support activities q Continue DG 2 SIT Test Execution q Continue DG 2 UAT supporting content build q Continue review of DG 2 Training content structure and materials q Continue DG 2 and DG 3 configuration build-out in FNC environment *If status is yellow or red, describe why. DG 2 UAT and pre-UAT training supporting materials are being provided on a just in time basis. The concurrent DG 2 and DG 3 activities are causing the team to prioritize externally-/client-facing activities and deadlines/starts for certain internal tasks continue to get missed. 6

Workstream Status – July 8 to 19, 2019 Communications G Accomplished this period ü

Workstream Status – July 8 to 19, 2019 Communications G Accomplished this period ü c. ELC committee transitional planning and communications ü Continued planning for Executive Sponsor Seminar on 7/30 ü Communications by Phase/Countdown meeting planning with DG 3 PMs and Comms staff ü DG 2 Go/No-Go decision package timeline options ü Accessibility update blog re vendor process, testing, prioritization ü Steering Committee meeting materials developed, distributed Planned for next period q Support July 30 Exec Sponsor Seminar q Hold Comms by Phase Planning meeting on July 31 q Accessibility blog post, phase 2 q Continue Comms Advisory Committee planning q Communications Office scope/activities q Templates work (including Critical Communications Template) Organizational Change Management G Accomplished this period ü Meet with DG 2 PM’s to discuss how change management activities are going with their teams ü Continued planning DG 4 Peer Review ü Started meeting with DG 3 colleges about testing, training, and life after go-live. ü Conducted onboarding with new college PMs ü Continued planning DG 6 Road Show around Initiation Deliverables in October Planned for next period • Continue to work with CPW Facilitators and Functional Teams to determine scope for upcoming sessions • Continue College Relations/OCM Check-ins with DG 3, DG 4, DG 5 and DG 6 • Continue development on schedule of events with PMO and all Deployment Groups Technical G CONVERSION Accomplished this period ü DG 2: Conversion Issues review/resolution. ü DG 2: Establish the timeline for Cycle 4 B. ü DG 2: Successfully migrated objects to Conversion Environment (CTS). ü DG 2: Successfully moved all tested configurations to date into the CTS. Planned for next period q DG 2: Conversion Issues resolution. – In Progress q DG 2: SF Parallel Test activities. q DG 3: Cycle 3 Conversion Activities. DEVELOPMENT Accomplished this period ü Support and work on Service Desk, FIT, SIT & UAT tickets for CS, HCM & FS pillars. ü Migrated the retrofit project (for HCM PUM 31) to HCDEV & HCTST environments. ü Remediation development for HCM for CEMLI R-266. ü Unit Test completed for OAA Application Fee waiver code Planned for next period q Unit Testing Nelnet Retrofit ENVIRONMENTS Accomplished this period ü Coordinated PUM Image Update in Project environments. ü Coordinated Load Testing Project work. ü DG 2 cycle 4 b environment refresh. ü Fluid Migration strategy. ü Prepare STAT trainings for Functional Team. Planned for next period q STAT trainings q DG 3 cycle 3 and DG 3 Cycle 4 B environment support. Testing Y Accomplished this period ü Continued system integration testing (SIT): Finance 100% complete, HCM over 80% complete, CS 60% complete ü Completed Sprint 4 UAT ü Provided metrics on SIT and UAT status ü Continued to build UAT materials for final sprints ü Supported Sprint Closure for 1 -3, UAT 4 execution ü Began Parallel Testing: Payroll nearing completion, Financial Aid Dual Processing began, Student Financials preparing to start next week Planned for next period q Prepare for UAT Sprint 5 and 6 execution q Continue to build UAT materials, System Integration Testing, UAT support, UAT/SIT metrics q Continuation of Load Testing q Reviewing PUM Image releases for regression testing in Sprint 6 *If status is yellow or red, describe why. Overlapping project tasks that utilize the same resources may impact testing. Training Y Accomplished this period ü Currently at 75% for Sprint 5 and 25% for sprint 6 ü Started working in all pillars on development of End User Training Courses ü At 25% for all End User Training Canvas Courses ü Worked with vendor on HCM UAT training deliverables ü Continued work to define training scope, work assignments, activity durations, and dependencies Planned for next period q Continue to work on Pre-UAT Training materials q Continue to work on End User Training courses *If status is yellow or red, describe why. § Large amount of materials needed with upcoming timelines 7

Deployment Group 2 Timeline (High Level Phases) G 8

Deployment Group 2 Timeline (High Level Phases) G 8

Deployment Group 2 Self-Reported Status – July 8 to 19, 2019 Clark College G

Deployment Group 2 Self-Reported Status – July 8 to 19, 2019 Clark College G R Accomplished this period ü Continue to work through post Co. A issues/cleanup ü Security Role meetings to complete mapping guide template for CCS to begin validating new security roles. Matt C working with SBCTC on best way to map Old to New. ü FY Close –DG 2 UATs – Wrapped up Sprint 4. Sprint 5 starts 7/29 ü Finance team delivered new Co. A Projects spreadsheets required to SBCTC Accomplished this period ü Began Sprint 4 of UAT ü Payroll Parallel testing underway ü Final review of Courses in production ü Assessing training schedule to plan for locations. Mondays have up to four sessions simultaneously. ü Dates and deadlines related to Go-Live sent to campus Planned for next period q Chart of Accounts Redesign: Work in progress on Co. A manual conversion work required post Co. A rollout q EOY/EOM: Complete tasks prior to YE July 24 close date. Finalize Closing of FY 16, 17, 18. q Security Issues: CCS to complete validating roles assigned to non-sensitive data vs sensitive data. SBCTC preparing to remove all old query roles. q Security Role Redesign: Pending new Security Role spreadsheets from SBCTC so we can start validation exercise. Planned for next period q Query 101 training July 25 q Host project team 7/29 -8/1 for transfer course equivalencies q Finalize Go Ready checklist q Finalize student communications and graphics Planned, but not completed • More progress on AARs and documentation – ongoing slowly SBCTC Agency Community Colleges of Spokane Y Accomplished this period ü WAPAY now in production! 7/17. Celebration held 7/18 ü Travel & Expense Open Houses completed 7/10 and 7/17. Approximately 80 attendees between three June and July sessions! ü Change Readiness Survey #3 sent to agency all-staff by Executive Sponsor John Boesenberg. 7/17 Planned for next period q HR Leave and Self-Service ctc. Link Open House Demo Only 7/29 q UAT Sprint 5 – “End-to-end” regression testing 7/29 -8/6 Planned, but not completed • Status is needed regarding completing a list of all supplemental systems. *If status is yellow or red, describe why. FIN and HR are on track. Payroll is making great progress in UAT Sprint 3. Open Houses are giving all-staff opportunities to see and “touch” the ctc. Link system for Travel & Expenses with plans underway for HR Self. Service. However, manageable issues remain in completing Payroll testing, including UAT Sprint 3. Issues remain regarding security and approval work flow engine (AWE). *If status is yellow or red, describe why. • FY Close activities for 16, 17, 18 & 19 at risk. • CCS Chart of Accounts – Continue to work through blocking issues in Finance. SBCTC addressing issues but CCS continues to be impacted by new blocking issues as of 7/23. Coming up to Year End 7/24 Close date. • Security Role Redesign – CCS still waiting for SBCTC to provide us any spreadsheets with the new security roles, so we can begin validating and assigning correct security roles. SBCTC was not able to provide us the Role Mapping Guidance spreadsheet as originally communicated. • Scope of work has grown substantially for both post-Co. A cutover and Security Role mapping/validation. Tacoma Community College G 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 and activities ü Participate in UAT, monitor and communicate UAT status ü Received Training info from SBCTC ü Started coordinating Training Planned for next period q Local SMEs attend ctc. Link Security redesign group, ctc. Link PM groups, ctc. Link governance groups, various ctc. Link status meetings q Chart of Accounts meetings & work activities q Participate in UAT q Work with SMEs, Pillar Leads, TCC Leadership to get better participation in the project q Plan and execute OCM for DG 2 project q Monitor UAT status 9

Deployment Group 3 Timeline (High Level Phases) G 10

Deployment Group 3 Timeline (High Level Phases) G 10

Deployment Group 3 Self-Reported Status – July 8 to 19, 2019 Cascadia College G

Deployment Group 3 Self-Reported Status – July 8 to 19, 2019 Cascadia College G Accomplished this period ü Completed all data validation requirements for cycle #2 ü CS pillar completed final optional assignments (due 6/28/19) ü Finance completed all cycle #3 homework assignments due 7/17/19 ü Payroll attended VC 12 b CPW, July 17 -19 ü CS and FIN completed data cross-walk activities Planned for next period q Internal Training Management planning q Internal Testing Management planning q Preparing for Reporting & Query Management Plan Peninsula College Accomplished this period ü HCM Completed FWL assignments ü SME’s continue to meet with project to fix errors ü Attended Time & Labor CPW Planned for next period q Preparing next round of Validation, bringing on more SME’s G Pierce College District G Accomplished this period ü SMEs completed/submitted Cycle 3 conversion files. ü College Leadership, Implementation Team and SMEs participated in six-month follow-up session with SBCTC project team. ü SMEs participated in follow-up Web. Ex sessions regarding Cycle 3 conversion. ü HCM SMEs participated in Time & Labor Administrative Tasks CPW. Planned for next period q Schedule/plan follow-up meeting with College Leadership, Implementation Team and SMEs – planning next 6 months. q Identify Training Lead q Participate in upcoming Common Process Workshops Planned, but not completed • Review applicants for project positions. • Review and update Communications Plan • Review and update internal Training Plan with college Training Team. • Identify/establish training space. Lower Columbia College G Accomplished this period ü Completed all data validation requirements for cycle #2. ü SME’s completed/submitted Cycle 3 conversion files. ü College leadership, Alignment Team and SME’s participated in the follow up session with SBCTC project team at LCC. ü CS and FIN completed data cross-walk activities. ü Onboarding activities completed for new project manager. Planned for next period q Reporting lead and SME’s will attend query development workshop at Clark College. q Continue on campus messaging and communication about ctc. Link. q Continue to develop forecasting tools to track staff workload and project hours. q Identify UAT/Training Space Olympic College G Accomplished this period ü Continued work on ATD/ctc. Link Teams for Residency, Choosing Academic Plan, Changing Academic Plan ü Completed cycle 2 validation lessons learned ü Re-started Change Impact Analysis planning Planned for next period q Restart Change Impact Analysis Workshops Planned, but not completed • Additional CIA Workshops 11

Deployment Group 4 Dashboard Reports – July 8 to 19, 2019 DG 4 Initiation

Deployment Group 4 Dashboard Reports – July 8 to 19, 2019 DG 4 Initiation Phase Completion Summary As of July 19, 2019 College/District Centralia College 65% Edmonds Community College 60% Highline College 63% Seattle Colleges (3) 57% Wenatchee Valley College 68% 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 target percentages will be added in August 2019. DG 4 Pre-Implementation and General Timeline G 12

Deployment Group 5 Dashboard Reports – July 8 to 19, 2019 DG 5 Initiation

Deployment Group 5 Dashboard Reports – July 8 to 19, 2019 DG 5 Initiation Phase Completion Summary As of July 19, 2019 Target Percentage for July 2019 * Bellevue College 10% 35% Bellingham Technical College 24% 35% Big Bend Community College 22% 35% Everett Community College 24% 35% Grays Harbor College 30% 35% Green River College 31% 35% Skagit Valley College 18% 35% Whatcom Community College 35% College/District 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 13

ctc. Link Remediation Status Reports – July 8 to 19, 2019 Solution Status Due

ctc. Link Remediation Status Reports – July 8 to 19, 2019 Solution Status Due Date Chart of Accounts (revised) Due/Finish Status Campus Solutions 10 of 45 remain open DG 3 Tacoma CC Chart of Accounts Adoption Kickoff Dec. 12, 2018 Complete Financial Management 5 of 39 remain open DG 2 6 of 25 remain open DG 2 CCs of Spokane Chart of Accounts Adoption Kickoff Feb. 1, 2019 Complete Human Capital Management Faculty Workload Complete March 2019 Foundational Chartfield Configuration March 22, 2019 Complete DRS Redistribution Complete May 2019 College Configuration Review and Updates May 3, 2019 Complete Absence Management Complete April 2019 Security Audit Controls Security Redesign / Mapping FLC / DG 2 Functional and System Integration Testing May 10, 2019 Complete Student Billing/Third-Party Billing Complete May 2019 Work Group Finalize Requirements User Acceptance Testing Budget Planning Jan 2020 May 10 - June 3, 2019 Complete May 28 – June 14, 2019 Online Admissions App RFI Being Developed DG 2 College Readiness Gate / Go-No Go Discussions Continuing Education Contract Finalization DG 3 Readiness Gate / Go-No Go Decision Community Colleges of Spokane R Progress made on overall remediation conditions over the past five months, but remains Red with FY 16, 17, 18 Close and delay of Security Role Redesign rollout. Delay of new Security Roles mapping availability and the overlap of projects (post Co. A manual work and blocking issues, EOY tasks, DG 2 UAT Training/Testing, FY Closing of 16, 17, & 18) are all impacting college staff and normal operations now through October 2019. June 12 -14, 2019 Complete June 18, 2019 Complete Tacoma Community College G Remediation Items progress this period q See SBCTC status update for Remediation items, tickets, and worklist. Accomplished this period q Participate in Budget Tool planning. q Monitored remediation items progress and communicate to local stakeholders Security Role Redesign: Scope for validating security role mapping validation exercise has now grown substantially as SBCTC was not able to provide us the mapping helper guides as initially communicated. As of 7/23, we have not received any Security Role spreadsheets to even began validation. Chart of Accounts: Co. A conversion also resulted in substantial manual work; some planned and some unplanned work. SBCTC providing money for resources to assist, but that impacts existing resource time as well. 14

Other ctc. Link Project Activities – Status as of July 19, 2019 RFP Publish

Other ctc. Link Project Activities – Status as of July 19, 2019 RFP Publish Solution Status Solution Decision Accessibility • • • Develop and published RFP Work Group engaged to evaluate RFP Responses Final Decision on Vendors to be awarded Vendor contracts awarded SOW for Accessibility Testing underway 5/10/2019 • Testing Prior to DG 2 (October 2019) Continuing Education • • • RFP was developed and approved by Governance RFP proposals were due November 15, 2018 3 Vendors responded and subgroup is evaluating solution Governance approved procurement and decision of Vendor contract being finalized for scope and cost 10/15/2018 • Contract Draft Complete • Overall Pricing in Negotiations Online Admissions Application • Sub-Committee finalized OAA requirements • Project Team performed Fit/Gap of ctc. Link functionality • OAA workgroup evaluated select solutions currently in use at other People. Soft universities and colleges • OAA workgroup developing a short list of best/possible solutions to identify those solutions on 2/12/2019 • RFI to understand possible solutions and costs before final decision on RFP or custom solution • Continue to enhance current OAA based on requirements for RFI TBD • RFI requested • Current ctc. Link OAA requirements being prioritized prior to continue improvements Budget Planning Tool • Committee formed to review, finalize, approve Budgeting requirements • Budget Planning Tool Work Group meetings underway to finalize requirements and vet Oracle PBCS Solution • If needed, develop RFP TBD • Work Group Kick Off • Members reviewing Original RFP Budget Requirements Physical Inventory (Asset Tracking) • Vendor Solutions being evaluated • New PS Functionality will provide integration for asset tracking scanners directly with ctc. Link and is ready for DG 2 5/21/2018 • DG 2 15