I am an MBA HR intern. I have created an Excel-based employee database that includes almost all parameters from CTC breakup to personnel details. Now, I have to prepare a project report. However, I am not able to understand what should be added to the project report, such as topics that I can cover, because I can't just add that Excel sheet. Please help. It's urgent.
From India, Delhi
Acknowledge(0)
Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
HI Ankigodzi, Can you post just a demo of your database? May be for your Report best is to user Microsoft crystal report
From Rwanda
Acknowledge(0)Amend(0)
From Rwanda
Acknowledge(0)Amend(0)
Hi bht007, The following parameters are there in the employee database, and there are approximately 250 employees:
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 Revenue 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. Child 1
52. Child 1 DOB
53. Child 2
54. Child 2 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 for exit
67. Last Working Day
68. Date of relieving
69. Notice period served
70. F&F form submitted by employee
71. Date of sending F&F form to resources
72. Date of receiving F&F cheque
73. Date of handing 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
I hope this helps! Let me know if you need further assistance.
From India, Delhi
Acknowledge(0)Amend(0)
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 Revenue 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. Child 1
52. Child 1 DOB
53. Child 2
54. Child 2 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 for exit
67. Last Working Day
68. Date of relieving
69. Notice period served
70. F&F form submitted by employee
71. Date of sending F&F form to resources
72. Date of receiving F&F cheque
73. Date of handing 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
I hope this helps! Let me know if you need further assistance.
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
HR Manual (Employee Hand Book).doc
HR Monthly Report.xls