EnterpriseDW
 dbo.FactOrgUnit_User_Bridge (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.FactOrgUnit_User_Bridge
  Properties
Property Value
Name FactOrgUnit_User_Bridge
Schema dbo
Row Count 130013
Data Size 2528 KB
Index Size 8 KB
Create Date 8/28/2013 9:53 AM
Description This table will provide a bridge between Users and the Org Units to which they have access. Will contain one row per Org Unit per Use that has access to the Org Unit.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
Foreign Key
OrgUnitSK
int(10, 0)
False
False
False
 
Key to OrgUnit Dimension
Foreign Key
UserSK
int(10, 0)
False
False
False
 
Key to User Dimension
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
OrgUnitSK
DimOrgUnit
OrgUnitSK
True
UserSK
DimUser
UserSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactOrgUnit_User_Bridge depends on)
Name Type
Table
Table
  Child Dependencies (objects that depend on dbo.FactOrgUnit_User_Bridge)
Name Type
TABLE
TABLE
  Extended Properties
Object Property Value
FactOrgUnit_User_Bridge
Display Name
OrgUnit_User_Bridge
FactOrgUnit_User_Bridge
MS_Description
This table will provide a bridge between Users and the Org Units to which they have access. Will contain one row per Org Unit per Use that has access to the Org Unit.
FactOrgUnit_User_Bridge
Table Description
This table will provide a bridge between Users and the Org Units they have access to.
FactOrgUnit_User_Bridge
Table Type
Fact
OrgUnitSK
Description
Key to OrgUnit Dimension
OrgUnitSK
Display Name
OrgUnitSK
OrgUnitSK
Example Values
1,2,3
OrgUnitSK
MS_Description
Key to OrgUnit Dimension
OrgUnitSK
Source System
Derived
UserSK
Description
Key to User Dimension
UserSK
Display Name
UserSK
UserSK
Example Values
1,2,3
UserSK
MS_Description
Key to User Dimension
UserSK
Source System
Derived
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactOrgUnit_User_Bridge] Script Date: 03/09/2017 17:14:58 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactOrgUnit_User_Bridge](
    [OrgUnitSK] [int] NOT NULL,
    [UserSK] [int] NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[FactOrgUnit_User_Bridge]  WITH CHECK ADD  CONSTRAINT [FK_FactOrgUnit_User_Bridge_DimOrgUnit] FOREIGN KEY([OrgUnitSK])
REFERENCES [DimOrgUnit] ([OrgUnitSK])
ALTER TABLE [dbo].[FactOrgUnit_User_Bridge] CHECK CONSTRAINT [FK_FactOrgUnit_User_Bridge_DimOrgUnit]
ALTER TABLE [dbo].[FactOrgUnit_User_Bridge]  WITH CHECK ADD  CONSTRAINT [FK_FactOrgUnit_User_Bridge_DimUser] FOREIGN KEY([UserSK])
REFERENCES [DimUser] ([UserSK])
ALTER TABLE [dbo].[FactOrgUnit_User_Bridge] CHECK CONSTRAINT [FK_FactOrgUnit_User_Bridge_DimUser]


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This table will provide a bridge between Users and the Org Units to which they have access. Will contain one row per Org Unit per Use that has access to the Org Unit.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactOrgUnit_User_Bridge'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'This table will provide a bridge between Users and the Org Units they have access to.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactOrgUnit_User_Bridge'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to OrgUnit Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactOrgUnit_User_Bridge', @level2type=N'COLUMN',@level2name=N'OrgUnitSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to OrgUnit Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactOrgUnit_User_Bridge', @level2type=N'COLUMN',@level2name=N'OrgUnitSK'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to User Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactOrgUnit_User_Bridge', @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'FactOrgUnit_User_Bridge', @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'FactOrgUnit_User_Bridge', @level2type=N'COLUMN',@level2name=N'UserSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to User Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactOrgUnit_User_Bridge', @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'FactOrgUnit_User_Bridge', @level2type=N'COLUMN',@level2name=N'UserSK'
  Sample Data
OrgUnitSK UserSK
12695 404
14448 416
14341 386
14077 416
15955 426
19800 419
14106 366
15824 366
18448 400
18003 414
Powered by BI Documenter