|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FactHoursWorkedByWeek |
| Schema | dbo |
| Row Count | 1117765 |
| Data Size | 47328 KB |
| Index Size | 16672 KB |
| Create Date | 3/9/2017 10:43 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
 |
AssignmentSK |
int(10, 0) |
False |
False |
False |
Key identifier for the employee's Assignment, used to reference the assignment dimension. |
||
|
|
EmployeeSK |
int(10, 0) |
False |
False |
False |
Key identifier for the Employee, used to reference the employee dimension. |
||
|
|
EndDateSK |
int(10, 0) |
False |
False |
False |
Key identifier for the end date of the week which will be Sunday, used to reference the date dimension. |
||
|
|
HoursWorked |
numeric(9, 2) |
False |
False |
False |
The number (in some cases the average hours not actual) of hours worked by an employee on an assignment for a week. |
||
 |
|
HoursWorkedByWeekSk |
int(10, 0) |
False |
False |
False |
(1 / 1) |
Primary Key to the Fact. |
|
|
|
PositionSK |
int(10, 0) |
False |
False |
False |
Key identifier for the employee's Position, used to reference the position dimension. |
||
|
|
StartDateSK |
int(10, 0) |
False |
False |
False |
Key identifier for the start date of the week which will be Saturday, used to reference the date dimension. |
||
|
|
TimeTypeSK |
int(10, 0) |
False |
False |
False |
Key identifier for the type of hours worked by the employee, used to reference the time type dimension. |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
HoursWorkedByWeekSk |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
AssignmentSK |
DimAssignment |
AssignmentSK |
True |
|
EmployeeSK |
DimEmployee |
EmployeeSK |
True |
|
EndDateSK |
DimDate |
DateSK |
True |
|
PositionSK |
DimPosition |
PositionSK |
True |
|
StartDateSK |
DimDate |
DateSK |
True |
|
TimeTypeSK |
DimTimeType |
TimeTypeSK |
True |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FactHoursWorkedByWeek depends on)
| Name | Type |
Table |
|
Table |
|
Table |
|
Table |
|
Table |
Child Dependencies (objects that depend on dbo.FactHoursWorkedByWeek)
| Name | Type |
TABLE |
|
TABLE |
|
TABLE |
|
TABLE |
|
TABLE |
Extended Properties
| Object | Property | Value |
FactHoursWorkedByWeek |
Display Name |
HoursByWeek |
FactHoursWorkedByWeek |
Table Description |
The fact will contain a row per employee per assignment per week (week is Saturday to Sunday) worked at the institution for regu |
FactHoursWorkedByWeek |
Table Type |
Fact |
AssignmentSK |
MS_Description |
Key identifier for the employee's Assignment, used to reference the assignment dimension. |
EmployeeSK |
MS_Description |
Key identifier for the Employee, used to reference the employee dimension. |
EndDateSK |
MS_Description |
Key identifier for the end date of the week which will be Sunday, used to reference the date dimension. |
HoursWorked |
MS_Description |
The number (in some cases the average hours not actual) of hours worked by an employee on an assignment for a week. |
HoursWorkedByWeekSk |
MS_Description |
Primary Key to the Fact. |
PositionSK |
MS_Description |
Key identifier for the employee's Position, used to reference the position dimension. |
StartDateSK |
MS_Description |
Key identifier for the start date of the week which will be Saturday, used to reference the date dimension. |
TimeTypeSK |
MS_Description |
Key identifier for the type of hours worked by the employee, used to reference the time type dimension. |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FactHoursWorkedByWeek] Script Date: 03/09/2017 17:14:58 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FactHoursWorkedByWeek]( [HoursWorkedByWeekSk] [int] IDENTITY(1,1) NOT NULL, [EmployeeSK] [int] NOT NULL, [PositionSK] [int] NOT NULL, [AssignmentSK] [int] NOT NULL, [StartDateSK] [int] NOT NULL, [EndDateSK] [int] NOT NULL, [TimeTypeSK] [int] NOT NULL, [HoursWorked] [numeric](9, 2) NOT NULL, CONSTRAINT [PK_dbo.FactHoursWorkedByWeek] PRIMARY KEY NONCLUSTERED ( [HoursWorkedByWeekSk] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] ALTER TABLE [dbo].[FactHoursWorkedByWeek] WITH CHECK ADD CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_AssignmentSK] FOREIGN KEY([AssignmentSK]) REFERENCES [DimAssignment] ([AssignmentSK]) ALTER TABLE [dbo].[FactHoursWorkedByWeek] CHECK CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_AssignmentSK] ALTER TABLE [dbo].[FactHoursWorkedByWeek] WITH CHECK ADD CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_EmployeeSK] FOREIGN KEY([EmployeeSK]) REFERENCES [DimEmployee] ([EmployeeSK]) ALTER TABLE [dbo].[FactHoursWorkedByWeek] CHECK CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_EmployeeSK] ALTER TABLE [dbo].[FactHoursWorkedByWeek] WITH CHECK ADD CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_EndDateSK] FOREIGN KEY([EndDateSK]) REFERENCES [DimDate] ([DateSK]) ALTER TABLE [dbo].[FactHoursWorkedByWeek] CHECK CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_EndDateSK] ALTER TABLE [dbo].[FactHoursWorkedByWeek] WITH CHECK ADD CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_PositionSK] FOREIGN KEY([PositionSK]) REFERENCES [DimPosition] ([PositionSK]) ALTER TABLE [dbo].[FactHoursWorkedByWeek] CHECK CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_PositionSK] ALTER TABLE [dbo].[FactHoursWorkedByWeek] WITH CHECK ADD CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_StartDateSK] FOREIGN KEY([StartDateSK]) REFERENCES [DimDate] ([DateSK]) ALTER TABLE [dbo].[FactHoursWorkedByWeek] CHECK CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_StartDateSK] ALTER TABLE [dbo].[FactHoursWorkedByWeek] WITH CHECK ADD CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_TimeTypeSK] FOREIGN KEY([TimeTypeSK]) REFERENCES [DimTimeType] ([TimeTypeSK]) ALTER TABLE [dbo].[FactHoursWorkedByWeek] CHECK CONSTRAINT [FK_dbo_FactHoursWorkedByWeek_TimeTypeSK] EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'HoursByWeek' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek' EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain a row per employee per assignment per week (week is Saturday to Sunday) worked at the institution for regu' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek' EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Fact' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the employee''s Assignment, used to reference the assignment dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'AssignmentSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Employee, used to reference the employee dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'EmployeeSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the end date of the week which will be Sunday, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'EndDateSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number (in some cases the average hours not actual) of hours worked by an employee on an assignment for a week.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'HoursWorked' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key to the Fact.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'HoursWorkedByWeekSk' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the employee''s Position, used to reference the position dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'PositionSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the start date of the week which will be Saturday, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'StartDateSK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the type of hours worked by the employee, used to reference the time type dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactHoursWorkedByWeek', @level2type=N'COLUMN',@level2name=N'TimeTypeSK' |
Sample Data
| AssignmentSK | EmployeeSK | EndDateSK | HoursWorked | HoursWorkedByWeekSk | PositionSK | StartDateSK | TimeTypeSK |
| 111680 | 5846 | 20150808 | 11.43 | 360382 | 5620 | 20150802 | 24 |
| 182905 | 14499 | 20080126 | 22.75 | 671944 | 7422 | 20080120 | 24 |
| 201640 | 11985 | 20130511 | 6.86 | 1115801 | 5620 | 20130505 | 24 |
| 162049 | 9165 | 20071006 | 4.94 | 160165 | 6148 | 20070930 | 24 |
| 102597 | 5876 | 20111224 | 8.40 | 1082709 | 3634 | 20111218 | 24 |
| 196450 | 10900 | 20161029 | 3.43 | 219521 | 3078 | 20161023 | 24 |
| 98680 | 9455 | 20041009 | 10.48 | 253870 | 7368 | 20041003 | 24 |
| 229944 | 14934 | 20140628 | 20.53 | 461990 | 5541 | 20140622 | 24 |
| 173163 | 9058 | 20080209 | 21.00 | 796800 | 3871 | 20080203 | 24 |
| 119774 | 6048 | 20161022 | 6.59 | 312487 | 3990 | 20161016 | 24 |
| Powered by BI Documenter |
