Project Overall Status May 13 24 2019 Overall

  • Slides: 15
Download presentation
Project Overall Status – May 13 -24, 2019 Overall Y Schedule Y • •

Project Overall Status – May 13 -24, 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 Scope Y • Monitoring scope and timing of: Budgeting Tool, Continuing Education, Online Admissions Application, Physical Assets and OBIA implementations Budget G 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. DG 4 is in the Initiation Phase, with most colleges just past the halfway mark on deliverables. Gate 1 Peer Review will be in late July. DG 5 colleges have begun Initiation Phase and are learning the public status reporting process. DG 6 has begun the initiation phase and will start the public reporting process this fall. • Requirements Traceability Matrix (RTM) needs to be updated to validate original RFP requirements have been implemented, tested, and end users trained on the processes and functionality • • Currently tracking under budget New Technology Plan approved as well as Stage Gate #3 for OFM/OCIO Technology Pool funding Overall Status Summary per Deployment Group DG# PMOReported Comments Status Clark DG 2 Y SBCTC Mapping is still pending Spokane • Security Production DG 3 G G DG 5 G DG 6 G Y G R G Cascadia G LCC Complete Olympic • Conversion cycles have Peninsula begun G Pierce DG 4 Self. Reported Status Tacoma • BPFG Workshops 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. College/ Agency • College teams working on Initiation Phase activities G G G Implementation reporting begins Nov. 2019 Implementation reporting begins March 2020 Implementation reporting begins Nov 2020 1

Top Risks Reported – as of May 24, 2019 Risk Level Risk Description Mitigating

Top Risks Reported – as of May 24, 2019 Risk Level Risk Description Mitigating Actions LEGEND: C Critical H High M Submitted by (name, org/college), Deployment Group & Date Moderate Low Risk Owner (s) H Chart of Accounts (Co. A): User adoption and Update: ctc. Link has shifted resources to focus on Co. A. Emmett Folk, ctc. Link PM for FIN & HCM Team Emmett Folk successful deployment (scheduled for July 1, 2019) is Spokane engagement is strong. Emmett met with TCC critical for Deployment Group 2 (DG 2) timeline. SMEs on 5/24/2019 to gauge engagement level and DG 2 Impacted, Risk Date: 10/12/2018 support needed. UAT begins week of 5/28/2019. *Refer *also Risk submitted by Matt Connelly, to Co. A milestones tracking in this report. Spokane District PM on 10/23/18 If manual work is required, SBCTC Agency go-live activities could be impacted by the diversion of SBCTC staff resource. SBCTC researching all potentially impacted areas to test what could happen and determine mitigation steps. Evelyn Williams C 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 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: Impact to college Continuing Education (CE) program. seems likely Clark will start with OSECE and possibly move to Campus. CE. Decisions are dependent on cost for Campus. CE, support for OSECE and impact to students. Update: ctc. Link team met to discuss options for OSECE and Campus. CE. Preparing to deploy OSECE and waiting on vendor contract negotiations. Campus. CE request for enrollment information sent to campus Continuing/Corporate Education directors. PMs were asked to follow up locally with their CE directors to help meet June 1 deadline. Susan Maxwell, Clark PM C Top Issues Reported – as of May 24, 2019 Issue Level Issue Description Security Mapping activities to mitigate UAT timeline, have not addressed the new Security Design Production user access. H H DG 3 Cycle 2 Student Financials (SF) Conversion – Configuration was not accurate or completed to execute conversion as of 5/20/19. Status 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. Emmett Folk, Christyanna Dawson DG 2 Impacted, Risk Date: 5/3/2019 DG 2 Impacted, Risk Date: 3/15/2019 John Henry Whatley, Dennis Colgan L LEGEND: H High M Moderate Submitted by (name, org/college), Deployment Group & Date ctc. Link PMO submitted for ctc. Link CS, HCM, FIN Team Low Issue Owner (s) Tara Keen, Security Team DG 2 Impacted, Issue Date: 4/16/2019 SF will attempt to update and complete configuration, John Henry Whatley, ctc. Link PM for CS Team execute conversion 5/30/19 with SF Functional validation thereafter. College validation impact can be minimized DG 3 Impacted, Issue Date: 5/23/19 or not impacted at all (college validation dates 6/127/2/19). Chandan Goel & John Henry Whatley 2

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

