Attachment 6.1 Technical Exhibit OFR_Census.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Group Life Insurance
- Solicitation number
- 2031JW21Q00092
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 | |||||||||||
| Grade | Adjusted Base Salary | OFR Life Basic Amount | OFR Life Coverage Amount | OFR Life Coverage Code | OFR Life Coverage Description | Gender Code | State | Birth Date | OFR Life Age Group Code | OFR Life Age Group Desc | Pay Period End Date |
| 03 | 168,400.00 | 300000 | 300 | 1 | BASIC ONLY | M | MT | 05/01/1967 | 5 | 50 to 54 | 02/27/2021 |
| 42 | 87,525.00 | 0 | 0 | 0 | NONE | F | NJ | 05/15/1959 | 0 | 02/27/2021 | |
| 42 | 74,778.00 | 77000 | 77 | 1 | BASIC ONLY | F | MD | 06/23/1985 | 2 | 35 to 39 | 02/27/2021 |
| 42 | 76,313.00 | 79000 | 79 | 1 | BASIC ONLY | F | MD | 08/10/1962 | 6 | 55 to 59 | 02/27/2021 |
| 51 | 123,303.00 | 0 | 0 | 0 | NONE | F | MD | 12/11/1976 | 0 | 02/27/2021 | |
| 51 | 94,842.00 | 0 | 0 | 0 | NONE | F | VA | 06/08/1955 | 0 | 02/27/2021 | |
| 51 | 116,387.00 | 0 | 0 | 0 | NONE | M | MD | 05/30/1969 | 0 | 02/27/2021 | |
| 52 | 116,608.00 | 119000 | 119 | 1 | BASIC ONLY | F | VA | 06/17/1967 | 5 | 50 to 54 | 02/27/2021 |
| 52 | 128,816.00 | 131000 | 131 | 5 | BASIC/EMPLOYEE | F | DC | 05/09/1972 | 4 | 45 to 49 | 02/27/2021 |
| 53 | 138,647.00 | 0 | 0 | 0 | NONE | F | VA | 07/28/1976 | 0 | 02/27/2021 | |
| 53 | 159,855.00 | 0 | 0 | 0 | NONE | M | DC | 05/08/1989 | 0 | 02/27/2021 | |
| 53 | 133,382.00 | 0 | 0 | 0 | NONE | M | MD | 03/22/1962 | 0 | 02/27/2021 | |
| 53 | 160,000.00 | 0 | 0 | 0 | NONE | M | NY | 06/17/1975 | 0 | 02/27/2021 | |
| 53 | 139,797.00 | 0 | 0 | 0 | NONE | M | TX | 09/16/1966 | 0 | 02/27/2021 | |
| 53 | 155,000.00 | 0 | 0 | 0 | NONE | M | VA | 03/25/1989 | 0 | 02/27/2021 | |
| 53 | 134,163.00 | 137000 | 137 | 6 | BASIC/EMPLOYEE/SPOUSE 50 | M | VA | 07/05/1987 | 1 | Under 35 | 02/27/2021 |
| 53 | 143,236.00 | 146000 | 146 | 1 | BASIC ONLY | M | VA | 03/11/1979 | 3 | 40 to 44 | 02/27/2021 |
| 53 | 148,922.00 | 151000 | 151 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | M | NY | 11/05/1979 | 3 | 40 to 44 | 02/27/2021 |
| 53 | 152,065.00 | 155000 | 155 | 1 | BASIC ONLY | M | VA | 11/23/1974 | 4 | 45 to 49 | 02/27/2021 |
| 53 | 155,000.00 | 157000 | 157 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | M | TX | 02/12/1992 | 1 | Under 35 | 02/27/2021 |
| 53 | 157,313.00 | 160000 | 160 | 1 | BASIC ONLY | M | NJ | 12/27/1984 | 2 | 35 to 39 | 02/27/2021 |
| 53 | 160,994.00 | 163000 | 163 | 5 | BASIC/EMPLOYEE | M | VA | 03/29/1989 | 1 | Under 35 | 02/27/2021 |
| 53 | 166,038.00 | 169000 | 169 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | M | VA | 01/03/1987 | 1 | Under 35 | 02/27/2021 |
| 53 | 168,386.00 | 171000 | 171 | 11 | BASIC/EMPLOYEE/SPOUSE 100 | F | MD | 08/07/1964 | 6 | 55 to 59 | 02/27/2021 |
| 53 | 168,386.00 | 171000 | 171 | 5 | BASIC/EMPLOYEE | M | MD | 12/29/1961 | 6 | 55 to 59 | 02/27/2021 |
| 60 | 217,118.00 | 0 | 0 | 0 | NONE | F | MD | 07/25/1956 | 0 | 02/27/2021 | |
| 60 | 184,884.00 | 0 | 0 | 0 | NONE | F | MD | 09/23/1957 | 0 | 02/27/2021 | |
| 60 | 185,204.00 | 0 | 0 | 0 | NONE | F | MD | 11/06/1966 | 0 | 02/27/2021 | |
| 60 | 194,126.00 | 0 | 0 | 0 | NONE | F | MD | 03/29/1968 | 0 | 02/27/2021 | |
| 60 | 178,247.00 | 0 | 0 | 0 | NONE | F | MD | 12/24/1969 | 0 | 02/27/2021 | |
| 60 | 217,118.00 | 0 | 0 | 0 | NONE | F | MD | 10/16/1975 | 0 | 02/27/2021 | |
| 60 | 186,076.00 | 0 | 0 | 0 | NONE | M | DC | 03/04/1971 | 0 | 02/27/2021 | |
| 60 | 157,455.00 | 0 | 0 | 0 | NONE | M | DC | 11/16/1983 | 0 | 02/27/2021 | |
| 60 | 194,230.00 | 0 | 0 | 0 | NONE | M | DC | 08/30/1985 | 0 | 02/27/2021 | |
| 60 | 208,545.00 | 0 | 0 | 0 | NONE | M | MD | 05/17/1956 | 0 | 02/27/2021 | |
| 60 | 155,154.00 | 0 | 0 | 0 | NONE | M | MD | 10/15/1983 | 0 | 02/27/2021 | |
| 60 | 217,118.00 | 0 | 0 | 0 | NONE | M | NJ | 10/27/1959 | 0 | 02/27/2021 | |
| 60 | 187,877.00 | 0 | 0 | 0 | NONE | M | VA | 08/31/1961 | 0 | 02/27/2021 | |
| 60 | 197,278.00 | 0 | 0 | 0 | NONE | M | VA | 08/16/1967 | 0 | 02/27/2021 | |
| 60 | 217,118.00 | 0 | 0 | 0 | NONE | M | VA | 07/31/1968 | 0 | 02/27/2021 | |
| 60 | 190,094.00 | 0 | 0 | 0 | NONE | M | VA | 01/04/1974 | 0 | 02/27/2021 | |
| 60 | 212,531.00 | 0 | 0 | 0 | NONE | M | VA | 01/16/1980 | 0 | 02/27/2021 | |
| 60 | 210,162.00 | 0 | 0 | 0 | NONE | M | VA | 04/21/1982 | 0 | 02/27/2021 | |
| 60 | 139,337.00 | 142000 | 142 | 5 | BASIC/EMPLOYEE | M | VA | 01/15/1961 | 6 | 55 to 59 | 02/27/2021 |
| 60 | 140,313.00 | 143000 | 143 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | F | MD | 02/11/1988 | 1 | Under 35 | 02/27/2021 |
| 60 | 152,032.00 | 155000 | 155 | 1 | BASIC ONLY | F | VA | 11/15/1984 | 2 | 35 to 39 | 02/27/2021 |
| 60 | 153,588.00 | 156000 | 156 | 1 | BASIC ONLY | M | VA | 05/10/1980 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 155,850.00 | 158000 | 158 | 21 | BASIC/EMPLOYEE/FAMILY 3X | M | VA | 10/23/1968 | 5 | 50 to 54 | 02/27/2021 |
| 60 | 159,469.00 | 162000 | 162 | 9 | BASIC/SPOUSE 100 | M | DC | 01/25/1967 | 5 | 50 to 54 | 02/27/2021 |
| 60 | 160,217.00 | 163000 | 163 | 11 | BASIC/EMPLOYEE/SPOUSE 100 | M | VA | 07/07/1980 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 161,010.00 | 164000 | 164 | 1 | BASIC ONLY | M | MD | 09/11/1981 | 2 | 35 to 39 | 02/27/2021 |
| 60 | 162,396.00 | 165000 | 165 | 11 | BASIC/EMPLOYEE/SPOUSE 100 | M | VA | 09/11/1978 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 163,687.00 | 166000 | 166 | 1 | BASIC ONLY | M | MD | 12/21/1979 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 164,402.00 | 167000 | 167 | 1 | BASIC ONLY | M | VA | 02/03/1973 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 167,479.00 | 170000 | 170 | 1 | BASIC ONLY | M | NY | 03/22/1982 | 2 | 35 to 39 | 02/27/2021 |
| 60 | 172,102.00 | 175000 | 175 | 1 | BASIC ONLY | M | VA | 10/15/1975 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 172,193.00 | 175000 | 175 | 9 | BASIC/SPOUSE 100 | M | VA | 06/23/1980 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 175,656.00 | 178000 | 178 | 33 | BASIC/EMPLOYEE/FAMILY 5X | M | VA | 09/28/1971 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 175,307.00 | 178000 | 178 | 5 | BASIC/EMPLOYEE | M | VA | 11/27/1976 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 176,056.00 | 179000 | 179 | 1 | BASIC ONLY | F | VA | 02/09/1972 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 179,174.00 | 182000 | 182 | 11 | BASIC/EMPLOYEE/SPOUSE 100 | F | DC | 08/07/1971 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 180,352.00 | 183000 | 183 | 23 | BASIC/SPOUSE 100/FAMILY 3X | M | VA | 11/20/1984 | 2 | 35 to 39 | 02/27/2021 |
| 60 | 181,559.00 | 184000 | 184 | 5 | BASIC/EMPLOYEE | M | NJ | 07/25/1967 | 5 | 50 to 54 | 02/27/2021 |
| 60 | 182,070.00 | 185000 | 185 | 1 | BASIC ONLY | M | MD | 10/31/1980 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 184,840.00 | 187000 | 187 | 5 | BASIC/EMPLOYEE | M | VA | 01/04/1974 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 197,180.00 | 200000 | 200 | 11 | BASIC/EMPLOYEE/SPOUSE 100 | M | VA | 03/17/1972 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 200,476.00 | 203000 | 203 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | M | MD | 10/31/1979 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 202,762.00 | 205000 | 205 | 1 | BASIC ONLY | F | VA | 01/10/1962 | 6 | 55 to 59 | 02/27/2021 |
| 60 | 202,183.00 | 205000 | 205 | 1 | BASIC ONLY | F | VA | 06/25/1973 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 204,734.00 | 207000 | 207 | 1 | BASIC ONLY | F | MD | 09/27/1963 | 6 | 55 to 59 | 02/27/2021 |
| 60 | 209,942.00 | 212000 | 212 | 1 | BASIC ONLY | F | VA | 06/22/1962 | 6 | 55 to 59 | 02/27/2021 |
| 60 | 215,491.00 | 218000 | 218 | 2 | BASIC/SPOUSE 50 | M | VA | 05/10/1974 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 217,118.00 | 220000 | 220 | 1 | BASIC ONLY | M | VA | 11/06/1974 | 4 | 45 to 49 | 02/27/2021 |
| 60 | 217,118.00 | 220000 | 220 | 5 | BASIC/EMPLOYEE | M | MD | 01/08/1980 | 3 | 40 to 44 | 02/27/2021 |
| 60 | 217,272.00 | 220000 | 220 | 9 | BASIC/SPOUSE 100 | M | NJ | 07/31/1982 | 2 | 35 to 39 | 02/27/2021 |
| 60 | 222,494.00 | 225000 | 225 | 1 | BASIC ONLY | F | NJ | 03/30/1966 | 5 | 50 to 54 | 02/27/2021 |
| 60 | 233,801.00 | 236000 | 236 | 1 | BASIC ONLY | M | NJ | 07/23/1954 | 7 | 60 and over | 02/27/2021 |
| 70 | 214,958.00 | 0 | 0 | 0 | NONE | F | DC | 05/17/1971 | 0 | 02/27/2021 | |
| 70 | 205,487.00 | 0 | 0 | 0 | NONE | F | MD | 10/22/1960 | 0 | 02/27/2021 | |
| 70 | 224,676.00 | 0 | 0 | 0 | NONE | F | MD | 10/04/1966 | 0 | 02/27/2021 | |
| 70 | 180,626.00 | 0 | 0 | 0 | NONE | F | MD | 06/27/1982 | 0 | 02/27/2021 | |
| 70 | 275,800.00 | 0 | 0 | 0 | NONE | M | DC | 03/09/1945 | 0 | 02/27/2021 | |
| 70 | 217,411.00 | 0 | 0 | 0 | NONE | M | DC | 04/22/1981 | 0 | 02/27/2021 | |
| 70 | 243,939.00 | 0 | 0 | 0 | NONE | M | MD | 02/07/1976 | 0 | 02/27/2021 | |
| 70 | 218,001.00 | 0 | 0 | 0 | NONE | M | MD | 09/07/1979 | 0 | 02/27/2021 | |
| 70 | 229,208.00 | 0 | 0 | 0 | NONE | M | VA | 01/12/1956 | 0 | 02/27/2021 | |
| 70 | 240,855.00 | 0 | 0 | 0 | NONE | M | VA | 11/25/1974 | 0 | 02/27/2021 | |
| 70 | 176,307.00 | 179000 | 179 | 9 | BASIC/SPOUSE 100 | M | DC | 11/14/1982 | 2 | 35 to 39 | 02/27/2021 |
| 70 | 196,231.00 | 199000 | 199 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | M | VA | 03/23/1982 | 2 | 35 to 39 | 02/27/2021 |
| 70 | 202,245.00 | 205000 | 205 | 5 | BASIC/EMPLOYEE | M | MD | 09/03/1960 | 7 | 60 and over | 02/27/2021 |
| 70 | 249,068.00 | 252000 | 252 | 1 | BASIC ONLY | F | VA | 03/25/1963 | 6 | 55 to 59 | 02/27/2021 |
| 70 | 250,181.00 | 253000 | 253 | 11 | BASIC/EMPLOYEE/SPOUSE 100 | M | MD | 09/24/1966 | 5 | 50 to 54 | 02/27/2021 |
| 70 | 271,982.00 | 274000 | 274 | 1 | BASIC ONLY | F | VA | 11/23/1966 | 5 | 50 to 54 | 02/27/2021 |
| 70 | 275,800.00 | 278000 | 278 | 1 | BASIC ONLY | M | MD | 03/06/1968 | 5 | 50 to 54 | 02/27/2021 |
| 70 | 275,800.00 | 278000 | 278 | 16 | BASIC/EMPLOYEE/SPOUSE 50/FAMILY 2X | M | MD | 10/16/1958 | 7 | 60 and over | 02/27/2021 |
| 80 | 283,200.00 | 0 | 0 | 0 | NONE | F | MD | 08/29/1959 | 0 | 02/27/2021 | |
| 80 | 283,200.00 | 0 | 0 | 0 | NONE | M | VA | 05/02/1958 | 0 | 02/27/2021 | |
| 80 | 242,889.00 | 300000 | 300 | 36 | BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5X | M | VA | 05/28/1979 | 3 | 40 to 44 | 02/27/2021 |
| 80 | 275,171.00 | 300000 | 300 | 6 | BASIC/EMPLOYEE/SPOUSE 50 | M | VA | 05/30/1962 | 6 | 55 to 59 | 02/27/2021 |
File details come from the government source that posted it. Updated .