Laserfiche WebLink
• Outstanding Purchase Orders (PO) by fund <br />• Working Trial Balance -comparative to prior year <br />• Expenditure statement by department, object -for all funds <br />• Expenditure statement by department, object -for all funds (comparative to prior year) <br />2.6.2 HCM Report Development <br />The list below are the City's required system generated reports that support HR/Payroll business <br />processes. The project team will review these reports to determine the scope of reports that must <br />be developed in Phase 2 HCM. It is the expectation of the City and CherryRoad that reports <br />which are provided to outside agencies will be developed using Oracle Cloud report development <br />tools. For those reports that are provided to City employees, City departments, etc., it is the <br />expectation of the City and CherryRoad that this data will be made available in dashboard and/or <br />query format using the Oracle Cloud delivered tools. <br />• New hires/promotions/separations report - run monthly <br />• Leave reports — run to process work for employees on Family Medical Leave Act (FMLA), <br />California Family Rights Act (CFRA) Leave <br />• Service awards — run quarterly <br />• Timecard history report <br />• Giving campaign report — run annually during open enrollment <br />• Salary plan report — run to detail salary changes <br />• Timecard entry reports — run by employee or department entered <br />• Listing of dependents age 26 and over (as of a specific date) — run quarterly to check for <br />dependents who need to be removed from insurance coverage <br />• Accounts payable inquiry — run as needed to obtain invoice amount, date paid, vendor info, <br />vendor number, etc. <br />• Accounts receivable inquiry data — run as needed and used by HR in work performed for <br />training consortium. <br />• Vendor information — run as needed to obtain vendor number and contact information to pay <br />invoice(s) <br />• Affordable Care Act (ACA) 1095-C documents — printed annually for distribution to <br />employees and worksheet for 1099 fire <br />• Auto allowance listing — report run annually and/or during negotiations to check allowances, <br />labor relations use, etc. <br />• Deferred compensation census listing by plan — run 1-2 times annually to obtain enrollment <br />numbers and contribution amounts <br />• Employee information download report - excel costing and data retrieval run on average <br />every 2 weeks <br />• Health and dental census reports <br />• Employee listing by bargaining unit <br />• Report of casuals active but not paid— report run quarterly to determine separation <br />Personnel Action Forms (PAFs) to be completed <br />• Bilingual incentive report — run as needed to obtain translation support, to inform labor <br />negotiations, and to review pay differentials <br />• Life insurance table — run as needed to support discussions with employees, payroll, and in <br />responding to survey requests <br />EXHIBITA STATEMENT OF WORK <br />ATN/AGR/2019.118/CHERRYROAD ERP IMPLEMENTATION SERVICES <br />REV: 05-13-19 PR Page 34 of 172 <br />A-20 <br />