Table | # | Values |
---|---|---|
chargemasters_dirs | 1 |
pk: 5086 full_name: 2024/UC DAVIS REHABILITATION HOSPITAL oshpd_id: 106340025 year: 2024 |
chargemasters_files | 3 |
pk: 12495 dir_pk: 5086 year: 2024 full_name: 2024/UC DAVIS REHABILITATION HOSPITAL/106340025_CDM_ALL_2024.xlsx oshpd_id: 106340025 file_type: CDM All file_ext: xlsx common25: None pk: 12496 dir_pk: 5086 year: 2024 full_name: 2024/UC DAVIS REHABILITATION HOSPITAL/106340025_Common 25_2024.xlsx oshpd_id: 106340025 file_type: Common25 file_ext: xlsx common25: None pk: 12497 dir_pk: 5086 year: 2024 full_name: 2024/UC DAVIS REHABILITATION HOSPITAL/106340025_PCT_CHG.xlsx oshpd_id: 106340025 file_type: PCT CHG file_ext: xlsx common25: None |
facility_profile_attributes | 1 |
facility_desc: UC DAVIS REHABILITATION HOSPITAL site_address1: 4875 BROADWAY site_address2: None site_city: SACRAMENTO site_zip: 95820 site_x_coordinate: -121.451141 site_y_coordinate: 38.547364 oshpd_id: 106340025 license_type_desc: Hospital license_category_desc: General Acute Care Hospital license_number: 550008538 facility_level_desc: Parent Facility er_service_level_desc: Not Specified licensed_beds: 52 facility_status_desc: Open financial_facility_count: 0 consolidated_facility_desc_pipe: None consolidated_facility_desc_comma: None period_begin_date: None period_end_date: None net_pat_rev_medicare_traditional_ip: None net_pat_rev_medicare_managed_ip: None net_pat_rev_medi_cal_traditional_ip: None net_pat_rev_medi_cal_managed_ip: None net_pat_rev_county_indigent_traditional_ip: None net_pat_rev_county_indigent_managed_ip: None net_pat_rev_third_party_traditional_ip: None net_pat_rev_third_party_managed_ip: None net_pat_rev_other_indigent_ip: None net_pat_rev_other_payer_ip: None net_pat_rev_total_ip: None net_pat_rev_medicare_traditional_op: None net_pat_rev_medicare_managed_op: None net_pat_rev_medi_cal_traditional_op: None net_pat_rev_medi_cal_managed_op: None net_pat_rev_county_indigent_traditional_op: None net_pat_rev_county_indigent_managed_op: None net_pat_rev_third_party_traditional_op: None net_pat_rev_third_party_managed_op: None net_pat_rev_other_indigent_op: None net_pat_rev_other_payer_op: None net_pat_rev_total_op: None payer_mix_medicare_traditional_ip: .000000000000 payer_mix_medicare_traditional_ip_state: None payer_mix_medicare_managed_ip: .000000000000 payer_mix_medicare_managed_ip_state: None payer_mix_medi_cal_traditional_ip: .000000000000 payer_mix_medi_cal_traditional_ip_state: None payer_mix_medi_cal_managed_ip: .000000000000 payer_mix_medi_cal_managed_ip_state: None payer_mix_county_indigent_traditional_ip: .000000000000 payer_mix_county_indigent_traditional_ip_state: None payer_mix_county_indigent_managed_ip: .000000000000 payer_mix_county_indigent_managed_ip_state: None payer_mix_third_party_traditional_ip: .000000000000 payer_mix_third_party_traditional_ip_state: None payer_mix_third_party_managed_ip: .000000000000 payer_mix_third_party_managed_ip_state: None payer_mix_other_indigent_ip: .000000000000 payer_mix_other_indigent_ip_state: None payer_mix_other_payer_ip: .000000000000 payer_mix_other_payer_ip_state: None payer_mix_medicare_traditional_op: .000000000000 payer_mix_medicare_traditional_op_state: None payer_mix_medicare_managed_op: .000000000000 payer_mix_medicare_managed_op_state: None payer_mix_medi_cal_traditional_op: .000000000000 payer_mix_medi_cal_traditional_op_state: None payer_mix_medi_cal_managed_op: .000000000000 payer_mix_medi_cal_managed_op_state: None payer_mix_county_indigent_traditional_op: .000000000000 payer_mix_county_indigent_traditional_op_state: None payer_mix_county_indigent_managed_op: .000000000000 payer_mix_county_indigent_managed_op_state: None payer_mix_third_party_traditional_op: .000000000000 payer_mix_third_party_traditional_op_state: None payer_mix_third_party_managed_op: .000000000000 payer_mix_third_party_managed_op_state: None payer_mix_other_indigent_op: .000000000000 payer_mix_other_indigent_op_state: None payer_mix_other_payer_op: .000000000000 payer_mix_other_payer_op_state: None avg_stay_medicare_traditional: None avg_stay_medicare_managed: None avg_stay_medi_cal_traditional: None avg_stay_medi_cal_managed: None avg_stay_county_indigent_traditional: None avg_stay_county_indigent_managed: None avg_stay_third_party_traditional: None avg_stay_third_party_managed: None avg_stay_other_indigent_total: None avg_stay_other_payer_total: None avg_stay_total: None active_projects: 1 active_project_costs: 95000 active_projects_state: 4279 active_project_costs_state: 18558539344 spc_1: 0 spc_2: 0 spc_3: 0 spc_4: 0 spc_5: 3 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: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 BROADWAY dba_city: SACRAMENTO dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54736370 longitude: -121.45114060 |
licensed_facility_listing_09 | 1 |
oshpd_id: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 Broadway dba_city: Sacramento dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54736230 longitude: -121.45124210 |
licensed_facility_listing_10 | 1 |
oshpd_id: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 BROADWAY dba_city: SACRAMENTO dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54736370 longitude: -121.45114060 |
licensed_facility_listing_17 | 1 |
oshpd_id: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 Broadway dba_city: Sacramento dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54752000 longitude: -121.45100000 |
licensed_facility_listing_18 | 1 |
oshpd_id: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 Broadway dba_city: Sacramento dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54736230 longitude: -121.45124210 |
licensed_healthcare_facility_listing | 2 |
period: current oshpd_id: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 BROADWAY dba_city: SACRAMENTO dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54736370 longitude: -121.45114060 period: 2023-06-30 oshpd_id: 106340025 facility_name: UC DAVIS REHABILITATION HOSPITAL license_num: 550008538 facility_level_desc: Parent Facility dba_address1: 4875 Broadway dba_city: Sacramento dba_zip_code: 95820 county_code: 34 county_name: Sacramento er_service_level_desc: None total_number_beds: 52 facility_status_desc: Open facility_status_date: 2023-05-17 license_type_desc: Hospital license_category_desc: General Acute Care Hospital latitude: 38.54752000 longitude: -121.45100000 |