Attachment_20_-_Arizona_HRIS_Additional_Reports___Amendment_2.pdf

Attachment 20 - Arizona HRIS Additional Reports – Amendment 2

Additional Report Assumptions:

1. CGI will design, build, unit test, publish, and support defect resolution through UAT for forty (40) reports, as listed in this Attachment 20 (see table below), according to the Consolidated Sprint Plan.

2. The State will provide functional subject matter expertise for the following responsibilities:

A. Report data mapping;

B. Business process requirements definition; and

C. Custom business logic (if applicable).

3. The State will provide design documents for as-is reports as identified below, no later than June 3, 2024, or upon the Amendment 2 Effective

Date, whichever is later.

4. State functional subject matter experts will complete the report related user stories and subtasks as mutually agreed and assigned in the sprint plan.

5. If the State determines a report is no longer needed and if the:

A. Report planned start date has passed according to the Consolidated Sprint Plan – the report will be removed from the CGI scope and will not be replaced; or

B. Report planned start date has not passed according to the Consolidated Sprint Plan – the report may be replaced with another report of equal or lesser complexity.

6. After the State approves a report design, design changes to the report (e.g., new columns, new fields, new visualizations, etc.) will require a

Change Request in accordance with the Contract and the rate card in BAFO Attachment 12 – Arizona HRIS Pricing Attachment, Tab – O&M

Labor Hour Worksheet.

7. A report or analytic with more than 2 tabs will be treated as a new report and may require a Change Request in accordance with the Contract and the rate card in BAFO Attachment 12 – Arizona HRIS Pricing Attachment, Tab – O&M Labor Hour Worksheet.

# SOA Report ID New Report ID Summary Complexity

(High, Med, Low)

As-Is Design Needed

1 PAETE HRM-PR-X1004 DW - /Agency HRIS Payroll Reports/Pre Compute - ETE Pending Time Records - (ETE) Medium Yes

2 PR260 HRM-PR-X1056 PR260 - Payment Detail Listing Medium No

3 ZR260 HRM-PR-X1057 ZR260 - Payment Detail Listing Medium No

4 PXR35.2 HRM-PR-X1052 DW - /Agency HRIS Payroll Reports/Pre Compute - Pending Time Records - (XR35.2) Medium Yes

5 ZR135 HRM-PR-X1009 DW - /Agency HRIS Payroll Reports/Info - Employee Reimbursement - (ZR135) Medium Yes

6 HR255 HRM-PR-X1012 DW - /Agency HRIS Payroll Reports/Info - Payroll Employee Group - (HR255) Medium Yes

7 ZS203 HRM-PR-X1022 ZS203 - Vehicle Report Medium Yes

8 BDU30R HRM-BSD-X4003 DW - /Agency Benefits Reports/Under 30 Hour Report Medium Yes

9 DW - HRM-PR-X1017 DW - /Agency HRIS Payroll Reports/Pre Compute - Time Records After Term Date Medium Yes

10 BDLE HRM-BSD-X4005 DW - /Agency Benefits Reports/Life Events High Yes

11 ZR261 HRM-PR-X1005 ZR261 - Employee Deduction Logfile Lst Medium No

12 BDUBP2 HRM-BSD-X4004 DW - /Central Benefits/Unpaid Benefit Premium Agency Level Report Medium Yes

13 ZR230 HRM-PR-X1023 ZR230 - Time Record Edit Report Medium No

14 AZ282 HRM-PR-X1024 AZ282 - Transit Deductions Not Taken Medium Yes

15 PR291 HRM-PR-X1025 PR291 - Unemployment Continuation Form Medium No

16 PR239 HRM-PR-X1026 PR239 - One Time Deduction Listing Medium Yes

17 PR292 HRM-PR-X1027 PR292 - Quarterly Unemployment Ins Medium No

18 ZR290 HRM-PR-X1028 ZR290 - Daily Payment Detail Listing Medium No

19 ZS200 HRM-PR-X1029 ZS200 - Employee Time Entry Time Record Audit Report Medium Yes

20 ZS201 HRM-PR-X1030 ZS201 - Employee Time Entry Proxy Maintenance (Updates custom table ZPROXY) Medium Yes

21 ZS202 HRM-PR-X1031 ZS202 - ETE Manager-Proxy Tracking Rpt Medium Yes

22 BUSC HRM-PR-X1032 DW - /GAO CONTROL D/BUSCARD Medium Yes

23 BUSCM HRM-PR-X1033 DW - /GAO CONTROL D/BUSCARDMAILING Medium Yes

24 ZR263 HRM-PR-X1035 ZR263 - LWOP Only Report Medium Yes

25 ZR205 HRM-PR-X1036 ZR205 - Taxable Wages Report Medium Yes

26 ZS204 HRM-PR-X1037 ZS204 - ETE Labor Detail Report Medium Yes

27 DW - HRM-PR-X1039 DW - /Agency HRIS Payroll Reports/Info - Employee Historical Daily Time Records Medium Yes

28 AZ273 HRM-PR-X1043 AZ273 - Replaced-Cancelled Trans Cards Medium Yes

29 PR278 HRM-PR-X1044 PR278 - United States Workers Compensation Report Medium Yes

30 New HRM-HR-X2006 EIN Lookup Report Low No

31 AZ258 HRM-BSD-X4010 AZ258 - Optum HSA Payroll Report Medium Yes

32 BN220 HRM-BSD-X4011 BN220 - Benefit Plan Status Report Medium Yes

33 ZS521 HRM-PR-X1055 ZS521 - Vehicle Data Extract Medium Yes

34 AZ238 HRM-PR-X1058 AZ238 - Qrtly Wage for Unemp Monthly Medium No

35 NEW HRM-BSD-X4002 NEW - Benefit Analytic Report (BSD Analytic) Medium No

36 PAPTD HRM-PR-A1059 DW - /Agency HRIS Payroll Reports/Post Compute - Payroll Transactions Detail Medium Yes

37 PR225 HRM-PR-X1065 PR225 - United States Garnishment Rules Listing Medium Yes

38 PR226 HRM-PR-X1066 PR226 - United States Employee Garnishment Listing Medium Yes

39 PR275 HRM-PR-X1068 PR275 - Deduction Report Medium Yes

40 PR276 HRM-PR-X1070 PR276 - Employee Deduction Report Medium Yes