# Table: SalesPersonQuotaHistory

## Properties

Property | Value
--- | ---
Name | SalesPersonQuotaHistory
ID | 1490104349
Owner | dbo
Schema | Sales
Filegroup | PRIMARY
Data Size (KB) | 16 KB
Index Size (KB) | 32 KB
Rows | 163
Unused (KB) | 0 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:43 PM
Create Date | 8/8/2010 5:21:52 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Sales performance tracking.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | BusinessEntityID | int |  |  |
2 | QuotaDate | datetime |  |  |
3 | SalesQuota | money |  |  |
4 | rowguid | uniqueidentifier |  |  |
5 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
BusinessEntityID
QuotaDate

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID | Sales.SalesPerson | No action | No action

## Column Level Check Constraints

Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named
--- | --- | --- | --- | --- | --- | --- | --- | ---
CK_SalesPersonQuotaHistory_SalesQuota | 3 | SalesQuota | ([SalesQuota]>(0.00)) |  |  |  |  |

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_SalesPersonQuotaHistory_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_SalesPersonQuotaHistory_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate | CLUSTERED |  |  |  |  |
AK_SalesPersonQuotaHistory_rowguid | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate | Aug 8 2010 5:23PM | 163 | 163 | 11 | 0.1 | 12 |  |  | 163

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.05882353 | 4 | BusinessEntityID
0.006134969 | 12 | BusinessEntityID, QuotaDate

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
274 | 0 | 12 | 0 | 1
276 | 12 | 12 | 1 | 12
278 | 12 | 12 | 1 | 12
280 | 12 | 12 | 1 | 12
282 | 12 | 12 | 1 | 12
283 | 0 | 12 | 0 | 1
284 | 0 | 7 | 0 | 1
286 | 4 | 4 | 1 | 4
287 | 0 | 8 | 0 | 1
288 | 0 | 4 | 0 | 1
290 | 8 | 8 | 1 | 8

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_SalesPersonQuotaHistory_rowguid | Aug 8 2010 5:23PM | 163 | 163 | 144 | 1 | 28 |  |  | 163

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.006134969 | 16 | rowguid
0.006134969 | 20 | rowguid, BusinessEntityID
0.006134969 | 28 | rowguid, BusinessEntityID, QuotaDate

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
ab87ae3a-a0db-4073-b348-02851be80d64 | 0 | 1 | 0 | 1
738ac57f-d7a4-42f6-bb6c-0447d877aa13 | 0 | 1 | 0 | 1
dfd01444-8900-461c-8d6f-04598dae01d4 | 0 | 1 | 0 | 1
b1382489-b7ef-465f-bc96-06fd27e8f320 | 0 | 1 | 0 | 1
aa3c8a00-6590-497e-80f6-075bb947e025 | 0 | 1 | 0 | 1
12aac834-ab2f-4e84-b85d-08839670c198 | 0 | 1 | 0 | 1
876e5dd7-de44-4497-bb38-08b1d56a9f5d | 0 | 1 | 0 | 1
3e7198aa-2bf8-4050-9050-091d14f61ff1 | 0 | 1 | 0 | 1
10c5e693-5182-4951-9f36-0bae17b3878c | 0 | 1 | 0 | 1
16962d2d-f610-4150-9c05-0be2e0ffe207 | 0 | 1 | 0 | 1
58e9567d-5174-4a27-a95a-11da6e6dc585 | 2 | 1 | 2 | 1
1290b655-35f4-4447-a4c5-1385f62fef4d | 0 | 1 | 0 | 1
53a0df58-8b98-4371-97a5-14c1442a3582 | 0 | 1 | 0 | 1
b762b64b-0e51-41c9-889f-1535bf553bed | 0 | 1 | 0 | 1
bb8c5bb9-475d-438b-a611-17a20f4a6b91 | 0 | 1 | 0 | 1
90489216-ea7e-43b0-be90-17f2ed47f2e2 | 0 | 1 | 0 | 1
c35fb2f4-1e84-4b8f-af6b-186315ccac08 | 0 | 1 | 0 | 1
c88dafc0-a293-4a00-98c2-1a530288a113 | 0 | 1 | 0 | 1
0e252d7f-f0a3-493a-93ff-1aca0fbfe0ad | 0 | 1 | 0 | 1
d44e0e60-c00c-413b-b288-1b69553120bc | 0 | 1 | 0 | 1
1ea57383-0be7-46e8-bfb9-21034fabe6cc | 1 | 1 | 1 | 1
9aeda6ba-4476-4f8e-821b-26b52596718f | 0 | 1 | 0 | 1
ce0b49c6-ced2-46b2-83c4-28f72d04ce5c | 0 | 1 | 0 | 1
0cfb6474-20aa-46d3-a5c0-29dba2eda025 | 0 | 1 | 0 | 1
87ac1fb7-a3c5-43a6-90aa-2d09ae00148a | 1 | 1 | 1 | 1
496e25d7-21a1-4185-9fbc-2db261c8de25 | 0 | 1 | 0 | 1
816a0650-905e-4079-8f89-2e1a698a1e10 | 0 | 1 | 0 | 1
fcef2af1-6183-41b3-a04f-2ead88389267 | 0 | 1 | 0 | 1
f72567da-8a78-43c7-9adb-30b1503e6f56 | 0 | 1 | 0 | 1
4b6ebe93-65ed-474b-9210-3115f0979546 | 0 | 1 | 0 | 1
59e16b51-71f7-48e4-8a80-359103fe685a | 0 | 1 | 0 | 1
08270720-0537-4f0e-ba15-375ec0660f31 | 0 | 1 | 0 | 1
a0018050-d5a1-46b9-88a0-37ea2034585a | 0 | 1 | 0 | 1
c81757ca-da32-4618-8429-395f96283a6d | 0 | 1 | 0 | 1
ba494ea7-5ced-4044-995c-39a69dd68b34 | 0 | 1 | 0 | 1
634a330e-8683-42d4-824f-39b3f9076270 | 0 | 1 | 0 | 1
81ef8bc1-eff8-4cff-adc3-3b76104d9b5f | 0 | 1 | 0 | 1
b9c12814-44b8-47ce-8db8-45a7c91e360b | 0 | 1 | 0 | 1
5fbe0fbe-45ff-42ad-9e04-46d6c5dd24a9 | 0 | 1 | 0 | 1
f22dfa8f-2d6d-4ca1-9abf-48d8b2b4f705 | 0 | 1 | 0 | 1
d3afa546-5a53-47ca-b2ac-49a54d68c090 | 0 | 1 | 0 | 1
a6cf1e2a-da84-407a-9bec-4ad473708c0b | 0 | 1 | 0 | 1
87a51a0f-3d6d-42d0-98a7-4ad934977417 | 0 | 1 | 0 | 1
bff32188-2095-43b6-88ff-4cdcdd7c2f4c | 0 | 1 | 0 | 1
1b62e37f-2045-404a-b3f0-4e7b65c8d979 | 0 | 1 | 0 | 1
2c00a4fc-8f81-4b01-8e12-5171e008803b | 0 | 1 | 0 | 1
76d1ed81-97a0-466e-8778-51b19e6b21fa | 0 | 1 | 0 | 1
27ded788-f295-472a-8151-5254a86103e0 | 0 | 1 | 0 | 1
5db4299a-1ad9-49c6-b024-528c771cae3f | 0 | 1 | 0 | 1
c637e5f0-1e12-41f6-932e-53714b6961a8 | 0 | 1 | 0 | 1
d1f92ec2-0c55-47d4-be71-54b37223d19f | 0 | 1 | 0 | 1
440aa05d-4bc7-4093-8c4e-54f7f8c74bb9 | 0 | 1 | 0 | 1
40ade5de-6cae-40c2-8d7f-594045a6a40e | 0 | 1 | 0 | 1
62dd856a-7b26-4952-861d-5c8b85a2e859 | 0 | 1 | 0 | 1
5671ec9e-4fa4-4232-907f-5cb981445e52 | 0 | 1 | 0 | 1
a6b9418a-d891-469e-a2c2-5d3e8e7251fd | 0 | 1 | 0 | 1
6206c73d-958d-44ca-b1c1-5e0c34a3c156 | 0 | 1 | 0 | 1
62ce3158-2b10-483f-beb3-5e4d60966183 | 0 | 1 | 0 | 1
f8443072-c5b3-4f3f-8e20-5f53c90b0414 | 0 | 1 | 0 | 1
e7f639ac-53c3-4b66-8ecd-5f71e7cacb99 | 0 | 1 | 0 | 1
99109bbf-8693-4587-bc23-6036ec89e1be | 0 | 1 | 0 | 1
68082afc-9a96-4ede-8b8e-64c4e9f8ddd4 | 0 | 1 | 0 | 1
20819180-2de9-41fe-9efb-6513453d69a0 | 0 | 1 | 0 | 1
9058a255-7745-494b-9a4b-6cea2d0a3ba7 | 0 | 1 | 0 | 1
cfa3347d-bbf9-4f9b-8339-6fc0fd0079f4 | 0 | 1 | 0 | 1
2df41dd8-182e-4c57-ae81-718f714cb4ff | 1 | 1 | 1 | 1
bde90d55-c92e-4b0d-8e0c-72fd0eece610 | 0 | 1 | 0 | 1
760cef84-b980-417b-a667-7358c38857f0 | 0 | 1 | 0 | 1
a5ccd7a0-f696-489e-8d9b-73904d898dc6 | 0 | 1 | 0 | 1
59fd606c-22ff-4f43-951b-74fca7758ede | 0 | 1 | 0 | 1
472859c3-39a7-4504-a0cd-760cbeac95f8 | 1 | 1 | 1 | 1
f9823592-5888-487d-9b86-79074a27a96f | 0 | 1 | 0 | 1
aa12de6f-c835-4876-9afb-7ae5501db57e | 0 | 1 | 0 | 1
00f2f9f8-5158-4436-b134-7e0c462289e5 | 0 | 1 | 0 | 1
122081ea-60af-45e8-b732-7e614edf8460 | 0 | 1 | 0 | 1
7a09cd71-eed6-485b-8af4-800c82aec15a | 0 | 1 | 0 | 1
0103899f-618c-4478-90bb-815b20856f35 | 0 | 1 | 0 | 1
70785e05-776d-4479-b6b5-83d9b1c9d7dd | 0 | 1 | 0 | 1
8b4e3cbf-f0ef-49c5-9a8c-87679055057e | 0 | 1 | 0 | 1
03a84ecc-e299-4b61-a634-892399e0a0ec | 1 | 1 | 1 | 1
cb65848e-16d8-42fd-a9f3-8a8cae4ceb9c | 0 | 1 | 0 | 1
5e45eb9d-6592-444c-bb43-8b260afabd7d | 0 | 1 | 0 | 1
a3974eb0-509f-432a-8046-8e14bb175a91 | 0 | 1 | 0 | 1
0569df99-deab-46ce-8818-8eee2dd47bf1 | 0 | 1 | 0 | 1
da8d1458-5fb9-4c3e-9ead-8f5ce1393047 | 0 | 1 | 0 | 1
c7a90e1b-3b08-4b58-84f7-8f70c9092d86 | 0 | 1 | 0 | 1
5f7e9647-3f08-49b0-a4a4-90257fc78197 | 0 | 1 | 0 | 1
d368dc2c-f142-48f6-a787-91d818c04534 | 0 | 1 | 0 | 1
eca1e739-05f5-4584-9118-927634284e93 | 0 | 1 | 0 | 1
173ad1f3-c953-4182-8168-97190ca5f929 | 0 | 1 | 0 | 1
23dcfb7a-4b3f-4302-b88a-989b28c9c32a | 0 | 1 | 0 | 1
0f4f65ca-3a56-46f0-b5f0-9d86db593ca3 | 1 | 1 | 1 | 1
982237b6-4533-4dcb-907a-9e15d45afa59 | 0 | 1 | 0 | 1
9b6e418d-0842-4fe3-b86a-9eca7cce4367 | 0 | 1 | 0 | 1
cb4de112-c5fa-4b67-8eeb-9f09569c249c | 0 | 1 | 0 | 1
eb5d735c-8bbd-4b6c-a7eb-a006335a5d2e | 0 | 1 | 0 | 1
99552f0a-6a94-4a5b-afe9-a18973958b9e | 0 | 1 | 0 | 1
34b585ba-dd7e-41e6-af29-a4ac61eae320 | 0 | 1 | 0 | 1
0a25496d-5797-44f6-9331-a71d06b0fd63 | 0 | 1 | 0 | 1
b06507b8-6a96-4819-ac31-a77411c9b777 | 0 | 1 | 0 | 1
bc1a222f-47a0-48d1-9c56-ac873269dc98 | 0 | 1 | 0 | 1
c5a85488-c1dc-4f85-9b24-addf853793f8 | 0 | 1 | 0 | 1
64c8e4f4-f979-4816-a2ee-b044ad74224d | 0 | 1 | 0 | 1
8de8217f-553d-4614-b0e0-b0bdb32e7aec | 1 | 1 | 1 | 1
e9de95e3-b119-4441-bd1d-b27fc4516022 | 0 | 1 | 0 | 1
95b4b50b-08e7-4b71-a68c-b55f9400395b | 0 | 1 | 0 | 1
1f07008f-826f-4c83-a3f6-b72ea3a406af | 0 | 1 | 0 | 1
480c5a5b-e2ac-4c72-930b-b80e770fb14b | 0 | 1 | 0 | 1
f9488f84-7dfe-4073-8de4-ba2ba1f3a00f | 0 | 1 | 0 | 1
fceb753b-9a73-445a-937f-ba7ec99385b4 | 0 | 1 | 0 | 1
15e5eae2-bd36-4798-a066-bc7594e2930b | 1 | 1 | 1 | 1
d566e989-d212-4b08-bb20-be7967ecefaf | 2 | 1 | 2 | 1
61407c3a-731d-4269-9894-bfa0f447fe79 | 0 | 1 | 0 | 1
ee81e30a-0878-4fdd-b626-c44ad7b7df61 | 0 | 1 | 0 | 1
c69b67db-f35f-4dad-a8a8-c4d074ad17db | 0 | 1 | 0 | 1
0a69f453-9689-4ccf-a08c-c644670f5668 | 0 | 1 | 0 | 1
5690e967-970d-41f6-9864-c64bd61a896d | 0 | 1 | 0 | 1
070f2190-c4fb-4261-98ef-c6b5ca745de8 | 0 | 1 | 0 | 1
610f84c0-206d-487f-988e-c804abfc11a5 | 0 | 1 | 0 | 1
f436e58a-b6e5-4945-bee1-c80602b7b7a8 | 0 | 1 | 0 | 1
c40ac76f-5027-4417-9b60-cb1210ac079a | 1 | 1 | 1 | 1
f020801a-4e65-42e3-83e5-cb92fde0beee | 1 | 1 | 1 | 1
3bd5fb9e-0d3c-41b5-a619-cb98d6e5b7fe | 0 | 1 | 0 | 1
13947d2c-a254-47c9-8817-cbd186ffa526 | 0 | 1 | 0 | 1
292d397c-b094-44bd-8374-cff90cf4b10a | 0 | 1 | 0 | 1
bfb04c57-f0f4-4422-aa9b-d2a74e67a3a8 | 0 | 1 | 0 | 1
d1cf9bfc-0e82-4b0a-becc-da6246767a74 | 0 | 1 | 0 | 1
0323d0bc-c5cc-4d67-8935-dd05074fba43 | 0 | 1 | 0 | 1
15be4c16-782c-40fd-861f-dd85cdebca83 | 0 | 1 | 0 | 1
aeda3a74-5e52-4fdc-ae81-e236b4d14f5f | 1 | 1 | 1 | 1
f6c65525-b30a-42b5-be6c-ea63b6bef320 | 0 | 1 | 0 | 1
4f97c4d6-9c4c-4915-9ca4-eab679d373f6 | 0 | 1 | 0 | 1
118f1fc6-7b7e-4588-90b0-f08ba349dbe7 | 0 | 1 | 0 | 1
adc65c86-afee-4a07-80d9-f23039954c4a | 1 | 1 | 1 | 1
5af006c1-aa62-4303-875f-f248b448297c | 0 | 1 | 0 | 1
85cd56a2-f1a1-4e1d-9ab6-f415d811f3c1 | 0 | 1 | 0 | 1
a2b99573-af8a-461a-b554-f489de2fa266 | 0 | 1 | 0 | 1
d2fe8c53-8307-4c36-9571-f5648da24ca2 | 0 | 1 | 0 | 1
ad3e7040-3f1f-485e-a716-f7d18ce09e76 | 2 | 1 | 2 | 1
375ed681-8543-49e2-bb95-fa56545568e8 | 0 | 1 | 0 | 1
4580482f-a91e-4482-a95d-fc7bce1a2e01 | 1 | 1 | 1 | 1
e35d6a3a-8303-47dd-b0e6-fd7d40a396b2 | 0 | 1 | 0 | 1
c97c50f2-2dbe-465d-8780-fe201f0cfd25 | 0 | 1 | 0 | 1
7cea47b5-8391-4414-a866-ff6ec6628cd3 | 0 | 1 | 0 | 1

## Objects that depend on [SalesPersonQuotaHistory]

- Sales.SalesPersonQuotaHistory

## Objects on which [SalesPersonQuotaHistory] depends

- Sales.SalesPersonQuotaHistory
  - Sales.SalesPerson
    - Sales.SalesTerritory
      - Person.CountryRegion
        - dbo.Name
    - HumanResources.Employee
      - Person.Person
        - Person.AdditionalContactInfoSchemaCollection
        - Person.BusinessEntity
        - Demographics.exist
        - Person.IndividualSurveySchemaCollection
        - dbo.NameStyle
      - dbo.Flag

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[SalesPersonQuotaHistory]( [BusinessEntityID] [int] NOT NULL, [QuotaDate] [datetime] NOT NULL, [SalesQuota] [money] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales quota date.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'QuotaDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales quota amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'SalesQuota' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales performance tracking.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory'

#### See also

List of Tables