EnterpriseDW
 dbo.DimFeeType (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  EnterpriseDW   Tables   dbo.DimFeeType
  Properties
Property Value
Name DimFeeType
Schema dbo
Row Count 704
Data Size 80 KB
Index Size 24 KB
Create Date 1/28/2014 9:47 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
FeeCategory
varchar(30)
False
False
False
 
A descriptive name for the category of the fee, which include standard fees, class fees and term fees.
FeeCategoryCode
varchar(3)
False
False
False
 
Code for the category of the fee, which include standard fees, class fees and term fees.
FeeGroup
varchar(30)
False
False
False
 
A descriptive name for the category of the fee, which include standard fees, class fees and term fees.
FeeGroupCode
varchar(3)
False
False
False
 
Code for the institutional grouping of like fees, which include standard fees, class fees and term fees.
FeeType
varchar(30)
False
False
False
 
A descriptive name for the type of fee charged to a student for attending a specific class, for attending the institution or for
FeeTypeAK
varchar(4)
False
False
False
 
Business key.
FeeTypeCode
varchar(4)
False
False
False
 
Code for the type of fee charged to a student for attending a specific class, for attending the institution or for a service pro
In Primary Key
FeeTypeSK
int(10, 0)
False
False
False
(1 / 1)
Surrogate primary key
RowEndDate
datetime(23, 3)
True
False
False
 
When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent
nchar(1)
False
False
False
 
Is this the current row for this member (Y/N)?
RowStartDate
datetime(23, 3)
False
False
False
 
When did this row become valid for this member?
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
FeeTypeSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimFeeType depends on)
Name Type
Table
  Child Dependencies (objects that depend on dbo.DimFeeType)
Name Type
TABLE
  Extended Properties
Object Property Value
DimFeeType
Display Name
FeeType
DimFeeType
Table Description
Fees charged to students for classes, for class required additional charges and for fees related to registration.
DimFeeType
Table Type
Dimension
FeeCategory
Display Name
Fee Category
FeeCategory
ETL Rules
The value will be deterined based on the values in FeeCategoryCode as follows: S = Standard, C = Class, T = Term and all others
FeeCategory
Example Values
Standard, Class, Term
FeeCategory
MS_Description
A descriptive name for the category of the fee, which include standard fees, class fees and term fees.
FeeCategory
SCD Type
1
FeeCategory
Source Field Name
FeeCategory
Source System
Derived
FeeCategory
Source Table
FeeCategoryCode
Display Name
Fee Category Code
FeeCategoryCode
ETL Rules
The value will exist in the FIELD_VALUE for the row on the UTL_CODE_TABLE_GENEIC where the GENERIC_COUNT = 1 related to the same
FeeCategoryCode
Example Values
S, C, T
FeeCategoryCode
MS_Description
Code for the category of the fee, which include standard fees, class fees and term fees.
FeeCategoryCode
SCD Type
1
FeeCategoryCode
Source Field Name
FIELD_VALUE
FeeCategoryCode
Source System
DWStaging
FeeCategoryCode
Source Table
UTL_CODE_TABLE_GENERIC
FeeGroup
Display Name
Fee Group
FeeGroup
ETL Rules
The value is the DESCRIPTION from the UTL_CODE_TALE for the CODE equal the FeeGroupCode and the TABLE_NAME equal to 'FEE-GROUP'
FeeGroup
Example Values
Adult Ed IN State, Distance Learning, Lab Fees, Testing Fees
FeeGroup
MS_Description
A descriptive name for the category of the fee, which include standard fees, class fees and term fees.
FeeGroup
SCD Type
1
FeeGroup
Source Field Name
DESCRIPTION
FeeGroup
Source System
DWStaging
FeeGroup
Source Table
UTL_CODE_TABLE
FeeGroupCode
Display Name
Fee Group Code
FeeGroupCode
ETL Rules
If the FeeCategoryCode is equal to 'C', then retreive the FEE_GRP code from the ST_SPCL_FEE_A table where the CRS_FEE_IND = '
FeeGroupCode
Example Values
AI, DL, LB, TE
FeeGroupCode
MS_Description
Code for the institutional grouping of like fees, which include standard fees, class fees and term fees.
FeeGroupCode
SCD Type
1
FeeGroupCode
Source Field Name
FEE_GRP
FeeGroupCode
Source System
DWStaging
FeeGroupCode
Source Table
ST_SPCL_FEE_A
FeeType
Display Name
Fee Type
FeeType
ETL Rules
Convert to upper/lower case.
FeeType
Example Values
Lab Fee 12.00, Late Fee, Matriculation, Tuition
FeeType
MS_Description
A descriptive name for the type of fee charged to a student for attending a specific class, for attending the institution or for
FeeType
SCD Type
1
FeeType
Source Field Name
DESCRIPTION
FeeType
Source System
DWStaging
FeeType
Source Table
UTL_CODE_TABLE
FeeTypeAK
Display Name
FeeTypeAK
FeeTypeAK
Example Values
CAPI, D040, L012, TUIT
FeeTypeAK
MS_Description
Business key.
FeeTypeAK
SCD Type
1
FeeTypeAK
Source Field Name
CODE
FeeTypeAK
Source System
DWStaging
FeeTypeAK
Source Table
UTL_CODE_TABLE
FeeTypeCode
Display Name
Fee Type Code
FeeTypeCode
ETL Rules
FeeTypeCode
Example Values
CAPI, D040, L012, TUIT
FeeTypeCode
MS_Description
Code for the type of fee charged to a student for attending a specific class, for attending the institution or for a service pro
FeeTypeCode
SCD Type
1
FeeTypeCode
Source Field Name
CODE
FeeTypeCode
Source System
DWStaging
FeeTypeCode
Source Table
UTL_CODE_TABLE
FeeTypeSK
Display Name
FeeTypeSK
FeeTypeSK
Example Values
1, 2, 3?
FeeTypeSK
MS_Description
Surrogate primary key
FeeTypeSK
SCD Type
key
FeeTypeSK
Source System
Derived
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
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
Display Folder
Exclude from cube
RowStartDate
Display Name
Row Start Date
RowStartDate
ETL Rules
Standard SCD-2
RowStartDate
Example Values
1/24/2011
RowStartDate
MS_Description
When did this row become valid for this member?
RowStartDate
SCD Type
n/a
RowStartDate
Source System
Derived
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimFeeType] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimFeeType](
    [FeeTypeSK] [int] IDENTITY(1,1) NOT NULL,
    [FeeTypeAK] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FeeTypeCode] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FeeType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FeeCategoryCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FeeCategory] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FeeGroupCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FeeGroup] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
 CONSTRAINT [PK_dbo.DimFeeType] PRIMARY KEY CLUSTERED 
