Appendix 1 Benefit Administration Services Data.xlsx

XLSX spreadsheet 447 KB Posted Aug 5, 2025

Attached to: Open Market Competitive Sealed Proposal IL|24-416CMS-BENF4-P-77070
Contract number: 24-416CMS-BENF4-P-77070
Issued by: Illinois

About this file

Written by GovTribe AI · Aug 12, 2025

This document is an appendix to a Benefit Administration Services Request for Proposal (RFP) 24-416CMS-BENF4-B for the Illinois Department of Central Management Services. The comprehensive attachment contains detailed operational and administrative data for state employee benefits management, covering multiple state entities including the State of Illinois, Local Government Health Plan (LGHP), Teachers' Retirement Insurance Program (TRIP), and College Insurance Program (CIP).

The document provides extensive volumetric data across multiple dimensions, including call volumes, employee portal visits, newly eligible events, payroll processing, invoicing, and member population metrics. Key highlights include an average of 91,617 monthly pension deductions, 23 current payrolls, 57 pay schedules, and a complex reporting framework with 87 different types of reports ranging from weekly financial reports to annual census analyses. The member population encompasses approximately 368,000 individuals, including state employees, retirees, and their dependents, with coverage options spanning health, dental, life insurance, and flexible spending accounts. The system manages intricate payroll reconciliation processes, with monthly discrepancies averaging 14,483 transactions and financial variances of approximately $745,230 in over/underpayments.

View the file

Other files

File	Type	Posted
Appendix 4 NIGP Code Revision Request Form.pdf	PDF	Aug 5, 2025
Addendum 3 - Benefit Administration Solution RFP ~1.doc	DOC document	Aug 5, 2025
Benefits Adm Solution Price Proposal Worksheet Final.xlsx	XLSX spreadsheet	Aug 5, 2025
Benefits Administration Solution RFP Final Revised 7-30-24.docx	DOCX document	Aug 5, 2025
Addendum 1 - Benefit Administration Solution RFP~2.doc	DOC document	Aug 5, 2025
Addendum 2 - Benefit Administration Solution RFP.doc	DOC document	Aug 5, 2025
Appendix 2 Group Insurance Reimbursement System.pdf	PDF	Aug 5, 2025
U-Plan BEP-VBP V.24.1.pdf	PDF	Aug 5, 2025
Appendix 3 AFSCME Contract 2023-2027 App A and B.pdf	PDF	Aug 5, 2025
NOA B-42679 Benefit Adm Solution updated to reflect estimated value.pdf	PDF	Aug 5, 2025

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.

Front Page

Benefit Administration Platform and Related Services RFP

24-416CMS-BENF4-B-

ILLINOIS DEPARTMENT OF CENTRAL MANAGEMENT SERVICES PROPRIETARY AND CONFIDENTIAL

This document and the information contained herein MUST not be published, disclosed, or used for any other purpose, without the express permission of ILLINOIS DEPARTMENT OF CENTRAL MANAGEMENT SERVICES

Index Index

Tab #	Description
1 Volumetric - Call Data	Summarizes call data for the period from 2021 to 2023 by functional area/group/process
2 Volumetric - Newly Eligible and OE Events	Lists all newly eligible and Open Enrollment events
3. All Events	Lists all events
4. Pre Pay Payroll	Summarizes key volumetric information for benefits admininistration and pre pay payroll processing
5. Post Pay Payroll	Summarizes key volumetric information for benefits admininistration and post pay payroll processing
6. Invoices	Summarizes key volumetric information for benefits admininistration invoicing
7. Member Population	Summarizes headcount by group; includes member only and member + dependent counts as of April 1, 2024
8. Benefit Administration & Payroll Background	Summarizes benefit administration and payroll background information
9. Reporting	Lists the reports (system generated or manual) that CMS expects the Benefits Administrator to provide in the future state

1. Call Volume

Values	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total
Calls Received - 2021	13,301	9,661	10,796	10,396	26,808	17,901	16,907	13,648	12,210	16,082	16,795	11,965	176,470
Calls Received - 2022	12,646	9,475	12,607	11,071	28,997	14,318	12,208	12,836	12,234	17,888	27,570	32,628	204,478
Calls Received - 2023	21,031	11,770	11,552	9,675	24,872	12,043	12,068	12,217	9,990	13,127	13,674	10,388	162,407

Calls Outbound - 2021	603	493	595	343	618	614	538	594	301	394	252	320	5,665
Calls Outbound - 2022	343	486	409	501	497	452	579	350	465	857	916	947	6,802
Calls Outbound - 2023	938	910	701	598	800	1,041	770	909	626	829	859	565	9,546

Employee Portal Visits - 2021	30,371	7,750	10,080	29,027	79,333	26,556	37,747	37,635	35,791	42,066	38,351	30,335	405,042
Employee Portal Visits - 2022	33,715	32,368	47,702	37,237	136,578	37,548	30,562	35,753	30,065	29,981	38,932	31,912	522,353
Employee Portal Visits - 2023	37,065	29,996	31,782	31,100	140,828	33,880	40,215	36,972	30,702	36,319	34,483	27,310	510,652

Average Per Year	181,118
Average Per Benefit Choice	26,892
Average Per Trail	29,083
Average Outbound Per Year	7,338
Average Employee Portal Visits Per Year	479,349

2. Newly Elig and OE Events

Newly Eligible Events
Year	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
2021	985	848	877	844	1076	1215	1576	2081	1399	1082	1006	903	13892	1158
New Hire	749	701	698	624	716	759	785	1458	1115	875	735	690	9905	825
New Member (CIP/TRIP)	72	42	46	61	225	331	665	465	167	74	126	85	2359	197
New Retiree Member (State)	71	19	46	48	59	56	31	57	33	41	34	44	539	45
New Survivor	93	86	87	111	76	69	95	101	84	92	111	84	1089	91
2022	998	804	1137	804	1084	1711	1674	2400	1600	974	1335	1013	15534	1295
New Hire	765	638	962	621	777	1244	912	1782	1348	769	1084	793	11695	975
New Member (CIP/TRIP)	65	54	40	60	186	343	635	473	143	82	91	81	2253	188
New Retiree Member (State)	59	22	40	35	51	49	41	71	35	46	65	64	578	48
New Survivor	109	90	95	88	70	75	86	74	74	77	95	75	1008	84
2023	1171	1138	1197	1098	1407	1605	2409	2307	1992	1626	1506	1306	18762	1564
New Hire	972	971	1049	908	1052	1218	1584	1704	1721	1404	1273	1080	14936	1245
New Member (CIP/TRIP)	70	49	35	69	231	245	683	455	132	92	100	90	2251	188
New Retiree Member (State)	34	33	30	33	52	50	56	62	41	46	57	50	544	45
New Survivor	95	85	83	88	72	92	86	86	98	84	76	86	1031	86
2021 Monthly Average - Newly Eligible Events	1,158
2022 Monthly Average - Newly Eligible Events	1,295
2023 Monthly Average - Newly Eligible Events	1,564
3 Year Monthly Average - Newly Eligible Events	1,339
2021 Total - Newly Eligible Events	13,892
2022 Total - Newly Eligible Events	15,534
2023 Total - Newly Eligible Events	18,762
3 Year Total - Newly Eligible Events	48,188

Open/Annual Enrollment Events
Event Description	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
Annual Enrollment (Benefit Choice Enrollment)	961	301	179	75	87	151284	2990	1071	3234	263	669	109	161223	13435
TRAIL Enrollment	400	123	101	39	24	19	17	23	327	47	137308	1073	139501	11625
Annual Enrollment (Benefit Choice Enrollment)	99	64	113	94	92	149315	3161	1031	318	190	123	143	154743	12895
TRAIL Enrollment	394	149	159	80	47	39	44	48	76	26	27	142648	143737	11978
Annual Enrollment (Benefit Choice Enrollment)	128	128	125	206	133	150100	3394	1384	415	342	270	189	156814	13068
TRAIL Enrollment	482	169	120	48	20	41	28	28	21	48	146020	723	147748	12312
Benefit Choice Average Events (30 day period May/June)	150,233
TRAIL Enrollment Average Events (30 day period October/November)	141,992

3. All Events

Events 2021
Event Description	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
Address Change MAPD	25	22	26	40	45	45	37	70	51	41	66	36	504	42
Address Change MAPD- Dependent	1			2	2	3	1	5	4	1	3	3	25	3
Address Change Non MAPD	146	123	280	258	351	324	258	350	331	341	266	265	3293	274
Administrative Changes	263	286	227	231	212	311	248	329	300	274	234	291	3206	267
Plan Year Rate Recalc	189	60	68	23	19	12	11	203750	1820	222	1718	112	208004	17334
Birth, Adoption or Legal Guardianship	162	146	183	189	155	214	127	259	196	177	200	189	2197	183
COBRA Annual Enrollment												1	1	1
COBRA Enrollment	12	12	12	16	18	11	32	17	26	18	26	11	211	18
COBRA Termination	1	1		3	1			3					9	2
COBRA Term for Non-Payment	2	18	17	6		1	1		10	5			60	8
COBRA Voluntary Coverage Termination	5	10	9	13	12	12	10	23	12	10	13	18	147	12
Significant change in daycare costs	6	6	6		2	1	1	18	6	5	4	14	69	6
DCAP Mid-Year Enrollment / Change - IRS Extension	22	5	4	32	125	35	2		3		1		229	25
Dependent Aging Out of Coverage	396	389	375	336	57	108	26	1351	495	407	340	297	4577	381
Dependent Data Change	162	158	168	133	231	133	49	338	232	229	221	188	2242	187
Death of a Dependent	131	98	114	88	77	61	66	109	110	108	104	60	1126	94
Drop Dependent CIP/TRIP	2	2	1	2	3	4	1	5	6	1	3	5	35	3
DEVA Reinstatement	3	5	3	2				1	2	1		1	18	2
DEVA Failure to Recertify	8	5	4	3	1	1	1	3	4	1	1		32	3
Disability	38	33	30	36	29	24	20	52	29	36	45	21	393	33
Disability of Child Certification	1	2		1				2	1	2	1		10	1
Add Disabled Dependent Child								1	1				2	1
Divorce/Legal Separation MAPD		1		2	2	4		6	2	3	2		22	3
Divorce/Legal Separation Non MAPD	32	25	30	21	41	30	30	42	36	41	39	32	399	33
Dual Enrollment Changes	2	3	3				1	3	3	1	1		17	2
Participant Data Change	2230	676	807	475	584	217211	3250	1389	2863	803	1089	54524	285901	23825
Death of Member	602	518	546	468	469	447	558	516	524	473	583	515	6219	518
EOI Approval/Denial for Spouse Life	186	79	95	66	51	65	17	63	115	431	279	112	1559	130
EOI Approval/Denial for Supplemental Life	472	251	298	284	174	223	111	224	326	1262	971	466	5062	422
Payroll Generation	737	330	798	253	249	337	131	359	646	301	496	293	4930	411
Full Time to Part Time	24	19	32	21	34	19	18	25	40	49	31	23	335	28
Gain of other coverage	76	66	68	26	40	62	32	142	95	73	71	110	861	72
Gain of dependent eligibility	73	56	66	55	49	43	58	129	95	88	91	98	901	75
Gain of Medicare	49	44	33	20	22	19	15	40	65	18	19	18	362	30
Temporary Guardianship Verification		1						1	2		2		6	2
HSA Update Event	4	3	3	3	4		1	12	17	20	15	14	96	9
Commence Leave of Absence Non Military	305	294	470	521	1601	550	292	616	410	434	354	263	6110	509
Commence Leave of Absence Military	51	49	59	51	54	41	40	50	24	47	37	27	530	44
Legal Guardianship								1	1	1	1	1	5	1
Life Insurance Volume Reduction	843	280	170	133	16	40	12	723	390	179	169	180	3135	261
Local COBRA Enrollment		1	1	1	3	1	2	1		3		1	14	2
Loss of other coverage	66	43	60	43	53	57	43	98	75	66	65	79	748	62
Loss of dependent eligibility	44	44	38	27	28	20	34	64	55	50	50	50	504	42
Loss of Medicare		2		2				2	1	1			8	2
MAPD FY19 Benefit Choice (Dental & Life)	1			1				1	54	10	1		68	11
MAPD Intial Eligibility					38	23	123	521	360	477	285	102	1929	241
MAPD Initial Eligibility						32	13	39	7			24	115	23
MAPD Initial Eligibility/							5	62	97	84	36	34	318	53
MAPD Initial Enrollment (Ended 12/31/2020)	558	125	52	15	15	21	8	3	178	14	7	2	998	83
MAPD Initial Enrollment	126	414	1506	489	987	543	282	323	43	141	273	342	5469	456
MAPD Late Enrollment (Ended 12/31/2020)	121	40	28	7	5	13	6	1	51	4	4	4	284	24
MAPD Late Enrollment	232	126	115	59	79	86	31	117	54	73	90	77	1139	95
Marriage CIP/TRIP			1			1		1		1	2	1	7	1
Marriage Non MAPD State	53	25	42	36	39	63	31	105	71	70	69	61	665	55
Marriage MAPD State	3		2	3	1	5			1		4	6	25	3
MCAP Mid-Year Enrollment / Change - IRS Extension	34	5	4	65	304	90	13	2	1		6		524	52
Medicare Attainment	520	857	1233	56	59	259	236	1224	680	1127	89	532	6872	573
MAPD/TRAIL Disenrollment	45	112	111	94	57	63	49	61	88	53	114	126	973	81
Change in Medicaid/Medicare/CHIP Eligibility	3	4	3	8	3	1	1	1	5	2		1	32	3
Medicare Eligible New Member (CIP/TRIP)	3	4	3	6	3	6	13	14	11	6	6	2	77	6
Medicare Eligible New Member (CIP/TRIP)	1			1	4	9	4	9	7	10	15	7	67	7
Medicare Eligible New Member (CIP/TRIP)	22	27	34	46	62	84	135	146	55	29	23	34	697	58
Part Time Changes	58	21	12	19	27	13	21	50	35	16	12	15	299	25
Part time to Full Time	40	38	37	42	42	33	29	49	51	54	29	32	476	40
Payroll Change	154	157	147	140	149	172	102	328	205	202	225	838	2819	235
QMCSO	3		3	3	2	1	2	3	3	2	1	2	25	2
Recalc	1		3			1		6			2		13	3
recalc Payroll Deductions	13	29	47	2	129	64	125	5	16	25	1	2	458	38
Rehire	51	41	58	114	53	66	59	121	83	78	131	67	922	77
Reinstatement	7	5	14	16	19	13	8	119	44	9	17	8	279	23
Medicare Eligible Retirement (State)	50	33	49	54	78	46	69	126	126	55	46	137	869	72
Retirement	550	153	330	175	239	220	159	327	261	259	259	318	3250	271
Medicare Eligible Retirement (State)	3	45	42	42	57	31	47	58	44	46	30	38	483	40
Medicare Eligible Retirement (State)	1		5	14	16	27	11	27	49	63	38	41	292	27
Retirement Start	228	162	242	320	306	353	148	701	331	276	302	868	4237	353
Return From Leave Non Military	449	245	379	246	300	302	162	1650	353	292	205	111	4694	391
Return From Disability	26	21	23	26	21	27	10	30	24	21	24	12	265	22
Return From Leave Military	45	36	68	38	29	44	61	48	42	38	30	17	496	41
Current Salary Change	8723	7673	3946	4317	4776	5533	3244	71886	22535	9840	7754	5170	155397	12950
Fixed Annual Salary Decrease	293	110	190	104	140	72	50	279	787	225	180	190	2620	218
New Survivor Initial Enrollment	106	36	55	27	33	25	17	17	14	31	52	44	457	38
Termination	616	413	568	612	621	745	1102	1096	944	880	742	629	8968	747
Term FSA DCAP for LOA	1	2	1										4	1
Term FSA for Non-Payment	26	24	19	20	24	8	3	14	19	17	24	14	212	18
Direct Bill Term for Non-Payment	60	5	59	31	32	156	60	17	52	6	55	17	550	46
TRAIL Reinstatement					1		1	1					3	1
TRAIL State Reinstatement				4									4	4
Voluntary benefit change (Anytime Event)	230	179	200	135	438	282	39	1173	330	354	257	190	3807	317
Age Band Recalculation	1908	1076	1223	1126	253	199	79	4471	1675	1334	838	508	14690	1224
Grand Total	22735	16409	15958	12399	14255	230201	12094	296424	39210	22447	19889	68941	770962	64247

