| facility_profile_attributes |
|
facility_desc - varchar(79)
site_address1 - varchar(42)
site_address2 - varchar(50)
site_city - varchar(23)
site_zip - varchar(10)
site_x_coordinate - varchar(17)
site_y_coordinate - varchar(17)
oshpd_id - varchar(9)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
license_number - varchar(14)
facility_level_desc - varchar(22)
er_service_level_desc - varchar(21)
licensed_beds - varchar(13)
facility_status_desc - varchar(20)
financial_facility_count - varchar(24)
consolidated_facility_desc_pipe - varchar(158)
consolidated_facility_desc_comma - varchar(161)
period_begin_date - varchar(17)
period_end_date - varchar(15)
net_pat_rev_medicare_traditional_ip - varchar(35)
net_pat_rev_medicare_managed_ip - varchar(31)
net_pat_rev_medi_cal_traditional_ip - varchar(35)
net_pat_rev_medi_cal_managed_ip - varchar(31)
net_pat_rev_county_indigent_traditional_ip - varchar(42)
net_pat_rev_county_indigent_managed_ip - varchar(38)
net_pat_rev_third_party_traditional_ip - varchar(38)
net_pat_rev_third_party_managed_ip - varchar(34)
net_pat_rev_other_indigent_ip - varchar(29)
net_pat_rev_other_payer_ip - varchar(26)
net_pat_rev_total_ip - varchar(20)
net_pat_rev_medicare_traditional_op - varchar(35)
net_pat_rev_medicare_managed_op - varchar(31)
net_pat_rev_medi_cal_traditional_op - varchar(35)
net_pat_rev_medi_cal_managed_op - varchar(31)
net_pat_rev_county_indigent_traditional_op - varchar(42)
net_pat_rev_county_indigent_managed_op - varchar(38)
net_pat_rev_third_party_traditional_op - varchar(38)
net_pat_rev_third_party_managed_op - varchar(34)
net_pat_rev_other_indigent_op - varchar(29)
net_pat_rev_other_payer_op - varchar(26)
net_pat_rev_total_op - varchar(20)
payer_mix_medicare_traditional_ip - varchar(33)
payer_mix_medicare_traditional_ip_state - varchar(39)
payer_mix_medicare_managed_ip - varchar(29)
payer_mix_medicare_managed_ip_state - varchar(35)
payer_mix_medi_cal_traditional_ip - varchar(33)
payer_mix_medi_cal_traditional_ip_state - varchar(39)
payer_mix_medi_cal_managed_ip - varchar(29)
payer_mix_medi_cal_managed_ip_state - varchar(35)
payer_mix_county_indigent_traditional_ip - varchar(40)
payer_mix_county_indigent_traditional_ip_state - varchar(46)
payer_mix_county_indigent_managed_ip - varchar(36)
payer_mix_county_indigent_managed_ip_state - varchar(42)
payer_mix_third_party_traditional_ip - varchar(36)
payer_mix_third_party_traditional_ip_state - varchar(42)
payer_mix_third_party_managed_ip - varchar(32)
payer_mix_third_party_managed_ip_state - varchar(38)
payer_mix_other_indigent_ip - varchar(27)
payer_mix_other_indigent_ip_state - varchar(33)
payer_mix_other_payer_ip - varchar(24)
payer_mix_other_payer_ip_state - varchar(30)
payer_mix_medicare_traditional_op - varchar(33)
payer_mix_medicare_traditional_op_state - varchar(39)
payer_mix_medicare_managed_op - varchar(29)
payer_mix_medicare_managed_op_state - varchar(35)
payer_mix_medi_cal_traditional_op - varchar(33)
payer_mix_medi_cal_traditional_op_state - varchar(39)
payer_mix_medi_cal_managed_op - varchar(29)
payer_mix_medi_cal_managed_op_state - varchar(35)
payer_mix_county_indigent_traditional_op - varchar(40)
payer_mix_county_indigent_traditional_op_state - varchar(46)
payer_mix_county_indigent_managed_op - varchar(36)
payer_mix_county_indigent_managed_op_state - varchar(42)
payer_mix_third_party_traditional_op - varchar(36)
payer_mix_third_party_traditional_op_state - varchar(42)
payer_mix_third_party_managed_op - varchar(32)
payer_mix_third_party_managed_op_state - varchar(38)
payer_mix_other_indigent_op - varchar(27)
payer_mix_other_indigent_op_state - varchar(33)
payer_mix_other_payer_op - varchar(24)
payer_mix_other_payer_op_state - varchar(30)
avg_stay_medicare_traditional - varchar(29)
avg_stay_medicare_managed - varchar(25)
avg_stay_medi_cal_traditional - varchar(29)
avg_stay_medi_cal_managed - varchar(25)
avg_stay_county_indigent_traditional - varchar(36)
avg_stay_county_indigent_managed - varchar(32)
avg_stay_third_party_traditional - varchar(32)
avg_stay_third_party_managed - varchar(28)
avg_stay_other_indigent_total - varchar(29)
avg_stay_other_payer_total - varchar(26)
avg_stay_total - varchar(14)
active_projects - varchar(15)
active_project_costs - varchar(20)
active_projects_state - varchar(21)
active_project_costs_state - varchar(26)
spc_1 - varchar(5)
spc_2 - varchar(5)
spc_3 - varchar(5)
spc_4 - varchar(5)
spc_5 - varchar(5)
spc_1_state - varchar(11)
spc_2_state - varchar(11)
spc_3_state - varchar(11)
spc_4_state - varchar(11)
spc_5_state - varchar(11)
sysdate - varchar(7)
|