TASS ASCII Data Definitions
File Type	ANSI
Delimitation	Comma Delimited except for the Notes table which is Tab Delimited
Row delimiter	{CR}{LF}
Text qualifier	Double Quotes {"}
Column Names:	First row contains column names
TABLE NAME	Column Name	Data Type	Length	Nulls Allowed	Comments
				Y/N
AssetsInstrumentsDetails	ProductReference	int		N	One to One link to ProductDetails Table
AE = Equities	AE_Cash	bit		N	0 = Not checked, 1 = checked
	AE_Convertibles	bit		N	0 = Not checked, 1 = checked
	AE_Equities	bit		N	0 = Not checked, 1 = checked
	AE_ExchangeTraded	bit		N	0 = Not checked, 1 = checked
	AE_IndexFutures	bit		N	0 = Not checked, 1 = checked
	AE_Options	bit		N	0 = Not checked, 1 = checked
	AE_OTC	bit		N	0 = Not checked, 1 = checked
	AE_PrimaryFocus	bit		N	0 = Not checked, 1 = checked
	AE_Warrants	bit		N	0 = Not checked, 1 = checked
AF = Fixed Income	AF_Cash	bit		N	0 = Not checked, 1 = checked
	AF_Convertibles	bit		N	0 = Not checked, 1 = checked
	AF_ExchangeTraded	bit		N	0 = Not checked, 1 = checked
	AF_FixedIncome	bit		N	0 = Not checked, 1 = checked
	AF_Forward	bit		N	0 = Not checked, 1 = checked
	AF_Futures	bit		N	0 = Not checked, 1 = checked
	AF_Options	bit		N	0 = Not checked, 1 = checked
	AF_OTC	bit		N	0 = Not checked, 1 = checked
	AF_PrimaryFocus	bit		N	0 = Not checked, 1 = checked
	AF_Swaps	bit		N	0 = Not checked, 1 = checked
	AF_Warrants	bit		N	0 = Not checked, 1 = checked
AC = Commodities	AC_Agriculturals	bit		N	0 = Not checked, 1 = checked
	AC_BaseMetals	bit		N	0 = Not checked, 1 = checked
	AC_Commodity	bit		N	0 = Not checked, 1 = checked
	AC_Energy	bit		N	0 = Not checked, 1 = checked
	AC_ExchangeTraded	bit		N	0 = Not checked, 1 = checked
	AC_Forwards	bit		N	0 = Not checked, 1 = checked
	AC_Futures	bit		N	0 = Not checked, 1 = checked
	AC_Indices	bit		N	0 = Not checked, 1 = checked
	AC_Metals	bit		N	0 = Not checked, 1 = checked
	AC_Options	bit		N	0 = Not checked, 1 = checked
	AC_OTC	bit		N	0 = Not checked, 1 = checked
	AC_Physical	bit		N	0 = Not checked, 1 = checked
	AC_PreciousMetals	bit		N	0 = Not checked, 1 = checked
	AC_PrimaryFocus	bit		N	0 = Not checked, 1 = checked
	AC_Softs	bit		N	0 = Not checked, 1 = checked
ACUR = Currencies	ACUR_Currency	bit		N	0 = Not checked, 1 = checked
	ACUR_ExchangeTraded	bit		N	0 = Not checked, 1 = checked
	ACUR_Forwards	bit		N	0 = Not checked, 1 = checked
	ACUR_Futures	bit		N	0 = Not checked, 1 = checked
	ACUR_HedgingOnly	bit		N	0 = Not checked, 1 = checked
	ACUR_Options	bit		N	0 = Not checked, 1 = checked
	ACUR_OTC	bit		N	0 = Not checked, 1 = checked
	ACUR_PrimaryFocus	bit		N	0 = Not checked, 1 = checked
	ACUR_Spot	bit		N	0 = Not checked, 1 = checked
	ACUR_Swaps	bit		N	0 = Not checked, 1 = checked
AP = Property & Other	AP_OtherAssets	bit		N	0 = Not checked, 1 = checked
	AP_Property	bit		N	0 = Not checked, 1 = checked
	AP_PrimaryFocus	bit		N	0 = Not checked, 1 = checked
FocusDetails
	ProductReference	int		N	One to One link to ProductDetails Table
SF = Sector Focus	SF_BioTechnology	bit		N	0 = Not checked, 1 = checked
	SF_CloseEndedFunds	bit		N	0 = Not checked, 1 = checked
	SF_CorporateBonds	bit		N	0 = Not checked, 1 = checked
	SF_Diversified	bit		N	0 = Not checked, 1 = checked
	SF_EmergingMarketBonds	bit		N	0 = Not checked, 1 = checked
	SF_EmergingMarketEquities	bit		N	0 = Not checked, 1 = checked
	SF_Financial	bit		N	0 = Not checked, 1 = checked
	SF_Gold	bit		N	0 = Not checked, 1 = checked
	SF_GovernmentBonds	bit		N	0 = Not checked, 1 = checked
	SF_GrowthStocks	bit		N	0 = Not checked, 1 = checked
	SF_HealthCare	bit		N	0 = Not checked, 1 = checked
	SF_LargeCap	bit		N	0 = Not checked, 1 = checked
	SF_MediaCommunications	bit		N	0 = Not checked, 1 = checked
	SF_MediumCap	bit		N	0 = Not checked, 1 = checked
	SF_MicroCap	bit		N	0 = Not checked, 1 = checked
	SF_MoneyMarkets	bit		N	0 = Not checked, 1 = checked
	SF_NaturalResources	bit		N	0 = Not checked, 1 = checked
	SF_NewIssues	bit		N	0 = Not checked, 1 = checked
	SF_OilEnergy	bit		N	0 = Not checked, 1 = checked
	SF_Other	bit		N	0 = Not checked, 1 = checked
	SF_PrivateEquity	bit		N	0 = Not checked, 1 = checked
	SF_PureCurrency	bit		N	0 = Not checked, 1 = checked
	SF_PureEmergingMarket	bit		N	0 = Not checked, 1 = checked
	SF_PureManagedFutures	bit		N	0 = Not checked, 1 = checked
	SF_RealEstateProperty	bit		N	0 = Not checked, 1 = checked
	SF_Shipping	bit		N	0 = Not checked, 1 = checked
	SF_SmallCap	bit		N	0 = Not checked, 1 = checked
	SF_SovereignDebt	bit		N	0 = Not checked, 1 = checked
	SF_Technology	bit		N	0 = Not checked, 1 = checked
	SF_TurnaroundsSpinOffs	bit		N	0 = Not checked, 1 = checked
	SF_Utilities	bit		N	0 = Not checked, 1 = checked
	SF_ValueStocks	bit		N	0 = Not checked, 1 = checked
IA = Investment Approach	IA_Arbitrage	bit		N	0 = Not checked, 1 = checked
	IA_BottomUp	bit		N	0 = Not checked, 1 = checked
	IA_Contrarian	bit		N	0 = Not checked, 1 = checked
	IA_Directional	bit		N	0 = Not checked, 1 = checked
	IA_Discretionary	bit		N	0 = Not checked, 1 = checked
	IA_Diversified	bit		N	0 = Not checked, 1 = checked
	IA_Fundamental	bit		N	0 = Not checked, 1 = checked
	IA_LongBias	bit		N	0 = Not checked, 1 = checked
	IA_MarketNeutral	bit		N	0 = Not checked, 1 = checked
	IA_NonDirectional	bit		N	0 = Not checked, 1 = checked
	IA_Opportunistic	bit		N	0 = Not checked, 1 = checked
	IA_Other	bit		N	0 = Not checked, 1 = checked
	IA_RelativeValue	bit		N	0 = Not checked, 1 = checked
	IA_ShortBias	bit		N	0 = Not checked, 1 = checked
	IA_SystematicQuant	bit		N	0 = Not checked, 1 = checked
	IA_Technical	bit		N	0 = Not checked, 1 = checked
	IA_TopDownMacro	bit		N	0 = Not checked, 1 = checked
	IA_TrendFollower	bit		N	0 = Not checked, 1 = checked
GF = Geographic Focus	GF_Africa	bit		N	0 = Not checked, 1 = checked
	GF_AsiaPacific	bit		N	0 = Not checked, 1 = checked
	GF_AsiaPacificExcludingJapan	bit		N	0 = Not checked, 1 = checked
	GF_EasternEurope	bit		N	0 = Not checked, 1 = checked
	GF_Global	bit		N	0 = Not checked, 1 = checked
	GF_India	bit		N	0 = Not checked, 1 = checked
	GF_Japan	bit		N	0 = Not checked, 1 = checked
	GF_LatinAmerica	bit		N	0 = Not checked, 1 = checked
	GF_NorthAmerica	bit		N	0 = Not checked, 1 = checked
	GF_NorthAmericaExcludingUSA	bit		N	0 = Not checked, 1 = checked
	GF_Other	bit		N	0 = Not checked, 1 = checked
	GF_Russia	bit		N	0 = Not checked, 1 = checked
	GF_UK	bit		N	0 = Not checked, 1 = checked
	GF_USA	bit		N	0 = Not checked, 1 = checked
	GF_WesternEurope	bit		N	0 = Not checked, 1 = checked
	GF_WesternEuropeExcludingUK	bit		N	0 = Not checked, 1 = checked
IF = Investment Focus	IF_Bankruptcy	bit		N	0 = Not checked, 1 = checked
	IF_CapitalStructureArbitrage	bit		N	0 = Not checked, 1 = checked
	IF_DistressedBonds	bit		N	0 = Not checked, 1 = checked
	IF_DistressedMarkets	bit		N	0 = Not checked, 1 = checked
	IF_EquityDerivativeArbitrage	bit		N	0 = Not checked, 1 = checked
	IF_HighYieldBonds	bit		N	0 = Not checked, 1 = checked
	IF_MergerArbitrageRiskArbitrage	bit		N	0 = Not checked, 1 = checked
	IF_MortgageBackedSecurities	bit		N	0 = Not checked, 1 = checked
	IF_MultiStrategy	bit		N	0 = Not checked, 1 = checked
	IF_PairsTrading	bit		N	0 = Not checked, 1 = checked
	IF_RegD	bit		N	0 = Not checked, 1 = checked
	IF_ShareholderActivist	bit		N	0 = Not checked, 1 = checked
	IF_SociallyResponsible	bit		N	0 = Not checked, 1 = checked
	IF_SpecialSituations	bit		N	0 = Not checked, 1 = checked
	IF_StatisticalArbitrage	bit		N	0 = Not checked, 1 = checked
Notes
	ProductReference	int		N	Link to ProductDetails - the ProductReference and Type are the primary key
	NotesID	int		N
	Type	varchar	255	N
	NoteText	text		Y
ProductDetails
	ProductReference	int		N	Primary Key
	Name	varchar	255	N	Fund Name
	PrimaryCategory	varchar	255	Y
	CurrencyCode	char	3	N
	CurrencyDescription	varchar	255	N	Base Currency of the Fund - The Assets and returns in ProductPerformance are in this currency
	LegalStructure	varchar	255	Y
	ClosedToInvestDate	datetime		Y	A default date of 1/1/1899 indicates that the fund is closed but the date is unknown
	ReopenToInvestDate	datetime		Y
	InceptionDate	datetime		Y	Inception date of the legal fund structure
	PerformanceStartDate	datetime		N	First data point in the ProductPerformance table
	PerformanceEndDate	datetime		N	Last data point in the ProductPerformance table
	GrossNett	char	1	N	G = Gross of all fees, N = Net of all fees, A = Net of management but Gross of incentive fees
	InitialNAV	float		N	Starting value used in ProductPerformance
	InitialSharePrice	float		Y
	Guaranteed	bit		N	1 = Guaranteed, 0 = Not guaranteed
	NavROR	char	1	N	N = Tracked by NAV, R =- Tracked by rate of return
	MinimumInvestment	float		Y
	ManagementFee	float		Y
	IncentiveFee	float		Y
	ManagementFeePayablePeriod	varchar	255	Y
	HighWaterMark	bit		N
	ShareEqualisationMethod	bit		N
	Leveraged	bit		N	1= Fund uses leverage, 0 Fund does not use leverage
	MaxLeverage	float		Y	A value of 100 would = 100%
	AvgLeverage	float		Y	A value of 100 would = 100%
	Futures	bit		Y	If fund leverages using futures value = 1, else 0
	Derivatives	bit		Y	If fund leverages using derivatives value = 1, else 0
	Margin	bit		Y	If fund leverages using margin borrowing value = 1, else 0
	FXCredit	bit		Y	If fund leverages using FXCredit value = 1, else 0
	PersonalCapital	bit		N	If principals have money invested = 1 else 0
	PersonalCapitalAmount	float		Y
	CurrencyExposure	bit		N	If the fund hedges FX exposure value = 1 else 0
	OpenEnded	bit		N	If fund open ended value = 1 else 0
	OpenToPublic	bit		N	If fund open to the public value = 1 else 0
	InvestsInManagedAccounts	bit		N	If fund invests in managed accounts value = 1 else 0
	InvestsInOtherFunds	bit		N	If fund invests in other hedge funds value = 1 else 0
	AcceptsManagedAccounts	bit		N	If fund accepts managed accounts value = 1 else 0
	ManagedAccountsMinAmount	float		Y
	TrackingFrequency	varchar	255	N	Either Monthly or Quarterly - determines data points in ProductPerformance
	SubscriptionFrequency	varchar	255	Y
	RedemptionFrequency	varchar	255	Y
	RedemptionNoticePeriod	int		Y	units are days
	LockUpPeriod	int		Y	units are months
	LockUpComment	varchar	255	Y
	PayOutPeriod	int		Y	units are days
	PayOutComment	varchar	255	Y
	AuditDate	datetime		Y	Most recent audited financial statements that have physically been received by TASS
	RegisteredInvestmentAdviser	bit		N	If fund is a registered as an investment advisor
	DomicileState	varchar	255	Y	Only used for US domiciled funds
	DomicileCountry	varchar	255	Y	Legal fund domicile
ProductDetailsAddDate
	ProductReference	int		N	Primary Key
	DateAddedToTASS	datetime		N	This is the date that the fund was added to the TASS Database
	DateRemovedFromTASS	datetime		Y	This is the date that the fund ceased reporting to the TASS Database
ProductPerformance
	ProductReference	int		N	Link to ProductDetails - ProductReference and Date form the Primary Key
	Date	datetime		N	Last day of month or quarter
	RateOfReturn	float		N
	NAV	float		N
	EstimatedAssets	float		Y
	EstimatedActual	char	1	N	E = estimated. A = Actual as stated by Fund Manager
StockExchanges
	StockExchangeID	int		N
	Description	varchar	100	N
StockExchangeXRef					This table indicates if a fund is listed on a stock exchange - One to May Relationship to Product Details
	ProductReference	int		N	Link to Product Details - ProductReference and SockExchange ID are the Primary Key
	StockExchangeID	int		N	Lookup to Stock Exchanges
TradingExchange
	ExchangeID	int		N
	Description	varchar	255	N
TradingExchangeXRef					This table indicates the exchanges that a fund trades on - One to Many Relationship to Product Details
	ProductReference	int		N	Link to Product Details - ProductReference and ExchangeID are the Primary Key
	ExchangeID	int		N	Lookup to Trading Exchange
IndexDetails	IndexReference	int		N	The unique Index identifier
	IndexName	varchar	100	N	The full name of the Index
	Abbreviation	varchar	8	N	The short name of the Index
	StartDate	datetime		Y	The first performance data point in the IndexPerformance table
	EndDate	datetime		Y	The last performance data point in the IndexPerformance table
	InitialNAV	float		N	The starting value or price for the Index. This value is used to calculate the rate of return in the first month in the IndexPerformance table
IndexPerformance	IndexReference	int		N	The link to the IndexDetails table
	MonthEndDate	datetime		N	The date of the Index price
	NAV	float		N	The Index month-end price/value
	RateOfReturn	float		N	The percentage movement for the month
ServiceProviderDetails	ProductReference	int		N	The link to the ProductDetails table
	CompanyID	int		N	Lookup to CompanyID in Companies table
	CompanyName	varchar	100	Y
	CompanyTypeID	int		N	Lookup to CompanyType in Companies table
	CompanyType	varchar	100	N
	Sequence	int		N	Arbitrary Sequence Number per Product
	StateName	varchar	255	Y
	CountryName	varchar	255	Y
CompanyDetails	ProductReference	int		N	The link to the ProductDetails table
	CompanyID	int		N	Lookup to CompanyID in Companies table
	CompanyName	varchar	100	Y
	CompanyTypeID	int		N	Lookup to CompanyType in CompanyType table
	CompanyType	varchar	100	N	Description from the CompanyTypeTable
	Sequence	int		N	Arbitrary Sequence Number per Product
	Address1	varchar	50	Y
	Address2	varchar	50	Y
	Address3	varchar	50	Y
	CityName	varchar	100	Y
	StateName	varchar	255	Y
	Zip	varchar	10	Y
	CountryName	varchar	255	Y
	Phone1	varchar	20	Y
	Phone2	varchar	20	Y
	Fax1	varchar	20	Y
	Fax2	varchar	20	Y
	MainEmail	varchar	50	Y
	WebAddress	varchar	50	Y
PeopleDetails	ProductReference	int		N	The link to the ProductDetails table
	PersonID	int		N	Lookup to PersonID in People table
	Prefix	varchar	10	Y
	First	varchar	100	Y
	Last	varchar	100	Y
	Suffix	varchar	10	Y
	JobTitle	varchar	1	Y	Not Used - Always Blank
	PersonTypeID	int		N	Lookup to PersonType in PeopleType table
	PersonType	varchar	100	N	Description from PeopleType table
	Sequence	int		N	Arbitrary Sequence Number per Product
	Address1	varchar	50	Y
	Address2	varchar	50	Y
	Address3	varchar	50	Y
	CityName	varchar	100	Y
	StateName	varchar	255	Y
	Zip	varchar	10	Y
	CountryName	varchar	255	Y
	Phone1	varchar	20	Y
	Phone2	varchar	20	Y
	Fax1	varchar	20	Y
	Fax2	varchar	20	Y
	MainEmail	varchar	50	Y