Author: Umakant Mishra
Abstract:
Selection and recruitment is a key HR function and it is
often necessary to maintain at least a small database of all the candidates who
have been invited in past interviews. This information may be considered as a
part of HR MIS and may be maintained by HR department along with other HR MIS
such as employee information, transfers, performance appraisals, trainings etc.
This recruitment MIS database includes all the candidates
after the preliminary scrutiny is over. When the candidates go through
different stages of interviews, the MIS also captures all their interview
results. Maintaining this information not only helps the HR manager but also
helps other senior managers to find the short listed/ interviewed candidates
quickly from the database.
As this MIS data contains confidential information, such as,
salary negotiations etc., the access to this data should be restricted only to
few senior managers. The MIS administrator may assign read/write access to
different data/reports based on the role and responsibility of the manger in
the organization.
Keywords: information systems, management information
system, MIS database, recruitment database, employee database, database design,
database structure, software design, MIS design
Mishra,
Umakant, Designing an MIS Database for Selection and Recruitment (September 13,
2013). Available at SSRN: http://ssrn.com/abstract=2325533 or http://dx.doi.org/10.2139/ssrn.2325533
