Project Overall Status May 27 to June 7

  • Slides: 15
Download presentation
Project Overall Status – May 27 to June 7, 2019 Overall Y Schedule Y

Project Overall Status – May 27 to June 7, 2019 Overall Y Schedule Y • • • Program is on track, per timeline, scope and budget Security Mapping activities impacting 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. Review and definition of scope for each deployment continues due to the rework of key solutions. Each Deployment Group (DG) is now engaged and all colleges now have an Initiation or Implementation Work Plan in place: • • • DG 2 is in the Construct Phase. Colleges and SBCTC are engaged in User Acceptance Testing sprints – training in the morning, testing in the afternoon. ctc. Link governance approved the DG 2 Go-Live schedule. ctc. Link will be offline for the upgrade Oct. 11 -14 and again for cutover activities Oct. 25 -28. DG 3 is in the Structure Phase and recently completed Business Process Fit/Gap sessions. Preparing for DG 3 Testing/Training road show in July. 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 in late July. DG 5 colleges have begun Initiation Phase and are learning the public status reporting process. PMO team visiting colleges for Initiation road show. DG 6 has begun the initiation phase and will start the public reporting process this fall. Planning meetings have begun with all technical colleges to better understand the differences between how they and other colleges do business. The new Chart of Accounts is scheduled to be implemented in July for Spokane and Tacoma, following a go/no-go governance decision process in June. Final contract negotiations continue 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. 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, Work in progress before new allotment for Gate 4 can be requested Y G *Slide 3 revised 6/18/2019 Overall Status Summary per Deployment Group DG# PMOReported Comments Status College/ Agency Clark DG 2 Y SBCTC Mapping is still pending Spokane • Security Production G G DG 5 G DG 6 G Y R G Cascadia G LCC Complete Olympic • Conversion cycles have Peninsula begun G Pierce DG 4 Y Tacoma • BPFG Workshops DG 3 Self. Reported Status 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 June 7, 2019 Risk Level Risk Description

L Top Risks Reported – as of June 7, 2019 Risk Level Risk Description Mitigating Actions LEGEND: C Critical H High M Moderate Submitted by (name, org/college), Deployment Group & Date Low Risk Owner (s) Emmett Folk H Chart of Accounts (Co. A): User adoption and Update: Information will be packaged for Steering Emmett Folk, ctc. Link PM for FIN & HCM successful deployment (scheduled for July 1, 2019) is Committee Meeting on June 18, 2019 regarding TCC & Team critical for Deployment Group 2 (DG 2) timeline. CCS readiness for Co. A. If needed, this decision will be taken to c. ELC on June 19/20. DG 2 Impacted, Risk Date: 10/12/2018 *also Risk submitted by Matt Connelly, Spokane District PM on 10/23/18 Emmett Folk & Christyanna Dawson C SBCTC: Risk of resource diversion due to Co. A Update: SBCTC, ctc. Link FIN leads, ERP FIN lead met Evelyn Williams, SBCTC PM adoption. Combination editing rules will be revised in on 6/7/2019 to clarify roles for year end close and tandem with additional chartfield use. Impacts impacts to their areas. Further discussions are needed. DG 2 Impacted, Risk Date: 5/3/2019 First. Link Colleges’ (FLCs) ability to post many transactions prior to effective date. Cutover is planned to complete on 7/22/2019. If this happens, requires manual or automated workarounds to correct issues as they occur; will require SBCTC staff resources to support. Clark: Student Financials – Clark submitted three risks. John Henry Whatley, Emmett Folk, Chandan Goel H Update: Items related to Student Financials, Financial Susan Maxwell, Clark College PM Aid, General Ledger and coordination between Student Financials and Finance. These items have been DG 2 Impacted, Risk Date: 2/1/2019 discussed with Clark. Cycle 4 B is planned to mitigate Risks #50, #51, #52 these risks. A follow-up will be scheduled with Clark’s PM after Cycle 4 B. Top Issues Reported – as of June, 7 2019 Issue Level H L Issue Description Security Mapping activities to mitigate UAT timeline, have not addressed the new Security Design Production user access. CS GDR (Global Design Review) Items – Six items listed in status update. Items were approved by Working Group and Steering Committee. These items need additional work. LEGEND: L H High M Moderate Low Submitted by (name, org/college), Deployment Group & Date Issue Owner (s) Update: The ctc. Link team is highly concerned about the Production Security Mapping for DG 2 Colleges and entering new Security into one of the UAT cycles. Although there are no other options due to the schedule, this will be a challenge for the DG Colleges and SB as well as potential impact to the remaining UAT cycles. ctc. Link PMO submitted for ctc. Link CS, HCM, FIN Team Tara Keen, Security Team Update: Tracking GDR items as listed (statewide email accounts, shared HCM/CS ethnicity codes, academic careers, academic program structure, student self-service & student self-service (instructor contact display). Items are in progress. John Henry Whatley Status Update DG 2 Impacted, Issue Date: 4/16/2019 DG 2 Impacted, Issue Dates: 5/15/2019 CS Team & Further Analysis/Decisions with Commissions & Councils 2

