HomeMy WebLinkAboutIR 9365INFORMAL REPORT TO CITY COUNCIL MEMBERS
G�'RTEgFO
r
t�
rs�a
To the Mayor and Members of the City Council
No. 9365
March 1, 2011
Page 1 of 3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE I
UPDATE
The purpose of this Informal Report is to provide an update on the current status of payroll
performance and corrections.
Pay Correction Checks Paid Citywide: The chart and table below depict the number of pay
correction checks issued.
300
250
200
150
100
50
0
Paycheck Correction Checks Paid Citywide (as of February 18, 2011)
—0— Police —Fire -,Water/WW --+(-- Transportation Public Works
Oct 29th Nov 12th Nov 24th Dec 10th Dec 24th Jan 7th Jan 21st Feb 4th Feb 18th
The spike in number of Pay Period 03 correction checks was due to an Oracle system defect
detected the week of February 1. All employees impacted by this anomaly received an off cycle
check the week of February 7. Staff has implemented a work around and will continue to monitor
the issue until the vendor provides a permanent solution.
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
INFORMAL REPORT TO CITY COUNCIL MEMBERS
ATEt,4e
a
To the Mayor and Members of the City Council
No. 9365
March 1, 2011
Page 2 of 3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE I
UPDATE
Other City Departments Not Shown on Previous Page
Analysis of Dollar Values of Corrections: The following table provides a breakdown of the
correction checks by dollar categories for each pay period.
Pav Period
Check Mnurt
Oct 29th
Nov 12th
Nov 24th
Dec 10th
Dec 24th
Jan 7th
Jan 21st
Feb 4th
Feb 18th
Parks and Community Services
10
6
3
7
4
10
11
1
0
Municipal Court
1
6
3
5
4
7
3
4
1
Code Compliance
4
2
3
3
1
1
5
0
0
City Manager
01
0
3
5
0
0
0
0
0
Planning and Development
3
1
1
2
1
3
9
0
0
C' Secrets
2
0
0
1
0
0
2
0
1
Equipment Services
1
0
1
0
2
0
1
10
0
Financial Management Services
0
0
2
1
0
2
1
7
0
Housing and Economic Develop
0
1
1
0
2
0
3
0
0
Libra
2
1
0
0
0
2
2
0
0
Public Events
3
0
0
01
0
0
0
3
1
Information Technology
0
0
1
1
0
1
0
0
7
Community Relations
1
0
0
0
0
0
0
0
0
Human Resources
1
0
0
0
1
1
1
0
0
Internal Audit
0
0
0
0
1
1
0
0
0
Aviation
01
0
0
0
0
0
0
1
0
Law
1 01
0
0
0
0
0
0
0
1
Analysis of Dollar Values of Corrections: The following table provides a breakdown of the
correction checks by dollar categories for each pay period.
Pav Period
Check Mnurt
0029th
Nov 12th
Nov 24th
Dec 10th
Dec 24th
Jan 7th
Jan 21st
Feb 4th
Feb 18th
Total
less than $50
32
6
1
14
16
16
13
46
6
150
between $50 and $100
23
10
1
26
12
26
28
57
4
187
between $100 and $250
54
39
37
47
45
67
40
124
16
469
between $250 and $500
22
21
22
1 44
48
69
1 15
70
5
1 316
between $500 and $750
6
10
6
15
7
18
4
13
3
82
between $750 and $1000
6
5
2
6
6
7
3
4
0
39
between $1000 and $1500
3
3
5
5
5
5
1
0
2
29
between $1500 and $2000
2
0
4
6
2
2
2
1
0
19
between $2000 and $2500
0
0
0
2
0
1
0
2
0
5
greater than $2500
0
0
4
2
0
0 1
2
0
1
9
The total number of checks /advices produced since 18 Oct 2010 is 55,776. The total number of
off cycle checks is 1,305 which is 2.34 %.
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
INFORMAL REPORT TO CITY COUNCIL MEMBERS
G��Tt�O
a
tzw
To the Mayor and Members of the City Council
No. 9365
March 1, 2011
Page 3 of 3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE I
UPDATE
Police Paycheck Inquiries: The following table tracks the number of paycheck inquiries
submitted to the Central Payroll Processing Team (CPPT) in Police. These inquiries are
researched by the task force of CPPT and ERP Support Team members to determine the
appropriate resolution. The resolutions of the inquiries can be payment of a shortage, reduction
of subsequent check due to overage, adjustments to leave balance, and /or confirmation that
policies enforced by the system are functioning properly and the paycheck is correct.
* Since the last report, PD reported additional inquiries along with requests for review of
previously researched /completed inquiries.
Update on Deployment of Resources to Assist Police: On January 4, 2011, City Council
approved the addition of contract resources for support of Police, implemented as follows.
• Five consultants are now being utilized to provide support for Police payroll correction
inquiries and verification.
• Continued use of time entry resources deployed on January 12th at ERP to address
volume of Police time entry and expand support to additional Police Divisions.
Payroll Advances: The City continues to make payroll advances available for those employees
whose pay may be adversely impacted by the PeopleSoft implementation. When approved by
departmental management, an employee is eligible to receive an advance up to the estimated
amount of the shortage in pay. While employees must repay these advances, repayment is
deferred until the related payroll issues are researched and resolved. Payroll advance checks will
be available one business day after receipt in the FMS payroll office except during regular payroll
week when checks are only run on Monday and Friday.
The next IR update will be provided to Council on March 8, 2011.
If you have any questions, please contact Pete Anderson, Director, IT Solutions Department at
817- 392 -8781.
I
Higgins
Interim City Manager
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
29 -W -10
12-Nov-10
24- Nov -10
10- Dec -10
23-0ea10
Nan-11
21Jan -11
4-Feb -11
18- Feb-11
Total
PP22
PP23
PP24
PP25
PP26
PP01
PP02
PP03
PP04
Total inquiries rcvd by CPPT
226
240
156
249
209
174
155
162
54
1625
Total inquiries researched competed
-224
•228
-152
234
-167
-148
- 110
43
-3
-1309
Total Remaining to be researched
'2
'12
'4
'15
42
'26
'45
'119
51
316
* Since the last report, PD reported additional inquiries along with requests for review of
previously researched /completed inquiries.
Update on Deployment of Resources to Assist Police: On January 4, 2011, City Council
approved the addition of contract resources for support of Police, implemented as follows.
• Five consultants are now being utilized to provide support for Police payroll correction
inquiries and verification.
• Continued use of time entry resources deployed on January 12th at ERP to address
volume of Police time entry and expand support to additional Police Divisions.
Payroll Advances: The City continues to make payroll advances available for those employees
whose pay may be adversely impacted by the PeopleSoft implementation. When approved by
departmental management, an employee is eligible to receive an advance up to the estimated
amount of the shortage in pay. While employees must repay these advances, repayment is
deferred until the related payroll issues are researched and resolved. Payroll advance checks will
be available one business day after receipt in the FMS payroll office except during regular payroll
week when checks are only run on Monday and Friday.
The next IR update will be provided to Council on March 8, 2011.
If you have any questions, please contact Pete Anderson, Director, IT Solutions Department at
817- 392 -8781.
I
Higgins
Interim City Manager
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS