Project Overall Status June 24 to July 5

  • Slides: 15
Download presentation
Project Overall Status – June 24 to July 5, 2019 Overall Y Schedule Y

Project Overall Status – June 24 to July 5, 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 and recently completed Business Process Fit/Gap sessions. DG 3 Testing/Training road shows are underway. • DG 4 is in the Initiation Phase, with most colleges just 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 implementation is underway, following a “go” decision (with conditions) by the Steering Committee. 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 reconvening to finalize 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 waiting on approval before new allotment for Gate 4 can be requested 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 R 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 1

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

L Top Risks Reported – as of July 5, 2019 Risk Level H C Risk Description Mitigating Actions M H High M Submitted by (name, org/college), Deployment Group & Date Low Risk Owner (s) SBCTC: Risk of resource diversion due to Co. A adoption. Combination editing rules will be revised in tandem with additional chartfield use. Impacts First. Link Colleges’ (FLCs) ability to post many transactions prior to effective date. Cutover is planned to complete on July 22, 2019. If this happens, requires manual or automated workarounds to correct issues as they occur; will require SBCTC staff resources to support. Update: SBCTC, ctc. Link FIN leads, ERP FIN lead will Evelyn Williams, SBCTC PM continue to meet to clarify roles for year-end close and their role in old chart of accounts. Next round when SBCTC is on DG 2 Impacted, Risk Date: 5/3/2019 the new chart of accounts their resources will be impacted. Discussions also occurred for how ERP will support the new chart of account issues. Emmett Folk & Christyanna Dawson 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. John Henry Whatley, Emmett Folk, Chandan Goel Issue Description Status Update Emmett Folk, ctc. Link PM for FIN & HCM Team Moderate Update: Phase 1 cutover activities completed. Phase 2 and sub-ledger closing activities are in progress and are scheduled to be completed on July 10. Final configuration (Phase 3) is now scheduled for the week of July 15. Top Issues Reported – as of July 5, 2019 H C Critical Chart of Accounts (Co. A): User adoption and successful deployment (scheduled for July 1, 2019) is critical for Deployment Group 2 (DG 2) timeline. H Issue Level LEGEND: Emmett Folk DG 2 Impacted, Risk Date: 10/12/2018 *also Risk submitted by Matt Connelly, Spokane District PM on 10/23/2018 LEGEND: L 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: #36, #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 1/1/2020 G 6 DG 4 – Transition & Deploy Phase DG 5 – Construct Phase DG 6 – Initiation & Structure Phase Future 7/1/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 1/1/2021 G 8 DG 6 – Transition & Deploy Phase Future 7/1/2021 Complete G 9 Contingency Deployment N/A 1/1/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 – June 24 to July 5, 2019 Campus Solutions Accomplished this period

Pillar Status – June 24 to July 5, 2019 Campus Solutions Accomplished this period ü Receive DG 3 College Optional Files for Cycle 3 ü Support DG 3 Cycle 2 data validation ü Began reviewing requirements for Guided Pathways system configuration ü Clark Transfer Credit Rule Go-Live Workshop prep ü Review DG 3 assignment submissions for configuration ü Clark Dual Processing SIT end-to-end (45% complete) ü DG 2 Sprint 3 CS UAT ü Continue DG 3 FIT ü Continue DG 2 SIT ü Continue UAT material planning/build Planned for next period q Hand-Off DG 3 Cycle 3 College Optional Files to Legacy Team q Prep for DG 2 4 B conversion q Continue to review requirements for Guided Pathways system configuration q Support Security Redesign activities q Support UAT for DG 2 Colleges q Prep for 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 FAST Work Group meeting (SAP work) Planned, but not completed • Clark Dual Processing SIT end-to-end (further progress) G Human Capital Management Pillar Status – as of 6/8/2018 Accomplished this period ü Began DG 3 Cycle 3 prep activities ü Continued review of Security Redesign Role/Permission List Definition ü 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 configuration build out in FNC environment ü Continued DG 3 configuration build out in FNC environment Planned for next period q Collect DG 3 Cycle 3 Data Files q Continue DG 3 Cycle 3 Prep Activities q Continue review of Security Redesign Role/Permission List Definition 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 configuration build out in FNC environment q Continue 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 Y Financial Services Y Accomplished this period ü Began DG 3 Cycle 3 Prep Activities ü Continued review of Security Redesign Role/Permission List Definition ü 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 configuration build out in FNC environment ü Continued DG 3 configuration build out in FNC environment Planned for next period q Collect DG 3 Cycle 3 Data Files q Continue DG 3 Cycle 3 Prep Activities q Continue review of Security Redesign Role/Permission List Definition 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 configuration build out in FNC environment q Continue 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 6

