Kansas 911 Coordinating Council Balance Sheet 6/30/2017

Transcription

Kansas 911 Coordinating CouncilBalance Sheet6/30/2017Assets:Cash911 State Fund911 Grant FundTotal Cash 3,962,854.32 10,591,735.26 14,554,589.58Accounts Receivable 110,891.16Prepaid Expenses 108,621.28Accrued RevenuesAccrued Receivables - Telecom PaymentsAccrued Receibales - Prepaid Wireless FeesTotal Accrued Revenues 1,761,804.72141,814.301,903,619.02Total Assets 16,677,721.04LiabilitiesAccounts Payable 29,862.51Accrued ExpensesAccrued Accounts Payable - PSAP PaymentsAccrued Accounts Payable PSAP Minimum PaymentsAccrued Accounts Payable - ArrearsAccrued Accounts PayablesTotal Accrued Expenses 3,086,613.22285,000.00123,675.443,495,288.66 883,720.57Total Liabilities 4,408,871.74Fund Balance - Unrestricted 12,268,849.30Deferred RevenueEquityTotal Liabilites and Equity 16,677,721.04Printed: 8/15/2017, 8:24 AM

Kansas 911 Coordinating CouncilSummaryFor the Six Months Ending June 30, 2017CurrentPeriodCurrent PeriodBudgetCurrentYTD% ofTelecom &PrepayFeePaymentsBudgetYTDFY 17 BudgetRemainingRevenueTelecom and Prepay Fee PaymentsPSAP 911 Service PaymentsInterest IncomeTotal Revenues 1,982,609.37 170,411.46 8,350.47 0.00 0.00 0.00 11,382,458.74 837,459.64 35,758.45 0.00 0.00 0.00 2,161,371.30 0.00 12,255,676.83 0.00 0.00 0.00 0.00 0.00ExpendituresPSAP Payments and Minim1,680,375.120.009,946,763.250.00 1,680,375.12 0.00 9,946,763.25 0.00Personnel ContractsCouncil Meeting ExpensesCommittee Meeting ExpensesLCPA ContractOther Administrative ,000.0019,848.00Total Operating Expenses 30,490.04 33,682.92 790,483.40303,901.495,500,000.00398,052.00Total Contractual Costs 540,576.80 983,008.67 2,094,384.89 5,898,052.00 9,209,516.60 492,202.51 9,701,719.11Net Change in Net Assets( 90,070.66)( 1,016,691.58) 31,287.00( 6,100,149.50) 9,924,979.32Total PSAP Payments0.00 0.00Operating Expenses1.6% 304.13 223,260.21Contractual CostsAT&T Service ContractsOther Contract CostsPrinted: 8/15/2017, 8:24 AM

Kansas 911 Coordinating Council911 State FundFor the Six Months Ending June 30, 2017CurrentPeriodCurrent PeriodBudget6CurrentYTDBudgetYTDFY 17 BudgetRemainingRevenueTelecom IncomeInterest Income 1,840,795.072,153.63 0.000.00 10,482,887.399,565.66 0.000.00 0.000.00 0.00Total Revenues 1,842,948.70 0.00 10,492,453.05 0.00 1,585,375.1295,000.00 0.000.00 9,377,725.25569,038.00 0.000.00 1,680,375.12 0.00 9,946,763.25 0.00Personnel ContractsCouncil Meeting ExpensesCommittee Meeting ExpensesLCPA ContractOther Administrative Costs 0.000.000.000.00216.01 0.000.000.000.000.00 0.000.000.000.001,153.45 0.000.000.000.000.00Total Operating Expenses 216.01 0.00 1,153.45 0.00AT&T Service ContractsOther Contract Costs 0.000.00 0.000.00 0.000.00 0.000.00Total Contractual Costs 0.00 0.00 0.00 0.00 0.000.00 0.00 162,357.57 0.00 544,536.35 0.00( 1,153.45)ExpendituresPSAP PaymentsPSAP Minimum Quarterly PaymentsTotal PSAP Payments 0.000.00 0.00Operating Expenses 0.000.000.000.001,153.45 1,153.45Contractual CostsNet Change in Net AssetsPrinted: 8/15/2017, 8:24 AM

