Free template template · Word

Employee Database Format

An employee database format is a design sheet that defines which fields your HR database holds, what type of data each field takes, who can see it and why it is needed. HR and IT use it to build or clean a database that is accurate and collects no more data than necessary.

Editable Word (.docx)
Made for India
12 fill-in fields highlighted
Free, no sign-up

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[Company Logo][Company Name]

EMPLOYEE DATABASE FORMAT – FIELD DICTIONARY

Organisation:: [Company Name]
Version:: [Version Number]
Approved on:: [DD/MM/YYYY]
Data Owner:: [HR Name]

This field dictionary defines the employee database for [Company Name]. Each field must have a stated purpose; fields without a purpose are not collected.

Field Name	Data Type / Format	Mandatory	Purpose	Access Level	Retention
Employee ID	Alphanumeric, unique	Yes	Primary key across systems	All HR, payroll, manager	Permanent (service record)
Full Name	Text, as per PAN	Yes	Identification, payslips	All HR, payroll, manager	Employment + retention period
Date of Birth	DD/MM/YYYY	Yes	Age checks, PF records	HR, payroll	Employment + retention period
Aadhaar	Last 4 digits only	No	Identity check, PF KYC	HR only	Employment + retention period
Bank Account / IFSC	Numeric / 11-character code	Yes	Salary credit	Payroll only	Employment + retention period
[Field Name]	[Format]	[Yes / No]	[Purpose]	[Role]	[Period]

Access levels

HR administrator: full read and edit access.
Payroll: salary, bank, statutory fields only.
Reporting manager: work-related fields for direct reports only.
Employee: read access to own record through self-service.

Privacy notice: [Company Name] collects the details on this page only for designing and operating the employee database. Access is limited to authorised HR staff, and the record will be kept for the retention periods listed against each field above, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Prepared by
[HR Name]

Approved by
[Authorised Signatory]
Date: [Date]

Download Word (.docx) — free

What this template includes

Field dictionary listing every data point in one place
Data type and format rules to keep entries consistent
Purpose column justifying each field
Access level column for role-based visibility
Retention rule per field group
Owner column naming who keeps each field updated

When to use it

Designing a new HRMS or spreadsheet database from scratch
Auditing an existing database for unnecessary personal data
Briefing an HR software vendor on required fields
Setting role-based access for managers, payroll and HR

How to customise this template

1List every field in your current system before deciding what to keep
2Delete any field where you cannot write a clear purpose
3Set access levels that match your org roles
4Agree retention rules with finance and legal
5Share the final format with your HRMS vendor as the specification

HR tips

Separate sensitive fields such as bank and health data into restricted tables
Use drop-downs instead of free text for department and designation
Mask Aadhaar and store only the last four digits
Review the format once a year or when a new law or process arrives

For HR & hiring managers

Experienced and fresher candidates across India — blue, grey and white collar. Post a job in 5 minutes and start receiving applications.

Post a job free See plans

Post in 5 minutesDescribe the role in one line — we write the job description.
Verified applicantsEvery applicant has a verified mobile number.
Resume databaseSearch experienced candidates by skill, city and experience.

Frequently asked questions

What fields should an employee database have?+

At minimum: employee ID, name, contact, department, designation, manager, joining date, employment type, status, PAN, UAN and bank details for salary. Add fields only when there is a clear purpose.

Who should have access to the employee database?+

HR and payroll typically need full or partial access. Managers should see only their team's work-related data.

How do I make my employee database privacy-friendly?+

Collect only needed fields, restrict access by role, mask identifiers like Aadhaar, and delete data after the retention period.

All 50 employee personal & master records →

[Company Logo][Company Name]
EMPLOYEE PERSONAL INFORMATION FORM
Company:
[Company Name]
Employee ID:
[Employee ID]
Date of Joining:
[Date of Joining]
Form Date:
[Date]
1. Personal Details
Full Name (as per PAN / ID)
Preferred Name
Date of Birth (DD/MM/YYYY)
Gender (optional)
Nationality
Marital Status (optional)
2. Contact Details
Personal Mobile Number
Alternate Mobile Number
Personal Email ID
Current Address with PIN Code
Permanent Address with PIN Code
3. Statutory and Payroll Details
Form · Word
Employee Personal Information Form
Download .docx

Full Name (as per PAN / ID)
Preferred Name
Date of Birth (DD/MM/YYYY)
Gender (optional)
Nationality
Marital Status (optional)

