|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | DimCheckType |
| Schema | dbo |
| Row Count | 17 |
| Data Size | 8 KB |
| Index Size | 8 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 |
||
 |
|
CheckType |
varchar(30) |
False |
False |
False |
Descriptive name for the type of check. |
||
|
|
CheckTypeCode |
varchar(3) |
False |
False |
False |
Check Type Code |
||
|
|
CheckTypeCodeAK |
varchar(3) |
False |
False |
False |
Business key for the check type, this will contain the code for the check type. |
||
 |
|
CheckTypeSK |
int(10, 0) |
False |
False |
False |
(1 / 1) |
Surrogate primary key |
|
|
|
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 |
CheckTypeSK |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.DimCheckType depends on)
| Name | Type |
Table |
|
Table |
|
Table |
Child Dependencies (objects that depend on dbo.DimCheckType)
| Name | Type |
TABLE |
|
TABLE |
|
TABLE |
Extended Properties
| Object | Property | Value |
DimCheckType |
Display Name |
CheckType |
DimCheckType |
Table Description |
The dimension will contain a row for every entry on the generic table 'CHECK-TYPE'. |
DimCheckType |
Table Type |
Dimension |
CheckType |
MS_Description |
Descriptive name for the type of check. |
CheckTypeCode |
MS_Description |
Check Type Code |
CheckTypeCodeAK |
MS_Description |
Business key for the check type, this will contain the code for the check type. |
CheckTypeSK |
MS_Description |
Surrogate primary key |
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].[DimCheckType] Script Date: 03/09/2017 17:14:54 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[DimCheckType]( [CheckTypeSK] [int] IDENTITY(1,1) NOT NULL, [CheckTypeCodeAK] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CheckTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CheckType] [varchar](30) 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.DimCheckType] PRIMARY KEY CLUSTERED ( [CheckTypeSK] 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].[DimCheckType] ADD DEFAULT ('12/31/9999') FOR [RowEndDate] EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'CheckType' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType' EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The dimension will contain a row for every entry on the generic table ''CHECK-TYPE''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType' EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of check.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType', @level2type=N'COLUMN',@level2name=N'CheckType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Check Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType', @level2type=N'COLUMN',@level2name=N'CheckTypeCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key for the check type, this will contain the code for the check type.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType', @level2type=N'COLUMN',@level2name=N'CheckTypeCodeAK' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimCheckType', @level2type=N'COLUMN',@level2name=N'CheckTypeSK' 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'DimCheckType', @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'DimCheckType', @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'DimCheckType', @level2type=N'COLUMN',@level2name=N'RowStartDate' |
Sample Data
| CheckType | CheckTypeCode | CheckTypeCodeAK | CheckTypeSK | RowEndDate | RowIsCurrent | RowStartDate |
| Manual | MA | MA | 6 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Severance Payment | SV | SV | 14 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Terminal Sick Leave | TS | TS | 4 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Monthly Benefit | MO | MO | 7 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Endowed Chair | EC | EC | 8 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Special Payroll | SP | SP | 13 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Awards | AW | AW | 2 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Terminal Vacation | TL | TL | 15 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Overpayment | OV | OV | 9 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Hmo Bonus | HB | HB | 5 | 9999-12-31T23:59:00-05:00 | Y | 2017-03-09T12:16:00-05:00 |
| Powered by BI Documenter |
