Table - dbo.DimOrgUnit

Property	Value
Name	DimOrgUnit
Schema	dbo
Row Count	7687
Data Size	2728 KB
Index Size	16 KB
Create Date	8/28/2013 9:53 AM
Description	Information regarding the Org Units, one row per Org Unit.

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
BudgetManager	varchar(40)	False	False	False			The name of the Budget Manager as defined in Security.
BudgetManagerId	varchar(9)	False	False	False			The ID of the Budget Manager as defined in Maintain COA Org Unit screen.
ControlOrgUnit	varchar(18)	False	False	False			The control 16 digit Org Unit. Multiple Org Units can use on 16 digit Control Org Unit to record assets, liabilities and fund balance.
ControlOrgUnitName	varchar(30)	False	False	False			The description of the Control Org Unit.
EndDate	datetime(23, 3)	False	False	False			Date when OrgUnit expires
FunctionCode	varchar(3)	False	False	False			Digits 1-2 of the OrgUnit. The Function Code of the Org Unit. The Function Code is defined in the table F002.
FunctionDescription	varchar(30)	False	False	False			The description of the Function as per Accounting Manual. The Function Code and its definition are defined in the table F002. Example 15=Student Support, 21=Direct Instruction.
Fund	varchar(30)	False	False	False			The description or name of the FundCode. The description of the fund the Org Unit is associated with based on the first digit. Example: Current Funds-Unrestricted.
FundCode	varchar(3)	False	False	False			The 1st digit of the Org Unit. This also indicates the fund the Org Unit is associated with.
Location	varchar(30)	False	False	False			The description of the Location Code. The Location Code and its defintion are defined in the Location Table in the Infrequently Used Table Menu.
LocationCode	varchar(3)	False	False	False			Digits 15 and 16 of Org Unit or the last two digits of the OrgUnit Number. The Location Code is defined in the Location Table in the Infrequently Used Table Menu.
OrgUnit	varchar(18)	False	False	False			OrgUnit Number as assigned in Integrow, including the "-" to separate the State Org, Qual 1 and location.
OrgUnitAK	varchar(16)	False	False	False			OrgUnit Number as assigned in Integrow. This is the 16 digit OrgUnit number.
OrgUnitGrouping	varchar(4)	False	False	False			Grouping method of Org Units as defined in the Maintain COA Org Unit screen. The field on this screen is called Special Field. This field is used as a filter in the Data Warehouse with a label of Org Unit Groups.
OrgUnitName	varchar(30)	False	False	False			Org Unit description.
OrgUnitSK	int(10, 0)	False	False	False	(1 / 1)		Primary Key the table's
OrgUnitStatus	varchar(15)	False	False	False			The Status of the Org Unit. Example: Active, Inactive, Summary.
OrgUnitStatusCode	varchar(3)	False	False	False			The Status Description of the Org Unit. Example: A, I, S.
PrincipalAdmin	varchar(40)	False	False	False			The name of the Principal Administrator as defined in the Maintain COA Org Unit screen.
PrincipalAdminId	varchar(9)	False	False	False			The ID of the Principal Administrator as defined in the Maintain COA Org Unit screen.
ProjectNumber	int(10, 0)	False	False	False			The project number from the OrgUnit if used for tracking as defined in the Maintain COA Org Unit screen.
Qual1	varchar(6)	False	False	False			Digits 9 - 14 of Org Unit or Qual 1.
ReportDistribution	varchar(30)	False	False	False			Description of Gropuing method for OrgUnits as defined in the Maintain COA Org Unit screen. The values and defintions on this table are defined in the Distribution Table.
ReportDistributionCode	varchar(4)	False	False	False			Grouping method of Org Units as defined in the Maintain COA Org Unit screen. The values and defintions on this table are defined in the Distribution Table.
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?
StartDate	datetime(23, 3)	False	False	False			Date since OrgUnit is Active
StateOrgUnit	varchar(8)	False	False	False			The first 8 characters of the Org Unit Code as prescribed by the Accounting Manual.
SubFunction	varchar(30)	False	False	False			The description of the Sub-Function as per Accounting Manual. The Subfunction code and its definition are defined in the table F003.
SubFunctionCode	varchar(3)	False	False	False			Digits 1-3 of OrgUnit or subfunction. The Subfunction Code is defined in the table F003.
UserGroup	varchar(40)	False	False	False			The name of the User Group as defined in User Group Profile.
UserGroupId	varchar(16)	False	False	False			The ID of the User Group as defined in the Maintain COA Org Unit screen.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimOrgUnit	True	OrgUnitSK

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.FactOrgUnit_User_Bridge	Table
dbo.FactPositionBudget	Table
dbo.FactPositionExpense	Table

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

