EnterpriseDW
 dbo.DimUser (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.DimUser
  Properties
Property Value
Name DimUser
Schema dbo
Row Count 68
Data Size 8 KB
Index Size 16 KB
Create Date 8/28/2013 9:53 AM
Description Dimension contains data regarding Users, one row per User.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ApplicationUserId
varchar(25)
False
False
False
 
Userid as assigned in Integrow
DomainUserId
varchar(25)
False
False
False
 
UserId used as Domain ID, including Domain
RowEndDate
datetime(23, 3)
True
False
False
 
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
char(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?
UserName
varchar(50)
False
False
False
 
User Last Name, First Name
In Primary Key
UserSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
UserSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimUser depends on)
Name Type
Table
  Child Dependencies (objects that depend on dbo.DimUser)
Name Type
TABLE
  Extended Properties
Object Property Value
DimUser
Display Name
User
DimUser
MS_Description
Dimension contains data regarding Users, one row per User.
DimUser
Table Description
Dimension contains data regarding Users.
DimUser
Table Type
Dimension
ApplicationUserId
Description
Userid as assigned in Integrow
ApplicationUserId
Display Name
ApplicationUserId
ApplicationUserId
ETL Rules
Only retrieve Active Users that with User_Type ME
ApplicationUserId
Example Values
ZCSMC
ApplicationUserId
MS_Description
Userid as assigned in Integrow
ApplicationUserId
Source Field Name
USER_ID
ApplicationUserId
Source System
DWStaging
ApplicationUserId
Source Table
SECURITY_USER_A2
DomainUserId
Description
UserId used as Domain ID, including Domain
DomainUserId
Display Name
DomainUserId
DomainUserId
ETL Rules
Retrieve data from Lookup_Security
DomainUserId
Example Values
ad/scowan
DomainUserId
MS_Description
UserId used as Domain ID, including Domain
DomainUserId
SCD Type
key
DomainUserId
Source System
Lookup_Security
RowEndDate
Description
When did this row become invalid? (12/31/9999 if current row)
RowEndDate
Display Folder
Exclude from cube
RowEndDate
Display Name
Row End Date
RowEndDate
ETL Rules
Standard SCD-2
RowEndDate
Example Values
1/14/1998, 12/31/9999
RowEndDate
MS_Description
When did this row become invalid? (12/31/9999 if current row)
RowEndDate
SCD Type
n/a
RowEndDate
Source System
Derived
RowIsCurrent
Description
Is this the current row for this member (Y/N)?
RowIsCurrent
Display Folder
Exclude from cube
RowIsCurrent
Display Name
Row Is Current
RowIsCurrent
ETL Rules
Standard SCD-2
RowIsCurrent
Example Values
Y, N
RowIsCurrent
MS_Description
Is this the current row for this member (Y/N)?
RowIsCurrent
SCD Type
n/a
RowIsCurrent
Source System
Derived
RowStartDate
Description
When did this row become valid for this member?
RowStartDate
Display Folder
Exclude from cube
RowStartDate
Display Name
Row Start Date
RowStartDate
ETL Rules
Standard SCD-2
RowStartDate
Example Values
1/24/2011
RowStartDate
MS_Description
When did this row become valid for this member?
RowStartDate
SCD Type
n/a
RowStartDate
Source System
Derived
UserName
Description
User Last Name, First Name
UserName
Display Name
UserName
UserName
Example Values
Cowan, Sophia
UserName
MS_Description
User Last Name, First Name
UserName
SCD Type
1
UserName
Source Field Name
LAST_NAME and FIRST_NAME
UserName
Source System
DWStaging
UserName
Source Table
SECURITY_USER-A2
UserSK
Description
Surrogate primary key
UserSK
Display Name
UserSK
UserSK
Example Values
1, 2, 3?
UserSK
MS_Description
Surrogate primary key
UserSK
SCD Type
key
UserSK
Source System
Derived
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimUser] Script Date: 03/09/2017 17:14:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimUser](
    [UserSK] [int] IDENTITY(1,1) NOT NULL,
    [DomainUserId] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ApplicationUserId] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [UserName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
 CONSTRAINT [PK_DimUser] PRIMARY KEY CLUSTERED 
(
    [UserSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Dimension contains data regarding Users, one row per User.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Dimension contains data regarding Users.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Userid as assigned in Integrow' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'ApplicationUserId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Only retrieve Active Users that with User_Type ME' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'ZCSMC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Userid as assigned in Integrow' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'USER_ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'SECURITY_USER_A2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'ApplicationUserId'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'UserId used as Domain ID, including Domain' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'DomainUserId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Retrieve data from Lookup_Security' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'ad/scowan' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'UserId used as Domain ID, including Domain' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Lookup_Security' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'DomainUserId'


EXEC sys.sp_addextendedproperty @name=N'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'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row End Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/14/1998, 12/31/9999' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


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


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowEndDate'


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


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Is Current' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Y, N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


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


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Start Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Standard SCD-2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/24/2011' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


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


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'User Last Name, First Name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'UserName' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cowan, Sophia' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'User Last Name, First Name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'LAST_NAME and FIRST_NAME' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'SECURITY_USER-A2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserName'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'UserSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserSK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1, 2, 3?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserSK'


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


EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimUser', @level2type=N'COLUMN',@level2name=N'UserSK'
  Sample Data
ApplicationUserId DomainUserId RowIsCurrent RowStartDate UserName UserSK
ZKSJW ad\swilson Y 2017-03-09T11:55:00-05:00 Wilson, Sheila 385
ZIDLW ad\dwindham Y 2017-03-09T11:55:00-05:00 Windham, Donald 370
ZIMMH ad\mhernand Y 2017-03-09T11:55:00-05:00 Hernandez, Maria 375
ZCIAP ad\ipeterso Y 2017-03-09T11:55:00-05:00 Peterson, Ian 417
ZTJDM ad\jmills Y 2017-03-09T11:55:00-05:00 Mills, Joe 425
ZISMT ad\stucker Y 2017-03-09T11:55:00-05:00 Tucker, Suzanne 380
ZBLMD ad\ldatz Y 2017-03-09T11:55:00-05:00 Datz, Lisa 398
ZLSCK ad\skeith Y 2017-03-09T11:55:00-05:00 Keith, Shelby 386
ZIRYS ad\rstewart Y 2017-03-09T11:55:00-05:00 Stewart, Ryan 378
ZPTWF ad\tmontagn Y 2017-03-09T11:55:00-05:00 Montagnino, Tracy 409
Powered by BI Documenter