ctc. Link Quality Assurance Scorecard Moran -Technology Consulting ctc. Link Quality Assurance Scorecard Moran Technology Consulting , Report: NOVEMBERApril 2018 2019 STATUS G G Y Y Overall Status Y PROJECT AREA DESCRIPTION / NOTES SBCTC/Governance framework continues to work as expected. Meetings are held according to schedule, with materials distributed beforehand, and decisions made at the appropriate level. Project Management Office (PMO) is fully staffed, working well together and continuing to address improvements in project management processes. Phase Scope QA remains concerned about the number of solutions to be re-implemented to replace/augment current PS functionality and that timing and resource availability could negatively impact DG 2/DG 3 scope and schedule. Schedule Status Training 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. This work stream is yellow, but is trending green due to the decisions and actions taken by PMO which have enabled recovery of this key workstream. DG 2 success dependent on active end-user participation, assessments and college follow-up. This work stream is yellow, but trending green due to changes made by the PMO. DG 2 UAT Sprints supported by training materials began in April and run through August. DG 2 testing workstream remains a concerns since it relies heavily on availability and expertise of functional project staff. Testing G Configurations / Data Conversion Technical work for DG 2 System Configurations and Data Conversion Cycle 4 continues with good results reported. QA considers it an important achievement that Clark College is now live in the ctc. Link Production Environment with user maintenance of their course catalog. G Organizational Change Management (OCM) PMO/OCM is actively engaged with all colleges now involved with their Deployment Groups. QA concerned that PMO focus remains on the DG 2 schedule. G Y Project Staffing Technical Environment LEGEND Risk Description: Project staffing is adequate at this time and continues to make staffing adjustments as appropriate. QA and the PMO remain concerned that the overlap of DG 2/DG 3/DG 4 may require additional project and contractor resources. Project leadership and staff morale is positive given schedule pressures. PMO is recruiting for seven open positions. Future PS updates/bundles and third-party software installation and support work is being managed by the IT Division outside of the project responsibility. Overall planning of these changes needs to be tightly integrated with the ctc. Link DG 2/DG 3/DG 4 schedules. This becomes more challenging with the overlap in implementation schedules. Draft SLA agreement has been distributed to the colleges. 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 May 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 In Progress 1/1/2019 G 4 DG 2 – Transition & Deploy Phase DG 3 – Construct Phase DG 4 – Initiation & Structure Phase Future 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 April 30, 2019 G 5

Budget Status – as of April 30, 2019 G 5

Pillar Status – May 13 to May 24, 2019 Campus Solutions G Accomplished this

Pillar Status – May 13 to May 24, 2019 Campus Solutions G Accomplished this period ü DG 2 Sprint 2 CS UAT ü Held FA Parallel Processing Web. Ex with Clark ü Clark Class Building and AAR Go Live Workshop (5/13 -5/17) ü Present CS GDR recommendations to ctc. Link Steering Committee ü DG 3 BPFG Sessions for Core, SF and FA ü Continue DG 3 FIT ü Continue DG 2 SIT ü Continue work on SAP Modification with FAST Group ü Continue UAT material planning/build ü Review DG 3 assignment submissions for configuration ü High. Point Mobile framework for Clark built in Mobile 1 and Mobile 2 environments. Planned for next period q 9. 2 Fluid presentation to Working Group 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) q FA Authorization/Disbursement/Reconciliation CPW preparations q Finalize High. Point Mobile configuration for Clark in Mobile 1 and Mobile 2 environments after assignment submission due 5/28. Human Capital Management Y Pillar Status – as of 6/8/2018 Accomplished this period ü Completed DG 3 Cycle 3 Configuration Migrations to GLD ü Began Payroll Parallel Testing Activities ü Began DG 3 Cycle 3 Validation Material Development ü Continued UAT support activities ü Continued DG 2 UAT diagram/scenario updates and 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. Financial Services Y Accomplished this period ü Completed DG 3 Cycle 2 Configuration Migrations to GLD ü Began DG 3 Cycle 3 Validation Material Development ü Continued DG 2 UAT support activities ü Continued DG 2 SIT Test Execution ü Continued DG 2 UAT diagram/scenario updates and 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 13 to May 24, 2019 Communications Accomplished this period ü

