SleekView for WP ERP HR: employees, leaves & attendance as tables
WP ERP HR stores employees in wp_erp_hr_employees joined to wp_erp_peoples, leave requests in wp_erp_hr_leave_requests and attendance entries in dedicated tables. SleekView reads those rows directly so HR teams work from one filterable workspace.
♾️ Lifetime License available
HR data without per-employee drill-in
WP ERP HR persists the employee record in wp_erp_hr_employees linked to a person row in wp_erp_peoples. Leave requests live in wp_erp_hr_leave_requests with leave policies in wp_erp_hr_leave_policies and entitlements in wp_erp_hr_leave_entitlements. Department and designation references sit in wp_erp_hr_depts and wp_erp_hr_designations. The default HR UI lists employees on one screen and leave on another, which works for HR admins doing one task at a time and limits cross-screen operations.
SleekView reads wp_erp_hr_employees directly and joins wp_erp_peoples for name and email, wp_erp_hr_depts for department and wp_erp_hr_leave_requests aggregated for pending leave count. Filters combine department, designation, hire date and leave status in saved views. Leave approval becomes a single filtered table instead of a per-request screen walk.
Inline edits route through WP ERP HR's functions where supported, so leave approvals, status changes and designation updates call the same hooks the default UI fires. Audit entries in WP ERP's logs record consistently.
Workflow
HR ops from one filterable workspace
Connect HR tables
wp_erp_hr_employees with joins to wp_erp_peoples, wp_erp_hr_depts and leave tables. The agent offers ready joins for designation and policy references.
Compose employee columns
wp_erp_peoplemeta keys into typed columns for fields like reporting line.
Build a leave approval view
wp_erp_hr_leave_requests page filterable by status, department and date. Surface entitlement balance as a column for at-a-glance approvals.
Approve inline
Sample columns
A typical WP ERP HR leave approval view
wp_erp_hr_leave_requests and joins wp_erp_hr_employees plus wp_erp_peoples for name and department.
wp_erp_hr_employees + wp_erp_peoples + wp_erp_hr_leave_requests
| Employee | Department | Leave type | Days | Status | Start date |
|---|---|---|---|---|---|
| Alex Reiter | Engineering | Vacation | 5 | Pending | Apr 24 |
| Ria Patel | Design | Sick | 2 | Approved | Apr 23 |
| Tom Bailey | Engineering | Vacation | 10 | Approved | Apr 22 |
| Mia Brewer | Operations | Unpaid | 1 | Rejected | Mar 09 |
Comparison
Default WP ERP HR admin vs SleekView
Default WP ERP HR admin
- Employee list and leave request list live on separate screens
- Pending leave approvals do not surface combined with department or designation
-
Custom
wp_erp_peoplemetafields on employees are not exposed as columns - Leave entitlement balance is per-employee, not a sortable column on the leave view
- Bulk approve or reject leave across a filtered cohort requires per-row clicks
SleekView
-
Read directly from
wp_erp_hr_employeeswith joins towp_erp_peoplesand leave tables -
Surface leave balance from
wp_erp_hr_leave_entitlementsas a column - Filter on department, designation, status and date together
- Inline-edit leave status, designation and hire date via WP ERP HR hooks
- Tabbed SleekView pages for employees, leave requests and attendance
Features
What SleekView gives you for WP ERP HR Module
Employee directory as a real table
Join wp_erp_hr_employees with wp_erp_peoples and department references for name, email, designation and start date. Sort, filter and inline-edit from one workspace.
Leave approvals in one view
wp_erp_hr_leave_requests joined to employee, department and policy gives managers a single approval table. Bulk approve a department's pending requests after a planning meeting.
Attendance with proper filters
Build attendance views over the WP ERP HR attendance tables filterable by date range and department. Spot anomalies without per-day spreadsheet exports.
Audience
Who uses SleekView for WP ERP HR
HR admins
Filter employees by department and designation to keep org records tidy. Inline-edit designation and reporting line after a restructure without per-employee screens.
Line managers
Build a pending-leave view filtered to the manager's department. Bulk approve a sprint's requests through WP ERP HR hooks so notifications fire correctly.
People analytics
Aggregate attendance and leave balance for headcount and absenteeism reports. Export filtered views as CSV for the finance partner without per-employee clicks.
The bigger picture
Why HR data needs a real working layer
WP ERP HR shares people storage with CRM and Accounting because employees, customers and vendors often overlap in small-business operations. The HR schema layers wp_erp_hr_employees, wp_erp_hr_leave_requests, leave policies and entitlements on top of that shared base. The default HR admin keeps each concept on its own screen because that is the right shape for data entry and limits the chance of accidental edits across modules.
The cost is that HR teams routinely ask cross-screen questions: pending leave by department, balance by employee, attendance trends by team. SleekView reads the HR tables directly with the joins those questions need, surfaces leave balance and pending counts as columns, and routes inline approvals through WP ERP HR's functions so notifications and audit entries remain correct. HR admins keep org records tidy from one table.
Line managers approve a sprint's leave in one pass. People analytics gets export-ready cohorts without spreadsheet pivots. The shared schema was designed for this kind of joined view; SleekView is the working layer that uses it.
Questions
Common questions about SleekView for WP ERP HR Module
In wp_erp_hr_employees linked to a person row in wp_erp_peoples with a type of employee. Department and designation references sit in wp_erp_hr_depts and wp_erp_hr_designations. SleekView joins those for a complete employee row.
Yes. SleekView reads wp_erp_hr_leave_entitlements and subtracts taken days to compute current balance. Surface balance as a column on the employee or leave-request view.
Yes. Leave status changes call WP ERP HR's approval functions, so employee notifications and audit logs record the same way they would for a default-UI approval.
 
Yes. WP ERP HR stores custom employee fields in wp_erp_peoplemeta. SleekView pivots mapped keys into typed columns for sort and filter.
Yes. Select a filtered set of pending requests and run bulk approve. SleekView writes through WP ERP HR's approval functions per row so balances update correctly.
 
Yes. SleekView paginates server-side and uses indexes on wp_erp_hr_employees and wp_erp_hr_leave_requests. Thousands of employees with department filters render quickly.
Yes. Build a dedicated attendance view over the WP ERP HR attendance tables filterable by date range and department. Sort by missed days to surface follow-up cohorts.
 
Yes. People in wp_erp_peoples are shared across modules. Cross-module SleekView pages can show employee context next to accounting payroll or CRM client interactions.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Woocommerce Quickbooks Sync
- Woocommerce Fulfillment
- Woocommerce Product Addons Pro
- Surecart Checkout
- Wpc Grouped Product
- Yith Woocommerce Subscription
- Edd Stripe Pro
- Woocommerce Checkout Addons
- Wpc Frequently Bought Together
- Woocommerce Paystack
- Woocommerce Klarna Checkout
- Woocommerce Amazon Pay Pro
- Yith Woocommerce Product Bundles
- Thirstyaffiliates
- Woocommerce Bulk Stock Management