EnterpriseDW
 dbo.DimGlTransDetail (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.DimGlTransDetail
  Properties
Property Value
Name DimGlTransDetail
Schema dbo
Row Count 7688484
Data Size 852512 KB
Index Size 3176 KB
Create Date 8/28/2013 9:53 AM
Description Journal Information including Journal Type and Budget Type. Will conain one row per GL-TRANS record.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
BudgetType
varchar(50)
False
False
False
 
The description of the Budget Type Code
BudgetTypeCode
varchar(8)
False
False
False
 
The Budget Type Code. Example ORIGINAL, PM-AMEND, PM-REALL, etc.
GlCalendarPeriod
varchar(6)
False
False
False
 
Calendar Period. Example is 201307 or CCYYMM
GlDetailAK
varchar(18)
False
False
False
 
Business Key. This is combination of CalendarPeriod, JournalType, JournalNo and LineNo. 201201JE0000100004
In Primary Key
GlDetailSK
int(10, 0)
False
False
False
(1 / 1)
Primary ID Key
JournalGrouping
varchar(30)
False
False
False
 
How journal types are grouped. Example: Budget (BT) Commitments (CO), Encumbrances (EN), Actuals (AP,CC, JE, PR)
JournalNumber
int(10, 0)
False
False
False
 
Journal Number. Sequential Number assinged by the system.
JournalType
varchar(30)
False
False
False
 
Description of the Journal Type Code.
JournalTypeCode
varchar(3)
False
False
False
 
Journal Type Code. Examples are AP, CC, BT, CO, EN, JE, PR, etc.
LineNumber
int(10, 0)
False
False
False
 
Journal Line Number
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?
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
GlDetailSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimGlTransDetail depends on)
Name Type
Table
  Child Dependencies (objects that depend on dbo.DimGlTransDetail)
Name Type
TABLE
  Extended Properties