ctc. Link Quality Assurance Scorecard / Moran Technology Consulting Report May , 2019 ctc.

ctc. Link Quality Assurance Scorecard / Moran Technology Consulting Report May , 2019 ctc. Link Quality Assurance Scorecard - Moran Technology Consulting NOVEMBER 2018 STATUS G G Y Y Y DESCRIPTION / NOTES SBCTC/Governance Go-No Go Decision for FLC implementation of new Chart of Accounts set for June 18, 2019. Project Management Office (PMO) is fully staffed, working well together and continuing to address improvements in project management processes. PMO has interviewed candidates to replace Open position for a qualified PM to manage Schedules. 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. Schedule Status Training materials to support Sprints 1 and 2 were completed in time for use. Sprint 3 materials were being completed. Considerable work still remains to develop the 60 courses to support end-user training. For DG 2 success, training focus still requires active end-user participation, effectiveness assessments and college follow-up. Testing The DG 2 User Acceptance Testing (UAT) Sprints, supported with Training materials was underway in May. Sprint 1 completed and Sprint 2 was starting in end of May. The DG 2 Testing workstream is now a major QA concern since it requires active FLC college end-user participation. Configurations / Data Conversion ctc. Link project technical staff are planning at least one additional conversion cycle to support Clark College during data review of Student Financials. Parallel testing conversions for Payroll were underway in May. DG 2 production cutover planning sessions to begin at the end of May. Month-end and Year-end Co. A data conversions were being run in May to determine differences in Gross Calculations. QA views this as a Critical Go-No Go supporting activity for FLC colleges implementation of the new Co. A. Organizational Change Management 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. PM Summit was held in early May with all deployment groups represented. Project Staffing Project staffing is adequate at this time and continues to make staffing adjustments as appropriate. PMO is recruiting for open positions. QA and the PMO remains concerned that the overlap of DG 2/DG 3/DG 4 may require additional project and contractor resources. Technical Environment The IT division continues addressing processes and critical staffing. Draft of Service Level Agreement has been distributed to colleges. IT is reviewing staffing models at other People. Soft ERP community college systems for staff and budget sizing. The development of security roles for the colleges has been taking longer than expected. The security setup has impacted the start of the UAT Sprints. Security changes are not considered a show stopper since colleges can implement changes after Go -live with People. Soft ERP. G G Y LEGEND Risk Description: Y PROJECT AREA Y G Overall Status 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 June 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 In Progress 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 May 31, 2019 G 5

Budget Status – as of May 31, 2019 G 5

Pillar Status – May 27 to June 7, 2019 Campus Solutions G Accomplished this

Pillar Status – May 27 to June 7, 2019 Campus Solutions G Accomplished this period ü Published DG 3 Cycle 2 data validation materials in Canvas ü FA Authorization/Disbursement/Reconciliation CPW ü DG 2 Sprint 2 CS UAT ü Presented 9. 2 Fluid part 2 presentation to Working Group ü Continue DG 3 FIT ü Continue DG 2 SIT ü Continue UAT material planning/build ü Review DG 3 assignment submissions for configuration ü DG 3 and Clark High. Point Mobile are configured in Mobile 1 environment Planned for next period q Hold DG 3 Cycle 2 data validation workshops q Support DG 3 Cycle 2 data validation q Prep for a possible 4 B conversion 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 Continue SAP CPW modification work q Dual Processing testing (end to end with all 10 interfaces) 6/12 -6/13 Planned, but not completed • Dual Processing testing (end to end with all 10 interfaces) Human Capital Management Y Pillar Status – as of 6/8/2018 Accomplished this period ü Continued Payroll Parallel Testing Activities ü Continued DG 3 Cycle 3 Validation Material Development ü 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 Continue Payroll Parallel Testing Activities q Continue DG 3 Cycle 3 Validation Material Development 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. 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 ü Continued DG 3 Cycle 3 Validation Material Development ü 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 Continue DG 3 Cycle 3 Validation Material Development 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; behind in DG 2 SIT execution. 6

