EnterpriseDW
 dbo.DimFTEClassification (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.DimFTEClassification
  Properties
Property Value
Name DimFTEClassification
Schema dbo
Row Count 5
Data Size 8 KB
Index Size 8 KB
Create Date 8/23/2012 3:40 PM
Description The Full Time Equivalent Classifitions used for grouping when reporting FTE for the institution. There is one row per classifitation.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
FTEClassification
varchar(30)
False
False
False
 
Descriptive name for the FTE classification category.
FTEClassificationAK
varchar(3)
False
False
False
 
Code identifier assigned to the FTE classifications used by the Data Warehouse as the Business Key.
In Primary Key
FTEClassificationSK
int(10, 0)
False
False
False
(1 / 1)
Unique identifier for the FTE classification categories in the data warehouse, in numeric format.
RowEndDate
datetime(23, 3)
True
False
False
 
The effective end date-time for the current FTE Classification row.
RowIsCurrent
nchar(1)
False
False
False
 
Indicator if the row is the most current representation of the FTE classification. The valid values are 'N' or 'Y'.
RowStartDate
datetime(23, 3)
False
False
False
 
The effective start date-time for the current FTE Classification row.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
FTEClassificationSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimFTEClassification depends on)
Name Type
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.DimFTEClassification)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
DimFTEClassification
MS_Description
The Full Time Equivalent Classifitions used for grouping when reporting FTE for the institution. There is one row per classifitation.
FTEClassification
MS_Description
Descriptive name for the FTE classification category.
FTEClassificationAK
MS_Description
Code identifier assigned to the FTE classifications used by the Data Warehouse as the Business Key.
FTEClassificationSK
MS_Description
Unique identifier for the FTE classification categories in the data warehouse, in numeric format.
RowEndDate
MS_Description
The effective end date-time for the current FTE Classification row.
RowIsCurrent
MS_Description
Indicator if the row is the most current representation of the FTE classification. The valid values are 'N' or 'Y'.
RowStartDate
MS_Description
The effective start date-time for the current FTE Classification row.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimFTEClassification] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimFTEClassification](
    [FTEClassificationSK] [int] IDENTITY(1,1) NOT NULL,
    [FTEClassificationAK] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FTEClassification] [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_DimFTEClassification] PRIMARY KEY CLUSTERED 
(
    [FTEClassificationSK] 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'MS_Description', @value=N'The Full Time Equivalent Classifitions used for grouping when reporting FTE for the institution. There is one row per classifitation.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the FTE classification category.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification', @level2type=N'COLUMN',@level2name=N'FTEClassification'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code identifier assigned to the FTE classifications used by the Data Warehouse as the Business Key. ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification', @level2type=N'COLUMN',@level2name=N'FTEClassificationAK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique identifier for the FTE classification categories in the data warehouse, in numeric format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification', @level2type=N'COLUMN',@level2name=N'FTEClassificationSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective end date-time for the current FTE Classification row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator if the row is the most current representation of the FTE classification. The valid values are ''N'' or ''Y''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective start date-time for the current FTE Classification row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimFTEClassification', @level2type=N'COLUMN',@level2name=N'RowStartDate'
  Sample Data
FTEClassification FTEClassificationAK FTEClassificationSK RowIsCurrent RowStartDate
Bachelors 01 3 Y 2012-08-07T00:00:00-04:00
Non-Credit 04 6 Y 2012-08-07T00:00:00-04:00
Post-Secondary 03 5 Y 2012-08-07T00:00:00-04:00
N/A N/A -1 Y 2012-08-07T00:00:00-04:00
Adult Education 02 4 Y 2012-08-07T00:00:00-04:00
Powered by BI Documenter