Attachment_D_-_Process_Flows-As_Is.pptx

PPTX presentation 96 KB Posted

Attached to
CPUC RFI 24ITC0680 - Communications Data Portal (CDP)
Solicitation number
0000034655
Issued by
California

About this file

This document is a PowerPoint presentation detailing the current ("As-Is") process flows for the California Public Utilities Commission (CPUC) and related agencies, focusing on various regulatory and administrative workflows. The presentation outlines process details for multiple subprograms including Network Resiliency Plans, Service Quality Reports, ETC Biennial Reports, Eligibility Tracking, TSQ-MSI Portal Operations, Tariff Creation and Violations, and Provider Outage Management. The workflows encompass key steps such as data submission, validation, grace period management, protest processes, reporting, site visits, and regulatory compliance tracking.

The current system demonstrates mostly manual processes with limited automation, including manual data validation, report submissions, tariff searches, and extensive human intervention across workflows. The presentation highlights significant gaps in the existing system, such as rudimentary data analysis, lack of multi-dataset correlation, and minimal automated validation. The proposed changes suggest moving towards a more automated, zero-touch approach with enhanced data validation, Tableau dashboard visualizations, automated reporting, and improved integration between different regulatory tracking mechanisms. The process flows also detail specific steps for managing protests, supplemental filings, notifications, and inter-agency communications across various regulatory domains.

View the file

Other files

File Type Posted
Attachment_C_-_Respondent_Questionaire.docx DOCX document
Attachment_B-_Solution_Cost_Estimate.xlsx XLSX spreadsheet
RFI_24ITC0680_-_Communications_Data_Portal.pdf PDF
Attachment_F_-_Requirements.xlsx XLSX spreadsheet
Attachment_A-_Letter_of_Interest.docx DOCX document
Attachment_E_-_Process_Flows-To_Be.pptx PPTX presentation

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

CDP As-Is Processes V6 – 2024-08-05

Contents Changes from To-Be Key Steps Grace Period Workflow A sub-workflow that is common across many of the main workflows.

Subprograms Network Resiliency Plans Service Quality Reports ETC Biennial Reports and Eligibility TSQ-MSI Portal Tariff Creation and Violations OES Provider Outages Site Visits

Changes from To-Be

To-BeAs-Is
CDP DBTracking sheet and legacy DB
Mostly zero touch w/ full automationRudimentary analysis and No correlation w/ multiple dataset
Auto-validate submissionsManually validate
Single and Bulk Upload/ Download Reports, Plans, and Raw DataManually receive or submit reports, Plans, and Raw Data
Submission review InterfaceNone
Tableau Dashboard visualizationsNone
Tariff search engineManually search tariff rules
Automate ReportsManual Reports

Key Steps These steps are identified by yellow circles in the process flows. Each requirement in the requirement listing also has a step ID.

File and form completions File and form submissions and control Grace Period Starts CPUC data validation and entry Grace Period Workflow Protest Management Supplemental filings and refilings Integrations Data Analysis Report Generation Site Visit Scheduling Notifications and Alerts

Grace Period Workflow Yes

Problem No Request Correction No

Resolvable

Disposition Period < 30 days Yes

Protest Period < 20 days Yes Yes No Reject

Analysis Complete Yes Suspend No Approve Refile

CD

Analyst

Protest Protest Request

Outcome Pass Fail Carrier

Subprograms

CD

Analyst Engineer Network Resiliency Plans Complete RP template Complete EO Plan template Email Resiliency Plan Email EO Plan

Approve Data Analysis

PAL

Tracking Sheet Confidential Report Provide RP template Grace & Protest Period Starts Grace Period Workflow Manually Validate Data Provide supplemental filing Protest Process

Manage Protest

Advocacy Groups Public Report

Refile/ Reject Protest Approve

Analyst Service Quality Reports Email Quarterly SQ Report Submit SQ Raw Data

Data Analysis (Review Monthly) Corrective Action Plan

OOS/CTT Validation

Problem No Yes

PAL

Tracking Sheet

Confidential Report Grace Period Workflow Manually Validate Data Grace & Protest Period Starts Provide supplemental filing

Protest Process

Manage Protest

Repeated >= 2 Months Advocacy Groups Public Report

Refile/ Reject

Analyst ETC Biennial Reports & Eligibility - AL Submit AL

UCS

Create Biennial SQ Plan AL UCS Check Filing History Service DB Crime History

PAL

Crime History Update PAL

Tracking Sheet Confidential Report Grace Period Workflow Manually Validate Data Grace & Protest Period Starts Submit AL Create Annual Report Provide supplemental filing Protest Process Manage Protest

Advocacy Groups

Refile/ Reject

MSI

CD

Analyst TSQ-MSI Portal Initial Notification Data Analysis Initial Report Final Report

Withdraw Yes Withdraw Report Identify Inspection Candidate Conduct Site Visit Submit Site visit Report

DIRS

Activated

NORS/DIRS

System Suspend Reporting FCC Reporting Alignment Yes No DIRS/NORS Determination

TSQ Portal Confidential Report

Analyst Tariff Creation and Violations Carrier Cal OES Submit Tariffs and URL link Manually Research Tariffs

Tariff Repository

Confidential Report Violate Tariff rules?

Grace & Protest Period Starts Grace Period Workflow Protest Process Manage Protest

Refile/ Reject

Analyst OES Provider Outages Review OES Provider Outage Updates Cal-OES ORS System Cal OES Carrier Outage Event

Engineer Site Visits Schedule Site Visit Carrier Conduct Site Visit Complete Post Site Visit Collaboration Report Send Report Receive Report Send Checklist & Schedule Receive Checklist and Schedule Conduct Follow-up Analysis image1.png image2.svg

File details come from the government source that posted it. Updated .