Attachment 6- Technicla Exhibit OFR Census.xlsx

XLSX spreadsheet 21 KB Posted May 15, 2024

Attached to: OCC's Group Life Insurance Services
Solicitation number: 2031JW24N00005
Issued by: Department of the Treasury Office of the Comptroller of the Currency

About this file

Written by GovTribe AI · May 15, 2024

This document appears to be an attachment related to a federal contract opportunity. The attachment contains information about the Office of the Comptroller of the Currency's (OCC) group life insurance services, including salary and coverage details for various employees.

The related federal contract opportunity is a pre-solicitation notice for the OCC's Group Life Insurance Services (Solicitation Number: 2031JW24N00005). The OCC is conducting market research to determine the feasibility of a potential procurement requirement for group life insurance services. The primary NAICS code is 524113 - Direct Life Insurance Carriers, but the OCC is open to other relevant NAICS codes as well. The OCC is seeking information from interested sources with the capabilities and qualifications to underwrite and administer its group life insurance program.

View the file

Other files

File	Type	Posted
Attachment 4 - Technical Exhibt Affidavit of Domestic Partnership.pdf	PDF	May 15, 2024
Attachment 5- Technical Exhibit OCC Life Claims September 2021 through December 2023.xlsx	XLSX spreadsheet	May 15, 2024
SSN 2031JW24N00005-Life Ins_final2.pdf	PDF	May 15, 2024
Attachment 3 - Technical Exhibit Retiree Census - 02292024.xlsx	XLSX spreadsheet	May 15, 2024
Attachment 1-Blank OCC Group Life Pricing Structure.pdf	PDF	May 15, 2024
Attachment 2 - Technical Exhibit Active Employee Census Data.xlsx	XLSX spreadsheet	May 15, 2024

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

OFR Life

