SQL View: Difference between revisions

Latest revision as of 10:49, 25 September 2019

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 process payroll for the KL branch employees only. However, the Penang HR staff will allow to view and process payroll for 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.

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 the description (eg. EMPLOYEE-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.

TIPS:
Change to DEPARTMENT if the view control by Department.

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'.

NOTE:
Remember to put a quoted to branch code, eg. 'KL-Branch'.

9. Save it.

10. At DIY View Template screen, select a view template (eg. EMPLOYEE-KL) and click OK.

11. KL view template will be added under Employee (Maintain Employee).

1. Right click on View Template (eg. EMPLOYEE-KL)

2. Click on User View.

3. Tick user view to allow the selected user to view (eg. KL-USER).

After the above settings, KL-USER can view, process payroll and print reports for KL branch employees only.

For example, KL Accountant will process payroll for employees from KL Branch and Accounts department only.

1. At Maintain DIY, click on View Template tab.

2. Double click on the existing Template View (eg. EMPLOYEE-KL).

3. Click to press the button to add a new condition to add new condition. See the screenshot below.

@@ Line 71: / Line 71: @@
 <br />
-===More than single condition View===
+===User View - More than single condition===
-:For example, KL Accountant will process payroll for employees from KL branch Accounts department only.
+:For example, KL Accountant will process payroll for employees from '''KL Branch''' and '''Accounts department only.'''
 ::[[File:SQL_View_11.jpg |900px]]
 <br />
-:Add more conditions by '''press the button to add a new condition'''.
+:1. At Maintain DIY, click on View Template tab.
+:2. Double click on the existing Template View (eg. EMPLOYEE-KL).
+:3. Click to '''press the button to add a new condition''' to add new condition. See the screenshot below.
 ::[[File:SQL_View_10.jpg |600px]]
 <br />