dbo.FactCallCenter
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | FactCallCenter |
| Module | Call Center |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | FactCallCenterID | int | Identity | |||||
| Identity |
||||||||
| 2 | DateKey | int | dbo.DimDate | |||||
| References: dbo.DimDate | ||||||||
| 3 | WageType | nvarchar(15) | ||||||
| 4 | Shift | nvarchar(20) | ||||||
| 5 | LevelOneOperators | smallint | ||||||
| 6 | LevelTwoOperators | smallint | ||||||
| 7 | TotalOperators | smallint | ||||||
| 8 | Calls | int | ||||||
| 9 | AutomaticResponses | int | ||||||
| 10 | Orders | int | ||||||
| 11 | IssuesRaised | smallint | ||||||
| 12 | AverageTimePerIssue | smallint | ||||||
| 13 | ServiceGrade | float | ||||||
| 14 | Date | datetime | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.FactCallCenter | dbo.DimDate | dbo.FactCallCenter.DateKey = dbo.DimDate.DateKey | FK_FactCallCenter_DimDate | |
|
dbo.FactCallCenter.DateKey = dbo.DimDate.DateKey Name: FK_FactCallCenter_DimDate |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_FactCallCenter_FactCallCenterID | FactCallCenterID | ||
| AK_FactCallCenter_DateKey_Shift | DateKey, Shift |
Uses
| Name |
|---|
|
dbo.FactCallCenter
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58