Kansas 911 Coordinating Council911 Grant FundFor the Six Months Ending June 30, 2017CurrentPeriodCurrent PeriodBudget6CurrentYTDBudgetYTDFY 17 BudgetRemainingRevenuePrepay Fee IncomePSAP 911 Service PaymentsInterest Income 141,814.30 170,411.46 6,196.84 0.000.000.00 899,571.35837,459.6426,192.79 0.000.000.00 0.000.000.00 318,422.60 0.00 1,763,223.78 0.00 0.00PSAP Payments 0.00 0.00 0.00 0.00 0.00Total PSAP Payments 0.00 0.00 0.00 0.00 0.00Personnel ContractsCouncil Meeting ExpensesCommittee Meeting ExpensesLCPA ContractOther Administrative Costs 15,562.180.00713.9610,416.673,581.22 18,941.58533.33400.0010,500.003,308.00 93,587.652,498.569,956.6962,500.0213,545.32 113,649.50 3,200.00 2,400.00 63,000.00 19,848.00Total Operating Expenses 30,274.03 33,682.92 182,088.24 202,097.50 133,711.353,901.44(5,156.69)63,499.9826,150.68 222,106.76 500,521.2940,055.51 916,666.6766,342.00 1,790,483.40303,901.49 5,500,000.00 398,052.00 540,576.80 983,008.67 2,094,384.89 5,898,052.00 9,209,516.60492,202.51 9,701,719.11( 252,428.23)( 1,016,691.58)( 513,249.35)( 6,100,149.50) 9,923,825.87Total RevenuesExpendituresOperating ExpensesContractual CostsAT&T Service ContractsOther Contract CostsTotal Contractual CostsNet Change in Net AssetsPrinted: 8/15/2017, 8:24 AM

Kansas 911 Coordinating CouncilBank ActivityJune 30, 30/2017Balance911 State Fund 3,647,377.33 1,797,062.76 1,481,585.77 3,962,854.32911 Grant Fund 10,858,522.61 627,305.94 10,591,924.65Total 14,505,899.94 2,157,770.74 2,108,891.71 14,554,778.97360,707.98Printed: 8/15/2017, 8:36 AM

Kansas 9‐1‐1 Coordinating CouncilMeeting Friday, August 18, 2017Agenda New Council Member OrientationCall to Order, Roll Call (Chief Heitschmidt)Voting Members (17)Non‐Voting Members (9)SupportMike Albers, Govt ITRep. John Alcala, House (Minority)Troy Briggs, Kansas Sheriff AssociationRobert Cooper, Deaf Hard HearingKathy Kuenstler, PSAP Any SizeSen. Marci Francisco, Senate (Pres.)Dick Heitschmidt, Chair, Law Enforce’Rep. Kyle Hoffman, House (Speaker)Michael Leiker, Govt ITSherry Massey, PSAPs less 75k (pend)Kerry McCue, Kansas EMS BoardRobert McLemore, Fire ChiefJosh Michaelis, PSAPs less 75kMelanie Mills‐Bergers PSAPs over 75kChris Stratmann, Vice‐chair, AGEllen Wernicke, PSAPs over 75kTBD, Senate (Minority)Jay Coverdale, Kansas OITSDavid Cowan, LKMJerry Daniels, KACLarry Dexter, VoIP ProviderJohn Fox, LEC over 50k linesAdam Geffert, MARCRusty Griffin, Large WirelessKen Nelson, GIOTBD, Rural Independent’ TelcosMichele Abbott, OperationsLori Alexander, LiaisonEileen Battles, GISToyia Bulla, NSIDebbie Edwards, CybersecurityScott Ekberg, AdministratorJason Loewen, securityPhill Ryan, ITSSGayle Schwarzrock, NSIRandall White, PM Motion to accept Minutes for meeting February 3, 2017 (Chief Heitschmidt) M / S /P Motion to accept Minutes for special call March 21, 2017 (Chief Heitschmidt) M / S /P Motion to accept Minutes for special call July 25, 2017 (Chief Heitschmidt) M / S /P LCPA (Local Collection Point Administrator) Report (Toyia Bulla)o LCPA Audit for 2017 update Chairman’s Report (Chief Heitschmidt)o FirstNet decision of Governoro Council vacancies and appointmentso Staffing Resource Management Update1

