Spaces:
Runtime error
Runtime error
File size: 4,022 Bytes
5ee80e4 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 |
CREATE TABLE ped_stg_usa.us_kol_engagement (
activity_name_eng varchar(256),
activity_type_eng varchar(256),
partnering_department_eng varchar(256),
year_eng float8,
quarter_eng varchar(256),
cat1_eng integer,
cat2_eng integer,
cat3_eng integer,
cat1_sum_eng float8,
cat2_sum_eng float8,
cat3_sum_eng float8,
segment_eng varchar(256),
hospital_eng varchar(256),
region_eng varchar(256),
area_eng varchar(256),
engagement_score_eng float8,
rank_eng float8,
phy_name_eng varchar(256)
);
CREATE TABLE ped_stg_usa.us_kol_overall_scoring (
phy_name_us varchar(256),
hospital_us varchar(256),
city_us varchar(256),
state_us varchar(256),
us_area_us varchar(256),
position_us varchar(256),
segment_us varchar(256),
email_us varchar(256),
fellowship_us varchar(256),
graduation_us varchar(256),
emerging_us varchar(256),
twitter_us varchar(256),
eng_score_pct_us float8,
sfdc_ytd_score_pct_us float8,
sfdc_l4q_score_pct_us float8,
pod_score_pct_us float8,
soc_score_pct_us float8,
pub_score_pct_us float8,
ct_score_pct_us float8,
influence_score_pct_us float8,
partnership_score_pct_us float8,
overall_score_pct_us float8
);
CREATE TABLE ped_stg_usa.us_kol_open_payments ( record_id_op varchar(256),
phy_name_op varchar(256),
date_of_payment_op date,
total_amount_of_payment_usdollars_op float country_of_travel_op varchar(256),
state_of_travel_op varchar(256) ,
city_of_travel_op varchar(256),
nature_of_payment_or_transfer_of_value_op varchar(256) ,
applicable_manufacturer_or_applicable_gpo_making_payment_country_op varchar(256) ,
applicable_manufacturer_or_applicable_gpo_making_payment_state_op varchar(256) ,
sender_organization_op varchar(256) );
CREATE TABLE ped_stg_usa.us_kol_procedures
(
sfdccallid varchar(256),
actualstartdate timestamp,
casetype varchar(256),
casesubtype varchar(256),
us_physician_names varchar(256),
sfdc_names varchar(256),
all_prod_names varchar(1000),
city varchar(256),
state varchar(256),
hospital varchar(256),
segment varchar(256),
global_region varchar(256),
us_area varchar(256),
last varchar(256),
first varchar(256),
last_4_qr integer,
emerging varchar(256),
curr_yr_flag integer,
prev_yr_flag integer,
rolling_12_mo integer,
psaf integer,
paf integer,
afib integer,
vt integer,
cartoprime integer,
smarttouch_sf integer,
soundstar integer,
pentaray integer,
surpoint integer,
vizigo integer,
qdot integer,
octaray integer,
nuvision integer,
optrell integer,
da_group varchar(256),
af_complex_svt integer,
oce integer,
oce_2 integer,
oce_3 integer,
oce_4 integer,
af_oce integer,
af_oce_2 integer,
af_oce_3 integer,
vt_oce_1 integer,
vt_oce_2 integer,
af_cartoprime integer,
af_pentaray integer,
af_stsf integer,
af_soundstar integer,
af_surpoint integer,
af_vizigo integer,
af_csvt_cartoprime integer,
vt_cartoprime integer,
vt_pentaray integer,
vt_stsf integer,
vt_soundstar integer,
vt_surpoint integer,
vt_vizigo integer,
af_curr_yr integer,
af_prev_yr integer,
vt_curr_yr integer,
vt_prev_yr integer,
af_roll_12 integer,
vt_roll_12 integer,
ytd_score float8,
last_4_qr_score float8,
phy_name varchar(256),
sfdc_refresh_date varchar(256)
);
|