EnterpriseDW
 dbo.FactCheckComponent (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  EnterpriseDW   Tables   dbo.FactCheckComponent
  Properties
Property Value
Name FactCheckComponent
Schema dbo
Row Count 18358301
Data Size 1080792 KB
Index Size 273512 KB
Create Date 2/10/2016 1:05 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Foreign Key
AssignmentSK
int(10, 0)
False
False
False
 
Key identifier for the employee's Assignment, used to reference the assignment dimension.
In Primary Key
CheckComponentSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
CheckComponentTypeSK
int(10, 0)
True
False
False
 
Key identifier for the type of component of a paycheck, will indicate gross, benefits, deductions and taxes.
Foreign Key
CheckDateSK
int(10, 0)
False
False
False
 
Key identifier for the date the employee was paid or the check date, used to reference the date dimension.
Foreign Key
CheckTypeSK
int(10, 0)
False
False
False
 
Key identifier for the type of check the employee received, used to reference the check type dimension.
ComponentAmount
numeric(11, 2)
False
False
False
 
The dollar value of the component of the employee's check.
Foreign Key
EmployeeSK
int(10, 0)
False
False
False
 
Key identifier for the Employee, used to reference the employee dimension.
Foreign Key
GLAccountSK
int(10, 0)
False
False
False
 
Key identifier for the full account number, used to reference the Chart of Accounts dimension.
Foreign Key
GlCodeSK
int(10, 0)
False
False
False
 
Key identifier for the General Ledger Code of the account (last 9 digits of the account), used to reference the GLCode dimensio
Foreign Key
OrgUnitSK
int(10, 0)
False
False
False
 
Key identifier for the Organizational Unit of the account (first 16 digits of the account), used to reference the OrgUnit Dimens
Foreign Key
PositionSK
int(10, 0)
False
False
False
 
Key identifier for the employee's Position, used to reference the position dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
CheckComponentSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
AssignmentSK
DimAssignment
AssignmentSK
True
CheckComponentTypeSK
DimCheckComponentType
CheckComponentTypeSK
True
CheckDateSK
DimDate
DateSK
True
CheckTypeSK
DimCheckType
CheckTypeSK
True
EmployeeSK
DimEmployee
EmployeeSK
True
GLAccountSK
DimChartOfAccount
GlAccountSK
True
GlCodeSK
DimGlCode
GlCodeSK
True
OrgUnitSK
DimOrgUnit
OrgUnitSK
True
PositionSK
DimPosition
PositionSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactCheckComponent depends on)
Name Type
Table
Table
Table
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactCheckComponent)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactCheckComponent
Display Name
CheckComponent
FactCheckComponent
Table Description
The fact will contain a row per Employee per Position per Assignment per pay check per budget component per account number for p
FactCheckComponent
Table Type
Fact
AssignmentSK
MS_Description
Key identifier for the employee's Assignment, used to reference the assignment dimension.
CheckComponentSK
MS_Description
Primary Key to the Fact.
CheckComponentTypeSK
MS_Description
Key identifier for the type of component of a paycheck, will indicate gross, benefits, deductions and taxes.
CheckDateSK
MS_Description
Key identifier for the date the employee was paid or the check date, used to reference the date dimension.
CheckTypeSK
MS_Description
Key identifier for the type of check the employee received, used to reference the check type dimension.
ComponentAmount
MS_Description
The dollar value of the component of the employee's check.
EmployeeSK
MS_Description
Key identifier for the Employee, used to reference the employee dimension.
GLAccountSK
MS_Description
Key identifier for the full account number, used to reference the Chart of Accounts dimension.
GlCodeSK
MS_Description
Key identifier for the General Ledger Code of the account (last 9 digits of the account), used to reference the GLCode dimensio
OrgUnitSK
MS_Description
Key identifier for the Organizational Unit of the account (first 16 digits of the account), used to reference the OrgUnit Dimens
PositionSK
MS_Description
Key identifier for the employee's Position, used to reference the position dimension.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactCheckComponent] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactCheckComponent](
    [CheckComponentSK] [int] IDENTITY(1,1) NOT NULL,
    [CheckDateSK] [int] NOT NULL,
    [CheckTypeSK] [int] NOT NULL,
    [CheckComponentTypeSK] [int] NULL,
    [EmployeeSK] [int] NOT NULL,
    [PositionSK] [int] NOT NULL,
    [AssignmentSK] [int] NOT NULL,
    [OrgUnitSK] [int] NOT NULL,
    [GlCodeSK] [int] NOT NULL,
    [GLAccountSK] [int] NOT NULL,
    [ComponentAmount] [numeric](11, 2) NOT NULL,
 CONSTRAINT [PK_dbo.FactCheckComponent] PRIMARY KEY NONCLUSTERED 
