Table: vTargetMail
Table properties
| Property | Value |
| Database schema name | dbo |
| Database table name | vTargetMail |
| Friendly name | vTargetMail |
| Table name | dbo_vTargetMail |
| Table type | View |
| Is loaded |
Query definition
Parent relations
Child relations
Columns
| Name | Type | Computed column expression |
| CustomerKey | System.Int32 | |
| GeographyKey | System.Int32 | |
| CustomerAlternateKey | System.String | |
| Title | System.String | |
| FirstName | System.String | |
| MiddleName | System.String | |
| LastName | System.String | |
| NameStyle | System.Boolean | |
| BirthDate | System.DateTime | |
| MaritalStatus | System.String | |
| Suffix | System.String | |
| Gender | System.String | |
| EmailAddress | System.String | |
| YearlyIncome | System.Decimal | |
| TotalChildren | System.Byte | |
| NumberChildrenAtHome | System.Byte | |
| EnglishEducation | System.String | |
| SpanishEducation | System.String | |
| FrenchEducation | System.String | |
| EnglishOccupation | System.String | |
| SpanishOccupation | System.String | |
| FrenchOccupation | System.String | |
| HouseOwnerFlag | System.String | |
| NumberCarsOwned | System.Byte | |
| AddressLine1 | System.String | |
| AddressLine2 | System.String | |
| Phone | System.String | |
| DateFirstPurchase | System.DateTime | |
| CommuteDistance | System.String | |
| Region | System.String | |
| Age | System.Int32 | |
| BikeBuyer | System.Int32 |
See also