Sample Dashboard - Facility 335513 - 320 Consulting
Data Disclaimer: This dashboard displays data from CMS Payroll-Based Journal and Provider Information files. Data has not been independently verified.CMS PBJ/Provider Info data. Not verified.
Deployed 02/20/2026

SEAGATE REHABILITATION AND NURSING CENTER (335513)

PBJ320 Dashboard

Brooklyn, NY - Kings

Affiliated Entity: N/A

Staffing by Time Period
Tap to select/deselect.
Tap to select/deselect.
Data Range: 2017-2025

-

Total Days

-

Avg Census

-

Total HPRD

-

Direct HPRD

-

RN HPRD

-

Direct RN

-

Indirect Staffing HPRD

-

Contract %

-

Days: Total RN < 8

-

Days: RN < 8
State Compliance Review: NY min. (3.56)
Single Day Report
Nursing Staff HPRD Trends
Total Nursing Staff Hours
Resident Census
Contract Staff %
Provider Info & Ratings
Overall Rating
-
Staffing Rating
-
Health Inspection
-
Quality Measures
-
Ownership
-
SFF Status
-
Ownership Change
-
Red Flag History
SFF Status, 1-Star Ratings, Abuse Icons, Ownership Changes, Admin TO, and other quality concerns

Loading red flag history...

Red Flag Criteria:
• Special Focus Facility or SFF Candidate
• 1-Star Overall Rating
• 1-Star Staffing Rating
• Abuse Icon
• Ownership Change
• Admins who left NH (12 months)

Data Matching Note: Provider Info staffing data (reported, case-mix, adjusted, ratings, turnover) is matched to quarter based on payroll-based journal data. Other info such as overall ratings does not update quarterly but is linked to the quarter matched by PBJ.

Total Staff: Total vs. Direct vs. Case-Mix vs. Adjusted
RN Staff: Total vs. Direct vs. Case-Mix vs. Adjusted
Nurse Aide Staff: Total vs. Case-Mix vs. Adjusted
% Case-Mix HPRD - Total & Direct
Total Staff and Direct Staff (excl. admin/DON) divided by Case-Mix. Values below 1.0 indicate staffing deficit.
% Case-Mix HPRD - RN & RN Direct
Total RN and RN Direct (excl. admin/DON) divided by Case-Mix. Values below 1.0 indicate staffing deficit.
Ratings over TimeOverall (bold); Staffing, Health Inspection, Quality (sub-components)
Provider Info quarters estimated based on matching staffing data in PBJ dataset. Quarters for non-staffing metrics may not be exact.
Outlier Detection

Detect statistical outliers in the current filtered dataset or across all historical data. Current filter:

Within filtered data
vs. all data (2017-2025)
Daily Data - Seagate Rehabilitation And Nursing Center
# Date Day Census Total Staff HPRD Total Staff Hours Direct Staff HPRD Total RN HPRD Total RN Hours Total LPN HPRD Total LPN Hours Nurse Aide HPRD Nurse Aide Hours RN Contract % LPN Contract % Aide Contract % Holiday
Showing 0-0 of 0 records
Quarterly Data - Seagate Rehabilitation And Nursing Center
Quarter Census Total HPRD Direct HPRD Total RN HPRD RN HPRD RN Admin HPRD RN DON HPRD
(Avg Hrs/Day) (Avg Hrs/Day) (Avg Hrs/Day) (Avg Hrs/Day) (Avg Hrs/Day) (Avg Hrs/Day)
All values rounded to 2 decimal places. Hours shown are average hours per day.
Case-Mix Acuity Analysis - Seagate Rehabilitation And Nursing Center
Quarter Reported HPRD Case-Mix HPRD CMI % Case-Mix (Reported/Case-Mix)
Total Direct RN LPN Nurse Aide Total RN LPN NA Total Direct Total RN Direct RN Total LPN Direct LPN NA
Prov Info PBJ PBJ
(excl admin)		 Prov Info
(Total)		 PBJ
(Total)		 PBJ
(Direct)		 Prov Info
(Total)		 PBJ
(Total)		 PBJ
(Direct)		 Prov Info PBJ
Data Sources: Reported values from both Provider Information files (Prov Info) and PBJ daily records (PBJ). Provider Info matched to PBJ quarters by reported total staffing. Case-Mix values from Provider Information files represent CMS expected staffing based on resident acuity. CMI (Case-Mix Index) from Provider Information files indicates the source column name used (e.g., "nursing_case_mix_index").
% Case-Mix Calculation: (Reported ÷ Case-Mix) × 100. Green (100-110%): Meeting expectations. Orange (90-99%): Below expectations. Red (<90%): Significantly below. Blue (>110%): Above expectations.
Direct Categories: Exclude RN Admin, RN DON, and LPN Admin from calculations. Total Categories: Include all staff in that position type.
Harrington Expected Staffing (CMI-Adjusted)
Methodology & Definitions
Staff Categories
  • Total Staff: All nursing staff including RNs, LPNs, CNAs, administrators, and DON
  • Direct Staff: Staff providing direct patient care (excludes administrators and DON)
  • Total RN (Registered Nurse): Includes RNs + RN administrators + RN DON (Director of Nursing)
  • Direct RN: Excludes RN Admin, RN DON.
  • LPN (Licensed Practical Nurse): Includes direct care LPNs + LPN administrators
  • Nurse Aides: Includes CNAs + NA trainees + Medication Aides
  • Contract Staff: Temporary/agency staff (marked with "_ctr" suffix)
