U
User
User

OT / DT Dashboard

Live data from the Celayix + Master Database tables. Select a date range to see real numbers for that period.

Workspace
Select Date Range
Choose a manager and date range to view the dashboard data.
Manager
From
To
Open buffer (min)
Regional Summary
Total, Regular, OT and DT hours by region for the selected range.
By Manager
Breakdown of hours, shifts and app usage by manager.
Employee Detail
Click a KPI card above to see the underlying employee-level records for that category.
Hours by manager
Regular, Overtime and Double-time hours by manager.
RegOTDT
Check-in: App vs Manual
Comparison of check-ins via Team Xpress (App) vs Manual.
Open Posts & Late/Early (Net Of Relief & Swaps)
Total open
–

Open = scheduled time at a regular post no employee covered (patrol posts excluded, relief/swaps netted). Gaps at/under the buffer are ignored; late starts & early-outs are still flagged.

Hours by Manager
"Labor" Records
Every record for the selected date range where "Labor" appears anywhere in the employee name (start, middle, or end).
By Region
Staffing Company total, broken down by the region each record belongs to.
Matching Records
Full detail for every matching row — nothing summarized away.
All shifts resolved to the RCM region for the selected date range.
RCM Site-wise Monitoring
Weekly view (Saturday to Friday) for each site. Showing monitoring hours and total shifts. [build 2026-09-19-G]
Day Swing Night Specific Hours 24 Hrs – No Monitoring
Billable OT vs Billable DT
Billable OT Billable DT
Excused OT vs Excused DT
Excused OT Excused DT
Employee Approved OT
Manage excused OT/DT rules per employee. Maximum 5 days can be configured.
Important Notes
  • Maximum excused OT/DT days per employee can be up to 5 days.
  • Permanent = Yes means the rule continues for future dates until changed.
  • Permanent = No requires Start Date and End Date.
  • Employee ID/Name are tied to the existing employee database.
  • This configuration is used for employee-level OT/DT rules.
Site Approved OT
Manage billable OT/DT rules per site. These settings apply at site level.
Important Notes
  • Site-level Billable OT/DOT rules.
  • Permanent = Yes means the rule continues for future dates until changed.
  • Permanent = No requires Start Date and End Date.
  • Site-level configuration applies according to the configured site rule.
Office Hours for the selected date range, broken out by category instead of one combined figure. Uses the same Office Hours data as the Ryan tab (India Office / Office / Hammer Head Office / Patrol Office Hours).
Office Hours by Category
Full detail for every Office Hours record — nothing summarized away.
Hammer Head - Ops (Executive Team / Operations Team) hours for the selected date range.
Lakh - HH Ops — Detail
Every Hammer Head - Ops record for the selected date range.
Billable Hours to Client — Ryan / Patrol
Client billable hours vs employee paid hours for the selected date range.
Billable Hours to Client — Site Summary
Dates are generated dynamically from the selected range.
Site 163 — Payroll Not Calculated as Billable Hours
These hours are not included in the client billable total, but employees still must be paid for them.
Patrol Billable vs Employee Paid Hours
Difference = Billable Hours − Employee Paid Hours

Discrepancies / Data Issues

Recomputed live from the database for the date range currently selected on the Dashboard tab. Nothing here is guessed or auto-corrected — it only shows what needs a human look in the Master Database tabs.

Loading…