Personal Mobile Number
Alternate Mobile Number
Personal Email ID
Current Address with PIN Code
Permanent Address with PIN Code

[Company Logo][Company Name]

EMPLOYEE MASTER DATA SHEET

Company:: [Company Name]
Data as on:: [DD/MM/YYYY]
Maintained by:: [HR Name]

This sheet holds the minimum master data needed to run payroll, headcount reporting and statutory compliance. Bank details, health information and identity documents are kept in separate restricted records and are not entered here.

Emp ID	Employee Name	Department	Designation	Reporting Manager	Date of Joining	Employment Type	Work Location	UAN	ESIC No.	Status	Last Updated
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]
[Employee ID]	[Employee Name]	[Department]	[Designation]	[Reporting Manager]	[DD/MM/YYYY]	[Permanent / Contract / Trainee]	[Work Location]	[UAN]	[ESIC No. / NA]	[Active / Notice / Exited]	[DD/MM/YYYY]

Column guidance

Emp ID: never reuse an ID after an employee exits.
Employment Type: use only the values in your drop-down list.
ESIC No.: enter NA where wages exceed the ESI coverage limit of ₹21,000 per month.
Status: change to Exited only after the last working day is confirmed.

Privacy notice: [Company Name] collects the details on this page only for workforce administration, payroll and statutory reporting. Access is limited to authorised HR staff, and the record will be kept for as long as the employee is on the rolls and for the archival period in the records retention policy, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Template · Word

Employee Master Data Sheet

Download .docx

[Company Logo][Company Name]

Name of Establishment:: [Company Name]
Address:: [Company Address]
Registration No.:: [Registration Number]
Register Period:: [DD/MM/YYYY] to [DD/MM/YYYY]

Sl. No.	Emp ID	Name of Employee	Father / Spouse Name	Gender	Date of Birth	Designation	Nature of Employment	Date of Joining	Date of Leaving	Reason for Leaving	Initials of Authorised Person
1	[Employee ID]	[Employee Name]	[Name]	[M/F/Other]	[DD/MM/YYYY]	[Designation]	[Permanent / Fixed-term / Contract]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Resignation / Retirement / Other]	[Initials]
2	[Employee ID]	[Employee Name]	[Name]	[M/F/Other]	[DD/MM/YYYY]	[Designation]	[Nature]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Reason]	[Initials]
3	[Employee ID]	[Employee Name]	[Name]	[M/F/Other]	[DD/MM/YYYY]	[Designation]	[Nature]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Reason]	[Initials]

Instructions for maintaining this register

Enter employees in order of joining and keep serial numbers continuous.
Fill Date of Leaving and Reason for Leaving only after exit formalities are complete.
Corrections must be struck through once, rewritten and initialled with the date.
The register must not hold bank, health or full Aadhaar details.
Produce the register when requested by an authorised inspector.

Privacy notice: [Company Name] collects the details on this page only for maintaining the statutory register of employees and confirming service history. Access is limited to authorised HR staff, and the record will be kept for the period required by applicable labour laws and the company retention policy, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Maintained by
[HR Name]
[Designation]

Certified by
[Authorised Signatory]
For [Company Name]

Employee Master Register

Download .docx

[Company Logo][Company Name]
EMPLOYEE ID ALLOCATION FORM
Form No.:
[Reference Number]
Date of Request:
[Date]
Requested by:
[HR Name]
A. Joiner Details
Name of Joiner [Employee Name]
Designation [Designation]
Department [Department]
Reporting Manager [Reporting Manager]
Work Location [Work Location]
Date of Joining [Date of Joining]
B. Category
- Permanent employee
- Fixed-term employee
- Trainee / Apprentice
- Intern
- Rejoining employee (previous ID: [Employee ID])
C. Allocation (HR Operations)
Form · Word
Employee ID Allocation Form
Download .docx

Name of Joiner	[Employee Name]
Designation	[Designation]
Department	[Department]
Reporting Manager	[Reporting Manager]
Work Location	[Work Location]
Date of Joining	[Date of Joining]

[Company Logo][Company Name]

EMPLOYEE CODE REGISTER

Company / Entity:: [Company Name]
Code Series:: [Prefix]-0001 to [Prefix]-9999
Register Owner:: [HR Name]