Object	Property	Value
DimOrgUnit	Display Name	OrgUnit
DimOrgUnit	MS_Description	Information regarding the Org Units, one row per Org Unit.
DimOrgUnit	Table Description	Information regarding the Org Units
DimOrgUnit	Table Type	Dimension
BudgetManager	Description	The name of the Budget Manager
BudgetManager	Display Name	BudgetManager
BudgetManager	ETL Rules	The name associated with the Budget Manager from SECURITY_USER_VIEW
BudgetManager	Example Values	Brisset Jaramillo
BudgetManager	MS_Description	The name of the Budget Manager as defined in Security.
BudgetManager	SCD Type	1
BudgetManager	Source System	DWStaging
BudgetManager	Source Table	SECURITY_USER_VIEW
BudgetManagerId	Description	The ID of the Budget Manager
BudgetManagerId	Display Name	BudgetManagerId
BudgetManagerId	Example Values	BUDGET
BudgetManagerId	MS_Description	The ID of the Budget Manager as defined in Maintain COA Org Unit screen.
BudgetManagerId	SCD Type	1
BudgetManagerId	Source Field Name	BUDGET_MANAGER
BudgetManagerId	Source System	DWStaging
BudgetManagerId	Source Table	COA_ORG_UNIT_FILE
ControlOrgUnit	Description	The controlling Org Unit
ControlOrgUnit	Display Name	ControlOrgUnit
ControlOrgUnit	ETL Rules	CONTROL_ORG_UNIT
ControlOrgUnit	Example Values	1400010014000140
ControlOrgUnit	MS_Description	The control 16 digit Org Unit. Multiple Org Units can use on 16 digit Control Org Unit to record assets, liabilities and fund balance.
ControlOrgUnit	SCD Type	1
ControlOrgUnit	Source Field Name	CONTRL_ORG_UNIT
ControlOrgUnit	Source System	DWStaging
ControlOrgUnit	Source Table	COA_ORG_UNIT_FILE
ControlOrgUnitName	Description	The description of the Control Org Unit
ControlOrgUnitName	Display Name	ControlOrgUnitName
ControlOrgUnitName	ETL Rules	Convert to Upper/lower case
ControlOrgUnitName	Example Values	GENERAL OPERATING
ControlOrgUnitName	MS_Description	The description of the Control Org Unit.
ControlOrgUnitName	SCD Type	1
ControlOrgUnitName	Source Field Name	DESCRIPTION
ControlOrgUnitName	Source System	DWStaging
ControlOrgUnitName	Source Table	COA_ORG_UNIT_FILE
EndDate	Description	Date when OrgUnit expires
EndDate	Display Name	EndDate
EndDate	Example Values	2/6/2098
EndDate	MS_Description	Date when OrgUnit expires
EndDate	SCD Type	1
FunctionCode	Description	Digits 1-2 of the OrgUnit
FunctionCode	Display Name	FunctionCode
FunctionCode	ETL Rules	Digits 1-2 of the OrgUnit
FunctionCode	Example Values	11,10, 26
FunctionCode	MS_Description	Digits 1-2 of the OrgUnit. The Function Code of the Org Unit. The Function Code is defined in the table F002.
FunctionCode	SCD Type	1
FunctionCode	Source Field Name	ORG_UNIT
FunctionCode	Source System	DWStaging
FunctionCode	Source Table	COA_ORG_UNIT_FILE
FunctionDescription	Description	The description of the Function as per Accounting Manual
FunctionDescription	Display Name	FunctionDescription
FunctionDescription	ETL Rules	The description from the UTL_CODE_TABLE - Table Name F002 where code = FunctionCode
FunctionDescription	Example Values	Academc Affairs, Public Service
FunctionDescription	MS_Description	The description of the Function as per Accounting Manual. The Function Code and its definition are defined in the table F002. Example 15=Student Support, 21=Direct Instruction.
FunctionDescription	SCD Type	1
FunctionDescription	Source Field Name	DESCRIPTION
FunctionDescription	Source System	DWStaging
FunctionDescription	Source Table	UTL_CODE_TABLE_FILE
Fund	Description	The description or name of the FundCode
Fund	Display Name	Fund
Fund	ETL Rules	The description from the UTL_CODE_TABLE - Table Name F001 where code = FundCode
Fund	Example Values	CURRENT FUNDS - UNRESTRICTED
Fund	MS_Description	The description or name of the FundCode. The description of the fund the Org Unit is associated with based on the first digit. Example: Current Funds-Unrestricted.
Fund	SCD Type	1
Fund	Source Field Name	DESCRIPTION
Fund	Source System	DWStaging
Fund	Source Table	UTL_CODE_TABLE_FILE
FundCode	Description	The 1st digit of the Org Unit
FundCode	Display Name	Fund Code
FundCode	ETL Rules	The first digit of the Org Unit
FundCode	Example Values	1, 2, 4
FundCode	MS_Description	The 1st digit of the Org Unit. This also indicates the fund the Org Unit is associated with.
FundCode	SCD Type	1
FundCode	Source Field Name	ORG_UNIT
FundCode	Source System	DWStaging
FundCode	Source Table	COA_ORG_UNIT_FILE
Location	Description	The description of the Location Code
Location	Display Name	Location
Location	ETL Rules	Description from FIG-TABLES - Table Name FIGADM6 where CODE = LocationCode
Location	Example Values	President, President Grants
Location	MS_Description	The description of the Location Code. The Location Code and its defintion are defined in the Location Table in the Infrequently Used Table Menu.
Location	SCD Type	1
Location	Source System	DWStaging
Location	Source Table	FIG_TABLES
LocationCode	Description	Digits 15 and 16 of Org Unit
LocationCode	Display Name	LocationCode
LocationCode	ETL Rules	Digits 15 and 16 of Org Unit
LocationCode	Example Values	00, 01
LocationCode	MS_Description	Digits 15 and 16 of Org Unit or the last two digits of the OrgUnit Number. The Location Code is defined in the Location Table in the Infrequently Used Table Menu.
LocationCode	SCD Type	1
LocationCode	Source Field Name	ORG_UNIT
LocationCode	Source System	DWStaging
LocationCode	Source Table	COA_ORG_UNIT_FILE
OrgUnit	Description	OrgUnit Number as assigned in Integrow, including the -
OrgUnit	Display Name	OrgUnit
OrgUnit	ETL Rules	Include '-'
OrgUnit	Example Values	26311200-263112-10
OrgUnit	MS_Description	OrgUnit Number as assigned in Integrow, including the "-" to separate the State Org, Qual 1 and location.
OrgUnit	SCD Type	1
OrgUnit	Source Field Name	ORG_UNIT
OrgUnit	Source System	DWStaging
OrgUnit	Source Table	COA_ORG_UNIT_FILE
OrgUnitAK	Description	OrgUnit Number as assigned in Integrow
OrgUnitAK	Display Name	OrgUnitAK
OrgUnitAK	ETL Rules	Pull all ORG-UNITs from COA_ORG_UNIT_FILE where ORG_IND = 'Y'
OrgUnitAK	Example Values	1400010014000140
OrgUnitAK	MS_Description	OrgUnit Number as assigned in Integrow. This is the 16 digit OrgUnit number.
OrgUnitAK	SCD Type	key
OrgUnitAK	Source Field Name	ORG_UNIT
OrgUnitAK	Source System	DWStaging
OrgUnitAK	Source Table	COA_ORG_UNIT_FILE
OrgUnitGrouping	Description	Grouping method of Org Units
OrgUnitGrouping	Display Name	OrgUnitGrouping
OrgUnitGrouping	ETL Rules	Extract from BANK-CODE on COA_ORG_UNITS_FILE
OrgUnitGrouping	Example Values	1234
OrgUnitGrouping	MS_Description	Grouping method of Org Units as defined in the Maintain COA Org Unit screen. The field on this screen is called Special Field. This field is used as a filter in the Data Warehouse with a label of Org Unit Groups.
OrgUnitGrouping	SCD Type	1
OrgUnitGrouping	Source Field Name	BANK_CODE
OrgUnitGrouping	Source System	DWStaging
OrgUnitGrouping	Source Table	COA_ORG_UNIT_FILE
OrgUnitName	Description	Name of the Org Unit
OrgUnitName	Display Name	OrgUnitName
OrgUnitName	ETL Rules	Using the Description of the ORG_UNIT. Convert to Upper/Lower Case
OrgUnitName	Example Values	GENERAL OPERATING
OrgUnitName	MS_Description	Org Unit description.
OrgUnitName	SCD Type	1
OrgUnitName	Source Field Name	DESCRIPTION
OrgUnitName	Source System	DWStaging
OrgUnitName	Source Table	COA_ORG_UNIT_FILE
OrgUnitSK	Description	Primary Key
OrgUnitSK	Display Name	OrgUnitSK
OrgUnitSK	ETL Rules	Assigned by the ETL process.
OrgUnitSK	Example Values	1, 2, 3?
OrgUnitSK	MS_Description	Primary Key the table's
OrgUnitSK	SCD Type	key
OrgUnitSK	Source System	Derived
OrgUnitStatus	Description	The Status of the Org Unit
OrgUnitStatus	Display Name	OrgUnitStatus
OrgUnitStatus	ETL Rules	Code in ETL based on Active_Ind
OrgUnitStatus	Example Values	Active, InActive or Summary
OrgUnitStatus	MS_Description	The Status of the Org Unit. Example: Active, Inactive, Summary.
OrgUnitStatus	SCD Type	1
OrgUnitStatus	Source System	Derived
OrgUnitStatusCode	Description	The Status Description of the Org Unit
OrgUnitStatusCode	Display Name	OrgUnitStatusCode
OrgUnitStatusCode	ETL Rules	Extracted from Active_ind
OrgUnitStatusCode	Example Values	A, I or S
OrgUnitStatusCode	MS_Description	The Status Description of the Org Unit. Example: A, I, S.
OrgUnitStatusCode	SCD Type	1
OrgUnitStatusCode	Source Field Name	ACTIVE_IND
OrgUnitStatusCode	Source System	DWStaging
OrgUnitStatusCode	Source Table	COA_ORG_UNIT_FILE
PrincipalAdmin	Description	The name of the Principal Administrator
PrincipalAdmin	Display Name	PrincipalAdmin
PrincipalAdmin	ETL Rules	The name associated with thePrincipal Administrator from SECURITY_USER_VIEW
PrincipalAdmin	Example Values	Sophia Cowan
PrincipalAdmin	MS_Description	The name of the Principal Administrator as defined in the Maintain COA Org Unit screen.
PrincipalAdmin	SCD Type	1
PrincipalAdmin	Source System	DWStaging
PrincipalAdmin	Source Table	SECURITY_USER_VIEW
PrincipalAdminId	Description	The ID of the Principal Administrator
PrincipalAdminId	Display Name	PrincipalAdminId
PrincipalAdminId	Example Values	Grants
PrincipalAdminId	MS_Description	The ID of the Principal Administrator as defined in the Maintain COA Org Unit screen.
PrincipalAdminId	SCD Type	1
PrincipalAdminId	Source Field Name	PRINCIPAL_ADMIN
PrincipalAdminId	Source System	DWStaging
PrincipalAdminId	Source Table	COA_ORG_UNIT_FILE
ProjectNumber	Description	The project number from the OrgUnit if used for tracking
ProjectNumber	Display Name	ProjectNumber
ProjectNumber	Example Values	1237458
ProjectNumber	MS_Description	The project number from the OrgUnit if used for tracking as defined in the Maintain COA Org Unit screen.
ProjectNumber	SCD Type	1
ProjectNumber	Source Field Name	PROJECT_NO
ProjectNumber	Source System	DWStaging
ProjectNumber	Source Table	COA_ORG_UNIT_FILE
Qual1	Description	Digits 9 - 14 of Org Unit
Qual1	Display Name	Qual1
Qual1	ETL Rules	Digits 9 - 14 of Org Unit
Qual1	Example Values	144444, 263112
Qual1	MS_Description	Digits 9 - 14 of Org Unit or Qual 1.
Qual1	SCD Type	1
Qual1	Source Field Name	ORG_UNIT
Qual1	Source System	DWStaging
Qual1	Source Table	COA_ORG_UNIT_FILE
ReportDistribution	Description	Description of Gropuing method for OrgUnits
ReportDistribution	Display Name	ReportDistribution
ReportDistribution	ETL Rules	Description from FIG-TABLES - Table Name FIGADM13
ReportDistribution	MS_Description	Description of Gropuing method for OrgUnits as defined in the Maintain COA Org Unit screen. The values and defintions on this table are defined in the Distribution Table.
ReportDistribution	Source System	DWStaging
ReportDistribution	Source Table	FIG_TABLES
ReportDistributionCode	Description	Grouping method of Org Units
ReportDistributionCode	Display Name	ReportDistributionCode
ReportDistributionCode	Example Values	3100
ReportDistributionCode	MS_Description	Grouping method of Org Units as defined in the Maintain COA Org Unit screen. The values and defintions on this table are defined in the Distribution Table.
ReportDistributionCode	SCD Type	1
ReportDistributionCode	Source Field Name	DISTRIBUTION
ReportDistributionCode	Source System	DWStaging
ReportDistributionCode	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?
RowStartDate	SCD Type	n/a
RowStartDate	Source System	Derived
StartDate	Description	Date since OrgUnit is Active
StartDate	Display Name	StartDate
StartDate	Example Values	1/2/2012
StartDate	MS_Description	Date since OrgUnit is Active
StateOrgUnit	MS_Description	The first 8 characters of the Org Unit Code as prescribed by the Accounting Manual.
SubFunction	Description	The description of the Sub-Function as per Accounting Manual
SubFunction	Display Name	SubFunction
SubFunction	ETL Rules	The description from the UTL_CODE_TABLE - Table Name F003 where code = SubFunctionCode
SubFunction	Example Values	Distance Learning
SubFunction	MS_Description	The description of the Sub-Function as per Accounting Manual. The Subfunction code and its definition are defined in the table F003.
SubFunction	SCD Type	1
SubFunction	Source Field Name	DESCRIPTION
SubFunction	Source System	DWStaging
SubFunction	Source Table	UTL_CODE_TABLE_FILE
SubFunctionCode	Description	Digits 1-3 of OrgUnit
SubFunctionCode	Display Name	SubFunctionCode
SubFunctionCode	ETL Rules	Digits 1-3 of OrgUnit
SubFunctionCode	Example Values	111141
SubFunctionCode	MS_Description	Digits 1-3 of OrgUnit or subfunction. The Subfunction Code is defined in the table F003.
SubFunctionCode	SCD Type	1
SubFunctionCode	Source Field Name	ORG_UNIT
SubFunctionCode	Source System	DWStaging
SubFunctionCode	Source Table	COA_ORG_UNIT_FILE
UserGroup	Description	The name of the User Group
UserGroup	Display Name	UserGroup
UserGroup	ETL Rules	The name in the USER_GROUP_PROFILE_A file for the associated UserGroupId. Convert ot Upper/Lower Case
UserGroup	Example Values	HetGroup Users
UserGroup	MS_Description	The name of the User Group as defined in User Group Profile.
UserGroup	SCD Type	1
UserGroup	Source System	DWStaging
UserGroup	Source Table	USER_GROUP_PROFILE
UserGroupId	Description	The ID of the User Group
UserGroupId	Display Name	UserGroupId
UserGroupId	Example Values	FCCSC
UserGroupId	MS_Description	The ID of the User Group as defined in the Maintain COA Org Unit screen.
UserGroupId	SCD Type	1
UserGroupId	Source Field Name	USER_GROUP_ID
UserGroupId	Source System	DWStaging
UserGroupId	Source Table	COA_ORG_UNIT_FILE

