Hi there,
It's easy to see that the basic reason for having a database is to have all the information of all employees at your fingertips. So, you should have details as follows:
- Employee code
- Name
- Surname
- Date of joining
- Date of birth
- Designation
- Department
- Location
- Number of years of service in the company
- Number of years of service (total experience)
- Previous company worked at and designation held
Additionally, you need to include various CTC details such as:
- Basic
- DA
- HRA
- Conveyance
- Monthly gross
- Annual gross
- Medical reimbursement
- Etc.
I hope this solves your query.
Shilpa