Project Overall Status September 2 to 13 2019
Project Overall Status – September 2 to 13, 2019 Overall Y • • Schedule Y Program is on track, per timeline, scope and budget Activities for DG 2 are being complete just in time and issues being mitigated to meet current timeline Current DG 2 Schedule has no “float” remaining in timeline Monitoring scope and timing of: Budgeting Tool, Continuing Education, Online Admissions Application, 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, preparing for October go-live. Go/No-Go decision is scheduled for Sept. 24, 2019 Steering Committee. If a “Go, ” ctc. Link will be offline for the DG 2 upgrade Oct. 11 -14 and again for cutover activities Oct. 25 -28. • DG 3 is in the Construct Phase, focused on Conversion and Data Validation and Functional Unit Testing. Steering Committee approved new March 9, 2020 DG 3 go-live date. • Steering Committee approved DG 4 to enter the Implementation Phase, with a kick-off slated for Oct. 14, and a revised DG 4 go-live date of Feb. 1, 2021. • DG 5 colleges are in the Initiation Phase and continue Initiation Deliverables status reporting. Gate 1 Initiation Phase Peer Review slated for early Dec. 2019. • DG 6 is in the Initiation Phase and will start public status reporting this fall. The Initiation Phase Road Shows are scheduled for Oct. 2019. • • 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. Steering Committee approved the requirements for the Budget Planning Tool. Oracle/Mythics is developing a prototype and will provide a demo to the Budget Planning Tool work group. Level Access completed Accessibility testing for Student and Employee Self. Service, Mobile is still in progress. Phase 2 includes online admissions application and continuing education tools (OSECE and Campus. CE). 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 Allotment for Gate 4 funding has been partially approved (Partial approval with conditions per 8/30/19 OCIO letter). Additional request for remaining Gate 4 funding will be submitted in late September. Y G • Overall Status Summary per Deployment Group DG# PMOReported Comments Status • Security Production Build DG 2 Y and Mapping late • Readiness conditions of work still in progress • Conversion cycles have DG 3 G DG 4 G DG 5 G DG 6 G begun • Functional Unit Testing • Preparing for System Integration Testing College/ Agency Self. Reported Status Clark G SBCTC Y Spokane R Tacoma G Cascadia G LCC G Olympic G Peninsula G Pierce G • College teams working on Implementation begins Nov. 2019 Initiation Phase activities • College teams working on Implementation begins March Initiation Phase activities 2020 • College teams working on Implementation begins Nov 2020 Initiation Phase activities 1
L Top Risks Reported – as of Sept. 13, 2019 Risk Level H Risk Description C Critical H High Update: One outstanding item is being resolved that is tied to automation in the General Ledger module. Development work is completed and testing is in progress. Clark: SF, FA, FIN , GL – Clark submitted these risks. Update: Items related to Student Financials, Financial Aid, General Ledger and coordination between Student Financials and Finance. Follow-up and continued discussion with Clark’s PM after Cycle 4 B validation to better understand which items are still outstanding. Susan Maxwell, Clark College PM Update: Finance and Student Financials teams continue to meet to discuss AR (Accounts Receivable) items and alignment in data conversion activities and processes. Chandan Goel ctc. Link Team: The GL & SF Conversion logic/requirements for the Go-Live term has still not been finalized. If not addressed soon, it creates a risk of being unavailable for college validation and meeting Cycle 4 B and future cycles. M Moderate Submitted by (name, org/college), Deployment Group & Date 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 H Mitigating Actions LEGEND: Emmett Folk, ctc. Link PM for FIN & HCM Team Low Risk Owner (s) Emmett Folk DG 2 Impacted, Risk Date: 10/12/2018 *also Risk submitted by Matt Connelly, Spokane District PM on 10/23/2018 DG 2 Impacted, Risk Date: 2/1/2019 Risks #50, #51, #52, #58 John Henry Whatley, Emmett Folk, Chandan Goel John Henry Whatley, Christyanna Dawson DG 2 Impacted, Risk Date: 7/8/2019 Risk #71 (moved to Issue Log 8/1/19, Issue #50) L Top Issues Reported – as of Sept. 13, 2019 Issue Level H Issue Description Security Mapping activities to mitigate UAT timeline have not addressed the new Security Design Production user access. Clark – Accessibility items M Status Update: The ctc. Link team is highly concerned about the Production Security Mapping for DG 2 Colleges and entering new Security into the UAT cycles. SBCTC – Security mapping is not complete and doesn’t reflect roles/job. SBCTC SMEs are working with FIN/HCM leads to test security for specific modules/roles that are ready. 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 *also issue #37 submitted by Evelyn Williams, SBCTC on 6/26/19. Clark has submitted issues around accessibility items they Susan Maxwell, Clark College PM have identified. We are tracking these items and have provided this first round of information to Level Access DG 2 Impacted, Issue Dates: 6/27/2019 (vendor) in early August. Phase 1 testing by Level Access is Issues: #39 -48 complete and results has been shared with Clark. ctc. Link Team began working with Oracle to solve some of the issues. Phase 2 testing slated to begin in early September. Owners assigned 2
WA State Office of the Chief Information Officer (OCIO) Oversight as of August 2019 WA State Office of the Chief Information Officer (OCIO) Oversight 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 Partially Approved 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. 3
ctc. Link Quality Assurance Scorecard / Moran Technology Consulting Report ctc. Link Quality Assurance Scorecard - Moran Technology Consulting , NOVEMBER August 2019 2018 STATUS Y DESCRIPTION / NOTES SBCTC/Governance The Go/No Go Decision for DG 2 implementation is planned to be made in late September by the ctc. Link Steering Committee. This decision is considered most critical to meeting the schedule for success of DG 2 and impacts all remaining Deployment Groups. Project Management The PMO continues to make adjustments in staffing, and team continues working well together. PMO was preparing the Readiness Template for intended use with DG 2. Phase Scope QA continues to remain concerned that the risk created by the number of solutions to be re-implemented to replace/augment current People. Soft functionality. Major scope changes will impact budget, schedule, and project and support staffing. The implementation of enhanced role security for ctc. Link is a major Project and QA schedule risk concern. The DG 2 schedule is now less than 60 days from Go-live. Pressures are mounting on the project team and the DG 2 Colleges and State Board. The PMO was actively detailing multi-step plans for DG 2 Go-live data conversions and production cutover. FLC colleges will be going into a production upgrade state with new functionality, while Clark and the State Board will be first time implemented with People. Soft. Training team and consultants continue working on preparing materials for the delivery of end-user training courses scheduled for September. This scope includes a combination of Self-Paced Courses and Instructor-Led Training workshops. However, considering the workstream schedule, QA continues to be concerned that considerable content development remains for the 56 courses to support range of end-user training. The majority of the planned 36 Instructor –Led courses is Finance pillar specific and requires support from functional project staff. Schedule Status Y Training Y Y G G G Y Y PROJECT AREA G G Overall Status Testing The last DG 2 User Acceptance Testing (UAT) Sprint (Sprint #6) is now scheduled for the first week of September. DG 2 has been executing a large testing workstream that includes parallel testing for payroll, financial aid, and tuition calculation. Configurations / Data Conversion Technical staff supported the DG 2 cycle 4 B conversion for additional data validation by Clark and SBCTC. The data conversion and production implementation of the Bio-Demo data for Clark College and SBCTC has a September 7 target date. Performance Load Testing identified technical production to ensure ctc. Link system meets increased student user usage projections (20, 000 active student users). Organizational Change Management PMO/OCM is actively engaged with all colleges now involved with their Deployment Groups. ctc. Link management teams continue to meet with DG colleges via on-site check-ins. With 60 days until Go-live, QA remains concerned the PMO focuses on the DG 2 schedule/priority activities. 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. Additional positions supporting ctc. Link production have been approved and hiring underway. The ERP Change Management Board is being re-implemented to improve coordination and scheduling of changes. Service Level Agreement is awaiting final signatures. 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. 4
Budget Status – as of Aug. 31, 2019 G 5
Pillar Status – September 2 to 13, 2019 Campus Solutions Accomplished this period ü Clark Item Types migrated to PRD in support of Course and Class Fee workshop at Clark ü Support DG 3 Cycle 3 Data Validation ü Hand off DG 2 Cycle 5 optional files to Legacy team ü Complete UAT material planning/build ü Complete UAT for DG 2 ü Hold Clark Parallel Testing – Tuition Calculation ü Continue DG 2 SIT ü DG 2 Mock Run for Go Live activities ü EMPL IDS for Clark and SBCTC in PRD Planned for next period q Support DG 3 Cycle 3 Data Validation q Continue DG 2 Mock Run Activities q DG 2 Cycle 5 Data Validation q Hold Course and Class Fee workshop at Clark (9/20) q Continue DG 3 FIT q Begin DG 3 SIT q Continue UAT material planning/build Planned, but not completed • Begin DG 3 SIT G Human Capital Management Y Status – as of 6/8/2018 Accomplished. Pillar this period ü Began DG 2 Go-Live Dry Run activities ü Continued DG 2 Cutover planning ü Continued support of DG 3 Cycle 3 validation activities ü Continued support for DG 2 Cycle 4 B validation activities ü Completed support for accessibility testing with Level Access ü Continued DG 4 BPFG session planning ü Continued review of Security Redesign Role/Permission List Definitions ü Continued DG 2 UAT support activities ü Continued review of DG 2 Training content structure and materials ü Continued DG 2 and DG 3 configuration build-out in FNC environment Finance Y Accomplished this period ü Began DG 2 Go-Live Dry Run activities ü Continued DG 2 Cutover planning ü Continued support of DG 3 Cycle 3 validation activities ü Continued support of DG 2 Cycle 4 B validation activities ü Continued review of Security Redesign Role/Permission List Definitions ü Continued DG 4 BPFG session planning ü Continued DG 2 UAT support activities ü Continued DG 2 UAT supporting content build ü Continued review of DG 2 Training content structure and materials ü Continued DG 2 and DG 3 configuration build-out in FNC environment Planned for next period q Continue DG 2 Cutover planning q Complete DG 2 Go-Live Dry Run activities q Complete DG 4 BPFG session planning q Continue support of DG 3 Cycle 3 and Cycle 4 B validation activities q Continue review of Security Redesign Role/Permission List Definitions q Continue DG 2 UAT support activities q Continue DG 2 UAT supporting content build q Continue review of DG 2 Training content structure and materials q Continued DG 2 and DG 3 configuration build-out in FNC environment Planned for next period q Complete DG 2 Go-Live Dry Run activities q Continue DG 2 Cutover planning q Complete DG 4 BPFG session planning q Continue support of DG 3 Cycle 3 and Cycle 4 B validation activities q Continue review of Security Redesign Role/Permission List Definitions q Continue DG 2 UAT support activities q Continue DG 2 UAT supporting content build q Continue review of DG 2 Training content structure and materials q Continued DG 2 and DG 3 configuration build-out in FNC environment q Continue DG 2 UAT supporting content build *If status is yellow or red, describe why. Need for additional functional team support in earlier work packages and currently in-process work items has delayed the start of functional team level DG 2 go -live planning and prep activities. 6
Workstream Status – September 2 to 13, 2019 Communications G Accomplished this period ü Steering Committee meeting materials support, review, distribution ü Deployment Readiness Documents review, edits ü OCIO IT Projects Dashboard updates ü DG 2 student/employees communications planning review/assistance ü Review and edit DG 2 readiness spreadsheet, DG 4 Gate 1 deck, DG 2 roadshow, budget tool requirements spreadsheet ü Work on updating DG 2 (Clark, SBCTC) portal and tiles page logos Planned for next period q Steering Committee meeting materials support, review, distribution q Prep Go/No-Go decision package materials q Project Status/Roundup blog post q Revise end-user training registration web/process. Organizational Change Management G Accomplished this period ü Met with DG 2 PM’s to discuss how change management activities are going with their teams ü Planning Go-Live Readiness meetings with DG 2 college ü Conducted onboarding with new college PMs and OCMs ü Planning next meeting with all technical colleges to discuss 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, DG 5 and DG 6 Technical G CONVERSION Accomplished this period ü DG 2: Conversion Issues review/ resolution. ü DG 2: Successfully establish DG 2 Employee Bio Data in Production. Planned for next period q Planned for next periods q DG 2: Successfully completed the DG 2 Dry Run Activities. DEVELOPMENT Accomplished this period ü Support and work on Service Desk, FIT, SIT & UAT tickets for CS, HCM & FS pillars. ü Successfully completed the DG 2 Dry run activities for CS 9. 2 Upgrade. ü Successfully completed the DG 2 Dry run activities for HCM & FS Fluid. Planned for next period q Continue to support on Service Desk, FIT, SIT & UAT tickets for CS, HCM & FS pillars. q FTDD document updates for DG 2 CEMLIs. q FTDD document updates for CS 9. 2 retrofits. ENVIRONMENTS Accomplished this period ü Work on UPGRADE DRY RUN plan ü 2020 Release calendar finalized after meeting with ERP support ü DG 2 UPGRADE Dry Run activities Planned for next period q DG 2 Dry Run conversion environment support q Load Testing Project report review. Testing Y Accomplished this period ü Continued system integration testing (SIT) • Finance 100% Complete • HCM 100% Complete • CS 89% Complete ü Continued Sprint 6 testing ü Provided metrics on SIT and UAT status ü Continued to build UAT materials for final sprint Planned for next period 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 ü Continued work on in all pillars on development of end-user training (EUT) courses ü Released 16 completed end-user courses to participants ü Currently at 45% for end-user training Canvas Courses ü Worked with DG 2 PMs to incorporate lessons learned from EUT ü Working with Communications and Digital Asset Manger to create new registration process ü Continued work to define training scope, work assignments, activity durations, and dependencies Planned for next period q Continue to work on end-user Training courses *If status is yellow or red, describe why. Large amount of materials needed with upcoming timelines. 7
Deployment Group 2 Timeline (High Level Phases) G 8
Deployment Group 2 Self-Reported Status – September 2 to 13, 2019 Clark College G Planned for next period q Security roles q Set up meetings with various groups q Go/No-Go recommendation q SBCTC 1 day session for course fees and instructors Planned for next period ü Track ctc. Link 9. 2 training stats for registration and completion ü Create plan for testing new security roles (how/when/who) ü Complete HCM/Payroll training Planned, but not completed • Keeping up with emails Y Accomplished this period ü Training and Communication Plans completed and approved. ü Data validation homework completed and turned in for Grants and POs. ü Progress getting OBIS (supplemental system) and CI Upload for Vouchers for grant invoices from colleges set up. Work is ongoing. ü Completed some EUT training in canvas and ILT, TAM and HCM core. Risk Management Team updates: ü Issue #37 on Security – progress made on Security issues; anticipate completing security assignment plan next week. Planned for next period q Will continue work with IT programming staff on OBIS (supplemental system) and CI Upload for Vouchers for grant invoices set up q Will continue training as released. q Will work on validation of grant and OP data turned in last week. Planned, but not completed • End-to-end testing planned once Security and AWE in place – in jeopardy without Security and AWE *If status is yellow or red, describe why. The SBCTC agency currently is making progress working through security issues and anticipate progress to continue. Although we’re seeing progress, security and training remain areas of concern and focus. R Accomplished this period ü Continue to address post Co. A cutover issues ü Worked on College Readiness Checklist ü Planning for new ctc. Link Training & Registration process/site. ü Participated in CS 9. 2 CCS communications roadmap for Go Live ü Completed CS Image update UAT ü Staff signing up for end-user training Accomplished this period ü Go/No-Go checklist completed – working to determine status and move to green ü ctc. Link Screen Reader Resource Guide created ü Hosted SBCTC staff for Go/No-Go discussion and provided list of critical needs ü Security meeting ü Training SBCTC Agency Community Colleges of Spokane *If status is yellow or red, describe why. These issues not blocking CS 9. 2 release, but impact DG 2 and future DGs • Security Roles and supporting documents not completed yet for CCS. Significant impact on our ability to pass a security audit. • New Chart of Accounts continues to significantly impact budget team and finance business office. This cutover continues to impact our normal financial business processes. 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 ü Participate in UAT ü Monitor and communicate UAT status ü Received Training info from SBCTC ü Started coordinating Training ü QA with Mora 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 Participate in UAT q Work with SMEs, Pillar Leads, TCC Leadership to get better participation in the project q Plan and execute OCM for DG 2 project q Monitor UAT status q Continue rolling out End-user Training 9 q Go/No-Go Signoff
Deployment Group 3 Timeline (High-Level Phases) G 10
Deployment Group 3 Self-Reported Status – September 2 to 13, 2019 Cascadia College G Accomplished this period ü Departments continued data error cleanup activities (2020 Q 1) ü Continued Course Catalog build in PS Production ü CS, FA, SF pillars initiated data validation cycle #3 (environment not available until 9/3/19) ü HCM & FIN pillars continued Cycle #3 Data Validation Planned for next period q Finalize Cascadia’s Testing & Training Plan q Continue internal Training Management Team planning q Continue internal Testing Management Team planning q Complete drafting Cascadia Data Governance Plan (includes Reporting & Query Management planning) q Engage with SBCTC for SIT Testing Lower Columbia College Accomplished this period ü CS, FA, SF began data validation (environment not available until 9/3) ü FIN and HCM pillars continued with data validation ü Continued course catalog build in the PS production environment ü Communications and Training leads prepared for ctc. Link presentation during Fall in-service week ü Departments continued data error cleanup activities (2020 Q 1) Pierce College District G Accomplished this period ü SMEs continued Cycle #3 data validation. ü SMEs continued quarterly data error cleanup efforts (2020 Q 1). Planned for next period q Continue work on College Communications Plan. q Plan ctc. Link activities for Fall all-college welcome back. Peninsula College G Accomplished this period ü All SMEs have been fully engaged in Validation activities ü Instruction SMEs attended catalog production workshop ü Instruction SMEs have been working in production environment validating catalog Planned for next period q Continue validation Planned, but not completed • Review applicants for project positions. • Identify/establish training space. • Work on Training Plan. • Work on Testing Plan. G Olympic College G Accomplished this period ü Continued Cycle 3 Data Validation ü Continued work on Course revisions in Production Planned for next period q Continue Cycle 3 Data Validation Planned, but not completed • Additional CIA Workshops Planned for next period q All pillars to finish cycle 3 data validation activities q Class scheduling SME’s to attend pre-workshop Web. Ex session q Deliver ctc. Link presentation/activities during fall-in service week sessions 11
Deployment Group 4 Dashboard Reports – September 2 to 13, 2019 DG 4 Initiation Phase Completion Summary College/District As of Sept. 13, 2019 Centralia College 70% Edmonds Community College 74% Highline College 64% Seattle Colleges (3) 61% Wenatchee Valley College 70% DG 4 General Timeline Draft 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 G 12
Deployment Group 5 Dashboard Reports – September 2 to 13, 2019 DG 5 Initiation Phase Completion Summary As of Sept. 13, 2019 Target Percentage for Sept. 2019 Bellevue College 19% 55% Bellingham Technical College 31% 55% Big Bend Community College 25% 55% Everett Community College 31% 55% Grays Harbor College 36% 55% Green River College 34% 55% Skagit Valley College 40% 55% Whatcom Community College 40% 55% 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 – September 2 to 13, 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 DG 2 May 10 - June 3, 2019 Complete May 28 – June 14, 2019 Online Admissions App RFI Being Developed DG 3 College Readiness Gate / Go-No Go Discussions Continuing Education Contract Finalization DG 3 Readiness Gate / Go-No Go Decision Community Colleges of Spokane • • • R Unable to close yearend 2016, 17, 18, 19: SBCTC has not posted all adjusting journals and run closing rules. Asked for SBCTC plan to export adjustments for FY 16, 17, 18 into Excel to run the closing rules for accurate opening and fund balances. Book to Bank Cash Reconciliation: SBCTC changed accounts to be used for cash posting, and changed the chartstrings on several item types to try and partially alleviate the ongoing problem, however, a total solution has not been identified. Spokane still needs reports that will assist the reconciliation process, and a complete list of Finance system processes that run with dependencies to help us troubleshoot discrepancies. $18 million-dollar cash variance: Spokane has chosen to write off the $18 million book to bank cash variance as SBCTC was unable to identify underlying problem, or provide accurate data on how the variance occurred. We are very concerned a variance will remain, because it was not completely resolved. 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. Accomplished this period q Monitored remediation items progress and communicate to local stakeholders *If status is yellow or red, describe why. • Delay of Security Roles puts CCS at risk for Security Audit. Testing and validating new security roles is a significant hit on all resources; and we are still unable to begin testing. Not able to plan for or schedule this work. • Scope for validating the security role mapping validation exercise has now grown substantially as SBCTC was not able to provide us the mapping helper guides as initially communicated. We are still waiting for scaled down mapping workbooks for each pillar. • The Co. A conversion also resulted in substantial manual work; some planned and some unplanned work. 14
Other ctc. Link Project Activities – Status as of September 13, 2019 RFP Publish Solution Decision Develop and published RFP, Work Group evaluated RFP Responses Final Decision on Vendors to be awarded Vendor contracts awarded Statement of Work completed Phase 1 Accessibility Testing has completed with exception of Mobile/Message Center and results being evaluated (Student & Employee Self-Service) 5/10/2019 • Phase 1 complete with exception of Mobile and Message Center • Phase 2 will begin in October RFP was developed and approved by Governance RFP proposals were due November 15, 2018 3 Vendors responded and subgroup is evaluating solution Governance approved procurement and decision of Vendor contract being finalized for scope and cost 10/15/2018 • Contract Draft Complete • Overall Pricing in Negotiations • 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 • Committee formed to review, finalize, approve Budgeting requirements • Budget Planning Tool Work Group meetings underway to finalize requirements and vet Oracle PBCS Solution • Oracle/Mythics building Prototype of PBCS Solution with templates from (Peninsula, Pierce, Spokane, and SBCTC) • Work Group will recommend to ctc. Link Governance if PBCS will meet requirements or if an RFP will need to be developed TBD • ctc. Link Budget Planning Requirements Approved Solution Status Accessibility • • • Continuing Education • • • Online Admissions Application Budget Planning Tool 15
- Slides: 15