(
    [FeeTypeSK] 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'FeeType' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType'


EXEC sys.sp_addextendedproperty @name=N'Table Description', @value=N'Fees charged to students for classes, for class required additional charges and for fees related to registration.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Fee Category ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategory'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The value will be deterined based on the values in FeeCategoryCode as follows: S = Standard, C = Class, T = Term and all others ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategory'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Standard, Class, Term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategory'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the category of the fee, which include standard fees, class fees and term fees.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategory'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Fee Category Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The value will exist in the FIELD_VALUE for the row on the UTL_CODE_TABLE_GENEIC where the GENERIC_COUNT = 1 related to the same' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'S, C, T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the category of the fee, which include standard fees, class fees and term fees.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategoryCode'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_GENERIC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeCategoryCode'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Fee Group ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroup'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'The value is the DESCRIPTION from the UTL_CODE_TALE for the CODE equal the FeeGroupCode and the TABLE_NAME equal to ''FEE-GROUP''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroup'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Adult Ed IN State, Distance Learning, Lab Fees, Testing Fees' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroup'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the category of the fee, which include standard fees, class fees and term fees.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroup'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroup'


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Fee Group Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroupCode'


EXEC sys.sp_addextendedproperty @name=N'ETL Rules', @value=N'If the FeeCategoryCode is equal to ''C'', then retreive the FEE_GRP code from the ST_SPCL_FEE_A table where the CRS_FEE_IND = ''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroupCode'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'AI, DL, LB, TE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroupCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the institutional grouping of like fees, which include standard fees, class fees and term fees.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroupCode'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_SPCL_FEE_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeGroupCode'


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Lab Fee 12.00, Late Fee, Matriculation, Tuition' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeType'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name for the type of fee charged to a student for attending a specific class, for attending the institution or for' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeType'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeType'


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'CAPI, D040, L012, TUIT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeAK'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeAK'


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'CAPI, D040, L012, TUIT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code for the type of fee charged to a student for attending a specific class, for attending the institution or for a service pro' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeCode'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeCode'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate primary key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @level2type=N'COLUMN',@level2name=N'FeeTypeSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @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'DimFeeType', @level2type=N'COLUMN',@level2name=N'RowStartDate'
  Sample Data
FeeCategory FeeCategoryCode FeeGroup FeeGroupCode FeeType FeeTypeAK FeeTypeCode FeeTypeSK RowEndDate RowIsCurrent RowStartDate
Class C Contract Student Fees CF Special Fee Cdl 1722.50 S454 S454 947 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab/Materials LM Special Fee 78.94 S379 S379 887 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab/Materials LM Special Fee 174.76 S433 S433 926 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab/Materials LM Special Fee 136.00 S206 S206 716 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab SF Pilot Special Fee S346 S346 850 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab SF Special Fee 35.94 S136 S136 656 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab/Materials LM Special Fee 58.93 S277 S277 781 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Study Abroad SA Study Abroad Fee 1630.00 SA1 SA1 397 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Cce Fee CC Cce Special Fee 180.00 C036 C036 522 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Class C Special Fees - Lab/Materials LM Special Fee 79.92 S480 S480 298 9999-12-31T23:59:00-05:00 Y 2017-03-09T12:03:00-05:00
Powered by BI Documenter