| Name |
family-pact-providers-profile |
|---|
| Updated |
2024-12-16 |
|---|
| Current |
True |
|---|
| Tables |
| family_pact_providers_profile_cy_2019 | |
provider_number - varchar(15)
npi_provider_number - varchar(19)
owner_number - varchar(12)
service_location_number - varchar(23)
provider_business_legal_name - varchar(28)
enrollment_status_effective_date - varchar(32)
provider_type_code - varchar(37)
provider_type_code_desc - varchar(43)
provider_license_number - varchar(23)
provider_specialty_code - varchar(23)
provider_specialty_code_desc - varchar(55)
out_of_state_ind - varchar(16)
out_of_state_ind_desc - varchar(21)
provider_address_county_code - varchar(28)
provider_address_county_code_description - varchar(40)
attention_line - varchar(24)
provider_address_line1 - varchar(24)
provider_address_line2 - varchar(24)
provider_address_city - varchar(21)
provider_address_state - varchar(22)
provider_address_zip - varchar(20)
provider_address_latitude - varchar(25)
provider_address_longitude - varchar(26)
mssa_id - varchar(8)
tract_id - varchar(8)
|
| family_pact_providers_profile_cy_2021_2022 | |
provider_number - varchar(18)
npi_provider_number - varchar(19)
owner_number - varchar(12)
service_location_number - varchar(23)
provider_business_legal_name - varchar(28)
enrollment_status_effective_date - varchar(32)
provider_type_code - varchar(18)
provider_type_code_desc - varchar(54)
provider_license_number - varchar(23)
provider_specialty_code - varchar(23)
provider_specialty_code_desc - varchar(42)
out_of_state_ind - varchar(16)
out_of_state_ind_desc - varchar(21)
provider_address_county_code - varchar(28)
provider_address_county_desc - varchar(28)
attention_line - varchar(24)
provider_address_line1 - varchar(24)
provider_address_line2 - varchar(24)
provider_address_city - varchar(21)
provider_address_state - varchar(22)
provider_address_zip - varchar(20)
provider_address_latitude - varchar(25)
provider_address_longitude - varchar(26)
mssa_id - varchar(8)
tract_id - varchar(8)
|
| family_pact_providers_profile_cys_2020_2021 | |
provider_number - varchar(15)
npi_provider_number - varchar(19)
owner_number - varchar(12)
service_location_number - varchar(23)
provider_business_legal_name - varchar(28)
enrollment_status_effective_date - varchar(32)
provider_type_code - varchar(18)
provider_type_code_desc - varchar(54)
provider_license_number - varchar(23)
provider_specialty_code - varchar(23)
provider_specialty_code_desc - varchar(51)
out_of_state_ind - varchar(16)
out_of_state_ind_desc - varchar(21)
provider_address_county_code - varchar(28)
provider_address_county_desc - varchar(28)
attention_line - varchar(24)
provider_address_line1 - varchar(24)
provider_address_line2 - varchar(24)
provider_address_city - varchar(21)
provider_address_state - varchar(22)
provider_address_zip - varchar(20)
provider_phone_number - varchar(21)
provider_address_latitude - varchar(25)
provider_address_longitude - varchar(26)
mssa_id - varchar(8)
tract_id - varchar(8)
|
|
|---|
| Sources |
data-dictionary.docx --> None
family-pact-providers-profile-cy-2019.csv --> family_pact_providers_profile_cy_2019
family-pact-providers-profile-cy-2021-2022.csv --> family_pact_providers_profile_cy_2021_2022
family-pact-providers-profile-cys-2020-2021.csv --> family_pact_providers_profile_cys_2020_2021
|
|---|
| Updates |
| 2025-02-02 17:55:06 |
|
0 |
| 2025-01-31 16:05:18 |
|
0 |
| 2024-12-29 21:51:43 |
|
0 |
| 2024-12-27 18:34:53 |
|
0 |
| 2024-12-14 14:34:42 |
|
0 |
| 2024-12-04 16:23:36 |
|
None |
| 2024-09-18 12:57:27 |
|
None |
|
|---|