Enterprise National DNR Report

Report Description: The Enterprise National DNR Report is an Enterprise-level reporting tool designed to provide a comprehensive history of guests marked with a "Do Not Rent" (DNR) status across all properties within the organisation. This report allows users to audit DNR entries added over a specific date range, identifying which property initiated the request, the specific reasons for the restriction, and when the status was officially applied. It serves as a vital audit trail for corporate security and oversight teams to monitor guest safety protocols and consistency across the enterprise.

Date Range: This report can render historical data for a filterable date range of up to 365 days (e.g., Today, Yesterday, MTD, YTD, or Custom).

Column Name	Column Description	Amount Includes Taxes/Fees	Calculation / Logic
Property Code	The unique identifier for the hotel property where the DNR was initiated.	Not Applicable	`properties.code`
Property Name	The full legal or trading name of the training or live property.	Not Applicable	`properties.name`
Date	The date the guest status was officially updated or reviewed in the system.	Not Applicable	`global_dnr_guests.updated_at` (Date part)
Requested Date	The original date the request was submitted for the guest to be flagged.	Not Applicable	`global_dnr_guests.created_at`
First Name	First name of the guest being flagged.	Not Applicable	`global_dnr_guests.first_name`
Last Name	Last name of the guest being flagged.	Not Applicable	`global_dnr_guests.last_name`
DNR Code	The specific alphanumeric code assigned to the DNR status.	Not Applicable	`global_dnr_guests.dnr_code`
Reason	The descriptive explanation of the DNR code (e.g., "Illegal Activities").	Not Applicable	`enterprise_dnr_codes.name`
DNR Type	Categorisation of the DNR scope (e.g., National).	Not Applicable	Hardcoded "National" for this report scope
Remarks	Additional internal notes or comments regarding the DNR entry.	Not Applicable	`global_dnr_guests.remarks`

Misc Report Information

Available Features:

Export & Search: Users can export the report data into CSV or Excel formats for external auditing and use the funnel icon for advanced grid filtering.
Dynamic Range: Ability to filter data by specific enterprise sites and predefined or custom date ranges (past 12 months).

Available Configuration:

User Preferences: Allows users to customise their view by using the "Select Columns" tool to reposition or remove specific fields.
Property Preferences: Allows enterprise admins to set a standardised baseline view for all properties within the organisation.

Baseline Configuration:

Initial Deployment: All key identification columns (Property Code, Property Name, and Requested Date) are enabled by default to satisfy corporate security requirements.