Object Property Value
DimGlTransDetail
Display Name
GLTransDetail
DimGlTransDetail
MS_Description
Journal Information including Journal Type and Budget Type. Will conain one row per GL-TRANS record.
DimGlTransDetail
Table Description
Journal Information including Journal Type and Budget Type
DimGlTransDetail
Table Type
Dimension
BudgetType
Description
The description of the Budget Type Code
BudgetType
Display Name
Budget Type
BudgetType
ETL Rules
Extract from FIG_TABLES - FIGADM9 where the code matches the BUDGET-TYPE-CODE from GL-TRANS
BudgetType
Example Values
Original Budget, Perm Amendment, etc.
BudgetType
MS_Description
The description of the Budget Type Code
BudgetType
SCD Type
1
BudgetType
Source System
DWStaging
BudgetType
Source Table
FIG_TABLES
BudgetTypeCode
Description
The Budget Type Code
BudgetTypeCode
Display Name
BudgetTypeCode
BudgetTypeCode
ETL Rules
BUDGET-TYPE-CODE from GL_TRANS
BudgetTypeCode
Example Values
ORIGINAL, PM-AMEND
BudgetTypeCode
MS_Description
The Budget Type Code. Example ORIGINAL, PM-AMEND, PM-REALL, etc.
BudgetTypeCode
SCD Type
1
BudgetTypeCode
Source Field Name
BUDGET_TYPE_CODE
BudgetTypeCode
Source System
DWStaging
BudgetTypeCode
Source Table
GL_TRANS
GlCalendarPeriod
Description
Calendar Period
GlCalendarPeriod
Display Name
Calendar Period
GlCalendarPeriod
ETL Rules
GL-TRANS - Calendar Period
GlCalendarPeriod
Example Values
201201
GlCalendarPeriod
MS_Description
Calendar Period. Example is 201307 or CCYYMM
GlCalendarPeriod
SCD Type
1
GlCalendarPeriod
Source Field Name
CALENDAR_PERIOD
GlCalendarPeriod
Source System
DWStaging
GlCalendarPeriod
Source Table
GL_TRANS
GlDetailAK
Description
Business Key.
GlDetailAK
Display Name
GlDetailAK
GlDetailAK
ETL Rules
Combination of CalendarPeriod, JournalType, Journal No and Line No
GlDetailAK
Example Values
201201JE0000100004
GlDetailAK
MS_Description
Business Key. This is combination of CalendarPeriod, JournalType, JournalNo and LineNo. 201201JE0000100004
GlDetailAK
SCD Type
key
GlDetailAK
Source System
DWStaging
GlDetailAK
Source Table
GL_TRANS
GlDetailSK
Description
Primary ID Key
GlDetailSK
Display Name
GLDetailSK
GlDetailSK
Example Values
1, 2, 3,
GlDetailSK
MS_Description
Primary ID Key
GlDetailSK
SCD Type
key
GlDetailSK
Source Field Name
SESSION_KEY
GlDetailSK
Source Table
GL_TRANS
JournalGrouping
Description
How journal types are grouped
JournalGrouping
Display Name
JournalGrouping
JournalGrouping
Example Values
Actuals, Commitments, etc
JournalGrouping
MS_Description
How journal types are grouped. Example: Budget (BT) Commitments (CO), Encumbrances (EN), Actuals (AP,CC, JE, PR)
JournalGrouping
SCD Type
1
JournalGrouping
Source System
Derived
JournalNumber
Description
Journal Number
JournalNumber
Display Name
Journal Number
JournalNumber
ETL Rules
Journal Number
JournalNumber
Example Values
1
JournalNumber
MS_Description
Journal Number. Sequential Number assinged by the system.
JournalNumber
SCD Type
1
JournalNumber
Source Field Name
JOURNAL_NO
JournalNumber
Source System
DWStaging
JournalNumber
Source Table
GL_TRANS
JournalType
Description
Description of the Journal Type
JournalType
Display Name
Journal Type
JournalType
ETL Rules
Extract from FIG_TABLES - FIGADM10 where the code matches the Journal Type from GL-TRANS
JournalType
Example Values
Budget Transaction
JournalType
MS_Description
Description of the Journal Type Code.
JournalType
SCD Type
1
JournalType
Source System
DWStaging
JournalType
Source Table
FIG_TABLES
JournalTypeCode
Description
Journal Type Code
JournalTypeCode
Display Name
Journal Type Code
JournalTypeCode
ETL Rules
Journal Type
JournalTypeCode
Example Values
BT, PR, EN, CO
JournalTypeCode
MS_Description
Journal Type Code. Examples are AP, CC, BT, CO, EN, JE, PR, etc.
JournalTypeCode
SCD Type
1
JournalTypeCode
Source Field Name
JOURNAL_TYPE
JournalTypeCode
Source System
DWStaging
JournalTypeCode
Source Table
GL_TRANS
LineNumber
Description
Line Number
LineNumber
Display Name
Line Number
LineNumber
ETL Rules
Line No
LineNumber
Example Values
1
LineNumber
MS_Description
Journal Line Number
LineNumber
SCD Type
1
LineNumber
Source Field Name
LINE_NO
LineNumber
Source System
DWStaging
LineNumber
Source Table
GL_TRANS
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
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimGlTransDetail] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimGlTransDetail](
    [GlDetailSK] [int] IDENTITY(1,1) NOT NULL,
    [GlDetailAK] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCalendarPeriod] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [JournalNumber] [int] NOT NULL,
    [LineNumber] [int] NOT NULL,
    [JournalTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [JournalType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [JournalGrouping] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BudgetTypeCode] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BudgetType] [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_dbo.DimGlTransDetail] PRIMARY KEY CLUSTERED 
