AttendMitra
Attend Mitra
Interactive demo
Workforce Management · Glossary

Employee Database

Also called: employee master, personnel database, employee records, HR master data

Definition

An employee database, also called the employee master, is the single record of every person on the rolls: identity, statutory IDs, job and reporting details, pay structure and documents. Attendance rules, shift assignment, leave policy and payroll all read from it, so a wrong joining date or missing UAN in the master becomes a wrong balance, a wrong shift or a wrong deduction downstream.

What the employee master contains

A usable master has five groups of fields. Identity: name, employee ID, date of birth, gender, photo, contact details, emergency contact. Statutory: PAN, Aadhaar reference where lawfully collected, UAN and PF member ID, ESIC IP number, bank account for salary. Job: department, branch or site, designation, reporting manager, date of joining, employment type (permanent, contract, apprentice, daily-rated), shift group, weekly-off pattern. Pay: salary structure with basic, DA, HRA and allowances, applicable policy for PF, ESI, professional tax state and leave. Documents: offer letter, ID proofs, police verification for guards, certificates, signed policy acknowledgements.

Each of these groups is owned by a different process (HR, payroll, operations, compliance), which is why the master drifts when it lives in several Excel sheets. One record, with field-level ownership and an audit log, is the fix.

  • Identity and contact, including a photo used for ID cards and face enrolment confirmation
  • Statutory IDs: PAN, UAN, ESIC number, bank details, PT state
  • Job: site, department, reporting line, joining date, employment type, shift group
  • Pay structure and the policies (PF, ESI, leave, attendance) the employee is mapped to
  • Documents with expiry dates where relevant (licences, verifications, contracts)

Why it is the source for attendance rules and payroll

Attendance software does not apply rules to a name; it applies them to the attributes on the master. The shift group decides which timings a punch is validated against. The site decides which geofence applies. The employment type decides whether the 26-day divisor or calendar days are used for the per-day rate. The joining date decides leave accrual and, later, gratuity eligibility. The PF and ESI flags decide whether contributions are computed at all.

Payroll reads the same record for basic and DA (PF base), gross (ESI base), the professional tax state, and the bank account for the NEFT file. If a guard is transferred from a Gurugram site to a Faridabad site and the master is not updated, his punches will fail the old geofence and his professional tax may be computed for the wrong state. The HRMS glossary entry explains how the master sits under every other module.

DPDP handling and access control

Almost everything in the master is personal data under the Digital Personal Data Protection Act 2023, and some of it (Aadhaar, bank, face descriptors, health records) deserves stricter treatment. The practical obligations are to collect only what a stated purpose needs, tell employees what is held and why, restrict who can see each field group, keep an access log, and retain records only as long as statutory rules require after exit.

Role-based access is the everyday control: a site supervisor needs names, photos, shift group and phone numbers; he does not need bank accounts or PAN. Exports should be logged and limited to the fields the recipient needs, because the mass CSV export to a personal email is how most master-data leaks happen.

  • Purpose-limited collection; no field 'just in case'
  • Field-group permissions by role, with an access and export log
  • Retention schedule tied to statutory requirements, with deletion at the end
  • Employee self-service for viewing and correcting their own contact and bank details
Example: one wrong field, three downstream errors

A housekeeping contractor onboards 30 staff for a new Bengaluru mall from a supervisor's WhatsApp list. Joining dates are entered as the 1st of the month for everyone, though most joined on the 8th. Three things go wrong: earned leave accrues a week early for all 30; the first month's payroll pays 30 days instead of 23 for each; and PF is computed on a full month's basic. The correction touches the leave ledger, an arrears reversal and a revised ECR. Reconciling the master against offer letters before the first payroll would have taken an hour.

How Attend Mitra handles this

Attend Mitra keeps one employee database with departments, branches and sites, digital ID cards, document uploads, and the shift, leave, PF and ESI mappings that attendance and payroll preparation read from. Bulk import from Excel, role-based access, audit logs and employee self-service for contact details are included; the headcount reports and analytics exports run off the same record.

Frequently asked questions

What is employee database software?
Software that stores one structured record per employee, covering identity, statutory IDs, job details, pay structure and documents, with role-based access, an audit trail and import and export tools. It is the master that attendance, leave, roster and payroll modules read from, rather than a spreadsheet that each team copies and edits separately.
What is the difference between an employee database and an HRMS?
The employee database is the master record. An HRMS is the wider system that uses that record for attendance, leave, payroll, onboarding and appraisals. Every HRMS contains an employee database; a standalone employee data management tool holds the record without those modules, and exports it to whatever else you run.
Which fields are mandatory in an Indian employee master?
For payroll and compliance you need name, date of joining, date of birth, PAN, UAN, ESIC number where applicable, bank account, salary structure with basic and DA, the state for professional tax, and the employment type. For attendance you need site, shift group and weekly-off pattern. Keep Aadhaar only where a specific law or scheme requires it.
How should employee data be protected under the DPDP Act?
Collect only what the stated purpose needs, give employees notice of what is held and why, restrict each field group to the roles that need it, log access and exports, secure the data at rest and in transit, and retain it only for the statutory period after exit. Employees should be able to see and correct their own details.

Related terms

HRMS (Human Resource Management System)
HRMS stands for Human Resource Management System, software that stores and manages employee records and HR processes across the employment lifecycle: onboarding, personal and statutory data, attendance and leave, payroll, performance, documents and exit. It differs from HRIS (record-keeping focus), HCM (strategic talent focus) and WFM (daily scheduling and attendance focus), though vendors blur the lines.
Headcount
Headcount is the number of people employed by an organisation, site or department at a point in time, counting each person as one regardless of hours worked. It is distinct from FTE, which weights people by hours, and from active strength, which counts only those actually working. Reconciling headcount against attendance and payroll every month is how ghost employees and unbilled workers are caught.
Workforce Management (WFM)
Workforce management (WFM) is the set of processes and tools an organisation uses to have the right number of people with the right skills in the right place at the right time. It spans demand forecasting, shift scheduling, time and attendance, leave management, absence control and productivity tracking. WFM is operational and daily, whereas HRMS covers the broader employee lifecycle.
Employee Self-Service (ESS)
Employee self-service (ESS) is the part of an HR or attendance system that lets employees view and act on their own records without going through HR: checking attendance and shift, applying for leave, raising attendance regularization requests, downloading payslips and updating personal details. Delivered through a mobile app, ESS cuts HR queries and gives shift workers direct visibility into what they will be paid.
Payroll Register (Wage Register)
A payroll register, also called a wage register or salary register, is the employer's month-wise record of every employee's paid days, earnings by component, deductions, employer contributions and net pay. It is a statutory register under the Code on Wages and the contract-labour rules, the source from which payslips and EPF, ESI and TDS returns are prepared, and the first record an inspector or auditor asks to see.
Contract Labour
Contract labour means workers hired by or through a contractor to work in an establishment, rather than employed directly by it. Security guards, housekeeping staff, canteen workers and loaders are common examples. The Contract Labour (Regulation and Abolition) Act 1970 and now the OSH Code 2020 regulate who must register, who must hold a licence, and who is finally liable for wages, PF and ESI.

Go deeper

Employee records management softwareImporting employees from ExcelDigital employee ID card systemHRMS (glossary)Headcount (glossary)

See how this works inside Attend Mitra

Verified attendance, shift rosters, leave, and payroll-ready reports in one platform built for Indian teams.

Browse all terms