Database

Accessible tables and latest available date

Date Checker

Live freshness check for key operational source tables

Segment_Actual

Unavailable

unavailable

Segmentation_Daily_Snapshot

Unavailable

unavailable

sentec_drr

Unavailable

unavailable

Shows which DB tables are available and the max date currently found in each one

publicSegment_Actual

OTB segment data on daily feed basis.

unavailable

Max date: Unavailable

publicSegmentation_Daily_Snapshot

Detailed OTB statistics by segment, LOB, room type, client, and more.

unavailable

Max date: Unavailable

publicpnl

Monthly actual P&L data.

unavailable

Max date: Unavailable

publicsentec_drr

Daily Revenue Report from 2026-03-01 onward.

unavailable

Max date: Unavailable

stgstg_drr

Historical DRR from 2024-01-01 to 2026-02-28.

unavailable

Max date: Unavailable

stgstr_monthly

Monthly STR data from January 2024 onward.

Max date: 1970-01-01

stgstr_daily

Daily STR data from 2024-01-01 onward.

unavailable

Max date: Unavailable

tempbooking_production

Account, company, and client production data.

unavailable

Max date: Unavailable