Executive Committee Report (Col. Chris Stratmann)o Office of Attorney General legal support House Bill 2409 became effective on 1 July 2017: certification that theindividual/company is not engaged in a boycott of Israel.o General relationship of 911‐related programs Operations Committee Report (Michele Abbott)o What we learned at APCO International, Denver; NASNA/NENA, San Antonioo New Council website furnished by NSI now liveo Fall Admin Day, Sept 13, 2017, Salina, Kansaso Expenditure Report Updateo PSAP Distribution of 911 Subscriber Fees Reporto Workplan updateo Text‐to‐911 Subcommittee Reporto Training Subcommittee Report Technical Committee Report (Jay Coverdale)o Annual NG911 All‐team Workshop, June 15, Topekao Program Statuso Kansas NG911 Security Plan / Policieso Incident Management (IcM) (day‐2 support) GIS Committee Report (Ken Nelson)o GIS Data Maintenance statuso Geospatial Call Routing statuso Orthoimagery Updateo NG911 GIS User Group reporto Cross‐border updateo Portal Update NG911 Administrator Report (Scott Ekberg)o Status of our Hosted Solutiono NG911 AT&T nationwide ESInet (Emergency Services IP network)o Legacy website provider CivicPlus contract NG911 Liaison Report (Lori alexander)o PSAP Relationso 911 Knowledge Center updateo Vesta Map User Group reporto New Council website furnished by NSI now live http://www.kansas911.org/ New Business Next Meeting, October 9, 2017, Newton, KS2

Abbreviations, Acronyms, DefinitionsAFUAGALIANIANSIAPCOAT&TAVPNBDABUSCall HandlingEquipmentCAMA urityDBDDSDHSECaTSECRFESInetESNESRPFCAApproved for Use term used by AT&TAttorney GeneralAutomatic Location Identification (ALI) is a service whereby a PSAP call taker isautomatically given the emergency 9‐1‐1 caller’s address. This service uses a tabularDB that is associated with CAMA trunks that are provided by the PSAP’s LEC carrier.Automatic Number Identification (ANI) is a service whereby a PSAP call taker isautomatically given the emergency 911 caller’s telephone number; uses a tabulardatabase that is associated with CAMA trunks that are provided by the PSAP’s LECcarrier.American National Standards InstituteAssociation of Public‐Safety Communications OfficialsAmerican Telephone and TelegraphAT&T Virtual Private NetworkBi‐Directional Amplifier used to boost wireless signal strength into NG911 systemBack‐Up Site such as Yoder CenterIs special equipment that allows PSAP call takers to accept, manage and, if necessary,transfer emergency 9‐1‐1 calls. Typically, this equipment is computer based and usesone or more monitors to facilitate the handling of emergency calls.Centralized Automatic Message Accounting (CAMA) is actually a call log that is basedon the traditional telephone line (“trunk” or “circuit”) from the LEC to the PSAP.DatabaseCode Division Multiple Access for example CDMA networksCritical Design ReviewChange Management; Configuration ManagementChange Order RequestCustomer Premise Equipment is equipment that the Council’s provider AT&Tfurnishes at PSAP in order to provide the hosted call handling service of NG911;typically, this is a small router or switch similar to that provided in homes for cable TVservice.Cyber Threat Information ProgramRefers to the facility where the PSAP operates. Customer premises are specified indocuments such as the SOR and Site Survey.Unauthorized use of a protected network system and measures to counterDataBaseData Distribution Services server term used by AirbusDepartment of Homeland SecurityEmergency Call Tracking System universal 911 Call Reporting System provides real‐time reporting analytics; ECaTS911 is a product of Direct TechnologyEmergency Call Routing FunctionEmergency Services IP NetworkEmergency Service NumberEmergency Services Routing ProxyFirst Company Application term used by AT&T3

