Employee Data Management Overview

Your organization’s single source of truth for every employee record — from hire date to emergency contacts, custom fields to compliance tracking — all governed by configurable permissions and intelligent approval workflows.

---

What is Employee Data Management?

Employee Data Management is MangoApps Workforce’s core HRIS module that centralizes all employee information into a unified, permission-controlled system. It replaces scattered spreadsheets and disconnected databases with a structured platform where profiles are always current, compliance is continuously monitored, and data changes flow through auditable approval workflows.

The module serves every role in your organization: employees manage their own profiles through self-service, managers oversee their teams’ data, and administrators maintain full control over sensitive fields, compliance deadlines, and organizational structure.

🌟 Core Value Proposition

• 📋 Centralized Employee Records — One profile per employee with 40+ standard fields across personal, employment, compliance, and compensation categories
• 🔒 Granular Permission Control — Three-tier edit permissions (employee, manager, admin) with configurable visibility per field
• ✅ Compliance Automation — Proactive alerts for visa expirations, I-9 reverification, probation endings, and missing emergency contacts
• 🤖 AI-Powered Data Quality — Autonomous agent detects incomplete records, monitors compliance deadlines, and sends profile completion reminders

---

How It Works

Employee Data Lifecycle

┌─────────────┐     ┌──────────────┐     ┌────────────────┐     ┌──────────────┐
│   Onboard   │────▶│  Manage &    │────▶│   Compliance   │────▶│  Offboard &  │
│  New Hire   │     │  Self-Service │     │   Monitoring   │     │  Former EE   │
│             │     │              │     │                │     │   Portal     │
│ • CSV Import│     │ • Edit fields│     │ • Visa expiry  │     │ • Pay stubs  │
│ • Custom    │     │ • Request    │     │ • I-9 reverify │     │ • Tax forms  │
│   mappings  │     │   updates    │     │ • Probation    │     │ • Experience │
│ • Bulk add  │     │ • Documents  │     │ • Profiles     │     │   letters    │
└─────────────┘     └──────────────┘     └────────────────┘     └──────────────┘
       │                    │                     │                      │
       ▼                    ▼                     ▼                      ▼
  ┌─────────────────────────────────────────────────────────────────────────┐
  │                      AUDIT TRAIL (PaperTrail)                          │
  │  Every change tracked • Who changed what • Timeline view • Rollback   │
  └─────────────────────────────────────────────────────────────────────────┘

Integration Ecosystem

                        ┌─────────────────────┐
                        │  Employee Data Mgmt  │
                        │    (Core Module)     │
                        └──────────┬──────────┘
                                   │
          ┌────────────────────────┼────────────────────────┐
          │                        │                        │
    ┌─────▼──────┐          ┌─────▼──────┐          ┌─────▼──────┐
    │Compensation│          │ Onboarding │          │ Offboarding│
    │ Management │          │    Hub     │          │    Hub     │
    └────────────┘          └────────────┘          └────────────┘
          │                        │                        │
    ┌─────▼──────┐          ┌─────▼──────┐          ┌─────▼──────┐
    │  Payroll   │          │  Training  │          │  Former EE │
    │  Connect   │          │  Connect   │          │   Portal   │
    └────────────┘          └────────────┘          └────────────┘
          │                        │                        │
    ┌─────▼──────┐          ┌─────▼──────┐          ┌─────▼──────┐
    │   EPMS     │          │   Skills   │          │ HR File    │
    │Performance │          │  Tracking  │          │  Manager   │
    └────────────┘          └────────────┘          └────────────┘

---

Key Features

📊 Standard Field Configuration

Administrators can configure which of the 40+ built-in employee fields are active, required, or visible — and who can edit them.

Setting	Options	Description
Edit Permission	Employee / Manager / Admin Only	Controls who can directly change a field value
Required	Yes / No	Whether the field must be filled for profile completeness
Show in Directory	Yes / No	Whether the field appears in the employee directory
Manager Viewable	Yes / No	Whether managers can see this field on their reports’ profiles
Active	Yes / No	Whether the field appears at all in the system
Risk Category	Routine / Standard / Critical	Determines approval workflow routing priority

Field Sections:

