Attachment 5 - Technical Exhibit OCC Life Claims.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
OCC Group Life Insurance (OGLI) Services (RFP)
Solicitation number
2031JW26R00001
Issued by

About this file

This file is an Excel spreadsheet (Attachment 5) containing detailed claims census data for the Office of the Comptroller of the Currency (OCC) Group Life Insurance (OGLI) program from 2020 to 2025. The document provides a comprehensive breakdown of claims by type, including Basic Life (Active, OCC Retiree, OTS Retiree), Optional Life, Dependent Life, and Accidental Death & Dismemberment (AD&D), with total claim amounts ranging from approximately $27,500 to $2,565,163 across different years and categories.

The claims data includes granular details such as date incurred, date paid, and specific claim amounts, with individual claims ranging from as low as $2,250 to as high as $711,000. The data covers multiple claim types for active employees, retirees, and dependents, demonstrating the breadth of the group life insurance coverage. This attachment is part of the solicitation (2031JW26R00001) for OCC Group Life Insurance Services, which seeks a contractor to underwrite and administer a group life insurance program for OCC and Office of Financial Research (OFR) employees and their eligible dependents, with a potential 5-year contract period ending December 31, 2030.

View the file

Other files

File Type Posted
Attachment 5 - Technical Exhibit OCC Life Claims-Supplement-R.xlsx XLSX spreadsheet
SF 30_2031JW26R00001 A00003_Revised Attachment 5.pdf PDF
SF 30_2031JW26R00001 A00002_Revised Attachment 3.pdf PDF
Attachment 3 - Technical Exhibit Retiree Census Data-Supplement-R.xlsx XLSX spreadsheet
Attachment 3 - Technical Exhibit Retiree Census Data-Supplement.xlsx XLSX spreadsheet
Attachment 13 - QandA Worksheet-GOVT.xlsx XLSX spreadsheet
Attachment 1B - OGLI Design Plan_Schedule of Benefits.pdf PDF
SF 30_2031JW26R00001 A00001_Q-A Worksheet and Attachments.pdf PDF
Attachment 5 - Technical Exhibit OCC Life Claims-Supplement.xlsx XLSX spreadsheet
Attachment 1C - OCC-OFR GLI Memorandum of Understanding.pdf PDF
Attachment 6 - Technical Exhibit OFR Census-Supplement.xlsx XLSX spreadsheet
Attachment 2 -Technical Exhibit Active Employee Census Data-Supplement.xlsx XLSX spreadsheet
Attachment 6 - Technical Exhibit OFR Census.xlsx XLSX spreadsheet
Attachment 13 - QandA Worksheet.xlsx XLSX spreadsheet
Attachment 4 - Technical Exhibt Affidavit of Domestic Partnership.pdf PDF
Attachment 1 - Price Proposal Template.xlsx XLSX spreadsheet
Attachment 3 - Technical Exhibit Retiree Census Data.xlsx XLSX spreadsheet
Attachment 9 - Security Compliance Requirements Questionnaire.docx DOCX document
SF 33_2031JW26R00001_RFP OGLI_FAR 15.pdf PDF
Attachment 8 - Past Performance Questionnaire.docx DOCX document
Attachment 7 - Technical Capability Questionnire.pdf PDF
Attachment 2 -Technical Exhibit Active Employee Census Data.xlsx XLSX spreadsheet
Attachment 1A - OGLI Pricing Structure Template.docx DOCX document
Show all 23

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

Total Claims

