Demographic

Global dimensional table for Demographic sourced from global demographic table.

Global DDS Field Field Type

Source Data

Connector: Global

Table: demographic_gbl_ods__v

dim_global_demographic_id__v bigint n/a
account_name__v varchar(300) account_name__v
account_country__v varchar(200) account_country__v
address_country__v varchar(765) address_country__v
address_line_1__v varchar(240) address_line_1__v
address_line_2__v varchar(300) address_line_2__v
locality__v varchar(150) locality__v
first_name__v varchar(200) first_name__v
middle_name__v varchar(200) middle_name__v
last_name__v varchar(240) last_name__v
speciality_1__v varchar(765) speciality_1__v
credentials__v varchar(765) credentials__v
email__v varchar(240) email__v
npi__v varchar(75) npi__v
phone__v varchar(120) phone__v
postal_code__v varchar(60) postal_code__v
administrative_area__v varchar(60) administrative_area__v
vid__v varchar(765) vid__v
ispersonaccount__v boolean ispersonaccount__v
formatted_name__v varchar(500) formatted_name__v
gender__v varchar(100) gender__v
account_status__v varchar(100) account_status__v
hco_type__v varchar(100) hco_type__v
hcp_type__v varchar(100) hcp_type__v
hin__v varchar(10) hin__v
me_id__v varchar(10) me_id__v
pdrp_optout__v varchar(100) pdrp_optout__v
pdrp_optout_date__v date pdrp_optout_date__v
sha_id__v varchar(10) sha_id__v
alternate_customer_id__v varchar(100) alternate_customer_id__v
start_date__v timestamp start_date__v
end_date__v timestamp end_date__v
lastmodifieddate__v timestamp lastmodifieddate__v