Section	Examples	Default Risk
Personal Information	First Name, Last Name, Date of Birth, Gender, Pronouns	Standard
Contact Information	Email, Phone, Address, City, State, ZIP	Routine
Employment Details	Hire Date, Job Title, Department, Manager, FLSA Status	Standard
Compensation	Pay Grade, Pay Band, Bonus Eligibility, Bonus Target %	Critical
Compliance & Legal	Employee ID, SSN Last 4, I-9 Dates, Visa Expiry, Citizenship	Critical
Onboarding	Onboarding Status, Onboarding Completed Date	Standard
Offboarding	Termination Date, Last Day, Termination Type, Rehire Eligible	Critical

Pro Tip: Fields like first_name and last_name are always required and always visible — they cannot be hidden or made optional. Sensitive fields like SSN and visa data are marked as sensitive by default and restricted to admin-only access.

---

🏗️ Custom Fields

Extend employee profiles beyond the standard fields with fully configurable custom fields.

Field Type	Use Cases
Text / Textarea	Employee ID from legacy system, notes, certifications
Number / Currency	Equipment value, parking spot number
Email / Phone / URL	Secondary contacts, LinkedIn profiles
Select / Multi-Select / Radio	T-shirt size, office preference, dietary restrictions
Checkbox	Agreements, opt-ins
Date / DateTime / Time	License expiration, CPR certification date
File	Uploaded certifications or documents
Rating	Internal skill self-assessments

Custom Field Categories:

• Personal — Stored in employment_metadata.custom_fields
• Employment — Stored in employment_metadata.custom_fields
• Compliance — Stored in compliance_metadata.custom_fields
• Custom — General-purpose catch-all

Each custom field supports:

• Drag-and-drop ordering (position-based)
• Validation rules (min/max, regex patterns)
• Permission-level editing (employee / manager / admin only)
• Directory visibility toggle
• Active/inactive toggling without data loss

Pro Tip: Use the Custom Fields Usage report to identify fields with low completion rates and decide whether to make them required or remove them.

---

🔄 Profile Update Request Workflow

When employees need to change fields they don’t have permission to edit directly, they submit update requests that flow through a configurable approval workflow.

┌──────────┐     ┌───────────────┐     ┌──────────────┐     ┌──────────┐
│ Employee │────▶│ Rules Engine  │────▶│   Approver   │────▶│  Applied │
│ Requests │     │ Routes To:    │     │  Reviews     │     │ to User  │
│  Change  │     │               │     │              │     │ Profile  │
│          │     │ • Manager     │     │ • Approve    │     │          │
│ + Reason │     │ • Admin       │     │ • Reject     │     │ + Audit  │
│ + Docs   │     │ • Auto-approve│     │ • Escalate   │     │   Trail  │
└──────────┘     └───────────────┘     └──────────────┘     └──────────┘
                         │
                  ┌──────▼──────┐
                  │  SLA Timer  │
                  │ • Reminders │
                  │ • Escalation│
                  │ • Daily     │
                  │   Digest    │
                  └─────────────┘

Approval Routing Logic:

Field Permission Level	Routing Behavior
Employee Editable	No approval needed — direct edit
Manager Editable	Routes to employee’s direct manager
Admin Only	Routes to HR administrators

Workflow Capabilities:

Feature	Description
Auto-Approval Rules	Define rules to automatically approve low-risk changes (e.g., phone number updates)
Routing Rules	Assign specific admins to specific field categories
Multi-Level Workflows	Chain approvals: Manager → HR → Finance for compensation fields
SLA Enforcement	Configurable reminder (default: 3 days) and escalation (default: 5 days) timers
Manager Delegation	PTO-aware routing that skips to skip-level manager when assigned manager is on leave
Supporting Documents	Employees attach proof (PDFs, images) to substantiate their requests
Effective Dates	Schedule changes for future dates with automatic application
Impact Detection	Automatically flags changes that affect payroll, benefits, or compliance systems

Email Notifications:

Event	Recipient
Request Submitted	Employee (confirmation)
Manager Request Received	Assigned manager
Request Approved	Employee
Request Rejected	Employee (with reason)
Manager Reminder	Manager (after SLA reminder period)
Request Escalated	Admin team (when manager SLA exceeded)
Scheduled Change Applied	Employee
Scheduled Change Failed	Admin team
Daily Digest	Admins with pending requests

---

🛡️ Compliance Monitoring

Proactive compliance tracking with dedicated dashboards for each compliance area.

Compliance Check	Trigger	Alert Level
Missing Emergency Contacts	Employee has no emergency contacts in JSONB field	⚠️ Warning
Visa Expiring	Work visa expires within 60 days	⚠️ Warning
I-9 Reverification	I-9 reverification date within 30 days	🔴 Danger
Probation Ending	Probation end date within current month	ℹ️ Info
Incomplete Profiles	Missing phone, hire date, or job title	ℹ️ Info

