Breadcrumbs

Room History .ng

Room History Report Overview

Parent Hub: 🧹 Rooms & Facilities

Category: 📋 Operations Analytics

Target Roles: Executive Housekeepers, Chief Engineers, Front Office Managers, Security & Loss Prevention Directors, Operations Analysts, General Managers

Key Value: Serves as an immutable chronological audit trail tracking every physical room status transition, housekeeping update, attendant assignment, occupancy state change, and maintenance event executed across property accommodations.

Executive Summary

The Room History Report is an essential operational compliance, forensic audit, and room lifecycle document within the 📋 Operations Analytics category of the 🧹 Rooms & Facilities hub. Designed to provide full historical transparency over physical guest room events, it logs every status change, staff action, and maintenance update recorded in the Property Management System (PMS) across specified date windows.

  • By mapping location parameters (Room Number, Floor Number, Building) to audit timeframes (Calendar Date, Business Date, Time), staff user credentials (Username), action classifications (Action Performed, e.g., Changed Housekeeping Status, Assigned Housekeeper, Changed Occupancy Status), root cause triggers (Reason, Start Date, End Date), state transitions (Previous Housekeeping Status, Current Housekeeping Status, Previous Occupancy Status, Current Occupancy Status), guest reservation profiles (Guest Name, First Name, Last Name, Confirmation Number, Check In Date), and operational notes (Remarks), this report enables management to conduct forensic investigations, audit staff accountability, track room turnover cycles, and resolve operational disputes.

Key Capabilities

  • Immutable Room Lifecycle Audit Trail: Captures a sequential, timestamped log of all physical room status modifications and attendant assignments.

  • Housekeeping & Occupancy State Transition Analysis: Tracks exact prior and resulting states (Previous Housekeeping Status to Current Housekeeping Status, Previous Occupancy Status to Current Occupancy Status) to verify room cleaning and inspection workflows.

  • Staff User Accountability Trace: Identifies the precise staff member (Username) responsible for executing each status update or room attendant allocation.

  • Maintenance & Out-of-Order Linkage: Correlates room status changes with maintenance reasons (Reason, e.g., PREVENTATIVE MAINTENANCE, CHANGING ROOM, DOOR LOCK BROKEN, CARPET SHAMPOO) and date ranges (Start Date, End Date).

  • Guest Reservation Context Alignment: Connects room state changes directly to active in-house guest profiles (Guest Name, Confirmation Number, Check In Date) to audit room moves or occupancy discrepancies.

Report Views & Functional Breakdown

The Room History Report presents historical room event data in a unified single-table master matrix supporting three primary operational perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                        ROOM HISTORY REPORT                             │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Location & Event      │ 2. Status Transition &   │ 3. Guest Profile │
│    Audit Matrix          │    Maintenance Reason    │    & Order Trace │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Location & Event Audit Matrix

Monitors physical room locations, floor levels, building wings, action timestamps, operational business dates, and staff user credentials.

  • Primary Use: Investigating staff actions performed on a specific room at a precise date and time.

  • Key Metrics: Room Number, Floor Number, Building, Calendar Date, Business Date, Time, Username, Action Performed.

2. Status Transition & Maintenance Reason

Tracks historical cleanliness and occupancy progression alongside maintenance task reasons and effective date windows.

  • Primary Use: Verifying proper room cleaning progression (e.g., Dirty > Ready For Inspection > Ready For Guest) and auditing maintenance holds.

  • Key Metrics: Action Performed, Reason, Start Date, End Date, Previous Housekeeping Status, Current Housekeeping Status, Previous Occupancy Status, Current Occupancy Status.

3. Guest Profile & Order Trace

Correlates room event logs with registered guest names, reservation confirmation numbers, and arrival dates.

  • Primary Use: Reconciling room status changes against active guest stays and investigating guest billing or room condition complaints.

  • Key Metrics: Guest Name, First Name, Last Name, Confirmation Number, Check In Date, Remarks.

Image 10-18-26 at 7.58 PM.png
Room History Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary sorted in alphabetical order by column name:

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Action Performed

Classification of the operational change executed on the room (e.g., Changed Housekeeping Status, Assigned Housekeeper, Changed Occupancy Status).

Room Audit Engine > Action Type

N/A

Building

Designation or name of the physical building structure or wing (e.g., BUILDING 1).

PMS Setup > Building Structure

N/A

Business Date

Property operational business date under which the room audit event was posted.

PMS Calendar > Business Date

N/A

Calendar Date

Actual calendar date on which the room audit action occurred.

System Clock > Logged Date

N/A

Check In Date

Scheduled or actual arrival date of the active reservation linked to the room.

Reservation System > Arrival Date

N/A

Confirmation Number