Events 2022
Event Description	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
Address Change MAPD	35	31	39	36	27	35	27	42	24	52	42	54	444	37
Address Change MAPD- Dependent	2	1		1	3	1	2		2	1		6	19	2
Address Change Non MAPD	278	277	305	252	337	294	246	367	303	311	228	243	3441	287
Administrative Changes	333	188	288	236	257	350	203	293	261	355	284	259	3307	276
Plan Year Rate Recalc	98	66	18238	95	81	93	49	39	39	40	31	18380	37249	3104
Birth, Adoption or Legal Guardianship	181	121	207	156	184	224	143	275	190	157	215	188	2241	187
COBRA Enrollment	25	17	21	21	27	16	27	34	23	15	23	12	261	22
COBRA Termination						1			2		1		4	1
COBRA Term for Non-Payment		6	4			6		14				9	39	8
COBRA Voluntary Coverage Termination	13	12	17	13	12	17	10	25	26	23	7	10	185	15
Conversion			1		1					1	1		4	1
Significant change in daycare costs	8	3	13	6	10	6	1	17	6	6	4	9	89	7
Dependent Aging Out of Coverage	336	304	667	373	61	278	149	1061	426	348	264	431	4698	392
Dependent Data Change	156	147	2120	1106	477	299	98	364	208	197	236	206	5614	468
Death of a Dependent	125	94	129	60	85	74	70	78	85	90	110	88	1088	91
Drop Dependent CIP/TRIP	5	2	3	2		3	1	5		1	5	4	31	3
DEVA Reinstatement			1							1			2	1
DEVA Failure to Recertify			1						1	1		1	4	1
Disability	46	22	48	29	38	32	18	39	41	28	18	33	392	33
Disability of Child Certification			1	1	3				1	1			7	1
Add Disabled Dependent Child			1				1						2	1
Divorce/Legal Separation MAPD	1	2	1	1	1	3	4	1	3	1	4	3	25	2
Divorce/Legal Separation Non MAPD	29	16	39	26	41	40	20	30	36	30	25	33	365	30
Dual Enrollment Changes		1		2	1	2			22	6	5	1	40	5
Participant Data Change	1285	670	1065	728	2178	4416	1159	105936	1063	1048	665	831	121044	10087
Death of Member	725	583	596	449	425	458	527	456	497	430	530	520	6196	516
EOI Approval/Denial for Spouse Life	99	59	90	122	87	106	90	452	208	489	137	359	2298	192
EOI Approval/Denial for Supplemental Life	375	216	331	404	339	728	436	1486	657	1453	426	1058	7909	659
Payroll Generation	304	305	465	314	373	412	356	523	367	369	370	305	4463	372
Full Time to Part Time	21	31	35	18	46	29	24	33	36	51	49	22	395	33
Gain of other coverage	121	75	75	41	33	77	41	131	94	72	53	160	973	81
Gain of dependent eligibility	80	58	106	67	75	80	52	118	89	57	74	97	953	79
Gain of Medicare	27	11	21	10	9	13	11	12	11	9	17	7	158	13
Temporary Guardianship Verification			1						1			1	3	1
HSA Update Event	15	14	13	18	35	23	6	36	24	19	15	23	241	20
Commence Leave of Absence Non Military	435	271	555	422	1499	603	229	509	373	326	275	329	5826	486
Commence Leave of Absence Military	28	17	33	27	26	27	15	41	25	42	18	39	338	28
Commence Non State Paid Leave		2	7	12	19	16	15	17	12	13	13	11	137	12
Legal Guardianship						1	1						2	1
Life Insurance Volume Reduction	43	31	399	162	12	325	202	173	174	150	66	231	1968	164
Local COBRA Enrollment		1		1		1						1	4	1
Loss of other coverage	94	66	94	77	65	83	29	103	85	55	84	98	933	78
Loss of dependent eligibility	37	43	55	27	25	20	20	73	65	47	49	54	515	43
Loss of Medicare	1		2				1	1				2	7	1
MAPD FY19 Benefit Choice (Dental & Life)			2			1	1	1	2	1	1	1	10	1
MAPD Intial Eligibility	141	111	100	101	100	118	104	98	139	74	224	222	1532	128
MAPD Initial Eligibility	19	10	24	10	21	20	29	24	40	30	12	5	244	20
MAPD Initial Eligibility/	44	13	12	20	39	31	23	37	44	34	26	47	370	31
MAPD Initial Enrollment (Ended 12/31/2020)	2		2	4		1	1	3		2	1	1	17	2
MAPD Initial Enrollment	387	315	437	408	537	411	443	537	477	400	255	269	4876	406
MAPD Late Enrollment (Ended 12/31/2020)			1			1	1					1	4	1
MAPD Late Enrollment	64	64	82	65	100	73	75	98	97	84	54	226	1082	90
Marriage CIP/TRIP							2	1			2	1	6	2
Marriage Non MAPD State	26	27	48	21	31	65	16	72	66	67	67	53	559	47
Marriage MAPD State	2	4	2	1	2	1	7	4			6	2	31	3
MCAP Mid-Year Enrollment / Change - IRS Extension			2										2	2
Medicare Attainment	527	516	1826	34	56	572	1272	137	552	582	516	523	7113	593
MAPD/TRAIL Disenrollment	82	43	176	85	89	59	66	25	86	108	73	283	1175	98
Change in Medicaid/Medicare/CHIP Eligibility	3	2	4	5	16	5	1	7	2	2	2	2	51	4
Newly Eligible Leave		1	18	12	10	9	6	3	11	5	8	14	97	9
Medicare Eligible New Member (CIP/TRIP)	7	3	5	3	4		7	5	8	8	5	6	61	6
Medicare Eligible New Member (CIP/TRIP)	5	1	7	5	5	7	6	12	1	3	12	4	68	6
Medicare Eligible New Member (CIP/TRIP)	22	18	28	29	65	89	114	109	36	17	27	23	577	48
Part Time Changes	70	32	22	22	16	26	6	57	40	24	20	10	345	29
Part time to Full Time	39	43	76	26	60	27	25	49	49	49	36	22	501	42
Payroll Change	189	182	310	186	189	231	172	332	294	230	226	330	2871	239
QMCSO	5	1	5	4	5	3	5	5	1	2	1	3	40	3
Recalc			1	1	1		1		1	2	1	3	11	1
recalc Payroll Deductions		1	5		3	1	112	19	24	17	1	1	184	18
Rehire	74	52	82	65	91	110	65	176	143	96	136	93	1183	99
Reinstatement	22	14	15	18	12	10	8	115	49	28	24	16	331	28
Medicare Eligible Retirement (State)	66	58	48	101	66	87	70	76	51	45	59	134	861	72
Retirement	328	130	361	183	197	197	205	312	125	260	168	270	2736	228
Medicare Eligible Retirement (State)	125	62	48	30	25	21	21	26	25	29	23	25	460	38
Medicare Eligible Retirement (State)	74	17	46	44	35	24	31	55	24	30	27	27	434	36
Retirement Start	165	156	351	339	223	362	375	294	270	227	270	782	3814	318
Return From Leave Non Military	316	190	314	240	235	280	131	1357	260	229	215	163	3930	328
Return From Disability	38	24	32	34	19	13	15	24	22	27	24	18	290	24
Return From Leave Military	19	14	14	15	12	20	13	15	24	13	10	10	179	15
Current Salary Change	7806	4273	7649	5065	6153	6267	3526	72561	26533	9842	6250	5893	161818	13485
Fixed Annual Salary Decrease	207	102	221	123	108	70	95	160	113	247	147	168	1761	147
New Survivor Initial Enrollment	55	36	40	38	38	34	20	52	29	41	34	22	439	37
Termination	635	681	850	729	725	1035	962	1146	885	697	600	655	9600	800
Term FSA DCAP for LOA			1										1	1
Term FSA for Non-Payment	13	28	24	14	21	8	5	5	23	10	14	13	178	15
Direct Bill Term for Non-Payment	8	27	91	7	17	40	134	91	58	59	9	45	586	49
TRAIL Reinstatement	1				1				1		1		4	1
TRAIL State Reinstatement	1		3	2		9			1				16	3
Voluntary benefit change (Anytime Event)	242	167	446	236	1034	315	140	345	212	160	272	257	3826	319
Age Band Recalculation	495	335	3857	1137	431	771	452	3379	1331	1282	533	1945	15948	1329
Grand Total	17685	11516	43775	14777	17684	20616	13046	194608	37629	21358	14736	36706	444136	37011