ATTACHMENT 5 OGLI CLAIMS CENSUS DATA FOR 2020 - 2025
Total Claim by Year
2020Basic Life Actives$ 788,000
2020Basic Life - OCC Retiree$ 456,250
2020Basic Life - OTS Retiree$ 1,743,937
2020Dependent Life Family$ 27,500
2020Dependent Life Spouse-OCC$ 213,000
2020Dependent Life Spouse - OTS Retiree$ -
2020Optional Life EE$ 1,100,000
2021Basic Life Actives$ 435,949
2021Basic Life - OCC Retiree$ 40,510
2021Basic Life - OTS Retiree$ 181,750
2021Dependent Life Family$ 25,000
2021Dependent Life Spouse-OCC$ 181,000
2021Dependent Life Spouse - OTS Retiree$ -
2021Optional Life EE$ 775,000
2022Basic Life Actives$ 162,000
2022Basic Life - OCC Retiree$ 971,145
2022Basic Life - OTS Retiree$ 495,042
2022Dependent Life Family$ 25,000
2022Dependent Life Spouse$ 673,000
2022Dependent Life Spouse - OTS Retiree$ -
2022Optional Life EE$ 300,000
2023Basic Life Actives$ 326,000
2023Basic Life - OCC Retiree$ 763,000
2023Basic Life - OTS Retiree$ 1,149,416
2023Dependent Life Family$ 67,585
2023Dependent Life Spouse$ 567,000
2023Dependent Life Spouse - OTS Retiree$ 181,000
2023Optional Life EE$ 800,000
2024Basic Life Actives$ 691,000
2024Basic Life - OCC Retiree$ 910,340
2024Basic Life - OTS Retiree$ 2,565,163
2024AD&D$ 101,000
2024Dependent Life Spouse$ 204,000
2024Dependent Life Spouse - OTS Retiree$ 260,500
2024Optional Life EE$ 500,000

OCC Claims (Detailed) Data