Workstream Status – May 13 to May 24, 2019 Communications Accomplished this period ü Bulk upload of configurations in FNC environment to support DG 3 Cycle 2 ü Successfully migrated delta configurations from Functional Test to Gold/ SIT/ UAT environments ü Begin Migration process of configurations to support Go-Live Class setup activities in Production (DG 2) Planned for next period q Conversion Issues resolution (DG 2/ DG 3) – In Progress q Finalize approach to establish DG 2 EMPLID in Production – In Progress Planned for next period q Communications Office scope/activities q ctc. Link at Commissions/Councils spreadsheet and process q Templates work (including Critical Communications Template) q Begin Comms Advisory Committee planning DEVELOPMENT G Accomplished this period ü Completed BPFG Sessions ü Met with DG 2 (Clark) to work on Cutover Planning ü Met with Clark to discuss student financials and dual processing for Financial Aid ü Continued discussions with DG 5 colleges around Initiation deliverables ü Continued planning the DG 5 Initiation Road Show ü Continued planning DG 4 Peer Review ü Assisted in onboarding new college PMs 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 4 and DG 5 G CONVERSION Accomplished this period ü Steering Committee minutes, meeting prep, meeting packet, meeting support ü Steering Committee Charter Subgroup: charter updates, meeting planning and support ü Troubleshoot ctc. Link logo replacement (for Upgrade) with Campus Solutions team ü Blog post re Clark College live on Campus Solutions catalog and other modules ü ctc. Link Governance updates communication Organizational Change Management Technical G Accomplished this period ü Support and work on Service Desk, SIT & UAT tickets for CS, HCM & FS pillars ü Migrated the retrofit projects (for CS PUM 13, HCM PUM 29 & FSCM PUM 31) to UAT, SIT, TRD, SVL, COA & GDR environments Planned for next period q Continue to support SIT & UAT tickets for CS, HCM and FS pillars ENVIRONMENTS Accomplished this period ü Coordinated PUM Image Update in Project environments. ü Coordinated Load Testing Project work. ü DG 3 cycle 2 environment support. ü Accessibility setup in PROJ Environments in progress ü STAT project Planned for next period q STAT Project – In Progress q Coordinate PUM image updates 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 installation and configuration of PETA (People. Soft Enterprise Test Automation) ü Began PETA training ü Provided metric on UAT status Planned for next period q Continue to build UAT materials q Continue system integration testing q Continue supporting UAT *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 and executed sprint 2 materials and training sessions ü Made modifications on training delivery via lessons learned ü Currently at 75% with content for Sprint 3 ü Completed, disbursed Sprint 3 schedule to PMs ü Continue to work with vendor on Finance and HCM 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 *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 13 to 24, 2019 Clark College Y

