Attachment H - Metrics.xlsx

53 KB Posted

Attached to
ERP Production Support RFP
Solicitation number
26-448DOIT-INFOT-B-53319
Issued by
Illinois

About this file

Written by GovTribe AI ·

This is a metrics file documenting the performance and utilization of an enterprise resource planning (ERP) system across 74 Illinois state agencies during calendar year 2024. The system encompasses two company codes and serves approximately 4,261 users across 262 locations, with a live budget of $1.265 trillion as of December 2024. The ERP implementation includes Finance, Human Capital Management (HCM), and related modules supporting general ledger, accounts payable, asset management, funds management, grant management, procurement, project systems, and materials management functions. Monthly metrics tracked throughout 2024 demonstrate system activity including invoice processing, asset valuations, and user engagement across all participating state entities, with the system processing 2.878 million transactions and managing $28.6 billion in fixed assets by year-end.

Operationally, the system generated 14,110 total incidents across Finance, HCM, and Security functional areas during 2024, with the largest volume concentrated in Employee Central (3,093 incidents) and Security (2,992 incidents). The state implemented 425 total releases throughout the year, comprising 337 normal weekly/monthly releases and 88 emergency releases, with the majority related to incident resolution (294 changes) rather than enhancement requests (131 changes). Production support efforts were significant during the HCM hypercare phase in early 2024, with data cleanup activities transitioning to ongoing support by April. Supporting documentation includes 176 Business Intelligence artifacts, 422 ECC/SRM technical specifications across conversion, enhancement, forms, interfaces, and workflows, and 179 SuccessFactors technical artifacts, providing comprehensive configuration and process documentation across all functional areas.

View the file

Other files

File Type Posted
Attachment E - Finance Overview.docx DOCX document
Attachment M - Amplifund_SAP Integration - Process Flow.pptx PPTX presentation
Attachment L - ERP Program Architectures.pptx PPTX presentation
Attachment J - Interfaces.xlsx XLSX spreadsheet
Attachment K - RPA Bots Summary.docx DOCX document
Attachment P - Access Profile Roles_Impacted Workflow - Finance.xlsx XLSX spreadsheet
Attachment I - SOIL Master BOBJ Reports HANA Views and BODS Jobs List.xlsx XLSX spreadsheet
B-53319 ERP Production Support RFP ~2.docx DOCX document
Attachment D - Change Request Resource Hours Monthy.docx DOCX document
BEP Utilization Plan v.26.1~5.pdf PDF
ipg-active-registered-vendor-disclosure-formerly-forms-b~1.docx DOCX document
Attachment G - HCM Overview.docx DOCX document
Attachment F - Advanced Reporting Overview.docx DOCX document
Attachment N - DHS_SAP_IOC_Conduent Integrations - Process Flow.pptx PPTX presentation
c2d-vendor-guidance-v.24.4~6.pdf PDF
VBP Utilization Plan v.26.1~2.pdf PDF
ATTACHMENT C - Requirements and RASCI Matrix UPDATED 12.01.25.xlsx XLSX spreadsheet
ATTACHMENT Q - F.3.4.4 Proposed Staff Organization Structure.xlsx XLSX spreadsheet
ATTACHMENT R - F.3.4.5 Proposed Staff Table.xlsx XLSX spreadsheet
Attachment A - Applications List.xlsx XLSX spreadsheet
Blank IT Contract..docx DOCX document
Attachment T - State of Illinois Standard Security Requirements.pdf PDF
B-53319 - Offer to the State of Illinois Information and Technology.pdf PDF
c2d-vendor-answer-sheet-v-26-2~4.pdf PDF
ATTACHMENT S - Glossary.xlsx XLSX spreadsheet
vendor-disclosure-formerly-forms-a-v27-1-2026-0624~6.docx DOCX document
Attachment O - SAP_IOC High-Level Flow of Activity.pptx PPTX presentation
Attachment B - Customizations.xlsx XLSX spreadsheet
Show all 28

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.

Finance

