🏥 Mercy San Juan Medical Center

Sacramento County · HCAI 106340950

6501 COYLE AVENUE, CARMICHAEL 95608

Open · Hospital facility · roster 2026-10-01

Hospital Snapshot

The available data, together. Tap a section to open its history and sources.

↑ Increasing · ↓ Decreasing · → Stable · Provisional = filing still in process

Read the arrows

Trends: ↑ increasing, ↓ decreasing, → stable over the dates shown. Provisional means a filing is still in process.

CMS / CDPH comparisons: ↑ above, ↓ below, ↔ equal to the national number or the source reports no difference. The label identifies which comparison is shown.

—: no matched comparison.

👩‍⚕️ RN staffing

Reporting-unit RN hours / patient day: 13.47↓
Productive RN hours: 1,357,747
RN-only FTEs · productive, calculated: 652.76

History & details →

✈️ Travelers / agency

Contract RN hours / reported nursing hours: 6.1%↑
Contract RN hours: 101,236

History & details →

🛏️ Beds & capacity

🏥 Reported licensed beds: 384
🛏️ Reported staffed beds: 312—
⚙️ Operational beds: — UNKNOWN
🛏️ Reported available beds: 384
❤️ Licensed ICU beds: 45
👶 Licensed NICU beds: 40
🤰 Licensed perinatal beds: 32
🚑 ED treatment stations: 31

History & details →

🚑 ED & hospital pressure

🚑 ED encounters · admitted + non-admitted: 80,651
🛏️ ED admissions: 14,465
⏱️ Median ED stay · excludes psych / transfers: 197 min↑
⏱️ Psychiatric / mental-health ED stay · median: 330 min↑
🚑 Left before being seen: 1%↓
⏱️ Ambulance offload · 90th percentile: 29.7 min
🚨 Reported diversion hours: 9 hours
⏱️ Boarding / wait time: — UNKNOWN

History & details →

🔄 Services & changes

Documented service changes: Service review not documented

History & details →

👥 Turnover & working conditions

Acute-hospital RN turnover: — UNKNOWN
RN vacancies: — UNKNOWN

Pay, overtime, orientation and contract records →

History & details →

💬 Patient experience

Nurses communicated well · Always: 77%↓
Help as soon as wanted · Always · legacy measure: 59%↓

History & details →

🦠 Infections · CMS ratios

Central-line bloodstream infections · CLABSI · SIR: 0.567↔CMS: no different from national benchmark
Catheter-associated urinary infections · CAUTI · SIR: 0.000↓CMS: lower than national benchmark · better
MRSA bloodstream infections · SIR: 0.144↓CMS: lower than national benchmark · better
C. diff infections · SIR: 0.108↓CMS: lower than national benchmark · better
Surgical-site infections · colon surgery · SIR: 0.000↔CMS: no different from national benchmark
Surgical-site infections · hysterectomy · SIR: Not calculable

History & details →

🏥 Readmissions & mortality

30-day readmissions

Heart attack: 15.1%↑
Heart failure: 22.2%↑
Pneumonia: 17.9%↑
COPD: 21.2%↑
Coronary bypass surgery: 11.3%↑
Hip/knee replacement: 6.1%↑

30-day mortality

Heart attack: 14.6%↑
Heart failure: 12.9%↑
Pneumonia: 13.7%↓
COPD: 9.6%↑
Coronary bypass surgery: 1.9%↓
Stroke: 12.2%↑

History & details →

📈 Workload & complete records

Patient days, discharges, care mix and workload history.

🔎 All sources →History & details →

Explore history & sources

Before you take the job

Open details

Charge-nurse patient assignment — UNKNOWN · charge availability affects every nurse’s backupIs the charge nurse free of a patient assignment on this unit? If not, is it a partial or full assignment, how many patients, and how often? What dedicated RN/LVN support is provided, and who covers charge duties during emergencies?Source →

↑ Back to snapshot

👥 Turnover & working conditions

Open details

Who stays? Who leaves?

Acute-hospital RN turnover: — UNKNOWN
RN vacancies: — UNKNOWN

Pay, overtime, orientation & contract

RN overtime: UNKNOWN — no matched RN-specific hours
Current RN wage scale: UNKNOWN — no matched current scale
Orientation: UNKNOWN — no matched unit policy
Contract provisions: UNKNOWN — no executed local contract reviewed

↑ Back to snapshot

📈 Workload & patient demand

Open details

📈 Workload, Staffing & Capacity

2022–2024: ED encounters increased from 72,772 to 80,651.

🚑 ED activity · ↑ 10.8%

ED history & measures → · 🔎 Sources →

↑ Back to snapshot

👩‍⚕️ RN Staffing

Open details

Annual RN labor inputs · all retained years

Annual financial reporting unit · source-reported inputs
Reporting period	Productive RN hours	Contract RN hours	Patient days	Filing status	Source
2021-07-01–2022-06-30	1,424,981	24,505	97,966	Audited	Preserved fileAPI record ID 257
2022-07-01–2023-06-30	1,384,501	87,142	99,972	Audited	Preserved fileAPI record ID 257
2023-07-01–2024-06-30	1,357,747	101,236	100,817	Audited	Preserved fileHADR 01-01-2024 to 12-31-2024 row 255

Full source records & reporting scope →

🔎 Records & complete history →