Deployment Group 2 Self-Reported Status – May 13 to 24, 2019 Clark College Y Accomplished this period ü Completed assigning change action tasks to key staff. Over 600 tasks to review, complete. ü Workshop with SBCTC staff to build AAR’s. ü Workshop with SBCTC staff to schedule fall and winter classes. ü Completed Sprint 1 UAT Planned for next period q Query training for query developers by 6/11 first course q Complete UAT Spring 2 *If status is yellow or red, describe why. Building in production going well, but slow. People are learning lots in UAT. Some challenges with approvals of vouchers. SBCTC Agency G Accomplished this period ü FIN testing for Create and Modify Capital Projects ü FIN training and testing for Requisition Processing ü HCM training and testing for Entering Processing Absence, Manage Time & Labor Enrollments, Manage Benefits Enrollments, Entering/Processing Time. ” ü Executive Sponsor John Boesenberg attended PM Summit May 6 -7 ü New Rick #63 - Risk of losing grant money due to federal fiscal year-end Planned for next period q Risk Management Team to add risk regarding Grant conversion, and review WAPAY status update, Global Account Level Cross-Walk rework, and HCM/FIN Security. 5/24 – 6/7 q ADKAR “Knowledge” Info-Session TBD in June q FIN scanner being tested, a go/no go may be determined during this time. Tacoma Community College 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. ü Participate in UAT/pre-UAT meetings ü 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/pre-UAT meetings q Work with SMEs, Pillar Leads, TCC Leadership to get better participation in project q Plan and execute OCM for DG 2 project G Community Colleges of Spokane R Accomplished this period ü Chart of Accounts Redesign ü Received all initial Finance cutover plans ü Reviewed UAT test plans and process (5/28). ü Requesting UAT plans for CS/HCM/FWL. Delayed. ü FWL Pkg 2. SBCTC provided Web. Ex for FWL admins on new contract types. ü FY Close – CCS continues to adjust journal entries. Pending cash accounts reconciliation and FY Closing rules for 16, 17, 18 & 19. ü DG 2 UATs – wrapping up Sprint 2. Requesting testers for sprint 3. Planned for next period q Chart of Accounts Redesign q Start Finance UAT testing 5/29 thru 5/31. q Review CS/FA/SF/FWL cutover plans; need to communicate UAT process to CS leadership prior to UAT start 6/3 to 6/5. q Communicate cutover plans to all pillar leads. q Security Issues q CCS to validate roles assigned to non-sensitive data vs sensitive data. SBCTC preparing to remove all old query roles. Meeting week of 5/28. q Finance q CCS continues to adjust journal entries. q Review latest SBCTC reconciliation of key cash accounts to determine cause of 18 million dollar variances *If status is yellow or red, describe why. • Remediation Conditions. Student statements 2 nd UAT passed; ready for Production. DRS passed UAT, implementation date TBD. Absence management passed UAT, but CCS validating some incorrect calculations. Third party billing failed UAT 5. 21. 39 open remediation tickets. • FY 16, 17, & 18. CCS continues to reconcile journal entry adjustments. CCS cannot close FY 16, 17, & 18 until cash reconciliation is completed for 101150, 101160, & 101110 (large variances in these accounts for CCS and TCC). Pending detailed T-Accounts and transaction process flow for these accounts. Need closing rules for 16, 17, & 18. One T-account analysis done (balanced, no variance found). 6 key/high volume accounts pending. • CCS Chart of Accounts – 5. 28 - High risk as SBCTC cutover plans still in progress. Finance plans completed but CS/SF/FA & FWL plans not completed as of 5/24. • Urgent Security issues - SBCTC preparing for removing old queries. Bank Statement security fix to be addressed with DG 2 release (Oct. 2019). • Security Role Redesign – Delayed rollout. CCS now saying UAT mapping/testing may happen late July/early August. Pending rollout of auditing reporting and separation of duties. 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 13 to 24, 2019 Cascadia College G

Deployment Group 3 Self-Reported Status – May 13 to 24, 2019 Cascadia College G Pierce College District G Accomplished this period ü Attended the five remaining BPFG follow-up Web. Ex sessions ü Submitted CS and HCM homework assignments on time ü Completed CS data validation crosswalks Accomplished this period ü SMEs participated in BPFG Web. Ex sessions. ü SMEs completed/submitted homework assignments. ü SMEs prepared for Cycle 2 Validation. Planned for next period q Finish all late SF and FIN BPFG assignments q Complete all remaining CS and HCM homework assignments q Prepare for Data Conversion Cycle #3 and Validation Planned for next period q SMEs participate in CPW’s. q SMEs participate/complete Cycle 2 Validation. q OCM activity – plan appreciation lunch for SMEs. q Reporting Lead discussion with SBCTC. q Identify Training Lead Planned, but not completed • Could not complete one SF item crosswalk validation in this cycle • Could not complete 12 SF and 15 BPFG homework assignments by due date – working closely with SBCTC Pillar staff to complete in May Lower Columbia College G Accomplished this period ü Work with Alignment Team to plan for Cycle 2 Conversion/Validation Work ü Work with Alignment Team to plan testing and training activities ü Completed BPFG activities Planned for next period q Work with Alignment team to plan testing and training activities q Work with Alignment team to plan Cycle 2 Configuration activities q Continue to develop forecasting tools to track staff workload and project hours. 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. Peninsula College G Accomplished this period ü Submitted all CS & FIN homework assignment due this period ü Attended final BPFG sessions ü Completed crosswalk validation ü Attended CPW: Banking & Reconciliation ü Created Communications Workgroup Planned for next period q Continue to complete and submit BPFG assignments. q Attend upcoming CPW workshops q Prepare for Cycle 2 validation Planned, but not completed • FWL assignments: Issues with faculty workload configuration. SBCTC staff are having to configure us differently, which has put us behind on completing assignments. Olympic College G Accomplished this period ü Attended remaining BPFGs ü Submitted BPFG Homework ü Began training third Project Analyst ü Continued work on ATD/ctc. Link Teams for Residency, Choosing Academic Plan, Changing Academic Planned for next period q BPFG Homework q Continue training third Project Analyst q Prepare for Cycle 2 Data Validation Planned, but not completed • Additional CIA Workshops 11