Finance Metrics for Calendar Year 2024
Mo/Year# of Company Codes# of ECC Agencies# of Locations# of UsersLive Budget$ DisbursedTotal Invoice Count$ Invoices ProcessedTotal Asset CountValue of Fixed Assets
24-Jan2733,937$1,078,926,854,986.14$4,805,129,703.22228,223$4,882,356,682.28$27,365,252,870.85
24-Feb2734,057$1,068,030,532,055.14$4,259,681,135.37236,446$4,955,412,896.23$27,380,874,838.30
24-Mar2734,082$1,068,121,875,236.14$4,477,817,265.19232,812$4,707,158,492.15$27,250,798,697.60
24-Apr2734,141$1,067,752,906,554.14$5,359,152,412.63247,717$5,261,165,389.86$27,390,750,733.41
24-May2744,202$1,067,952,462,682.14$4,055,112,331.28236,187$5,260,681,675.58$27,559,893,164.16
24-Jun2744,234$1,069,591,711,359.14$5,779,840,893.98234,281$5,317,655,056.06$27,557,204,666.20
24-Jul2744,246$1,060,862,237,493.14$5,014,048,740.99252,655$6,352,862,984.11$27,632,354,776.39
24-Aug2744,200$1,061,187,237,493.14$5,671,604,181.77248,960$5,455,413,924.87$27,709,059,179.23
24-Sep2744,215$1,061,187,837,493.14$4,648,096,739.26227,489$4,791,507,463.60$27,977,418,713.63
24-Oct2744,233$1,061,187,837,493.14$4,702,914,387.13244,409$6,984,837,841.27$28,071,448,509.53
24-Nov2744,256$1,061,187,837,493.14$4,376,973,920.33248,721$4,675,793,889.94$28,173,163,890.87
24-Dec2742624,261$1,265,320,594,294.14$5,149,974,536.02240,710$4,591,680,664.87769,402$28,604,601,324.46

2024 Totals 2 74 262 4,261 $1,265,320,594,294.14 $58,300,346,247.17 2,878,610 $63,236,526,960.82 769,402 $28,604,601,324.46

Finance by Module

Finance Module Utilization by Agency
Agency NameAcronymBusiness AreaCluster Go-Live DateGeneral LedgerAccounts PayableAsset ManagementFunds ManagementGrant ManagementControllingPSCD Misc ReceiptsPSCD ReceivablesMaterials Management (SRM)Warehouse ManagementPSIOWBSLHFAmpliFund (Grantor) (if highlighted, use is upcoming)Payroll I/F
Office of The Auditor GeneralOAG10320.7.1XXXXXXXXPS_I-3

PS_I_2 Grant Alloc

General Assembly Retirement SystemGARS13122.7.1XXXXPS_I_3
Administrative Office of the Illinois CourtsAOIC20121.7.1XXXXXXXXXPS_I_3
Office of Statewide Pretrial ServicesOSPS20425.7.1XXXXPS_I_3
Judges Retirement SystemJRS27522.7.1XXXXXJournal Entries
Illinois Pollution Control BoardPCB277XXXXXXPS_I_3
Illinois Courts CommissionCCOM28024.3.1XXXXXXXPS_I_3
Judicial Inquiry BoardJIB28520.7.1XXXXXXXPS_I_3

PS_I_2 Grant Alloc

Office of The State Appellate DefenderOSAD29020.7.1XXXXXXXPS_I_3
State's Attorney Appellate ProsecutorSAAP29522.7.1XXXXXXXPS_I_3
Office of The GovernorGOV31017.4.1XXXXXXXPS_I_3
Office of The Lieutenant GovernorLTG33017.4.1XXXXXXXPS_I_3
Office of The Attorney GeneralAGO34021.7.1XXXXXXXXXXX

Shanks, Diana: Shanks, Diana:

Configured in C8; not usingPS_I_3
Office of The TreasurerSTO37021.7.1XXXXXXXPS_I_3
Department on AgingAGE40220.7.1XXXXXXXXXXXPS_I_3
Department of AgricultureAGR40618.7.1XXXXXXXXXXXPS_I_3

PS_I_1

Department of Central Management ServicesCMS41618.7.1XXXXXXXXXPS_I_3
Department of Children and Family ServicesDCFS41818.1.1XXXXXXXXPS_I_3
Department of Commerce and Economic OpportunityDCEO42022.7.1XXXXXXXXXXXXPS_I_3
Department of Natural ResourcesDNR42219.1.1XXXXXXXXXXXXXPS_I_12
Department of Juvenile JusticeDJJ42520.1.1XXXXXXXXXXXPS_I_21
Department of CorrectionsDOC42620.1.1XXXXXXXXXXXPS_I_14
Department of Employment SecurityDES42716.10.1XXXXXXXXXXXPS_I_21
Department of Financial and Professional RegulationDFPR44018.7.1XXXXXXXXPS_I_3
Department of Human RightsDHR44219.1.1XXXXXXXXPS_I_3
Department of Human ServicesDHS44421.7.1XXXXXXXXXXXXXPS_I_3
Illinois Power AgencyIPA44518.7.1XXXXXXXXXXPS_I_3
Department of InsuranceDOI44618.7.1XXXXXXXXPS_I_21
Department of Innovation and TechnologyDOIT44818.7.1XXXXXXXXXXXXPS_I_3

