EnterpriseDW
 dbo.FactGlTransactions (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.FactGlTransactions
  Properties
Property Value
Name FactGlTransactions
Schema dbo
Row Count 7688483
Data Size 1338784 KB
Index Size 16 KB
Create Date 8/28/2013 9:53 AM
Description The record of a posted journal line, one record for each Journal Line. Will contain all the records for the General Ledger Transactions that have been posted. Data will be added daily.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ActualsAmount
numeric(11, 2)
True
False
False
 
The amount on the journal line if the journal type is not BT, EN or CO.
ActualsAmountCredit
numeric(11, 2)
True
False
False
 
The Actuals Amount if it was negative without a sign. Journal types such as AP, CC, JE, PR.
ActualsAmountDebit
numeric(11, 2)
True
False
False
 
The Actuals Amount if it is positive. Journal types such as AP, CC, JE, PR.
BudgetAmount
numeric(11, 2)
True
False
False
 
The amount on the journal line if the journal typ e is BT=Budget Transfer
BudgetAmountCredit
numeric(11, 2)
True
False
False
 
The Budget Amount if it was negative without a sign
BudgetAmountDebit
numeric(11, 2)
True
False
False
 
The BudgetAmount if it is positive
CommitmentAmount
numeric(11, 2)
True
False
False
 
The amount on the journal line if the journal type is CO=Commitment
CommitmentAmountCredit
numeric(11, 2)
True
False
False
 
The Commitment Amount if it was negative without a sign
CommitmentAmountDebit
numeric(11, 2)
True
False
False
 
The Commitment Amount if it is positive
Foreign Key
DateSK
int(10, 0)
False
False
False
 
Key to the Date dimension
EncumbranceAmount
numeric(11, 2)
True
False
False
 
The amount on the journal line if the journal type is EN=Encumbrance
EncumbranceAmountCredit
numeric(11, 2)
True
False
False
 
The Encumbrance Amount if it was negative without a sign
EncumbranceAmountDebit
numeric(11, 2)
True
False
False
 
The Encumbrance Amount if it is positive
Foreign Key
GlAccountSK
int(10, 0)
False
False
False
 
Key to ChartOfAccount dimension
Foreign Key
GlCodeSK
int(10, 0)
False
False
False
 
Key to GlCode dimension
Foreign Key
GlDetailSK
int(10, 0)
False
False
False
 
Key to GL Detail
GlTransactionsSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key for the GL Transactions fact.
JournalAmount
numeric(11, 2)
True
False
False
 
The amount on the journal line
JournalAmountCredit
numeric(11, 2)
True
False
False
 
The Journal Amount if it was negative without a sign
JournalAmountDebit
numeric(11, 2)
True
False
False
 
The Journal Amount if it is positive
Foreign Key
OrgUnitSK
int(10, 0)
False
False
False
 
Key to OrgUnit Dimension
Foreign Key
PostedDateSK
int(10, 0)
False
False
False
 
Key to Date dimension.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
GlAccountSK
DimChartOfAccount
GlAccountSK
True
DateSK
DimDate
DateSK
True
PostedDateSK
DimDate
DateSK
True
GlCodeSK
DimGlCode
GlCodeSK
True
GlDetailSK
DimGlTransDetail
GlDetailSK
True
OrgUnitSK
DimOrgUnit
OrgUnitSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactGlTransactions depends on)
Name Type
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactGlTransactions)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactGlTransactions
Display Name
GeneralLedger
FactGlTransactions
MS_Description
The record of a posted journal line, one record for each Journal Line. Will contain all the records for the General Ledger Transactions that have been posted. Data will be added daily.
FactGlTransactions
Table Description
The record of a posted journal line, one record for each Journal Line
FactGlTransactions
Table Type
Fact
ActualsAmount
Description
The amount on the journal line if the journal type is not BT, EN or CO
ActualsAmount
Display Name
ActualsAmount
ActualsAmount
ETL Rules
AMOUNT if Journal Type = AP, CC, JE or PR
ActualsAmount
Example Values
60.00, 75.00
ActualsAmount
MS_Description
The amount on the journal line if the journal type is not BT, EN or CO.
ActualsAmount
Source Field Name
AMOUNT
ActualsAmount
Source System
DWStaging
ActualsAmount
Source Table
GL_TRANS_FILE
ActualsAmountCredit
Description
The Actuals Amount if it was negative without a sign
ActualsAmountCredit
ETL Rules
AMOUNT if < 0 and Journal Type = AP, CC, JE or PR
ActualsAmountCredit
Example Values
60.00, 75.00
ActualsAmountCredit
MS_Description
The Actuals Amount if it was negative without a sign. Journal types such as AP, CC, JE, PR.
ActualsAmountCredit
Source Field Name
AMOUNT
ActualsAmountCredit
Source System
DWStaging
ActualsAmountCredit
Source Table
GL_TRANS_FILE
ActualsAmountDebit
Description
The Actuals Amount if it is positive
ActualsAmountDebit
ETL Rules
AMOUNT if > 0 and Journal Type = AP, CC, JE or PR
ActualsAmountDebit
Example Values
60.00, 75.00
ActualsAmountDebit
MS_Description
The Actuals Amount if it is positive. Journal types such as AP, CC, JE, PR.
ActualsAmountDebit
Source Field Name
AMOUNT
ActualsAmountDebit
Source System
DWStaging
ActualsAmountDebit
Source Table
GL_TRANS_FILE
BudgetAmount
Description
The amount on the journal line if the journal typ e is BT
BudgetAmount
Display Name
BudgetAmount
BudgetAmount
ETL Rules
AMOUNT if Journal Type = BT
BudgetAmount
Example Values
100, -245.78
BudgetAmount
MS_Description
The amount on the journal line if the journal typ e is BT=Budget Transfer
BudgetAmount
Source Field Name
AMOUNT
BudgetAmount
Source System
DWStaging
BudgetAmount
Source Table
GL_TRANS_FILE
BudgetAmountCredit
Description
The Budget Amount if it was negative without a sign
BudgetAmountCredit
ETL Rules
AMOUNT if < 0 and Journal Type = BT
BudgetAmountCredit
Example Values
654
BudgetAmountCredit
MS_Description
The Budget Amount if it was negative without a sign
BudgetAmountCredit
Source Field Name
AMOUNT
BudgetAmountCredit
Source System
DWStaging
BudgetAmountCredit
Source Table
GL_TRANS_FILE
BudgetAmountDebit
Description
The BudgetAmount if it is positive
BudgetAmountDebit
ETL Rules
AMOUNT if > 0 and if Journal Type = BT
BudgetAmountDebit
Example Values
190
BudgetAmountDebit
MS_Description
The BudgetAmount if it is positive
BudgetAmountDebit
Source Field Name
AMOUNT
BudgetAmountDebit
Source System
DWStaging
BudgetAmountDebit
Source Table
GL_TRANS_FILE
CommitmentAmount
Description
The amount on the journal line if the journal type is CO
CommitmentAmount
Display Name
CommitmentAmount
CommitmentAmount
ETL Rules
AMOUNT if Journal Type = CO
CommitmentAmount
Example Values
1,0, -100.67
CommitmentAmount
MS_Description
The amount on the journal line if the journal type is CO=Commitment
CommitmentAmount
Source Field Name
AMOUNT
CommitmentAmount
Source System
DWStaging
CommitmentAmount
Source Table
GL_TRANS_FILE
CommitmentAmountCredit
Description
The Commitment Amount if it was negative without a sign
CommitmentAmountCredit
ETL Rules
AMOUNT if < 0 and Journal Type = CO
CommitmentAmountCredit
Example Values
60.00, 75.00
CommitmentAmountCredit
MS_Description
The Commitment Amount if it was negative without a sign
CommitmentAmountCredit
Source Field Name
AMOUNT
CommitmentAmountCredit
Source System
DWStaging
CommitmentAmountCredit
Source Table
GL_TRANS_FILE
CommitmentAmountDebit
Description
The Commitment Amount if it is positive
CommitmentAmountDebit
ETL Rules
AMOUNT if > 0 and Journal Type = CO
CommitmentAmountDebit
Example Values
60.00, 75.00
CommitmentAmountDebit
MS_Description
The Commitment Amount if it is positive
CommitmentAmountDebit
Source Field Name
AMOUNT
CommitmentAmountDebit
Source System
DWStaging
CommitmentAmountDebit
Source Table
GL_TRANS_FILE
DateSK
Description
Key to the Date dimension
DateSK
Display Name
DateSK
DateSK
ETL Rules
Use calendar period and add 01
DateSK
Example Values
1,2,3
DateSK
MS_Description
Key to the Date dimension
DateSK
Source System
Derived
EncumbranceAmount
Description
The amount on the journal line if the journal type is EN
EncumbranceAmount
Display Name
EncumbranceAmount
EncumbranceAmount
ETL Rules
AMOUNT if Journal Type = EN
EncumbranceAmount
Example Values
0, 3.0, 3.5
EncumbranceAmount
MS_Description
The amount on the journal line if the journal type is EN=Encumbrance
EncumbranceAmount
Source Field Name
AMOUNT
EncumbranceAmount
Source System
DWStaging
EncumbranceAmount
Source Table
GL_TRANS_FILE
EncumbranceAmountCredit
Description
The Encumbrance Amount if it was negative without a sign
EncumbranceAmountCredit
ETL Rules
AMOUNT if < 0 and Journal Type = EN
EncumbranceAmountCredit
Example Values
60.00, 75.00
EncumbranceAmountCredit
MS_Description
The Encumbrance Amount if it was negative without a sign
EncumbranceAmountCredit
Source Field Name
AMOUNT
EncumbranceAmountCredit
Source System
DWStaging
EncumbranceAmountCredit
Source Table
GL_TRANS_FILE
EncumbranceAmountDebit
Description
The Encumbrance Amount if it is positive
EncumbranceAmountDebit
ETL Rules
AMOUNT if > 0 and Journal Type = EN
EncumbranceAmountDebit
Example Values
60.00, 75.00
EncumbranceAmountDebit
MS_Description
The Encumbrance Amount if it is positive
EncumbranceAmountDebit
Source Field Name
AMOUNT
EncumbranceAmountDebit
Source System
DWStaging
EncumbranceAmountDebit
Source Table
GL_TRANS_FILE
GlAccountSK
Description
Key to ChartOfAccount dimension
GlAccountSK
Display Name
GlAccountSK
GlAccountSK
Example Values
1,2,3
GlAccountSK
MS_Description
Key to ChartOfAccount dimension
GlAccountSK
Source System
Derived
GlCodeSK
Description
Key to GlCode dimension
GlCodeSK
Display Name
GlCodeSK
GlCodeSK
Example Values
1,2,3
GlCodeSK
MS_Description
Key to GlCode dimension
GlCodeSK
Source System
Derived
GlDetailSK
Description
Key to GL Detail
GlDetailSK
Display Name
GlDetailSK
GlDetailSK
Example Values
1,2,3
GlDetailSK
MS_Description
Key to GL Detail
GlDetailSK
Source System
Derived
GlTransactionsSK
MS_Description
Primary Key for the GL Transactions fact.
JournalAmount
Description
The amount on the journal line
JournalAmount
Display Name
JournalAmount
JournalAmount
ETL Rules
AMOUNT
JournalAmount
Example Values
100
JournalAmount
MS_Description
The amount on the journal line
JournalAmount
SCD Type
1
JournalAmount
Source Field Name
AMOUNT
JournalAmount
Source System
DWStaging
JournalAmount
Source Table
GL_TRANS_FILE
JournalAmountCredit
Description
The Journal Amount if it was negative without a sign
JournalAmountCredit
ETL Rules
AMOUNT if < 0
JournalAmountCredit
Example Values
60.00, 75.00
JournalAmountCredit
MS_Description
The Journal Amount if it was negative without a sign
JournalAmountCredit
Source Field Name
AMOUNT
JournalAmountCredit
Source System
DWStaging
JournalAmountCredit
Source Table
GL_TRANS_FILE
JournalAmountDebit
Description
The Journal Amount if it is positive
JournalAmountDebit
ETL Rules
AMOUNT if > 0
JournalAmountDebit
Example Values
60.00, 75.00
JournalAmountDebit
MS_Description
The Journal Amount if it is positive
JournalAmountDebit
Source Field Name
AMOUNT
JournalAmountDebit
Source System
DWStaging
JournalAmountDebit
Source Table
GL_TRANS_FILE
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
PostedDateSK
Description
Key to Date dimension
PostedDateSK
Display Name
PostedDateSK
PostedDateSK
ETL Rules
Posted_date
PostedDateSK
Example Values
1,2,3
PostedDateSK
MS_Description
Key to Date dimension.
PostedDateSK
Source System
Derived
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactGlTransactions] Script Date: 03/09/2017 17:14:58 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactGlTransactions](
    [GlTransactionsSK] [int] IDENTITY(1,1) NOT NULL,
    [DateSK] [int] NOT NULL,
    [PostedDateSK] [int] NOT NULL,
    [GlDetailSK] [int] NOT NULL,
    [OrgUnitSK] [int] NOT NULL,
    [GlCodeSK] [int] NOT NULL,
    [GlAccountSK] [int] NOT NULL,
    [JournalAmount] [numeric](11, 2) NULL,
    [BudgetAmount] [numeric](11, 2) NULL,
    [CommitmentAmount] [numeric](11, 2) NULL,
    [EncumbranceAmount] [numeric](11, 2) NULL,
    [ActualsAmount] [numeric](11, 2) NULL,
    [BudgetAmountDebit] [numeric](11, 2) NULL,
    [BudgetAmountCredit] [numeric](11, 2) NULL,
    [ActualsAmountDebit] [numeric](11, 2) NULL,
    [ActualsAmountCredit] [numeric](11, 2) NULL,
    [CommitmentAmountDebit] [numeric](11, 2) NULL,
    [CommitmentAmountCredit] [numeric](11, 2) NULL,
    [EncumbranceAmountDebit] [numeric](11, 2) NULL,
    [EncumbranceAmountCredit] [numeric](11, 2) NULL,
    [JournalAmountDebit] [numeric](11, 2) NULL,
    [JournalAmountCredit] [numeric](11, 2) NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[FactGlTransactions]  WITH CHECK ADD  CONSTRAINT [FK_FactGlTransactions_DimChartOfAccount] FOREIGN KEY([GlAccountSK])
REFERENCES [DimChartOfAccount] ([GlAccountSK])
ALTER TABLE [dbo].[FactGlTransactions] CHECK CONSTRAINT [FK_FactGlTransactions_DimChartOfAccount]
ALTER TABLE [dbo].[FactGlTransactions]  WITH CHECK ADD  CONSTRAINT [FK_FactGlTransactions_DimDate] FOREIGN KEY([DateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactGlTransactions] CHECK CONSTRAINT [FK_FactGlTransactions_DimDate]
ALTER TABLE [dbo].[FactGlTransactions]  WITH CHECK ADD  CONSTRAINT [FK_FactGlTransactions_DimDate1] FOREIGN KEY([PostedDateSK])
REFERENCES [DimDate] ([DateSK])
ALTER TABLE [dbo].[FactGlTransactions] CHECK CONSTRAINT [FK_FactGlTransactions_DimDate1]
ALTER TABLE [dbo].[FactGlTransactions]  WITH CHECK ADD  CONSTRAINT [FK_FactGlTransactions_DimGlCode] FOREIGN KEY([GlCodeSK])
REFERENCES [DimGlCode] ([GlCodeSK])
ALTER TABLE [dbo].[FactGlTransactions] CHECK CONSTRAINT [FK_FactGlTransactions_DimGlCode]
ALTER TABLE [dbo].[FactGlTransactions]  WITH CHECK ADD  CONSTRAINT [FK_FactGlTransactions_DimGlTransDetail] FOREIGN KEY([GlDetailSK])
REFERENCES [DimGlTransDetail] ([GlDetailSK])
ALTER TABLE [dbo].[FactGlTransactions] CHECK CONSTRAINT [FK_FactGlTransactions_DimGlTransDetail]
ALTER TABLE [dbo].[FactGlTransactions]  WITH CHECK ADD  CONSTRAINT [FK_FactGlTransactions_DimOrgUnit] FOREIGN KEY([OrgUnitSK])
REFERENCES [DimOrgUnit] ([OrgUnitSK])
ALTER TABLE [dbo].[FactGlTransactions] CHECK CONSTRAINT [FK_FactGlTransactions_DimOrgUnit]


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The record of a posted journal line, one record for each Journal Line. Will contain all the records for the General Ledger Transactions that have been posted. Data will be added daily.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'The record of a posted journal line, one record for each Journal Line' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The amount on the journal line if the journal type is not BT, EN or CO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmount'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if Journal Type = AP, CC, JE or PR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmount'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The amount on the journal line if the journal type is not BT, EN or CO.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmount'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmount'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Actuals Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if < 0 and Journal Type = AP, CC, JE or PR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Actuals Amount if it was negative without a sign. Journal types such as AP, CC, JE, PR.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountCredit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Actuals Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if > 0 and Journal Type = AP, CC, JE or PR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Actuals Amount if it is positive. Journal types such as AP, CC, JE, PR.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountDebit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'ActualsAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The amount on the journal line if the journal typ e is BT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmount'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if Journal Type = BT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmount'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'100, -245.78' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The amount on the journal line if the journal typ e is BT=Budget Transfer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmount'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmount'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Budget Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if < 0 and Journal Type = BT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'654' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Budget Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountCredit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The BudgetAmount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if > 0 and if Journal Type = BT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'190' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The BudgetAmount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountDebit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'BudgetAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The amount on the journal line if the journal type is CO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmount'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if Journal Type = CO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmount'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1,0, -100.67' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The amount on the journal line if the journal type is CO=Commitment' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmount'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmount'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Commitment Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if < 0 and Journal Type = CO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Commitment Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountCredit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Commitment Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if > 0 and Journal Type = CO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Commitment Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountDebit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'CommitmentAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to the Date dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'DateSK'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Use calendar period and add 01 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'DateSK'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to the Date dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'DateSK'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The amount on the journal line if the journal type is EN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmount'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if Journal Type = EN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmount'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0, 3.0, 3.5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The amount on the journal line if the journal type is EN=Encumbrance' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmount'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmount'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Encumbrance Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if < 0 and Journal Type = EN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Encumbrance Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountCredit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Encumbrance Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if > 0 and Journal Type = EN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Encumbrance Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountDebit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'EncumbranceAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to ChartOfAccount dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlAccountSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to ChartOfAccount dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlAccountSK'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to GlCode dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlCodeSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to GlCode dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlCodeSK'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to GL Detail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlDetailSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to GL Detail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlDetailSK'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key for the GL Transactions fact.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'GlTransactionsSK'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The amount on the journal line' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmount'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmount'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'100' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmount'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The amount on the journal line' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmount'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N' GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmount'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Journal Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if < 0 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Journal Amount if it was negative without a sign' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountCredit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountCredit'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Journal Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'AMOUNT if > 0 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'60.00, 75.00' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountDebit'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Journal Amount if it is positive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountDebit'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'JournalAmountDebit'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Key to Date dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'PostedDateSK'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Posted_date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'PostedDateSK'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key to Date dimension. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'PostedDateSK'


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactGlTransactions', @level2type=N'COLUMN',@level2name=N'PostedDateSK'
  Sample Data
ActualsAmount ActualsAmountCredit ActualsAmountDebit BudgetAmount BudgetAmountCredit BudgetAmountDebit CommitmentAmount CommitmentAmountCredit CommitmentAmountDebit DateSK EncumbranceAmount EncumbranceAmountCredit EncumbranceAmountDebit GlAccountSK GlCodeSK GlDetailSK GlTransactionsSK JournalAmount JournalAmountCredit JournalAmountDebit OrgUnitSK PostedDateSK
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20101201 25.02 0.00 25.02 2969937 5617 17935172 3234889 25.02 0.00 25.02 12484 20101214
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20061101 -253.20 253.20 0.00 2852161 5671 14941204 267264 -253.20 253.20 0.00 12484 20061117
-55.10 55.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20150601 0.00 0.00 0.00 3090463 5148 21479201 6576290 -55.10 55.10 0.00 12484 20150619
0.00 0.00 0.00 0.00 0.00 0.00 164.00 0.00 164.00 20090701 0.00 0.00 0.00 2939976 5619 18743202 2163819 164.00 0.00 164.00 12484 20090730
0.00 0.00 0.00 0.00 0.00 0.00 -58.74 58.74 0.00 20091001 0.00 0.00 0.00 2939976 5619 14479884 2371327 -58.74 58.74 0.00 12484 20091007
-485.00 485.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20140501 0.00 0.00 0.00 3090213 5915 21335781 5806986 -485.00 485.00 0.00 19142 20140514
0.00 0.00 0.00 0.00 0.00 0.00 2198.06 0.00 2198.06 20080801 0.00 0.00 0.00 2909826 5619 17372458 1476076 2198.06 0.00 2198.06 12484 20080806
0.00 0.00 0.00 0.00 0.00 0.00 -19.00 19.00 0.00 20161101 0.00 0.00 0.00 2933179 6515 22010647 7604589 -19.00 19.00 0.00 14426 20161107
275.00 0.00 275.00 0.00 0.00 0.00 0.00 0.00 0.00 20130701 0.00 0.00 0.00 3061380 5915 20073647 5184340 275.00 0.00 275.00 12484 20130722
0.00 0.00 0.00 0.00 0.00 0.00 -25.00 25.00 0.00 20100601 0.00 0.00 0.00 2945996 6446 16425296 2852409 -25.00 25.00 0.00 13129 20100628
Powered by BI Documenter