Each compliance view provides:

• Paginated list of affected employees (50 per page)
• Employee details with location, department, and manager
• Bulk selection for sending reminder notifications
• Direct links from the admin dashboard alerts panel

---

📈 Profile Completion Tracking

Monitor and improve data quality across your workforce.

Metric	Description
Overall Completion Rate	Percentage of employees with all required fields filled
Completion Distribution	Breakdown by range: 0-25%, 26-50%, 51-75%, 76-99%, 100%
Incomplete Users	Paginated list sorted by completion percentage (lowest first)
Required Fields	Hire date, phone, emergency contacts, employment status

The profile completeness score is calculated per employee based on:

• Hire date present
• Phone number present
• At least one emergency contact
• Employment status set

---

📂 Employee Documents

Manage employee documents with expiration tracking and type categorization.

Document Type	Examples
Certification	Professional certifications, training completions
License	Driver’s license, professional licenses
ID Document	Passport, work permit, national ID
Contract	Employment agreements, NDAs
Other	Miscellaneous employee documents

Document Features:

• File attachment support (PDF, DOC, DOCX, JPG, PNG — max 10MB)
• Expiration date tracking with expiring_soon and expired scopes
• Automatic file metadata capture (filename, content type, file size)
• Business-scoped with user association

---

📥 Import & Export

Bulk manage employee data through CSV import/export with flexible mapping.

Capability	Description
CSV Import	Upload employee data with add-only or add-and-update modes
Custom Column Mappings	Map CSV columns to MangoApps fields with saved mapping templates
Match Fields	Identify employees by email, user ID, external employee ID, or MangoApps employee ID
Import History	Track all imports with status, counts (created/updated/failed), and error details
CSV Export	Export filtered employee data to CSV
Bulk Actions	Bulk update roles, departments, leave policies, and skills from the admin users view

---

🏢 Organizational Departments

Hierarchical department structure with full tree operations.

Feature	Description
Nested Hierarchy	Unlimited depth parent-child department structure
Department Managers	Assign managers with effective manager inheritance up the tree
Path-Based Queries	Efficient ancestor, descendant, subtree, and sibling lookups
Auto-Team Creation	Automatically creates scheduling teams when new departments are added
Job Family Linking	Bi-directional sync between departments and job families
CSV Import	Bulk import departments from CSV

---

🧑‍💼 Emergency Contacts

Employees manage their own emergency contacts through a self-service JSON-based interface.

Action	Method
Add contact	POST /employee/emergency_contacts
Update contact	PATCH /employee/emergency_contacts/:index
Remove contact	DELETE /employee/emergency_contacts/:index

Emergency contacts are stored as JSONB arrays on the user record, supporting multiple contacts per employee with name, phone, and relationship fields.

---

🤖 AI-Powered Employee Data Agent

An autonomous AI agent continuously monitors employee data quality and compliance.

Capability	What It Detects
Data Validation	Employee records with missing required fields (name, email, phone, department)
Profile Completeness	Employees below the configurable completeness target (default: 80%)
Compliance Monitoring	Expiring I-9 verifications, expired background checks, probation periods ending

The agent runs on a 15-minute schedule and generates actionable opportunities:

• Data Quality Reports sent to administrators when incomplete records are detected
• Profile Completion Reminders sent to individual employees below target
• Probation Review Reminders sent to managers and employees when probation ends within 14 days
• I-9 Expiration Reports sent to administrators for bulk compliance action

---

🕰️ Audit Trail & History

Every change to employee data is tracked through PaperTrail with a comprehensive timeline view.

Tracked Event	Icon	Category
Profile Created	👤+	Personal
Field Updated	✏️	Varies by field
Role Changed	🛡️	Employment
Location Assigned/Removed	📍	Location
Document Uploaded/Removed	📄	Documents
Terminated	👤-	Employment
Promoted	⬆️	Employment

Audit Features:

• Full changeset tracking (old value → new value)
• Who made each change (whodunnit tracking)
• Date range filtering
• Statistics: total changes, unique editors, days since last change
• Human-readable descriptions with field-specific formatting

---

🏛️ Former Employee Portal

A secure self-service portal for former employees to access their historical employment documents.

