---
title: SQL - Staff on Access Levels
description: VetLinkPro SQL - Staff on Access Levels
---
# VetLink PRO
Connecting Veterinary Professionals with Smarter Solutions
[Skip to content](https://help.vetlinkpro.com/vetlinkpro/sql-staff-on-access-levels#main-content)
English - Australia
Show submenu for translations
Open main navigation
Close main navigation
- English - Australia
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [VetLink PRO](https://help.vetlinkpro.com/vetlinkpro)
2. [Support](https://help.vetlinkpro.com/vetlinkpro/support)
3. [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)
# SQL - Staff on Access Levels
## v7,v6
See [Create Export to CSV using SQL Query](https://help.vetlinkpro.com/vetlinkpro/create-export-to-csv-using-sql-query) for information on using query below for export to csv.
Note: Access level names in export query need to be updated to match names in options -\> Setup -\> Staff -\> Access tab,
select SM."Id", CM."First\_Name", CM."Last\_Name"
, case when SM."Access" = 0 then 'Owner'
when SM."Access" = 1 then 'Owner'
when SM."Access" = 2 then 'Desk'
when SM."Access" = 3 then 'AccessC' //update name of access level here
when SM."Access" = 4 then 'AccessD' //update name of access level here
when SM."Access" = 5 then 'AccessE' //update name of access level here
when SM."Access" = 6 then 'AccessF' //update name of access level here
when SM."Access" = 7 then 'AccessG' //update name of access level here
else '' end "Access Level"
from "Staff\_Main" SM
join "Client\_Main" CM on CM."Ref\_Number" = SM."Cln\_Link"
where SM."Status" = 'A'
and SM."Id" \<\> 'OWN'
- [Support](https://help.vetlinkpro.com/vetlinkpro/support#main-content)
- [Client Portal](https://help.vetlinkpro.com/vetlinkpro/support#client-portal)
- [Creditors](https://help.vetlinkpro.com/vetlinkpro/support#creditors)
- [Upgrade](https://help.vetlinkpro.com/vetlinkpro/support#upgrade)
- [Payments](https://help.vetlinkpro.com/vetlinkpro/support#payments)
- [Patient](https://help.vetlinkpro.com/vetlinkpro/support#patient)
- [Product](https://help.vetlinkpro.com/vetlinkpro/support#product)
- [Xero](https://help.vetlinkpro.com/vetlinkpro/support#xero)
- [Clinical History](https://help.vetlinkpro.com/vetlinkpro/support#clinical-history)
- [RDS Setup](https://help.vetlinkpro.com/vetlinkpro/support#rds-setup)
- [Client](https://help.vetlinkpro.com/vetlinkpro/support#client)
- [Diary](https://help.vetlinkpro.com/vetlinkpro/support#diary)
- [Mailers](https://help.vetlinkpro.com/vetlinkpro/support#mailers)
- [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)
- [Stocktake](https://help.vetlinkpro.com/vetlinkpro/support#stocktake)
- [Reports](https://help.vetlinkpro.com/vetlinkpro/support#reports)
- [EOP / Statements](https://help.vetlinkpro.com/vetlinkpro/support#eop-statements)
- [Eforms / Digital Forms](https://help.vetlinkpro.com/vetlinkpro/support#eforms-digital-forms)
- [Other](https://help.vetlinkpro.com/vetlinkpro/support#other)
- [Printing](https://help.vetlinkpro.com/vetlinkpro/support#printing)
- [Email](https://help.vetlinkpro.com/vetlinkpro/support#email)
- [Server / Technical](https://help.vetlinkpro.com/vetlinkpro/support#server-technical)
- [Insurance](https://help.vetlinkpro.com/vetlinkpro/support#insurance)
- [Bill](https://help.vetlinkpro.com/vetlinkpro/support#bill)
- [Vac Reminders](https://help.vetlinkpro.com/vetlinkpro/support#vac-reminders)
- [Online Booking](https://help.vetlinkpro.com/vetlinkpro/support#online-booking)
- [Mobile Billing](https://help.vetlinkpro.com/vetlinkpro/support#mobile-billing)
- [Barcoding](https://help.vetlinkpro.com/vetlinkpro/support#barcoding)
- [SMS](https://help.vetlinkpro.com/vetlinkpro/support#sms)
- [General Ledger](https://help.vetlinkpro.com/vetlinkpro/support#general-ledger)
- [Staff](https://help.vetlinkpro.com/vetlinkpro/support#staff)
- [Telemedicine](https://help.vetlinkpro.com/vetlinkpro/support#telemedicine)
- [Manual](https://help.vetlinkpro.com/vetlinkpro/manual#main-content)
- [6.1](https://help.vetlinkpro.com/vetlinkpro/manual#6-1)
- [7.0](https://help.vetlinkpro.com/vetlinkpro/manual#7-0)
[](https://www.vetlinkpro.com)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, VetlinkPRO