Employee Code	Employee Name	Department	Category	Allocation Form Ref.	Date Issued	Date Deactivated	Access Removed (Y/N)	Status	Remarks
[Employee ID]	[Employee Name]	[Department]	[Permanent / Contract / Intern]	[Reference Number]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Y/N]	[Active / Deactivated]	[Remarks]
[Employee ID]	[Employee Name]	[Department]	[Category]	[Reference Number]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Y/N]	[Status]	[Remarks]
[Employee ID]	[Employee Name]	[Department]	[Category]	[Reference Number]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Y/N]	[Status]	[Remarks]
[Employee ID]	[Unallotted]	-	-	-	-	-	-	[Available]	[Next in series]

Rules

Each code is allotted once and is never reused.
Every row must reference an approved Employee ID Allocation Form.
On exit, enter the last working day as the deactivation date within two working days.
Quarterly, reconcile active codes with the payroll register and note mismatches below.

Quarterly reconciliation date
Mismatches found
Action taken

This register holds only the details needed to control employee codes. It is accessible to HR operations and internal audit only, as part of the company's data-minimisation practice under the Digital Personal Data Protection Act, 2023.

Employee Code Register

Download .docx

[Company Logo][Company Name]

EMPLOYEE PHOTO REGISTER

Company:: [Company Name]
Location:: [Work Location]
Maintained by:: [HR Name]

Sl.	Employee ID	Employee Name	Date Taken	Purpose	Consent for Optional Use (Y/N)	Storage Location	Deletion Due	Deleted On	HR Initials
1	[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[ID card / Access system]	[Y/N]	[HRMS / Folder path]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Initials]
2	[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Purpose]	[Y/N]	[Location]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Initials]
3	[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Purpose]	[Y/N]	[Location]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Initials]

Permitted purposes

Essential: photo ID card, access control, HRMS profile.
Optional (consent needed): intranet directory, website, brochures, event coverage.

Employee consent for optional use

I, [Employee Name], agree that my photograph may be used for: [Optional Purpose]. I understand I can withdraw this consent at any time by writing to HR, and that withdrawal will not affect my employment.

Employee Photo Register

Download .docx

[Company Logo][Company Name]

SPECIMEN SIGNATURE REGISTER

Company:: [Company Name]
Department:: [Department]
Register Ref.:: [Reference Number]

Employee ID	Employee Name	Designation	Specimen Signature 1	Specimen Signature 2	Initials	Authority / Documents	Limit (₹)	Effective From	Withdrawn On	Attested by
[Employee ID]	[Employee Name]	[Designation]	[Sign]	[Sign]	[Initials]	[Vouchers / Purchase orders]	[Amount]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Authorised Signatory]
[Employee ID]	[Employee Name]	[Designation]	[Sign]	[Sign]	[Initials]	[Authority]	[Amount]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Authorised Signatory]
[Employee ID]	[Employee Name]	[Designation]	[Sign]	[Sign]	[Initials]	[Authority]	[Amount]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Authorised Signatory]

Declaration by authorised employee

I confirm that the specimen signatures and initials above are my own. I will sign company documents only within the authority and limit stated, and I will inform HR immediately if my role changes.

Employee
[Employee Name]
Date: [Date]

Attested by
[Authorised Signatory]
For [Company Name]

Privacy notice: [Company Name] collects the details on this page only for verifying signatures on company documents within delegated authority. Access is limited to authorised HR staff, and the record will be kept for the period of signing authority plus the audit retention period, after which it will be securely deleted or destroyed. You may ask HR to see or correct your data, consistent with the Digital Personal Data Protection Act, 2023.

Employee Signature Register

Download .docx

[Company Logo][Company Name]
EMPLOYEE CONTACT DETAILS FORM
Employee Name:
[Employee Name]
Employee ID:
[Employee ID]
Department:
[Department]
Date:
[Date]
Type of Submission
- New joiner
- Update to existing details
Phone and Email
Primary Mobile Number
Alternate Mobile Number (optional)
Personal Email ID
Official Email ID (HR to fill)
Addresses
Form · Word
Employee Contact Details Form
Download .docx

Primary Mobile Number
Alternate Mobile Number (optional)
Personal Email ID
Official Email ID (HR to fill)

Employee Database Format

Preview of the template

Access levels

What this template includes

When to use it

How to customise this template

HR tips

Hire top talent from BetterJobs

Frequently asked questions

Related HR templates