Reporting-unit RN hours / patient day

13.47

2023-07-01–2024-06-30📈 Trend: ↓ Decreasing · 2022–2024

California peer comparison

Peer median: 14.85
Typical reported range · middle 50%: 11.14–19.49

RN hours / patient day · 191 audited 2024 reports

Mostly acute-care patient days

100.0% of this report’s patient days: acute care

Within the typical reported range

🔎 Comparison source & calculation

Productive RN hours

1,357,747

2023-07-01–2024-06-30

RN-only FTEs · productive, calculated

652.76

2023-07-01–2024-06-30 · productive RN hours ÷ 2,080

📈 RN hours per patient day · annual reports

RN hours per patient day · annual reports · RN hours / patient day
Period	RN hours / patient day
2022	14.55
2023	13.85
2024	13.47

2022–2024 pattern: RN hours per patient day went from 14.55 to 13.47.

↑ Back to snapshot

✈️ Travelers / Agency Nursing

Open details

🔎 Records & complete history →

Contract RN hours / reported nursing hours: 6.1%
Contract RN hours: 101,236

📈 Contract RN share of nursing hours · annual reports

Contract RN share of nursing hours · annual reports · % of nursing hours
Period	% of nursing hours
2022	1.47
2023	5.21
2024	6.09

2022–2024 pattern: contract RN share went from 1.5% to 6.1%.

2018–2019 baseline: 3.5%.

↑ Back to snapshot

🛏️ Beds & Capacity

Open details

Which kind of bed capacity is reported?

What do these bed counts mean?

🏥 Licensed: Authorized bed capacity under the facility license.
🛏️ Staffed: Beds the hospital reports having personnel to operate during the reporting period.
⚙️ Operational: Beds open and equipped for patient care at a stated time.
📋 Reported available: The source’s available-bed count for its dated reporting period. Live availability means an empty, staffed bed ready to accept a patient now.

🔎 Records & complete history →

🏥 Reported licensed beds: 384
🛏️ Reported staffed beds: 312
⚙️ Operational beds: — UNKNOWN
🛏️ Reported available beds: 384
❤️ Licensed ICU beds: 45
👶 Licensed NICU beds: 40
🤰 Licensed perinatal beds: 32
🚑 ED treatment stations: 31

📈 Licensed specialty-bed history

Licensed beds · annual utilization
Licensed beds	2022	2023	2024
❤️ ICU	45	45	45
👶 NICU	40	40	40
🤰 Perinatal	32	32	32

📈 ED treatment stations · December 31

ED treatment stations · December 31 · Stations
Period	Stations
2022	31
2023	31
2024	31

↑ Back to snapshot

🚑 ED & Hospital Pressure

Open details

🔎 Records & complete history →

🚑 ED encounters · admitted + non-admitted: 80,651
🛏️ ED admissions: 14,465
⏱️ Median ED stay · excludes psych / transfers: 197 min↑
⏱️ Psychiatric / mental-health ED stay · median: 330 min↑
🚑 Left before being seen: 1%↓
⏱️ Ambulance offload · 90th percentile: 29.7 min
🚨 Reported diversion hours: 9 hours
⏱️ Boarding / wait time: — UNKNOWN

📈 Ambulance offload · 90th percentile · Oct 2024–Mar 2025

Ambulance offload · 90th percentile · Oct 2024–Mar 2025 · Minutes
Period	Minutes
Oct 2024	27.13
Nov 2024	24.23
Dec 2024	30.5
Jan 2025	30.42
Feb 2025	33.47
Mar 2025	29.7

📈 ED encounters · admitted + non-admitted

ED encounters · admitted + non-admitted · Encounters
Period	Encounters
2022	72,772
2023	75,014
2024	80,651

📈 Reported diversion hours

Reported diversion hours · Hours
Period	Hours
2022	8
2023	28
2024	9

↑ Back to snapshot

🔄 Services & Changes

Open details

Service review not documented

All documented service changes →↑ Back to snapshot

💬 Patient experience

Open details

Patient Experience

CMS reporting unit 050516 · MERCY SAN JUAN MEDICAL CENTER

Patients who answered “Always”

Nurses communicated well: 77%↓Below national rate 80% · numerical comparison
Received help as soon as wanted: 59%↓Below national rate 67% · numerical comparison

🔎 Measure records & sources →

↑ Back to snapshot

🦠 Infections · CMS ratios

Open details

Infections · CMS

CMS reporting unit 050516 · MERCY SAN JUAN MEDICAL CENTER

Infections · standardized infection ratio (SIR)

Central-line bloodstream infections · CLABSI · SIR: 0.567↔CMS: no different from national benchmark
Catheter-associated urinary infections · CAUTI · SIR: 0.000↓CMS: lower than national benchmark · better
MRSA bloodstream infections · SIR: 0.144↓CMS: lower than national benchmark · better
C. diff infections · SIR: 0.108↓CMS: lower than national benchmark · better
Surgical-site infections · colon surgery · SIR: 0.000↔CMS: no different from national benchmark
Surgical-site infections · hysterectomy · SIR: Not calculable

🔎 Measure records & sources →

↑ Back to snapshot

🏥 Readmissions & mortality

Open details

Readmissions & Mortality

CMS reporting unit 050516 · MERCY SAN JUAN MEDICAL CENTER

Unplanned readmissions within 30 days