Primary unique alphanumeric reservation identifier associated with the room stay.

Reservation System > Confirmation ID

N/A

Current Housekeeping Status

Cleanliness state resulting from the action (e.g., Ready For Guest, Ready For Inspection, Dirty).

Housekeeping Engine > Result Status

N/A

Current Occupancy Status

Physical occupancy state resulting from the action (e.g., Vacant, Occupied).

PMS Inventory Engine > Result Occupancy

N/A

End Date

Ending date of the maintenance, out-of-order, or stay window associated with the room action.

Work Order / Stay > End Date

N/A

First Name

First name of the registered primary guest occupant.

Guest Profile > First Name

N/A

Floor Number

Physical building floor level location (e.g., FLOOR 10, FLOOR 2, FLOOR 3, FLOOR 4).

PMS Setup > Floor Level

N/A

Guest Name

Combined full name of the registered primary guest occupant (e.g., FULLER JAMES).

Guest Profile > Full Name

N/A

Last Name

Last name of the registered primary guest occupant.

Guest Profile > Last Name

N/A

Previous Housekeeping Status

Cleanliness state prior to the action (e.g., Ready For Inspection, Dirty, Ready For Guest).

Housekeeping Engine > Prior Status

N/A

Previous Occupancy Status

Physical occupancy state prior to the action (e.g., Occupied, Vacant).

PMS Inventory Engine > Prior Occupancy

N/A

Reason

Primary cause or trigger description associated with the room action (e.g., PREVENTATIVE MAINTENANCE, CHANGING ROOM, DOOR LOCK BROKEN, CARPET SHAMPOO).

Maintenance / Room Engine > Reason Code

N/A

Remarks

Free-text operational audit notes or handling instructions.

Audit Log > Remarks Notes

N/A

Room Number

Physical guest room number assigned on property (e.g., 1001, 1004, 1006, 1007).

PMS > Physical Room ID

N/A

Start Date

Starting date of the maintenance, out-of-order, or stay window associated with the room action.

Work Order / Stay > Start Date

N/A

Time

Exact timestamp recording when the action was executed.

Audit Log > Event Timestamp

N/A

Username

Full name or login credential of the staff member who logged the room action (e.g., Michael Humienny, Efrain Larraga, Karim Ouwaidat, Betul Arpinar).

Security Audit Trail > User ID

N/A

Customization & Platform Features

User & Property Preferences

  • Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.

  • Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:

    • Physical Location Locators (Cols 1–3): Room Number | Floor Number | Building

    • Event Execution Timestamps (Cols 4–6): Business Date | Calendar Date | Time

    • Action & Audit Accountability (Cols 7–9): Action Performed | Reason | Username

    • Housekeeping & Occupancy State Transitions (Cols 10–13): Current Housekeeping Status | Previous Housekeeping Status | Current Occupancy Status | Previous Occupancy Status

    • Guest Identity & Stay Context (Cols 14–18): Guest Name | First Name | Last Name | Confirmation Number | Check In Date

    • Schedule Window & Remarks (Cols 19–21): Start Date | End Date | Remarks

Report Toolbar & Quick Actions

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon

Action / Feature

Description
Image 9-29-26 at 1.04 PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.
Image 9-29-26 at 12.37 PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
Image 9-29-26 at 12.39 PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.
Image 9-29-26 at 12.40 PM.png

Highlight

Highlights column values in a designated color based on selected conditions.
Image 9-29-26 at 12.42 PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
Image 9-29-26 at 12.43 PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
Image 9-29-26 at 12.44 PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.
Advanced Controls

  • Forensic Audit Exporting: Schedule automated periodic exports to archive room audit logs for security, quality control, and legal compliance.

  • Filtering: Filter data by specific Room Number values to review the complete operational history of a room prior to a guest complaint or incident.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight out-of-order assignments (Reason = PREVENTATIVE MAINTENANCE), manual overrides, or rapid status reversals.

Within 🧹 Rooms & Facilities & 📋 Operations Analytics / 🛏️ Room Status:

  • Housekeeping Detail – Granular line-item audit tracking individual attendant cleaning speeds, durations, and inspection times.

  • Housekeeping Room Log – Immutable audit trail tracking room status changes and attendant cleaning actions.

  • All Rooms – Master physical room inventory, cleanliness state, and housekeeping schedule manifest.

  • Room Detail– Master room-by-room physical status, housekeeping, and maintenance audit matrix.

Cross-Pillar Deep Dives:

  • 🛠️ Facilities Maintenance: Cross-reference maintenance history reasons (Reason) in Maintenance Activity and Maintenance Summary to track recurring room repairs.

  • 🛡️ Security & Loss Prevention: Audit room access and status changes (Action Performed) against electronic door lock logs in Lock Error to resolve security incidents.