Notes

create view cdp_actln_dwh.VW_Patient_Valchlor_CAP_Avella as select * from cdp_actln_dwh.TBL_Patient_Valchlor_CAP_Avella
with no schema binding;
DROP TABLE cdp_actln_dwh.TBL_Patient_Valchlor_CAP_Avella;
CREATE TABLE cdp_actln_dwh.TBL_Patient_Valchlor_CAP_Avella (
Data_Capture_Week_End_Date DATE
,Product VARCHAR(8) NOT NULL
,SP_Name VARCHAR(6) NOT NULL
,Patient_ID VARCHAR(50)
,Age VARCHAR(50)
,Age_Group VARCHAR(25)
,GENDER VARCHAR(50)
,Patient_Status VARCHAR(50)
,Patient_Status_Outcome VARCHAR(50)
,Patient_Status_Outcome_Description VARCHAR(100)
,PT_Paying_Status_Calc VARCHAR(1) NOT NULL
,Status_Change_Date DATE
,Referral_Date DATE
,Referral_Ranking BIGINT
,Referral_WeekEnd_Date DATE
,Referral_Year_Month VARCHAR(7)
,Payer_Type VARCHAR(50)
,Plan_Name VARCHAR(50)
,PA_Required VARCHAR(50)
,TOKEN VARCHAR(50)
,Conversion_Days INT
,Conversion_Period VARCHAR(10)
,Exposure_Date DATE
,Managing_HCP_Actelion_ID INT
,Managing_HCP_First_Name VARCHAR(50) NOT NULL
,Managing_HCP_Last_Name VARCHAR(50) NOT NULL
,Managing_HCP_Specialty VARCHAR(50)
,Managing_HCP_Specialty_Secondary VARCHAR(50)
,Managing_HCP_Aspire_Sales_Restricted VARCHAR(1)
,Managing_HCP_Flag_PDRP VARCHAR(1)
,Managing_HCP_Address VARCHAR(100) NOT NULL
,Managing_HCP_City VARCHAR(50) NOT NULL
,Managing_HCP_State VARCHAR(50) NOT NULL
,Managing_HCP_ZipCode VARCHAR(50) NOT NULL
,Managing_HCP_Territory_ID CHAR(25)
,Managing_Account NVARCHAR(255)
,Managing_Veeva_ID NVARCHAR(18)
,Managing_HCO_Tier NVARCHAR(255)
,Managing_HCP_Tier NVARCHAR(255)
,Enrolling_HCP_Actelion_ID INT
,Enrolling_HCP_First_Name VARCHAR(50)
,Enrolling_HCP_Last_Name VARCHAR(50)
,Enrolling_HCP_Specialty VARCHAR(50)
,Enrolling_HCP_Specialty_Secondary VARCHAR(50)
,Enrolling_HCP_PDRP_Flag VARCHAR(1)
,Enrolling_HCP_Aspire_Sales_Restricted VARCHAR(1)
,Enrolling_HCP_Address VARCHAR(100) NOT NULL
,Enrolling_HCP_City VARCHAR(50) NOT NULL
,Enrolling_HCP_State VARCHAR(50) NOT NULL
,Enrolling_HCP_ZipCode VARCHAR(50) NOT NULL
,Enrolling_HCP_Territory_ID CHAR(25) NOT NULL
,PRIOR_THERAPY_CODE VARCHAR(1) NOT NULL
,PRIOR_THERAPY VARCHAR(1) NOT NULL
,Enrolling_Account NVARCHAR(255)
,Enrolling_Veeva_ID NVARCHAR(18)
,Enrolling_HCO_Tier NVARCHAR(255)
,Enrolling_HCP_Tier NVARCHAR(255)
);