Attachment 6.1 Technical Exhibit OFR_Census.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
Group Life Insurance
Solicitation number
2031JW21Q00092
Issued by

About this file

This document contains a federal contract solicitation and technical exhibit for an incumbent group life insurance program. The Office of the Comptroller of the Currency and the Office of Financial Research are seeking an experienced contractor to underwrite and administer their group life insurance program for active employees, retirees, and eligible dependents. The program currently insures approximately 2,580 employees and 2,510 retirees, of which 688 are part of a frozen retirement group. The solicitation seeks to amend an existing policy to include additional coverage terms such as optional supplemental employee life insurance of $25,000 to $500,000 or 5 times salary. The technical exhibit provides enrollment details including employee names, salaries, coverage levels, and demographic information. The incumbent contractor is Metropolitan Life Insurance Company, whose five-year contract expires on June 30, 2021.

View the file

Other files

Show all 19

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

OFR Life

Attachment 6.1: Technical Exhibit OFR Census
RFQ: 2031JW21Q00092
GradeAdjusted Base SalaryOFR Life Basic AmountOFR Life Coverage AmountOFR Life Coverage CodeOFR Life Coverage DescriptionGender CodeStateBirth DateOFR Life Age Group CodeOFR Life Age Group DescPay Period End Date
03168,400.003000003001BASIC ONLYMMT05/01/1967550 to 5402/27/2021
4287,525.00000NONEFNJ05/15/1959002/27/2021
4274,778.0077000771BASIC ONLYFMD06/23/1985235 to 3902/27/2021
4276,313.0079000791BASIC ONLYFMD08/10/1962655 to 5902/27/2021
51123,303.00000NONEFMD12/11/1976002/27/2021
5194,842.00000NONEFVA06/08/1955002/27/2021
51116,387.00000NONEMMD05/30/1969002/27/2021
52116,608.001190001191BASIC ONLYFVA06/17/1967550 to 5402/27/2021
52128,816.001310001315BASIC/EMPLOYEEFDC05/09/1972445 to 4902/27/2021
53138,647.00000NONEFVA07/28/1976002/27/2021
53159,855.00000NONEMDC05/08/1989002/27/2021
53133,382.00000NONEMMD03/22/1962002/27/2021
53160,000.00000NONEMNY06/17/1975002/27/2021
53139,797.00000NONEMTX09/16/1966002/27/2021
53155,000.00000NONEMVA03/25/1989002/27/2021
53134,163.001370001376BASIC/EMPLOYEE/SPOUSE 50MVA07/05/19871Under 3502/27/2021
53143,236.001460001461BASIC ONLYMVA03/11/1979340 to 4402/27/2021
53148,922.0015100015136BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMNY11/05/1979340 to 4402/27/2021
53152,065.001550001551BASIC ONLYMVA11/23/1974445 to 4902/27/2021
53155,000.0015700015736BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMTX02/12/19921Under 3502/27/2021
53157,313.001600001601BASIC ONLYMNJ12/27/1984235 to 3902/27/2021
53160,994.001630001635BASIC/EMPLOYEEMVA03/29/19891Under 3502/27/2021
53166,038.0016900016936BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMVA01/03/19871Under 3502/27/2021
53168,386.0017100017111BASIC/EMPLOYEE/SPOUSE 100FMD08/07/1964655 to 5902/27/2021
53168,386.001710001715BASIC/EMPLOYEEMMD12/29/1961655 to 5902/27/2021
60217,118.00000NONEFMD07/25/1956002/27/2021
60184,884.00000NONEFMD09/23/1957002/27/2021
60185,204.00000NONEFMD11/06/1966002/27/2021
60194,126.00000NONEFMD03/29/1968002/27/2021
60178,247.00000NONEFMD12/24/1969002/27/2021
60217,118.00000NONEFMD10/16/1975002/27/2021
60186,076.00000NONEMDC03/04/1971002/27/2021
60157,455.00000NONEMDC11/16/1983002/27/2021
60194,230.00000NONEMDC08/30/1985002/27/2021
60208,545.00000NONEMMD05/17/1956002/27/2021
60155,154.00000NONEMMD10/15/1983002/27/2021
60217,118.00000NONEMNJ10/27/1959002/27/2021
60187,877.00000NONEMVA08/31/1961002/27/2021
60197,278.00000NONEMVA08/16/1967002/27/2021
60217,118.00000NONEMVA07/31/1968002/27/2021
60190,094.00000NONEMVA01/04/1974002/27/2021
60212,531.00000NONEMVA01/16/1980002/27/2021
60210,162.00000NONEMVA04/21/1982002/27/2021
60139,337.001420001425BASIC/EMPLOYEEMVA01/15/1961655 to 5902/27/2021
60140,313.0014300014336BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XFMD02/11/19881Under 3502/27/2021
60152,032.001550001551BASIC ONLYFVA11/15/1984235 to 3902/27/2021
60153,588.001560001561BASIC ONLYMVA05/10/1980340 to 4402/27/2021
60155,850.0015800015821BASIC/EMPLOYEE/FAMILY 3XMVA10/23/1968550 to 5402/27/2021
60159,469.001620001629BASIC/SPOUSE 100MDC01/25/1967550 to 5402/27/2021
60160,217.0016300016311BASIC/EMPLOYEE/SPOUSE 100MVA07/07/1980340 to 4402/27/2021
60161,010.001640001641BASIC ONLYMMD09/11/1981235 to 3902/27/2021
60162,396.0016500016511BASIC/EMPLOYEE/SPOUSE 100MVA09/11/1978340 to 4402/27/2021
60163,687.001660001661BASIC ONLYMMD12/21/1979340 to 4402/27/2021
60164,402.001670001671BASIC ONLYMVA02/03/1973445 to 4902/27/2021
60167,479.001700001701BASIC ONLYMNY03/22/1982235 to 3902/27/2021
60172,102.001750001751BASIC ONLYMVA10/15/1975445 to 4902/27/2021
60172,193.001750001759BASIC/SPOUSE 100MVA06/23/1980340 to 4402/27/2021
60175,656.0017800017833BASIC/EMPLOYEE/FAMILY 5XMVA09/28/1971445 to 4902/27/2021
60175,307.001780001785BASIC/EMPLOYEEMVA11/27/1976340 to 4402/27/2021
60176,056.001790001791BASIC ONLYFVA02/09/1972445 to 4902/27/2021
60179,174.0018200018211BASIC/EMPLOYEE/SPOUSE 100FDC08/07/1971445 to 4902/27/2021
60180,352.0018300018323BASIC/SPOUSE 100/FAMILY 3XMVA11/20/1984235 to 3902/27/2021
60181,559.001840001845BASIC/EMPLOYEEMNJ07/25/1967550 to 5402/27/2021
60182,070.001850001851BASIC ONLYMMD10/31/1980340 to 4402/27/2021
60184,840.001870001875BASIC/EMPLOYEEMVA01/04/1974445 to 4902/27/2021
60197,180.0020000020011BASIC/EMPLOYEE/SPOUSE 100MVA03/17/1972445 to 4902/27/2021
60200,476.0020300020336BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMMD10/31/1979340 to 4402/27/2021
60202,762.002050002051BASIC ONLYFVA01/10/1962655 to 5902/27/2021
60202,183.002050002051BASIC ONLYFVA06/25/1973445 to 4902/27/2021
60204,734.002070002071BASIC ONLYFMD09/27/1963655 to 5902/27/2021
60209,942.002120002121BASIC ONLYFVA06/22/1962655 to 5902/27/2021
60215,491.002180002182BASIC/SPOUSE 50MVA05/10/1974445 to 4902/27/2021
60217,118.002200002201BASIC ONLYMVA11/06/1974445 to 4902/27/2021
60217,118.002200002205BASIC/EMPLOYEEMMD01/08/1980340 to 4402/27/2021
60217,272.002200002209BASIC/SPOUSE 100MNJ07/31/1982235 to 3902/27/2021
60222,494.002250002251BASIC ONLYFNJ03/30/1966550 to 5402/27/2021
60233,801.002360002361BASIC ONLYMNJ07/23/1954760 and over02/27/2021
70214,958.00000NONEFDC05/17/1971002/27/2021
70205,487.00000NONEFMD10/22/1960002/27/2021
70224,676.00000NONEFMD10/04/1966002/27/2021
70180,626.00000NONEFMD06/27/1982002/27/2021
70275,800.00000NONEMDC03/09/1945002/27/2021
70217,411.00000NONEMDC04/22/1981002/27/2021
70243,939.00000NONEMMD02/07/1976002/27/2021
70218,001.00000NONEMMD09/07/1979002/27/2021
70229,208.00000NONEMVA01/12/1956002/27/2021
70240,855.00000NONEMVA11/25/1974002/27/2021
70176,307.001790001799BASIC/SPOUSE 100MDC11/14/1982235 to 3902/27/2021
70196,231.0019900019936BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMVA03/23/1982235 to 3902/27/2021
70202,245.002050002055BASIC/EMPLOYEEMMD09/03/1960760 and over02/27/2021
70249,068.002520002521BASIC ONLYFVA03/25/1963655 to 5902/27/2021
70250,181.0025300025311BASIC/EMPLOYEE/SPOUSE 100MMD09/24/1966550 to 5402/27/2021
70271,982.002740002741BASIC ONLYFVA11/23/1966550 to 5402/27/2021
70275,800.002780002781BASIC ONLYMMD03/06/1968550 to 5402/27/2021
70275,800.0027800027816BASIC/EMPLOYEE/SPOUSE 50/FAMILY 2XMMD10/16/1958760 and over02/27/2021
80283,200.00000NONEFMD08/29/1959002/27/2021
80283,200.00000NONEMVA05/02/1958002/27/2021
80242,889.0030000030036BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMVA05/28/1979340 to 4402/27/2021
80275,171.003000003006BASIC/EMPLOYEE/SPOUSE 50MVA05/30/1962655 to 5902/27/2021

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