Spreadsheet: 801323d1666172457-merging-3-sheets-to-one-then-using-filter-function-example-attached-excel-help-4
Sheet: Tina

85% Zoom | Requsition Updates - Tina
 | Employee Details |  |  |  |  |  |  |  |  | Ad Details |  |  |  |  |  |  |  |  |  | Onboarding Progress |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
 | Name | Position | State | Clinic | Hiring Manger | Entity | Employment Type | Requisition Type |  | Job Ad ID | Quantity | Number of Relists | Posted | Check In | [NAME] | Listing Type | Status | Req paper |  | SharePoint Created | Resume Uploaded | [NAME] | [NAME] | PEM Sent D&A Booked | PEM Determination | D&A Determination | AHPRA Registration | [NAME] | Contract Details From HM | Contract Drafted | [NAME] by HM | Flare Uploaded | [NAME] | Litmos User Form | Litmos Welcome | Job Adder Updated | SharePoint Folder Moved |  | Complete % | Completed | Medical Date | Onboarding Start Date | Last Updated | Complete Date | Duration (Days) | Duration from Ad (Days) | Next Action/Notes | All Comments
 | 111 | MR | QLD |  |  |  | Casual | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 222 | MR | QLD |  |  |  | PPT | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 333 | RN | QLD |  |  |  |  | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 444 | MR | QLD |  |  |  | PPT | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 555 | MR | QLD |  |  |  | PPT | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 666 | PM | QLD |  |  |  |  | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 777 | 2IC | QLD |  |  |  | PFT | New Hire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | [NAME] O'connor | 2IC | QLD | Bundall Medical Centre | [NAME] | PHMC | PFT | Variation |  | 970028 |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Yes |  |  |  |  |  |  | True | 16 |  |  |  |  |  | Bundall 2IC variation to PM with 6 month probation - Due to current PM role change. New 2IC will be requested and advertised. | Signed on flare
 | [NAME] | OHN | QLD | [NAME] | [NAME] | Jobfit | PFT | Variation |  | 973759 |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Yes |  |  |  |  |  |  | True | 16 |  |  |  |  |  | [NAME] increase to $38
 | [NAME] | MR | VIC | Templestowe District Medical Centre | [NAME] | PHMC | PPT | Variation |  | 968535 |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | No |  |  |  |  |  |  | False | 20
 | [NAME] | RN |  | Park Orchards Family Practice |  |  |  | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  | Yes | Requested |  |  |  |  |  |  |  |  | False | 20
 | [NAME] | MR |  | Broadway General Practice |  |  |  | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  | Yes | Requested |  |  |  |  |  |  |  |  | False | 20
 | [NAME] | MR |  | Cairns Cosmetic Clinic |  |  |  | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  | Yes | Requested |  |  |  |  |  |  |  |  | False | 20
 | Justeen Claire Vilocino | 2IC | QLD | Indooroopilly General Practice | [NAME] | PHMC | PFT | Variation |  | 919546 | 1 | 2 | 2022-08-31 00:00:00 |  | 2022-09-28 00:00:00 | Standard | Searching | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | 6 |  |  |  |  |  | Julie: "I will check with Sati and Justeen to work out what days are best. Justeen is doing Uni exams in Oct/Nov, will reach out and organise." UPDATE 11/10 - Mater hill MR to step up - awaiting VA (13/10), looks like we are waiting on a new MR at Mater Hill to be hired & trained before this takes effect | x2 interviews being set up, potential for 1-2 RN roles at clinic with staff expected to depart, have advised to put a request through - V Re-listed (x3) - 1.5k Sign on Bonus from Lyn (if desperate) - V to jump in and shortlisted, strategy to recruit MR looking to step up (healthcare exp = must for [NAME]) + vibes
 | [NAME] | MR | QLD | Marroochydore Medical Centre | [NAME] | PHMC | PPT | Variation |  | 953541 |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  | False | 16 |  |  |  |  |  | Increase Ayu Bolton hours from 64 hours per fortnight to 72 hours per fortnight (8 days to 9 days)
 | [NAME] (glasshouse) | PM | QLD | Woodford Family Medical Centre | [NAME] | PHMC | PFT | Variation |  | Not yet confirmed |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | 20
 | Karin (MR) | 2IC | QLD | Woodford Family Medical Centre | [NAME] | PHMC |  | Variation |  | Not yet confirmed by bnette |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | 20