DWOperations
 dbo.Staged_dbo_DimRelativeDay (Table)
Home  Diagrams  Documents  Images  DWOperations  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:  DWOperations   Tables   dbo.Staged_dbo_DimRelativeDay
  Properties
Property Value
Name Staged_dbo_DimRelativeDay
Schema dbo
Row Count 220031
Data Size 23040 KB
Index Size 80 KB
Create Date 5/29/2013 12:13 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
RelativeDay
varchar(15)
False
False
False
 
RelativeDayDate
date(10, 0)
False
False
False
 
RelativeDayDateSK
int(10, 0)
False
False
False
 
RelativeDayNumber
int(10, 0)
False
False
False
 
In Primary Key
RelativeDaySK
int(10, 0)
False
False
False
 
Term
varchar(6)
False
False
False
 
TermTitle
varchar(30)
False
False
False
 
TermTypeCode
varchar(3)
False
False
False
 
TermYear
varchar(4)
False
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
RelativeDaySK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.Staged_dbo_DimRelativeDay depends on)
Name Type
  Child Dependencies (objects that depend on dbo.Staged_dbo_DimRelativeDay)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[Staged_dbo_DimRelativeDay] Script Date: 03/09/2017 17:21:42 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Staged_dbo_DimRelativeDay](
    [RelativeDaySK] [int] NOT NULL,
    [Term] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermYear] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [TermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RelativeDayNumber] [int] NOT NULL,
    [RelativeDay] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RelativeDayDate] [date] NOT NULL,
    [RelativeDayDateSK] [int] NOT NULL,
 CONSTRAINT [PK_DimRelativeDay] PRIMARY KEY CLUSTERED 
(
    [RelativeDaySK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  Sample Data
RelativeDay RelativeDayDate RelativeDayDateSK RelativeDayNumber RelativeDaySK Term TermTitle TermTypeCode TermYear
Day -35 1981-04-02T00:00:00-05:00 19810402 -35 -35198103 19813 Spring Term 1981 3 1981
Day 111 1996-04-24T00:00:00-04:00 19960424 111 111199602 19962 Winter Term 1996 2 1996
Day 181 2015-11-15T00:00:00-05:00 20151115 181 181201503 20153 Summer Term 2015 3 2015
Day -88 1981-03-22T00:00:00-05:00 19810322 -88 -88198104 19814 Summer Term 1981 4 1981
Day 154 2006-10-11T00:00:00-04:00 20061011 154 154200603 20063 Summer Term 2006 3 2006
Day -235 1968-11-01T00:00:00-05:00 19681101 -235 -235196904 19694 Summer Term 1969 4 1969
Day -68 1996-04-18T00:00:00-04:00 19960418 -68 -68199604 19964 Summer Term 1996 4 1996
Day 262 1971-02-07T00:00:00-05:00 19710207 262 262197005 19705 Full Summer Term 1970 5 1970
Day -157 1964-01-16T00:00:00-05:00 19640116 -157 -157196404 19644 Summer Term 1964 4 1964
Day 88 1945-04-20T00:00:00-04:00 19450420 88 88194502 19452 Winter Term 1945 2 1945
Powered by BI Documenter