Feature	Description
Pay Stubs	Access historical paycheck records
Tax Forms	Download W-2s and 1095-C forms
Experience Letters	Request and download employment verification letters
HR Files	Access non-confidential HR documents
Configurable Access	Set access duration (years), token validity (1-30 days)
Auto-Send on Termination	Optionally send portal access automatically when employee is offboarded
Branded Portal	Uses unified public portal layout with business branding

---

User Roles & Permissions

Capability	Employee	Manager	HR Admin	Super Admin
View own profile	✅	✅	✅	✅
Edit employee-editable fields	✅	✅	✅	✅
Submit update requests	✅	✅	✅	✅
Cancel own pending requests	✅	✅	✅	✅
Manage emergency contacts	✅	✅	✅	✅
View direct reports’ profiles	—	✅	✅	✅
Edit manager-editable fields	—	✅ (reports)	✅	✅
Approve manager-level requests	—	✅ (reports)	✅	✅
View admin-only fields	—	—	✅	✅
Edit admin-only fields	—	—	✅	✅
Approve/reject all requests	—	—	✅	✅
Configure standard fields	—	—	✅	✅
Manage custom fields	—	—	✅	✅
Access compliance dashboards	—	—	✅	✅
Import/export employee data	—	—	✅	✅
Manage module settings	—	—	✅	✅
View audit history	—	—	✅	✅
Configure Former EE Portal	—	—	✅	✅

---

Getting Started

For Employees

1. Access your profile — Navigate to your user profile through the unified profile page
2. Edit allowed fields — Directly update fields marked as employee-editable (preferred name, personal email, phone, address)
3. Request restricted changes — Use the “Request Update” link on fields you cannot edit directly; provide a reason and optional supporting documents
4. Track your requests — Visit the Update Requests page to see pending, approved, and rejected requests
5. Manage emergency contacts — Add, edit, or remove emergency contacts from your profile

For Managers

1. Review team profiles — Access your direct reports’ profiles to view manager-viewable fields
2. Approve update requests — Review and approve/reject profile change requests from your team members
3. Monitor completeness — Identify team members with incomplete profiles and encourage completion
4. Edit manager fields — Directly update manager-editable fields (work phone, bio, time zone) for your reports

For Administrators

1. Enable the module — Activate Employee Data Management from System Modules in the admin panel
2. Configure standard fields — Set which fields are active, required, employee-editable, and directory-visible
3. Set up custom fields — Create organization-specific fields for data not covered by standard fields
4. Configure approval workflows — Set up auto-approval rules, routing rules, and multi-level workflows
5. Import employee data — Use CSV import with custom column mappings to bulk-load employee records
6. Monitor compliance — Review compliance dashboards for visa expirations, I-9 reverification, and missing contacts
7. Configure Former Employee Portal — Enable portal access, set duration, and choose available documents
8. Load sample data — Use the “Load Sample Data” button in settings to populate demo employees for testing

---

Best Practices

• ✅ Start with standard field configuration — Review all 40+ fields and set appropriate permission levels before inviting employees
• ✅ Use the three-tier permission model — Assign employee-edit for low-risk fields, manager-edit for team-relevant fields, and admin-only for sensitive data
• ✅ Enable compliance monitoring early — Set up visa expiry notifications (60 days) and I-9 reverification alerts (30 days) before they become urgent
• ✅ Configure SLA timers — Set reminder days (1-10) and escalation days (3-14) that match your organization’s response expectations
• ✅ Create saved import mappings — Save column mapping templates for recurring CSV imports from external HRIS or payroll systems
• ✅ Monitor profile completion — Use the profile completion dashboard to identify and address data gaps systematically
• ✅ Leverage custom fields sparingly — Only create custom fields for data not covered by the 40+ standard fields; excessive fields reduce completion rates
• ✅ Review audit trails regularly — Use the employee audit history to verify data integrity and track unauthorized changes
• ✅ Enable the AI agent — Turn on data validation, profile completeness, and compliance monitoring capabilities for proactive data quality management
• ✅ Configure the Former Employee Portal — Provide self-service access to reduce HR workload for document requests from former staff

---

Related Resources

• Compensation Management Overview — Manage salary, pay grades, and compensation workflows
• Offboarding Hub Overview — Streamline employee departures and termination workflows
• Onboarding Hub Overview — Automate new hire onboarding tasks and document collection

---

Employee Data Management — the foundation of your workforce platform, keeping every record accurate, compliant, and accessible to the people who need it.