CREATE TABLE SecList_ComputedData(
                                      SLC_Symbol Varchar(15)  NOT NULL,
                                      SLC_LatestPriceDate datetime Null,
                                      SLC_LatestPrice real Null,
                                      SLC_DivIntRate real Null,
                                      SLC_ROCrate real Null,
                                      SLC_LastDivDate datetime Null,
                                      SLC_LastDivRate real Null,
                                      SLC_YieldPercent real Null,
                                      SLC_AnnualHigh real Null,
                                      SLC_AnnualLow real Null,
                                      SLC_A4WeekGainP real Null,
                                      SLC_A13WeekGainP real Null,
                                      SLC_A26WeekGainP real Null,
                                      SLC_TwelveMonGainP real Null,
                                      SLC_13WkRelStrgP real Null,
                                      SLC_12MonRelStrgP real Null,
                                      SLC_A4WeekROI real Null,
                                      SLC_A13WeekROI real Null,
                                      SLC_A26WeekROI real Null,
                                      SLC_TwelveMonROI real Null,
                                      SLC_TwoYearROI real Null,
                                      SLC_SharpeRatio real Null,
                                      SLC_Alpha real Null,
                                      SLC_Beta real Null,
                                      SLC_StdDeviation real Null,
                                      SLC_Correlation real Null,
                                      SLC_10dayTurnover real Null,
                                      SLC_3MonAvgTurnover real Null,
                                      SLC_TurnoverRatio real Null,
                                      SLC_TaxEfficiency real Null,
                                      SLC_YieldToCall1P real Null,
                                      SLC_YieldToCall2P real Null,
                                      SLC_YieldToMaturityP real Null,
                                      SLC_YieldToRedemptP real Null,
                                      SLC_AfterTaxYTR real Null,
                                      SLC_DurationToMat real Null,
                                      SLC_DurationToRed real Null,
                                      SLC_BondConvexity float Null,
                                      SLC_NetPresentValue real Null,
                                      SLC_AfterTaxNPV real Null,
                                      SLC_LastEarningsDate datetime Null,
                                      SLC_EarningsPerShare real Null,
                                      SLC_SalesPerShare real Null,
                                      SLC_EBITDAperShr real Null,
                                      SLC_BookValuePerShare real Null,
                                      SLC_CashPerShare real Null,
                                      SLC_FreeCFPerShr real Null,
                                      SLC_CurrentRatio real Null,
                                      SLC_DebtEquity real Null,
                                      SLC_DebtvsMktCap float Null,
                                      SLC_DebtvsRevenue float Null,
                                      SLC_DebtvsEarnings float Null,
                                      SLC_SharesOutstanding real Null,
                                      SLC_InstitPercent real Null,
                                      SLC_InsiderPercent real Null,
                                      SLC_FCEarningsPerShr real Null,
                                      SLC_FCSalesPerShr real Null,
                                      SLC_PriceEarningsRatio Real Null,
                                      SLC_PriceSalesRatio real Null,
                                      SLC_ThreeYrEarnGrowthP real Null,
                                      SLC_ThreeYrSaleGrowthP real Null,
                                      SLC_OneYrEarnGrowthP real Null,
                                      SLC_OneYrSalesGrowthP real Null,
                                      SLC_FCEarningsGrowthP real Null,
                                      SLC_FCSalesGrowthP real Null,
                                      SLC_PriceVsEpriseValue real Null,
                                      SLC_Revenue real Null,
                                      SLC_MarketCap real Null,
				      SLC_DataSource Varchar(4) Null,
                                      SLC_UserDef1 float null,
                                      SLC_UserDef2 float null,
                                      SLC_UserDef3 float null,
                                      SLC_UserDef4 float null,
                                      SLC_UserDef5 float null,
                                      SLC_UserDef6 float null,
                                      SLC_UserDef7 float null,
                                      SLC_UserDef8 float null,
                                      SLC_UserDef9 float null,
                                      SLC_UserDef10 float null,
                                      SLC_ProgCtrlBits integer null default 0,
                                      SLC_TempRecord bit null default 0,
                                      SLC_IsFrozen bit null default 0,
				      SLC_EffectiveMatDate datetime null,
                                      CONSTRAINT PK_SecList_ComputedData PRIMARY KEY CLUSTERED
                                      (SLC_Symbol)
                                      );

ALTER TABLE [dbo].[SecList_ComputedData] ADD
	CONSTRAINT [FK_SecList_ComputedData_SecList_FixedData] FOREIGN KEY
	(
		[SLC_Symbol]
	) REFERENCES [dbo].[SecList_FixedData] (
		[SLF_Symbol]
	) ON DELETE CASCADE  ON UPDATE CASCADE
