Notes

create table cdp_actln_dwh.TBL_V_VEEVA_TM_RSM_Flag(
ACTELION_ID int,
TM_RSM_Flag nvarchar(10)
);

create view cdp_actln_dwh.V_VEEVA_TM_RSM_Flag as select * from cdp_actln_dwh.TBL_V_VEEVA_TM_RSM_Flag;


CREATE TABLE cdp_actln_dwh.TBL_Shipment_Valchlor_CAP (
Data_Capture_Week_End_Date DATE
,Report_Period_Start_Date DATE
,Patient_ID VARCHAR(50)
,Gender VARCHAR(50)
,Year_of_Birth VARCHAR(50)
,Physician_First_Name VARCHAR(50)
,Physician_Middle_Initial VARCHAR(50)
,Physician_Last_Name VARCHAR(50)
,Physician_Address_1 VARCHAR(100)
,Physician_Address_2 VARCHAR(100)
,Physician_City VARCHAR(50)
,Physician_State VARCHAR(50)
,Physician_Zip VARCHAR(50)
,Primary_Payer_Name VARCHAR(50)
,Insurance_Type VARCHAR(100)
,Ship_Date DATE
,NDC_Number varchar(50)
,Drug_Name VARCHAR(50)
,Quantity_Shipped FLOAT
,Days_Supply FLOAT
,New_Or_Refill VARCHAR(50)
,Prescription_Number VARCHAR(50)
,Deductible FLOAT
,Primary_Copay_Amount FLOAT
,Copay_Type VARCHAR(2)
,Co_Insurance_Percentage VARCHAR(20)
,Primary_ICD9_Code VARCHAR(50)
,PA_Required VARCHAR(50)
,BIN_NUMBER VARCHAR(50)
,PCN_NUMBER VARCHAR(50)
,SHIPMENT_ID VARCHAR(50)
,REFILLS_REMAINING FLOAT
,REFILLS_AUTHORIZED FLOAT
,PRESCRIBER_ID VARCHAR(50)
,TOKEN VARCHAR(50)
,ACTELION_ID INT
,FLAG_PDRP VARCHAR(1)
,ASPIRE_SALES_RESTRICTED VARCHAR(1)
,Prism_FirstName VARCHAR(50)
,Prism_LastName VARCHAR(50)
,Account NVARCHAR(255)
,HCO_Veeva_ID NVARCHAR(18)
,HCO_Tier NVARCHAR(255)
,HCP_Tier NVARCHAR(255)
,Payer_Type VARCHAR(10) NOT NULL
,Territory_ID CHAR(25) NOT NULL
,Territory VARCHAR(50) NOT NULL
,Region_ID CHAR(25) NOT NULL
,Region VARCHAR(50) NOT NULL
,Exposure_Flag VARCHAR(1)
,Shipment_Year_Month VARCHAR(7)
,SP_Name VARCHAR(50)
);


create view cdp_actln_dwh.VW_Shipment_Valchlor_CAP as select * from cdp_actln_dwh.TBL_Shipment_Valchlor_CAP with no schema binding;