Workstream Status – May 27 to June 7, 2019 Communications Accomplished this period ü

Workstream Status – May 27 to June 7, 2019 Communications Accomplished this period ü Begin Comms Advisory Committee planning ü Blog post about ctc. Link presentation at Trustees conference ü Steering Committee and c. ELC agenda and presentation development, meeting packets prep, meeting support ü c. ELC special meeting coordination (for possible Chart of Accounts decision) Planned for next period q Continue Comms Advisory Committee planning q ctc. Link Commissions/Councils spreadsheet, process CONVERSION Accomplished this period ü DG 2: Conversion Issues review/ resolution ü DG 3: Completed Cycle 2 conversion execution ü Technical Team validated conversion results, reported errors and applied necessary security in preparation for college validation activities Planned for next period q DG 2: Conversion Issues resolution in progress, Cycle 4 B Conversion Activities q DG 3: Cycle 3 Conversion Activities DEVELOPMENT ü Support and work on Service Desk, SIT & UAT tickets for CS, HCM & FS pillars ü Migrated the retrofit projects for CS People. Soft G Accomplished this period ü Started DG 5 road show around Initiation Deliverables ü Continued planning DG 4 Peer Review ü Continued planning DG 3 Road Show around upcoming Testing/Training ü Assisted in onboarding new college PMs ü Started planning meetings with all technical colleges to learn the differences between how they do business and other colleges. Planned for next period q Continue to work with CPW Facilitators and Functional Teams to determine scope for upcoming sessions q Continue College Relations/OCM Check-ins with DG 3, DG 4 and DG 5 G Accomplished this period Planned, but not completed • Communications Office scope/activities • ctc. Link at Commissions/Councils spreadsheet and process Organizational Change Management Technical G Update Manager (PUM) 13, HCM PUM 29 & FSCM PUM 31 to FNC & GLD environments ü Testing support on HCM for CEMLI SE-235, SE -234 & I-02 Planned for next period q Continue to support on Service Desk, SIT & UAT tickets for CS, HCM & FS pillars ENVIRONMENTS Accomplished this period ü Coordinated PUM Image Update in Project environments ü Coordinated Load Testing Project work ü DG 3 Cycle 2 environnent refresh ü Validate STAT Workflow for Project environments Planned for next period q STAT Project – in progress q Planning for next PUM image updates q DG 3 Cycle 2 environnent support. Testing Y Accomplished this period ü Continued system integration testing (SIT) ü Provided metrics on SIT status ü Continued to build UAT materials ü Supported Sprint 1 and 2 UAT ü Completed PETA training ü Developed automated test scripts for confidence testing Planned for next period q Begin UAT sprint 3 execution q Continue to build UAT materials q Continue system integration testing *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 ü 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 *If status is yellow or red, describe why. Large amount of materials needed with upcoming timelines. 7

Deployment Group 2 Timeline (High Level Phases) Y 8

Deployment Group 2 Timeline (High Level Phases) Y 8

Deployment Group 2 Self-Reported Status – May 27 to June 7, 2019 Clark College

