Table # Values
chargemasters_dirs 3 pk: 4465
full_name: 2022/Sacramento Behavioral Healthcare Hospital
oshpd_id: 106344210
year: 2022
pk: 4909
full_name: 2023/Sacramento Behavioral Healthcare Hospital LLC
oshpd_id: 106344210
year: 2023
pk: 5398
full_name: 2024/SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
oshpd_id: 106344210
year: 2024
chargemasters_files 3 pk: 10766
dir_pk: 4465
year: 2022
full_name: 2022/Sacramento Behavioral Healthcare Hospital/106344210_CDM_ALL.xls
oshpd_id: 106344210
file_type: CDM All
file_ext: xls
common25: 0
pk: 11293
dir_pk: 4909
year: 2023
full_name: 2023/Sacramento Behavioral Healthcare Hospital LLC/106344210_CDM_ALL_2023.xlsx
oshpd_id: 106344210
file_type: CDM All
file_ext: xlsx
common25: 2
pk: 12372
dir_pk: 5398
year: 2024
full_name: 2024/SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC/106344210_CDM_ALL.xlsx
oshpd_id: 106344210
file_type: CDM All
file_ext: xlsx
common25: None
facility_profile_attributes 1 facility_desc: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
site_address1: 1400 EXPO PARKWAY
site_address2: None
site_city: SACRAMENTO
site_zip: 95815
site_x_coordinate: -121.457447
site_y_coordinate: 38.597054
oshpd_id: 106344210
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
license_number: 550007457
facility_level_desc: Parent Facility
er_service_level_desc: Not Specified
licensed_beds: 117
facility_status_desc: Open
financial_facility_count: 1
consolidated_facility_desc_pipe: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
consolidated_facility_desc_comma: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
period_begin_date: 2023-01-01
period_end_date: 2023-12-31
net_pat_rev_medicare_traditional_ip: 1862473
net_pat_rev_medicare_managed_ip: 840430
net_pat_rev_medi_cal_traditional_ip: 506844
net_pat_rev_medi_cal_managed_ip: 56855
net_pat_rev_county_indigent_traditional_ip: 32376567
net_pat_rev_county_indigent_managed_ip: 0
net_pat_rev_third_party_traditional_ip: 29353
net_pat_rev_third_party_managed_ip: 3240491
net_pat_rev_other_indigent_ip: 10236
net_pat_rev_other_payer_ip: 0
net_pat_rev_total_ip: 38923250
net_pat_rev_medicare_traditional_op: 25350
net_pat_rev_medicare_managed_op: 9917
net_pat_rev_medi_cal_traditional_op: 0
net_pat_rev_medi_cal_managed_op: 0
net_pat_rev_county_indigent_traditional_op: 0
net_pat_rev_county_indigent_managed_op: 0
net_pat_rev_third_party_traditional_op: 0
net_pat_rev_third_party_managed_op: 154421
net_pat_rev_other_indigent_op: -30
net_pat_rev_other_payer_op: 0
net_pat_rev_total_op: 189657
payer_mix_medicare_traditional_ip: .078334509527
payer_mix_medicare_traditional_ip_state: .2319
payer_mix_medicare_managed_ip: .044460127028
payer_mix_medicare_managed_ip_state: .1787
payer_mix_medi_cal_traditional_ip: .154551870148
payer_mix_medi_cal_traditional_ip_state: .0995
payer_mix_medi_cal_managed_ip: .004234297812
payer_mix_medi_cal_managed_ip_state: .2287
payer_mix_county_indigent_traditional_ip: .489061397318
payer_mix_county_indigent_traditional_ip_state: .0097
payer_mix_county_indigent_managed_ip: .000000000000
payer_mix_county_indigent_managed_ip_state: .0002
payer_mix_third_party_traditional_ip: .005645730416
payer_mix_third_party_traditional_ip_state: .0365
payer_mix_third_party_managed_ip: .218772053634
payer_mix_third_party_managed_ip_state: .1991
payer_mix_other_indigent_ip: .004940014114
payer_mix_other_indigent_ip_state: .0050
payer_mix_other_payer_ip: .000000000000
payer_mix_other_payer_ip_state: .0107
payer_mix_medicare_traditional_op: .191570881226
payer_mix_medicare_traditional_op_state: .2267
payer_mix_medicare_managed_op: .045977011494
payer_mix_medicare_managed_op_state: .0967
payer_mix_medi_cal_traditional_op: .000000000000
payer_mix_medi_cal_traditional_op_state: .0584
payer_mix_medi_cal_managed_op: .000000000000
payer_mix_medi_cal_managed_op_state: .2641
payer_mix_county_indigent_traditional_op: .000000000000
payer_mix_county_indigent_traditional_op_state: .0109
payer_mix_county_indigent_managed_op: .000000000000
payer_mix_county_indigent_managed_op_state: .0018
payer_mix_third_party_traditional_op: .000000000000
payer_mix_third_party_traditional_op_state: .0490
payer_mix_third_party_managed_op: .762452107279
payer_mix_third_party_managed_op_state: .2667
payer_mix_other_indigent_op: .000000000000
payer_mix_other_indigent_op_state: .0074
payer_mix_other_payer_op: .000000000000
payer_mix_other_payer_op_state: .0182
avg_stay_medicare_traditional: 12.4775
avg_stay_medicare_managed: 11.3175
avg_stay_medi_cal_traditional: 6.7626
avg_stay_medi_cal_managed: 13.3333
avg_stay_county_indigent_traditional: 41.7359
avg_stay_county_indigent_managed: .0000
avg_stay_third_party_traditional: 6.7500
avg_stay_third_party_managed: 8.0677
avg_stay_other_indigent_total: 9.0000
avg_stay_other_payer_total: .0000
avg_stay_total: 24.8412
active_projects: None
active_project_costs: None
active_projects_state: 4279
active_project_costs_state: 18558539344
spc_1: None
spc_2: None
spc_3: None
spc_4: None
spc_5: None
spc_1_state: 33
spc_2_state: 655
spc_3_state: 385
spc_4_state: 781
spc_5_state: 1446
sysdate: None
licensed_facility_listing_01 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 EXPO PARKWAY
dba_city: SACRAMENTO
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59705350
longitude: -121.45744690
licensed_facility_listing_08 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59706000
longitude: -121.45729000
licensed_facility_listing_09 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59705400
longitude: -121.45744800
licensed_facility_listing_10 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 EXPO PARKWAY
dba_city: SACRAMENTO
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59705350
longitude: -121.45744690
licensed_facility_listing_16 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59706000
longitude: -121.45729000
licensed_facility_listing_17 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59706000
longitude: -121.45729000
licensed_facility_listing_18 1 oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 EXPO PARKWAY
dba_city: SACRAMENTO
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 0.00000000
longitude: 0.00000000
licensed_healthcare_facility_listing 4 period: current
oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 EXPO PARKWAY
dba_city: SACRAMENTO
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59705350
longitude: -121.45744690
period: 2022-12-31
oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59706000
longitude: -121.45729000
period: 2022-06-30
oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59706000
longitude: -121.45729000
period: 2023-06-30
oshpd_id: 106344210
facility_name: SACRAMENTO BEHAVIORAL HEALTHCARE HOSPITAL, LLC
license_num: 550007457
facility_level_desc: Parent Facility
dba_address1: 1400 Expo Pkwy
dba_city: Sacramento
dba_zip_code: 95815
county_code: 34
county_name: Sacramento
er_service_level_desc: Not Applicable
total_number_beds: 117
facility_status_desc: Open
facility_status_date: 2021-12-17
license_type_desc: Hospital
license_category_desc: Acute Psychiatric Hospital
latitude: 38.59706000
longitude: -121.45729000