Spaces:
Runtime error
Runtime error
| 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) | |
| ); | |