ureIPRIP al Communications CommissionFinal Design ReviewFirst Responder Network AuthorityGeneral Availability term used by AT&TAllows more accurate routing of emergency 911 calls than traditional E9‐1‐1. Relies ona GIS database to identify the location of the emergency 9‐1‐1 caller on a map using X‐Y coordinates rather than current MSAG, ALI and ANI tabular databases. Variouslayers of information can be added to the map to provide call taker with enhancedinformation relative to location to improve emergency response and routing of call.Usual legacy ANI/ALI/ESN tables or caller geospatial routing database (latitude,longitude), geo‐spatial routing ensures that E9‐1‐1 calls are routed to the correct PSAPfor emergency response regardless of the network used by the caller.A Geographic Information System (GIS) is a system that correlates an emergency 9‐1‐1callers location to a map database in order for the PSAP call taker to route and directemergency responders accurately and quickly to the location of the emergency.Global Network Operations Center AT&T, Bedminster, NJThe methodology whereby the major stakeholders of NG911 are monitored based onpre‐determined policies.Hazardous MaterialsHot Fix term used by Airbus for a last‐minute fix to a release for example "R6.0 HF2"Hot Fix 2 for Airbus release R6.0NENA standards‐based NG9‐1‐1 solution standards offering not only voice traffic butalso text, IM, streaming video, photo, telematics, and other non‐voice media usingESRP and ECRF.Incident Management “Day‐2 Support Model and Plan”; monitors open‐closed troubletickets.Invitation for Bid; same as RFPIntegrated Logistic Support. An ILS Plan is a 360‐degree look at logistic support. Itconsiders such things as spares, spares location, Day‐2 support of Resolution Center.Instant MessagingIP Multimedia SubsystemThe hardware and software necessary for providing the Kansas NG911 Solution as aService; includes networking, data centers, call handling and reporting, operationalsupport.Intellectual Property RightsEnd‐to‐end ESInet selective routing interaction is the ESInet solution leading to fullNG9‐1‐1 functionality i3 architectural end state.Information Security Management SystemKansas Association of Chiefs of PoliceKansas Association of MappersKansas Department of Health and EnvironmentKansas Highway PatrolKansas Law Enforcement Training CenterKansas UniversityLocal Collection Point Administrator4

LCPALECLTELTELVFMARCMDSMOAMOPMRSMSAGNAS PSDCQoSLocal Collection Point AdministratorLocal Exchange Carrier (LEC) refers to the telephone company (“carrier”) for a locality.Examples are AT&T, CenturyLink, Pioneer Communication, and many others in Kansas.Long‐Term Evolution for example LTE networkLong Term Evolution cellular networkLocation Validation FunctionMid‐America Regional Council, KC, MOMedia Distribution Services server term used by AirbusThis document is the Memorandum of Agreement (MOA). It forms the relationshipand participation between the PSAP jurisdiction and the Council for the acquisitionand support of NG911 hosted call handling services from the Council’s provider AT&T.Method of ProcedureManaged Router Service term used by AT&TThe Master Street Address Guide (MSAG) is a tabular databaseNetwork‐Attached Storage (NAS) is a GIS data storage server (black box) connected tothe NG911 network at the host and PSAP level.National Association of State 911 AdministratorsNebraska, Missouri, Oklahoma, Colorado.National Emergency Number AssociationNext Generation 9‐1‐1 (NG911) is a national initiative for updating our outdated 9‐1‐1call handling service with special emphasis on increased dependency of our society onwireless (cellular) communication rather than traditional wireline telephone.National Initiative for Cybersecurity EducationNational Institute of Standards and TechnologyNational Public Safety BB NetworkNational Telecommunications and Information AdministrationQuality of Experience – pixelated videoPreliminary Design ReviewName of a patented aerial image capture process that produces imagery showing thefronts and sides of buildings and locations on the ground. Can then be stitchedtogether to create composite aerial maps that seamlessly span miles of terrain.Presence Information Data Format for Location Objects. In the i3 environment, PIDF‐LO is the replacement for ALI data, providing expanded location information.Project Management; Program ManagementPosition PaperPublic Service AnnouncementThe Public Safety Answering Point (PSAP) is a local center where emergency 9‐1‐1calls are routed. Typically, PSAPs are located at a county level such as a county sheriff.They are also located at a local level such as a police department.Public Safety Dispatch Center; non‐traditional PSAP such as higher education, military,Native American, Highway Patrol Public Safety Dispatch CenterQuality of Service ‐ voice #15

RAIDRFIRFPRFQRTTSISIFSLMSSMSSMS TextingSPOCTCCTCSTEESVehicleTelematicsRedundant Array of Independent DisksRequest for InformationRequest for ProposalRequest for QuoteReal‐Time Texting appearance as typingSpatial Interface (replacing SIF)Spatial Information Function (replaced by SI)Software, Learning Management ServiceShort Message Service for text messagingShort Message Service allows wireless subscribers to send 911 SMS text messages toPSAPs and for subscribers to receive text replies from PSAPsSingle Point of ContactText Control CenterTeleCommunication Systems Text‐to‐911 technology, Comtech TelecommunicationsTest and Evaluation Equipment Suite for BUSThe computer system in a vehicle that collect and store critical information that canbe used to determine events leading to a crash.6

