Table	#	Values
chargemasters_dirs	3	pk: 4487 full_name: 2022/Scripps Mercy Hospital- Chula Vista oshpd_id: 106370658 year: 2022 pk: 4933 full_name: 2023/Scripps Mercy Hospital - Chula Vista oshpd_id: 106370658 year: 2023 pk: 5126 full_name: 2024/SCRIPPS MERCY HOSPITAL CHULA VISTA oshpd_id: 106370658 year: 2024
chargemasters_files	3	pk: 10335 dir_pk: 4487 year: 2022 full_name: 2022/Scripps Mercy Hospital- Chula Vista/106370658_CDM_ALL_2022.xlsx oshpd_id: 106370658 file_type: CDM All file_ext: xlsx common25: 54 pk: 11459 dir_pk: 4933 year: 2023 full_name: 2023/Scripps Mercy Hospital - Chula Vista/106370658_CDM_ALL.xlsx oshpd_id: 106370658 file_type: CDM All file_ext: xlsx common25: 55 pk: 12395 dir_pk: 5126 year: 2024 full_name: 2024/SCRIPPS MERCY HOSPITAL CHULA VISTA/106370658_CDM_ALL.xlsx oshpd_id: 106370658 file_type: CDM All file_ext: xlsx common25: None
hospital_chars_list_for_ca_provs_in_st_fisc_yr_2019_20	1	oshpd_id: 106370658 oshpd_provider_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA designated_nicu_as_defined_by_dhcs: No dph: No ndph: No oshpd_rural_hospital: No dhcs_designated_remote_rural: No sfy_2019_20_cost_to_charge_ratio_pct: 0.18293 ffy_2019_wage_index_value: 1.25 ffy_2019_wage_index_value_adjusted_for_ca_neutrality_factor: 1.2164 sfy_2019_20_unadjusted_statewide_base_rate: 6584 sfy_2019_20_wage_adjusted_statewide_base_rate: 7557 sfy_2019_20_rehab_rate: 0 sfy_2019_20_admin_2_190_rate: 1074.41 sfy_2019_20_admin_2_199_rate: 990.88
licensed_healthcare_facility_listing	15	period: current oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63378590 longitude: -117.08317770 period: 2016-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2017-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 90000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2018-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2019-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2020-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2021-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2022-12-31 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2017-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2018-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2019-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H STREET dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: SAN DIEGO er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2020-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2021-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2022-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000 period: 2023-06-30 oshpd_id: 106370658 facility_name: SCRIPPS MERCY HOSPITAL - CHULA VISTA license_num: 090000074 facility_level_desc: Consolidated Facility dba_address1: 435 H ST dba_city: CHULA VISTA dba_zip_code: 91910 county_code: 37 county_name: San Diego er_service_level_desc: Emergency - Basic total_number_beds: 173 facility_status_desc: Open facility_status_date: 2004-10-01 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 32.63289000 longitude: -117.08282000