PS_I_2 Grant Alloc

Department of LaborDOL45218.7.1XXXXXXXXXXPS_I_3
Department of The LotteryLOT45818.7.1XXXXXXXXPS_I_3
Department of Military AffairsMA46620.1.1XXXXXXXXXXXPS_I_3
Department of Healthcare and Family ServicesHFS47820.1.1XXXXXXXXXXPS_I_3

PS_I_1 n/ using since Go-Live

Illinois Dept of Early ChildhoodDEC48025.1.1XXXXPS_I_3
Department of Public HealthDPH48218.7.1XXXXXXXXXXPS_I_3
Department of RevenueDOR49217.7.1XXXXXXPS_I_3
Illinois State PoliceISP49320.1.1XXXXXXXXXXXPS_I_3
Department of TransportationDOT49420.1.1XXXXXXXXPS_I_3
Department of Veterans' AffairsDVA49716.10.1XXXXXXXXXXXPS_I_3
Illinois Arts CouncilIAC50318.7.1XXXXXXPS_I_3
Abraham Lincoln Presidential Library and MuseumALPM50617.7.1XXXXXXXXPS_I_3
Governor’s Office of Management and BudgetGOMB50717.4.1XXXXXXXXPS_I_3
Office of the Executive Inspector GeneralOIG50919.1.1XXXXXXXPS_I_3
Executive Ethics CommissionEEC51018.1.1XXXXXXXXPS_I_3
Capital Development BoardCDB51117.4.1XXXXXXXXXXXPS_I_3

PS_I_2 Grant Alloc

Illinois Civil Service CommissionCSC51717.4.1XXXXXXPS_I_3
Illinois Commerce CommissionICC52418.7.1XXXXXXXXPS_I_3
Illinois Deaf and Hard of Hearing CommissionDHH52619.1.1XXXXXXXPS_I_3
Environmental Protection AgencyEPA53216.10.1XXXXXXXXXXPS_I_3
Commission on Equity and InclusionCEI53322.1.1XXXXXXPS_I_18
Guardianship and Advocacy CommissionGAC53719.1.1XXXXXXXPS_I_3
Human Rights CommissionHRC54219.1.1XXXXXXPS_I_3
Criminal Justice Information AuthorityCJIA54619.1.1XXXXXXXXXXPS_I_3
Illinois Educational Labor Relations BoardELRB54818.7.1XXXXXXPS_I_3
Illinois TollwayILTA55718.7.1XXXXXXXXXPS_I_3
Illinois Council on Developmental DisabilitiesCDD55818.1.1XXXXXXXXPS_I_3
Illinois Procurement Policy BoardPPB56217.4.1XXXXXXPS_I_3
Illinois Workers' Compensation CommissionWCC56318.7.1XXXXXXXXPS_I_3
Illinois Independent Tax TribunalITT56418.1.1XXXXXXPS_I_3

PS_I_19 EE/WBS Assign PS_I_2 Grant Alloc

Illinois Gaming BoardGAM56518.7.1XXXXXXXXPS_I_3
Illinois Liquor Control CommissionLCC56719.7.1XXXXXXXPS_I_3
Law Enforcement TrainingLET56922.7.1XXXXXXXXPS_I_3
Illinois Prisoner Review BoardPRB57820.1.1XXXXXXXPS_I_3
Illinois Racing BoardIRB57918.7.1XXXXXXXXXPS_I_3
Property Tax Appeal BoardPTAB58018.7.1XXXXXXPS_I_3
Sex Offender Management BoardSOMB58320.1.1XXXXXPS_I_3
State Board of ElectionsSBE58721.7.1XXXXXXXXXPS_I_3
Illinois Emergency Management AgencyIEMA58817.7.1XXXXXXXXXXPS_I_3
State Employees Retirement SystemSERS58922.7.1XXXXXPS_I_3
Illinois Labor Relations BoardLRB59018.7.1XXXXXXXPS_I_3
State Police Merit BoardSPMB59119.1.1XXXXXXXPS_I_3
Office of The State Fire MarshalSFM59220.1.1XXXXXXXXXXXPS_I_3
Illinois Board of Higher EducationIBHE60122.7.1XXXXXXXXXXXPS_I_3
Illinois Community College BoardICCB68421.7.1XXXXXXXXXPS_I_3
Illinois Student Assistance CommissionISAC69122.7.1XXXXXXXXXXPS_I_3
State Univ Civil Service SystemSUCSS69521.7.1XXXXXXXPS_I_3