Heart attack: 15.1%↑Above national rate 14.4% · numerical comparison
Heart failure: 22.2%↑Above national rate 21.3% · numerical comparison
Pneumonia: 17.9%↑Above national rate 17.3% · numerical comparison
COPD: 21.2%↑Above national rate 20% · numerical comparison
Coronary bypass surgery: 11.3%↑Above national rate 11% · numerical comparison
Hip/knee replacement: 6.1%↑Above national rate 5.8% · numerical comparison

Deaths within 30 days

Heart attack: 14.6%↑Above national rate 11.9% · numerical comparison
Heart failure: 12.9%↑Above national rate 11.1% · numerical comparison
Pneumonia: 13.7%↓Below national rate 15.2% · numerical comparison
COPD: 9.6%↑Above national rate 8.6% · numerical comparison
Coronary bypass surgery: 1.9%↓Below national rate 2.4% · numerical comparison
Stroke: 12.2%↑Above national rate 11.9% · numerical comparison

🔎 Measure records & sources →

↑ Back to snapshot

🔎 Sources

Open details

HCAI facility roster · 2026-10-01 · source row 314 · Retained roster
Download this hospital’s retained records and history (JSON)HCAI 106340950 · dates, source locators and original values included

RN labor and workload · records & history

RN trend comparison: eligible. Contract-share trend comparison: eligible.

2022 · 2021-07-01–2022-06-30 · Audited

Download preserved source · Official source · API record ID 257

Field

Value

year

2022

begin

2021-07-01

end

2022-06-30

reportDays

365

filing

Audited

type

Comparable

sourceRecord

257

name

MERCY SAN JUAN MEDICAL CENTER

county

Sacramento

rnHours

1424981

patientDays

97966

ratio

14.545668905538657

components

Open components

Retained record fields
Field	Value
PRD_HR_RN	1424981
PRD_HR_LVN	5628
PRD_HR_AID	214268
CNT_HR_RN	24505

nursingHours

1669382

contractShare

0.014679084834986839

careDays

Open careDays

Retained record fields
Field	Value
DAY_ACUTE	97966
DAY_PSYCH	0
DAY_CHEM	0
DAY_REHAB	0
DAY_LTC	0
DAY_RESDNT	0

2023 · 2022-07-01–2023-06-30 · Audited

Download preserved source · Official source · API record ID 257

Field

Value

year

2023

begin

2022-07-01

end

2023-06-30

reportDays

365

filing

Audited

type

Comparable

sourceRecord

257

name

MERCY SAN JUAN MEDICAL CENTER

county

Sacramento

rnHours

1384501

patientDays

99972

ratio

13.848887688552795

components

Open components

Retained record fields
Field	Value
PRD_HR_RN	1384501
PRD_HR_LVN	6164
PRD_HR_AID	195941
CNT_HR_RN	87142

nursingHours

1673748

contractShare

0.052063990517090986

careDays

Open careDays

Retained record fields
Field	Value
DAY_ACUTE	99972
DAY_PSYCH	0
DAY_CHEM	0
DAY_REHAB	0
DAY_LTC	0
DAY_RESDNT	0

2024 · 2023-07-01–2024-06-30 · Audited

Download preserved source · Official source · HADR 01-01-2024 to 12-31-2024 row 255

Field

Value

year

2024

begin

2023-07-01

end

2024-06-30

reportDays

366

filing

Audited

type

Comparable

sourceRecord

255

name

MERCY SAN JUAN MEDICAL CENTER

county

Sacramento

rnHours

1357747

patientDays

100817

ratio

13.467441006973031

components

Open components

Retained record fields
Field	Value
PRD_HR_RN	1357747
PRD_HR_LVN	6052
PRD_HR_AID	198517
CNT_HR_RN	101236

nursingHours

1663552

contractShare

0.06085532643403994

careDays

Open careDays

Retained record fields
Field	Value
DAY_ACUTE	100817
DAY_PSYCH	0
DAY_CHEM	0
DAY_REHAB	0
DAY_LTC	0
DAY_RESDNT	0

Current CNO profile record · reported labor fields

Preserved 2024 financial workbook

Retained record fields
Field	Value
rnHours	1357747
contractHours	101236
contractShare	0.06086
rnPerPatientDay	13.46744
baseline	0.03484
history	UNIQUE
filing	Audited

Beds and capacity · records & history

Official facility identity, campus scope & licensed beds · 2026-10-01

Official HCAI roster · Retained source · row 314

Field

Value

officialName

MERCY SAN JUAN MEDICAL CENTER

county

Sacramento

city

CARMICHAEL

address

6501 COYLE AVENUE

zip

95608

level

Parent Facility

category

General Acute Care Hospital

status

Open

statusEffective

1967-02-03

licensedBeds

384

erServiceLevel

Emergency - Basic

licenseNumber

030000063

rosterDate

2026-10-01

checkedOn

2026-10-12

sourceRow

314

officialUrl

https://data.chhs.ca.gov/dataset/licensed-healthcare-facility-listing

sourceFile

/downloads/coverage/hcai-current-20261001.json.gz

aliases

Open aliases

Record 1

MERCY SAN JUAN MEDICAL CENTER

parentId

— UNKNOWN

parentName

— UNKNOWN

cdphFacilityType

GENERAL ACUTE CARE HOSPITAL

