Demographics
Provides a conformed table with demographic information on HCPs and HCOs sourced from CRM or Network. Mappings are delivered enabled by default. To prevent either source from pushing data to global ODS, set the mapping table value on the enabled: attribute to false. Address fields are included only if they are marked as primary or ordinal = 1.
| Global ODS Field | Field Type |
Source Data Connector: Network _FTP Table: network_hco_ods__v |
Source Data Connector: Network _FTP Table: network_hcp_ods__v |
Source Data Connector: CRM Table: account_ods__v |
Source Data Connector: Network IS Table: network_hco_ods__v |
Source Data Connector: Network IS Table: network_hcp_ods__v |
|---|---|---|---|---|---|---|
| composite_key__v | varchar(100) | |source_connector_name__v|souce_table_name__v|native_id__v|start_date__v|end_date__| | |source_connector_name__v|souce_table_name__v|native_id__v|start_date__v|end_date__| | |source_connector_name__v|souce_table_name__v|native_id__v|start_date__v|end_date__| | |source_connector_name__v|souce_table_name__v|native_id__v|start_date__v|end_date__| | |source_connector_name__v|souce_table_name__v|native_id__v|start_date__v|end_date__| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) | Extracted from Internal Admin Console (Source ID) |
| native_id__v | varchar(18) | vid__v | vid__v | account_ods__v.crm_account_id__v | vid__v | vid__v |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console (Connector Name) | Extracted from Internal Admin Console (Connector Name) | Extracted from Internal Admin Console (Connector Name) | Extracted from Internal Admin Console (Connector Name) | Extracted from Internal Admin Console (Connector Name) |
| source_table_name__v | varchar(100) | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS |
| account_name__v | varchar(300) | null | corporate_name__v | account_name__v | null | corporate_name__v |
| account_country__v | varchar(200) | primary_country__v | primary_country__v | country_vod__v.Country_Name_vod__c | primary_country__v | primary_country__v |
| address_country__v | varchar(765) | network_address_ods__v.country__v | network_address_ods__v.country__v | address_vod__v.country_vod__v | network_address_ods__v.country__v | network_address_ods__v.country__v |
| address_line_1__v | varchar(240) | network_address_ods__v.address_line_1__v | network_address_ods__v.address_line_1__v | address_vod__v.address_vod_name__v | network_address_ods__v.address_line_1__v | network_address_ods__v.address_line_1__v |
| address_line_2__v | varchar(300) | network_address_ods__v.address_line_2__v | network_address_ods__v.address_line_2__v | address_vod__v.address_line_2_vod__v | network_address_ods__v.address_line_2__v | network_address_ods__v.address_line_2__v |
| locality__v | varchar(150) | network_address_ods__v.locality__v | network_address_ods__v.locality__v | address_vod__v.city_vod__v | network_address_ods__v.locality__v | network_address_ods__v.locality__v |
| first_name__v | varchar(200) | first_name__v | null | firstname__v | first_name__v | null |
| last_name__v | varchar(240) | last_name__v | null | lastname__v | last_name__v | null |
| specialty_1__v | varchar(765) | specialty_1__v | specialty_1__v | specialty_1_vod__v | specialty_1__v | specialty_1__v |
| credentials__v | varchar(765) | null | credentials_1__v | credentials_vod__v | null | credentials_1__v |
| email__v | varchar(240) | email_1__v | null | personemail__v | email_1__v | null |
| npi__v | varchar(75) | npi_num__v | null | npi_vod__v | npi_num__v | null |
| phone__v | varchar(120) | network_address_ods__v.phone_1__v | network_address_ods__v.phone_1__v | address_vod__v.phone_vod__v | network_address_ods__v.phone_1__v | network_address_ods__v.phone_1__v |
| postal_code__v | varchar(60) | network_address_ods__v.postal_code__v | network_address_ods__v.postal_code__v | address_vod__v.zip_vod__v | network_address_ods__v.postal_code__v | network_address_ods__v.postal_code__v |
| administrative_area__v | varchar(765) | network_address_ods__v.administrative_area__v | network_address_ods__v.administrative_area__v | address_vod__v.state_vod__v | network_address_ods__v.administrative_area__v | network_address_ods__v.administrative_area__v |
| vid__v | varchar(765) | vid__v | vid__v | veevaid_vod__v | vid__v | vid__v |
| ispersonaccount__v | boolean | "True" | "False" | ispersonaccount__v | "True" | "False" |
| accept_medicaid__v | varchar(20) | accept_medicaid__v | null | start_date__v | accept_medicaid__v | null |
| accept_medicare__v | varchar(20) | accept_medicare__v | null | end_date__v | accept_medicare__v | null |
| ama_do_not_contact__v | varchar(20) | ama_do_not_contact__v | ama_do_not_contact__v | lastmodifieddate__v | ama_do_not_contact__v | ama_do_not_contact__v |
| ams_id__v | varchar(10) | ams_id__v | ams_id__v | null | ams_id__v | ams_id__v |
| aoa_id__v | varchar(10) | null | aoa_id__v | null | null | aoa_id__v |
| birth_city__v | varchar(200) | null | birth_city__v | null | null | birth_city__v |
| birth_country__v | varchar(100) | null | birth_country__v | null | null | birth_country__v |
| birth_state__v | varchar(10) | null | birth_state__v | null | null | birth_state__v |
| birth_year__v | varchar(10) | null | birth_year__v | null | null | birth_year__v |
| board_certification__v | varchar(100) | null | board_certification__v | null | null | board_certification__v |
| candidate_record__v | varchar(10) | candidate_record__v | candidate_record__v | null | candidate_record__v | candidate_record__v |
| clia_effective_date__v | date | clia_effective_date__v | null | null | clia_effective_date__v | null |
| clia_exception_date__v | date | clia_exception_date__v | null | null | clia_exception_date__v | null |
| clia_lab_num__v | varchar(10) | clia_lab_num__v | null | null | clia_lab_num__v | null |
| clia_status__v | varchar(10) | clia_status__v | null | null | clia_status__v | null |
| corporate_name__v | varchar(300) | corporate_name__v | null | null | corporate_name__v | null |
| count_all_locn_md_do__v | numeric(6) | count_all_locn_md_do__v | null | null | count_all_locn_md_do__v | null |
| count_all_locn_medstaff__v | numeric(6) | count_all_locn_medstaff__v | null | null | count_all_locn_medstaff__v | null |
| count_all_locn_non_md_do__v | numeric(6) | count_all_locn_non_md_do__v | null | null | count_all_locn_non_md_do__v | null |
| count_beds__v | numeric(6) | count_beds__v | null | null | count_beds__v | null |
| count_inpatients__v | numeric(9) | count_inpatients__v | null | null | count_inpatients__v | null |
| count_md_do__v | numeric(6) | count_md_do__v | null | null | count_md_do__v | null |
| count_medstaff__v | numeric(6) | count_medstaff__v | null | null | count_medstaff__v | null |
| count_non_md_do__v | numeric(6) | count_non_md_do__v | null | null | count_non_md_do__v | null |
| count_outpatients__v | numeric(9) | count_outpatients__v | null | null | count_outpatients__v | null |
| credentials_1_referencetype__v | varchar(15) | null | HCPCredentials | null | null | HCPCredentials |
| credentials_2__v | varchar(100) | null | credentials_2__v | null | null | credentials_2__v |
| credentials_2_referencetype__v | varchar(15) | null | HCPCredentials | null | null | HCPCredentials |
| cri_id__v | varchar(10) | cri_id__v | cri_id__v | null | cri_id__v | cri_id__v |
| education_level__v | varchar(100) | null | education_level__v | null | null | education_level__v |
| email_2__v | varchar(100) | email_2__v | email_2__v | null | email_2__v | email_2__v |
| fellow__v | varchar(20) | null | fellow__v | null | null | fellow__v |
| formatted_name__v | varchar(200) | null | formatted_name__v | null | null | formatted_name__v |
| gender__v | varchar(5) | null | gender__v | null | null | gender__v |
| gln_id__v | varchar(10) | gln_id__v | null | null | gln_id__v | null |
| grad_school__v | varchar(200) | null | grad_school__v | null | null | grad_school__v |
| grad_training__v | varchar(20) | null | grad_training__v | null | null | grad_training__v |
| grad_trg_end_date__v | date | null | grad_trg_end_date__v | null | null | grad_trg_end_date__v |
| grad_trg_start_date__v | date | null | grad_trg_start_date__v | null | null | grad_trg_start_date__v |
| grad_year__v | varchar(4) | null | grad_year__v | null | null | grad_year__v |
| account_status__v | varchar(255) | hco_status__v | hcp_status__v | null | hco_status__v | hcp_status__v |
| hco_tax_id__v | varchar(20) | hco_tax_id__v | null | null | hco_tax_id__v | null |
| hco_type__v | varchar(100) | hco_type__v | null | null | hco_type__v | null |
| hcp_type__v | varchar(30) | null | hcp_type__v | null | null | hcp_type__v |
| hin__v | varchar(10) | hin__v | null | null | hin__v | null |
| kaiser__v | varchar(20) | kaiser__v | kaiser__v | null | kaiser__v | kaiser__v |
| knipper_id__v | varchar(10) | null | knipper_id__v | null | null | knipper_id__v |
| lab_services__v | varchar(20) | lab_services__v | null | null | lab_services__v | null |
| major_class_of_trade__v | varchar(30) | major_class_of_trade__v | null | null | major_class_of_trade__v | null |
| me_id__v | varchar(10) | null | me_id__v | null | null | me_id__v |
| medical_degree_1__v | varchar(100) | null | medical_degree_1__v | null | null | medical_degree_1__v |
| medical_degree_2__v | varchar(100) | null | medical_degree_2__v | null | null | medical_degree_2__v |
| middle_name__v | varchar(200) | null | middle_name__v | null | null | middle_name__v |
| mpa__v | varchar(100) | null | mpa__v | null | null | mpa__v |
| ncpdp_num__v | varchar(10) | ncpdp_num__v | null | null | ncpdp_num__v | null |
| pdrp_optout__v | varchar(20) | null | pdrp_optout__v | null | null | pdrp_optout__v |
| pdrp_optout_date__v | date | null | pdrp_optout_date__v | null | null | pdrp_optout_date__v |
| percent_medicaid__v | varchar(100) | percent_medicaid__v | null | null | percent_medicaid__v | null |
| percent_medicare__v | varchar(100) | percent_medicare__v | null | null | percent_medicare__v | null |
| place_of_employment__v | varchar(100) | null | place_of_employment__v | null | null | place_of_employment__v |
| prefix__v | varchar(25) | null | prefix__v | null | null | prefix__v |
| record_state__v | varchar(20) | record_state__v | record_state__v | null | record_state__v | record_state__v |
| roster_date__v | date | roster_date__v | null | null | roster_date__v | null |
| sha_id__v | varchar(10) | sha_id__v | sha_id__v | null | sha_id__v | sha_id__v |
| specialty_1_referencetype__v | varchar(10) | Specialty | Specialty | null | Specialty | Specialty |
| specialty_2__v | varchar(100) | specialty_2__v | specialty_2__v | null | specialty_2__v | specialty_2__v |
| specialty_2_referencetype__v | varchar(10) | Specialty | Specialty | null | Specialty | Specialty |
| specialty_3__v | varchar(100) | specialty_3__v | specialty_3__v | null | specialty_3__v | specialty_3__v |
| specialty_3_referencetype__v | varchar(10) | Specialty | Specialty | null | Specialty | Specialty |
| status_update_time__v | varchar(100) | status_update_time__v | status_update_time__v | null | status_update_time__v | status_update_time__v |
| suffix__v | varchar(25) | null | suffix__v | null | null | suffix__v |
| total_revenue__v | numeric(15) | total_revenue__v | null | null | total_revenue__v | null |
| total_revenue_currency__v | varchar(100) | total_revenue_currency__v | null | null | total_revenue_currency__v | null |
| training_facility__v | varchar(20) | training_facility__v | null | null | training_facility__v | null |
| type_of_practice__v | varchar(100) | null | type_of_practice__v | null | null | type_of_practice__v |
| upin__v | varchar(10) | null | upin__v | null | null | upin__v |
| URL_1__v | varchar(5000) | URL_1__v | URL_1__v | null | URL_1__v | URL_1__v |
| URL_2__v | varchar(5000) | URL_2__v | URL_2__v | null | URL_2__v | URL_2__v |
| va_dod_affiliated__v | varchar(20) | va_dod_affiliated__v | null | null | va_dod_affiliated__v | null |
| alternate_customer_id__v | varchar(100) | null | null | null | null | null |
| xray_services__v | varchar(20) | xray_services__v | null | null | xray_services__v | null |
| years_in_progress__v | numeric(2) | null | years_in_progress__v | null | null | years_in_progress__v |
| start_date__v | timestamp | null | null | start_date__v | start_date__v | start_date__v |
| end_date__v | timestamp | null | null | end_date__v | end_date__v | end_date__v |
| lastmodifieddate__v | timestamp | modified_date__v | modified_date__v | lastmodifieddate__v | modified_date__v | modified_date__v |