Grade	Adjusted Base Salary	OFR Life Basic Amount (OFR Life Age Coverage Amount*1000)	OFR Life Age Coverage Amount	OFR Life Age Coverage Code	OFR Life Age Coverage Description	Gender Code	State	Birth Date	OFR Life Age Group Code	OFR Life Age Group Desc	Pay Period End Date
42	70,904.00	0	0	0	NONE	F	GA	10/13/1993	0		03/23/2024
51	91,057.00	0	0	0	NONE	M	OH	04/30/1991	0		03/23/2024
51	105,012.00	108000	108	1	BASIC ONLY	F	MD	08/10/1962	7	60 and over	03/23/2024
51	105,651.00	0	0	0	NONE	M	DC	11/09/1998	0		03/23/2024
51	105,651.00	0	0	0	NONE	F	MD	06/02/1998	0		03/23/2024
51	105,651.00	0	0	0	NONE	F	VA	08/14/1999	0		03/23/2024
53	114,764.00	117000	117	30	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 4X	F	NY	01/16/1992	1	Under 35	03/23/2024
52	117,099.00	0	0	0	NONE	M	DC	01/07/1993	0		03/23/2024
52	119,052.00	122000	122	9	BASIC/SPOUSE 100	M	DC	10/22/1996	1	Under 35	03/23/2024
52	121,288.00	0	0	0	NONE	M	VA	02/12/1997	0		03/23/2024
53	123,945.00	126000	126	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	WV	05/09/1983	3	40 to 44	03/23/2024
53	125,745.00	128000	128	6	BASIC/EMPLOYEE/SPOUSE 50	F	FL	03/07/1983	3	40 to 44	03/23/2024
51	125,927.00	0	0	0	NONE	M	PA	10/01/1992	0		03/23/2024
53	129,214.00	0	0	0	NONE	M	OH	09/03/1986	0		03/23/2024
60	130,448.00	133000	133	9	BASIC/SPOUSE 100	M	WV	04/01/1967	6	55 to 59	03/23/2024
53	135,101.00	0	0	0	NONE	F	TX	01/22/1978	0		03/23/2024
52	135,257.00	138000	138	1	BASIC ONLY	M	FL	12/27/1963	7	60 and over	03/23/2024
51	136,084.00	0	0	0	NONE	M	MD	05/30/1969	0		03/23/2024
53	137,197.00	140000	140	1	BASIC ONLY	M	NH	02/13/1988	2	35 to 39	03/23/2024
52	140,252.00	143000	143	1	BASIC ONLY	F	VA	06/17/1967	6	55 to 59	03/23/2024
53	140,869.00	0	0	0	NONE	M	TN	04/11/1978	0		03/23/2024
53	141,158.00	144000	144	1	BASIC ONLY	M	IN	07/28/1980	3	40 to 44	03/23/2024
53	141,508.00	0	0	0	NONE	M	VA	03/20/1990	0		03/23/2024
53	145,768.00	0	0	0	NONE	M	TX	01/05/1967	0		03/23/2024
53	148,553.00	151000	151	1	BASIC ONLY	F	KY	07/04/1962	7	60 and over	03/23/2024
53	151,543.00	0	0	0	NONE	M	MD	03/22/1962	0		03/23/2024
53	154,904.00	157000	157	9	BASIC/SPOUSE 100	M	OH	05/16/1979	3	40 to 44	03/23/2024
52	154,936.00	157000	157	5	BASIC/EMPLOYEE	F	DC	05/09/1972	5	50 to 54	03/23/2024
53	156,083.00	0	0	0	NONE	M	PA	08/11/1992	0		03/23/2024
60	156,368.00	159000	159	1	BASIC ONLY	M	OH	04/20/1982	3	40 to 44	03/23/2024
53	159,152.00	162000	162	6	BASIC/EMPLOYEE/SPOUSE 50	M	VA	07/05/1987	2	35 to 39	03/23/2024
60	159,687.00	0	0	0	NONE	M	LA	11/16/1983	0		03/23/2024
52	163,992.00	0	0	0	NONE	F	MD	12/11/1976	0		03/23/2024
60	164,339.00	167000	167	9	BASIC/SPOUSE 100	F	CO	09/30/1979	3	40 to 44	03/23/2024
53	164,524.00	167000	167	5	BASIC/EMPLOYEE	F	VA	07/04/1983	3	40 to 44	03/23/2024
60	164,551.00	0	0	0	NONE	M	IN	11/23/1985	0		03/23/2024
53	165,060.00	0	0	0	NONE	M	DC	10/06/1991	0		03/23/2024
53	165,060.00	0	0	0	NONE	M	DC	01/31/1991	0		03/23/2024
53	165,144.00	0	0	0	NONE	M	DE	02/15/1978	0		03/23/2024
53	166,895.00	0	0	0	NONE	M	DC	05/10/1991	0		03/23/2024
53	168,115.00	0	0	0	NONE	M	VA	05/10/1992	0		03/23/2024
53	168,115.00	0	0	0	NONE	M	VA	12/19/1991	0		03/23/2024
53	168,530.00	0	0	0	NONE	M	VA	11/30/1990	0		03/23/2024
53	168,804.00	171000	171	1	BASIC ONLY	M	WV	07/02/1970	5	50 to 54	03/23/2024
53	168,937.00	171000	171	11	BASIC/EMPLOYEE/SPOUSE 100	M	VA	12/10/1992	1	Under 35	03/23/2024
60	169,621.00	0	0	0	NONE	F	WV	12/04/1962	0		03/23/2024
53	169,897.00	172000	172	5	BASIC/EMPLOYEE	F	VA	05/14/1977	4	45 to 49	03/23/2024
60	170,613.00	173000	173	11	BASIC/EMPLOYEE/SPOUSE 100	M	VA	07/07/1980	3	40 to 44	03/23/2024
53	171,617.00	174000	174	33	BASIC/EMPLOYEE/FAMILY 5X	F	VA	07/28/1976	4	45 to 49	03/23/2024
60	173,679.00	176000	176	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	F	MD	02/11/1988	2	35 to 39	03/23/2024
60	174,436.00	0	0	0	NONE	F	OK	08/19/1969	0		03/23/2024
53	175,056.00	0	0	0	NONE	F	MD	07/02/1981	0		03/23/2024
53	177,298.00	180000	180	1	BASIC ONLY	M	DC	03/11/1979	3	40 to 44	03/23/2024
53	179,704.00	182000	182	1	BASIC ONLY	M	VA	07/01/1993	1	Under 35	03/23/2024
53	180,319.00	0	0	0	NONE	M	NY	09/03/1987	0		03/23/2024
60	181,646.00	0	0	0	NONE	F	VA	05/05/1975	0		03/23/2024
60	182,196.00	185000	185	1	BASIC ONLY	M	VA	05/10/1980	3	40 to 44	03/23/2024
60	182,260.00	185000	185	11	BASIC/EMPLOYEE/SPOUSE 100	M	VA	10/05/1972	5	50 to 54	03/23/2024
53	183,547.00	186000	186	9	BASIC/SPOUSE 100	M	DC	01/18/1988	2	35 to 39	03/23/2024
53	184,443.00	187000	187	11	BASIC/EMPLOYEE/SPOUSE 100	M	VA	08/12/1989	1	Under 35	03/23/2024
60	185,165.00	188000	188	5	BASIC/EMPLOYEE	M	FL	12/31/1970	5	50 to 54	03/23/2024
53	185,653.00	0	0	0	NONE	M	VA	04/02/1970	0		03/23/2024
60	185,966.00	0	0	0	NONE	M	DC	05/30/1969	0		03/23/2024
53	186,718.00	189000	189	1	BASIC ONLY	M	NJ	12/27/1984	2	35 to 39	03/23/2024
60	187,564.00	190000	190	21	BASIC/EMPLOYEE/FAMILY 3X	M	VA	10/23/1968	6	55 to 59	03/23/2024
53	188,593.00	191000	191	1	BASIC ONLY	M	VA	03/25/1989	1	Under 35	03/23/2024
53	188,593.00	0	0	0	NONE	F	VA	01/27/1966	0		03/23/2024
53	188,593.00	191000	191	5	BASIC/EMPLOYEE	M	DC	10/02/1968	6	55 to 59	03/23/2024
60	188,888.00	0	0	0	NONE	M	VA	06/20/1983	0		03/23/2024
60	189,229.00	0	0	0	NONE	F	MD	03/11/1979	0		03/23/2024
60	191,071.00	194000	194	1	BASIC ONLY	M	MD	09/11/1981	3	40 to 44	03/23/2024
60	192,050.00	195000	195	35	BASIC/SPOUSE 100/FAMILY 5X	M	MD	10/15/1983	3	40 to 44	03/23/2024
60	192,090.00	195000	195	5	BASIC/EMPLOYEE	M	VA	01/15/1961	7	60 and over	03/23/2024
60	192,213.00	0	0	0	NONE	F	MD	10/04/1966	0		03/23/2024
60	192,544.00	0	0	0	NONE	M	TX	09/16/1966	0		03/23/2024
60	194,568.00	197000	197	2	BASIC/SPOUSE 50	M	VA	08/19/1975	4	45 to 49	03/23/2024
60	194,675.00	197000	197	9	BASIC/SPOUSE 100	M	DC	01/25/1967	6	55 to 59	03/23/2024
60	194,710.00	197000	197	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	NJ	04/16/1968	6	55 to 59	03/23/2024
60	195,357.00	198000	198	1	BASIC ONLY	M	VA	02/03/1973	5	50 to 54	03/23/2024
60	195,935.00	198000	198	1	BASIC ONLY	F	DC	02/03/1982	3	40 to 44	03/23/2024
60	198,714.00	0	0	0	NONE	F	DC	08/20/1981	0		03/23/2024
60	199,229.00	202000	202	1	BASIC ONLY	M	VA	03/08/1976	4	45 to 49	03/23/2024
60	199,240.00	202000	202	1	BASIC ONLY	F	FL	06/25/1973	5	50 to 54	03/23/2024
60	200,000.00	0	0	0	NONE	F	NJ	03/11/1985	0		03/23/2024
60	200,685.00	203000	203	1	BASIC ONLY	M	VA	09/21/1971	5	50 to 54	03/23/2024
60	201,311.00	204000	204	1	BASIC ONLY	M	VA	11/23/1974	4	45 to 49	03/23/2024
60	202,046.00	205000	205	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	NY	11/05/1979	3	40 to 44	03/23/2024
60	202,726.00	205000	205	1	BASIC ONLY	M	MD	12/21/1979	3	40 to 44	03/23/2024
60	203,518.00	0	0	0	NONE	F	MD	07/27/1961	0		03/23/2024
60	204,233.00	207000	207	1	BASIC ONLY	M	VA	10/15/1975	4	45 to 49	03/23/2024
60	204,733.00	0	0	0	NONE	F	MD	03/29/1968	0		03/23/2024
60	204,755.00	0	0	0	NONE	M	CO	12/10/1972	0		03/23/2024
70	205,154.00	208000	208	1	BASIC ONLY	F	VA	11/15/1984	2	35 to 39	03/23/2024
60	205,273.00	208000	208	1	BASIC ONLY	M	MD	10/18/1963	7	60 and over	03/23/2024
60	207,037.00	210000	210	11	BASIC/EMPLOYEE/SPOUSE 100	F	MD	08/07/1964	6	55 to 59	03/23/2024
60	207,421.00	210000	210	1	BASIC ONLY	M	NY	03/22/1982	3	40 to 44	03/23/2024
60	208,847.00	211000	211	1	BASIC ONLY	F	VA	02/09/1972	5	50 to 54	03/23/2024
60	209,981.00	212000	212	9	BASIC/SPOUSE 100	F	DC	07/31/1974	4	45 to 49	03/23/2024
60	211,160.00	0	0	0	NONE	M	VA	03/07/1980	0		03/23/2024
60	212,467.00	215000	215	11	BASIC/EMPLOYEE/SPOUSE 100	F	MD	08/07/1971	5	50 to 54	03/23/2024
60	213,142.00	216000	216	9	BASIC/SPOUSE 100	M	VA	06/23/1980	3	40 to 44	03/23/2024
60	213,925.00	216000	216	5	BASIC/EMPLOYEE	M	VA	11/27/1976	4	45 to 49	03/23/2024
60	216,678.00	219000	219	5	BASIC/EMPLOYEE	M	MD	12/29/1961	7	60 and over	03/23/2024
60	217,428.00	220000	220	33	BASIC/EMPLOYEE/FAMILY 5X	M	VA	09/28/1971	5	50 to 54	03/23/2024
60	218,191.00	0	0	0	NONE	M	DC	08/11/1966	0		03/23/2024
60	218,951.00	221000	221	1	BASIC ONLY	M	PA	01/21/1970	5	50 to 54	03/23/2024
60	219,320.00	0	0	0	NONE	F	MD	09/23/1957	0		03/23/2024
60	220,089.00	0	0	0	NONE	M	MD	10/21/1980	0		03/23/2024
60	222,416.00	225000	225	5	BASIC/EMPLOYEE	M	VA	01/04/1974	4	45 to 49	03/23/2024
60	222,746.00	225000	225	1	BASIC ONLY	M	MD	07/27/1975	4	45 to 49	03/23/2024
60	223,240.00	226000	226	23	BASIC/SPOUSE 100/FAMILY 3X	M	VA	11/20/1984	2	35 to 39	03/23/2024
60	223,814.00	0	0	0	NONE	M	DC	03/04/1971	0		03/23/2024
60	223,820.00	226000	226	1	BASIC ONLY	F	MD	11/08/1977	4	45 to 49	03/23/2024
70	224,251.00	227000	227	9	BASIC/SPOUSE 100	M	VT	11/14/1982	3	40 to 44	03/23/2024
60	225,366.00	228000	228	1	BASIC ONLY	M	MD	10/31/1980	3	40 to 44	03/23/2024
60	227,754.00	230000	230	11	BASIC/EMPLOYEE/SPOUSE 100	M	DC	10/07/1982	3	40 to 44	03/23/2024
60	232,553.00	0	0	0	NONE	M	VA	08/31/1961	0		03/23/2024
60	233,906.00	236000	236	11	BASIC/EMPLOYEE/SPOUSE 100	M	VA	03/17/1972	5	50 to 54	03/23/2024
60	235,298.00	0	0	0	NONE	M	VA	01/04/1974	0		03/23/2024
60	237,821.00	0	0	0	NONE	M	VA	01/17/1968	0		03/23/2024
60	238,308.00	0	0	0	NONE	M	NY	10/14/1986	0		03/23/2024
60	239,572.00	242000	242	5	BASIC/EMPLOYEE	M	NJ	07/25/1967	6	55 to 59	03/23/2024
60	240,736.00	0	0	0	NONE	M	VA	08/16/1967	0		03/23/2024
70	242,135.00	0	0	0	NONE	F	MD	06/27/1982	0		03/23/2024
60	242,566.00	0	0	0	NONE	F	VA	04/01/1955	0		03/23/2024
60	243,172.00	0	0	0	NONE	F	MD	10/16/1975	0		03/23/2024
60	243,172.00	0	0	0	NONE	M	MD	05/17/1956	0		03/23/2024
60	243,172.00	246000	246	1	BASIC ONLY	F	VA	01/10/1962	7	60 and over	03/23/2024
60	243,172.00	246000	246	1	BASIC ONLY	F	MD	09/27/1963	7	60 and over	03/23/2024
60	243,172.00	246000	246	2	BASIC/SPOUSE 50	M	VA	05/10/1974	4	45 to 49	03/23/2024
60	243,172.00	0	0	0	NONE	M	VA	04/21/1982	0		03/23/2024
60	243,172.00	0	0	0	NONE	M	VA	05/24/1966	0		03/23/2024
60	243,172.00	246000	246	1	BASIC ONLY	M	VA	11/06/1974	4	45 to 49	03/23/2024
60	243,172.00	0	0	0	NONE	M	VA	07/31/1968	0		03/23/2024
60	243,172.00	246000	246	1	BASIC ONLY	F	VA	06/22/1962	7	60 and over	03/23/2024
70	247,303.00	0	0	0	NONE	F	MD	10/22/1960	0		03/23/2024
70	251,793.00	0	0	0	NONE	M	VA	03/09/1977	0		03/23/2024
70	252,169.00	255000	255	12	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 1X	F	MD	11/06/1966	6	55 to 59	03/23/2024
70	255,039.00	258000	258	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	VA	03/23/1982	3	40 to 44	03/23/2024
60	256,167.00	0	0	0	NONE	M	NY	10/04/1981	0		03/23/2024
70	262,361.00	0	0	0	NONE	M	MD	09/07/1979	0		03/23/2024
70	262,857.00	265000	265	11	BASIC/EMPLOYEE/SPOUSE 100	M	MD	09/03/1960	7	60 and over	03/23/2024
70	263,369.00	0	0	0	NONE	M	DC	08/30/1985	0		03/23/2024
60	269,091.00	272000	272	9	BASIC/SPOUSE 100	M	NJ	07/31/1982	3	40 to 44	03/23/2024
60	271,613.00	274000	274	1	BASIC ONLY	F	NJ	03/30/1966	6	55 to 59	03/23/2024
60	272,517.00	0	0	0	NONE	M	NY	01/23/1980	0		03/23/2024
60	278,313.00	0	0	0	NONE	M	NJ	10/27/1959	0		03/23/2024
60	278,313.00	281000	281	1	BASIC ONLY	M	NJ	07/23/1954	7	60 and over	03/23/2024
60	280,297.00	0	0	0	NONE	M	CA	01/16/1980	0		03/23/2024
70	285,829.00	0	0	0	NONE	F	DC	05/17/1971	0		03/23/2024
70	287,863.00	290000	290	5	BASIC/EMPLOYEE	M	MD	01/08/1980	3	40 to 44	03/23/2024
70	289,272.00	292000	292	2	BASIC/SPOUSE 50	M	MA	01/12/1956	7	60 and over	03/23/2024
70	293,099.00	296000	296	16	BASIC/EMPLOYEE/SPOUSE 50/FAMILY 2X	M	MD	10/16/1958	7	60 and over	03/23/2024
70	297,675.00	0	0	0	NONE	M	MD	02/07/1976	0		03/23/2024
70	298,130.00	0	0	0	NONE	M	VA	11/25/1974	0		03/23/2024
80	301,459.00	500000	500	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	VA	05/28/1979	3	40 to 44	03/23/2024
70	302,200.00	305000	305	1	BASIC ONLY	F	VA	11/23/1966	6	55 to 59	03/23/2024
70	302,200.00	305000	305	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	VA	02/03/1987	2	35 to 39	03/23/2024
70	302,200.00	305000	305	5	BASIC/EMPLOYEE	M	MD	09/24/1966	6	55 to 59	03/23/2024
70	302,200.00	0	0	0	NONE	M	DC	03/09/1945	0		03/23/2024
70	302,200.00	305000	305	1	BASIC ONLY	M	MD	03/06/1968	6	55 to 59	03/23/2024
70	302,200.00	305000	305	1	BASIC ONLY	M	TX	04/20/1967	6	55 to 59	03/23/2024
80	307,495.00	500000	500	6	BASIC/EMPLOYEE/SPOUSE 50	M	VA	05/30/1962	7	60 and over	03/23/2024
80	310,300.00	500000	500	36	BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X	M	VA	05/02/1958	7	60 and over	03/23/2024
80	310,300.00	500000	500	1	BASIC ONLY	F	MD	08/29/1959	7	60 and over	03/23/2024

File details come from the government source that posted it. Updated May 15, 2024.