| medi_cal_fpact_provider_listing | |
x - varchar(17)
y - varchar(16)
objectid - varchar(8)
rec_id - varchar(36)
provider_source - varchar(15)
provider_number - varchar(15)
owner_number - varchar(12)
service_location_number - varchar(23)
provider_name - varchar(35)
business_name - varchar(35)
enroll_stat_effective_dt - varchar(24)
fi_category_of_service_cd - varchar(25)
fi_category_of_service - varchar(44)
enroll_stat_cd - varchar(14)
fi_provider_type_cd - varchar(19)
fi_provider_type - varchar(54)
address_attention - varchar(24)
address - varchar(24)
address2 - varchar(24)
city - varchar(20)
state - varchar(5)
zip - varchar(5)
zip_4 - varchar(5)
dhcs_county_cd - varchar(14)
fips_county_cd - varchar(14)
county - varchar(15)
phone_number - varchar(14)
latitude - decimal(12,8)
longitude - decimal(12,8)
countyname - varchar(22)
|