Table - dbo.DimGlCode

Property	Value
Name	DimGlCode
Schema	dbo
Row Count	1611
Data Size	376 KB
Index Size	16 KB
Create Date	8/28/2013 9:53 AM
Description	Information regarding the GL Codes, will contain one row per GL code.

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
AccountSign	smallint(5, 0)	False	False	False			The sign on the account. On reports, the sign of the amounts have to be switched
Glc	varchar(5)	False	False	False			The first 5 digits of the GlCodeAK
GlCategory	varchar(30)	False	False	False			The description of the GLCategory. The description of the first two digits of the glcode for grouping. Example: 10=Cash & Cash Equivalents, 13=Accounts Receivables. This is defined in the table GLC2-DESC.
GlCategoryCode	varchar(3)	False	False	False			Digits 1-2 of GLCodeAK. The first two digits of the glcode for grouping. Example: 10=Cash & Cash Equivalents, 13=Accounts Receivables. This is defined in the table GLC2-DESC.
GlcDescription	varchar(30)	False	False	False			The description of the GLC (first 5 digits). Example: 10101=Cash In Depositories, 60501=Travel-In-District. This is defined in the table C050.
GlClass	varchar(30)	False	False	False			The description of the GlClass or Account Type. The description of the first digit of the glc number. Example 1=Assets, 2=Liabilities, etc.
GlClassCode	varchar(3)	False	False	False			1st digit of GlCodeAK. The first digit of the glc number. Example 1 = Assets, 2=Liabilities, etc.
GlCodeAK	varchar(9)	False	False	False			Business Key for an instance of a GL Code. This field will contain the full GLC upto 9 characters. Exmple 10100 or 10401PYRL.
GlCodeName	varchar(50)	False	False	False			The description/name of the Full GLCode
GlCodeSK	int(10, 0)	False	False	False	(1 / 1)		Primary Key
GlCodeSubTotal	varchar(30)	False	False	False			The description of the GlCodeSubTotal. The description for the subtotals based on GLC ranges defined in the table GLC-DW-TOT.
GlCodeSubTotalCode	varchar(5)	False	False	False			The 5 digit GLC to which this GLC will sub-total. The subtotals are based on GLC ranges defined in the table GLC-DW-TOT.
GlGroup	varchar(10)	False	False	False			The grouping of GL Classes. The Gl Classes, 5, 6, 7 are grouped into Expenses
GlSubCategory	varchar(30)	False	False	False			The description of the GL Subcategory Code. The descrition of the first three digits of the glcode for grouping. Example: 101=Cash in Depository, 605=Travel. This is defined in the table GLC3-DESC.
GlSubCategoryCode	varchar(3)	False	False	False			Digits 1-3 of GlCodeAK. The first three digits of the glcode for grouping. Example: 101=Cash in Depository, 605=Travel. This is defined in the table GLC3-DESC.
HrClassification	varchar(10)	False	False	False			A classification of HR GL codes into Salary, Benefits and Taxes. The classification is defined in the table GLC-DW-TOT.
HrTimeStatus	varchar(30)	False	False	False			A classification of the Position Time Type for the GLC. Example: Full-Time Part-Time, Part-Time Temporary. The classification is defined in the table GLC-DW-TOT.
Qual2	varchar(4)	False	False	False			The last 4 digits of the GlCodeAK
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? Efective Dates for the GLC.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_DimGlCode	True	GlCodeSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactCheckComponent	Table
dbo.FactGlRollOverBalances	Table
dbo.FactGlSummaryBalances	Table
dbo.FactGlTransactions	Table
dbo.FactPositionBudget	Table
dbo.FactPositionExpense	Table

Name	Type
dbo.FactCheckComponent	TABLE
dbo.FactGlRollOverBalances	TABLE
dbo.FactGlSummaryBalances	TABLE
dbo.FactGlTransactions	TABLE
dbo.FactPositionBudget	TABLE
dbo.FactPositionExpense	TABLE

