47ADF7AD-983F-9719-2E5C720D20F03E5A.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
Site Security Cameras, LiDAR & Management System
Solicitation number
2025-62-21
Issued by
Franklin County, Ohio

About this file

This file is a MetLife Group Benefits policy data sheet for the Franklin County Board of Commissioners, documenting active injury and illness insurance policies. The spreadsheet contains 56 individual group benefit policies issued through MetLife's "All MetLife" channel to the Franklin County Board of Commissioners (Customer Number 157775). All policies are classified as new policies with active status, featuring the MetLife Filing plan for injury and illness coverage. Policy active dates range from December 1, 2024, through May 17, 2025, with corresponding end dates extending one year from activation. Monthly payment frequency is the standard arrangement for most policies, with select policies designated for annual payment. Payment methods include credit card, debit card, and check (ACH) options.

Selling prices for individual policies range from $235.90 to $1,977.12 monthly, reflecting varying coverage levels and participant populations. Deductible amounts vary across the portfolio, with most policies featuring $5,000 deductibles, while others carry $2,000, $7,000, $10,000, or $12,000 deductibles. All policies maintain active status with no lapses or cancellations noted. The policies collectively represent ongoing group benefits enrollment for Franklin County Board of Commissioners employees, with staggered activation dates suggesting rolling enrollment periods throughout the contract year. This arrangement provides continuous, comprehensive injury and illness coverage for county personnel with flexible payment options tailored to organizational preferences.

View the file

Other files

File Type Posted
B130D82C-B69F-E211-5C113B664A13BDA1.pdf PDF
4ADB9154-92D0-FA39-8C51818579A9E699.pdf PDF
E99102BF-B146-146D-35DFAF9763C1170B.pdf PDF
5FEA932D-A443-F834-C369AEC7AD13A552.pdf PDF
D1C75C4E-ACBE-A700-94A3260C246A50BF.pdf PDF
1FF7D8D0-C608-E689-8D121B0F5CC22DA9.pdf PDF
9D5C4E27-A2A7-EBA2-2714B42F829186DC.pdf PDF
4ADBF0DE-FA15-F6CB-0B2B1FFF2D166DEF.pdf PDF
B867E43E-FCA2-ABC6-686473D3D551080B.docx DOCX document
600B382B-92C2-EE01-36E3171A1CE23381.pdf PDF
4ADC6B3E-009D-638E-F9834A3736C61F00.xlsx XLSX spreadsheet
4ADBDA30-A10A-65AC-2585EBF3396EC49F.pdf PDF
FAFB33F1-A49E-7354-6799AC07E5D29DA0.pdf PDF
48C544C3-FCC4-F4ED-99FB5E91E5744B30.pdf PDF
44F2E64B-E391-5EAC-DD33927813E7BE98.xlsx XLSX spreadsheet
F388F0B8-095B-81FD-4AB0A90CB30AE31F.pdf PDF
98C3F6F7-A2E4-2584-EE8EB79AF1AA8052.xlsx XLSX spreadsheet
260F9701-94BA-EFEA-FCAED968AC730EE0.docx DOCX document
ED338BF8-FCF8-7E6B-4327CDB3236D9A0A.pdf PDF
A3F924CA-A2E1-A38A-2E6F296BD4EAE5D4.pdf PDF
47647B12-EF69-CBAE-3877E615229CE346.pdf PDF
44F2A935-093F-1234-3F0F06EFB73CE154.xlsx XLSX spreadsheet
45745F40-E0BA-1577-1AE1A9CC2179CA13.pdf PDF
455CC78D-B78A-EC66-F7D6D71B8AF36042.pdf PDF
47A09361-9A16-2F9F-03970F0DC73EAB8D.pdf PDF
1FF6D412-D5CF-E3DA-42373990EB63A4DE.docx DOCX document
E9905CF7-C973-40FC-678D5FD85143E735.pdf PDF
477EEBB5-9B64-4073-39F4D92B43E61BB0.pdf PDF
BCDA75E7-EC2E-694E-CB30EC7B8D89F683.pdf PDF
8BE169B1-0EA5-67F3-FE8D32CD74B2BC3C.pdf PDF
D19B3093-A699-8107-EE175100DAB2A969.pdf PDF
4ADC244E-B24C-BEC2-4654E43F7ACFB8A4.xlsx XLSX spreadsheet
1FF79148-03D3-7B1B-77CF64FD687ECA4C.pdf PDF
A4692B9C-E659-F33F-532C87A025A11AC2.pdf PDF
9EDCD8B0-B36E-8610-B9A1060DE4F7BDD1.pdf PDF
E920A267-FB29-7597-A525F8234B855C09.pdf PDF
52DB9448-0DA4-58EC-7CC559390BFA917E.pdf PDF
451DAC14-D169-2A9F-1266443CD504A357.xlsx XLSX spreadsheet
36771012-968A-47BA-49FB1CC4DFFFEC63.pdf PDF
48C71F36-F14E-8501-2A85945F358C6068.xlsx XLSX spreadsheet
600AF88E-C800-4399-20BE9FDE4A50714B.docx DOCX document
3CA5BBE9-A618-9D6F-45A1FE1B6F58F0BF.pdf PDF
48FFA356-A619-FDBE-4B4D833D8E7B2589.pdf PDF
8BE999EA-C1F3-6CAA-1ED2B57E621612FB.pdf PDF
8CFF3838-EA7E-33CD-42D86D9937F5AFDB.pdf PDF
1FF7B35A-B067-E38B-5984FBC2B840ECE1.pdf PDF
8B0111A9-AB26-EF6C-1377B5BEC77C1480.pdf PDF
39A8A9E3-F569-C6B6-B9E7BF50CFDC4F51.pdf PDF
47A070EA-AA3B-485A-6C240303241C99D2.pdf PDF
48FFE6B8-C249-DC8C-BA6A621BAD5FF49F.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 149 listed here. See the rest on GovTribe.

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