(
    [CheckComponentSK] 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].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_AssignmentSK] FOREIGN KEY([AssignmentSK])
REFERENCES [DimAssignment] ([AssignmentSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_AssignmentSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_CheckComponentTypeSK] FOREIGN KEY([CheckComponentTypeSK])
REFERENCES [DimCheckComponentType] ([CheckComponentTypeSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_CheckComponentTypeSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_CheckDateSK] FOREIGN KEY([CheckDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_CheckDateSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_CheckTypeSK] FOREIGN KEY([CheckTypeSK])
REFERENCES [DimCheckType] ([CheckTypeSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_CheckTypeSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_EmployeeSK] FOREIGN KEY([EmployeeSK])
REFERENCES [DimEmployee] ([EmployeeSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_EmployeeSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_GLAccountSK] FOREIGN KEY([GLAccountSK])
REFERENCES [DimChartOfAccount] ([GlAccountSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_GLAccountSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_GlCodeSK] FOREIGN KEY([GlCodeSK])
REFERENCES [DimGlCode] ([GlCodeSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_GlCodeSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_OrgUnitSK] FOREIGN KEY([OrgUnitSK])
REFERENCES [DimOrgUnit] ([OrgUnitSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_OrgUnitSK]
ALTER TABLE [dbo].[FactCheckComponent]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactCheckComponent_PositionSK] FOREIGN KEY([PositionSK])
REFERENCES [DimPosition] ([PositionSK])
ALTER TABLE [dbo].[FactCheckComponent] CHECK CONSTRAINT [FK_dbo_FactCheckComponent_PositionSK]


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'CheckComponent' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain a row per Employee per Position per Assignment per pay check per budget component per account number for p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent'


EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Fact' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent'


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'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'AssignmentSK'


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'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'CheckComponentSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the type of component of a paycheck, will indicate gross, benefits, deductions and taxes. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'CheckComponentTypeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the date the employee was paid or the check date, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'CheckDateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the type of check the employee received, used to reference the check type dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'CheckTypeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The dollar value of the component of the employee''s check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'ComponentAmount'


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'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'EmployeeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the full account number, used to reference the Chart of Accounts dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'GLAccountSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the General Ledger Code of the account (last 9 digits of the account), used to reference the GLCode dimensio' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'GlCodeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Organizational Unit of the account (first 16 digits of the account), used to reference the OrgUnit Dimens' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'OrgUnitSK'


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'FactCheckComponent', @level2type=N'COLUMN',@level2name=N'PositionSK'
  Sample Data
AssignmentSK CheckComponentSK CheckComponentTypeSK CheckDateSK CheckTypeSK ComponentAmount EmployeeSK GLAccountSK GlCodeSK OrgUnitSK PositionSK
-1 16995469 242 20101115 11 77.14 1410 2969881 5504 12484 -1
-1 10586874 120 20081126 11 862.08 10034 -1 -1 -1 -1
-1 14076075 216 20150227 11 543.84 15202 -1 -1 -1 -1
-1 13183698 732 20130815 11 29.00 472 -1 -1 -1 -1
-1 12012786 123 20110714 11 1128.12 10301 -1 -1 -1 -1
71614 1966189 41 20021115 11 946.96 2876 2762121 6100 13621 6790
-1 8560936 735 20040813 11 32.00 7337 -1 -1 -1 -1
-1 1091282 120 20001215 11 637.44 4754 2703371 6106 12725 -1
-1 5691412 551 20130430 11 6.64 6660 3035237 5942 12484 -1
191318 4919437 41 20110714 11 454.18 10536 3004772 6088 12681 2959
Powered by BI Documenter