Events 2023
Event Description	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
Address Change MAPD	51	33	37	23	17	25	25	25	28	11	2	1	278	23
Address Change MAPD- Dependent	3	9	6		1	2	3	1	7	4	2		38	4
Address Change Non MAPD	267	246	319	316	314	328	356	291	256	282	235	321	3531	294
Administrative Changes	324	279	275	228	334	309	346	302	273	243	234	191	3338	278
Age Band Rate Change						1	1						2	1
Plan Year Rate Recalc	239	96	76	93	92	66	51	43	34	52	60	20341	21243	1770
Birth, Adoption or Legal Guardianship	168	151	206	136	173	177	159	217	148	210	182	159	2086	174
COBRA Enrollment	9	12	25	12	23	25	17	32	16	19	21	17	228	19
COBRA Termination	12		1		1		1	7		6	3	3	34	4
COBRA Term for Non-Payment		6			9	9		9	5	5	5		48	7
COBRA Voluntary Coverage Termination	26	13	11	5	20	10	10	29	7	12	11	12	166	14
Conversion			3										3	3
Significant change in daycare costs	5	3	3	5	1	3	8	9	10	8	4	3	62	5
DCAP Mid-Year Enrollment / Change - IRS Extension				1									1	1
Dependent Aging Out of Coverage	380	410	407	376	50	309	715	270	408	492	174	173	4164	347
Dependent Data Change	230	181	460	365	373	193	197	215	195	242	208	186	3045	254
Death of a Dependent	102	104	115	74	128	74	88	117	76	93	93	88	1152	96
Drop Dependent CIP/TRIP	1	1	1	1	3	4	4	2	3	1	4	6	31	3
DEVA Reinstatement							1		1				2	1
DEVA Failure to Recertify				2			1		1	1	1		6	1
Disability	28	23	23	29	23	46	36	37	21	38	32	36	372	31
Add Disabled Dependent Child									1				1	1
Divorce/Legal Separation MAPD	2	5	2	1		4	3	1	2	2		2	24	2
Divorce/Legal Separation Non MAPD	23	42	28	29	39	29	24	35	25	45	27	34	380	32
Dual Enrollment Changes	7	7	3		3	1	4	2	17	5	1	2	52	5
Participant Data Change	781	876	653	1030	843	1303	106712	2235	1308	836	1223	571	118371	9864
Death of Member	655	488	511	499	456	486	471	503	499	436	543	507	6054	505
EOI Approval/Denial for Spouse Life	68	79	84	128	79	98	196	297	110	726	69	61	1995	166
EOI Approval/Denial for Supplemental Life	298	300	313	436	375	528	695	1050	278	2013	351	218	6855	571
Payroll Generation	336	258	346	301	248	462	419	352	385	306	360	711	4484	374
Full Time to Part Time	19	27	42	30	67	26	25	30	33	64	40	26	429	36
Gain of other coverage	120	74	58	47	51	44	54	96	55	61	71	138	869	72
Gain of dependent eligibility	84	83	76	70	85	55	86	109	72	98	82	134	1034	86
Gain of Medicare	10	17	28	11	5	4	3	4	2	3	1	8	96	8
Temporary Guardianship Verification	1												1	1
HSA Update Event	27	13	17	17	37	12	31	38	29	23	32	32	308	26
Commence Leave of Absence Non Military	326	327	365	536	1435	602	325	347	353	357	377	276	5626	469
Commence Leave of Absence Military	27	23	33	43	27	25	17	30	35	30	20	30	340	28
Commence Non State Paid Leave	14	4	11	10	20	14	15	9	7	13	19	16	152	13
Legal Guardianship					1								1	1
Life Insurance Volume Reduction	165	143	165	148	10	317	178	197	197	169	64	245	1998	167
Local COBRA Enrollment	2	1	1	1	1	1		1		1	1	1	11	1
Loss of other coverage	123	50	85	52	85	61	69	120	90	58	88	140	1021	85
Loss of dependent eligibility	59	25	42	14	33	28	36	58	46	42	51	58	492	41
Loss of Medicare	1	2	1						1				5	1
MAPD FY19 Benefit Choice (Dental & Life)			1						1	1			3	1
MAPD Intial Eligibility	132	93	97	99	88	117	117	84	53	98	102	83	1163	97
MAPD Initial Eligibility	12	30	22	9	18	16	25	13	11	10	12	2	180	15
MAPD Initial Eligibility/	62	136	35	31	13	10	15	13	27	18	10	18	388	32
MAPD Initial Enrollment (Ended 12/31/2020)	3	1	2	4	1	3	2	1			1	2	20	2
MAPD Initial Enrollment	260	382	423	344	396	389	455	503	439	388	379	332	4690	391
MAPD Late Enrollment (Ended 12/31/2020)	3	1		2	1		1				1		9	2
MAPD Late Enrollment	171	162	154	108	114	93	93	103	77	85	86	88	1334	111
Marriage CIP/TRIP		2			1		2	2	1	1		1	10	1
Marriage Non MAPD State	44	29	29	25	35	43	50	56	49	79	90	57	586	49
Marriage MAPD State	2		4	5	4	2	1	8	1	2	1	2	32	3
MCAP Mid-Year Enrollment / Change - IRS Extension						1		1		1			3	1
Medicare Attainment	558	513	1593	46	31	587	585	664	589	486	518	515	6685	557
MAPD/TRAIL Disenrollment	269	156	150	117	125	66	52	88	81	63	185	212	1564	130
Change in Medicaid/Medicare/CHIP Eligibility	5	9	4	4	6	4	1	3	4	4	3	5	52	4
Newly Eligible Leave	9	8	19	20	23	14	10	17	11	15	9	5	160	13
Medicare Eligible New Member (CIP/TRIP)	2	4	4	6	4	3	6	10	7	8	1	3	58	5
Medicare Eligible New Member (CIP/TRIP)	4	1	3	3		2	1	4		1	7	3	29	3
Medicare Eligible New Member (CIP/TRIP)	20	17	13	24	49	64	106	104	45	31	17	40	530	44
Part Time Changes	55	38	15	17	29	25	16	43	66	24	37	20	385	32
Part time to Full Time	30	36	41	40	57	34	37	43	43	70	47	34	512	43
Payroll Change	215	208	303	211	203	239	211	217	258	213	226	219	2723	227
QMCSO	1	4		6	2		1	1	2	1		3	21	2
Recalc	2	2	5	4	1	4	1	1	1	3		1	25	2
recalc Payroll Deductions	1	4	2	3	95	78	172	13	16	15	1	2	402	34
Rehire	104	126	105	102	109	142	127	156	199	146	150	136	1602	134
Reinstatement	21	14	21	21	14	25	26	110	39	22	27	22	362	30
Medicare Eligible Retirement (State)	45	45	78	66	76	80	80	97	75	54	69	142	907	76
Retirement	411	133	265	156	183	153	217	249	111	162	186	346	2572	214
Medicare Eligible Retirement (State)	49	52	47	28	39	33	46	34	41	31	31	35	466	39
Medicare Eligible Retirement (State)	25	24	54	22	27	35	33	48	41	34	39	41	423	35
Retirement Start	205	141	246	271	250	316	259	274	204	175	319	612	3272	273
Return From Leave Non Military	199	184	230	373	216	248	208	1249	284	221	247	189	3848	321
Return From Disability	13	13	17	28	18	26	33	19	31	28	24	21	271	23
Return From Leave Military	14	12	5	9	10	11	9	13	25	12	6	5	131	11
Current Salary Change	6810	5210	4351	7258	7317	5975	13214	4761	44341	36903	12581	6908	155629	12969
Fixed Annual Salary Decrease	265	98	182	128	128	77	121	158	99	161	135	213	1765	147
New Survivor Initial Enrollment	49	39	39	39	34	37	59	38	45	38	39	37	493	41
Termination	657	623	693	621	829	961	1042	1141	798	697	697	868	9627	802
Term FSA DCAP for LOA	1												1	1
Term FSA for Non-Payment	13	16	11	18	13	7	1	10	10	15	19	10	143	12
Direct Bill Term for Non-Payment	44	9	86	13	39	219	21	7	77	59	60	41	675	56
TRAIL Reinstatement	1												1	1
Voluntary benefit change (Anytime Event)	217	173	175	209	588	195	182	191	167	251	234	178	2760	230
Age Band Recalculation	1175	1059	1179	1147	454	717	2734	853	1353	1631	566	538	13406	1117
Grand Total	17171	14218	15535	16706	17102	16732	131754	18520	54756	49264	21853	36736	410347	34196

2021 Monthly Average - Events	64,247
2022 Monthly Average - Events	37,011
2023 Monthly Average - Events	34,196
3 Year Monthly Average	45,151
2021 Total - Events	770,962
2022 Total - Events	444,136
2023 Total - Events	410,347
3 Year Total - Events	1,625,445

4. Pre Pay Payroll