HCM

2024 End of Year Human Capital Management Metrics
AgencyAgency Code# of Positions# of Recruiting Users# of Onboarding Users# of Employee Central Users# of Compensation Users# of Job Requisitions# of Job Applications# of Transactions
Abraham Lincoln Presidential Library and Museum (0506)0506105611130391351173
Administrative Office of the Illinois Courts (0201)020100000000
Capital Development Board (0511)0511138435176633747308
Commission on Equity and Inclusion (0533)053337622901750146
Commission on Government Forecasting and Accountability (0105)010531003200028
Court of Claims (0528)05282902302006
Criminal Justice Information Authority (0546)0546229426196096212499
Department of Agriculture (0406)040681779478002756666425
Department of Central Management Services (0416)041610162382186182989428433
Department of Children and Family Services (0418)0418532818430421451944675411033
Department of Commerce and Economic Opportunity (0420)042075936945351712884339
Department of Corrections (0426)04264966281701277432094343222349
Department of Employment Security (0427)04271416916126743328124315
Department of Financial and Professional Regulation (0440)044059714757101362998267
Department of Healthcare and Family Services (0478)04783181146252193945919068957
Department of Human Rights (0442)0442189521471453698173
Department of Human Services (0444)0444102371234916617031121115724895
Department of Innovation and Technology (0448)0448256927391501574816582395
Department of Insurance (0446)044633461828931433078472
Department of Juvenile Justice (0425)042557438978921773624252
Department of Labor (0452)04521541041404822682199
Department of Military Affairs (0466)04663229638801432675513
Department of Natural Resources (0422)042223873914179415518972190
Department of Public Health (0482)04822107186141501057717717236
Department of Revenue (0492)04921135149101557426453903098
Department of the Lottery (0458)0458165831690441703206
Department of Transportation (0494)049444811302371490176027313292
Department of Veterans' Affairs (0497)049761734161470246265391077
Department on Aging (0402)04022084771826751815256
Emergency Management Agency (0588)058828984826831161922598
Environmental Protection Agency (0532)0532846603881350090281692
Executive Ethics Commission (0510)0510132192102022304143
Governor's Office of Management and Budget (0507)050790337828396133
Guardianship and Advocacy Commission (0537)0537131142142324473191
Human Rights Commission (0542)054238714601762851
Illinois Arts Council (0503)05033341254727549
Illinois Board of Higher Education (0601)0601812716323056853
Illinois Civil Service Commission (0517)05176125147610
Illinois Commerce Commission (0524)05242557227307066042
Illinois Community College Board (0684)068476027410099
Illinois Coroner Training Board (0520)052030020003
Illinois Council on Developmental Disabilities (0558)05581434900013
Illinois Deaf and Hard of Hearing Commission (0526)05261333605811
Illinois Educational Labor Relations Board (0548)054835321104132
Illinois Gaming Board (0565)056533418221871332541106
Illinois General Assembly (0101)01011177001299000958
Illinois Independent Tax Tribunal (0564)056443030003
Illinois Labor Relations Board (0590)05902142160332916
Illinois Law Enforcement Training and Standards Board (0569)05695414242163248966
Illinois Mathematics and Science Academy (0692)069227684314723190
Illinois Office of Comptroller (0360)03603322362791983202436
Illinois Power Agency (0445)0445575245028131118
Illinois Prisoner Review Board (0578)0578443135226106160
Illinois Procurement Policy Board (0562)056250050000
Illinois Racing Board (0579)05794221381114864
Illinois State Board of Elections (0587)05871171638531086261
Illinois State Board of Investments (0555)055514441620016
Illinois State Police (0493)049328391041427944198642519
Illinois Student Assistance Commission (0691)069134533346410259
Illinois Workers' Compensation Commission (0563)05631871521670101040198
Joint Committee on Administrative Rules (0167)016711001000011
Judges' Retirement System (0275)0275410404991
Judicial Inquiry Board (0285)028550050004
Legislative Audit Commission (0109)010960050009
Legislative Information System (0108)010847004100092
Legislative Printing Unit (0110)011031002500021
Legislative Reference Bureau (0115)011542003800024
Liquor Control Commission (0567)056715285460822166
Office of the Architect of The Capitol (0156)015650040003
Office of The Attorney General (0340)03408502084400013
Office of The Auditor General (0103)01031140199000238
Office of the Executive Inspector General (0509)05099317291329543100
Office of the Governor (0310)0310186531682331294131
Office of the Legislative Inspector General (0102)010240040000
Office of the Lieutenant Governor (0330)0330371236200101
Office of the State Appellate Defender (0290)029030903322300977
Office of the State Fire Marshal (0592)05922721121800861418196
Office of The State’s Attorneys Appellate Prosecutor (0295)029511200101400257
Pollution Control Board (EPA) (0577)0577382220366423
Property Tax Appeal Board (0580)0580404144032862
State Board of Education (0586)058667173600000239
State Employee Retirement System (0589)05891291221302441299251
State Police Merit Board (0591)0591162232003
State Univ Civil Service System (0695)06951422100001
Supreme Court Historic Preservation Commission (0210)021080080000
Teachers' Retirement System of the State of Illinois (0593)05932814352190106409420
Grand Totals8655,4952,85247968,12615715,755409,83627,435