Deployment Group 2 Self-Reported Status – May 27 to June 7, 2019 Clark College Accomplished this period ü Completed Sprint 2 UAT. FIN items with reviews/approvals needed are slowing down the process. Veterans staff had problems testing, others are now testing these processes. ü Have a prototype of High. Point mobile. Going through internal review process and expect to have live for summer term. Planned for next period q Query training for query developers by June 11 QDLC online – then Paula Mc. Daniel will come to Clark for PS Query 101 training in July. q UAT Sprint 3, and continue testing from Sprints 1 and 2. *If status is yellow or red, describe why If the First Link colleges do not adopt the new Chart of Accounts July 1 , this will likely delay the implementation at Clark. SBCTC Agency Y Accomplished this period ü FIN “Commitment Control” UAT is complete - June 6 ü HCM “Payroll to FIN” UAT is complete Planned for next period q Risk Management Team to review and possibly add risk on AWE, Global Account Level Cross-Walk rework, and HCM/FIN Security. Planned, but not completed q SBCTC has until end of UAT Sprint 4, July 15, 2019 to complete all UAT. June 7: UAT still in progress. Planned for next period q Chart of Accounts Redesign q Start SF testing if environment is ready. q Waiting for Go/No Go decision by ctc. Link Executive Leadership Committee (c. ELC) on 6/20. q Document impact on CCS with current Co. A cutover plans. q Security Issues q CCS to validate roles assigned to non-sensitive data vs sensitive data. SBCTC preparing to remove all old query roles. *If status is yellow or red, describe why • • 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 in Chart of Accounts meetings ü Participated in UAT ü Started OCM planning and execution for DG 2 project 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 Local SME attend Chart of Accounts meetings q Participate in UAT q Work with SMEs, Pillar Leads, TCC leadership to get better participation in the project R Accomplished this period ü Chart of Accounts Redesign ü SF Testing blocked. Pending SBCTC solution and implementation. TBD. ü HCM/Payroll completed testing week of June 10. ü FY Close – CCS continues to adjust journal entries. Pending cash accounts reconciliation and FY Closing rules for 16, 17, 18. Reviewing data/spreadsheets provided for cash accounts by SBCTC. ü DG 2 UATs – Wrapping up Sprint 2. Preparing for Sprint 3. • *If status is yellow or red, describe why (1. ) #65 - Security Mapping, (2. ) #60 - Chart of Accounts, (3. ) Accurate Approval Workflow Engine (AWE), #42 WAPAY: SBCTC requires this separate WAPAY payroll account up and running in production to go live in October. Tacoma Community Colleges of Spokane Y • Delays and overlap of all projects and deliverables impacting college staff now through October 2019. SBCTC Co. A decision to not convert sub-modules and their expectation for us to manually convert these will severely impact all daily operations. FY 16, 17, & 18. CCS continues to reconcile journal entry adjustments. CCS cannot close FY 16, 17 and 18 until cash reconciliation is completed for all cash accounts (large variances in these accounts for CCS and TCC). Need closing rules for 16, 17 and 18 to be run on period 0. CCS Chart of Accounts – 6. 12 – Extremely high risk. Not able to start SF testing yet pending an SBCTC solution and implementation. Not enough time allowed for testing. Requesting SBCTC exit criteria for Go No/Go decision, and how they plan to present to Steering Committee – No response to date. Security Role Redesign – No communications from SBCTC regarding when colleges will be able to test. No schedule or security role mapping guides provided. 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 – May 27 to June 7, 2019 Cascadia College

Deployment Group 3 Self-Reported Status – May 27 to June 7, 2019 Cascadia College G Accomplished this period ü Participated in multiple BPFG homework follow-up Web. Ex sessions ü Completed all 27 late FIN / SF homework assignments ü Attended two CPW’s in-person or via Web. Ex ü Initiated data error file cleanup for Cycle 3 Planned for next period q Complete data error file cleanup q Prepare for Data Validation Cycle #3 q Participate in BPFG homework follow-up Web. Ex sessions Lower Columbia College Pierce College District G Accomplished this period ü SMEs participated in SF BPFG sessions. ü SMEs participated in High. Point presentation. ü SMEs participated in Mobile Web. Ex follow-up session. ü SMEs participated in Reporting Lead Web. Ex session. ü SMEs participated in FA CPW session. ü SMEs completed/submitted homework assignments. ü SMEs prepared for Cycle 2 Validation. Peninsula College G Accomplished this period ü Completed all but CE and FWL assignments ü Attended CPW: FA Authorize/ Disburse/ Reconciliation ü Started Cycle 3 data cleanup Planned for next period q Attend Validation Workshops q Continue Cycle 3 data cleanup q Work on Cycle 2 validation Planned for next period q SMEs participate/complete Cycle 2 Validation q OCM activity – plan appreciation lunch for SMEs q Identify Training Lead G Accomplished this period ü Started work in Cycle 2 conversion validation ü Gather Reporting Team to determine the needs for transition of legacy reports ü Begin Transition activities for new project manager ü Start campus messaging and communication around fall training requirements for faculty and staff 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 q Select new project manager and work to transition activities and responsibilities into that new structure 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 Olympic College G Accomplished this period ü Submitted BPFG Homework ü Continued training third Project Analyst ü Continued work on Achieving the Dream (ATD)/ctc. Link Teams for Residency, Choosing Academic Plan, Changing Academic Plan ü Continued preparation for Data Cycle 2 Validation ü Started Cycle 3 Data Cleansing Planned for next period q BPFG Homework q Continue training third Project Analyst q Cycle 2 Data Validation Planned, but not completed • Additional CIA Workshops 11

