EnterpriseDW
 dbo.FactPositionBudget (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.FactPositionBudget
  Properties
Property Value
Name FactPositionBudget
Schema dbo
Row Count 104818
Data Size 5416 KB
Index Size 1600 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
BudgetAmount
numeric(11, 2)
False
False
False
 
The number (in some cases the average hours not actual) of hours worked by an employee on an assignment for a week.
Foreign Key
CompensationTypeSK
int(10, 0)
False
False
False
 
Key identifier for the type of budget component, used to reference the budget component dimension.
Foreign Key
EndDateSK
int(10, 0)
False
False
False
 
Key identifier for the end date of the week which will be Sunday, used to reference the date dimension.
Foreign Key
GLAccountSK
int(10, 0)
False
False
False
 
Key identifier for the full account number, used to reference the Chart of Accounts dimension.
Foreign Key
GlCodeSK
int(10, 0)
False
False
False
 
Key identifier for the General Ledger Code of the account (last 9 digits of the account), used to reference the GLCode dimensio
Foreign Key
OrgUnitSK
int(10, 0)
False
False
False
 
Key identifier for the Organizational Unit of the account (first 16 digits of the account), used to reference the OrgUnit Dimens
In Primary Key
PositionBudgetSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key to the Fact.
Foreign Key
PositionSK
int(10, 0)
False
False
False
 
Key identifier for the employee's Position, used to reference the position dimension.
Foreign Key
StartDateSK
int(10, 0)
False
False
False
 
Key identifier for the start date of the week which will be Saturday, used to reference the date dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
PositionBudgetSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
CompensationTypeSK
DimCompensationType
CompensationTypeSK
True
EndDateSK
DimDate
DateSK
True
GLAccountSK
DimChartOfAccount
GlAccountSK
True
GlCodeSK
DimGlCode
GlCodeSK
True
OrgUnitSK
DimOrgUnit
OrgUnitSK
True
PositionSK
DimPosition
PositionSK
True
StartDateSK
DimDate
DateSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactPositionBudget depends on)
Name Type
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactPositionBudget)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactPositionBudget
Display Name
PositionBudget
FactPositionBudget
Table Description
The fact will contain a row per Position per Fiscal year per budget component that was budgeted for a position by the institutio
FactPositionBudget
Table Type
Fact
BudgetAmount
MS_Description
The number (in some cases the average hours not actual) of hours worked by an employee on an assignment for a week.
CompensationTypeSK
MS_Description
Key identifier for the type of budget component, used to reference the budget component dimension.
EndDateSK
MS_Description
Key identifier for the end date of the week which will be Sunday, used to reference the date dimension.
GLAccountSK
MS_Description
Key identifier for the full account number, used to reference the Chart of Accounts dimension.
GlCodeSK
MS_Description
Key identifier for the General Ledger Code of the account (last 9 digits of the account), used to reference the GLCode dimensio
OrgUnitSK
MS_Description
Key identifier for the Organizational Unit of the account (first 16 digits of the account), used to reference the OrgUnit Dimens
PositionBudgetSK
MS_Description
Primary Key to the Fact.
PositionSK
MS_Description
Key identifier for the employee's Position, used to reference the position dimension.
StartDateSK
MS_Description
Key identifier for the start date of the week which will be Saturday, used to reference the date dimension.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactPositionBudget] Script Date: 03/09/2017 17:14:58 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactPositionBudget](
    [PositionBudgetSK] [int] IDENTITY(1,1) NOT NULL,
    [PositionSK] [int] NOT NULL,
    [CompensationTypeSK] [int] NOT NULL,
    [StartDateSK] [int] NOT NULL,
    [EndDateSK] [int] NOT NULL,
    [OrgUnitSK] [int] NOT NULL,
    [GlCodeSK] [int] NOT NULL,
    [GLAccountSK] [int] NOT NULL,
    [BudgetAmount] [numeric](11, 2) NOT NULL,
 CONSTRAINT [PK_dbo.FactPositionBudget] PRIMARY KEY NONCLUSTERED 
(
    [PositionBudgetSK] 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].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_CompensationTypeSK] FOREIGN KEY([CompensationTypeSK])
REFERENCES [DimCompensationType] ([CompensationTypeSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_CompensationTypeSK]
ALTER TABLE [dbo].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_EndDateSK] FOREIGN KEY([EndDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_EndDateSK]
ALTER TABLE [dbo].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_GLAccountSK] FOREIGN KEY([GLAccountSK])
REFERENCES [DimChartOfAccount] ([GlAccountSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_GLAccountSK]
ALTER TABLE [dbo].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_GlCodeSK] FOREIGN KEY([GlCodeSK])
REFERENCES [DimGlCode] ([GlCodeSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_GlCodeSK]
ALTER TABLE [dbo].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_OrgUnitSK] FOREIGN KEY([OrgUnitSK])
REFERENCES [DimOrgUnit] ([OrgUnitSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_OrgUnitSK]
ALTER TABLE [dbo].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_PositionSK] FOREIGN KEY([PositionSK])
REFERENCES [DimPosition] ([PositionSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_PositionSK]
ALTER TABLE [dbo].[FactPositionBudget]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactPositionBudget_StartDateSK] FOREIGN KEY([StartDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactPositionBudget] CHECK CONSTRAINT [FK_dbo_FactPositionBudget_StartDateSK]


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


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The fact will contain a row per Position per Fiscal year per budget component that was budgeted for a position by the institutio' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The number (in some cases the average hours not actual) of hours worked by an employee on an assignment for a week.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'BudgetAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the type of budget component, used to reference the budget component dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'CompensationTypeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the end date of the week which will be Sunday, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'EndDateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the full account number, used to reference the Chart of Accounts dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'GLAccountSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the General Ledger Code of the account (last 9 digits of the account), used to reference the GLCode dimensio' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'GlCodeSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Organizational Unit of the account (first 16 digits of the account), used to reference the OrgUnit Dimens' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'OrgUnitSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key to the Fact.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'PositionBudgetSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the employee''s Position, used to reference the position dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'PositionSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the start date of the week which will be Saturday, used to reference the date dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactPositionBudget', @level2type=N'COLUMN',@level2name=N'StartDateSK'
  Sample Data
BudgetAmount CompensationTypeSK EndDateSK GLAccountSK GlCodeSK OrgUnitSK PositionBudgetSK PositionSK StartDateSK
0.00 77 20150630 3108828 6347 15060 80921 4657 20140701
0.00 81 20110630 2984936 6096 14207 57017 2187 20101001
0.00 81 20080630 2895139 6096 14293 56892 1860 20071001
0.00 77 20090630 2923279 6338 14116 69248 2354 20090315
0.00 77 20080630 2881752 6088 12736 71560 7121 20070701
0.00 17 20110630 2982897 6096 13646 41581 218 20100701
0.00 77 20100630 2953450 6103 14479 61634 5172 20090701
0.00 100 20130630 3034272 6088 12672 8260 6477 20120701
0.00 77 20090630 2922549 6101 14439 92916 380 20080701
0.00 37 20091231 2954795 6100 14227 46981 4009 20090701
Powered by BI Documenter