Spreadsheet: 866749d1713646673-stuck-on-power-query-dec17-23-wk1
Sheet: Nights

[EMAIL]
 |  |  | EMPLOYEE’S DAILY / WEEKLY TIME RECORD
PINECREST - NIGHTS
 |  |  | WEEK 1
MECHANICS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2023-12-17 00:00:00 |  | 2023-12-18 00:00:00 |  | 2023-12-19 00:00:00 |  | 2023-12-20 00:00:00 |  | 2023-12-21 00:00:00 |  | 2023-12-22 00:00:00 |  | 2023-12-23 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
 |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 07:30
3351 | Grace | [NAME] | VAC |  | VAC |  | VAC |  | VAC |  | VAC |  | DO |  | DO
135455 | Lucas | [NAME] |  |  |  |  |  |  |  |  |  |  | DO |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  | 129996 |  | 129996 |  | 129996 |  | 129996 |  | 129996
 |  |  | EMPLOYEE’S DAILY / WEEKLY TIME RECORD
PINECREST - NIGHTS
 |  |  | WEEK 1
ATTENDANTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2023-12-17 00:00:00 |  | 2023-12-18 00:00:00 |  | 2023-12-19 00:00:00 |  | 2023-12-20 00:00:00 |  | 2023-12-21 00:00:00 |  | 2023-12-22 00:00:00 |  | 2023-12-23 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
sd | sdfsdf |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 07:30
135683 | [NAME] | Hernandez | VAC |  | VAC |  | VAC |  | VAC |  | VAC |  | DO |  | DO
127100 | Amelia | King |  |  |  |  |  |  |  |  |  |  | DO |  | DO
7073 | [NAME] | [NAME] | VAC |  | VAC |  | VAC |  | VAC |  | VAC |  | DO |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  | 129996 |  | 129996 |  | 129996 |  | 129996 |  | 129996
 |  |  | EMPLOYEE’S DAILY / WEEKLY TIME RECORD
PINECREST - COUNTDOWN
 |  |  | WEEK 1
ATTENDANTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2023-12-17 00:00:00 |  | 2023-12-18 00:00:00 |  | 2023-12-19 00:00:00 |  | 2023-12-20 00:00:00 |  | 2023-12-21 00:00:00 |  | 2023-12-22 00:00:00 |  | 2023-12-23 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
 |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
20:00-4:30
133213 | [NAME] | Brooks | DO |  |  |  |  |  |  |  | PLP#1 | 8 |  |  | DO
159557 | [NAME] | Reed | DO |  |  |  |  |  |  |  | Lt | 1.5 |  |  | DO
156368 | Victoria | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
136113 | Logan | Scott | DO |  |  |  |  |  |  |  |  |  |  |  | DO
167090 | Emma | Green | DO |  | EV | 8 |  |  |  |  | Sick | 7.5 |  |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  | 129996 |  | 129996 |  | 129996 |  | 129996 |  | 129996 | 3167 | 3354
CODES: |  |  | DO = DAY OFF   VAC = VACATION   E.V. = EMERGENCY VACATION  B=[NAME] (MUST STATE RELATIONSHIP TO EE)
 |  |  | LT = LATE  U- UNION BUSINESS  SE = SHIFT EXCHANGE NOT WORKED   SEW = SHIFT EXCHANGE WORKED
 |  |  | M = MEDICAL FOR [NAME] (2 HR. MAX.)   T = TRAINING   SU = SUSPENSION   X = REHAB WORKED
 |  |  | E = EXCUSED LEAVE (48 HRS. NOTICE GIVEN)   IE - IN EXCUSED LEAVE (NO NOTICE GIVEN)
 |  |  | S = SICK   IL = INVESTIGATORY LEAVE     PL = PARENTAL LEAVE      LTD = LONG TERM DISABILITY    MT = MAKE UP TIME
 |  |  | TI = TRANSFERRED IN FROM OTHER LOCATION   TO = TRANSFERRED OUT TO ANOTHER LOCATION |  |  |  |  |  |  |  |  |  |  |  | Si=isolation leave
 |  |  | … PLP – Personal [NAME] and PLU – Personal Leave Unpaid |  |  |  |  |  |  |  | (Please also add number code i.e. PLP-1)
 |  |  | 1. Personal illness/injury;
 |  |  | 2. Responsibilities related to health or care of any family member; |  |  |  |  |  |  |  |  |  | JD-Jury Duty
 |  |  | 3. Responsibilities related to education of any of their family members who are under 18 years of age;
 |  |  | 4. Addressing any urgent matter concerning themselves or their family;
 |  |  | 5. Attending their citizenship ceremony; or,
 |  |  | 6. Other reasons prescribed by regulation.