Labor Cost Labor Cost Pilot February 2010 February 2010 2 Agenda Terminology Hierarchies Dashboards Demo February 2010 3 Terminology Period vs Pay Period Accounting Period the month the transactions were posted to the PeopleSoft Financial System ID: 724050
Download Presentation The PPT/PDF document "February 2010 1 POLYDATA Dashboards" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
February 2010
1
POLYDATA DashboardsLabor Cost
Labor Cost Pilot February 2010Slide2
February 2010
2
AgendaTerminology
HierarchiesDashboardsDemoSlide3
February 2010
3
Terminology
Period vs Pay PeriodAccounting “Period” – the month the transactions were posted to the PeopleSoft Financial System
Format: 01 = July, 02 = August, 03 = SeptemberDefined the same on the Finance DashboardsPay Period – The month the employee was actually paid for – the work was incurredFormat: 201007 = July, 201008 = AugustSlide4
February 2010
4
Page Prompts Period vs Pay PeriodSlide5
February 2010
5
Period vs Pay Period
Period
“07” = January
Pay Periods
201001, 200910, 200911, 200912 =
Jan 2010, Oct 2009, Nov 2009, Dec 2009Slide6
February 2010
6
TerminologyDepartment vs Charge Department
Department = Assigned DepartmentCharge Department = the DeptID chartfield that the employee’s pay was actually charged toSlide7
February 2010
7
“Assigned” Department vs Charge DepartmentSlide8
February 2010
8
Department vs Chg Deptid
Assigned to DeptID 117602 Graduate Studies and charged to 110100 Mechanical EngineeringSlide9
February 2010
9
Employee Data
Primary Report Name
EmplIDShort UsernameSlide10
February 2010
10
Job Data Terminology
UnionJob FunctionJobcodeEmpl ClassPositions
Regular/TempFull/Part TimeActual Salary FreqPaygroupGrade JobcodeSlide11
February 2010
11
Jobcode UnionSlide12
February 2010
12
Job Function – grouping of Job CodesSlide13
February 2010
13
JobcodeSlide14
February 2010
14
Empl Class – Employee ClassificationSlide15
February 2010
15
Regular/TempSlide16
February 2010
16
Full/Part Time Slide17
February 2010
17
Actual Salary FrequencySlide18
February 2010
18
PaygroupSlide19
February 2010
19
Grade JobcodeSlide20
February 2010
20
Translation Values Page Slide21
February 2010
21
OBIEE Hierarchy - Department
Assigned DepartmentDept Level 1Dept Level 2
Dept Level 3Dept Level 4 DepartmentCharge DepartmentChg Dept Level 1Chg Dept Level 2Chg Dept Level 3Chg Dept Level 4 Chg Dept
Slide22
February 2010
22
OBIEE Hierarchy - Department
UnionJob FunctionJobcodeGrade JobcodeCFA – Unit 3
TEN – Tenure Track2360 Instr Faculty AY3- Assistant ProfessorSlide23
February 2010
23
Jobcode HierarchySlide24
February 2010
24
Security
HR Department Security is applied to Labor Cost DashboardSlide25
February 2010
25
Choice of MeasureSlide26
February 2010
26
Choice of TimeSlide27
February 2010
27
Choice of TimeSlide28
February 2010
28
Choice of Page BreakSlide29
February 2010
29
Labor Cost Pages
Payroll Detail – Simple report – not a lot of options
Employee Detail – Information about a single employee
Payroll Summary – Lots of options, Column Selectors, Page Prompts, Page Selectors, Time SelectorsSlide30
February 2010
30
Payroll Detail - PromptsSlide31
February 2010
31
Payroll Detail Views – Summary by PersonSlide32
February 2010
32
Payroll Detail – Summary by Activity TypeSlide33
February 2010
33
Payroll Detail – Payroll Detail Matrix View Slide34
February 2010
34
Employee Detail
Default is set to a Primary Report Name Value of “Select a Name” so that the dashboard does not try to bring in ALL employees.Slide35
February 2010
35
Employee Detail Page
Note: the format of the Primary Report Name is
Last, First MISlide36
February 2010
36
Payroll Summary Page PromptsSlide37
February 2010
37
Payroll Summary ViewsPayroll Summary
Payroll Summary by Activity TypePayroll Summary by Activity Type by Accounting Period or Pay PeriodSlide38
February 2010
38
Sample Payroll Summary Reports –By Union, by FunctionSlide39
February 2010
39
Alpha by FundSlide40
February 2010
40
By AccountSlide41
February 2010
41
By DepartmentSlide42
February 2010
42
Roster by Dept by Pay PeriodSlide43
February 2010
43
Roster by Dept by EmployeeSlide44
February 2010
44
Demo