Created by Miki Yanagi, last modified on Nov 21, 2018

BI-3 - HR Reports for BI tool Open

CategoryReport NameDM JIRA Ticket

Table Used

NotesCreated?

Benefits & Payroll


Paid Wages/ Distribution Reviews

DM-156 - Dist Review Closed DM-164 - Paid wages by FY and emplid BI Tool DM-87 - Regular2 wages by FY and emplid2 Closed

UM_PAYEARNS_VW#HR1

No



CategoryReport NameDM JIRA Ticket

Table Used

NotesCreated?

Position Management



Budget Report

(Combine Budget Report - DEPTID

Budget Report - Fund Code

Budget Report - Salary)

DM-17 - pm Budget + Transfers BI Tool DM-18 - pm budget report FTE BI Tool DM-19 - pm budget report w Annual, ABBR, SalBase BI Tool DM-21 - pm budget rprt BI Tool DM-25 - pm budget rprt-MW Budget Version BI Tool DM-36 - Position Management Base Budget with Salary Variance Closed DM-41 - pm budget report with salary BI Tool

UM_F_POS_BUD_VW

#HR2

Some people want to exclude $0 budget and others don't. Do we need to be clear on that on the report (make prompts or two versions)

No
Position Management
Position vs. Job Data

DM-27 - PM Budgets vs Annual Distributions Closed DM-40 - PM Budgets vs. Annual Distributions FY17 NEP Parked

#HR3No