Workstream Status – June 24 to July 5, 2019 Communications Accomplished this period ü

Workstream Status – June 24 to July 5, 2019 Communications Accomplished this period ü Chart of Accounts Week 1 go-live communications to governance groups and PMs ü Continued planning for Executive Sponsor special meeting in July ü ctc. Link Project Liaisons for Commissions/Councils meetings - develop spreadsheet, website and process; distribute to PMs, Project Team and SBCTC reps/liaisons ü Communications Advisory Committee planning Planned for next period q Continue Comms Advisory Committee planning q Communications Office scope/activities q Templates work (including Critical Communications Template) q Accessibility update re vendor process, testing, prioritization Organizational Change Management Technical G G CONVERSION Accomplished this period ü DG 2: Conversion Issues review/ resolution ü DG 2: Establish the timeline for Cycle 4 B ü Re-executed SF conversion with Go-Live logic to assist Parallel Test activities ü DG 3: Cycle 2 Conversion Issues review/ resolution Planned for next period q DG 2: Conversion Issues resolution. – In Progress q DG 2: SF Parallel Test activities DEVELOPMENT G Accomplished this period ü Completed DG 5 road show around Initiation Deliverables ü Meet with DG 2 PM’s to discuss how change management activities are going with their teams ü Continued planning DG 4 Peer Review ü Continued planning DG 3 Road Show around upcoming Testing/Training ü Assisted in onboarding new college PMs ü Started planning next meeting with all technical colleges to discuss the differences between how they do business and other colleges. ü Continued planning DG 6 Road Show around Initiation road show Planned for next period q Continue to work with CPW Facilitators and Functional Teams to determine scope for upcoming sessions Accomplished this period ü Support and work on Service Desk, SIT & UAT tickets for CS, HCM & FS pillars ü Migrated the retrofit projects (for FSCM PUM 32) to FSPLA, FSPLB, FSPLC, FSUAT, FSTRA & FSTRD environments ü Remediation development for HCM for CEMLI R-266 Planned for next period q Continue to support on Service Desk, SIT & UAT tickets for CS, HCM & FS pillars q Nelnet Retrofit ENVIRONMENTS Accomplished this period ü Coordinated PUM Image Update in Project environments ü Coordinated Load Testing Project work ü DG 3 cycle 3 environment refresh Planned for next period q STAT Project gather questions and feedback from team q DG 3 cycle 3 environment support Testing Y Accomplished this period ü Continued system integration testing (SIT) ü Began Sprint 4 UAT ü Provided metrics on SIT status ü Continued to build UAT materials for final sprints ü Supported Sprint Closure for 1 & 2, and execution for 3 UAT ü Provided metrics on UAT status ü Ensured Proper Security Staging for Load Testing ü Executed Initial Rounds of Load Testing Planned for next period q Prepare for UAT sprint 5 execution q Continue to build UAT materials q Continue system integration testing q Continue supporting UAT q Provide metrics for UAT and SIT *If status is yellow or red, describe why. § Overlapping project tasks that utilize the same resources may impact testing Training Y Accomplished this period ü Finalized schedule and materials for Sprint 3 ü Made modifications on training delivery via lessons learned ü Currently at 25% with content for Sprint 4 ü Completed sprint 4 through 6 schedules ü Continue to work with vendor on Finance, HCM, and CS training deliverables ü Restructured Training Team and associated job descriptions and tasks Planned for next period q Continue to work on Pre-UAT training materials *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 – June 24 to July 5, 2019 Clark College

