EnterpriseDW
 dbo.DimCheckComponentType (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.DimCheckComponentType
  Properties
Property Value
Name DimCheckComponentType
Schema dbo
Row Count 739
Data Size 128 KB
Index Size 24 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
CheckComponentTypeAK
varchar(18)
False
False
False
 
Business key for the check component type, this will contain the first 18 positions of the pay check component type code.
In Primary Key
CheckComponentTypeSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
ComponentCategory
varchar(15)
False
False
False
 
Descriptive name for the budget component, used by the Human Resouces department to budget employee expenses.
ComponentLine
varchar(50)
False
False
False
 
Descriptive name for the type of line for a pay check calculation.
ComponentLineCode
varchar(3)
False
False
False
 
An indication of the type of line for a pay check calculation.
ComponentOne
varchar(50)
False
False
False
 
Descriptive name of the high level component grouping of a pay check calculation.
ComponentOneCode
varchar(8)
False
False
False
 
An indication of the high level component grouping of a pay check calculation.
ComponentTwo
varchar(50)
False
False
False
 
Descriptive name of the lower level component grouping of a pay check calculation.
ComponentTwoCode
varchar(8)
False
False
False
 
An indication of the lower level component grouping of a pay check calculation.
RowEndDate
datetime(23, 3)
False
False
False
 
('12/31/9999')
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
nchar(1)
False
False
False
 
Is this the current row for this member (Y/N)?
RowStartDate
datetime(23, 3)
False
False
False
 
When did this row become valid for this member?
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
CheckComponentTypeSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimCheckComponentType depends on)
Name Type
Table
  Child Dependencies (objects that depend on dbo.DimCheckComponentType)
Name Type
TABLE
  Extended Properties
Object Property Value
DimCheckComponentType
Display Name
CheckCmpntType
DimCheckComponentType
Table Description
The dimension will contain a row for every combination of Pay Check Component Line, Pay Check Component 1 and Pay Check Componen
DimCheckComponentType
Table Type
Dimension
CheckComponentTypeAK
MS_Description
Business key for the check component type, this will contain the first 18 positions of the pay check component type code.
CheckComponentTypeSK
MS_Description
Surrogate primary key
ComponentCategory
MS_Description
Descriptive name for the budget component, used by the Human Resouces department to budget employee expenses.
ComponentLine
MS_Description
Descriptive name for the type of line for a pay check calculation.
ComponentLineCode
MS_Description
An indication of the type of line for a pay check calculation.
ComponentOne
MS_Description
Descriptive name of the high level component grouping of a pay check calculation.
ComponentOneCode
MS_Description
An indication of the high level component grouping of a pay check calculation.
ComponentTwo
MS_Description
Descriptive name of the lower level component grouping of a pay check calculation.
ComponentTwoCode
MS_Description
An indication of the lower level component grouping of a pay check calculation.
RowEndDate
MS_Description
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
MS_Description
Is this the current row for this member (Y/N)?
RowStartDate
MS_Description
When did this row become valid for this member?
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimCheckComponentType] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimCheckComponentType](
    [CheckComponentTypeSK] [int] IDENTITY(1,1) NOT NULL,
    [CheckComponentTypeAK] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentLineCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentLine] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentOneCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentOne] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentTwoCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentTwo] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ComponentCategory] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.DimCheckComponentType] PRIMARY KEY CLUSTERED 
(
    [CheckComponentTypeSK] 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].[DimCheckComponentType] ADD  DEFAULT ('12/31/9999') FOR [RowEndDate]


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


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The dimension will contain a row for every combination of Pay Check Component Line, Pay Check Component 1 and Pay Check Componen' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for the check component type, this will contain the first 18 positions of the pay check component type code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'CheckComponentTypeAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'CheckComponentTypeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the budget component, used by the Human Resouces department to budget employee expenses.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentCategory'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of line for a pay check calculation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentLine'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the type of line for a pay check calculation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentLineCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the high level component grouping of a pay check calculation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentOne'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the high level component grouping of a pay check calculation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentOneCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name of the lower level component grouping of a pay check calculation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentTwo'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the lower level component grouping of a pay check calculation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'ComponentTwoCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckComponentType', @level2type=N'COLUMN',@level2name=N'RowStartDate'
  Sample Data
CheckComponentTypeAK CheckComponentTypeSK ComponentCategory ComponentLine ComponentLineCode ComponentOne ComponentOneCode ComponentTwo ComponentTwoCode RowEndDate RowIsCurrent RowStartDate
03DENTAL DHMOCH 213 Benefit Benefit 03 College Portion Dental Non Hdv Or Dual DENTAL Dental Dhmo Employee And Child DHMOCH 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
20PROF N/A 733 Time Time Type Used 20 Professional Leave PROF N/A N/A 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
16HTHHBUEOHLTHHBU 672 Benefit Benefit Accounts 16 Hmo Barg Unit Employee Only /Pd By Coll HTHHBUEO Hmo Barg Unit Pd By College HLTHHBU 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
13GARNISH USDED 15 435 Deduction Post Tax Deduction 13 Garnishments GARNISH Student Loan/Us Dept Of Ed/15% Dis Net USDED 15 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
07HEALTH HMOBU CH 479 Deduction Pre Tax Deduction 07 College's Health Portion/Pd. By College HEALTH Hmo Barg Unit Employee + Child HMOBU CH 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
08DEPCARE DEPCARE 126 Deduction Pre Tax Deduction Adjustment 08 Dependent Care DEPCARE Dependent Care DEPCARE 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
16HTHPBUSPPPOSPBU 679 Benefit Benefit Accounts 16 Ppo Barg Unit Ee+Spouse/Pd By Coll HTHPBUSP Ppo Barg Unit Ees Paid By College PPOSPBU 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
13DENTAL DHMOSHDV 320 Deduction Post Tax Deduction 13 College Portion Dental Non Hdv Or Dual DENTAL Dhmo Deduction For Spouse Hdv DHMOSHDV 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
13CHILDSUPCHSP WDC 306 Deduction Post Tax Deduction 13 Child Support CHILDSUP Child Supp/Washington Dc Ch Supp CHSP WDC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
08VISION VISFAHDV 197 Deduction Pre Tax Deduction Adjustment 08 Vision Insurance VISION Vision Deduction For Family Hdv VISFAHDV 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Powered by BI Documenter