2021 Pre-Payroll
Paygroup	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
CIP	204	153	144	131	159	425	207	196	183	174	160	1029	3165	264
CP1	257	167	174	174	171	255	2126	831	192	213	221	140	4921	410
CP10A	775	312	338	246	96	325	1495	1262	2851	568	413	1769	10450	871
CP13	120	56	449	70	27	102	421	399	546	122	123	211	2646	221
CP2	795	707	676	737	725	794	7840	3852	900	850	842	682	19400	1617
CP3	132	181	94	100	87	81	1012	454	102	123	115	71	2552	213
CP4	458	360	344	325	337	375	3801	1481	393	383	378	343	8978	748
CP5	85	67	29	30	72	77	580	270	69	86	35	78	1478	123
CP7	95	45	78	71	33	78	465	668	97	38	81	128	1877	156
CRT10M	149	81	44	35	29	23	1072	1000	627	67	79	23	3229	269
CRT10SM	94	35	45	21	16	22	488	421	443	99	84	155	1923	160
CSUSMA	976	965	959	962	954	943	928	868	914	920	906	889	11184	932
CSUSMD	221	219	216	216	215	212	210	210	208	208	208	211	2554	213
DES9	304	257	270	282	276	275	2212	1024	318	306	301	203	6028	502
DHS10	10795	10727	5722	5693	7054	2996	18212	12734	2857	4927	2748	3521	87986	7332
DHS4	1977	1850	1006	1008	1410	829	7475	5145	927	1641	913	1363	25544	2129
DHS5	8550	8269	4306	4442	7878	3810	19529	12769	3230	4626	2206	2551	82166	6847
DOT1	300	95	90	110	137	140	1835	788	122	141	143	145	4046	337
DOT2	686	169	144	153	178	200	4344	1729	195	187	187	160	8332	694
DOT4	136	97	92	75	102	114	1960	271	156	131	135	106	3375	281
DOT7	189	76	135	154	70	156	1094	1291	678	73	193	241	4350	363
EIUBWD	323	317	339	327	350	580	367	564	551	607	550	472	5347	446
EIUMA	383	378	369	484	385	428	686	365	436	593	422	393	5322	444
GSUSMA		1	1	1			1	1			2		7	1
GSUSMD	152	255	227	136	158	161	745	711	886	139	136	157	3863	322
HFS2	488	418	404	393	391	408	3690	1496	1122	547	512	432	10301	858
IOC10A	598	588	294	301	575	293	1103	287	248	480	232	471	5470	456
IOC10AM	98	92	104	80	73	69	271	136	237	72	57	60	1349	112
ISP1	186	313	213	236	277	355	3256	1610	712	753	589	641	9141	762
ISP4	196	86	170	80	196	183	1021	1792	155	194	113	146	4332	361
ISPTH	66	61	61	72	59	64	317	155	57	55	27	41	1035	86
ISUMA	371	200	111	88	89	451	1385	213	670	204	121	110	4013	334
ISUSMA	43	42	19	17	39	20	90	31	477	69	29	153	1029	86
ISUSMD	234	83	45	50	265	72	1015	45	1039	120	68	118	3154	263
NEIUBWD	88	81	82	43	91	418	360	195	66	62	89	923	2498	208
NEIUSMA	421	149	147	88	139	211	906	314	252	671	471	177	3946	329
NIUSMA	1412	1441	695	698	1480	640	1847	634	1804	1642	748	1483	14524	1210
NIUSMD	627	599	293	308	617	278	1221	280	322	822	331	703	6401	533
SERSDB	45		29	37		80		637	208		200	34	1270	159
SERSRS	4286	2	3738	3335	5	67907	12	6538	24618	5	3266	47252	160964	13414
SIUCSMBW	887	1728	1642	1665	1724	1598	2301	1653	1600	1593	2615	819	19825	1652
SIUCSMM	3	775	900	716	1	809	1911	848	962	813	1308	793	9839	820
SIUCSMSM	652	2337	638	1298	1310	654	1324	652	2352	2096	2089	1369	16771	1398
SIUEBWD	507	518	502	495	488	473	310	751	582	482	474	476	6058	505
SIUESMA	3049	1554	2458	2779	1225	2514	3563	3127	3109	1589	2731	4521	32219	2685
SOS3	1570	386	409	447	441	977	6984	1356	498	543	418	483	14512	1209
SURSDB	21	11	9	11	14	7	86	5	17	7	8	5	201	17
SURSE	293	51	41	79	54	191	148	64	187	60	68	35	1271	106
SURSRS	1991	1372	1409	1396	1530	38365	1872	1725	1810	1645	1889	26632	81636	6803
TRSR	926	81	78	82	78	79	1031	79	78	82	74	76	2744	229
UOFIA	36	42	42	42	40	38	38	47	37	37	37	37	473	39
UOFIBW	3455	5158	2073	3890	3164	14555	1516	3286	1512	4411	3315	2700	49035	4086
UOFICES	3	3		1	1			1		1	2		12	2
UOFIF	135	136	134	135	139	134	141	139	136	142	132	131	1634	136
UOFIM	3674	1373	525	1105	1104	1106	14771	2331	2254	11445	2141	1816	43645	3637
WIUBWD	53	42	42	27	45	71	349	69	69	46	63	359	1235	103
WIUMD	159	39	31	27	84	135	2	89	138	134	51	44	933	78
WIUSMD	44	33	21	70	100	46	43	29	243	47	27	50	753	63
Grand Total	54773	45633	33650	36074	36757	146602	131989	79918	65452	48091	35876	108131	822946	68579
2022 Pre-Payroll Data
Paygroup	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
CIP	198	168	175	165	161	1320	204	173	178	156	147	5740	8785	732
CP1	237	193	371	241	219	334	2158	1304	312	276	254	408	6307	526
CP10A	367	202	708	991	397	635	2301	4103	896	667	339	1998	13604	1134
CP13	65	35	141	195	62	105	139	604	108	120	149	229	1952	163
CP2	957	860	1512	863	973	998	7834	4688	1238	1072	1099	1763	23857	1988
CP3	122	176	174	101	99	109	992	662	132	134	133	182	3016	251
CP4	361	384	653	139	374	309	3563	2154	545	459	441	477	9859	822
CP5	50	39	30	36	31	84	331	345	318	100	40	121	1525	127
CP7	48	99	62	106	72	77	458	921	202	58	54	249	2406	201
CRT10M	72	72	62	244	19	49	992	1070	81	73	72	251	3057	255
CRT10SM	67	107	77	215	105	106	981	647	255	69	188	295	3112	259
CRT10SMD									48	28	26	53	155	39
CSUSMA	883	870	869	861	859	821	388	792	811	818	821	819	9612	801
CSUSMD	212	210	210	210	210	210	209	211	211	207	205	102	2407	201
DES9	324	315	439	281	315	217	2160	1285	272	377	363	419	6767	564
DHS10	3361	3735	6020	3179	4620	4507	16731	24594	3690	3631	4014	5398	83480	6957
DHS4	1270	1660	2231	1187	1660	1768	7215	10666	1670	1646	1654	2329	34956	2913
DHS5	2140	3212	4902	2728	5488	4866	17721	25354	3130	3996	4240	4900	82677	6890
DOT1	317	140	289	117	132	154	1842	1010	168	163	172	286	4790	399
DOT2	614	221	538	190	209	206	4154	2233	249	242	210	587	9653	804
DOT4	144	132	286	109	138	122	1827	1032	162	148	169	259	4528	377
DOT7	91	175	163	333	178	179	855	1724	887	309	280	937	6111	509
EIUBWD	552	456	547	548	489	510	238	499	538	483	466	480	5806	484
EIUMA	365	684	671	503	394	430	680	403	760	437	419	543	6289	524
GSUSMA												1	1	1
GSUSMD	70	142	120	1239	1222	1225	1237	1288	1224	377	230	400	8774	731
HFS2	539	622	863	528	466	487	3610	2115	543	543	577	856	11749	979
IOC10A	234	447	447	516	436	406	1556	465	1036	233	476	927	7179	598
IOC10AM	59	54	51	96	50	45	224	122	274	62	57	98	1192	99
ISP1	622	726	958	665	597	828	3176	1960	627	744	678	898	12479	1040
ISP4	161	84	102	40	208	232	958	1136	1065	249	108	412	4755	396
ISPTH	42	46	86	89	59	64	331	189	52	58	67	87	1170	98
ISUMA	224	1336	133	322	127	472	1121	138	1522	183	1282	121	6981	582
ISUSMA	530	45	39	47	47	51	667	78	74	531	38	175	2322	194
ISUSMD	39	73	56	125	362	119	919	169	431	608	67	216	3184	265
NEIUBWD	812	768	482	82	188	894	1576	1192	188	395	1066	337	7980	665
NEIUSMA	646	7	9	4	8	3	2	2					681	85
NIUSMA	764	1100	763	1410	746	724	1994	747	793	892	768	1769	12470	1039
NIUSMD	335	338	337	642	325	329	1301	317	343	333	325	644	5569	464
SERSDB		34	32		40	29	3	499			2	109	748	94
SERSRS	5	4163	3666	8	3110	3142	12	3565	21	8	19	53262	70981	5915
SIUCSMBW	1667	1610	1656	1601	1623	1588	855	2559	1700	1623	1764	928	19174	1598
SIUCSMM	792	1982	817	1193	845	1086	1830	1100	2027	2	1402	898	13974	1165
SIUCSMSM	711	692	670	2028	673	691	2619	1073	1705	984	2131	729	14706	1226
SIUEBWD	242	240	479	474	481	466	505	885	246	469	458	469	5414	451
SIUESMA	1770	2874	2507	1231	2487	2789	1249	2827	3369	2500	2549	4305	30457	2538
SOS3	331	356	1174	510	580	512	6566	4623	634	564	895	847	17592	1466
SURSDB	7	5	9	9	6	5	62	7	66	9	6	5	196	16
SURSE	228	58	54	54	55	31	314	190	82	51	43	31	1191	99
SURSRS	1872	21377	21376	2186	1823	10320	1952	1828	1601	1786	1374	27381	94876	7906
TRSR	908	80	88	97	79	99	259	97	96	94	92	108	2097	175
UOFIA	37	37	37	37	37	35	37	36	36	37	37	37	440	37
UOFIBW	3494	3017	685	2651	3676	13825	4107	1845	24622	3362	3712	4906	69902	5825
UOFICES								1					1	1
UOFIF	126	130	130	129	131	128	142	128	154	137	121	131	1587	132
UOFIM	14	1472	733	3049	1306	1376	13546	2657	14559	10250	1986	5589	56537	4711
WIUBWD	83	58	40	59	276	68	353	390	40	72	66	209	1714	143
WIUMD	40	52	42	124	124	93	1	137	639	403	40	123	1818	152
WIUSMD	9	25	20	41	243	157	315	25	58	26	21	58	998	83
Grand Total	30230	58195	59791	34828	39640	60435	127372	120864	76688	43254	38412	135891	825600	68800
2023 Pre-Payroll Data
Paygroup	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
CIP	170	188	156	154	164	1229	173	178	172	124	120	5790	8618	718
CP1	262	296	279	291	265	320	2264	342	922	495	328	503	6567	547
CP10A	368	428	716	507	786	3944	737	3354	1454	451	476	2152	15373	1281
CP13	58	77	142	110	119	693	141	616	126	64	55	610	2811	234
CP2	979	1205	1107	1124	1137	1268	8481	1271	3955	2168	1410	2166	26271	2189
CP3	110	139	209	154	141	171	1140	225	428	320	183	270	3490	291
CP4	404	500	422	377	425	455	3804	447	1760	843	510	803	10750	896
CP5	78	47	44	101	48	104	307	98	316	157	61	154	1515	126
CP7	90	188	133	64	128	241	552	606	277	103	172	621	3175	265
CRT10M	175	74	44	126	90	84	1086	1093	86	84	74	262	3278	273
CRT10SM	93	155	132	209	202	153	521	609	233	110	166	300	2883	240
CRT10SMD	17	21	26	28	27	20	130	170	139	26	69	127	800	67
CSUSMA	854	822	820	854	820	1239	410	384	843	434	438	849	8767	731
CSUSMD	200	198	198	205	194	190	95	92	184	92	92	200	1940	162
DES9	324	376	339	294	371	367	2054	402	1116	509	417	555	7124	594
DHS10	3971	3961	3787	3832	4081	4180	24036	3749	6200	12839	4165	6402	81203	6767
DHS4	1663	1711	1795	1667	1676	1789	10648	1951	4058	6256	2145	3132	38491	3208
DHS5	4202	4353	4281	4411	5003	4894	25570	5166	9971	14718	5688	7532	95789	7982
DOT1	327	143	146	161	142	180	1784	245	353	193	853	369	4896	408
DOT2	589	270	224	225	219	241	3925	330	385	236	209	556	7409	617
DOT4	117	153	136	165	168	185	1925	247	225	183	162	338	4004	334
DOT7	303	516	524	256	557	866	958	1252	620	264	544	845	7505	625
EIUBWD	585	496	467	478	484	792	530	262	522	504	495	255	5870	489
EIUMA	524	442	439	431	437	608	703	694	485	617	557	522	6459	538
GSUSMA		1						2	2	2			7	2
GSUSMD	285	182	169	150	570	441	854	723	423	221	194	194	4406	367
HFS2	552	652	582	570	576	607	3701	663	1916	879	701	1012	12411	1034
IOC10A	365	671	544	252	495	499	493	1296	866	283	742	704	7210	601
IOC10AM	194	49	33	38	23	30	112	105	30	26	32	40	712	59
ISP1	656	777	644	608	574	638	3306	704	606	953	540	893	10899	908
ISP4	227	142	234	109	243	394	958	236	903	383	126	384	4339	362
ISPTH	64	77	62	57	58	58	293	86	67	87	69	83	1061	88
ISUMA	375	320	126	107	109	515	1167	1111	729	233	130	137	5059	422
ISUSMA	63	44	41	87	36	49	73	60	127	56	53	201	890	74
ISUSMD	63	97	56	114	60	111	935	115	264	92	85	238	2230	186
NEIUBWD	161	174	80	184	1718	1041	1123	909	794	701	207	1030	8122	677
NEIUSMA						3	1						4	2
NIUSMA	807	789	783	1859	814	775	1332	824	1770	847	1139	1966	13705	1142
NIUSMD	318	315	311	624	308	309	702	285	637	313	299	643	5064	422
SERSDB			30	22	20	1		446	2	21		97	639	80
SERSRS	31	5	3785	3487	3541	13	12	3807	5	3368	8	54081	72143	6012
SIUCSMBW	1668	1745	1621	1621	1687	3617	2848	1033	2094	1971	3618	995	24518	2043
SIUCSMM	1062	884	1151	822	803	936	1931	5	1316	2	1709	1952	12573	1048
SIUCSMSM	1397	688	716	1374	699	737	777	1892	1441	1823	724	1144	13412	1118
SIUEBWD	459	451	455	448	457	229	514	728	462	439	440	217	5299	442
SIUESMA	1269	2503	2449	2580	2585	2382	2787	2692	2363	2289	2411	2282	28592	2383
SOS3	577	569	576	620	624	673	7330	743	925	951	4372	1571	19531	1628
SURSDB	10	5	4	6	13	6	67	59	8	7	6	8	199	17
SURSE	72	52	69	53	55	25	331	76	62	62	59	30	946	79
SURSRS	2264	1946	1812	1857	1828	9991	1841	1840	1819	1625	1649	28043	56515	4710
TRSR	913	94	100	121	97	91	268	99	97	97	96	98	2171	181
UOFIA	37	37	37	38	38	37	38	37	37	38	37	37	448	37
UOFIBW	4350	3774	3743	4167	4247	15671	15021	2271	10698	4131	4718	6186	78977	6581
UOFICES	3			1									4	2
UOFIF	122	121	120	121	120	119	163	164	128	162	124	126	1590	133
UOFIM	8	1886	1617	1640	2793	2286	4	13800	2486	11698	2113	2599	42930	3578
WIUBWD	64	60	29	77	94	69	636	93	68	73	246	159	1668	139
WIUMD	39	47	34	34	62	92	1	567	137	134	47	508	1702	142
WIUSMD	261	23	50	62	23	23	259	35	56	33	27	285	1137	95
Grand Total	35199	35939	38629	40134	43054	66681	141852	61289	68168	75790	46110	143256	796101	66342
2021 Monthly Average - Pre-pay	68,579
2022 Monthly Average - Pre-pay	68,800
2023 Monthly Average - Pre-pay	66,342
3 Year Monthly Average - Pre-pay	67,907
2021 Total - Pre-pay	822,946
2022 Total - Pre-pay	825,600
2023 Total - Pre-pay	796,101
3 Year Total - Pre-pay	2,444,647

