reports final (PDF)

Reports
Report 1
Team ID

EmployeeID

Employee Name

Date

Dean Elliott

Project
Name
Castorama

0002

0004

0002
0002

Hours

28/FEB/17

Department
Activities
Work

0004

Dean Elliott

Castorama

09/JUL/17

Annual Leave

48

0004

Dean Elliott

Castorama

30/SEP/17

Overtime

9

1

In this report we decided to use ‘Dean Elliott’ to display the employee time for a particular project
including all cost centres. From the report it is clear which department activity this particular
employee has taken, ‘annual leave’ and how many hours they have taken. The report also shows the
hours worked and any overtime that has been completed by the employee. In the example there is 1
hour of regular work completed within the project and 9 hours of overtime.
Report 2
Project ID Project Name
Resource (Role)
Name
Hours
0001
Screwfix
Business Analysts
Harri McDonald
2
0003
Koctas
Business Analysts
Dion Parker
4
0003
Koctas
Business Analysts
Rocky Stam
5
0001
Screwfix
Developers
Allison Fry
1
0002
Castorama
Developers
Dean Elliott
1
0002
Castorama
Developers
Bear Ellison
3
0002
Castorama
Testers
Coby Suarez
4
0001
Screwfix
Testers
Danica Hammond
3
This report entails who has spent a certain amount of time on each project. We can gather from this
data that Screwfix employees have booked the least amount of time, at 6 hours whereas both
Castorama and Koctas used 9 hours. The report is also ordered by the different project resources,
(the different jobs that each employee does) rather than the project id, this means that there is no
set order for the projectID and other fields due to the data being ordered by the different roles.
Report 3
EmployeeID

Name

Resource (Role)

Week Commencing

Submitted

0001

Harri McDonald

Business Analysts

05/04/18

Yes

0002

Coby Suarez

Testers

05/04/18

Yes

0003

Allison Fry

Developers

05/04/18

No

0004

Dean Elliott

Developers

05/04/18

Yes

0005

Danica Hammond

Testers

05/04/18

No

0006

Dion Parker

Business Analysts

05/04/18

No

0007

Bear Ellison

Developers

05/04/18

Yes

0008

Rocky Stam

Business Analysts

05/04/18

Yes

Report 3 is to show which employees have submitted their work, during the same week, their role is
also inputted to make it clearer.

Report 4
Team

TeamID

Team Performance

Screwfix
0001
Great
Castorama
0002
Good
Koctas
0003
Great
This simple report shows each team and how their performance was ranked from 1-3, 1 being ‘Poor’,
2 being ‘Good’ and 3 being ‘Great’.
Report 5
Team

EmployeeID

Employee Name

Date

Overtime Hours

Screwfix
0001
Harri McDonald
26/05/17
4
Castorama
0002
Coby Suarez
26/03/18
4
Screwfix
0003
Allison Fry
21/06/18
6
Castorama
0004
Dean Elliott
30/09/17
9
Screwfix
0005
Danica Hammond 12/12/16
1
Koctas
0006
Dion Parker
0
Castorama
0007
Bear Ellison
29/09/17
2
Koctas
0008
Rocky Stam
0
This shows who has been using overtime and how many hours they have, nevertheless the team
Koctas have not used any overtime hours therefore do not have any data.
Report 6
--