Demographic
Global dimensional table for Demographic sourced from global demographic table (dim_demographic_gbl_DDS__v).
| 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 |
