Hi, I have been told to prepare a exhaustive list of fields for the employee database. Kindly suggest me few or kindly let me know the links where i can get the same. Thanks and Regards, Madhu
Acknowledge(0)
Amend(0)
Acknowledge(0)Amend(0)
Here are some of the fields that you can use:
- Emp. Code
- Title
- Name
- Designation
- Department
- D.O.J.
- D.O.B.
- Age
- Present Address
- Phone/ Mobile number
- Permanent Address
- Phone Number
- PAN Number
- Father's Name
- Qualifications
- Previous Experience (Yrs)
- Total Experience
- Location
- Basic Salary (p.m.)
- HRA (p.m.)
- PF (p.m.)
- Total CTC (p.m.)
- Remarks
Hope this helps!
From India, New Delhi
Acknowledge(0)Amend(0)
19- Emp. Code
- Title
- Name
- Designation
- Department
- D.O.J.
- D.O.B.
- Age
- Present Address
- Phone/ Mobile number
- Permanent Address
- Phone Number
- PAN Number
- Father's Name
- Qualifications
- Previous Experience (Yrs)
- Total Experience
- Location
- Basic Salary (p.m.)
- HRA (p.m.)
- PF (p.m.)
- Total CTC (p.m.)
- Remarks
Hope this helps!
From India, New Delhi
Acknowledge(0)Amend(0)
Hi Madhu,
The details given by Sush are absolutely relevant, and with this information, you can create a complete employee database. Try creating it in an Excel file as it will be more convenient for you. You can also highlight the various headers under which there will be subpoints.
For your reference, I am attaching a specimen of the desired format. I hope it will help you. If you need any clarification, feel free to ask.
Regards,
Poonam
From India, New Delhi
Acknowledge(1)Amend(0)
The details given by Sush are absolutely relevant, and with this information, you can create a complete employee database. Try creating it in an Excel file as it will be more convenient for you. You can also highlight the various headers under which there will be subpoints.
For your reference, I am attaching a specimen of the desired format. I hope it will help you. If you need any clarification, feel free to ask.
Regards,
Poonam
From India, New Delhi
Acknowledge(1)Amend(0)
Hi Madhu,
Find below the details of the Employee database that you can develop at your end and keep it as a record for every month, after some changes.
I am describing the contents sheet-wise:
First Sheet - Details of employees
a. E. Code b. Name of the employee c. Date of birth d. Designation e. CTC f. Address for communication g. Permanent address h. Contact number i. Blood group j. Maximum qualification k. Extra qualification l. Total Experience
Second Sheet - Salary structure
In this sheet, write down the complete salary structure and make a column for the salary after any revision.
Third Sheet - New Joinees
In this sheet, write down the names of the new joinees of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet - Resigned employees
In this sheet, write the names of employees who resigned during that particular month with details like name, designation, date of joining, date of resignation, last working day.
Fifth Sheet - Attrition rate
Hope this will be very helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Find below the details of the Employee database that you can develop at your end and keep it as a record for every month, after some changes.
I am describing the contents sheet-wise:
First Sheet - Details of employees
a. E. Code b. Name of the employee c. Date of birth d. Designation e. CTC f. Address for communication g. Permanent address h. Contact number i. Blood group j. Maximum qualification k. Extra qualification l. Total Experience
Second Sheet - Salary structure
In this sheet, write down the complete salary structure and make a column for the salary after any revision.
Third Sheet - New Joinees
In this sheet, write down the names of the new joinees of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet - Resigned employees
In this sheet, write the names of employees who resigned during that particular month with details like name, designation, date of joining, date of resignation, last working day.
Fifth Sheet - Attrition rate
Hope this will be very helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
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
Employee Data - Format.xls