Routine Columns
Fact	GeneralType	GeneralSchema	GeneralObject	column_id	GeneralColumn	SQLServerType	collation_name	is_nullable
17	V	HumanResources	vEmployee	1	BusinessEntityID	int		False
17	V	HumanResources	vEmployee	2	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	3	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	4	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	5	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	6	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	7	JobTitle	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	8	PhoneNumber	Phone	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	9	PhoneNumberType	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	10	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	11	EmailPromotion	int		False
17	V	HumanResources	vEmployee	12	AddressLine1	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	13	AddressLine2	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployee	14	City	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	15	StateProvinceName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	16	PostalCode	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	17	CountryRegionName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployee	18	AdditionalContactInfo	xml		True
17	V	HumanResources	vEmployeeDepartment	1	BusinessEntityID	int		False
17	V	HumanResources	vEmployeeDepartment	2	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployeeDepartment	3	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartment	4	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployeeDepartment	5	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartment	6	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployeeDepartment	7	JobTitle	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartment	8	Department	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartment	9	GroupName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartment	10	StartDate	date		False
17	V	HumanResources	vEmployeeDepartmentHistory	1	BusinessEntityID	int		False
17	V	HumanResources	vEmployeeDepartmentHistory	2	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployeeDepartmentHistory	3	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartmentHistory	4	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployeeDepartmentHistory	5	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartmentHistory	6	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vEmployeeDepartmentHistory	7	Shift	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartmentHistory	8	Department	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartmentHistory	9	GroupName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	HumanResources	vEmployeeDepartmentHistory	10	StartDate	date		False
17	V	HumanResources	vEmployeeDepartmentHistory	11	EndDate	date		True
17	V	HumanResources	vJobCandidate	1	JobCandidateID	int		False
17	V	HumanResources	vJobCandidate	2	BusinessEntityID	int		True
17	V	HumanResources	vJobCandidate	3	Name.Prefix	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	4	Name.First	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	5	Name.Middle	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	6	Name.Last	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	7	Name.Suffix	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	8	Skills	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	9	Addr.Type	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	10	Addr.Loc.CountryRegion	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	11	Addr.Loc.State	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	12	Addr.Loc.City	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	13	Addr.PostalCode	nvarchar(0020)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	14	EMail	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	15	WebSite	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidate	16	ModifiedDate	datetime		False
17	V	HumanResources	vJobCandidateEducation	1	JobCandidateID	int		False
17	V	HumanResources	vJobCandidateEducation	2	Edu.Level	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	3	Edu.StartDate	datetime		True
17	V	HumanResources	vJobCandidateEducation	4	Edu.EndDate	datetime		True
17	V	HumanResources	vJobCandidateEducation	5	Edu.Degree	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	6	Edu.Major	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	7	Edu.Minor	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	8	Edu.GPA	nvarchar(0005)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	9	Edu.GPAScale	nvarchar(0005)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	10	Edu.School	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	11	Edu.Loc.CountryRegion	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	12	Edu.Loc.State	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEducation	13	Edu.Loc.City	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	1	JobCandidateID	int		False
17	V	HumanResources	vJobCandidateEmployment	2	Emp.StartDate	datetime		True
17	V	HumanResources	vJobCandidateEmployment	3	Emp.EndDate	datetime		True
17	V	HumanResources	vJobCandidateEmployment	4	Emp.OrgName	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	5	Emp.JobTitle	nvarchar(0100)	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	6	Emp.Responsibility	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	7	Emp.FunctionCategory	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	8	Emp.IndustryCategory	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	9	Emp.Loc.CountryRegion	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	10	Emp.Loc.State	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	HumanResources	vJobCandidateEmployment	11	Emp.Loc.City	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	1	BusinessEntityID	int		False
17	V	Person	vAdditionalContactInfo	2	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Person	vAdditionalContactInfo	3	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	4	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Person	vAdditionalContactInfo	5	TelephoneNumber	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	6	TelephoneSpecialInstructions	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	7	Street	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	8	City	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	9	StateProvince	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	10	PostalCode	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	11	CountryRegion	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	12	HomeAddressSpecialInstructions	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	13	EMailAddress	nvarchar(0128)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	14	EMailSpecialInstructions	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	15	EMailTelephoneNumber	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Person	vAdditionalContactInfo	16	rowguid	uniqueidentifier		False
17	V	Person	vAdditionalContactInfo	17	ModifiedDate	datetime		False
17	V	Person	vStateProvinceCountryRegion	1	StateProvinceID	int		False
17	V	Person	vStateProvinceCountryRegion	2	StateProvinceCode	nchar(0003)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Person	vStateProvinceCountryRegion	3	IsOnlyStateProvinceFlag	Flag		False
17	V	Person	vStateProvinceCountryRegion	4	StateProvinceName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Person	vStateProvinceCountryRegion	5	TerritoryID	int		False
17	V	Person	vStateProvinceCountryRegion	6	CountryRegionCode	nvarchar(0003)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Person	vStateProvinceCountryRegion	7	CountryRegionName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductAndDescription	1	ProductID	int		False
17	V	Production	vProductAndDescription	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductAndDescription	3	ProductModel	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductAndDescription	4	CultureID	nchar(0006)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductAndDescription	5	Description	nvarchar(0400)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductModelCatalogDescription	1	ProductModelID	int		False
17	V	Production	vProductModelCatalogDescription	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductModelCatalogDescription	3	Summary	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	4	Manufacturer	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	5	Copyright	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	6	ProductURL	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	7	WarrantyPeriod	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	8	WarrantyDescription	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	9	NoOfYears	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	10	MaintenanceDescription	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	11	Wheel	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	12	Saddle	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	13	Pedal	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	14	BikeFrame	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	15	Crankset	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	16	PictureAngle	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	17	PictureSize	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	18	ProductPhotoID	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	19	Material	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	20	Color	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	21	ProductLine	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	22	Style	nvarchar(0256)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	23	RiderExperience	nvarchar(1024)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelCatalogDescription	24	rowguid	uniqueidentifier		False
17	V	Production	vProductModelCatalogDescription	25	ModifiedDate	datetime		False
17	V	Production	vProductModelInstructions	1	ProductModelID	int		False
17	V	Production	vProductModelInstructions	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Production	vProductModelInstructions	3	Instructions	nvarchar(max )	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelInstructions	4	LocationID	int		True
17	V	Production	vProductModelInstructions	5	SetupHours	decimal(09,04)		True
17	V	Production	vProductModelInstructions	6	MachineHours	decimal(09,04)		True
17	V	Production	vProductModelInstructions	7	LaborHours	decimal(09,04)		True
17	V	Production	vProductModelInstructions	8	LotSize	int		True
17	V	Production	vProductModelInstructions	9	Step	nvarchar(1024)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Production	vProductModelInstructions	10	rowguid	uniqueidentifier		False
17	V	Production	vProductModelInstructions	11	ModifiedDate	datetime		False
17	V	Purchasing	vVendorWithAddresses	1	BusinessEntityID	int		False
17	V	Purchasing	vVendorWithAddresses	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithAddresses	3	AddressType	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithAddresses	4	AddressLine1	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithAddresses	5	AddressLine2	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithAddresses	6	City	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithAddresses	7	StateProvinceName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithAddresses	8	PostalCode	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithAddresses	9	CountryRegionName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithContacts	1	BusinessEntityID	int		False
17	V	Purchasing	vVendorWithContacts	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithContacts	3	ContactType	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithContacts	4	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithContacts	5	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithContacts	6	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithContacts	7	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Purchasing	vVendorWithContacts	8	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithContacts	9	PhoneNumber	Phone	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithContacts	10	PhoneNumberType	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithContacts	11	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Purchasing	vVendorWithContacts	12	EmailPromotion	int		False
17	V	Sales	vIndividualCustomer	1	BusinessEntityID	int		False
17	V	Sales	vIndividualCustomer	2	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	3	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	4	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	5	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	6	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	7	PhoneNumber	Phone	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	8	PhoneNumberType	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	9	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	10	EmailPromotion	int		False
17	V	Sales	vIndividualCustomer	11	AddressType	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	12	AddressLine1	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	13	AddressLine2	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vIndividualCustomer	14	City	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	15	StateProvinceName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	16	PostalCode	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	17	CountryRegionName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vIndividualCustomer	18	Demographics	xml		True
17	V	Sales	vPersonDemographics	1	BusinessEntityID	int		False
17	V	Sales	vPersonDemographics	2	TotalPurchaseYTD	money		True
17	V	Sales	vPersonDemographics	3	DateFirstPurchase	datetime		True
17	V	Sales	vPersonDemographics	4	BirthDate	datetime		True
17	V	Sales	vPersonDemographics	5	MaritalStatus	nvarchar(0001)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vPersonDemographics	6	YearlyIncome	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vPersonDemographics	7	Gender	nvarchar(0001)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vPersonDemographics	8	TotalChildren	int		True
17	V	Sales	vPersonDemographics	9	NumberChildrenAtHome	int		True
17	V	Sales	vPersonDemographics	10	Education	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vPersonDemographics	11	Occupation	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vPersonDemographics	12	HomeOwnerFlag	bit		True
17	V	Sales	vPersonDemographics	13	NumberCarsOwned	int		True
17	V	Sales	vSalesPerson	1	BusinessEntityID	int		False
17	V	Sales	vSalesPerson	2	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	3	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	4	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	5	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	6	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	7	JobTitle	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	8	PhoneNumber	Phone	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	9	PhoneNumberType	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	10	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	11	EmailPromotion	int		False
17	V	Sales	vSalesPerson	12	AddressLine1	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	13	AddressLine2	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	14	City	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	15	StateProvinceName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	16	PostalCode	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	17	CountryRegionName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPerson	18	TerritoryName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	19	TerritoryGroup	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPerson	20	SalesQuota	money		True
17	V	Sales	vSalesPerson	21	SalesYTD	money		False
17	V	Sales	vSalesPerson	22	SalesLastYear	money		False
17	V	Sales	vSalesPersonSalesByFiscalYears	1	SalesPersonID	int		True
17	V	Sales	vSalesPersonSalesByFiscalYears	2	FullName	nvarchar(0152)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vSalesPersonSalesByFiscalYears	3	JobTitle	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPersonSalesByFiscalYears	4	SalesTerritory	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vSalesPersonSalesByFiscalYears	5	2002	money		True
17	V	Sales	vSalesPersonSalesByFiscalYears	6	2003	money		True
17	V	Sales	vSalesPersonSalesByFiscalYears	7	2004	money		True
17	V	Sales	vStoreWithAddresses	1	BusinessEntityID	int		False
17	V	Sales	vStoreWithAddresses	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithAddresses	3	AddressType	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithAddresses	4	AddressLine1	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithAddresses	5	AddressLine2	nvarchar(0060)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithAddresses	6	City	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithAddresses	7	StateProvinceName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithAddresses	8	PostalCode	nvarchar(0015)	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithAddresses	9	CountryRegionName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithContacts	1	BusinessEntityID	int		False
17	V	Sales	vStoreWithContacts	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithContacts	3	ContactType	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithContacts	4	Title	nvarchar(0008)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithContacts	5	FirstName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithContacts	6	MiddleName	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithContacts	7	LastName	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithContacts	8	Suffix	nvarchar(0010)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithContacts	9	PhoneNumber	Phone	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithContacts	10	PhoneNumberType	Name	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithContacts	11	EmailAddress	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithContacts	12	EmailPromotion	int		False
17	V	Sales	vStoreWithDemographics	1	BusinessEntityID	int		False
17	V	Sales	vStoreWithDemographics	2	Name	Name	SQL_Latin1_General_CP1_CI_AS	False
17	V	Sales	vStoreWithDemographics	3	AnnualSales	money		True
17	V	Sales	vStoreWithDemographics	4	AnnualRevenue	money		True
17	V	Sales	vStoreWithDemographics	5	BankName	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithDemographics	6	BusinessType	nvarchar(0005)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithDemographics	7	YearOpened	int		True
17	V	Sales	vStoreWithDemographics	8	Specialty	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithDemographics	9	SquareFeet	int		True
17	V	Sales	vStoreWithDemographics	10	Brands	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithDemographics	11	Internet	nvarchar(0030)	SQL_Latin1_General_CP1_CI_AS	True
17	V	Sales	vStoreWithDemographics	12	NumberEmployees	int		True
17	TF	dbo	ufnGetContactInformation	1	PersonID	int		False
17	TF	dbo	ufnGetContactInformation	2	FirstName	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	TF	dbo	ufnGetContactInformation	3	LastName	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	TF	dbo	ufnGetContactInformation	4	JobTitle	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True
17	TF	dbo	ufnGetContactInformation	5	BusinessEntityType	nvarchar(0050)	SQL_Latin1_General_CP1_CI_AS	True