crosswalkRows

Open crosswalkRows

Record 1

Retained record fields
Field	Value
_id	245
LICENSED_CERTIFIED	LICENSED AND CERTIFIED
ELMS_FACID	030000127
LICENSE_NUMBER	030000063
LICENSE_STATUS_DESCRIPTION	ACTIVE
PERM_ID	10607
HCAI_ID	106340950
ASPEN_FACID	CA030000127
CCN	050516
NPI	1972541495
ASPEN_STATUS	ACTIVE
FACNAME	MERCY SAN JUAN MEDICAL CENTER
FAC_TYPE_DESCRIPTION	GENERAL ACUTE CARE HOSPITAL
FAC_FDR	GENERAL ACUTE CARE HOSPITAL
FAC_FAC_RELATIONSHIP	Parent
ELMS_PARENT_FACID	— UNKNOWN

addedByCoverageAudit

false

Retained record fields
Field	Value
licensedBeds	384
staffedBeds	312
availableBeds	384
reportingYear	2025
scope	Workforce reporting year 2024; capacity reporting year 2025; not a same-period state assessment.

Licensed beds by care type · 2022 · 2022-01-01–2022-12-31

Preserved utilization workbook · Page 1-6 · row 304

Field

Value

year

2022

begin

2022-01-01

end

2022-12-31

operated

Yes

beds

Open beds

Retained record fields
Field	Value
acute	384
psychiatric	0
chemical	0
skilledNursing	0
intermediateCare	0
developmentalCare	0

total

384

sourceRow

304

sourceId

AUR-2022

Licensed beds by care type · 2023 · 2023-01-01–2023-12-31

Preserved utilization workbook · Page 1-6 · row 305

Field

Value

year

2023

begin

2023-01-01

end

2023-12-31

operated

Yes

beds

Open beds

Retained record fields
Field	Value
acute	384
psychiatric	0
chemical	0
skilledNursing	0
intermediateCare	0
developmentalCare	0

total

384

sourceRow

305

sourceId

AUR-2023

Licensed beds by care type · 2024 · 2024-01-01–2024-12-31

Preserved utilization workbook · Page 1-6 · row 305

Field

Value

year

2024

begin

2024-01-01

end

2024-12-31

operated

Yes

beds

Open beds

Retained record fields
Field	Value
acute	384
psychiatric	0
chemical	0
skilledNursing	0
intermediateCare	0
developmentalCare	0

total

384

sourceRow

305

sourceId

AUR-2024

ED activity, specialty beds and diversion · records & history

2022 · 2022-01-01–2022-12-31

Download preserved workbook · Official source · HCAI 106340950 · source row 304

Retained record fields
Field	Value
year	2022
begin	2022-01-01
end	2022-12-31
operated	Yes
sourceId	AUR-2022
sourceRow	304
diversionReported	Yes
icuLicensed	45
nicuLicensed	40
perinatalLicensed	32
edStations	31
edNonAdmitVisits	59491
edAdmissions	13281
diversionHours	8

2023 · 2023-01-01–2023-12-31

Download preserved workbook · Official source · HCAI 106340950 · source row 305

Retained record fields
Field	Value
year	2023
begin	2023-01-01
end	2023-12-31
operated	Yes
sourceId	AUR-2023
sourceRow	305
diversionReported	Yes
icuLicensed	45
nicuLicensed	40
perinatalLicensed	32
edStations	31
edNonAdmitVisits	61336
edAdmissions	13678
diversionHours	28

2024 · 2024-01-01–2024-12-31

Download preserved workbook · Official source · HCAI 106340950 · source row 305

Retained record fields
Field	Value
year	2024
begin	2024-01-01
end	2024-12-31
operated	Yes
sourceId	AUR-2024
sourceRow	305
diversionReported	Yes
icuLicensed	45
nicuLicensed	40
perinatalLicensed	32
edStations	31
edNonAdmitVisits	66186
edAdmissions	14465
diversionHours	9

CMS ED measures · records & history

CMS 050516 · MERCY SAN JUAN MEDICAL CENTER · Download preserved CMS file · Official source

OP_18b · Average (median) time patients spent in the emergency department before leaving from the visit, excluding patients transferred to another facility or psychiatric care/mental health patients. A lower number of minutes is better · source row 13705

Retained record fields
Field	Value
value	197
raw	197
sample	350
footnote
start	2024-10-01
end	2025-09-30
sourceRow	13705
measureName	Average (median) time patients spent in the emergency department before leaving from the visit, excluding patients transferred to another facility or psychiatric care/mental health patients. A lower number of minutes is better

OP_18c · Average (median) time psychiatric/mental health patients spent in the emergency department before leaving from the visit. A lower number of minutes is better · source row 13706

Retained record fields
Field	Value
value	330
raw	330
sample	22
footnote
start	2024-10-01
end	2025-09-30
sourceRow	13706
measureName	Average (median) time psychiatric/mental health patients spent in the emergency department before leaving from the visit. A lower number of minutes is better

OP_18d · Average (median) time patients spent in the emergency department before being transferred to another facility. A lower number of minutes is better · source row 13707

Retained record fields
Field	Value
value	— UNKNOWN
raw	Not Available
sample	Not Available
footnote	1
start	2024-10-01
end	2025-09-30
sourceRow	13707
measureName	Average (median) time patients spent in the emergency department before being transferred to another facility. A lower number of minutes is better

