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 |