Object	Property	Value
DimGlCode	Display Name	GlCode
DimGlCode	MS_Description	Information regarding the GL Codes, will contain one row per GL code.
DimGlCode	Table Description	Information regarding the GL Codes
DimGlCode	Table Type	Dimension
AccountSign	Description	The sign on the account. On reports, the sign of the amounts have to be switched
AccountSign	Display Name	AccountSign
AccountSign	ETL Rules	Extracted from Account-sign on COA-ORG-UNIT-FILE or hardcoded in ETL
AccountSign	Example Values	1 or -1
AccountSign	MS_Description	The sign on the account. On reports, the sign of the amounts have to be switched
AccountSign	SCD Type	1
AccountSign	Source System	Derived
AccountSign	Source Table	Based on ETL coding
Glc	Description	The first 5 digits of the GlCodeAK
Glc	Display Name	Glc
Glc	ETL Rules	First 5 digits of GL_CODE
Glc	Example Values	10101
Glc	MS_Description	The first 5 digits of the GlCodeAK
Glc	SCD Type	1
Glc	Source Field Name	GL_CODE
Glc	Source System	DWStaging
Glc	Source Table	COA_ORG_UNIT_FILE
GlCategory	Description	The description of the GLCategory
GlCategory	Display Name	GlCategory
GlCategory	ETL Rules	The description of the GLCategoryCode, needs new table defined on UTL_CODE_TABLE
GlCategory	Example Values	Cash and Cash Equivilants, Accounts Receivables
GlCategory	MS_Description	The description of the GLCategory. The description of the first two digits of the glcode for grouping. Example: 10=Cash & Cash Equivalents, 13=Accounts Receivables. This is defined in the table GLC2-DESC.
GlCategory	SCD Type	1
GlCategory	Source Field Name	DESCRIPTION
GlCategory	Source System	DWStaging
GlCategory	Source Table	UTL_CODE_TABLE_FILE
GlCategoryCode	Description	Digits 1-2 of GLCodeAK
GlCategoryCode	Display Name	GlCategoryCode
GlCategoryCode	ETL Rules	Digits 1-2 of GlCode
GlCategoryCode	Example Values	10, 11, 17
GlCategoryCode	MS_Description	Digits 1-2 of GLCodeAK. The first two digits of the glcode for grouping. Example: 10=Cash & Cash Equivalents, 13=Accounts Receivables. This is defined in the table GLC2-DESC.
GlCategoryCode	SCD Type	1
GlCategoryCode	Source Field Name	GL_CODE
GlCategoryCode	Source System	DWStaging
GlCategoryCode	Source Table	COA_ORG_UNIT_FILE
GlcDescription	Description	The description of the Glc (first 5 digits)
GlcDescription	Display Name	GlcDescription
GlcDescription	ETL Rules	The description of the 5 digit GLC. Extracted from the UTL_CODE_TABLE - Table name C050
GlcDescription	Example Values	Food Assistance
GlcDescription	MS_Description	The description of the GLC (first 5 digits). Example: 10101=Cash In Depositories, 60501=Travel-In-District. This is defined in the table C050.
GlcDescription	SCD Type	1
GlcDescription	Source Field Name	DESCRIPTION
GlcDescription	Source System	DWStaging
GlcDescription	Source Table	UTL_CODE_TABLE_FILE
GlClass	Description	The description of the GlClass or Account Type
GlClass	Display Name	GlClass
GlClass	ETL Rules	The descrption of the Account Type. Extracted from the UTL_CODE_TABLE - Table A020
GlClass	Example Values	Assets, Liabilities
GlClass	MS_Description	The description of the GlClass or Account Type. The description of the first digit of the glc number. Example 1=Assets, 2=Liabilities, etc.
GlClass	SCD Type	1
GlClass	Source Field Name	DESCRIPTION
GlClass	Source System	DWStaging
GlClass	Source Table	UTL_CODE_TABLE_FILE
GlClassCode	Description	1st digit of GlCodeAK
GlClassCode	Display Name	GlClassCode
GlClassCode	ETL Rules	First digit of GL_CODE
GlClassCode	Example Values	1, 2, 3
GlClassCode	MS_Description	1st digit of GlCodeAK. The first digit of the glc number. Example 1 = Assets, 2=Liabilities, etc.
GlClassCode	SCD Type	1
GlClassCode	Source Field Name	GL_CODE
GlClassCode	Source System	DWStaging
GlClassCode	Source Table	COA_ORG_UNIT_FILE
GlCodeAK	Description	Business Key for an instance of a GL Code. This field will contain the full GLC upto 9 characters
GlCodeAK	Display Name	GLCodeAK
GlCodeAK	ETL Rules	Pull all records from COA_ORG_UNIT_FILE where GL_IND = 'Y'
GlCodeAK	Example Values	10101, 10401PYRL
GlCodeAK	MS_Description	Business Key for an instance of a GL Code. This field will contain the full GLC upto 9 characters. Exmple 10100 or 10401PYRL.
GlCodeAK	SCD Type	key
GlCodeAK	Source Field Name	GL_CODE
GlCodeAK	Source System	DWStaging
GlCodeAK	Source Table	COA_ORG_UNIT_FIEL
GlCodeName	Description	The description/name of the Full GLCode
GlCodeName	Display Name	GlCodeName
GlCodeName	ETL Rules	Convert to upper/lower case.
GlCodeName	Example Values	Investments - Cash Equivalents
GlCodeName	MS_Description	The description/name of the Full GLCode
GlCodeName	SCD Type	1
GlCodeName	Source Field Name	DESCRIPTION
GlCodeName	Source System	DWStaging
GlCodeName	Source Table	COA_ORG_UNIT_FILE
GlCodeSK	Description	Primary Key
GlCodeSK	Display Name	GlCodeSK
GlCodeSK	ETL Rules	Assigned by SQl Server
GlCodeSK	Example Values	1, 2, 3?
GlCodeSK	MS_Description	Primary Key
GlCodeSK	SCD Type	key
GlCodeSK	Source System	Derived
GlCodeSubTotal	Description	The description of the GlCodeSubTotal
GlCodeSubTotal	Display Name	GlCodeSubTotal
GlCodeSubTotal	ETL Rules	The description of the 5 digit GLC. Extracted from the UTL_CODE_TABLE - Table name GLC-DW-TOT, FIELD-VALUE(1)
GlCodeSubTotal	Example Values	01, 02, 03, 04 through 15
GlCodeSubTotal	MS_Description	The description of the GlCodeSubTotal. The description for the subtotals based on GLC ranges defined in the table GLC-DW-TOT.
GlCodeSubTotal	SCD Type	1
GlCodeSubTotal	Source Field Name	FIELD-VALUE(2)
GlCodeSubTotal	Source System	DWStaging
GlCodeSubTotal	Source Table	UTL_CODE_TABLE_FILE
GlCodeSubTotalCode	Description	The 5 digit GLC to which this GLC will sub-total
GlCodeSubTotalCode	Display Name	GlCodeSubTotalCode
GlCodeSubTotalCode	ETL Rules	The 5 digit GLC to which it will total. Extracted from the UTL_CODE_TABLE - Table name GLC-DW-TOT
GlCodeSubTotalCode	Example Values	Food Assistance
GlCodeSubTotalCode	MS_Description	The 5 digit GLC to which this GLC will sub-total. The subtotals are based on GLC ranges defined in the table GLC-DW-TOT.
GlCodeSubTotalCode	SCD Type	1
GlCodeSubTotalCode	Source Field Name	FIELD-VALUE(1)
GlCodeSubTotalCode	Source System	DWStaging
GlCodeSubTotalCode	Source Table	UTL_CODE_TABLE_FILE
GlGroup	Description	The grouping of GL Classes. The Gl Classes, 5, 6, 7 are grouped into Expenses
GlGroup	Display Name	GlGroup
GlGroup	ETL Rules	Derived
GlGroup	Example Values	Assets, Revenue, Expenses
GlGroup	MS_Description	The grouping of GL Classes. The Gl Classes, 5, 6, 7 are grouped into Expenses
GlGroup	SCD Type	1
GlSubCategory	Description	The description of the GL Subcategory Code
GlSubCategory	Display Name	GlSubCategory
GlSubCategory	ETL Rules	The description of the GLSubCategoryCode, extracted from UTL_CODE_TABLE_FILE, table-name GLC3-DESC
GlSubCategory	Example Values	Travel, Minor Equipment, Data Software
GlSubCategory	MS_Description	The description of the GL Subcategory Code. The descrition of the first three digits of the glcode for grouping. Example: 101=Cash in Depository, 605=Travel. This is defined in the table GLC3-DESC.
GlSubCategory	SCD Type	1
GlSubCategory	Source Field Name	DESCRIPTION
GlSubCategory	Source System	DWStaging
GlSubCategory	Source Table	UTL_CODE_TABLE_FILE
GlSubCategoryCode	Description	Digits 1-3 of GlCodeAK
GlSubCategoryCode	Display Name	GlSubCategoryCode
GlSubCategoryCode	ETL Rules	Digits 1-3 of GlCode
GlSubCategoryCode	Example Values	101, 605
GlSubCategoryCode	MS_Description	Digits 1-3 of GlCodeAK. The first three digits of the glcode for grouping. Example: 101=Cash in Depository, 605=Travel. This is defined in the table GLC3-DESC.
GlSubCategoryCode	SCD Type	1
GlSubCategoryCode	Source Field Name	GL_CODE
GlSubCategoryCode	Source System	DWStaging
GlSubCategoryCode	Source Table	COA_ORG_UNIT_FILE
HrClassification	Description	A classification of HR Gl codes into Salary, Benefits and Taxes
HrClassification	Display Name	HrClassification
HrClassification	ETL Rules	Extracted from UTL_CODE_TABLE GLC-DW-TOT, Sub-attribute 4
HrClassification	Example Values	Salary, Benefits and Expenses
HrClassification	MS_Description	A classification of HR GL codes into Salary, Benefits and Taxes. The classification is defined in the table GLC-DW-TOT.
HrClassification	SCD Type	1
HrClassification	Source Field Name	FIELD-VALUE(4)
HrClassification	Source System	DWStaging
HrClassification	Source Table	UTL_CODE_TABLE_FILE
HrTimeStatus	Description	A classification of the Position Time Type for the GLC.
HrTimeStatus	Display Name	HrTimeStatus
HrTimeStatus	ETL Rules	Extracted from UTL_CODE_TABLE GLC-DW-TOT, Sub-attribute 3
HrTimeStatus	Example Values	Full-Time, Part-Time, Part-Time Temporary
HrTimeStatus	MS_Description	A classification of the Position Time Type for the GLC. Example: Full-Time Part-Time, Part-Time Temporary. The classification is defined in the table GLC-DW-TOT.
HrTimeStatus	SCD Type	1
HrTimeStatus	Source Field Name	FIELD-VALUE(3)
HrTimeStatus	Source System	DWStaging
HrTimeStatus	Source Table	UTL_CODE_TABLE_FILE
Qual2	Description	The last 4 digits of the GlCodeAK
Qual2	Display Name	Qual2
Qual2	ETL Rules	Last 4 digits of GL_CODE
Qual2	Example Values	Can be spaces, PYRL, 1010
Qual2	MS_Description	The last 4 digits of the GlCodeAK
Qual2	SCD Type	1
Qual2	Source Field Name	GL_CODE
Qual2	Source System	DWStaging
Qual2	Source Table	COA_ORG_UNIT_FILE
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? Efective Dates for the GLC.
RowStartDate	SCD Type	n/a
RowStartDate	Source System	Derived