OP_22 · Left before being seen · source row 13708

Retained record fields
Field	Value
value	1
raw	1
sample	81679
footnote
start	2024-01-01
end	2024-12-31
sourceRow	13708
measureName	Left before being seen

Ambulance offload · records & history
Mercy San Juan Medical Center · CEMSIS 20286 · unique normalized hospital / retained CMS name + EMS geography
Download preserved report · Official report
Record 1 · 2024-10
Retained record fields
Field Value
month 2024-10
minutes 27.133333333333333
offloadCount 1848
countPage 31
rawTime 0:27:08
sourceId EMSA-APOT-JUNE2025
page 22
row 15
Record 2 · 2024-11
Retained record fields
Field Value
month 2024-11
minutes 24.233333333333334
offloadCount 1714
countPage 36
rawTime 0:24:14
sourceId EMSA-APOT-JUNE2025
page 22
row 15
Record 3 · 2024-12
Retained record fields
Field Value
month 2024-12
minutes 30.5
offloadCount 1786
countPage 41
rawTime 0:30:30
sourceId EMSA-APOT-JUNE2025
page 22
row 15
Record 4 · 2025-01
Retained record fields
Field Value
month 2025-01
minutes 30.416666666666668
offloadCount 1933
countPage 46
rawTime 0:30:25
sourceId EMSA-APOT-JUNE2025
page 22
row 15
Record 5 · 2025-02
Retained record fields
Field Value
month 2025-02
minutes 33.46666666666667
offloadCount 1834
countPage 51
rawTime 0:33:28
sourceId EMSA-APOT-JUNE2025
page 22
row 15
Record 6 · 2025-03
Retained record fields
Field Value
month 2025-03
minutes 29.7
offloadCount 1609
countPage 56
rawTime 0:29:42
sourceId EMSA-APOT-JUNE2025
page 22
row 15

CMS patient experience, infection, readmission & mortality records

CMS 050516 · MERCY SAN JUAN MEDICAL CENTER · 6501 COYLE AVE, CARMICHAEL 95608 · unique normalized address + city + ZIP

Unplanned Hospital Visits - National · Preserved national benchmarks · SHA-256 42db9aba1b194c9c65cbba3db83a990ffa653795d38a037bc660f12f58fecf98
Complications and Deaths - National · Preserved national benchmarks · SHA-256 b5e488f242f3e577db0e5cc8223bf2964cf914b424464fba95976e2931d15dc6
Patient survey (HCAHPS) - National · Preserved national benchmarks · SHA-256 1168d562ee10f94eaef2d29e4e8571a9be912c6e27b8dc37b215ad4300d0d6ed
Timely and Effective Care - National · Preserved national benchmarks · SHA-256 9a9201b989acb29177312caf5c9340cf5c07bc7469f58a15b80fbc7eab3636de
HCAHPS National · November 26, 2025 archive · Preserved national benchmarks · SHA-256 4b9d43013c67022783fd5cb4fc12fb8076afb084cc774644586093d1843f04af
HCAHPS · nurse communication · released 2026-08-13 · Preserved CSV (gzip) · Release metadata
File checksums
CSV SHA-256: b70e598f29552df302e30ed649d178abd1b3d3c868ae97cf8e55453dd33898fc
Gzip SHA-256: 95684a71416b383524c79ad0c7ad112622e632df97f33dbc1d701827eeff04a9
HCAHPS · legacy responsiveness · released 2025-11-26 · Preserved CSV (gzip) · Release metadata
File checksums
CSV SHA-256: c11338a55a9ee674566493fe8abde8748d2809163e86de100bc45aaa382d8751
Gzip SHA-256: 7c48b1aefcba65ebbe26a1dba592c0319261b847cdd9bb7c58306d55466cd4f8
Healthcare-associated infections · released 2026-08-13 · Preserved CSV (gzip) · Release metadata
File checksums
CSV SHA-256: 95283bf20e66c5f9271e6b0b98969d8655487b4d5fa074dcee6e204ee4574f3d
Gzip SHA-256: f6f0f580606726171c93adad77cd1c92a4ec00a8b37563114414ff19116c39af
CMS unplanned readmissions · released 2026-09-30 · Preserved CSV (gzip) · Release metadata
File checksums
CSV SHA-256: 98cc64f5fc330ffa7e4bef97f8e86a772a1d3dfe2f7dd08976cb1ee43fad1b2d
Gzip SHA-256: 1110a7b338b17e815ee9a2e3f6e40f7c53d9fde1df7663ff452b2f82ed7bb575
CMS 30-day mortality · released 2026-09-30 · Preserved CSV (gzip) · Release metadata
File checksums
CSV SHA-256: 2f7112969e2de2a015af8574848973dc48595ca6f2fe032e5f0932c515d5f59a
Gzip SHA-256: 04b606e8f24603cc6711bd630abc02fee2ee707d81a529360c72433806b180ce