Deployment Group 4 Dashboard Reports – May 27 to June 7, 2019 DG 4

Deployment Group 4 Dashboard Reports – May 27 to June 7, 2019 DG 4 Initiation Phase Completion Summary As of June 7, 2019* College/District Centralia College 50% Edmonds Community College 60% Highline College 55% Seattle Colleges (3) 48% Wenatchee Valley College 61% 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 Contact college Project Manager or ctc. Link for more information. DG 4 Pre-Implementation and General Timeline G 12

Deployment Group 5 Dashboard Reports – May 27 to June 7, 2019 DG 5

Deployment Group 5 Dashboard Reports – May 27 to June 7, 2019 DG 5 Initiation Phase Completion Summary As of June 7, 2019 College/District Bellevue College 10% Bellingham Technical College 18% Big Bend Community College 20% Everett Community College 20% Grays Harbor College 26% Green River College 24% Skagit Valley College 13% Whatcom Community College 25% 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 – May 27 to June 7, 2019 Solution Status

ctc. Link Remediation Status Reports – May 27 to June 7, 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 CCs of Spokane Chart of Accounts Adoption Kickoff Feb. 1, 2019 Complete Human Capital Management 6 of 25 remain open DG 2 Foundational Chartfield Configuration March 22, 2019 Complete Faculty Workload Complete March 2019 College Configuration Review and Updates May 3, 2019 Complete DRS Redistribution Complete May 2019 Functional and System Integration Testing May 10, 2019 Complete User Acceptance Testing May 10 - June 3, 2019 Complete May 28 – June 14, 2019 Absence Management Complete April 2019 Security Audit Controls Security Redesign Mapping Framework FLC / DG 2 Student Billing/Third-Party Billing Complete May 2019 Budget Planning Form Work Group Jan 2020 Online Admissions App Governance DG 2 Readiness Gate / Go-No Go Decision June 18, 2019 Not Started Continuing Education Vendor Negotiations DG 3 Production Cutover July 2019 Not Started Community Colleges of Spokane College Readiness Gate / Go-No Go Discussions R Remediation items progress this period • Student Statements and Third Party Billing - passed UAT and in Production. Looks great! • 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). • FY Close – see previous slide. • Security Role Redesign - No communications from SBCTC on UAT schedule or availability of Security Role Mapping Guides. June 12 -14, 2019 Complete Tacoma Community College G Accomplished this period ü See SBCTC status update for Remediation items, tickets, and worklist ü Received responses to TCC’s December 2018 remediation response, however TCC’s feedback did not seem to be acted upon. Planned for next period q Receive remediation detail with responses based on December 2018 feedback 14

Other ctc. Link Project Activities – Status as of June 7, 2019 RFP Publish

Other ctc. Link Project Activities – Status as of June 7, 2019 RFP Publish Solution Decision 10/15/2018 Negotiations subgroup assisting with final negotiations New Solution Status Continuing Education • • • Online Admissions Application TBD • 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 upon requirements for RFI Budget Planning • Committee to be formed to review, finalize and approve Budgeting requirements • Review requirements against Oracle PBCS Solution • If needed, develop RFP TBD Waiting on Budget work group to meet and vet 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) Accessibility • • • 5/10/2019 Testing Prior to DG 2 (October 2019) 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 has been contacted to begin negotiations to contract Continued discussions with Appsian (formerly Grey Heller) Identify accessibility vendor to assist with testing of ctc. Link Develop and published RFP Work Group engaged to evaluate RFP Responses Final Decision on Vendors to be awarded Pending RFI 15