SQL View: Difference between revisions

From eStream Software
 
(41 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Introduction==
==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.  
* 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.
* 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.


# All branches view
'''1. All branches'''
::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 />


# Branch KL View
'''2. Branch KL (KL HR Manager 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 />


# Branch Penang View
'''3. Branch Penang (Penang HR Staff 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 />


==SQL View==
==SQL View==
Coming Soon
''Menu: Tools | DIY | Maintain DIY...''
<br />
 
===New View Template===
:1. Right click on Employee (set view for Maintain Employee).
:2. Click on '''New View Template'''.
::[[File:SQL_View_02.jpg |500px]]
<br />
:3. Click on '''New''''.
::[[File:SQL_View_03.jpg |500px]]
<br />
: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'''.
::[[File:SQL_View_04a.jpg |500px]]
<br />
:6. Click to Change from '''AUTOKEY''' to '''BRANCH'''.
::[[File:SQL_View_04b.jpg |300px]]
<br />
'''TIPS:'''
Change to '''DEPARTMENT''' if the view control by Department.
:7. Next, change the operator from '''like''' to '''equals'''
::[[File:SQL_View_04c.jpg |400px]]
<br />
:8. Key-in or paste the '''branch code''' (Copy the branch code from Maintain Branch), eg. 'KL-BRANCH'.
::[[File:SQL_View_04d.jpg |500px]]
<br />
'''NOTE:'''
Remember to put a quoted to branch code, eg. 'KL-Branch'.
 
:9. '''Save''' it.
::[[File:SQL_View_04e.jpg |500px]]
<br />
:10. At DIY View Template screen, select a view template (eg. EMPLOYEE-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 />
 
===User View===
:1. Right click on View Template (eg. EMPLOYEE-KL)
:2. Click on '''User View'''.
::[[File:SQL_View_07.jpg |500px]]
<br />
:3. Tick user view to allow the selected user to view (eg. KL-USER).
::[[File:SQL_View_08.jpg |500px]]
<br />
 
:After the above settings, KL-USER can view, process payroll and print reports for KL branch employees only.
::[[File:SQL_View_09.jpg |900px]]
<br />
 
===User View - More than single condition===
:For example, KL Accountant will process payroll for employees from '''KL Branch''' and '''Accounts department only.'''
::[[File:SQL_View_11.jpg |900px]]
<br />
: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 />

Latest revision as of 10:49, 25 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 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
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...

New View Template

1. Right click on Employee (set view for Maintain Employee).
2. Click on New View Template.
SQL View 02.jpg


3. Click on New'.
SQL View 03.jpg


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.
SQL View 04a.jpg


6. Click to Change from AUTOKEY to BRANCH.
SQL View 04b.jpg


TIPS:
Change to DEPARTMENT if the view control by Department.
7. Next, change the operator from like to equals
SQL View 04c.jpg


8. Key-in or paste the branch code (Copy the branch code from Maintain Branch), eg. 'KL-BRANCH'.
SQL View 04d.jpg


NOTE:
Remember to put a quoted to branch code, eg. 'KL-Branch'.
9. Save it.
SQL View 04e.jpg


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


11. KL view template will be added under Employee (Maintain Employee).
SQL View 06.jpg


User View

1. Right click on View Template (eg. EMPLOYEE-KL)
2. Click on User View.
SQL View 07.jpg


3. Tick user view to allow the selected user to view (eg. KL-USER).
SQL View 08.jpg


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


User View - More than single condition

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


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.
SQL View 10.jpg