EnterpriseDW
 dbo.Configuration_Color (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.Configuration_Color
  Properties
Property Value
Name Configuration_Color
Schema dbo
Row Count 3
Data Size 8 KB
Index Size 8 KB
Create Date 9/5/2012 8:22 AM
Description The Color Configuration dimension provides color identity for the institution, used by SQL Server Reporting Services to determine color appearence.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
BackgroundAlternateColor
varchar(30)
True
False
False
 
The color indication to be used in the report color group for detail lines on a report and will usually be alternated with the BackgroundColor. The format can be either a standard color label used by SQL Reporting Services or HTML standard color format.
BackgroundColor
varchar(30)
True
False
False
 
The color indication to be used in the report color group for the default back ground color. The format can be either a standard color label used by SQL Reporting Services or HTML standard color format.
Band1Color
varchar(30)
True
False
False
 
The color indication to be used in the report color group for report headings. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band2Color
varchar(30)
True
False
False
 
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band3Color
varchar(30)
True
False
False
 
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band4Color
varchar(30)
True
False
False
 
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band5Color
varchar(30)
True
False
False
 
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band6Color
varchar(30)
True
False
False
 
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
ReportType
varchar(30)
False
False
False
 
A textual identifier for a report color configuration group.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Configuration_Color depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Configuration_Color)
Name Type
  Extended Properties
Object Property Value
Configuration_Color
MS_Description
The Color Configuration dimension provides color identity for the institution, used by SQL Server Reporting Services to determine color appearence.
BackgroundAlternateColor
MS_Description
The color indication to be used in the report color group for detail lines on a report and will usually be alternated with the BackgroundColor. The format can be either a standard color label used by SQL Reporting Services or HTML standard color format.
BackgroundColor
MS_Description
The color indication to be used in the report color group for the default back ground color. The format can be either a standard color label used by SQL Reporting Services or HTML standard color format.
Band1Color
MS_Description
The color indication to be used in the report color group for report headings. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band2Color
MS_Description
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band3Color
MS_Description
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band4Color
MS_Description
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band5Color
MS_Description
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
Band6Color
MS_Description
The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.
ReportType
MS_Description
A textual identifier for a report color configuration group.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Configuration_Color] Script Date: 03/09/2017 17:14:53 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Configuration_Color](
    [ReportType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BackgroundColor] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BackgroundAlternateColor] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Band1Color] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Band2Color] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Band3Color] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Band4Color] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Band5Color] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Band6Color] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Color Configuration dimension provides color identity for the institution, used by SQL Server Reporting Services to determine color appearence.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for detail lines on a report and will usually be alternated with the BackgroundColor. The format can be either a standard color label used by SQL Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'BackgroundAlternateColor'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for the default back ground color. The format can be either a standard color label used by SQL Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'BackgroundColor'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for report headings. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'Band1Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'Band2Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'Band3Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'Band4Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'Band5Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The color indication to be used in the report color group for highlighting drill down levels of a report and are expected to be gradations on one color. The format can be either a standard color label used by SQl Reporting Services or HTML standard color format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'Band6Color'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A textual identifier for a report color configuration group.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Configuration_Color', @level2type=N'COLUMN',@level2name=N'ReportType'
  Sample Data
CheckType CheckTypeCode CheckTypeCodeAK RowEndDate RowIsCurrent RowStartDate
Regular Check RG RG 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Special Payroll SP SP 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Awards AW AW 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Endowed Chair EC EC 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Monthly Benefit MO MO 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Tuition Reimbursement TR TR 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Terminal Vacation TL TL 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Professional Leave Payments PL PL 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Other OT OT 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Hmo Bonus HB HB 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:16:00-05:00
Powered by BI Documenter