Appendix J - Key State of Connecticut Statistics

Appendix J - Key State of Connecticut Statistics

Excel Spreadsheet - Number of Administrative Users by Agency

 Transaction Volumes - Financials

Parameter Value
Financials Package  
General  
Approximate number of locations 600
Approximate total number of users 2,300
Approximate number of "sets of books" by funds 500
Overall Yearly Organizational Growth 3-4%
   
Module: General Accounting  
Average number of journal entries per month 2,000
Approximate number of ledgers 4,700
Number of chart of accounts key fields 8 segments
Approximate number of projects 10,000
Approximate number of grants 20,000
Average number of months of GL history retained 60 mo.
Average number of months of journal entries history 60 mo.
Average number of months of actual balances history 60 mo.
Average number of months of budget history 60 mo.
Average number of months of encumbrance balances history 60 mo.
Average number of months of project history 60 mo.
Average number of months of grants history 60 mo.
   
Module: Accounts Payable  
Approximate number of vendors 80,000
Average number of AP invoices per month 41,500
Average number of Invoices per batch 8
Average number of lines per invoice/voucher 6
Average number of scheduled payments per invoice 1.1
Average number of checks cut per month 25,000
Average number of stop payments to vendors per month 130
% of 1099 vendors 12.5% (10,000)
Average number of 1099 records per 1099 vendor 4
Average number of months of AP vendor history retained 60 mo.
Average number of months of AP invoice history retained 60 mo.
Average number of months of AP payment history retained 60 mo.
   
Module: Revenues and Receipts  
Average number of customers 12,000
Average number of invoices issued per month 15,000
Average number of receipts per month 15,000
Average number of drafts per month 5,300
Average number of direct debits per customer per month 2
Average number of months customer history 60 mo.
Average number of months of receivables history 60 mo.
Average number of months of payment retention 60 mo.
   
Module: Asset Management  
Approximate number of asset records 675,000
Approximate number of books 5
Approximate number of depreciation books maintained 5
Approximate number of leases 600
Approximate number of departments/agencies 100
Number of chart fields 6
Approximate number of transfers per year 10,500
Approximate number of additions per year 32,000
Approximate number of Retirements per period 4,600
Average asset life (yrs) 10 yrs for Equip 40 yrs for Bldgs
   
Module: Projects and Grants  
Average number of Accounting Entries created per month 8,500
Average number of projects & grants 30,000
Average Project Length 60 mo.
Average number of Costing Transactions per month 10,000
Average number of Billing Transactions per month 2,000
Average number of hierarchical rollup structures per month 30,000
Average number of manual transactions in Projects per month 500
Average number of Externally Interfaced Transactions per month 300
Average number of months of Transaction history retained 60 mo.
   
Module: Purchasing  
Approximate number of Items 250,000
Approximate number of Vendors 57,000
Average number of Vendors per Item 4
Averaged number of Addressees per Vendor 2
Average number of Requisitions per month 5,000
Average number of Purchase Orders per month 10,000
Average number of Solicitations per month 3,000
Average number of Quotes/Bids per month 3,000
Average number of Lines per Receipt 8
Average number of months of Transaction history retained 48 mos
Average number of Purchase Order Lines per Purchase Order 4
Average number of Distribution Lines per Purchase Order Schedule 1
Average number of Requisition Lines per Requisition 4
Average number of Requisition Schedules per Requisition Line 1
Average number of Distribution Lines per Requisition Schedule 4
Approximate % of 1099 Vendors 12.5% (10,000)
Average number of 1099 records per 1099 vendor 1
Approximate number of Commodity Codes 1,100
Average number of Purchase Cards on File per month 12,000
Approximate number of Agencies using purchase cards 126
Average number of Purchase Card Transactions per month 1,260
Average number of Contract Documents created per year 65,000

Transaction Volumes - HRMS

Parameter Value
Human Resources Package  
General  
Approximate number of locations 320
Approximate total number of users 2,100
Overall Yearly Organizational Growth 3-4%
   
Module: Payroll  
Approximate number of employees 75,000
Number of Pay Periods per year 26, 24, 12
Average number of Checks per Year 800,000 cks
Approximate number of Direct Deposits per month 90,000
Approximate number of W-2s issued per year 90,000
Number of earnings types 97
Number of deduction types 146
Payroll processing done in house? Yes
Payroll runs 2 batches done bi-weekly
Current time to run payroll (hh:mm) 8.5 hrs run time + print time
Expected time to run payroll (hh:mm) 2-4 hrs run time
Number of salary calculations run per month and time frame 12 runs - 6 hrs total run time
Approximate number of salary calculations per run 75,000
Approximate number of retroactive calculations/transactions per payroll Max 18,000 / Avg 10 - 3,600
Average number of adjustments per payroll Max 100 / Avg 50
Number of years of history retention 7
Average number of pay checks per employee per pay period (regular, overtime, bonus, etc.) 1
Average number of earnings an employee will have on the pay stub. (e.g. Regular, Overtime, Premium) 7
Average number of employee and employer deductions per check e.g. Parking, Charity, 401k, union dues, etc. ee deds only - avg 4 excl. taxes (allows for 17)
Average number of Taxes an employee will have on the Pay Stub (Federal withholding, FICA, OASDI, State withholding, State OASDI) 3 (FICA/med combined)
Average number of labor department or accounts charged for earnings per check Max 20 / Avg 4
Average number of Positions, Agencies or Pay groups an employee can be active at the same time 1.1
   
Module: Benefits Administration  
Approximate number of benefit Packages 25
Length of open enrollment period 5 weeks
Benefits enrollment in house? Yes
Exception processing y or n Yes
Audit trails y or n Yes
Years of history retention 7
   
Module: Personnel Administration  
Approximate number of users 570
Amount of HR information captured 54,597 Appt. Records
Amount of HR history kept 1,742,365 appt. records
Approximate growth Rate 103 per month
Approximate number of ad hoc HR reports run per day 100
Average number of Positions per employee 1.001
Average number of changes per Empl-Position per year 3
Approximate number of new hires/month 456
Average number of job applicants per month 2,557
   
Module: Time and Attendance  
Approximate number of employees 75,000
Approximate number of time and attendance transmissions 600,000 / pay period
Approximate number of time entries by employees per period 0-30
Average number of tasks per day 2
Average number of earnings per day 2-3
Average number of expenses reimbursement requests/pay period 1,400
Number of years of historical data retention Duration of employment plus 30 years

Table of Contents
Index of Comptroller's RFPs
Comptroller's Home Page