Calculations
  • HPRD (Hours Per Resident Day): Total hours ÷ Census
  • Contract %: (Contract hours ÷ Total hours) × 100
  • Averages: Weighted by census when applicable
  • Rounding: Financial rounding (ROUND_HALF_UP) for all displayed metrics
  • % Case-Mix HPRD: Reported ÷ CMS Case-Mix. Values below 1.0 indicate staffing deficit relative to CMS benchmark expectations; values above 1.0 indicate surplus staffing. Case-mix is a CMS benchmark for staffing based on resident acuity.
  • Indirect Staffing HPRD: RN Admin + RN DON + LPN Admin hours per resident day
Harrington Expected Staffing (CMI-Adjusted)

The Harrington Expected formulas adjust expected staffing based on Case-Mix Index (CMI) to account for resident acuity:

  • Total Expected HPRD: 3.48 + ((CMI - 0.62) / (3.84 - 0.62))0.715 × (7.68 - 3.48)
  • RN Expected HPRD: 0.55 + ((CMI - 0.62) / (3.84 - 0.62))0.974 × (2.39 - 0.55)
  • Nurse Aide Expected HPRD: 2.45 + ((CMI - 0.62) / (3.84 - 0.62))0.236 × (3.6 - 2.45)

See: Nursing Home Guide to Adjusting Nurse Staffing for Resident Case-Mix (Harrington)

Note: Direct Care metrics are calculated from PBJ and exclude Admin/DON.

Statistical Analysis
  • Z-Score: (Value - Mean) ÷ Standard Deviation
  • Outlier Detection: |Z-Score| ≥ 2.0 (High), |Z-Score| ≥ 3.0 (Extreme)
  • Percentile: Approximate ranking compared to historical data
  • Holidays: Federal holidays as defined by U.S. government
Data Sources

This Nursing Home Staffing Dashboard uses CMS Payroll-Based Journal (PBJ) data from 2017 to 2025, covering all nursing positions, including contract staff (https://data.cms.gov/quality-of-care/payroll-based-journal-daily-nurse-staffing). CMS first published PBJ data in 2017. It also uses Provider Information datasets from 2018 to 2025 (https://data.cms.gov/provider-data/dataset/4pq5-n9py).

Unlike PBJ data, which is released quarterly, provider info files are published on a rolling monthly basis without a clear reference quarter. To align them with PBJ datasets, we matched the "reported total staffing" metric, which is available in both sources, to the corresponding quarter. This approach is not exact—health inspection data, for example, is updated on a different schedule—but it offers a reasonable best-guess for quarter assignment.

State legislation

For New York nursing homes, the state requires a minimum of 3.56 HPRD (Hours Per Resident Day) for total staffing.

Sources: MACPAC – State Policies Related to Nursing Facility Staffing (summary and state-by-state comparison).