Employee Database Indexing
The initial database should have a main index listing of employees. This could include a unique employee number (if it exists) or the last name and first name. A larger group may require this to be categorized under various departments.
Physical files should have an approach to dividing them into two sections: employee data and correspondence. The first section should be built on standard forms compiled by HR, which should cover employee information, emergency contact, medical history (blood group/allergies/medication), next of kin, etc. The second section would consist of all related correspondence filed date-wise.
Again, this could be simple or get complex depending on the nature and size of the organization. If the company also opts to have them in electronic form, you would need to adopt issuing soft copy formats for getting employee info, and relevant correspondence would need to be scanned and filed electronically. Ideally, a single file should be kept for each person.
Regards