(
    [GlDetailSK] 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'GLTransDetail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Journal Information including Journal Type and Budget Type. Will conain one row per GL-TRANS record.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Journal Information including Journal Type and Budget Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail'


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the Budget Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetType'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Budget Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetType'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extract from FIG_TABLES - FIGADM9 where the code matches the BUDGET-TYPE-CODE from GL-TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetType'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Original Budget, Perm Amendment, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Budget Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetType'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'FIG_TABLES' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetType'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Budget Type Code ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetTypeCode'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'BUDGET-TYPE-CODE from GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetTypeCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'ORIGINAL, PM-AMEND' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Budget Type Code. Example ORIGINAL, PM-AMEND, PM-REALL, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetTypeCode'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'BudgetTypeCode'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Calendar Period' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlCalendarPeriod'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Calendar Period' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlCalendarPeriod'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'GL-TRANS - Calendar Period' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlCalendarPeriod'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'201201' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlCalendarPeriod'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Calendar Period. Example is 201307 or CCYYMM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlCalendarPeriod'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlCalendarPeriod'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Business Key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailAK'


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


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Combination of CalendarPeriod, JournalType, Journal No and Line No' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailAK'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'201201JE0000100004' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business Key. This is combination of CalendarPeriod, JournalType, JournalNo and LineNo. 201201JE0000100004' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailAK'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailAK'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Primary ID Key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary ID Key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'GlDetailSK'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'How journal types are grouped' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalGrouping'


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Actuals, Commitments, etc' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalGrouping'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'How journal types are grouped. Example: Budget (BT) Commitments (CO), Encumbrances (EN), Actuals (AP,CC, JE, PR)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalGrouping'


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


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


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Journal Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalNumber'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Journal Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalNumber'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Journal Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalNumber'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Journal Number. Sequential Number assinged by the system.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalNumber'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalNumber'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Description of the Journal Type ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalType'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Journal Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalType'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extract from FIG_TABLES - FIGADM10 where the code matches the Journal Type from GL-TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalType'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Budget Transaction' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of the Journal Type Code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalType'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'FIG_TABLES' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalType'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Journal Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalTypeCode'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Journal Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalTypeCode'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Journal Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalTypeCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'BT, PR, EN, CO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Journal Type Code. Examples are AP, CC, BT, CO, EN, JE, PR, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalTypeCode'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'JournalTypeCode'


EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Line Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'LineNumber'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Line Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'LineNumber'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Line No ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'LineNumber'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Journal Line Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'LineNumber'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'GL_TRANS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'LineNumber'


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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @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'DimGlTransDetail', @level2type=N'COLUMN',@level2name=N'RowStartDate'
  Sample Data
BudgetType BudgetTypeCode GlCalendarPeriod GlDetailAK GlDetailSK JournalGrouping JournalNumber JournalType JournalTypeCode LineNumber RowEndDate RowIsCurrent RowStartDate
N/A N/A 201508 201508EN0047700002 19910391 Encumbrance 477 Encumbrance EN 2 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:51:00-05:00
N/A N/A 201104 201104EN0307800003 18988094 Encumbrance 3078 Encumbrance EN 3 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:49:00-05:00
N/A N/A 201209 201209AP0070700958 18164368 Actuals 707 Invoice Sent To Ap AP 958 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:50:00-05:00
N/A N/A 201309 201309CO0128600002 20403720 Commitments 1286 Commitment CO 2 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:50:00-05:00
N/A N/A 201311 201311CO0315600001 20679509 Commitments 3156 Commitment CO 1 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:50:00-05:00
N/A N/A 200707 200707CO0291600001 15825465 Commitments 2916 Commitment CO 1 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:47:00-05:00
N/A N/A 201204 201204JE0012200003 16912823 Actuals 122 Journal Entry JE 3 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:50:00-05:00
N/A N/A 201504 201504AP0036100001 20981685 Actuals 361 Invoice Sent To Ap AP 1 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:51:00-05:00
N/A N/A 201107 201107CO0195900002 15580666 Commitments 1959 Commitment CO 2 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:49:00-05:00
N/A N/A 200610 200610PR0000201770 14861554 Actuals 2 Payroll Batch Journal PR 1770 9999-12-31T23:59:00-05:00 Y 2017-03-09T11:47:00-05:00
Powered by BI Documenter