---
title: Staff Member Already in the Diary
description: Check if staff was replaced on the diary for a day
---
# VetLink PRO
Connecting Veterinary Professionals with Smarter Solutions
[Skip to content](https://help.vetlinkpro.com/vetlinkpro/staff-memeber-already-in-the-diar#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. [Diary](https://help.vetlinkpro.com/vetlinkpro/support#diary)
# Staff Member Already in the Diary
## v7
from version 7.3.4 if you get message saying staff member already in the diary it may be because they have been "Replaced" as staff on the diary.
You can run query below to see if replace was used
**select DRD."Ref\_Number", "Branch", DP."Dry\_Name" "Diary", DRD."Date", DRD."Modified\_On",**
**DRD."Org\_Staff", SM2."Id", DRD."Stf\_Num", SM1."Id", DRD."Start", DRd."Finish"**
**from "Diary\_Roster\_Day" DRD**
**join "Diary\_Profile" DP on DP."Site\_Ref" = DRD."Branch" and DRD."Dry\_Num" = Dp."Dry\_Number"**
**left outer join "Staff\_Main" SM1 on SM1."Ref\_Number" = DRD."Stf\_Num"**
**left outer join "Staff\_Main" SM2 on SM2."Ref\_Number" = DRD."Org\_Staff"**
**where ("Org\_Staff" = 1000000???? or "Stf\_Num" = 1000000????) //Staffnumber to search**
**and "Date" = '?? ??? 20??'//Day of error**
If they have been replaced you can use below to remove the OrgStaff
**update "Diary\_Roster\_Day"**
**set "Org\_Staff" = null**
**where "Ref\_Number" = 100000?????**//Ref number from previous query of row to update
- [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