21 Cineplex — HR & Payroll System
A structured HR & payroll system foundation for a distributed cinema network — employee records, attendance, payroll rules, allowances, employee loans, approvals, and role-based access.
Challenge
21 Cineplex managed HR operations across a distributed cinema network. HR and payroll needed to handle employee profiles, branch and outlet structures, attendance, overtime, salary components, allowances, employee loans, role access, and approval flows.
The complexity came from scale and rules: different locations, positions, salary components, attendance conditions, and payroll formulas had to be represented consistently.
Solution
konsep designed and developed a dedicated HR system covering employee data, cinema/outlet master data, position hierarchy, attendance, payroll components, monthly salary processing, overtime, employee-loan handling, user roles, and approval workflows — backed by a SQL Server database design with stored procedures.
Result
konsep delivered a structured HR/payroll system foundation for managing employee administration, attendance, payroll rules, loan tracking, approval flows, and access control across a distributed cinema operation.
Key features
- Employee profile & organizational hierarchy
- Cinema/outlet and branch master data
- Attendance and overtime calculation
- Monthly salary processing & component mapping
- Employee-loan management
- Approval workflows and role-based access
Technology
- Microsoft SQL Server
- Stored procedures & HR/payroll schema
- Windows Server environment