Object

Property

Value

/****** Object: Table [dbo].[DimGlCode] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimGlCode](
    [GlCodeSK] [int] IDENTITY(1,1) NOT NULL,
    [GlCodeAK] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Glc] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Qual2] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlClassCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlClass] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlGroup] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCategoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlSubCategoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlSubCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlcDescription] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCodeName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCodeSubTotalCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [GlCodeSubTotal] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HrClassification] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [HrTimeStatus] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AccountSign] [smallint] NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
CONSTRAINT [PK_DimGlCode] PRIMARY KEY CLUSTERED
(
    [GlCodeSK] 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'GlCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Information regarding the GL Codes, will contain one row per GL code.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode'

EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Information regarding the GL Codes ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode'

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The sign on the account. On reports, the sign of the amounts have to be switched' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'AccountSign'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from Account-sign on COA-ORG-UNIT-FILE or hardcoded in ETL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'AccountSign'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The sign on the account. On reports, the sign of the amounts have to be switched' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'AccountSign'

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'Based on ETL coding' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'AccountSign'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The first 5 digits of the GlCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Glc'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'First 5 digits of GL_CODE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Glc'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'10101' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Glc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The first 5 digits of the GlCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Glc'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Glc'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the GLCategory' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategory'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description of the GLCategoryCode, needs new table defined on UTL_CODE_TABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategory'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Cash and Cash Equivilants, Accounts Receivables' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategory'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the GLCategory. The description of the first two digits of the glcode for grouping. Example: 10=Cash & Cash Equivalents, 13=Accounts Receivables. This is defined in the table GLC2-DESC.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategory'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategory'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Digits 1-2 of GLCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategoryCode'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Digits 1-2 of GlCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'10, 11, 17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Digits 1-2 of GLCodeAK. The first two digits of the glcode for grouping. Example: 10=Cash & Cash Equivalents, 13=Accounts Receivables. This is defined in the table GLC2-DESC.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategoryCode'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the Glc (first 5 digits)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlcDescription'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description of the 5 digit GLC. Extracted from the UTL_CODE_TABLE - Table name C050' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlcDescription'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Food Assistance' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlcDescription'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the GLC (first 5 digits). Example: 10101=Cash In Depositories, 60501=Travel-In-District. This is defined in the table C050. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlcDescription'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlcDescription'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the GlClass or Account Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClass'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The descrption of the Account Type. Extracted from the UTL_CODE_TABLE - Table A020' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClass'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Assets, Liabilities' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClass'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the GlClass or Account Type. The description of the first digit of the glc number. Example 1=Assets, 2=Liabilities, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClass'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClass'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'1st digit of GlCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClassCode'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'First digit of GL_CODE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClassCode'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1st digit of GlCodeAK. The first digit of the glc number. Example 1 = Assets, 2=Liabilities, etc.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClassCode'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlClassCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Business Key for an instance of a GL Code. This field will contain the full GLC upto 9 characters' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeAK'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Pull all records from COA_ORG_UNIT_FILE where GL_IND = ''Y''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeAK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'10101, 10401PYRL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business Key for an instance of a GL Code. This field will contain the full GLC upto 9 characters. Exmple 10100 or 10401PYRL. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeAK'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FIEL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeAK'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description/name of the Full GLCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeName'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Convert to upper/lower case.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeName'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Investments - Cash Equivalents' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description/name of the Full GLCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeName'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeName'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Assigned by SQl Server' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @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'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSK'

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

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @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'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSK'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the GlCodeSubTotal' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotal'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description of the 5 digit GLC. Extracted from the UTL_CODE_TABLE - Table name GLC-DW-TOT, FIELD-VALUE(1)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotal'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'01, 02, 03, 04 through 15' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotal'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the GlCodeSubTotal. The description for the subtotals based on GLC ranges defined in the table GLC-DW-TOT.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotal'

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

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FIELD-VALUE(2)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotal'

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotal'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The 5 digit GLC to which this GLC will sub-total' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotalCode'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The 5 digit GLC to which it will total. Extracted from the UTL_CODE_TABLE - Table name GLC-DW-TOT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotalCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Food Assistance' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotalCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The 5 digit GLC to which this GLC will sub-total. The subtotals are based on GLC ranges defined in the table GLC-DW-TOT.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotalCode'

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

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FIELD-VALUE(1)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotalCode'

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlCodeSubTotalCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The grouping of GL Classes. The Gl Classes, 5, 6, 7 are grouped into Expenses' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlGroup'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlGroup'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Assets, Revenue, Expenses' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlGroup'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The grouping of GL Classes. The Gl Classes, 5, 6, 7 are grouped into Expenses' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlGroup'

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the GL Subcategory Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategory'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description of the GLSubCategoryCode, extracted from UTL_CODE_TABLE_FILE, table-name GLC3-DESC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategory'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Travel, Minor Equipment, Data Software' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategory'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the GL Subcategory Code. The descrition of the first three digits of the glcode for grouping. Example: 101=Cash in Depository, 605=Travel. This is defined in the table GLC3-DESC.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategory'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategory'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Digits 1-3 of GlCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategoryCode'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Digits 1-3 of GlCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'101, 605' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Digits 1-3 of GlCodeAK. The first three digits of the glcode for grouping. Example: 101=Cash in Depository, 605=Travel. This is defined in the table GLC3-DESC.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategoryCode'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'GlSubCategoryCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'A classification of HR Gl codes into Salary, Benefits and Taxes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrClassification'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from UTL_CODE_TABLE GLC-DW-TOT, Sub-attribute 4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrClassification'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Salary, Benefits and Expenses' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrClassification'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A classification of HR GL codes into Salary, Benefits and Taxes. The classification is defined in the table GLC-DW-TOT.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrClassification'

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

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FIELD-VALUE(4)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrClassification'

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrClassification'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'A classification of the Position Time Type for the GLC. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrTimeStatus'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from UTL_CODE_TABLE GLC-DW-TOT, Sub-attribute 3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrTimeStatus'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Full-Time, Part-Time, Part-Time Temporary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrTimeStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A classification of the Position Time Type for the GLC. Example: Full-Time Part-Time, Part-Time Temporary. The classification is defined in the table GLC-DW-TOT.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrTimeStatus'

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

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'FIELD-VALUE(3)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrTimeStatus'

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'HrTimeStatus'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The last 4 digits of the GlCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Qual2'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Last 4 digits of GL_CODE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Qual2'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Can be spaces, PYRL, 1010' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Qual2'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The last 4 digits of the GlCodeAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Qual2'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'COA_ORG_UNIT_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @level2type=N'COLUMN',@level2name=N'Qual2'

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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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'DimGlCode', @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? Efective Dates for the GLC.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimGlCode', @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'DimGlCode', @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'DimGlCode', @level2type=N'COLUMN',@level2name=N'RowStartDate'

AccountSign

Glc

GlCategory

GlCategoryCode

GlcDescription

GlClass

GlClassCode

GlCodeAK

GlCodeName

GlCodeSK

GlCodeSubTotal

GlCodeSubTotalCode

GlGroup

GlSubCategory

GlSubCategoryCode

HrClassification

HrTimeStatus

Qual2

RowIsCurrent

RowStartDate

-1

40110

Tuition & Fees Revenue

40

Tuition-Adv Professional

Revenue

4

401100302

Tuition-Sp 2003

5732

Tuition

40100

Revenue

Student Fees Control (Int Use)

401

N/A

0302

Y

2017-03-09T11:42:00-05:00

-1

49150

Non-Revenue Receipts

49

Mand Transfer In - Fund 5

Revenue

4

49150

Mand Transfer In - Fund 5

6350

Other Income

48100

Revenue

Mandatory Xfers - In,Fm Curr F

491

N/A

Y

2017-03-09T11:42:00-05:00

-1

40110

Tuition & Fees Revenue

40

Tuition-Adv Professional

Revenue

4

401101701

Tuition-Adv Professional

5764

Tuition

40100

Revenue

Student Fees Control (Int Use)

401

N/A

1701

Y

2017-03-09T11:42:00-05:00

-1

40860

Tuition & Fees Revenue

40

Student Capital Imp Fee A & P

Revenue

4

408601503

Student Capital Imp Fee A & P

6027

Student Capital Impr Fee

40869

Revenue

Financial Aid Fund Fees

408

N/A

1503

Y

2017-03-09T11:42:00-05:00

-1

40610

Tuition & Fees Revenue

40

Diploma Replacement Fee

Revenue

4

40610

Diploma Replacement Fee

5300

Misc Student Srvc Fees

40500

Revenue

Graduation Fees

406

N/A

Y

2017-03-09T11:42:00-05:00

-1

40320

Tuition & Fees Revenue

40

Non-Res-Postsecondary Vocation

Revenue

4

403200506

Psv-Out-Of-State-Tuition-2006

5805

Out Of State Fees

40301

Revenue

Out-Of-St Fees-Adv & Prof Bacc

403

N/A

0506

Y

2017-03-09T11:42:00-05:00

1

73012

Artwork/Artifact

73

Other Library Media

Capital Outlay

7

73012

Other Library Media

6640

Other Library Media

73012

Expenses

Library Books And Films

730

N/A

Y

2017-03-09T11:42:00-05:00

-1

40270

Tuition & Fees Revenue

40

Tuition Self Supporting Avoc

Revenue

4

402700502

Matriculation Avoc-Sp 2005

5641

Tuition

40100

Revenue

Lifelong Learning Fees Control

402

N/A

0502

Y

2017-03-09T11:42:00-05:00

1

67700

Library Resources, E-Materials

67

Admin Cost Alloc - Xref 677Xx

Current Expenses

6

67700

Admin Cost Pool Alloc - Xref 677Xx

6587

Admin Cost Alloc - Xref 677Xx

67700

Expenses

Administrative Cost Pool Alloc

677

N/A

Y

2017-03-09T11:42:00-05:00

-1

40310

Tuition & Fees Revenue

40

Non-Resident-Adv & Prof

Revenue

4

403101601

Non-Resident-Adv & Prof

5750

Out Of State Fees

40301

Revenue

Out-Of-St Fees-Adv & Prof Bacc

403

N/A

1601

Y

2017-03-09T11:42:00-05:00