SQL Payroll Leave Balance Report(with BF)

Page 1

Employee Department Branch Group Project Job Task Sort By

: : : : : : : :

All All All All All All All Employee;Branch;Department;HRGroup;Project;Job;Task

07/04/2010 10:52:26 AM ADMIN

Leave Balance for Year 2009

SAMPLE COMPANY SDN BHD (375882-V)

Page 1 of 1 Annual Leave

Employee Name

Medical Leave

Meternity Leave

Replacement Leave

Entitle

B/F

Taken

Balance

Entitle

Taken

Balance

Entitle

Taken

Balance

Entitle

Taken

Balance

Entitle

Taken

Balance

0.00

0.00

1.00

-1.00

0.00

1.00

-1.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

14.00

10.00

4.00

20.00

22.00

0.00

22.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

TAN YI WEN

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

YONG SHUO YUAN

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

16.00

2.00

11.00

7.00

22.00

3.00

19.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

8.00

1.00

2.00

7.00

14.00

0.00

14.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

NGAN THIONG LEAK TAN HOEY JIA

WILSON SEOW WEI XIEN YEW CHEE REN

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

10.00

0.00

8.00

2.00

16.00

3.00

13.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

YEW WEN QI

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

LEE LAY PENG

12.00

7.50

4.00

15.50

18.00

2.00

16.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

YAP CHUN FAT

0.00

0.00

0.00

0.00

0.00

3.00

-3.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

LOW KAI XUAN

12.00

4.00

1.00

15.00

22.00

0.00

22.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

TAN EE YUAN

9.50

-1.00

9.00

-0.50

15.50

0.00

15.50

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

TEE AI LING

8.00

0.00

2.00

6.00

14.00

2.00

12.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

ANG BENG HUAT

0.00

0.00

1.00

-1.00

0.00

1.00

-1.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

LIU SIEW PENG

10.00

-1.50

3.00

5.50

16.00

10.00

6.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

LEE WEI SHEN

16.00

0.00

0.00

16.00

22.00

0.00

22.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

NG QIU YEE

12.00

0.00

0.00

12.00

18.00

0.00

18.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

NG FUI LING

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

LIM KOK FEI LIAU SOK KUAN

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

12.00

5.00

7.00

10.00

18.00

1.00

17.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

CHAN KAI MUN

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

DER TUN WONG

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

TAN WAN YEAN

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

139.50

27.00

53.00

113.50

217.50

26.00

191.50

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

LEE JIAN TAT WONG LIAN SZE

Grand Total


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.