Incidents

Incidents by Assignment Group
Month 2024ERP FinanceERP HANAERP HCMERP Hypercare

tc={463D3F70-F2D5-49A4-B2D9-F18D6096EBD8}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Production Support assisted with large portion of HCM Hypercare incidents due to unique circumstances requiring updates for conversion data. Data Clean Up efforts transitioned to ERP HCM in April 2024 and is a continued Production Support task.ERP SecurityTotal by Month
January579141141234942
February494161114091861216
March561262394072341467
April55211450442681325
May5811355112691415
June572183542651209
July771183022901381
August671262202451162
September52017200216953
October610302123021154
November45122208290971
December50330150232915
Total by Group68652413111862303114110
212 HANA - Finance
Incidents by Functional Area
Accounts Payable1600
Asset571
Basis147
Compensation4
Controlling155
Employee Central3093
Fund Management379
General Ledger471
Grant Management91
HANA BI175Note: some HANA incidents tagged down to further functional area.
Onboarding54
Procurement2775
Project Systems98
PSCD657
Recruiting848
Security2992
Total by Area14110

Production Support assisted with large portion of HCM Hypercare incidents due to unique circumstances requiring updates for conversion data. Data Clean Up efforts transitioned to ERP HCM in April 2024 and is a continued Production Support task.

State Initiated Releases

Month 2024Release Changes
January26
February44
March50
April38
May33
June31
July26
August36
September42
October49
November25
December25
Total Releases425
WorkstreamRelease ChangesType of ReleaseRelease Changes
Finance288Normal Weekly/Monthly Releases337
HCM137Emergency Releases88
Total425Total425
Functional AreaRelease ChangesType of Change MethodRelease Changes
Procurement35Incident/Defect294
Assets76Change Request/Enhancement131
Security15Total425
Accounts Payable13
All/Multiple Areas16
Basis12
Controlling2
Employee Central86
Recruiting38
Funds Management20
General Ledger5
Grants Management10
Onboarding10
Project Systems3
PSCD84
Total425

Artifacts BI HANA FSD Type (count) Legend tc={10510F57-83A8-4305-9B44-0F80C99C0AAD}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

RICEFW count by Functional Area. Includes BI HANA. Reference Service Overview write up to be sure aligned. Config WBs, SM need covered somehow.Process AreaViewDashboardReportUniverseTotalFSDFunctional Specification Document
Assets5510BPDBusiness Process Document
Accounts Payable171027CRDConfiguration Rationale Document
Employee Central7512
Funds Management921122
General Ledger81220
Grants Management358
Process Integration11
Procurement13116131
Project Systems112
PSCD161127
Recruiting6814
Security22
Total853871176
ECC/SRMFSD Type (count)ECC/SRMBPD (count)CRD (count)
Process AreaConversionEnhancementFormsInterfaceReportsWorkflowTotalProcess Area
Assets2857325Assets71
Accounts Payable3384447197Accounts Payable71
Funds Management61661231Funds Management71
General Ledger3634218Cross Module - Entity Structure4
Grants Management310138126General Ledger41
Process Integration11Grants Management92
Procurement125982077113Period End Close4
Project Systems8715131Procurement156
PSCD42820138376Project Systems115
RPA33PSCD71
Security11AR/AP Payments1
Total41173331104520422Total7222
SFFSD Type (count)
Process AreaInterfaceReportTotal
Employee Central37120157
Onboarding55
Recruiting1717
Total37142179

RICEFW count by Functional Area. Includes BI HANA. Reference Service Overview write up to be sure aligned. Config WBs, SM need covered somehow.

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