Exact CMS records · reporting unit 050516
Measure	Reported value	Period	Source / row	CMS footnotes
H_COMP_1_A_PPatients who reported that their nurses "Always" communicated well	77	2024-10-01–2025-09-30	hcahps / 32302	None
H_COMP_3_A_PPatients who reported that they "Always" received help as soon as they wanted	59	2024-01-01–2024-12-31	responsiveness / 44391	None
HAI_1_SIRCentral Line Associated Bloodstream Infection (ICU + select Wards)	0.567	2024-10-01–2025-09-30	hai / 17107	None
HAI_1_NUMERATORCentral Line Associated Bloodstream Infection (ICU + select Wards): Observed Cases	5	2024-10-01–2025-09-30	hai / 17106	None
HAI_1_ELIGCASESCentral Line Associated Bloodstream Infection (ICU + select Wards): Predicted Cases	8.815	2024-10-01–2025-09-30	hai / 17105	None
HAI_1_CILOWERCentral Line Associated Bloodstream Infection (ICU + select Wards): Lower Confidence Limit	0.208	2024-10-01–2025-09-30	hai / 17102	None
HAI_1_CIUPPERCentral Line Associated Bloodstream Infection (ICU + select Wards): Upper Confidence Limit	1.257	2024-10-01–2025-09-30	hai / 17103	None
HAI_2_SIRCatheter Associated Urinary Tract Infections (ICU + select Wards)	0.000	2024-10-01–2025-09-30	hai / 17113	None
HAI_2_NUMERATORCatheter Associated Urinary Tract Infections (ICU + select Wards): Observed Cases	0	2024-10-01–2025-09-30	hai / 17112	None
HAI_2_ELIGCASESCatheter Associated Urinary Tract Infections (ICU + select Wards): Predicted Cases	11.889	2024-10-01–2025-09-30	hai / 17111	None
HAI_2_CILOWERCatheter Associated Urinary Tract Infections (ICU + select Wards): Lower Confidence Limit	Not Available	2024-10-01–2025-09-30	hai / 17108	8Lower confidence limit unavailable
HAI_2_CIUPPERCatheter Associated Urinary Tract Infections (ICU + select Wards): Upper Confidence Limit	0.252	2024-10-01–2025-09-30	hai / 17109	None
HAI_3_SIRSSI - Colon Surgery	0.000	2024-10-01–2025-09-30	hai / 17119	None
HAI_3_NUMERATORSSI - Colon Surgery: Observed Cases	0	2024-10-01–2025-09-30	hai / 17118	None
HAI_3_ELIGCASESSSI - Colon Surgery: Predicted Cases	2.600	2024-10-01–2025-09-30	hai / 17117	None
HAI_3_CILOWERSSI - Colon Surgery: Lower Confidence Limit	Not Available	2024-10-01–2025-09-30	hai / 17114	8Lower confidence limit unavailable
HAI_3_CIUPPERSSI - Colon Surgery: Upper Confidence Limit	1.152	2024-10-01–2025-09-30	hai / 17115	None
HAI_4_SIRSSI - Abdominal Hysterectomy	Not Available	2024-10-01–2025-09-30	hai / 17125	13CMS cannot calculate
HAI_4_NUMERATORSSI - Abdominal Hysterectomy: Observed Cases	3	2024-10-01–2025-09-30	hai / 17124	None
HAI_4_ELIGCASESSSI - Abdominal Hysterectomy: Predicted Cases	0.624	2024-10-01–2025-09-30	hai / 17123	None
HAI_4_CILOWERSSI - Abdominal Hysterectomy: Lower Confidence Limit	Not Available	2024-10-01–2025-09-30	hai / 17120	13CMS cannot calculate
HAI_4_CIUPPERSSI - Abdominal Hysterectomy: Upper Confidence Limit	Not Available	2024-10-01–2025-09-30	hai / 17121	13CMS cannot calculate
HAI_5_SIRMRSA Bacteremia	0.144	2024-10-01–2025-09-30	hai / 17131	None
HAI_5_NUMERATORMRSA Bacteremia: Observed Cases	1	2024-10-01–2025-09-30	hai / 17130	None
HAI_5_ELIGCASESMRSA Bacteremia: Predicted Cases	6.946	2024-10-01–2025-09-30	hai / 17129	None
HAI_5_CILOWERMRSA Bacteremia: Lower Confidence Limit	0.007	2024-10-01–2025-09-30	hai / 17126	None
HAI_5_CIUPPERMRSA Bacteremia: Upper Confidence Limit	0.710	2024-10-01–2025-09-30	hai / 17127	None
HAI_6_SIRClostridium Difficile (C.Diff)	0.108	2024-10-01–2025-09-30	hai / 17137	None
HAI_6_NUMERATORClostridium Difficile (C.Diff): Observed Cases	5	2024-10-01–2025-09-30	hai / 17136	None
HAI_6_ELIGCASESClostridium Difficile (C.Diff): Predicted Cases	46.491	2024-10-01–2025-09-30	hai / 17135	None
HAI_6_CILOWERClostridium Difficile (C.Diff): Lower Confidence Limit	0.039	2024-10-01–2025-09-30	hai / 17132	None
HAI_6_CIUPPERClostridium Difficile (C.Diff): Upper Confidence Limit	0.238	2024-10-01–2025-09-30	hai / 17133	None
READM_30_AMIAcute Myocardial Infarction (AMI) 30-Day Readmission Rate	15.1CMS cohort: 283Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	readmissions / 6660	None
READM_30_HFHeart failure (HF) 30-Day Readmission Rate	22.2CMS cohort: 852Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	readmissions / 6663	None
READM_30_PNPneumonia (PN) 30-Day Readmission Rate	17.9CMS cohort: 708Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	readmissions / 6665	None
READM_30_COPDRate of readmission for chronic obstructive pulmonary disease (COPD) patients	21.2CMS cohort: 379Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	readmissions / 6662	None
READM_30_CABGRate of readmission for CABG	11.3CMS cohort: 51Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	readmissions / 6661	None
READM_30_HIP_KNEERate of readmission after hip/knee replacement	6.1CMS cohort: 57Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	readmissions / 6664	None
MORT_30_AMIDeath rate for heart attack patients	14.6CMS cohort: 190Lower estimate: Not AvailableHigher estimate: Not Available	2022-07-01–2025-06-30	mortality / 9504	None
MORT_30_HFDeath rate for heart failure patients	12.9CMS cohort: 445Lower estimate: Not AvailableHigher estimate: Not Available	2022-07-01–2025-06-30	mortality / 9507	None
MORT_30_PNDeath rate for pneumonia patients	13.7CMS cohort: 444Lower estimate: Not AvailableHigher estimate: Not Available	2022-07-01–2025-06-30	mortality / 9508	None
MORT_30_COPDDeath rate for COPD patients	9.6CMS cohort: 193Lower estimate: Not AvailableHigher estimate: Not Available	2022-07-01–2025-06-30	mortality / 9506	None
MORT_30_CABGDeath rate for CABG surgery patients	1.9CMS cohort: 45Lower estimate: Not AvailableHigher estimate: Not Available	2022-07-01–2025-06-30	mortality / 9505	None
MORT_30_STKDeath rate for stroke patients	12.2CMS cohort: 518Lower estimate: Not AvailableHigher estimate: Not Available	2023-07-01–2025-06-30	mortality / 9509	None
HAI_1_DOPCCentral Line Associated Bloodstream Infection: Number of Device Days	7920	2024-10-01–2025-09-30	hai / 17104	None
HAI_2_DOPCCatheter Associated Urinary Tract Infections (ICU + select Wards): Number of Urinary Catheter Days	6548	2024-10-01–2025-09-30	hai / 17110	None
HAI_3_DOPCSSI - Colon Surgery: Number of Procedures	92	2024-10-01–2025-09-30	hai / 17116	None
HAI_4_DOPCSSI - Abdominal Hysterectomy: Number of Procedures	73	2024-10-01–2025-09-30	hai / 17122	None
HAI_5_DOPCMRSA Bacteremia: Patient Days	110397	2024-10-01–2025-09-30	hai / 17128	None
HAI_6_DOPCClostridium Difficile (C.Diff): Patient Days	101142	2024-10-01–2025-09-30	hai / 17134	None

