Cold Case~63min

The Employee Who Comped Stays At Properties On The Same Day

Employee EMP-204 issued 6 "goodwill service recovery" point adjustments to just 3 members — 92,000 points total — and on 3 separate dates, logged adjustments at two different properties on the very same day, which one front-desk employee cannot physically do. None of the 3 members has any stay record at all at the property their adjustment was issued for. EMP-311 also issued a goodwill adjustment, to MBR-045 at property P-07, but MBR-045 has a real stay on file at P-07 right before it, and it's EMP-311's only adjustment — a genuine service recovery, not fabrication.

Tables you'll query

membersstayspoint_adjustments

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →