1 / 31

DIVCA 2011 Video Franchise Holder Webinar

DIVCA 2011 Video Franchise Holder Webinar. Video Franchising and Broadband Deployment Team February 25, 2011. Agenda. Welcome! Data to Submit to CPUC on or before April 1, 2011 Other Reports due to CPUC on or before April 1, 2011 Broadband Subscriber data

tabitha
Download Presentation

DIVCA 2011 Video Franchise Holder Webinar

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DIVCA 2011 Video Franchise Holder Webinar Video Franchising and Broadband Deployment TeamFebruary 25, 2011

  2. Agenda • Welcome! • Data to Submit to CPUC on or before April 1, 2011 • Other Reports due to CPUC on or before April 1, 2011 • Broadband Subscriber data • BroadbandAvailability Data (same process as last Year) • Third Collection of Broadband Availability Data for NTIA’s SBDD (Mapping) Program • Video template for video annual report data • Annual Fee for Fiscal Year 2010-2011 • Website for Video Franchise & Broadband Deployment Team • Questions / Other Issues

  3. Data to Submit to CPUC by April 1, 2011 • Broadband Subscriber Data • California portion of Form 477 Data • Same data due to the FCC by March 1, 2011 used for reporting broadband subscribers by census tract, speed tiers and technologies • Broadband Availability data • We are assuming that you have already submitted the Broadband Availability Data by census tract • Video Subscriber Data by census tract • Video Availability Data by census tract

  4. Other Reports due on or before April 1, 2010 • Annual Employment Report • Workplace Diversity Report • Collective Bargaining • Free Services Provided to Community Centers • Annual Fee Due by April 30, 2011 • Fee statements are in the process of being sent out. You should receive yours soon.

  5. Broadband Data • Broadband Subscriber Data • Use the FCC’s 477 format that you use to submit data to the FCC • Details in next few slides • New process if you manually enter information into FCC website. • Broadband Availability Data • This year, broadband availability data is being collected via the State Broadband Data and Development (mapping) Program.

  6. Broadband Subscriber Data Details • If you manually enter information into the FCC’s 477 website, you can submit that data via either: • Excel Spreadsheet • Comma delimited text file. • In the past, we only accepted comma delimited text files. • If you send your 477 data to The FCC in a comma delimited text file, you can send it to us the same way.

  7. Operational Issues We had Last YearThat we’d like your Help Solving (1 of 2) • Census tract numbers • According to the FCC’s directions for submitting 477 data, census tract numbers are defined as: • A number up to 4 digits • Followed by a decimal • Followed by a number up to 2 digits. • For each census tract number you provide data about, please be sure to include a decimal point and to the right of the decimal either two numbers or two zeros. • Excel Spreadsheets - Video data • Please do NOT submit cells with formulas. • Formulas do not upload into our Oracle database. • In each cell that contains numbers created by formulas, please type in an actual number (or use an Excel function to convert the number created by a formula into an actual number).

  8. Operational Issues We had Last YearThat we’d like your Help Solving (2 of 2) • Percent Residential Connections • If you have no residential connections in a census tract, please enter zero. • Technology Code “Other” • Sixth place in comma delimited text file. • Please include commas with no data between them if you are meaning to leave that empty.

  9. Positions for data in FCC 477 Comma Delimited Text File Format (1 of 2)

  10. BB Subscribers Use FCC 477 FormatTemplate Details: Comma Delimited Text File FormatOR Spreadsheet if you enter it manually

  11. Positions for data in FCC 477 Comma Delimited Text File Format (2 of 2)

  12. Codes for FCC 477 FormatTechnology Used to Deploy Broadband

  13. Codes for FCC 477 Format Upload & Download Rates

  14. Broadband Availability Data Reporting Process Same as Last Year • Like last year, broadband availability data is being collected via the State Broadband Data and Development (mapping) Program. • To make life easier for you… Your organization will again NOT be required to report Broadband Availability data under DIVCA, if it has fully and properly submitted “third round” broadband availability data to the CPUC for the NTIA’s State Data and Development Program. • If your organization did not do that, please submit broadband availability data per the “third round” CPUC broadband mapping data request now.

  15. DIVCA VideoExcel Template for Annual Report • Video related data only in Excel Spreadsheet • Broadband data is handled separately, as we just discussed. • As a result, last year the column for broadband availability data was removed. It remains removed.

  16. DIVCA (Video Template)Important Excel Worksheets (Tabs) in Excel Workbook • State Franchise • Enter data for video service provided under state franchise • ONE franchise per State Franchise tab • Most of you have just one state franchise • Local Franchises • Enter data for video service provided under all local franchises • Telephone Service Area • Enter data for video service provided in the telephone service area.

  17. DIVCA Video Excel Template (1 of 2)

  18. Revised DIVCA Annual Report Video Excel Template (2 of 2)

  19. FCC Instructions Website • http://www.fcc.gov/Forms/Form477/477inst.pdf • http://www.fcc.gov/Forms/Form477/477screen-shots.pdf

  20. User Fees for Fiscal Year 2009-2010 • Resolution T-17305 • User Fee based on households in holders’ video service territories, rather than according to revenues, through Fiscal Year 2012-2013. • Rate set at from $0.0417 per household for FY 2010-2011, down from $0.0434 per household for FY 2009-2010 • User Fee due on April 30, 2011 for franchises issued before Resolution (2/24/11). • For franchises issued after 2/24/11, user fee due within 60 days after franchise is issued.

  21. User Fee Statements / Invoices • Statements are in the process of being prepared. • Please make checks payable to: "CPUC-VSP" • Please fill out and attach a copy of the fee statement to the check and mail to: Attn: Carmelita Reyes Fiscal Office, Room 3000 California Public Utilities Commission 505 Van Ness Avenue San Francisco, CA 94102

  22. Website for Video Franchise & Broadband Deployment Team • Shown on next several slides.

  23. From here there are two easy ways to access the Video Franchise main page: 1. Click the For Service Providers tab, then click the Video Franchising link. OR …

  24. How to access the Video Franchising website: Go to www.cpuc.ca.gov and click on the Communications tab.

  25. 2. Scroll down the page until you see theService Provider Programs and Informationsubheading, then click theVideo Franchisinglink.

  26. Video Franchising Main Page: Scroll down the page for various information pertaining to Video Franchising. Clicking on any of the four top links will put you to the bottom half of the page for quick access to Applications, Franchises, and Reporting information.

  27. Bottom half of main page: From here you can navigate to the desired document or page (i.e. Franchises Issued in 2007).

  28. Return to the Video Franchise main page by using the browser back button or clicking the Back to Video Franchise Main Page link.

  29. New Franchise Holders beginning April 2008 • You need to be on the service list to receive mailings on DIVCA matters • Email processoffice@cpuc.ca.gov, provide name, contact information, and request to be added to the service list for R 06-10-005

  30. Questions / Other IssuesThanks for Tuning Into This Webinar! • Michael Morris, Program and Project Supervisor • mmo@cpuc.ca.gov • Michael Pierce, Sr. Analyst • mbp@cpuc.ca.gov • (415) 703-2618

More Related