CMS footnote definitions · HCAHPS survey versions

2022–2024 annual nursing history · source records & calculations

HCAI 106340950 · annual financial reporting unit
Report	Reporting period	Productive RN hours	Patient days	Contract RN hours	Nursing hours
2022	2021-07-01–2022-06-30	1,424,981	97,966	24,505	1,669,382
2023	2022-07-01–2023-06-30	1,384,501	99,972	87,142	1,673,748
2024	2023-07-01–2024-06-30	1,357,747	100,817	101,236	1,663,552

RN hours per patient day: PRD_HR_RN ÷ DAY_TOT. Contract RN share: CNT_HR_RN ÷ (PRD_HR_RN + PRD_HR_LVN + PRD_HR_AID + CNT_HR_RN).

2022 HCAI annual financial records · Preserved source · API record ID 257 · Audited · ComparableSHA-256: a79841850b69181682634b9cf5baafc9886fc80761f7ef7bd18281d87c488e8e
2023 HCAI annual financial records · Preserved source · API record ID 257 · Audited · ComparableSHA-256: 50ecefcc9e0613b9c65c7f292acbb5ea45d82205d0ec651ee7a42c153143a4ba
2024 HCAI annual financial records · Preserved source · HADR 01-01-2024 to 12-31-2024 row 255 · Audited · ComparableSHA-256: 0fcc4c3c52f335adc63699cf65d5ecbe28b94bb2d20433508cfe799e82541e26

