| Line 3: | Line 3: | ||
* 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. | * 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 view | |||
::All branches view in Maintain Employee | ::All branches view in Maintain Employee | ||
::[[File:SQL_View_01.jpg |500px]]<br /> | ::[[File:SQL_View_01.jpg |500px]]<br /> | ||
2. Branch KL View | |||
::Restricted to view and access the KL branch employees. | ::Restricted to view and access the KL branch employees. | ||
::[[File:SQL_View_01a.jpg |500px]]<br /> | ::[[File:SQL_View_01a.jpg |500px]]<br /> | ||
3. Branch Penang View | |||
::Restricted to view and access the Penang branch employees. | ::Restricted to view and access the Penang branch employees. | ||
::[[File:SQL_View_01b.jpg |500px]]<br /> | ::[[File:SQL_View_01b.jpg |500px]]<br /> | ||
Revision as of 04:34, 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 view
- All branches view in Maintain Employee
2. Branch KL View
- Restricted to view and access the KL branch employees.
3. Branch Penang View
- Restricted to view and access the Penang branch employees.
SQL View
Coming Soon