Object

Property

Value

/****** Object: Table [dbo].[DimOrgUnit] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimOrgUnit](
    [OrgUnitSK] [int] IDENTITY(1,1) NOT NULL,
    [OrgUnitAK] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnit] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitStatusCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitStatus] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FundCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Fund] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FunctionDescription] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SubFunctionCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SubFunction] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StateOrgUnit] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [LocationCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Location] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Qual1] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ControlOrgUnit] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ControlOrgUnitName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BudgetManagerId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [BudgetManager] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [UserGroupId] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [UserGroup] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrincipalAdminId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PrincipalAdmin] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProjectNumber] [int] NOT NULL,
    [ReportDistributionCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ReportDistribution] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [OrgUnitGrouping] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StartDate] [datetime] NOT NULL,
    [EndDate] [datetime] NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
CONSTRAINT [PK_dbo.DimOrgUnit] PRIMARY KEY CLUSTERED
(
    [OrgUnitSK] 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'OrgUnit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Information regarding the Org Units, one row per Org Unit.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit'

EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Information regarding the Org Units' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit'

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The name of the Budget Manager' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManager'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The name associated with the Budget Manager from SECURITY_USER_VIEW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManager'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Brisset Jaramillo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManager'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the Budget Manager as defined in Security.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManager'

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'SECURITY_USER_VIEW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManager'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The ID of the Budget Manager' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManagerId'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'BUDGET' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManagerId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the Budget Manager as defined in Maintain COA Org Unit screen.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManagerId'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'BudgetManagerId'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The controlling Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnit'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'CONTROL_ORG_UNIT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnit'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1400010014000140' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The control 16 digit Org Unit. Multiple Org Units can use on 16 digit Control Org Unit to record assets, liabilities and fund balance.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnit'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnit'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the Control Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnitName'

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnitName'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'GENERAL OPERATING' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnitName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Control Org Unit.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnitName'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ControlOrgUnitName'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Date when OrgUnit expires' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'EndDate'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2/6/2098' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'EndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date when OrgUnit expires' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'EndDate'

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Digits 1-2 of the OrgUnit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionCode'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Digits 1-2 of the OrgUnit. The Function Code of the Org Unit. The Function Code is defined in the table F002.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionCode'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the Function as per Accounting Manual' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionDescription'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description from the UTL_CODE_TABLE - Table Name F002 where code = FunctionCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionDescription'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Academc Affairs, Public Service' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionDescription'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Function as per Accounting Manual. The Function Code and its definition are defined in the table F002. Example 15=Student Support, 21=Direct Instruction.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionDescription'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FunctionDescription'

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description from the UTL_CODE_TABLE - Table Name F001 where code = FundCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Fund'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'CURRENT FUNDS - UNRESTRICTED' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Fund'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description or name of the FundCode. The description of the fund the Org Unit is associated with based on the first digit. Example: Current Funds-Unrestricted.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Fund'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Fund'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The 1st digit of the Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FundCode'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Fund Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FundCode'

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The first digit of the Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FundCode'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The 1st digit of the Org Unit. This also indicates the fund the Org Unit is associated with.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FundCode'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'FundCode'

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Description from FIG-TABLES - Table Name FIGADM6 where CODE = LocationCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Location'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'President, President Grants' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Location'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Location Code. The Location Code and its defintion are defined in the Location Table in the Infrequently Used Table Menu.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Location'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Digits 15 and 16 of Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'LocationCode'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Digits 15 and 16 of Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'LocationCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'00, 01' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'LocationCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Digits 15 and 16 of Org Unit or the last two digits of the OrgUnit Number. The Location Code is defined in the Location Table in the Infrequently Used Table Menu.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'LocationCode'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'LocationCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'OrgUnit Number as assigned in Integrow, including the - ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnit'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Include ''-'' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnit'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'26311200-263112-10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnit'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OrgUnit Number as assigned in Integrow, including the "-" to separate the State Org, Qual 1 and location. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnit'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnit'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'OrgUnit Number as assigned in Integrow' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitAK'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Pull all ORG-UNITs from COA_ORG_UNIT_FILE where ORG_IND = ''Y''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitAK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1400010014000140' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OrgUnit Number as assigned in Integrow. This is the 16 digit OrgUnit number.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitAK'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitAK'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Grouping method of Org Units' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitGrouping'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extract from BANK-CODE on COA_ORG_UNITS_FILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitGrouping'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1234' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitGrouping'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Grouping method of Org Units as defined in the Maintain COA Org Unit screen. The field on this screen is called Special Field. This field is used as a filter in the Data Warehouse with a label of Org Unit Groups. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitGrouping'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitGrouping'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Name of the Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitName'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Using the Description of the ORG_UNIT. Convert to Upper/Lower Case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitName'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'GENERAL OPERATING' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitName'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Org Unit description.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitName'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitName'

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

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Assigned by the ETL process.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitSK'

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key the table''s' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitSK'

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

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Status of the Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatus'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Code in ETL based on Active_Ind' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatus'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Active, InActive or Summary' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Status of the Org Unit. Example: Active, Inactive, Summary.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatus'

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

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The Status Description of the Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatusCode'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Extracted from Active_ind' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'A, I or S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatusCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The Status Description of the Org Unit. Example: A, I, S.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatusCode'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'OrgUnitStatusCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The name of the Principal Administrator' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdmin'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The name associated with thePrincipal Administrator from SECURITY_USER_VIEW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdmin'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Sophia Cowan' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdmin'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the Principal Administrator as defined in the Maintain COA Org Unit screen.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdmin'

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'SECURITY_USER_VIEW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdmin'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The ID of the Principal Administrator' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdminId'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Grants' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdminId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the Principal Administrator as defined in the Maintain COA Org Unit screen.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdminId'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'PrincipalAdminId'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The project number from the OrgUnit if used for tracking' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ProjectNumber'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1237458' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ProjectNumber'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The project number from the OrgUnit if used for tracking as defined in the Maintain COA Org Unit screen.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ProjectNumber'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ProjectNumber'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Digits 9 - 14 of Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Qual1'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Digits 9 - 14 of Org Unit' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Qual1'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'144444, 263112' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Qual1'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Digits 9 - 14 of Org Unit or Qual 1. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Qual1'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'Qual1'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Description of Gropuing method for OrgUnits' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistribution'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'Description from FIG-TABLES - Table Name FIGADM13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistribution'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Description of Gropuing method for OrgUnits as defined in the Maintain COA Org Unit screen. The values and defintions on this table are defined in the Distribution Table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistribution'

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

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

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Grouping method of Org Units' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistributionCode'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'3100' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistributionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Grouping method of Org Units as defined in the Maintain COA Org Unit screen. The values and defintions on this table are defined in the Distribution Table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistributionCode'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'ReportDistributionCode'

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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Date since OrgUnit is Active' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'StartDate'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/2/2012' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'StartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date since OrgUnit is Active' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'StartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The first 8 characters of the Org Unit Code as prescribed by the Accounting Manual.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'StateOrgUnit'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The description of the Sub-Function as per Accounting Manual' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunction'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The description from the UTL_CODE_TABLE - Table Name F003 where code = SubFunctionCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunction'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Distance Learning' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunction'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The description of the Sub-Function as per Accounting Manual. The Subfunction code and its definition are defined in the table F003.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunction'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunction'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'111141' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunctionCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Digits 1-3 of OrgUnit or subfunction. The Subfunction Code is defined in the table F003.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunctionCode'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'SubFunctionCode'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The name of the User Group ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroup'

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

EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The name in the USER_GROUP_PROFILE_A file for the associated UserGroupId. Convert ot Upper/Lower Case' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroup'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'HetGroup Users' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroup'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The name of the User Group as defined in User Group Profile.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroup'

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

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

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'USER_GROUP_PROFILE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroup'

EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'The ID of the User Group' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroupId'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'FCCSC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroupId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The ID of the User Group as defined in the Maintain COA Org Unit screen.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroupId'

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

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

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

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'DimOrgUnit', @level2type=N'COLUMN',@level2name=N'UserGroupId'

BudgetManager

BudgetManagerId

ControlOrgUnit

ControlOrgUnitName

EndDate

FunctionCode

FunctionDescription

Fund

FundCode

Location

LocationCode

OrgUnit

OrgUnitAK

OrgUnitGrouping

OrgUnitName

OrgUnitSK

OrgUnitStatus

OrgUnitStatusCode

PrincipalAdmin

PrincipalAdminId

ProjectNumber

Qual1

ReportDistribution

ReportDistributionCode

RowIsCurrent

RowStartDate

StartDate

StateOrgUnit

SubFunction

SubFunctionCode

UserGroup

UserGroupId

Budget

BUDGET

21230200-200202-20

Sonography Program - Eissey

2002-10-02T00:00:00-04:00

21

Direct Instruction

Current Funds - Restricted

2

Vice Pres/Provost Main Campus

20

21230200-200202-20

2123020020020220

BARN

Sonography Program - Eissey

14182

Active

A

Grants

GRANTS

0

200202

N/A

45

Y

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

2000-06-01T00:00:00-04:00

21230200

N/A

212

Budget

FCCSC

Budget

BUDGET

58125100-125088-90

Pbcc-Leadership Develop Schp

2016-06-30T00:00:00-04:00

58

Other Scholarships Accounts

Scholarship Funds

5

N/A

90

58125100-125088-90

5812510012508890

N/A

Pbcc-Leadership Develop Schp

15330

Active

A

Grants

GRANTS

0

125088

Distribution 07

07

Y

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

2003-07-01T00:00:00-04:00

58125100

N/A

581

Budget

FCCSC

Budget

BUDGET

58125100-581024-90

Fed Sds Nursing

2008-10-30T00:00:00-04:00

58

Other Scholarships Accounts

Scholarship Funds

5

N/A

90

58125100-581024-90

5812510058102490

N/A

Fed Sds Nursing

15457

Active

A

Grants

GRANTS

0

581024

Distribution 07

07

Y

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

2007-06-11T00:00:00-04:00

58125100

N/A

581

Budget

FCCSC

Budget

BUDGET

58215100-152015-90

Pd Little People Of Americainc

2098-06-30T00:00:00-04:00

58

Other Scholarships Accounts

Scholarship Funds

5

N/A

90

58215100-152015-90

5821510015201590

N/A

Pd Little People Of Americainc

16806

Active

A

Grants

GRANTS

0

152015

Distribution 07

07

Y

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

2016-07-01T00:00:00-04:00

58215100

N/A

582

Budget

FCCSC

Budget

BUDGET

77310001- -00

08/9 Gen Ren/Rem

2013-11-30T00:00:00-05:00

77

Projects Financed From Peco

Unexpnd Plant & Renew/Replace

7

President

10

77315018-701311-10

7731501870131110

BARN

08/9E

18876

Active

A

Grants

GRANTS

0

701311

N/A

24

Y

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

2008-10-03T00:00:00-04:00

77315018

N/A

773

Budget

FCCSC

Budget

BUDGET

68126000-812116-90

United States Sugar Corp

2002-11-14T00:00:00-05:00

68

Organizational Accounts

Agency Funds

6

N/A

90

68126000-812116-90

6812600081211690

BARN

United States Sugar Corp

17188

Active

A

Grants

GRANTS

0

812116

Distribution 07

07

Y

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

1990-07-01T00:00:00-04:00

68126000

N/A

681

Budget

FCCSC

Budget

BUDGET

71210001- -00

98/99 Local Funds

2006-10-17T00:00:00-04:00

71

Projects Financed From Local S

Unexpnd Plant & Renew/Replace

7

President

10

71210003-7PENNY-10

712100037PENNY10

BARN

Training Center - P.Mcisaac

17919

Active

A

Grants

GRANTS

3

7PENNY

N/A

51

Y

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

2002-07-01T00:00:00-04:00

71210003

N/A

712

Budget

FCCSC

Budget

BUDGET

10000000- -00

Unrestr Current Fund Control

2098-06-30T00:00:00-04:00

14

Academic Support

Current Funds - Unrestricted

1

N/A

93

14801000-480125-93

1480100048012593

BARN

S&Pd - Honors

13227

Active

A

Grants

GRANTS

0

480125

N/A

22

Y

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

2004-06-10T00:00:00-04:00

14801000

Academic Professional Pers Dev

148

Budget

FCCSC

Budget

BUDGET

68121000-681232-20

Psi Beta Fundraising

2199-06-30T00:00:00-04:00

68

Organizational Accounts

Agency Funds

6

Vice Pres/Provost Main Campus

20

68121000-681232-20

6812100068123220

N/A

Psi Beta Fundraising

16974

Active

A

Grants

GRANTS

0

681232

N/A

45

Y

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

2009-07-01T00:00:00-04:00

68121000

N/A

681

Budget

FCCSC

Budget

BUDGET

71210001- -00

98/99 Local Funds

2016-06-30T00:00:00-04:00

71

Projects Financed From Local S

Unexpnd Plant & Renew/Replace

7

Vice Pres Of Academic Affairs

40

71210011-7ROADW-40

712100117ROADW40

BARN

10/11 Fd1 Trsf Rdwys West Camp

18042

Active

A

Grants

GRANTS

0

7ROADW

N/A

24

Y

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

2012-06-30T00:00:00-04:00

71210011

N/A

712

Budget

FCCSC