NG9-1-1 Program Management StatusPrepared byPrepared forDateJay Coverdale, Technical Committee ChairNG9-1-1 Coordinating CouncilAugust 14, 2017Status and AccomplishmentsNext Steps1.5 Local Collection Point Administrator (LCPA) – on scheduleBudget thru 2017 130,709.00Actual To Date 75,855.69 Council financials and meeting minutes Review and true-up of financial audits New website with significant enhancements Change OrderToyia Bulla, Non-profit Solutions Inc. (NSI)Contract PoP: Jan 1, 2017 thru Dec 31, 2018 with 2-yr option Contacting telco carriers (fees) and PSAPs (funding) Council services; Council meeting logistics registration for Fall APCO, Oct 9-11, Newton, KS2.1 DASC Support – on scheduleBudget thru 2017 522,170.00Actual to Date 360,320.00 GIS data maintenance and training GIS User Group and Vesta Locate User Group Portal enhancementsKen Nelson, Kansas Center for Research (KUCR)Contract PoP: Mar 25, 2015 to Dec 31, 2017 Oklahoma GIS Cross-border Collaboration GIS Data Maintenance Orthoimagery contract and cost share2.6 Dickinson County Support – on scheduleBudget thru 2017 80,087.75Actual to Date 79,935.54 County GIS data maintenance submittal GIS Cross-border CollaborationSherry Massey, GIS DirectorContract PoP: Jan 1, 2017 thru Dec 31, 2019 Geospatial call routing development for NG911 GIS Data Model and Maintenance Training3.1 Program Management – on scheduleBudget thru 2017 739,083.05 Actual to Date 647,819.59 Strategic Planning Communication Planning Implementation to Operations TransitionRandall White Consulting LLCContract PoP: Apr 7, 2014 to Dec 31, 2017 with 1-year option Manage Project Plans, Deliverable, Documentation Manage Project Schedule and Cost Transition from Hosted Solution to ESInet3.4 Infrastructure – Call Handling delaysBudget thru 2017 12,172,819. Actual to Date 8,467,113. 66 out of 117 PSAPs on NG911 plus Yoder Test/Backup Site Day-2 support Trouble Ticket Status: 1 open, low priority Infrastructure Cybersecurity expectationsAT&T (Airbus and ECaTS subcontractors)Contract PoP: Feb 5, 2015 to Dec 31, 2018 with 6-year option SMS Texting delays; R6.1HF4 test Yoder Target 76 (not 82) total PSAPs on NG911 by Dec 31, 2017 Hosted Solution migration to ESInet delays for R7.23.5 Implement’ Tech. Support Specialist - on scheduleBudget thru 2017 592,403.29 Actual To Date 481,087.00 85 out of 117 Service Order Requests (with Scott) PSAP consults, tech support, resolution, training Pre-Call-Flow readiness (Sedgwick, Shawnee)Phillip Ryan, Pryan LLC (Phill Ryan)Contract PoP: July 20, 2015 to Dec 31, 2017 with 1-year option Call Handling upgrade mini-plans & release notes SMS Texting MSAG-TN resolution; National ESInet AT&T transition4.3 Kansas 911 Knowledge Center go-live delayedBudget thru 2017 14,700.00Actual to Date 15,445.1 Fully operationalFirstNet Learning Inc. (Lori Alexander, Liaison)Contract PoP: Sep 15, 2016 to Dec 31, 2019 with 5-year option Expanding use and application(s)NOTE: Projects that are complete and contracts that are closed are no longer shown in this PM Status Report.Field Legend: green on plan, yellow caution/concerns, red alert status, grey inactive/closed

Kansas NG9‐1‐1Special Session Council Meeting MinutesTuesday, July 25, 20171 Call To OrderChairman Heitschmidt called the Kansas 911 Coordinating Council (“Council”) meeting to order at 11:02a.m.2 Roll CallCouncil Members in AttendanceMike Albers, Robert Cooper, Jay Coverdale, David Cowan, Chief Dick Heitschmidt, Kathy Kuenstler, MikeLeiker, Kerry McCue, Chief Robert McLemore, Josh Michaelis, Ken Nelson, Colonel Chris Stratmann.Council Members AbsentRep. John Alcala, Sheriff Troy Briggs, Jerry Daniels,

Aug 18, 2017 · Prepaid Expenses 108,621.28 Accrued Revenues Accrued Receivables - Telecom Payments 1,761,804.72 Accrued Receibales - Prepaid Wireless Fees 141,814.30 Total Accrued Revenues 1,903,619.02 Tota