Sheet1

Policy IdPolicy NumberChannelSubchannelRetailerGroup NameCDF Customer NumberNew Revised RenewalSelling PriceCurrent StatusPolicy Status as of End DateActive DateEnd DateFilingPlan NamePayment MethodUnderwriterPayment Frequency
29367661762718-01Group BenefitsAllMetLife Group to RetailFranklin County Board of Commissioners157775New$1,209.00ActiveActive12/1/2411/30/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29381081763301-01Group BenefitsAllMetLife Group to RetailFranklin County Board of Commissioners157775New$792.84ActiveActive12/1/2411/30/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29406141764499-01Group BenefitsAllMetLife Group to RetailFranklin County Board of Commissioners157775New$311.04ActiveActive12/3/2412/2/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29418641764995-01Group BenefitsAllMetLife Group to RetailFranklin County Board of Commissioners157775New$470.04ActiveActive12/4/2412/3/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29419531765073-01Group BenefitsAllMetLife Group to RetailFranklin County Board of Commissioners157775New$1,977.12ActiveActive12/4/2412/3/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29427311765742-01Group BenefitsAllMetLife Group to RetailFranklin County Board of Commissioners157775New$337.80ActiveActive12/4/2412/3/25MetLife FilingInjury & Illness $2000Debit CardMetLifemonthly
29453271766758-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$787.92ActiveActive12/13/2412/12/25MetLife FilingInjury & Illness $5000Debit CardMetLifemonthly
29514011769746-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$650.04ActiveActive12/10/2412/9/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29676871775463-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$701.16ActiveActive12/20/2412/19/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29683771776059-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,182.60ActiveActive12/20/2412/19/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29833951781823-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$433.68ActiveActive12/31/2412/30/25MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29906721785154-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$685.20ActiveActive1/5/251/4/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
29947421787113-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$741.36ActiveActive1/8/251/7/26MetLife FilingInjury & Illness $10000Credit CardMetLifemonthly
30042841791158-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$770.52ActiveActive1/14/251/13/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
30200201797674-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$653.16ActiveActive1/24/251/23/26MetLife FilingInjury & Illness $5000Check(ACH)MetLifemonthly
30200331797686-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$631.44ActiveActive1/24/251/23/26MetLife FilingInjury & Illness $5000Check(ACH)MetLifemonthly
30260301800009-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$318.12ActiveActive1/27/251/26/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
30446881809190-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$729.96ActiveActive2/9/252/8/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
30599071815119-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$647.76ActiveActive2/18/252/17/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
30616011816090-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,341.60ActiveActive2/19/252/18/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
30630021816751-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,201.44ActiveActive2/20/252/19/26MetLife FilingInjury & Illness $5000Check(ACH)MetLifemonthly
30668321818967-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$243.96ActiveActive2/22/252/21/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
30975941832988-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$393.96ActiveActive3/15/253/14/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31043871835557-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$814.68ActiveActive3/19/253/18/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31043891835558-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$571.08ActiveActive3/19/253/18/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31044161835582-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,308.24ActiveActive3/19/253/18/26MetLife FilingInjury & Illness $10000Credit CardMetLifemonthly
31046561835784-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$357.89ActiveActive3/19/253/18/26MetLife FilingInjury & Illness $5000Credit CardMetLifeannually
31047881835892-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,347.48ActiveActive3/19/253/18/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31090011837983-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$692.76ActiveActive3/22/253/21/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31099931838374-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$280.61ActiveActive3/23/253/22/26MetLife FilingInjury & Illness $5000Credit CardMetLifeannually
31181621841890-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$641.15ActiveActive3/28/253/27/26MetLife FilingInjury & Illness $10000Credit CardMetLifeannually
31181681841896-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$650.87ActiveActive3/28/253/27/26MetLife FilingInjury & Illness $10000Credit CardMetLifeannually
31222231843831-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$559.32ActiveActive3/31/253/30/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
31247621845044-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$765.48ActiveActive4/2/254/1/26MetLife FilingInjury & Illness $12000Credit CardMetLifemonthly
31276211846400-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$632.52ActiveActive4/4/254/3/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31356811850410-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$361.68ActiveActive4/10/254/9/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31429941853256-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$916.68ActiveActive4/15/254/14/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31492481855265-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$518.17ActiveActive4/18/254/17/26MetLife FilingInjury & Illness $5000Credit CardMetLifeannually
31495321855514-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,287.22ActiveActive4/18/254/17/26MetLife FilingInjury & Illness $5000Credit CardMetLifeannually
31506281855888-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$510.00ActiveActive4/19/254/18/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
31512871856464-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$241.80ActiveActive4/20/254/19/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
31691911864053-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$489.24ActiveActive5/2/255/1/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
31710261865042-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$868.92ActiveActive5/3/255/2/26MetLife FilingInjury & Illness $7000Credit CardMetLifemonthly
31778321868242-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$538.80ActiveActive5/8/255/7/26MetLife FilingInjury & Illness $5000Credit CardMetLifeannually
31847721870836-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$415.80ActiveActive5/13/255/12/26MetLife FilingInjury & Illness $2000Credit CardMetLifemonthly
31847751870839-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$1,557.24ActiveActive5/13/255/12/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31866601871851-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$369.36ActiveActive5/14/255/13/26MetLife FilingInjury & Illness $5000Credit CardMetLifemonthly
31928861873995-01Group BenefitsAllMetLife Customer 10Franklin County Board of Commissioners157775New$235.90ActiveActive5/17/255/16/26MetLife FilingInjury & Illness $5000Credit CardMetLifeannually

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