Epocrates Data Model
The following table displays data model information used when loading Epocrates 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 |
|---|---|---|---|---|---|---|
| EPOC_CONTROL_*.txt | epoc_mci_control__v | pt_ftp_stg_standardload__v | pt_ftp_ods_upsertload__v | file_name__v | n/a | n/a |
| EPOC_RESPONSE_*.txt | epoc_mci__v | pt_ftp_stg_standardload__v | pt_ftp_ods_rollingpartitionload__v | n/a | campaign_id__v | status_date__v |
The following table displays field information for each Nitro Table listed above.
| Nitro Table | epoc_mci__v | epoc_mci_control__v |
|---|---|---|
|
Nitro Table Fields |
user_account_key__v | file_name__v |
| account_address_key__v | file_date__v | |
| vendor_code__v | record_count__v | |
| client_code__v | ||
| program_code__v | ||
| program_id__v | ||
| program_start_date__v | ||
| program_end_date__v | ||
| first_name__v | ||
| last_name__v | ||
| occupation__v | ||
| specialty__v | ||
| address1__v | ||
| address2__v | ||
| address3__v | ||
| city__v | ||
| state__v | ||
| country__v | ||
| zip__v | ||
| me_number__v | ||
| npi__v | ||
| status_code__v | ||
| status_date__v | ||
| campaign_id__v | ||
| wave_id__v | ||
| tactic_id__v | ||
| product_id__v | ||
| customer_id__v | ||
| media_consumed__v | ||
| media_length__v |