2024 HCAI selected annual financial reports · RN hours and patient-day care mix · Preserved workbook
RN comparison calculation & reporting scope
Unweighted median of hospital report ratios PRD_HR_RN / DAY_TOT. Middle 50%: inclusive linear-interpolated 25th and 75th percentiles. Same 2024 selected-report file; audited Comparable reports, 365 or 366 days, majority (>50%) patient-day care group, exact unique HCAI IDs, reconciled care-day totals and existing CNO ratio. Includes reported zero RN hours; excludes missing values. No reference for mixed care-day groups or cohorts smaller than eight.
HCAI 106340950 · HADR 01-01-2024 to 12-31-2024 · row 255 · Audited · 2023-07-01–2024-06-30
Outlier screen: ratio above the care-group upper quartile plus three interquartile ranges.
Productive RN hours: 1,357,747 ÷ total patient days: 100,817
- Acute care: 100,817 patient days
- Psychiatric: 0 patient days
- Chemical dependency: 0 patient days
- Rehabilitation: 0 patient days
- Long-term care: 0 patient days
- Residential: 0 patient days
Source SHA-256: 0fcc4c3c52f335adc63699cf65d5ecbe28b94bb2d20433508cfe799e82541e26
Oct 2024–Mar 2025 · EMSA ambulance offload history · page 22 · Preserved report
Offload hospital identity & source times
Mercy San Juan Medical Center · Sacramento · CEMSIS 20286 · unique normalized hospital / retained CMS name + EMS geography
- Oct 2024: 0:27:08 · 90th percentile · 1,848 qualifying offloads · page 22 · count page 31
- Nov 2024: 0:24:14 · 90th percentile · 1,714 qualifying offloads · page 22 · count page 36
- Dec 2024: 0:30:30 · 90th percentile · 1,786 qualifying offloads · page 22 · count page 41
- Jan 2025: 0:30:25 · 90th percentile · 1,933 qualifying offloads · page 22 · count page 46
- Feb 2025: 0:33:28 · 90th percentile · 1,834 qualifying offloads · page 22 · count page 51
- Mar 2025: 0:29:42 · 90th percentile · 1,609 qualifying offloads · page 22 · count page 56
CMS ED measures · reporting unit 050516 · MERCY SAN JUAN MEDICAL CENTER · Preserved file
CMS values, dates & identity match
6501 COYLE AVE, CARMICHAEL 95608 · unique normalized address + city + ZIP
- OP_18b: 197 · 2024-10-01–2025-09-30 · sample 350
- OP_18c: 330 · 2024-10-01–2025-09-30 · sample 22
- OP_18d: Not Available · 2024-10-01–2025-09-30 · sample Not Available · CMS footnote 1
- OP_22: 1 · 2024-01-01–2024-12-31 · sample 81679
Preserved hospital identities · CMS footnote definitions
2022-01-01–2022-12-31 · HCAI licensed specialty beds, ED activity & diversion · Preserved file
2023-01-01–2023-12-31 · HCAI licensed specialty beds, ED activity & diversion · Preserved file
2024-01-01–2024-12-31 · HCAI licensed specialty beds, ED activity & diversion · Preserved file
2024 contract RN share calculation
Nursing-hour denominator
Contract RN hours ÷ (productive RN + productive LVN + productive aide + contract RN hours). HCAI fields: CNT_HR_RN ÷ (PRD_HR_RN + PRD_HR_LVN + PRD_HR_AID + CNT_HR_RN).
Productive FTE calculation · hours ÷ 2,080
2024 HCAI annual financial / RN labor
2025 California capacity record

All public source collections →
Evidence standards & methodology →↑ Back to snapshot

Research record, provenance & reporting scope

← Return to the statewide directory

Public Record Profile · No state call

Mercy San Juan Medical Center

Sacramento County · HCAI 106340950

Profile statusLISTED — NOT YET REVIEWEDDescriptive profile · two source layers2024 financial filing audited2024 workforce record available2025 capacity record available

What this page can show2024 nursing labor and 2025 capacity, reported separately.

What the public record reports

What is reported?

This facility is listed, but its records have not received the additional hospital-specific review shown on reviewed profiles.

Reported RN labor1,357,747 productive RN hours.

1,357,747Hospital-wide productive RN hours · 2024

Contract RN share6.1% of reported RN labor.

6.1%Agency, registry, or contract RN share · 2024

Reported RN intensity13.5 RN hours per patient day.

13.5Hospital-wide annual proxy · 2024

Reported capacity312 staffed beds.

384 → 312Available → staffed beds · 2025

Evidence trail

Where the numbers came from.

Facility identity

CLEAR — UNIQUE ID MATCH. This page is anchored to HCAI facility ID 106340950.

Open official facility source ↗

Workforce source

2024 productive RN hours and contract-RN measures come from the HCAI hospital financial/workforce reporting layer.

Open HCAI hospital financials ↗

Capacity source

2025 licensed, available, and staffed-bed records are a separate capacity layer with its own reporting scope.

Open California health data ↗

Next evidence step

Acquire third independent audited domain before any state call.

Read CNO’s methodology →

Use the gap

What changed in patient demand, staffed capacity, and permanent RN coverage during the same reporting period—and what happened on my unit?

Search another hospital →REQUEST AN ANONYMOUS REVIEW →

Compare hospitals →Request an anonymous review →

Field	Value
month	2024-10
minutes	27.133333333333333
offloadCount	1848
countPage	31
rawTime	0:27:08
sourceId	EMSA-APOT-JUNE2025
page	22
row	15

Field	Value
month	2024-11
minutes	24.233333333333334
offloadCount	1714
countPage	36
rawTime	0:24:14
sourceId	EMSA-APOT-JUNE2025
page	22
row	15

Field	Value
month	2024-12
minutes	30.5
offloadCount	1786
countPage	41
rawTime	0:30:30
sourceId	EMSA-APOT-JUNE2025
page	22
row	15

Field	Value
month	2025-01
minutes	30.416666666666668
offloadCount	1933
countPage	46
rawTime	0:30:25
sourceId	EMSA-APOT-JUNE2025
page	22
row	15

Field	Value
month	2025-02
minutes	33.46666666666667
offloadCount	1834
countPage	51
rawTime	0:33:28
sourceId	EMSA-APOT-JUNE2025
page	22
row	15

Field	Value
month	2025-03
minutes	29.7
offloadCount	1609
countPage	56
rawTime	0:29:42
sourceId	EMSA-APOT-JUNE2025
page	22
row	15