5. Post Pay Payroll

Year	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
2021	303675	233201	257302	283322	231224	338209	235932	335038	255810	236297	266148	330075	3306233	275519
CIP	6675	6667	6662	6655	6680	6714	6745	6770	6784	6791	6772	6785	80700	6725
CP1	2370	2333	2341	2348	2356	2373	2362	2342	2320	2325	2331	2326	28127	2344
CP10A	6102	3052	6127	6121	3046	6096	6068	3030	3057	6146	3079	9242	61166	5097
CP13	1112	556	1111	1117	558	1119	1116	558	563	1133	567	1698	11208	934
CP2	8033	8035	8075	8065	8034	8060	8080	8084	8117	8140	8189	8223	97135	8095
CP3	1100	1109	1110	1116	1113	1109	1108	1077	1070	1079	1072	1054	13117	1093
CP4	3869	3864	3863	3861	3863	3865	3858	3878	3900	3899	3874	3864	46458	3872
CP5	600	594	297	295	594	597	599	598	599	596	296	585	6250	521
CP7	821	411	837	848	426	854	841	860	875	433	860	1297	9363	780
CRT10M	1097	1065	1067	1070	1071	1073	1073	1075	1072	1067	1086	1084	12900	1075
CRT10SM	941	473	949	945	470	935	924	460	460	931	467	1402	9357	780
CSUSMA	1003	996	994	996	990	977	934	898	949	951	943	924	11555	963
CSUSMD	221	218	216	216	214	212	210	210	207	208	208	211	2551	213
DES9	2207	2204	2230	2231	2226	2241	2249	2220	2211	2186	2164	2155	26524	2210
DHS10	26523	26540	13325	13336	26580	13226	26326	13159	13031	25930	12973	25677	236626	19719
DHS4	10414	10416	5233	5266	10601	5322	10630	5307	5309	10715	5386	10780	95379	7948
DHS5	26823	26733	13385	13353	26583	13283	26483	13197	13096	26115	13041	25958	238050	19838
DOT1	1807	1803	1813	1825	1841	1850	1853	1849	1848	1852	1859	1883	22083	1840
DOT2	4391	4349	4335	4334	4366	4387	4397	4385	4396	4410	4390	4373	52513	4376
DOT4	1985	1962	1957	1945	1946	1957	1967	1947	1957	1957	1947	1932	23459	1955
DOT7	1973	983	1947	1931	960	1915	1924	1924	1906	948	1853	2760	21024	1752
EIUBWD	683	679	677	683	676	584	579	580	663	653	643	651	7751	646
EIUMA	765	765	761	758	756	763	687	685	759	772	776	756	9003	750
GSUSMA	1	3	3	3	2	2	2	3	2	2	4	2	29	2
GSUSMD	683	1366	1365	1365	1364	1361	1360	1368	1391	1396	1401	2106	16526	1377
HFS2	3705	3685	3710	3714	3722	3727	3746	3747	3740	3749	3744	3756	44745	3729
IOC10A	1619	1628	812	816	1626	812	1616	808	808	1616	805	1611	14577	1215
IOC10AM	272	263	266	271	271	271	271	271	271	271	273	272	3243	270
ISP1	3360	3352	3342	3332	3324	3321	3322	3286	3293	3297	3273	3258	39760	3313
ISP4	2055	1024	2048	1027	2056	2046	1024	3062	2033	2029	1017	2012	21433	1786
ISPTH	330	324	322	321	322	322	318	311	306	300	299	298	3773	314
ISUMA	1731	1731	1724	1722	1718	1713	1385	1343	1673	1615	1604	1598	19557	1630
ISUSMA	801	804	401	402	804	400	873	436	491	982	493	1068	7955	663
ISUSMD	2254	2241	1120	1111	2221	959	1866	936	1084	2152	1068	2120	19132	1594
NEIUBWD	704	701	701	349	691	1014	662	658	651	324	600	1204	8259	688
NEIUSMA	1328	1316	1305	1290	1283	1219	1178	1178	1245	1257	1254	1229	15082	1257
NIUSMA	3897	3890	1942	1942	3866	1787	3557	1772	1923	3872	1934	3849	34231	2853
NIUSMD	1726	1708	849	845	1621	764	1501	740	785	1585	789	1581	14494	1208
SERSDB	653		640	633		1217		1188	581		573	552	6037	755
SERSRS	67725		67641	67655		135471		135996	68131		68203	68825	679647	84956
SIUCSMBW	1499	2993	2973	2983	2962	2755	2735	2820	2885	2890	2895	1470	31860	2655
SIUCSMM		2059	2048	2053		2046	1913	1922	2050	2066	2046	2037	20240	2024
SIUCSMSM	1042	3158	1056	2122	2128	1057	2109	1047	3180	2131	2122	2123	23275	1940
SIUEBWD	690	692	684	674	664	628	310	944	670	665	657	666	7944	662
SIUESMA	3749	1877	3757	3743	1865	3713	3643	3636	3739	1871	3723	5564	40880	3407
SOS3	7803	7766	7789	7783	7761	7744	7753	7734	7774	7752	7740	7771	93170	7764
SURSDB	103	99	95	95	92	86	85	83	85	81	79	77	1060	88
SURSE	326	326	325	490	323	326	162	324	324	319	324	166	3735	311
SURSRS	40298	40285	40272	40300	40464	40572	40678	40704	40696	40778	40796	40865	486708	40559
TRSR	1115	1108	1110	1111	1107	1104	1107	1108	1105	1101	1096	1096	13268	1106
UOFIA	36	42	42	42	40	38	38	40	38	38	38	38	470	39
UOFIBW	25775	25970	12980	39246	26112	25655	25524	25828	13045	26172	26129	26219	298655	24888
UOFICES	3	3		1	1			1		1	2		12	2
UOFIF	137	138	137	139	141	139	139	142	145	149	145	147	1698	142
UOFIM	14895	14978	14921	14920	14869	14852	14885	15002	14935	14769	14653	29049	192728	16061
WIUBWD	721	731	732	370	716	699	667	679	692	695	703	691	8096	675
WIUMD	622	626	622	622	622	624		581	641	636	638	637	6871	625
WIUSMD	502	507	256	515	516	253	490	247	249	499	252	498	4784	399
Year	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
2022	209779	296436	287108	238834	297471	300305	227400	288855	247842	228524	229762	399404	3251720	270977
CIP	6785	6767	6751	6740	6747	6794	6824	6839	6853	6840	6835	6850	81625	6802
CP1	2293	2264	2277	2287	2288	2296	2311	2322	2323	2320	2315	2301	27597	2300
CP10A	3046	3033	6099	9170	3053	6090	3060	6186	6210	6212	3119	9466	64744	5395
CP13	550	547	1102	1651	554	1110	560	1131	1131	1119	560	1672	11687	974
CP2	8187	8118	8166	8217	8254	8300	8296	8253	8262	8287	8303	8400	99043	8254
CP3	1080	1105	1100	1092	1090	1080	1085	1096	1079	1072	1076	1079	13034	1086
CP4	3820	3818	3821	3805	3811	3816	3811	3847	3833	3840	3875	3885	45982	3832
CP5	581	289	283	567	283	574	592	599	599	600	298	597	5862	489
CP7	440	870	875	877	880	886	482	978	1502	503	500	1494	10287	857
CRT10M	1084	1079	1072	1071	1066	1067	1068	1072	1059	1059	1052	1059	12808	1067
CRT10SM	474	950	960	967	968	988	1012	1080	1114	515	506	1523	11057	921
CRT10SMD									48	78	109	345	580	145
CSUSMA	916	902	902	897	893	852	408	811	858	869	876	874	10058	838
CSUSMD	212	210	210	210	210	210	209	211	210	206	204	102	2404	200
DES9	2162	2189	2215	2216	2235	2248	2254	2245	2253	2249	2231	2201	26698	2225
DHS10	25508	25444	25472	25261	25212	25185	25169	25126	24948	24932	24930	24848	302035	25170
DHS4	10764	10807	10843	10823	10848	10861	10842	10853	10848	10782	10786	10837	129894	10825
DHS5	25815	25721	25769	25729	25716	25730	25771	25774	25697	25744	25879	25927	309272	25773
DOT1	1879	1863	1858	1851	1864	1863	1875	1875	1874	1855	1846	1837	22340	1862
DOT2	4312	4265	4249	4232	4226	4219	4215	4184	4177	4169	4151	4125	50524	4210
DOT4	1911	1894	1894	1886	1864	1856	1854	1879	1910	1931	1949	1940	22768	1897
DOT7	909	1808	1800	1804	1790	1771	875	1736	2572	868	866	2626	19425	1619
EIUBWD	649	645	633	640	638	589	284	555	602	590	579	586	6990	583
EIUMA	752	754	741	746	748	746	688	695	760	762	757	757	8906	742
GSUSMA	2	2	2	2	2	2	2	2	2	2	2	2	24	2
GSUSMD	698	1383	1368	1378	1379	1388	1381	1382	1408	1401	1396	1397	15959	1330
HFS2	3729	3711	3722	3718	3699	3719	3733	3737	3737	3761	3808	3829	44903	3742
IOC10A	794	1589	1594	1596	1602	1605	1606	1612	1610	811	1629	2578	18626	1552
IOC10AM	272	271	272	276	271	270	275	278	279	280	281	282	3307	276
ISP1	3263	3250	3268	3271	3274	3296	3375	3322	3282	3326	3407	3403	39737	3311
ISP4	1990	985	996	993	1993	1990	996	2981	1992	1999	999	1933	19847	1654
ISPTH	297	296	310	333	324	321	332	330	324	322	321	320	3830	319
ISUMA	1596	1515	1502	1497	1503	1504	1171	1127	1528	1521	1518	1517	17499	1458
ISUSMA	572	570	572	1141	566	567	1695	577	578	584	578	1163	9163	764
ISUSMD	1061	1054	1047	2090	1047	941	1829	923	1030	1032	1028	2076	15158	1263
NEIUBWD	1815	1814	1801	900	1815	1748	1725	1736	888	1786	2676	1783	20487	1707
NEIUSMA	638	3	3	3	2	2	2						653	93
NIUSMA	1919	1906	1906	3798	1889	1772	3493	1778	1920	1939	1950	3928	28198	2350
NIUSMD	788	789	784	1554	777	735	1401	698	744	750	745	1494	11259	938
SERSDB		546	540		529	516		510				972	3613	602
SERSRS		68858	68657		68647	68662		68856				138633	482313	80386
SIUCSMBW	2940	2944	2953	2935	2927	2791	1388	2824	2907	2892	2900	1479	31880	2657
SIUCSMM	2042	2046	2027	2037	2026	2016	1892	1899	2028		2070	2062	22145	2013
SIUCSMSM	1062	1066	1062	3229	1072	1082	3230	1068	2133	1058	3208	1075	20345	1695
SIUEBWD	334	338	676	678	677	638	614	929	327	638	626	626	7101	592
SIUESMA	1856	3713	3703	1839	3672	3587	1750	3521	3627	3612	3599	5432	39911	3326
SOS3	7705	7638	7613	7595	7614	7590	7568	7579	7622	7639	7629	7646	91438	7620
SURSDB	74	73	73	68	64	64	65	64	66	68	68	66	813	68
SURSE	340	338	333	327	321	166	337	332	500	335	333	168	3830	319
SURSRS	40878	40832	40821	40882	40972	41103	41175	41170	41202	41213	41198	41290	492736	41061
TRSR	1095	1093	1094	1092	1092	1096	1097	1096	1096	1097	1097	1094	13139	1095
UOFIA	38	38	38	38	37	36	36	36	37	38	38	38	448	37
UOFIBW	26132	26192	13113	26424	26293	25860	25901	12976	39987	26750	26834	26930	303392	25283
UOFICES								1					1	1
UOFIF	144	146	147	149	150	144	144	148	152	150	154	158	1786	149
UOFIM		14514	14433	14413	14397	14394	14498	14520	14628	14540	14489	28860	173686	15790
WIUBWD	692	693	698	708	714	685	652	658	334	683	680	676	7873	656
WIUMD	639	638	640	637	635	635		588	641	640	642	642	6977	634
WIUSMD	245	250	248	494	251	249	492	250	511	255	257	521	4023	335
Year	January	February	March	April	May	June	July	August	September	October	November	December	Grand Total	Monthly Average
2023	211898	228702	303185	303427	305723	242426	210562	289437	245336	301689	236869	393207	3272461	272705
CIP	6783	6787	6747	6745	6762	6783	6803	6821	6822	6805	6793	6828	81479	6790
CP1	2277	2257	2270	2275	2286	2308	2342	2382	2401	2449	2467	2483	28197	2350
CP10A	3152	3171	6362	3191	6407	9660	3223	6464	6520	3284	3310	9980	64724	5394
CP13	555	553	1114	554	1108	1676	560	1134	1124	564	558	1681	11181	932
CP2	8349	8340	8418	8524	8529	8602	8698	8773	8875	8993	9072	9121	104294	8691
CP3	1075	1079	1098	1126	1151	1169	1179	1203	1214	1231	1242	1250	14017	1168
CP4	3892	3922	3932	3914	3896	3909	3909	3914	3935	3985	4016	4025	47249	3937
CP5	596	297	304	606	305	613	307	623	624	623	315	641	5854	488
CP7	493	1002	1019	515	1047	1599	553	1125	1119	566	1150	1144	11332	944
CRT10M	1082	1047	1052	1077	1077	1084	1085	1088	1076	1075	1075	1076	12894	1075
CRT10SM	506	1005	1012	1015	1022	1033	520	1039	1565	524	1043	1568	11852	988
CRT10SMD	118	236	239	248	249	253	130	281	464	163	332	507	3220	268
CSUSMA	873	876	876	882	883	1301	436	411	896	461	465	910	9270	773
CSUSMD	200	198	198	205	196	192	95	92	186	93	93	204	1952	163
DES9	2157	2116	2105	2089	2101	2134	2130	2136	2138	2133	2146	2133	25518	2127
DHS10	24727	24727	24775	24694	24650	24557	24424	24392	24434	24439	24514	24645	294978	24582
DHS4	10814	10875	10978	10857	10869	10902	10975	11289	11472	11578	11706	11855	134170	11181
DHS5	25882	25864	25947	26003	26095	26131	26287	26533	26747	27125	27444	27656	317714	26476
DOT1	1817	1795	1792	1792	1788	1797	1802	1796	1808	1827	1837	1868	21719	1810
DOT2	4062	3984	3973	3967	3962	3963	3970	3984	3982	3980	3971	3968	47766	3981
DOT4	1920	1909	1906	1897	1913	1943	1951	1953	1955	1974	2021	2043	23385	1949
DOT7	872	1705	1702	861	1733	2620	962	1918	1904	953	1919	2911	20060	1672
EIUBWD	594	593	575	587	595	800	546	277	616	606	599	298	6686	557
EIUMA	758	761	759	749	752	744	702	707	774	768	770	775	9019	752
GSUSMA	2	2	2	2	2	2	2	3	4	4	2	2	29	2
GSUSMD	1402	1402	1403	1404	1407	1411	1421	1421	1439	1419	1413	1423	16965	1414
HFS2	3803	3776	3795	3809	3811	3788	3775	3757	3778	3821	3861	3937	45711	3809
IOC10A	960	1907	1914	961	1924	1924	956	1903	2843	949	1897	1899	20037	1670
IOC10AM	283	118	112	115	110	113	114	116	115	115	120	118	1549	129
ISP1	3403	3400	3386	3371	3361	3365	3392	3382	3364	3355	3359	3349	40487	3374
ISP4	1878	940	1885	946	1887	2863	961	1923	1943	1961	994	1996	20177	1681
ISPTH	315	307	305	298	297	298	295	293	293	292	292	288	3573	298
ISUMA	1536	1566	1566	1564	1566	1565	1177	1174	1610	1587	1584	1589	18084	1507
ISUSMA	586	588	584	1162	579	586	594	600	1226	615	617	1239	8976	748
ISUSMD	1040	1047	1044	2097	1048	951	936	940	2104	1061	1060	2125	15453	1288
NEIUBWD	1775	1783	893	1787	2647	1694	1654	1673	856	1710	1702	1710	19884	1657
NIUSMA	1966	1958	1960	3960	1986	1865	1873	1877	4112	2062	2076	4171	29866	2489
NIUSMD	752	747	740	1503	755	728	702	706	1504	749	755	1503	11144	929
SERSDB			475	462	456			444		432		835	3104	517
SERSRS			69493	69536	69559			69753		69795		140062	488198	81366
SIUCSMBW	2946	2961	2979	3008	3032	4301	2875	1452	3105	3129	4696	1584	36068	3006
SIUCSMM	2065	2059	2058	2061	2057	2056	1921		2085		2112	4220	22694	2269
SIUCSMSM	2157	1083	1111	2225	1135	1143	1159	2323	2338	2343	1154	1158	19329	1611
SIUEBWD	629	620	615	620	625	311	592	897	604	601	600	296	7010	584
SIUESMA	1802	3590	3526	3497	3503	3433	3281	3279	3406	3419	3414	3408	39558	3297
SOS3	7598	7612	7669	7718	7729	7723	7729	7735	7792	8049	8129	8184	93667	7806
SURSDB	66	68	69	71	70	66	65	63	63	61	60	62	784	65
SURSE	335	339	508	337	337	169	337	333	332	334	336	169	3866	322
SURSRS	41212	41217	41162	41195	41254	41316	41309	41370	41372	41353	41366	41460	495586	41299
TRSR	1092	1091	1095	1102	1100	1097	1098	1097	1097	1098	1096	1096	13159	1097
UOFIA	38	38	38	38	39	38	38	38	38	38	38	38	457	38
UOFIBW	26958	27082	27396	27575	27713	27474	27634	13891	28278	28438	28613	28774	319826	26652
UOFICES	3			1									4	2
UOFIF	157	158	159	162	162	164	164	167	170	169	168	169	1969	164
UOFIM		14568	14578	14600	14608	14635		14974	14975	14972	14950	14963	147823	14782
WIUBWD	676	671	339	693	685	671	655	660	669	658	649	655	7681	640
WIUMD	645	644	641	639	639	639		596	646	640	637	635	7001	636
WIUSMD	264	261	532	535	264	264	264	262	524	261	261	520	4212	351
Grand Total	725352	758339	847595	825583	834418	880940	673894	913330	748988	766510	732779	1122686	9830414	819201

