| Line 19: | Line 19: | ||
==SQL View== | ==SQL View== | ||
===Setup New View Template=== | |||
''Menu: Tools | DIY | Maintain DIY...'' | ''Menu: Tools | DIY | Maintain DIY...'' | ||
<br /> | <br /> | ||
| Line 43: | Line 44: | ||
:9. '''Save''' it. | :9. '''Save''' it. | ||
::[[File:SQL_View_04e.jpg |500px]] | ::[[File:SQL_View_04e.jpg |500px]] | ||
<br /> | |||
:10. At DIY View Template screen, select a view template (eg. KL) and click '''OK'''. | |||
::[[File:SQL_View_05.jpg |500px]] | |||
<br /> | |||
:11. KL view template will be added under '''Employee''' (Maintain Employee). | |||
::[[File:SQL_View_06.jpg |500px]] | |||
<br /> | <br /> | ||
Revision as of 07:50, 24 September 2019
Introduction
- 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
2. Branch KL (KL HR Manager View)
- Restricted to view and access the KL branch employees.
3. Branch Penang (Penang HR Staff View)
- Restricted to view and access the Penang branch employees.
SQL View
Setup New View Template
Menu: Tools | DIY | Maintain DIY...
- 1. Right click on Employee (set view for Maintain Employee).
- 2. Click on New View Template.
- 3. Click on New'.
- 4. At View Template form, key-in description (eg. KL).
- 5. At Filter tab, add the condition by press the button to add a new condition.
- 6. Click to Change from AUTOKEY to BRANCH.
- 7. Next, change the operator from LIKE to EQUALS
- 8. Key-in or paste the branch code (Copy the branch code from Maintain Branch), eg. KL-BRANCH.
- 9. Save it.
- 10. At DIY View Template screen, select a view template (eg. KL) and click OK.
- 11. KL view template will be added under Employee (Maintain Employee).
