Building an Employee Database: What Essential Fields Should I Include?

Hi,

I have been told to prepare an exhaustive list of fields for the employee database. Kindly suggest a few or let me know the links where I can find the same.

Thanks and Regards,
Madhu

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!

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

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.

Hi,

This is just a simple sheet! See if it can help you.

Kripali

Can anybody send me a database for printing timecards of employees in a specific timecard format? Please ensure that I can retrieve data in the required format.