Deployment Group 2 Self-Reported Status – June 24 to July 5, 2019 Clark College G Accomplished this period ü Began Sprint 4 of UAT. ü Payroll Parallel testing underway. ü Fall class schedule 90% completed in production. Waiting for access to add instructors and fees. ü Collated all 6 sprints into one document with all UAT users. Planned for next period q Query training for query developers by 6/11 QDLC online – then Paula Mc. Donald will come to Clark for PS Query 101 training in July. q Refine Training plan and schedule Planned, but not completed • More progress on AARs and documentation – ongoing slowly SBCTC Agency R Accomplished this period ü 17 attendees first ctc. Link Travel & Expense Open House held 6/27 ü UAT Sprint 2 100% complete! ü New communications are going out from Executive Sponsor John Boesenberg. ü UAT Sprint 1 99% complete! Will be completed before 7/15 ü WAPAY is in User Acceptance Testing (UAT) ü Security mapping validation has begun for FIN 7/3 ü Risk Management Team updates: § Risk #65 Security Mapping moved to Issue #37, 6/27 § Risk #67 Approval Workflow Engine (AWE) moved to Issue #38, 6/27 (these moves are corrections and being worked by the project team) § Risk #39 HCM Resources closed in PWA tool. Resources remain an internal SBCTC “Watch Item. ” Planned for next period q Documentation of an internal Payroll resource Issue is needed. We have one resource, Sharon Kinberg, who is doing her daily work and also responsible for Payroll Parallel testing and UAT. We have a new person coming on board as the new Payroll Coordinator 7/15. However, there will be a learning curve. Planned, but not completed • Status is needed regarding completing a list of all supplemental systems. *If status is yellow or red, describe why. § From a pillar perspective, FIN is on track. However, we are behind with one resource for Payroll UAT, Payroll Parallel Testing, HCM Security Mapping validation, upcoming Data Validation Community Colleges of Spokane R Accomplished this period ü Working through post Co. A issues/cleanup. ü Security Role meetings to complete a mapping guide template for CCS to began 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 3. Sprint 4 started 7/2. Planned for next period q Chart of Accounts Redesign: Complete all Co. A manual conversion worked required post Co. A rollout. Complete pushing through invoices with old Co. A values by 7/8. q End of Year/End of Month: Complete EOY/EOM tasks prior to sub module closing for June. 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: Hope to receive new Security Roles from SBCTC so we can start validation exercise. *If status is yellow or red, describe why. § FY 16, 17, & 18. CCS still correcting journal entries; unable to reconcile cash account with $18 million variance. § CCS Chart of Accounts – Continue to work through blocking issues in Finance. SBCTC addressing issues but continue to be impacted by new blocking issues as of 7/8. We are also impacted by the 7/8 closing of sub modules, and the 7/8 deactivating of old chart of accounts. § 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 Co. A and the Security Role mapping/validation. Changing scope to Red. 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 ü Started OCM planning and execution for DG 2 project ü Monitor and communicate UAT status 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 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 – June 24 to July 5, 2019 Pierce College

