I am MBA HR intern.
I have created excel based employee database which includes almost all parameters from CTC breakup to personnel details. Now I have to prepare project report. But I am not able to understand what should be added to the project report like topics that I can cover because I can't just add that excel sheet.
Please help. It's urgent.
From India, Delhi
I have created excel based employee database which includes almost all parameters from CTC breakup to personnel details. Now I have to prepare project report. But I am not able to understand what should be added to the project report like topics that I can cover because I can't just add that excel sheet.
Please help. It's urgent.
From India, Delhi
Hi bht007
The following parameters are there in the employee database and there are approx 250 emp
1. Category
2. Brand
3. Employee Code No
4. Employee Type
5. Name of Employee
6. Gender
7. Designation
8. Designation Level
9. Level/Grade
10. IBU/SBU/Support
11. Department
12. Sub-Department
13. Location
14. Code
15. Immediate Manager
16. Supervisor Employee Code
17. Supervising Manager
18. Date of Association with the Company (for employees working on Contract/inter-entity transfers)
19. DOJ
20. Annual Revue target / Costing
21. Client attached to
22. Business Unit
23. Nature of job (buying, planning, operations, finance etc)
24. Indoor/ outdoor
25. Name of HR Executive
26. Name of HR Manager
27. DOB
28. PAN
29. Bank Name
30. Bank Account (Main)
31. Bank Account (ERA)
32. Bank Address
33. NEFT Code
34. PF Account No
35. Pension Number
36. ESI
37. Educational Qualification
38. Years of Experience (in months)
39. Last employer
40. Official email id
41. Blood Group
42. Mobile
43. Current Address
44. Permanent Residence Address
45. Mother's name
46. Mother’s DOB
47. Father’s Name
48. Father’s DOB
49. Spouse’s Name
50. Spouse’s DOB
51. Child1
52. Child1 DOB
53. Child 2
54. Child2 DOB
55. Working "w"/ Resigned "R"
56. Confirmation Date
57. Date of handing confirmation letter
58. Annual CTC in INR
59. Annual CTC post increment in May 2011
60. Admin Charges
61. Total CTC post increment in may 2011
62. Annual Variable CTC
63. Mobile Reimbursements entitlement
64. Date of Resignation
65. Date of Exit interview
66. Reason of exit
67. Last Working Day
68. Date of relieving
69. Notice period served
70. F&F form submitted by emp
71. Date of sending F&F form to resources
72. Date of receiving F&F cheque
73. Date of handling F&F cheque to ex employee
74. Rating for 2009
75. Source of recruitment
76. Recruitment Cost
77. Salary effective from
78. Breakup effective from
79. Annual CTC(Calculated)
80. Employee contribution to PF
81. Employee contribution to ESIC
82. Gratuity
83. Basic
84. HRA
85. Conveyance
86. Consolidated Allowance
87. Medical
88. LTA
89. Telephone reimbursements
90. Food Voucher
91. Car lease
92. Driver’s Reimbursement
93. Car and petrol maintenance
94. Annual Bonus
95. Fixed Quarterly Allowance
96. Co. sponsored Foreign Trip
97. Revenue generating position
98. Personnel File
From India, Delhi
The following parameters are there in the employee database and there are approx 250 emp
1. Category
2. Brand
3. Employee Code No
4. Employee Type
5. Name of Employee
6. Gender
7. Designation
8. Designation Level
9. Level/Grade
10. IBU/SBU/Support
11. Department
12. Sub-Department
13. Location
14. Code
15. Immediate Manager
16. Supervisor Employee Code
17. Supervising Manager
18. Date of Association with the Company (for employees working on Contract/inter-entity transfers)
19. DOJ
20. Annual Revue target / Costing
21. Client attached to
22. Business Unit
23. Nature of job (buying, planning, operations, finance etc)
24. Indoor/ outdoor
25. Name of HR Executive
26. Name of HR Manager
27. DOB
28. PAN
29. Bank Name
30. Bank Account (Main)
31. Bank Account (ERA)
32. Bank Address
33. NEFT Code
34. PF Account No
35. Pension Number
36. ESI
37. Educational Qualification
38. Years of Experience (in months)
39. Last employer
40. Official email id
41. Blood Group
42. Mobile
43. Current Address
44. Permanent Residence Address
45. Mother's name
46. Mother’s DOB
47. Father’s Name
48. Father’s DOB
49. Spouse’s Name
50. Spouse’s DOB
51. Child1
52. Child1 DOB
53. Child 2
54. Child2 DOB
55. Working "w"/ Resigned "R"
56. Confirmation Date
57. Date of handing confirmation letter
58. Annual CTC in INR
59. Annual CTC post increment in May 2011
60. Admin Charges
61. Total CTC post increment in may 2011
62. Annual Variable CTC
63. Mobile Reimbursements entitlement
64. Date of Resignation
65. Date of Exit interview
66. Reason of exit
67. Last Working Day
68. Date of relieving
69. Notice period served
70. F&F form submitted by emp
71. Date of sending F&F form to resources
72. Date of receiving F&F cheque
73. Date of handling F&F cheque to ex employee
74. Rating for 2009
75. Source of recruitment
76. Recruitment Cost
77. Salary effective from
78. Breakup effective from
79. Annual CTC(Calculated)
80. Employee contribution to PF
81. Employee contribution to ESIC
82. Gratuity
83. Basic
84. HRA
85. Conveyance
86. Consolidated Allowance
87. Medical
88. LTA
89. Telephone reimbursements
90. Food Voucher
91. Car lease
92. Driver’s Reimbursement
93. Car and petrol maintenance
94. Annual Bonus
95. Fixed Quarterly Allowance
96. Co. sponsored Foreign Trip
97. Revenue generating position
98. Personnel File
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
HR Manual (Employee Hand Book).doc