2021 Monthly Average - Post-Pay	275,519
2022 Monthly Average - Post-Pay	270,977
2023 Monthly Average - Post-Pay	272,705
3 Year Monthly Average - Post-Pay	819,201
2021 Total - Post-Pay	3,306,233
2022 Total - Post-Pay	3,251,720
2023 Total - Post-Pay	3,272,461
3 Year Total - Post-Pay	9,830,414

6. Payroll Flowcharts data flow for the HRIS and payroll files: payroll pre and post files work:

6. Invoices

2021 Invoices
Metric	Jan	Feb	March	April	May	June	July	August	September	October	November	December	Total 2021	Monthly Average
Invoice Groups	5352	5023	4921	4903	5067	6013	6295	6431	6141	5703	5737	5683	67269	5606
Leave invoice	3630	3345	3251	3281	3426	4350	4494	4633	4344	3930	4004	3921	46609	3884
Retiree invoice	1058	1025	1025	999	1025	1038	1168	1164	1148	1137	1097	1106	12990	1083
Cip Invoice	159	157	158	156	155	158	165	174	170	168	168	178	1966	164
Cobra Invoice	191	182	173	153	148	153	154	146	163	152	152	162	1929	161
Local Employer (Group Invoices)	304	304	304	304	304	305	305	305	305	305	305	305	3655	305
Trip Retiree Invoice	2	2	2	2	2	2	2	2	4	4	4	4	32	3
Active Invoice	8	8	8	8	7	7	7	7	7	7	7	7	88	7
2022 Invoices
Metric	Jan	Feb	March	April	May	June	July	August	September	October	November	December	Total 2022	Monthly Average
Invoice Groups	5951	5656	5760	5854	5701	6931	6772	6869	6206	6198	6002	5896	73796	6150
Leave invoice	4138	3916	4004	4067	3944	5143	4884	5005	4343	4262	4104	4075	51885	4324

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Aug 12, 2025.