SQL View

From eStream Software
Revision as of 05:34, 24 September 2019 by Csloo (talk | contribs)


  • SQL View is one of the powerful advance security module to SQL Payroll to limit your employees access and process payroll by designated grouping.
  • For example, KL HR manager can view and handle the KL branch employees only. However, the Penang HR staff will allow to view and handle Penang branch employees only.

1. All branches

All branches view in Maintain Employee
SQL View 01.jpg

2. Branch KL (KL HR Manager View)

Restricted to view and access the KL branch employees.
SQL View 01a.jpg

3. Branch Penang (Penang HR Staff View)

Restricted to view and access the Penang branch employees.
SQL View 01b.jpg

SQL View

Menu: Tools | DIY | Maintain DIY...

SQL View 02.jpg