Deployment Group 4 Dashboard Reports – May 13 to 24, 2019 DG 4 Initiation

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

Deployment Group 5 Dashboard Reports – May 13 to 24, 2019 DG 5 Initiation

Deployment Group 5 Dashboard Reports – May 13 to 24, 2019 DG 5 Initiation Phase Completion Summary As of May 24, 2019 College/District Bellevue College 0% (No Update) Bellingham Technical College 17% Big Bend Community College 15% Everett Community College 14% Grays Harbor College 23% Green River College 23% Skagit Valley College 12% 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 13 to May 24, 2019 Solution Status

ctc. Link Remediation Status Reports – May 13 to May 24, 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 Absence Management Complete April 2019 Security Audit Controls Security Redesign Mapping Framework FLC / DG 2 User Acceptance Testing In Progress Student Billing/Third-Party Billing May 10 - June 3, 2019 May 28 – June 14, 2019 In UAT May 2019 Budget Planning Form Work Group Jan 2020 College Readiness Gate / Go-No Go Discussions June 12 -14, 2019 Not Started 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 R Remediation Items progress this period • Student Statements – Pending 2 nd SIT/UAT – Passed, ready for Production. Need to validate in production before checking off. • Security Audit Controls – In progress. SBCTC preparing for removing old queries. Bank Statement security fix to be addressed with DG 2 release (Oct 2019). • Accurate Reporting for DRS & PEBB – Passed UAT, pending actual availability in Production. • Third Party billing – Pending SIT/UAT. Failed 5/21 UAT. Pending fix in test environment. • FY Close – see previous slides. • Book to Bank - Cash Reconciliation. Focus now is on reconciliating the three cash accounts making up our $18 million dollar variance (same accounts for TCC). Received one T-Account; pending analysis for six key accounts. *If status is yellow or red, describe why. • Remediation Conditions. Student statements 2 nd UAT passed; ready for Production. DRS passed UAT, implementation date TBD. Absence management passed UAT, but CCS validating some incorrect calculations. Third party billing failed UAT 5/21. 39 open remediation tickets. • FY 16, 17, & 18. CCS continues to reconcile journal entry adjustments. CCS cannot close FY 16, 17, & 18 until cash reconciliation is completed for 101150, 101160, & 101110 (large variances in these accounts for CCS and TCC). Pending detailed TAccounts and transaction process flow for these accounts. Need closing rules for 16, 17, & 18. One T-account analysis done (balanced, no variance found). 6 key/high volume accounts pending 39 open remediation tickets. • Security Role Redesign – Delayed rollout continues. CCS now saying UAT mapping/testing may happen late July/early Aug. Pending rollout of auditing reporting and separation of duties. Tacoma Community College G Remediation Items progress 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 Planned, but not completed • • • *If status is yellow or red, describe why. 14

Other ctc. Link Project Activities – Status as of May 24, 2019 New Solution

Other ctc. Link Project Activities – Status as of May 24, 2019 New Solution Status Continuing Education • • • Online Admissions Application RFP Publish Solution Decision 10/15/2018 Negotiations subgroup assisting with final negotiations • 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 • Work Group to Review feedback from College discussions to provide recommendation Commission to provide recommendation to Governance. TBD Waiting for recommendation to Governance for Decision 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 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 RFP / Publish RFP Work Group will be engaged post publish to allow for feedback and amendment 15