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 | Description | Source Data Connector: Network _FTPTable: network_hco_ods__v | Source DataConnector: Network _FTPTable: network_hcp_ods__v | Source DataConnector: Vault CRM Table: account_ods__v | Source Data Connector: Network ISTable: network_hco_ods__v | Source DataConnector: Network ISTable: network_hcp_ods__v |
|---|---|---|---|---|---|---|---|
| composite_key__v | varchar(100) | Unique ID for record | |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|account_ods__v.vault_crm_id__v|start_date__v|end_date__v| | |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) | Unique ID for source system (eg. CRM Org 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) | Extracted from Internal Admin Console (Source ID) |
| native_id__v | varchar(18) | Native ID in source data | vid__v | vid__v | account_ods__v.vault_account_id__v | vid__v | vid__v |
| source_connector_name__v | varchar(100) | Name of connector where record is brought into Nitro | 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) | Name of table in source connecter where this record resides | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS | Extracted from MDS |
| account_name__v | varchar(300) | Formatted name of business demographic record | null | corporate_name__v | account_name__v | null | corporate_name__v |
| account_country__v | varchar(200) | Country according to CRM and/or Network account records | primary_country__v | primary_country__v | country_ods__v.country_name__v | primary_country__v | primary_country__v |
| address_country__v | varchar(765) | Country according to CRM and/or Network primary account/address records | network_address_ods__v.country__v | network_address_ods__v.country__v | address_ods__v.country__v | network_address_ods__v.country__v | network_address_ods__v.country__v |
| address_line_1__v | varchar(240) | Address line 1 of CRM and/or Network primary account/address records | network_address_ods__v.address_line_1__v | network_address_ods__v.address_line_1__v | address_ods__v.street_address_1_cda__v | network_address_ods__v.address_line_1__v | network_address_ods__v.address_line_1__v |
| address_line_2__v | varchar(300) | Address line 2 of CRM and/or Network primary account/address records | network_address_ods__v.address_line_2__v | network_address_ods__v.address_line_2__v | address_ods__v.street_address_2_cda__v | network_address_ods__v.address_line_2__v | network_address_ods__v.address_line_2__v |
| locality__v | varchar(150) | City of CRM and/or Network primary account/address records | network_address_ods__v.locality__v | network_address_ods__v.locality__v | address_ods__v.city_cda__v | network_address_ods__v.locality__v | network_address_ods__v.locality__v |
| first_name__v | varchar(200) | First name of person accounts | first_name__v | null | first_name_cda__v | first_name__v | null |
| last_name__v | varchar(240) | Last name of person accounts | last_name__v | null | last_name_cda__v | last_name__v | null |
| specialty_1__v | varchar(765) | Specialty 1 field for both person and business accounts | specialty_1__v | specialty_1__v | specialty_1__v | specialty_1__v | specialty_1__v |
| credentials__v | varchar(765) | Credentials 1 from person account records in CRM/Network HCP tables | null | credentials_1__v | credentials__v | null | credentials_1__v |
| email__v | varchar(240) | Email address for account | email_1__v | null | email_cda__v | email_1__v | null |
| npi__v | varchar(75) | Nation provider identification number (10 digits) | npi_num__v | null | npi__v | npi_num__v | null |
| phone__v | varchar(120) | Phone number from CRM and/or Network primary account/address records | network_address_ods__v.phone_1__v | network_address_ods__v.phone_1__v | address_ods__v.phone_cda__v | network_address_ods__v.phone_1__v | network_address_ods__v.phone_1__v |
| postal_code__v | varchar(60) | Postal Code from CRM and/or Network primary account/address records | network_address_ods__v.postal_code__v | network_address_ods__v.postal_code__v | address_ods__v.postal_code_cda__v | network_address_ods__v.postal_code__v | network_address_ods__v.postal_code__v |
| administrative_area__v | varchar(765) | State from CRM and/or Network primary account/address records | network_address_ods__v.administrative_area__v | network_address_ods__v.administrative_area__v | address_ods__v.state_province__v | network_address_ods__v.administrative_area__v | network_address_ods__v.administrative_area__v |
| vid__v | varchar(765) | Veeva Identifier | vid__v | vid__v | veevaid__v | vid__v | vid__v |
| ispersonaccount__v | boolean | Identifies if the record is a person or a business | "True" | "False" | ispersonaccount__v | "True" | "False" |
| accept_medicaid__v | varchar(20) | Does the business account accept medicaid? | accept_medicaid__v | null | null | accept_medicaid__v | null |
| accept_medicare__v | varchar(20) | Does the business account accept medicare? | accept_medicare__v | null | null | accept_medicare__v | null |
| ama_do_not_contact__v | varchar(20) | American Medical Association do not contact flag | ama_do_not_contact__v | ama_do_not_contact__v | null | ama_do_not_contact__v | ama_do_not_contact__v |
| ams_id__v | varchar(10) | AMD ID | ams_id__v | ams_id__v | null | ams_id__v | ams_id__v |
| aoa_id__v | varchar(10) | AOA ID | null | aoa_id__v | null | null | aoa_id__v |
| birth_city__v | varchar(200) | HCP birth city | null | birth_city__v | null | null | birth_city__v |
| birth_country__v | varchar(100) | HCP birth country | null | birth_country__v | null | null | birth_country__v |
| birth_state__v | varchar(10) | HCP birth state | null | birth_state__v | null | null | birth_state__v |
| birth_year__v | varchar(10) | HCP birth year | null | birth_year__v | year_of_birth_cda__v | null | birth_year__v |
| board_certification__v | varchar(100) | Board certification of an HCP | null | board_certification__v | null | null | board_certification__v |
| candidate_record__v | varchar(10) | Is this record loaded as a candidate for data steward validation | candidate_record__v | candidate_record__v | null | candidate_record__v | candidate_record__v |
| clia_effective_date__v | date | Clinical Laboratory Improvement Amendments Effective Date | clia_effective_date__v | null | null | clia_effective_date__v | null |
| clia_exception_date__v | date | Clinical Laboratory Improvement Amendments Exception Date | clia_exception_date__v | null | null | clia_exception_date__v | null |
| clia_lab_num__v | varchar(10) | Clinical Laboratory Improvement Amendments Number | clia_lab_num__v | null | null | clia_lab_num__v | null |
| clia_status__v | varchar(10) | Clinical Laboratory Improvement Amendments Status | clia_status__v | null | null | clia_status__v | null |
| corporate_name__v | varchar(300) | Official name of HCO | corporate_name__v | null | null | corporate_name__v | null |
| count_all_locn_md_do__v | numeric(6) | Number of MDs and DOs at all locations | count_all_locn_md_do__v | null | null | count_all_locn_md_do__v | null |
| count_all_locn_medstaff__v | numeric(6) | How many medical staff are there at all locations | count_all_locn_medstaff__v | null | null | count_all_locn_medstaff__v | null |
| count_all_locn_non_md_do__v | numeric(6) | Number of staff that are not MDs or DOs at all locations | count_all_locn_non_md_do__v | null | null | count_all_locn_non_md_do__v | null |
| count_beds__v | numeric(6) | Number of beds in HCO | count_beds__v | null | null | count_beds__v | null |
| count_inpatients__v | numeric(9) | Number of inpatients per year | count_inpatients__v | null | null | count_inpatients__v | null |
| count_md_do__v | numeric(6) | Number of MDs and DOs | count_md_do__v | null | null | count_md_do__v | null |
| count_medstaff__v | numeric(6) | Number of medical staff at HCO | count_medstaff__v | null | null | count_medstaff__v | null |
| count_non_md_do__v | numeric(6) | Number of staff that are not MDs or DOs | count_non_md_do__v | null | null | count_non_md_do__v | null |
| count_outpatients__v | numeric(9) | Number of outpatients per year | count_outpatients__v | null | null | count_outpatients__v | null |
| credentials_1_referencetype__v | varchar(15) | Value to filter reference table upon when looking for definition of credentials | null | HCPCredentials | null | null | HCPCredentials |
| credentials_2__v | varchar(100) | Credentials of HCP | null | credentials_2__v | null | null | credentials_2__v |
| credentials_2_referencetype__v | varchar(15) | Value to filter reference table upon when looking for definition of credentials | null | HCPCredentials | null | null | HCPCredentials |
| cri_id__v | varchar(10) | Massachusetts Covered Recipient Identifier (CRI) number | cri_id__v | cri_id__v | null | cri_id__v | cri_id__v |
| education_level__v | varchar(100) | Level of education achieved by an HCP | null | education_level__v | null | null | education_level__v |
| email_2__v | varchar(100) | Secondary email address | email_2__v | email_2__v | null | email_2__v | email_2__v |
| fellow__v | varchar(20) | Is this HCP a Fellow | null | fellow__v | null | null | fellow__v |
| formatted_name__v | varchar(200) | Calculated field used to display HCP name on profile page. Empty fields are populated with default concatenation rule of first_name__v + last_name__v unless country specific rules exist. | null | formatted_name__v | formatted_name__v | null | formatted_name__v |
| gender__v | varchar(5) | Gender of HCP | null | gender__v | gender__v | null | gender__v |
| gln_id__v | varchar(10) | Global Location Number. Unique ID for delivery address. | gln_id__v | null | null | gln_id__v | null |
| grad_school__v | varchar(200) | Name of graduation school | null | grad_school__v | null | null | grad_school__v |
| grad_training__v | varchar(20) | Graduate Training Confirmation flag | null | grad_training__v | null | null | grad_training__v |
| grad_trg_end_date__v | date | Grad Training End Date | null | grad_trg_end_date__v | null | null | grad_trg_end_date__v |
| grad_trg_start_date__v | date | Grad Training Start Date | null | grad_trg_start_date__v | null | null | grad_trg_start_date__v |
| grad_year__v | varchar(4) | Year HCP graduated from medical school | null | grad_year__v | null | null | grad_year__v |
| account_status__v | varchar(255) | Status of Account | hco_status__v | hcp_status__v | null | hco_status__v | hcp_status__v |
| hco_tax_id__v | varchar(20) | Tax Number | hco_tax_id__v | null | null | hco_tax_id__v | null |
| hco_type__v | varchar(100) | Type of HCO | hco_type__v | null | hco_type_cda__v | hco_type__v | null |
| hcp_type__v | varchar(30) | Type of HCP | null | hcp_type__v | hcp_type_cda__v | null | hcp_type__v |
| hin__v | varchar(10) | Health Industry Number | hin__v | null | null | hin__v | null |
| kaiser__v | varchar(20) | This flag indicates that at least one related HCO is a Kaiser Permanente organization. | kaiser__v | kaiser__v | null | kaiser__v | kaiser__v |
| knipper_id__v | varchar(10) | Knipper ID for HCP | null | knipper_id__v | null | null | knipper_id__v |
| lab_services__v | varchar(20) | Does this HCO offer lab services | lab_services__v | null | null | lab_services__v | null |
| major_class_of_trade__v | varchar(30) | Major Class of Trade for the HCO, the main type of HCO | major_class_of_trade__v | null | null | major_class_of_trade__v | null |
| me_id__v | varchar(10) | Medical Education (ME) number | null | me_id__v | null | null | me_id__v |
| medical_degree_1__v | varchar(100) | First medical degree of HCP | null | medical_degree_1__v | null | null | medical_degree_1__v |
| medical_degree_2__v | varchar(100) | Second medical degree of HCP | null | medical_degree_2__v | null | null | medical_degree_2__v |
| middle_name__v | varchar(200) | Middle name of HCP | null | middle_name__v | middle_name_cda__v | null | middle_name__v |
| mpa__v | varchar(100) | Major Professional Activity of HCP | null | mpa__v | null | null | mpa__v |
| ncpdp_num__v | varchar(10) | National Council for Prescription Drug Programs Number | ncpdp_num__v | null | null | ncpdp_num__v | null |
| pdrp_optout__v | varchar(20) | Flag to indicate if HCP has opted out via the PDRP | null | pdrp_optout__v | pdrp_opt_out__v | null | pdrp_optout__v |
| pdrp_optout_date__v | date | Date HCP requested to opt out via the PDRP | null | pdrp_optout_date__v | pdrp_opt_out_date__v | null | pdrp_optout_date__v |
| percent_medicaid__v | varchar(100) | Code representing the percentage of Medicaid patients in the practice. | percent_medicaid__v | null | null | percent_medicaid__v | null |
| percent_medicare__v | varchar(100) | Code representing the percentage of Medicare patients in the practice. | percent_medicare__v | null | null | percent_medicare__v | null |
| place_of_employment__v | varchar(100) | Place of employment | null | place_of_employment__v | null | null | place_of_employment__v |
| prefix__v | varchar(25) | Prefix or Honorific Title of HCP | null | prefix__v | prefix_cda__v | null | prefix__v |
| record_state__v | varchar(20) | Internal record state | record_state__v | record_state__v | null | record_state__v | record_state__v |
| roster_date__v | date | Date roster of HCO staff was received | roster_date__v | null | null | roster_date__v | null |
| sha_id__v | varchar(10) | SHA ID | sha_id__v | sha_id__v | null | sha_id__v | sha_id__v |
| specialty_1_referencetype__v | varchar(10) | Value to filter reference table upon when looking for definition of specialty code | Specialty | Specialty | null | Specialty | Specialty |
| specialty_2__v | varchar(100) | Secondary specialty | specialty_2__v | specialty_2__v | null | specialty_2__v | specialty_2__v |
| specialty_2_referencetype__v | varchar(10) | Value to filter reference table upon when looking for definition of specialty code | Specialty | Specialty | null | Specialty | Specialty |
| specialty_3__v | varchar(100) | Tertiary specialty | specialty_3__v | specialty_3__v | null | specialty_3__v | specialty_3__v |
| specialty_3_referencetype__v | varchar(10) | Value to filter reference table upon when looking for definition of specialty code | Specialty | Specialty | null | Specialty | Specialty |
| status_update_time__v | varchar(100) | Date the status of this record was last modified | status_update_time__v | status_update_time__v | null | status_update_time__v | status_update_time__v |
| suffix__v | varchar(25) | Suffix | null | suffix__v | suffix_cda__v | null | suffix__v |
| total_revenue__v | numeric(15) | Total annual revenue for the HCO | total_revenue__v | null | null | total_revenue__v | null |
| total_revenue_currency__v | varchar(100) | Currency of the HCOs total revenue | total_revenue_currency__v | null | null | total_revenue_currency__v | null |
| training_facility__v | varchar(20) | Flag to indicate if this HCO is a training facility | training_facility__v | null | null | training_facility__v | null |
| type_of_practice__v | varchar(100) | Type of practice for HCP | null | type_of_practice__v | null | null | type_of_practice__v |
| upin__v | varchar(10) | Unique Physician ID number (UPIN) for HCP | null | upin__v | null | null | upin__v |
| URL_1__v | varchar(5000) | Primary URL | URL_1__v | URL_1__v | website_cda__v | URL_1__v | URL_1__v |
| URL_2__v | varchar(5000) | Secondary URL | URL_2__v | URL_2__v | null | URL_2__v | URL_2__v |
| va_dod_affiliated__v | varchar(20) | Flag that indicates if an HCO is associated to the Department of Defense (DOD)/Veterans Affairs (VA) | va_dod_affiliated__v | null | null | va_dod_affiliated__v | null |
| alternate_customer_id__v | varchar(100) | Blank field to allow for mapping of custom ID on account records | null | null | null | null | null |
| xray_services__v | varchar(20) | Does this HCO offer xray services | xray_services__v | null | null | xray_services__v | null |
| years_in_progress__v | numeric(2) | Number of years in grad training program | null | years_in_progress__v | null | null | years_in_progress__v |
| start_date__v | timestamp | Record start date/time | null | null | start_date__v | start_date__v | start_date__v |
| end_date__v | timestamp | Record end date/time | null | null | end_date__v | end_date__v | end_date__v |
| lastmodifieddate__v | timestamp | Record last modified date | modified_date__v | modified_date__v | modified_date__v | modified_date__v | modified_date__v |
| first_name_cda__v | varchar(4500) | null | null | null | first_name_cda__v | null | null |
| middle_name_cda__v | varchar(150) | null | null | null | middle_name_cda__v | null | null |
| last_name_cda__v | varchar(240) | null | null | null | last_name_cda__v | null | null |
| prefix_cda__v | varchar(60) | null | null | null | prefix_cda__v | null | null |
| suffix_cda__v | varchar(30) | null | null | null | suffix_cda__v | null | null |
| street_address_1_cda__v | varchar(500) | null | null | null | address_ods__v.street_address_1_cda__v | null | null |
| street_address_2_cda__v | varchar(500) | null | null | null | address_ods__v.street_address_2_cda__v | null | null |
| email_cda__v | varchar(384) | null | null | null | email_cda__v | null | null |
| phone_cda__v | varchar(120) | null | null | null | address_ods__v.phone_cda__v | null | null |
| address_postal_code_cda__v | varchar(60) | null | null | null | address_ods__v.postal_code_cda__v | null | null |
| year_of_birth_cda__v | decimal | null | null | null | year_of_birth_cda__v | null | null |
| adopter_type_cda__v | varchar(1280) | null | null | null | adopter_type_cda__v | null | null |
| age_range_cda__v | varchar(1280) | null | null | null | age_range_cda__v | null | null |
| all_degree_cda__v | varchar(1280) | null | null | null | all_degree_cda__v | null | null |
| all_spec_cda__v | varchar(1280) | null | null | null | all_spec_cda__v | null | null |
| all_spec_group_cda__v | varchar(1280) | null | null | null | all_spec_group_cda__v | null | null |
| city_cda__v | varchar(120) | null | null | null | city_cda__v | null | null |
| clin_researcher_cda__v | varchar(1280) | null | null | null | clin_researcher_cda__v | null | null |
| degree_1_cda__v | varchar(1280) | null | null | null | degree_1_cda__v | null | null |
| fax_cda__v | varchar(120) | null | null | null | fax_cda__v | null | null |
| hco_name_cda__v | varchar(384) | null | null | null | hco_name_cda__v | null | null |
| hco_type_cda__v | varchar(1280) | null | null | null | hco_type_cda__v | null | null |
| hcp_type_cda__v | varchar(1280) | null | null | null | hcp_type_cda__v | null | null |
| investigator_cda__v | boolean | null | null | null | investigator_cda__v | null | null |
| kol_cda__v | boolean | null | null | null | kol_cda__v | null | null |
| level_cda__v | varchar(1280) | null | null | null | level_cda__v | null | null |
| veevaid__v | varchar(75) | null | null | null | veevaid__v | null | null |
| mobile_phone_cda__v | varchar(120) | null | null | null | mobile_phone_cda__v | null | null |
| nhid_cda__v | varchar(120) | null | null | null | nhid_cda__v | null | null |
| office_phone_cda__v | varchar(120) | null | null | null | office_phone_cda__v | null | null |
| postal_code_cda__v | varchar(60) | null | null | null | postal_code_cda__v | null | null |
| prescriber_cda__v | boolean | null | null | null | prescriber_cda__v | null | null |
| speaker_cda__v | boolean | null | null | null | speaker_cda__v | null | null |
| spec_1_cda__v | varchar(1280) | null | null | null | spec_1_cda__v | null | null |
| spec_group_1_cda__v | varchar(1280) | null | null | null | spec_group_1_cda__v | null | null |
| status_cda__v | varchar(1280) | null | null | null | status_cda__v | null | null |
| study_site_cda__v | boolean | null | null | null | study_site_cda__v | null | null |
| target_cda__v | boolean | null | null | null | target_cda__v | null | null |
| website_cda__v | varchar(765) | null | null | null | website_cda__v | null | null |
| billing_cda__v | boolean | null | null | null | address_ods__v.billing_cda__v | null | null |
| business_cda__v | boolean | null | null | null | address_ods__v.business_cda__v | null | null |
| home_cda__v | boolean | null | null | null | address_ods__v.home_cda__v | null | null |
| latitude_cda__v | decimal | null | null | null | address_ods__v.latitude_cda__v | null | null |
| longitude_cda__v | decimal | null | null | null | address_ods__v.longitude_cda__v | null | null |
| primary_cda__v | boolean | null | null | null | address_ods__v.primary_cda__v | null | null |
| sample_shipping_cda__v | boolean | null | null | null | address_ods__v.sample_shipping_cda__v | null | null |
| shipping_cda__v | boolean | null | null | null | address_ods__v.shipping_cda__v | null | null |
| address_status_cda__v | varchar(1280) | null | null | null | address_ods__v.status_cda__v | null | null |
