[go: up one dir, main page]
Scribd
Upload
26 views12 pages

Investment 235

Uploaded by

tolinakidane1015
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
26 views12 pages

Investment 235

Uploaded by

tolinakidane1015
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

NO TITLE FIRST_NAME MIDDLE_NAME LAST_NAME SEX DOB_ETH BIRTH_PLACE

1 ATO Shame Habib Abdule M 2/2/1970


2 ATO Amanuel M 12/4/1979
3 ATO Masarat Asafa Gamachu M 22/6/1963
4 ATO Dame Miressa Ribi M 5/1/1960
5 W/R Warqiye Asfawu Sirnessa F 10/2/1987
6 ATO Tarfasa Mulata Yade M 19/6/1963
7 ATO Elyas Mamo Baro M 22/6/963
8 ATO Tasfaa Masadi Sima M 3/5/1961
9 ATO Tamasgen Taka Disasa M 19/3/1979
10 ATO Gobana Dhinsa Kura M 5/1/1975
11 ATO Tariku Raga Aliko M 12/10/1976
12 ATO Bula Abdisa Bayana M 10/10/1956
13 ATO Chala Miressa Tarfa M 11/2/1982
14 ATO Kumara Tesso Nagasa M 1/5/1982
15 W/R Hirut Itana Lamu M 19/12/1991
16 W/R Askale Waqjira Galata F 15/2/1964
17 ATO Henok Amante Hunde M 29/6/1976
18 ATO Charu Magarsa Abdi m 11/6/1979
19 ATO Daniel Asfa Ayana M 12/5/1984
MARITAL_STATUS PENSION_ID HIRE_DATE_ETH EMPLOYMENT_TYPE EMPLOYEE_TYPE
MARRIED 1/12/1980 Permanent Civil
MARRIED 3/1/2001 Permanent Civil
MARRIED 1/3/1999 Permanent Civil
MARRIED 1/11/1989 Permanent Civil
MARRIED 1/4/2001 Permanent Civil
MARRIED 1/7/1986 Permanent Civil
MARRIED 16/3/1984 Permanent Civil
MARRIED 10/1/1986 Permanent Civil
MARRIED 13/7/1999 Permanent Civil
MARRIED 26/5/1998 Permanent Civil
MARRIED 10/1/2003 Permanent Civil
MARRIED 26/1/1980 Permanent Civil
MARRIED 15/9/2015 Permanent Civil
MARRIED 1/5/2005 Permanent Civil
SINGLE 18/9/2003 Permanent Civil
MARRIED 25/4/1987 Permanent Civil
MARRIED 1/5/2003 Permanent Civil
MARRIED 1/12/1997 Permanent Civil
MARRIED 28/8/2005 Permanent Civil
ORGANIZATION DEPARTMENT PAYROLL_NAME
leder
plan and bajet
Expert
farmerrs and PLC Leder
data encoder exp
marcet linkedge leader
Pro/Group leder
Expert
expert
farmers group leder
value cheen expert
expert
human resource
Expert
expert
jender equality
Expert
Group leder
farmer and inv expert
BICODE BINAME GRADE SALARY REGION CITY WEREDA HNO TELE
4000160101235
4000160101235 XIII
4000160101235 XIII
4000160101235 XV
4000160101235 XII
4000160101235 XIV
4000160101235 XV
4000160101235 XV
4000160101235 XII
4000160101235 XV
4000160101235 XIII
4000160101235 XIV
4000160101235 XIII
4000160101235 XIII
4000160101235 XIII
4000160101235 XIII
4000160101235 XIII
4000160101235 XIV
4000160101235 XII
MOBILE BANK_ACC FULL_NAME
965012605
917047301
920274827
917134291
953727682
946533177
967902361
932212898
917491559
917847165
917281190
917847654
917434194
917452589
917367211
917661935
931521290
917658631
917072364
Colunm Name Description
DOB_ETH Must be in Ethiopian Calendar using the format 01/01/2000
HIRE_DATE_ETH Must be in Ethiopian Calendar using the format 01/01/2001
SEX Must be F for Female or M for Male
MARITAL_STATUS Must be M for Married or S for Single or D for Divorced or W for Widdow
EMPLOYMENT_TYPE Must be P for Permanent or C for Contract
EMPLOYEE_TYPE Must be C for Civil M for Military

Validation Rules
Date of Birth must 18 years less than Hier date
Hier Date must not be Grater than Today
Fields in Red are mandatory
Format Accepted Values
01/01/1990 01/01/1990 or 01-01-1990 or 1-1-1990 or 1/1/1990
30/12/2012 01/01/1990 or 01-01-1990 or 1-1-1990 or 1/1/1991
Female,Male,Any Letter Starting with F or M
Married, Single, Divorced ,Widdow Any Letter Starting with M,S,D,W
Permanet,Contract ,Any Letter Starting with P or C
Civil,Military , Any Letter Starting with C or M
ELEMENT1
NO EMPLOYEE_ID EMPLOYEE_NAME BANK_ACC
House Allowance
1 159 Saba Haliemariam Huinde 3644485448 1000.00
2 205 Yakob Tadele Yemane 3644485632 0.00
3 206 Tesfaye Tura Ayo 3644485420 2000.00
4 73 Haile Demowz Tekllu 3644485360 0.00
5 3110 Tigist Asmamaw Zena 3644485432 3000.00
ELEMENT2 ELEMENT3 ELEMENT4 ELEMENT5
Cell Phone Allowance Cost Sharing EMPTY EMPTY You can upload upto 5 Elements & 500 Row
200.00 400.00 0 0
300.00 0.00 0 0 Do not Edit the Red Shaded Cells
0.00 200.00 0 0
500.00 100.00 0 0 Employee ID Name and Bank Acc. Must Ma
600.00 0.00 0 0
to 5 Elements & 500 Rows

d Shaded Cells

e and Bank Acc. Must Match


Current Month Payroll
No. Employee Name Basic Salary House Allowance Cell Phone Allowance Pension
1 Haile Demowz Tekllu 6,481.00 0.00 500.00 453.67
2 Saba Haliemariam Huinde 7,377.00 1000.00 200.00 516.39
3 Tesfaye Tura Ayo 6,773.00 2000.00 0.00 474.11
4 Tigist Asmamaw Zena 6,481.00 3000.00 0.00 453.67
5 Yakob Tadele Yemane 7,071.00 0.00 300.00 494.97
34,183.00 6,000.00 1,000.00 2,392.81
t Month Payroll
Cost Sharing Gross Tax Total Ded. Net Pay Gov.Pension
648.1 6,981.00 1,105.25 1,558.92 5,122.08 712.91
0 8,577.00 1,279.25 1,795.64 5,581.36 811.47
0 8,773.00 1,128.25 1,602.36 5,170.64 745.03
0 9,481.00 1,055.25 1,508.92 4,972.08 712.91
707.1 7,371.00 1,202.75 2,404.82 4,666.18 777.81
1,355.20 41,183.00 5,770.75 8,870.66 25,512.34 3,760.13

You might also like