ATTACHMENT 5 OGLI CLAIMS CENSUS DATA FOR 2020 - 2025
Date IncurredDate PaidClaim Amount (Including Interest)Claim Type
03/06/202004/16/2020$ 150,000.00Basic Life Active
04/08/202005/11/2020$ 269,000.00Basic Life Active
04/27/202006/19/2020$ 138,000.00Basic Life Active
09/06/202010/05/2020$ 231,000.00Basic Life Active
12/30/201901/23/2020$ 162,000.00Basic Life- OCC Retiree
10/27/201902/13/2020$ 42,500.00Basic Life- OCC Retiree
02/05/202002/28/2020$ 10,000.00Basic Life- OCC Retiree
01/07/202004/13/2020$ 11,250.00Basic Life- OCC Retiree
03/04/202004/16/2020$ 41,250.00Basic Life- OCC Retiree
03/13/202004/22/2020$ 26,500.00Basic Life- OCC Retiree
02/13/202004/24/2020$ 21,000.00Basic Life- OCC Retiree
04/07/202005/01/2020$ 7,400.00Basic Life- OCC Retiree
04/07/202005/07/2020$ 11,100.00Basic Life- OCC Retiree
09/28/201905/13/2020$ 17,000.00Basic Life- OCC Retiree
06/24/202008/11/2020$ 20,000.00Basic Life- OCC Retiree
04/24/202010/12/2020$ 47,250.00Basic Life- OCC Retiree
05/06/202012/14/2020$ 29,000.00Basic Life- OCC Retiree
12/21/201901/30/2020$ 194,000.00Basic Life- OTS Retiree
12/26/201902/13/2020$ 210,256.65Basic Life- OTS Retiree
01/14/202002/18/2020$ 55,250.00Basic Life- OTS Retiree
02/21/202004/28/2020$ 12,750.00Basic Life- OTS Retiree
04/07/202006/02/2020$ 300,000.00Basic Life- OTS Retiree
03/19/201906/05/2020$ 55,000.00Basic Life- OTS Retiree
06/12/202007/15/2020$ 255,000.00Basic Life- OTS Retiree
06/04/202007/22/2020$ 17,250.00Basic Life-OTS Retiree
06/12/202007/27/2020$ 45,000.00Basic Life- OTS Retiree
11/21/201908/06/2020$ 63,655.89Basic Life- OTS Retiree
11/21/201908/14/2020$ 21,230.14Basic Life- OTS Retiree
04/21/202009/09/2020$ 12,250.00Basic Life- OTS Retiree
08/25/202009/22/2020$ 49,250.00Basic Life- OTS Retiree
05/07/202010/01/2020$ 22,044.30Basic Life- OTS Retiree
10/13/202011/09/2020$ 154,000.00Basic Life- OTS Retiree
10/23/202011/06/2020$ 277,000.00Basic Life- OTS Retiree
03/06/202004/16/2020$ 100,000.00Optional Life
04/08/202005/11/2020$ 500,000.00Optional Life
09/06/202010/05/2020$ 500,000.00Optional Life
01/21/202002/19/2020$ 12,500.00Dependent Life Family
08/29/202010/13/2020$ 97,000.00Dependent Life Spouse
09/10/202010/26/2020$ 116,000.00Dependent Life Spouse
10/23/202011/23/2020$ 15,000.00Dependent Life Family
7/27/207/9/21$ 20,000.00Basic Life- OCC Retiree
5/14/217/14/21$ 22,220.60Basic Life- OCC Retiree
4/30/217/22/21$ 9,250.00Basic Life- OCC Retiree
4/23/208/9/21$ 39,500.00Basic Life- OCC Retiree
8/9/219/8/21$ 65,000.00Basic Life- OCC Retiree
7/28/219/15/21$ 25,051.02Basic Life Active
9/2/219/24/21$ 300,000.00Dependent Life Spouse
4/26/2110/14/21$ 156,000.00Basic Life Active
4/26/2110/14/21$ 25,000.00Optional Life
7/28/2110/22/21$ 124,948.98Basic Life Active
7/28/2110/22/21$ 500,000.00Optional Life
9/21/2111/2/21$ 4,625.00Basic Life- OCC Retiree
9/21/2111/8/21$ 4,625.00Basic Life- OCC Retiree
10/31/2111/24/21$ 31,260.27Basic Life- OCC Retiree
10/5/2112/2/21$ 127,000.00Basic Life- OTS Retiree
8/4/2112/7/21$ 100,750.00Basic Life Active
8/4/2112/7/21$ 162,500.00Optional Life
8/4/2112/9/21$ 54,250.00Basic Life Active
8/4/2112/9/21$ 87,500.00Optional Life
11/12/2112/20/21$ 54,750.00Basic Life- OTS Retiree
11/10/2112/31/21$ 181,000.00Dependent Life Spouse
11/10/2112/31/21$ 25,000.00Dependent Life Family
11/26/211/5/22$ 162,000.00Basic Life OCC Active
11/26/211/5/22$ 300,000.00Optional Life
11/10/211/13/22$ 57,250.00Basic Life- OTS Retiree
11/25/211/24/22$ 86,000.00Dependent Life Spouse
12/22/211/28/22$ 300,000.00Basic Life- OCC Retiree
12/2/212/2/22$ 10,500.00Basic Life-OTS Retiree
12/3/212/4/22$ 199,000.00Dependent Life Spouse
1/19/222/17/22$ 8,125.00Basic Life- OTS Retiree
2/7/223/3/22$ 13,000.00Basic Life- OTS Retiree
1/19/223/4/22$ 8,125.00Basic Life- OTS Retiree
12/25/213/17/22$ 32,250.00Basic Life- OCC Retiree
1/20/223/23/22$ 75,000.00Basic Life- OCC Retiree
5/8/213/23/22$ 75,000.00Basic Life- OCC Retiree
1/3/223/24/22$ 75,000.00Basic Life- OCC Retiree
1/20/223/25/22$ 121,000.00Dependent Life Spouse
2/2/223/31/22$ 37,500.00Basic Life- OCC Retiree
1/20/224/13/22$ 25,000.00Dependent Life Family
7/12/214/25/22$ 4,812.50Basic Life- OTS Retiree
8/31/214/28/22$ 24,750.00Basic Life-OTS Retiree
7/28/215/3/22$ 50,000.00Basic Life- OCC Retiree
4/11/225/6/22$ 24,000.00Basic Life- OCC Retiree
4/16/225/17/22$ 26,500.00Basic Life- OTS Retiree
3/8/225/26/22$ 267,000.00Dependent Life Spouse
7/12/215/31/22$ 4,812.50Basic Life- OTS Retiree
7/12/216/1/22$ 4,812.50Basic Life- OTS Retiree
5/13/226/2/22$ 33,750.00Basic Life- OTS Retiree
4/16/226/10/22$ 50,000.00Basic Life- OCC Retiree
7/12/216/17/22$ 4,812.50Basic Life-OTS Retiree
5/6/226/24/22$ 47,500.00Basic Life- OCC Retiree
1/3/226/30/22$ (75,000.00)Basic Life-OCC Retiree
5/5/227/6/22$ 45,750.00Basic Life- OTS Retiree
3/25/227/15/22$ 37,750.00Basic Life- OTS Retiree
4/24/227/18/22$ 108,000.00Basic Life- OTS Retiree
2/1/228/29/22$ 12,375.00Basic Life- OCC Retiree
2/1/229/14/22$ 12,375.00Basic Life- OCC Retiree
5/28/229/19/22$ 50,000.00Basic Life- OCC Retiree
1/3/229/23/22$ 75,000.00Basic Life- OCC Retiree
6/7/229/27/22$ 21,750.00Basic Life-OCC Retiree
9/4/2210/6/22$ 50,394.52Basic Life- OCC Retiree
8/20/2210/13/22$ 42,250.00Basic Life- OTS Retiree
12/4/2110/21/22$ 34,750.00Basic Life- OTS Retiree
9/8/2210/28/22$ 58,250.00Basic Life- OCC Retiree
6/29/2211/4/22$ 12,250.00Basic Life-OTS Retiree
10/25/2211/25/22$ 8,691.69Basic Life- OTS Retiree
10/25/2212/6/22$ 4,350.28Basic Life- OTS Retiree
11/25/221/4/23$ 111,000.00Dependent Life Spouse
11/25/221/4/23$ 25,000.00Dependent Life Family
5/31/221/17/23$ 35,500.00Basic Life- OTS Retiree
12/7/221/23/23$ 25,016.00Basic Life- OTS Retiree
12/17/221/24/23$ 40,000.00Basic Life- OTS Retiree
11/18/221/31/23$ 152,000.00Basic Life- OCC Active
11/18/221/31/23$ 500,000.00Optional Life
12/21/222/2/23$ 5,026.80Dependent Life Family
1/27/232/21/23$ 71,369.00Basic Life- OTS Retiree
1/29/232/21/23$ 39,750.00Basic Life- OTS Retiree
1/27/232/24/23$ 35,631.00Basic Life- OTS Retiree
1/6/233/2/23$ 54,000.00Basic Life- OTS Retiree
12/23/223/13/23$ 12,750.00Basic Life- OCC Retiree
7/24/223/14/23$ 48,000.00Basic Life- OCC Retiree
1/10/233/16/23$ 19,500.00Basic Life- OCC Retiree
12/29/223/20/23$ 87,000.00Basic Life- OCC Active
12/29/223/20/23$ 150,000.00Optional Life
10/10/223/23/23$ 57,500.00Basic Life- OTS Retiree
2/28/233/24/23$ 41,000.00Basic Life- OCC Retiree
1/18/233/24/23$ 6,750.00Basic Life- OCC Retiree
1/18/233/30/23$ 2,250.00Basic Life- OCC Retiree
12/29/224/10/23$ 87,000.00Basic Life- OCC Active
12/29/224/10/23$ 150,000.00Optional Life
1/15/234/21/23$ 20,250.00Basic Life- OCC Retiree
3/8/235/9/23$ 271,000.00Basic Life- OTS Retiree
8/10/225/23/23$ 36,500.00Basic Life- OCC Retiree
10/22/226/5/23$ 87,250.00Basic Life- OTS Retiree
4/11/236/12/23$ 189,000.00Basic Life- OCC Retiree
4/23/236/13/23$ 28,750.00Basic Life- OTS Retiree
12/9/226/23/23$ 30,192.41Basic Life- OTS Retiree
12/9/226/27/23$ 30,211.64Basic Life- OTS Retiree
1/12/227/17/23$ 31,000.00Basic Life- OTS Retiree
6/30/238/7/23$ 12,557.65Dependent Life Family
1/8/238/15/23$ 58,500.00Basic Life- OCC Retiree
7/17/238/16/23$ 181,000.00Dependent Life Spouse
7/11/238/21/23$ 9,333.33Basic Life- OCC Retiree
7/11/239/6/23$ 4,667.67Basic Life- OCC Retiree
8/6/239/27/23$ 24,500.00Basic Life- OCC Retiree
12/25/2210/4/23$ 72,000.00Basic Life- OCC Retiree
9/15/2310/12/23$ 15,750.00Basic Life- OCC Retiree
8/22/2310/13/23$ 24,250.00Basic Life- OCC Retiree
6/18/2110/18/23$ 50,000.00Basic Life- OCC Retiree
5/14/2210/30/23$ 16,200.00Basic Life- OTS Retiree
7/31/2311/3/23$ 21,333.33Basic Life- OCC Retiree
10/6/2311/3/23$ 273,000.00Dependent Life Spouse
10/1/2311/8/23$ 183,000.00Dependent Life Spouse
10/1/2311/8/23$ 25,000.00Dependent Life Family
10/19/2311/15/23$ 76,795.39Basic Life- OTS Retiree
10/15/2311/21/23$ 21,250.00Basic Life- OCC Retiree
10/11/2311/22/23$ 152,000.00Basic Life- OTS Retiree
7/31/2311/29/23$ 10,666.67Basic Life- OCC Retiree
10/21/2312/1/23$ 31,000.00Basic Life- OCC Retiree
9/26/2312/11/23$ 21,750.00Basic Life- OCC Retiree
10/24/2312/15/23$ 22,000.00Basic Life- OCC Retiree
11/5/2312/18/23$ 61,250.00Basic Life- OTS Retiree
9/22/2312/29/23$ 6,000.00Basic Life- OTS Retiree
4/11/235/1/24$ 164,000.00Basic Life Active
6/5/248/20/24$ 101,000.00Basic Life Active
6/17/2410/23/24$ 91,000.00Basic LIfe Active
10/22/2411/14/24$ 246,000.00Basic Life Active
6/17/2410/23/24$ 89,000.00Basic Life Active
12/23/232/15/24$ 47,750.00Basic Life- OCC Retiree
1/13/241/30/24$ 16,000.00Basic Life -OCC Retiree
2/3/245/14/24$ 27,750.00Basic Life- OCC Retiree
5/2/246/3/24$ 39,500.00Basic Life-OCC Retiree
5/19/246/10/24$ 15,000.00Basic Life-OCC Retiree
1/27/226/12/24$ 15,250.00Basic Life-OCC Retiree
11/23/237/29/24$ 3,250.00Basic Life-OCC Retiree
1/10/248/22/24$ 75,000.00Basic Life-OCC Retiree
3/20/249/12/24$ 300,000.00Basic Life-OCC Retiree
4/23/248/9/24$ 117,000.00Basic Life-OCC Retiree
1/3/249/3/24$ 33,250.00Basic Life-OCC Retiree
6/15/247/10/24$ 6,375.00Basic Life-OCC Retiree
6/15/247/3/24$ 14,875.00Basic Life-OCC Retiree
1/20/249/6/24$ 95,000.00Basic Life-OCC Retiree
11/23/2310/15/24$ 3,250.00Basic Life-OCC Retiree
10/20/2411/19/24$ 26,089.97Basic Life-OCC Retiree
9/26/2411/26/24$ 75,000.00Basic Life-OCC Retiree
12/14/232/1/24$ 489,000.00Basic Life-OTS Retiree
1/19/243/14/24$ 290,000.00Basic Life-OTS Retiree
5/14/221/25/24$ 4,050.00Basic Life-OTS Retiree
9/22/232/2/24$ 6,000.00Basic Life-OTS Retiree
10/1/232/28/24$ 153,000.00Basic Life-OTS Retiree
11/30/232/9/24$ 8,312.50Basic Life-OTS Retiree
11/30/231/31/24$ 8,312.50Basic Life-OTS Retiree
11/30/231/31/24$ 16,625.00Basic Life-OTS Retiree
11/26/231/29/24$ 16,250.00Basic Life-OTS Retiree
11/26/232/2/24$ 16,250.00Basic Life-OTS Retiree
12/26/232/7/24$ 64,250.00Basic Life-OTS Retiree
3/8/244/25/24$ 711,000.00Basic Life-OTS Retiree
4/3/245/3/24$ 47,750.00Basic Life-OTS Retiree
5/7/246/24/24$ 300,000.00Basic Life-OTS Retiree
5/21/246/25/24$ 34,949.93Basic Life-OTS Retiree
5/21/247/23/24$ 3,513.27Basic Life-OTS Retiree
3/30/247/25/24$ 73,894.38Basic Life-OTS Retiree
8/2/249/12/24$ 179,000.00Basic Life-OTS Retiree
8/4/249/26/24$ 50,500.00Basic Life-OTS Retiree
9/6/2411/1/24$ 72,000.00Basic Life-OTS Retiree
10/8/2412/5/24$ 11,750.00Basic Life-OTS Retiree
10/14/2412/26/24$ 12,250.00Basic Life-OTS Retiree
6/5/248/20/24$ 200,000.00Optional Life - Active
6/17/2410/23/24$ 25,000.00Optional Life - Active
10/22/2411/14/24$ 275,000.00Optional Life - Active
12/31/234/12/24$ 204,000.00Dependent Life-OCC Spouse
7/17/249/3/24$ 118,500.00Dependent Life- OTS Spouse
8/10/249/12/24$ 142,000.00Dependent Life-OTS Spouse
6/5/248/20/24$ 101,000.00AD&D Active

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