Census of Covered Lives Under the Group Life Insurance Program - Request for Proposals (RFP) - March 21, 1997

State of Connecticut

EXHIBIT E -
Census of Covered Lives Under the Group Life Insurance Program

Census data of the covered lives are contained in a self-extracting archive at:
lifeacrt.exe

The first of the two files (liferet.txt) contains 21,099 records for state retirees. The second file (lifeact.txt) contains data for 34,906 active state employees. To increase useability these files have been created in ASCII delimited format. Each file contains the following demographic information:

State Bargaining Unit (table follows this Exhibit)
Date of Birth (MM/DD/YY)
Basic Coverage Amount
Supplemental Coverage Amount
Insurance Status: (1 = Active, 04 = Premium Waiver, 05 = LAW, 06 = Judges/Legis., 07 = Pending Disability Waiver, 08 = Workers Compensation) Employee Type (01 = Active, 03 = Retirees)
Compensation Class Code from State Personnel System
1996 Gross Calendar Year Salary (not applicable for retirees)
Sex Code (M, F, or Blank)

STATE OF CONNECTICUT
COMPTROLLERS - TABLES DATA BASE
BARGAINING UNITS
Bargaining
Unit
Description
00 NO UNION AFFILIATION
01 EXEMPT-ELECT ST OFFICIALS
02 MANAGERIAL-CONFIDENTIAL
03 CONFIDENTIAL
04 OTHER NON-COLLECTIVE BARG
05 CSPU-STATE POLICE NP-1
06 CEUI CT EMPL UN IND NP-2
07 AFSCME ADM CLER/NP-3/CO-4
08 AFSCME/CORR OFF/NP-4/CO-4
09 PSEC/PROTECTIVE SVCS NP-5
10 RWDSU/HEALTH CARE NP/NP-6
11 RWDSU/HEALTH CARE PRO/NP1
12 AFSCME/SOCIAL SVCS/P-2/C4
13 CSEA/EDUC ADMINTORS/P-3A
15 CSEA/ENG SCIENC+TECH/P-4
16 AFT/CSFT-ADMIN RESID/P-5
17 AFT/ST VOCATIONAL FACULTY
18 AFSA/ST VOCATIONAL DIR
19 AFT/FED OF TECH COLL TCHR
20 ST TECHNICAL EXEMPT
21 AAUP/CT ST UNIV FACULTY
22 AFSCME/ST UNIV NON FAC AD
23 ST COLLEGE EXEMPT
24 CT HOUSING + FINANCE
25 CCCC/COM COLLEGE FACULTY
26 COMMUNITY COLLEGE EXEMPT
27 HIGHER EDUCATION PROF
28 AAUP/UCONN FACULTY
29 AFT/PROF EMPLS ASSOC
30 E O SMITH HS TCHRS ASSOC
31 UNIVERSITY EXEMPT
32 UNIV HEALTH CENTER EXEMPT
33 UNIV HEALTH CTR FACULTY
34 UNIV LAW SCHOOL FACULTY
35 VETS HOME + HOSP CLASSES
36 AGRICULTURAL EXPERIMENT
37 AGRICULTURAL EXPER EXEMPT
38 OFFICE ATTORNEY GENERAL
39 LEGISLATIVE MANAGEMENT
40 JUDICIAL JUDGES
41 JUDICIAL-MANAGEMENT+CONFID
42 AFT/CSFT-PROF JUDIC EMPLS
43 AFSCME/CT JUDICIAL EMPLS
44 CSEA/JUDICIAL INSPECTORS
45 UCHCPEA/AFT HEALTH CTR
46 CCCC/CONGRESS OF COMM COL
47 ST ACADEMIC AWARDS EXEMPT
49 CONTRACTUAL
50 COMMUNITY COLLEGE MANAGER
51 HIGHER EDUCATION EXEMPT
52 MANAGERIAL ORGANIZED
53 CRIMINAL JUSTICE ATTORNEY
54 CT ASSOC PROSECUTORS
55 AFSCME/ST TECH COLL/COUN4
56 CONN DEV AUTHORITY
57 CRIMINAL JUSTICE-RESIDUAL
58 DEPT HIGHER ED-DIRECTORS
59 DEPT HIGHER ED-ADMINISTNT
63 CONFINED EMP N MANAG PAY
99 NO DESIGNATED UNIT


Back to Table of Contents