Doximity Data Model
The following table displays data model information used when loading Doximity digital marketing data files into Nitro's Staging Layer.
Raw File Name | Nitro Table | STG Load Pattern | ODS Load Pattern | Primary Key | Partition Key | Rolling Date Key |
---|---|---|---|---|---|---|
doximity_*_control.txt | dox_mci_control__v | pt_ftp_stg_standardload__v | pt_ftp_ods_upsertload__v | file_name__v | n/a | n/a |
doximity_*.txt | dox_mci__v | pt_ftp_stg_standardload__v | pt_ftp_ods_rollingpartitionload__v | n/a | campaign_id__v | activity_date__v |
Fields contained in each table are listed here:
- dox_mci_control__v
- file_name__v
- record_count__v
- file_date__v
- dox_mci__v
- program__v
- campaign_id__v
- user_id__v
- party_id__v
- wave_id__v
- tactic_id__v
- product_id__v
- segmentation__v
- first_name__v
- last_name__v
- city__v
- state__v
- zip__v
- specialty__v
- npi__v
- activity__v
- activity_date__v
- url__v
- client_match__v
- media_consumed__v
- media_length__v