Deployment Group 3 Self-Reported Status – June 24 to July 5, 2019 Pierce College District G Accomplished this period ü SMEs completed Cycle 2 data validation ü SMEs completed/submitted optional homework assignments ü Completed planning for SBCTC July 10 th follow-up session ü Completed planning for OCM activity – SMEs appreciation lunch G Accomplished this period ü All pillars completed majority of their data validation requirements for cycle #2 ü CS pillar completed all but one “optional” Canvas homework assignments due 6/28/19 ü Finance completed all three “optional” homework assignments initially due 5/9/19 Peninsula College G Accomplished this period ü Completed validation activities ü SMEs are responding to error correction requests Planned for next period q HCM SMEs will work on FWL assignments that are available. Planned for next period q FIN complete cycle #3 homework assignments due July 17 q CS complete “optional” Test Score Cycle #3 homework assignment q Conduct data crosswalk cycle #3 q Attend VC 12 b CPW, July 17 -19 Planned for next period 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 Cascadia College G Accomplished this period ü Work in Cycle 2 conversion validation ü Review legacy reports for future remapping to ctc. Link ü Work through transition activities for new PM and Alignment Team ü Start campus messaging and communication around fall training requirements for faculty and staff ü Resolved ctc. Link/Navigate implementation issues Planned for next period q Continue on campus messaging and communication about ctc. Link q Continue to develop forecasting tools to track staff workload and project hours Planned, but not completed • CS pillar was unable to perform data validation in four areas Degree Honors, Transcript Text, Enrollment and Grades, Transfer Credit and Transcript Classes) due to heavy workload activities for end of spring quarter, graduation, start of summer quarter. • FA pillar was not able to validate data due to known conversion error issues (same as Cycle #1) • CS Test Score Cycle #3 optional homework Olympic College G Accomplished this period ü Recognized BPFG participants with a celebration lunch ü Continued work on ATD/ctc. Link Teams for Residency, Choosing Academic Plan, Changing Academic Plan ü Completed Data Cycle 2 Validation Planned for next period q Lessons learned on Cycle 2 Validation q Restart Change Impact Analysis Workshops Planned, but not completed • Additional CIA Workshops 11

Deployment Group 4 Dashboard Reports – June 24 to July 5, 2019 DG 4

Deployment Group 4 Dashboard Reports – June 24 to July 5, 2019 DG 4 Initiation Phase Completion Summary As of July 5, 2019 College/District Centralia College 63% Edmonds Community College 60% Highline College 59% Seattle Colleges (3) 57% Wenatchee Valley College 66% 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 – June 24 to July 5, 2019 DG 5

Deployment Group 5 Dashboard Reports – June 24 to July 5, 2019 DG 5 Initiation Phase Completion Summary As of July 5, 2019 Target Percentage for July 2019 Bellevue College 10% 25% Bellingham Technical College 18% 25% Big Bend Community College 21% 25% Everett Community College 21% 25% Grays Harbor College 29% 25% Green River College 30% 25% Skagit Valley College 15% 25% Whatcom Community College 31% 25% 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 – June 24 to July 5, 2019 Solution Status

ctc. Link Remediation Status Reports – June 24 to July 5, 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 Remediation Items progress this period ü Continue progress made on post absence management UAT tickets. ü Query Security Audit Controls – In progress. SBCTC preparing for removing old queries. Bank Statement security fix to be addressed with DG 2 release (Oct 2019). ü 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. June 12 -14, 2019 Complete June 18, 2019 Complete Tacoma Community College G Remediation Items progress this period ü See SBCTC status update for Remediation items, tickets, and worklist. ü Participate in budgeting tool workgroup. Planned for next period • Receive remediation detail with responses based on December 2018 feedback • Participate in budgeting tool workgroup *If status is yellow or red, describe why. • Progress made over the past 5 months, but remains Red with FY 16, 17, 18 Close and delay of Security Role Redesign rollout. • FY 16, 17, & 18. CCS still correcting journal entries; unable to reconcile cash account with $18 million variance. • Absence management - SBCTC making progress on post UAT issues. • Security Role Redesign – Delayed rollout continues. CCS still waiting for SBCTC to provide spreadsheets with new security roles, so we can begin validating, assigning correct security roles. SBCTC was not able to provide us the Role Mapping Guidance spreadsheet as originally communicated. 14

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

Other ctc. Link Project Activities – Status as of July 5, 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 Begin awarded Vendors Contract Begin SOW for Accessibility Testing 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/201 8 • 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 • Committee formed to review, finalize, approve Budgeting requirements • Budget Work Group 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 • Evaluate new PS Functionality that will provide integration for asset tracking scanners directly with ctc. Link 5/21/2018 DG 3 (February 2020) 15